SAP table J_3RBUE_BK_TABLE (Transparent table for PurBook (ALV))
SAP table J_3RBUE_BK_TABLE has 8 primary key fields being MANDT,BUKRS,BELNR_TRN,GJAHR_TRN,BUZEI_TEST,MONAT_TRN,EX_INDEX,EX_INDEX_POS.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | MANDT | ||
| BUKRS | Company Code | CHAR | 4 | 0 | BUKRS | ||
| BELNR_TRN | Document Number of an Accounting Document | CHAR | 10 | 0 | BELNR_D | ||
| GJAHR_TRN | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| BUZEI_TEST | Number of Line Item Within Accounting Document | NUMC | 3 | 0 | BUZEI | ||
| MONAT_TRN | Fiscal period | NUMC | 2 | 0 | MONAT | ||
| EX_INDEX | DE for EX index | CHAR | 10 | 0 | J_3RF_BUE_EXIND | ||
| EX_INDEX_POS | Extracts counter for PBOOK_03 | CHAR | 10 | 0 | J_3RF_EX_INDEX_POS | ||
| LAUFI | Additional Identification | CHAR | 6 | 0 | LAUFI | ||
| LAUFD | Date on Which the Program Is to Be Run | DATS | 8 | 0 | LAUFD | ||
| GSBER_TRN | Business Area | CHAR | 4 | 0 | GSBER | ||
| BLDAT_TRN | Document Date in Document | DATS | 8 | 0 | BLDAT | ||
| BUDAT_TRN | Posting Date in the Document | DATS | 8 | 0 | BUDAT | ||
| DMBTR_TRN | Amount in company code currency | CURR | 15 | 2 | FM_WTBUKRS | ||
| DMBTR_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| WRBTR_TRN | Gross Amount in Document Currency | CURR | 23 | 2 | FWBTR_DEFTAX_ITEM | ||
| WRBTR_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| FLG_BELNR_TRN | Reversal (Tax Transfer) | CHAR | 1 | 0 | J_3RF_BUE_F_D0 | ||
| BELNR_PAY | Document Number of an Accounting Document | CHAR | 10 | 0 | BELNR_D | ||
| GJAHR_PAY | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| BLDAT_PAY | Document Date in Document | DATS | 8 | 0 | BLDAT | ||
| BUDAT_PAY | Posting Date in the Document | DATS | 8 | 0 | BUDAT | ||
| DMBTR_PAY | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| DMBTR_WRS_PAY | Currency Key | CUKY | 5 | 0 | WAERS | ||
| WRBTR_PAY | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| WRBTR_WRS_PAY | Currency Key | CUKY | 5 | 0 | WAERS | ||
| FLG_BELNR_PAY | Reversal (Payment) | CHAR | 1 | 0 | J_3RF_BUE_F_D2 | ||
| FLG_XRAGL_PAY | Indicator: Clearing Was Reversed | CHAR | 1 | 0 | XRAGL | ||
| BELNR_ORIGPAY | Document Number of an Accounting Document | CHAR | 10 | 0 | BELNR_D | ||
| GJAHR_ORIGPAY | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| BLDAT_ORIGPAY | Document Date in Document | DATS | 8 | 0 | BLDAT | ||
| BUDAT_ORIGPAY | Posting Date in the Document | DATS | 8 | 0 | BUDAT | ||
| XBLNR_ORIGPAY | Reference Document Number | CHAR | 16 | 0 | XBLNR1 | ||
| BKTXT_ORIGPAY | Document Header Text | CHAR | 25 | 0 | BKTXT | ||
| BELNR_INV | Document Number of an Accounting Document | CHAR | 10 | 0 | BELNR_D | ||
| GJAHR_INV | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| BLDAT_INV | Document Date in Document | DATS | 8 | 0 | BLDAT | ||
| BUDAT_INV | Posting Date in the Document | DATS | 8 | 0 | BUDAT | ||
| DMBTR_INV | Amount in company code currency | CURR | 15 | 2 | FM_WTBUKRS | ||
| DMBTR_WRS_INV | Currency Key | CUKY | 5 | 0 | WAERS | ||
| WRBTR_INV | Gross Amount in Document Currency | CURR | 23 | 2 | FWBTR_DEFTAX_ITEM | ||
| WRBTR_WRS_INV | Currency Key | CUKY | 5 | 0 | WAERS | ||
| MWSKZ | Tax on sales/purchases code | CHAR | 2 | 0 | MWSKZ | ||
| MWSKZ_INV | Tax on sales/purchases code | CHAR | 2 | 0 | MWSKZ | ||
| FLG_BELNR_INV | Reversal (Invoice) | CHAR | 1 | 0 | J_3RF_BUE_F_D1 | ||
| FLG_BELNR_ALL | Reversal (Clearing) | CHAR | 1 | 0 | J_3RF_BUE_F_ALL | ||
| BASGRUNO | Group Number for Tax Base Amounts | NUMC | 2 | 0 | BASGRUNO | ||
| HWBAS_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| HWBAS_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| FWBAS_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| FWBAS_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| HWBAS2_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| HWBAS2_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| FWBAS2_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| FWBAS2_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| HWBAS3_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| HWBAS3_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| FWBAS3_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| FWBAS3_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| HWBAS4_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| HWBAS4_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| FWBAS4_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| FWBAS4_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| HWBAS5_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| HWBAS5_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| FWBAS5_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| FWBAS5_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| STEGRUNO | Group Number for Tax Amounts | NUMC | 2 | 0 | STEGRUNO | ||
| HWSTE_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| HWSTE_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| FWSTE_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| FWSTE_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| HWSTE2_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| HWSTE2_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| FWSTE2_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| FWSTE2_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| HWSTE3_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| HWSTE3_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| FWSTE3_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| FWSTE3_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| HWSTE5_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| HWSTE5_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| FWSTE5_TRN | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS_BSES | ||
| FWSTE5_WRS_TRN | Currency Key | CUKY | 5 | 0 | WAERS | ||
| BKTXT_TRN | Document Header Text | CHAR | 25 | 0 | BKTXT | ||
| LIFNR_CRED | Account Number of Supplier | CHAR | 10 | 0 | LIFNR | ||
| NAME1_CRED | Name 1 | CHAR | 35 | 0 | NAME1_GP | ||
| NAME2_CRED | Name 2 | CHAR | 35 | 0 | NAME2_GP | ||
| NAME3_CRED | Name 3 | CHAR | 35 | 0 | NAME3_GP | ||
| NAME4_CRED | Name 4 | CHAR | 35 | 0 | NAME4_GP | ||
| NAME1_CRED_R | Name 1 | CHAR | 35 | 0 | NAME1_GP | ||
| NAME2_CRED_R | Name 2 | CHAR | 35 | 0 | NAME2_GP | ||
| NAME3_CRED_R | Name 3 | CHAR | 35 | 0 | NAME3_GP | ||
| NAME4_CRED_R | Name 4 | CHAR | 35 | 0 | NAME4_GP | ||
| STCD1_CRED | Tax Number 1 | CHAR | 16 | 0 | STCD1 | ||
| STCD3_CRED | Tax Number 3 | CHAR | 18 | 0 | STCD3 | ||
| XBLNR_INV | Reference Document Number | CHAR | 16 | 0 | XBLNR1 | ||
| BKTXT_INV | Document Header Text | CHAR | 25 | 0 | BKTXT | ||
| XBLNR_PAY | Reference Document Number | CHAR | 16 | 0 | XBLNR1 | ||
| BKTXT_PAY | Document Header Text | CHAR | 25 | 0 | BKTXT | ||
| MM_INV_BUDAT | Date of Goods Receipt | DATS | 8 | 0 | J_3RF_DE_RDAT | ||
| MM_INV_EBLN | Purchasing Document Number | CHAR | 10 | 0 | EBELN | ||
| MM_INV_VOISO | Prelim. doc.: ISO code of ctry issuing the preliminary doc. | CHAR | 2 | 0 | VOISO | ||
| PART_PAYMENT | Partial Payment | CHAR | 1 | 0 | J_3RF_BUE_F_PP | ||
| LIGHTS | Icon ID (incl. @) | CHAR | 4 | 0 | SCRFICON | ||
| BOX | Flag for mark rec 01 | CHAR | 1 | 0 | J_3RF_BUE_F_BOX | ||
| NUM_LINE | Document Number of an Accounting Document | CHAR | 10 | 0 | BELNR_D | ||
| MM_INV_EBELP | Item Number of Purchasing Document | NUMC | 5 | 0 | EBELP | ||
| EKBE_BELNR_MM | Number of Material Document | CHAR | 10 | 0 | MBLNR | ||
| XREF1_INV | Business Partner Reference Key | CHAR | 12 | 0 | XREF1 | ||
| XREF1_DAT | Document Date in Document | DATS | 8 | 0 | BLDAT | ||
| HKONT_INV | General Ledger Account | CHAR | 10 | 0 | HKONT | ||
| HKONT_TRN | General Ledger Account | CHAR | 10 | 0 | HKONT | ||
| HKONT_CLN | General Ledger Account | CHAR | 10 | 0 | HKONT | ||
| USNAM_INV | User Name | CHAR | 12 | 0 | USNAM | ||
| USNAM_PAY | User Name | CHAR | 12 | 0 | USNAM | ||
| USNAM_PAY_FCT | User Name | CHAR | 12 | 0 | USNAM | ||
| RESERV | INT2 | 5 | 0 | ||||
| MM_INV_VORNU | Character String - 256 User-Defined Characters | LCHR | 256 | 0 | CHAR0256 |