SAP J_3RBUY_BOOK_14D Table in S/4 HANA - Stucture for PurBook (ALV)
J_3RBUY_BOOK_14D is a standard SAP Table which is used to store Stucture for PurBook (ALV) data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP J_3RBUY_BOOK_14D table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: J_3RBUY_BOOK_14D
J_3RBUY_BOOK_14D table structure field list
Below is the full J_3RBUY_BOOK_14D field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
BUKRS | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
BELNR_INV | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
XBLNR_INV | Reference Key 1 in VAT Invoice | J_3RF_BK_XBLNR | CHAR | 50(0) | J_3RF_BK_XBLNR | |||||
BLDAT_INV | Document Date in Document | BLDAT | DATS | 8(0) | DATUM | |||||
BUDAT_INV | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
DMBTR_INV | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
DMBTR_WRS_INV | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
WRBTR_INV | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
WRBTR_WRS_INV | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
BKTXT_INV | Document Header Text | BKTXT | CHAR | 25(0) | TEXT25 | |||||
BELNR_PAY | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
XBLNR_PAY | Reference Key 1 in VAT Invoice | J_3RF_BK_XBLNR | CHAR | 50(0) | J_3RF_BK_XBLNR | |||||
BLDAT_PAY | Document Date in Document | BLDAT | DATS | 8(0) | DATUM | |||||
BUDAT_PAY | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
DMBTR_PAY | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
DMBTR_WRS_PAY | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
WRBTR_PAY | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
WRBTR_WRS_PAY | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
BKTXT_PAY | Document Header Text | BKTXT | CHAR | 25(0) | TEXT25 | |||||
BELNR_ORIGPAY | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
GJAHR_ORIGPAY | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
BLDAT_ORIGPAY | Document Date in Document | BLDAT | DATS | 8(0) | DATUM | |||||
BUDAT_ORIGPAY | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
XBLNR_ORIGPAY | Reference Document Number | XBLNR1 | CHAR | 16(0) | XBLNR1 | |||||
BKTXT_ORIGPAY | Document Header Text | BKTXT | CHAR | 25(0) | TEXT25 | |||||
BELNR_TRN | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
GSBER_TRN | Business Area | GSBER | CHAR | 4(0) | Assigned to domain | GSBER | GSB | |||
BLDAT_TRN | Document Date in Document | BLDAT | DATS | 8(0) | DATUM | |||||
BUDAT_TRN | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
MONAT_TRN | Fiscal period | MONAT | NUMC | 2(0) | MONAT | |||||
DMBTR_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
DMBTR_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
WRBTR_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
WRBTR_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
HWBAS_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
HWBAS_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
FWBAS_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
FWBAS_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
HWBAS2_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
HWBAS2_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
FWBAS2_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
FWBAS2_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
HWBAS3_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
HWBAS3_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
FWBAS3_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
FWBAS3_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
HWBAS4_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
HWBAS4_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
FWBAS4_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
FWBAS4_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
HWBAS5_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
HWBAS5_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
FWBAS5_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
FWBAS5_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
BASGRUNO | Group Number for Tax Base Amounts | BASGRUNO | NUMC | 2(0) | NUM2 | |||||
HWSTE_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
HWSTE_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
FWSTE_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
FWSTE_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
HWSTE2_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
HWSTE2_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
FWSTE2_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
FWSTE2_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
HWSTE3_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
HWSTE3_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
FWSTE3_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
FWSTE3_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
HWSTE5_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
HWSTE5_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
FWSTE5_TRN | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
FWSTE5_WRS_TRN | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
STEGRUNO | Group Number for Tax Amounts | STEGRUNO | NUMC | 2(0) | NUM2 | |||||
GJAHR_TEST | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
BUZEI_TEST | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3(0) | BUZEI | BUZ | ||||
XBLNR_TEST | Reference Document Number | XBLNR1 | CHAR | 16(0) | XBLNR1 | |||||
LIFNR_CRED | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
NAME1_CRED | Name 1 | AD_NAME1 | CHAR | 40(0) | TEXT40 | |||||
NAME2_CRED | Name 2 | AD_NAME2 | CHAR | 40(0) | TEXT40 | |||||
NAME3_CRED | Name 3 | AD_NAME3 | CHAR | 40(0) | TEXT40 | |||||
NAME4_CRED | Name 4 | AD_NAME4 | CHAR | 40(0) | TEXT40 | |||||
NAME1_CRED_R | Name 1 | AD_NAME1 | CHAR | 40(0) | TEXT40 | |||||
NAME2_CRED_R | Name 2 | AD_NAME2 | CHAR | 40(0) | TEXT40 | |||||
NAME3_CRED_R | Name 3 | AD_NAME3 | CHAR | 40(0) | TEXT40 | |||||
NAME4_CRED_R | Name 4 | AD_NAME4 | CHAR | 40(0) | TEXT40 | |||||
STCD1_CRED | Tax Number 1 | STCD1 | CHAR | 16(0) | STCD1 | |||||
STCD3_CRED | Tax Number 3 | STCD3 | CHAR | 18(0) | CHAR18 | |||||
FLG_BELNR_TRN | Reversal (Tax Transfer) | J_3RF_BUE_F_D0 | CHAR | 1(0) | KOART | |||||
BKTXT_TRN | Document Header Text | BKTXT | CHAR | 25(0) | TEXT25 | |||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2(0) | Assigned to domain | MWSKZ | ||||
LIGHTS | Icon ID (incl. @) | SCRFICON | CHAR | 4(0) | SCRPICON | |||||
BOX | Flag for mark rec 01 | J_3RF_BUE_F_BOX | CHAR | 1(0) | KOART | |||||
FLG_BELNR_PAY | Reversal (Payment) | J_3RF_BUE_F_D2 | CHAR | 1(0) | ||||||
FLG_BELNR_INV | Reversal (Invoice) | J_3RF_BUE_F_D1 | CHAR | 1(0) | KOART | |||||
FLG_XRAGL_PAY | Indicator: Clearing Was Reversed | XRAGL | CHAR | 1(0) | XFELD | |||||
FLG_BELNR_ALL | Reversal (Clearing) | J_3RF_BUE_F_ALL | CHAR | 1(0) | KOART | |||||
MM_INV_BUDAT | Date of Goods Receipt | J_3RF_DE_RDAT | DATS | 8(0) | DATUM | |||||
MM_INV_EBLN | Purchasing Document Number | EBELN | CHAR | 10(0) | ALPHA | EBELN | BES | MEKK_C | EBELN | |
MM_INV_EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5(0) | Assigned to domain | EBELP | BSP | |||
MM_INV_VOISO | Prelim. doc.: ISO code of ctry issuing the preliminary doc. | VOISO | CHAR | 2(0) | INTCA | |||||
PART_PAYMENT | Partial Payment | J_3RF_BUE_F_PP | CHAR | 1(0) | ||||||
MWSKZ_INV | Tax on sales/purchases code | MWSKZ | CHAR | 2(0) | Assigned to domain | MWSKZ | ||||
NUM_LINE | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
GJAHR_TRN | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
GJAHR_INV | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
GJAHR_PAY | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
BUTXT | Name 1 | NAME1_BAS | CHAR | 35(0) | NAME | |||||
PAVAL | Parameter value | PAVAL | CHAR | 48(0) | TEXT48 | |||||
DAT_BEGIN | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
DAT_END | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
EKBE_BELNR_MM | Number of Material Document | MBLNR | CHAR | 10(0) | ALPHA | BELNR | MBN | |||
XREF1_INV | Business Partner Reference Key | XREF1 | CHAR | 12(0) | CHAR12 | |||||
XREF1_DAT | Document Date in Document | BLDAT | DATS | 8(0) | DATUM | |||||
HKONT_INV | General Ledger Account | HKONT | CHAR | 10(0) | Assigned to domain | ALPHA | SAKNR | |||
HKONT_TRN | General Ledger Account | HKONT | CHAR | 10(0) | Assigned to domain | ALPHA | SAKNR | |||
HKONT_CLN | General Ledger Account | HKONT | CHAR | 10(0) | Assigned to domain | ALPHA | SAKNR | |||
MM_INV_VORNU | Character String - 256 User-Defined Characters | CHAR0256 | LCHR | 256(0) | CHAR0256 | |||||
USNAM_INV | User Name | USNAM | CHAR | 12(0) | Assigned to domain | XUBNAME | USR | |||
USNAM_PAY | User Name | USNAM | CHAR | 12(0) | Assigned to domain | XUBNAME | USR | |||
USNAM_PAY_FCT | User Name | USNAM | CHAR | 12(0) | Assigned to domain | XUBNAME | USR | |||
BUKRS_ADD | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
BELNR_ADD | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
GJAHR_ADD | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
MONAT_ADD | Fiscal period | MONAT | NUMC | 2(0) | MONAT | |||||
BUZEI_ADD | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3(0) | BUZEI | BUZ | ||||
FLAG_ADD | Indicator: Document is reversed | STORN | CHAR | 1(0) | XFELD | |||||
CORR_TYPE | Correction Type | J_3RF_BUE_CORR_TYPE | CHAR | 1(0) | J_3RF_BUE_CORR_TYPE | |||||
CORR_BOOK | Correction invoice from opposite book | J_3RF_BUE_CORR_BOOK | CHAR | 1(0) | FLAG | |||||
BELNR_ORIG_INV | Number of Original VAT Invoice | J_3RFINV_ORIGS | CHAR | 10(0) | ALPHA | BELNR | ||||
GJAHR_ORIG_INV | Year of Original VAT Invoice | J_3RFINV_ORIGY | NUMC | 4(0) | GJAHR | GJAHR | ||||
BLDAT_ORIG_INV | Date of Original VAT Invoice | J_3RFINV_ORIGD | DATS | 8(0) | DATUM | |||||
BUDAT_ORIG_INV | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
XBLNR_ORIG_INV | External Document Number | J_3RF_EXT_NUMBER | CHAR | 50(0) | TEXT50 | |||||
NUMBER_REV | Revision Number | J_3RFINV_REVNO | NUMC | 3(0) | NUM03 | |||||
NUMBER_CORR_REV | Number of Revision of Correction | J_3RFINV_REVNO_CORR | NUMC | 3(0) | NUM03 | |||||
VATDATE_INV | Tax Reporting Date | VATDATE | DATS | 8(0) | DATUM | |||||
VATDATE_TRN | Tax Reporting Date | VATDATE | DATS | 8(0) | DATUM | |||||
BLDAT_CORR_INV | Date of Corrective VAT Invoice | J_3RFINV_CORRD | DATS | 8(0) | DATUM | |||||
XBLNR_CORR_INV | External Document Number | J_3RF_EXT_NUMBER | CHAR | 50(0) | TEXT50 | |||||
JOURNAL | Document is Registered by Operator | J_3RFINV_REGFLAG | CHAR | 1(0) | J_3RF_REGFLAG | |||||
BELNR_CORR_INV | Number of Corrective VAT Invoice | J_3RFINV_CORRS | CHAR | 10(0) | ALPHA | BELNR | ||||
GJAHR_CORR_INV | Year of Corrective VAT Invoice | J_3RFINV_CORRY | NUMC | 4(0) | GJAHR | GJAHR | ||||
BELNR_ORIG_REV | Number of Revision VAT Invoice | J_3RFINV_REVS | CHAR | 10(0) | ALPHA | BELNR | ||||
GJAHR_ORIG_REV | Year of Revision VAT Invoice | J_3RFINV_REVY | NUMC | 4(0) | GJAHR | GJAHR | ||||
BLDAT_ORIG_REV | Revision Date | J_3RFINV_REVD | DATS | 8(0) | DATUM | |||||
BELNR_CORR_REV | Number of Revision of Corrective Invoice | J_3RFINV_CORR_REVS | CHAR | 10(0) | ALPHA | BELNR | ||||
GJAHR_CORR_REV | Year of Revision of Corrective Invoice | J_3RFINV_CORR_REVY | NUMC | 4(0) | GJAHR | GJAHR | ||||
BLDAT_CORR_REV | Revision Date of Correction | J_3RFINV_CORR_REVD | DATS | 8(0) | DATUM | |||||
EXT_TEXT_ORIG | General Flag | FLAG | CHAR | 1(0) | FLAG | |||||
EXT_TEXT_CORR | General Flag | FLAG | CHAR | 1(0) | FLAG | |||||
OPER_TYP | Operation Type Code | J_3RFINV_OPERTYP | CHAR | 20(0) | CHAR20 | |||||
PAY_EXT_NUMBER | Payment Document Number and Date | J_3RF_BK_PAYMENT | CHAR | 255(0) | J_3RF_BK_PAYMENT | |||||
PAY_EXT_BLDAT | Document Date in Document | BLDAT | DATS | 8(0) | DATUM | |||||
COMM_TRADE | Trade Type | J_3RFINV_COMM_TRADE | CHAR | 1(0) | J_3RFINV_COMM_TRADE | |||||
AGENT_LIFNR | Agent ID | J_3RF_BK_AGENT_ID | CHAR | 10(0) | CHAR10 | |||||
AGENT_NAME | Agent Name | J_3RF_BK_AGENT_NAME | CHAR | 255(0) | J_3RF_TEXT255 | |||||
AGENT_INN | Agent INN | J_3RF_BK_AGENT_INN | CHAR | 16(0) | STCD1 | |||||
AGENT_KPP | Agent KPP | J_3RF_BK_AGENT_KPP | CHAR | 18(0) | CHAR18 | |||||
HWSTE_PAY | Total transactions in the period in local currency (curr 2) | HSLXX | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S |
Search for further information about these or an SAP related objects