SAP TABLES | Financial Accounting | Localization(FI-LOC) SAP FI

J_3RBUE_BK_TABLE SAP Transparent table for PurBook (ALV) Table








J_3RBUE_BK_TABLE is a standard SAP Table which is used to store Transparent table for PurBook (ALV) information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about Table J_3RBUE_BK_TABLE and the data within it using relevant SAP transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Allowed

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


Dictionary fields for SAP Table J_3RBUE_BK_TABLE




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
BUKRSBUKRSCHAR4
*
Company Code
BELNR_TRNBELNR_DCHAR10 Accounting Document NumberALPHA
GJAHR_TRNGJAHRNUMC4 Fiscal YearGJAHR
BUZEI_TESTBUZEINUMC3 Number of Line Item Within Accounting Document
MONAT_TRNMONATNUMC2 Fiscal Period
EX_INDEXJ_3RF_BUE_EXINDCHAR10 DE for EX index
EX_INDEX_POSJ_3RF_EX_INDEX_POSCHAR10 Extracts counter for PBOOK_03
LAUFILAUFICHAR6 Additional Identification
LAUFDLAUFDDATS8 Date on Which the Program Is to Be Run
GSBER_TRNGSBERCHAR4
*
Business Area
BLDAT_TRNBLDATDATS8 Document Date in Document
BUDAT_TRNBUDATDATS8 Posting Date in the Document
DMBTR_TRNFM_WTBUKRSCURR15(2) Amount in company code currency
DMBTR_WRS_TRNWAERSCUKY5
*
Currency Key
WRBTR_TRNFWBTR_DEFTAX_ITEMCURR15(2) Gross Amount in Document Currency
WRBTR_WRS_TRNWAERSCUKY5
*
Currency Key
FLG_BELNR_TRNJ_3RF_BUE_F_D0CHAR1 Reversal (Tax Transfer)
BELNR_PAYBELNR_DCHAR10 Accounting Document NumberALPHA
GJAHR_PAYGJAHRNUMC4 Fiscal YearGJAHR
BLDAT_PAYBLDATDATS8 Document Date in Document
BUDAT_PAYBUDATDATS8 Posting Date in the Document
DMBTR_PAYHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
DMBTR_WRS_PAYWAERSCUKY5
*
Currency Key
WRBTR_PAYHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
WRBTR_WRS_PAYWAERSCUKY5
*
Currency Key
FLG_BELNR_PAYJ_3RF_BUE_F_D2CHAR1 Reversal (Payment)
FLG_XRAGL_PAYXRAGLCHAR1 Indicator: Clearing was Reversed
BELNR_ORIGPAYBELNR_DCHAR10 Accounting Document NumberALPHA
GJAHR_ORIGPAYGJAHRNUMC4 Fiscal YearGJAHR
BLDAT_ORIGPAYBLDATDATS8 Document Date in Document
BUDAT_ORIGPAYBUDATDATS8 Posting Date in the Document
XBLNR_ORIGPAYXBLNR1CHAR16 Reference Document Number
BKTXT_ORIGPAYBKTXTCHAR25 Document Header Text
BELNR_INVBELNR_DCHAR10 Accounting Document NumberALPHA
GJAHR_INVGJAHRNUMC4 Fiscal YearGJAHR
BLDAT_INVBLDATDATS8 Document Date in Document
BUDAT_INVBUDATDATS8 Posting Date in the Document
DMBTR_INVFM_WTBUKRSCURR15(2) Amount in company code currency
DMBTR_WRS_INVWAERSCUKY5
*
Currency Key

WRBTR_INVFWBTR_DEFTAX_ITEMCURR15(2) Gross Amount in Document Currency
WRBTR_WRS_INVWAERSCUKY5
*
Currency Key
MWSKZMWSKZCHAR2
*
Tax on sales/purchases code
MWSKZ_INVMWSKZCHAR2
*
Tax on sales/purchases code
FLG_BELNR_INVJ_3RF_BUE_F_D1CHAR1 Reversal (Invoice)
FLG_BELNR_ALLJ_3RF_BUE_F_ALLCHAR1 Reversal (Clearing)
BASGRUNOBASGRUNONUMC2 Group Number for Tax Base Amounts
HWBAS_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
HWBAS_WRS_TRNWAERSCUKY5
*
Currency Key
FWBAS_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
FWBAS_WRS_TRNWAERSCUKY5
*
Currency Key
HWBAS2_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
HWBAS2_WRS_TRNWAERSCUKY5
*
Currency Key
FWBAS2_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
FWBAS2_WRS_TRNWAERSCUKY5
*
Currency Key
HWBAS3_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
HWBAS3_WRS_TRNWAERSCUKY5
*
Currency Key
FWBAS3_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
FWBAS3_WRS_TRNWAERSCUKY5
*
Currency Key
HWBAS4_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
HWBAS4_WRS_TRNWAERSCUKY5
*
Currency Key
FWBAS4_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
FWBAS4_WRS_TRNWAERSCUKY5
*
Currency Key
HWBAS5_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
HWBAS5_WRS_TRNWAERSCUKY5
*
Currency Key
FWBAS5_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
FWBAS5_WRS_TRNWAERSCUKY5
*
Currency Key
STEGRUNOSTEGRUNONUMC2 Group Number for Tax Amounts
HWSTE_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
HWSTE_WRS_TRNWAERSCUKY5
*
Currency Key
FWSTE_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
FWSTE_WRS_TRNWAERSCUKY5
*
Currency Key
HWSTE2_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
HWSTE2_WRS_TRNWAERSCUKY5
*
Currency Key
FWSTE2_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
FWSTE2_WRS_TRNWAERSCUKY5
*
Currency Key
HWSTE3_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
HWSTE3_WRS_TRNWAERSCUKY5
*
Currency Key
FWSTE3_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
FWSTE3_WRS_TRNWAERSCUKY5
*
Currency Key

HWSTE5_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
HWSTE5_WRS_TRNWAERSCUKY5
*
Currency Key
FWSTE5_TRNHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
FWSTE5_WRS_TRNWAERSCUKY5
*
Currency Key
BKTXT_TRNBKTXTCHAR25 Document Header Text
LIFNR_CREDLIFNRCHAR10
*
Account Number of Vendor or CreditorALPHA
NAME1_CREDNAME1_GPCHAR35 Name 1
NAME2_CREDNAME2_GPCHAR35 Name 2
NAME3_CREDNAME3_GPCHAR35 Name 3
NAME4_CREDNAME4_GPCHAR35 Name 4
NAME1_CRED_RNAME1_GPCHAR35 Name 1
NAME2_CRED_RNAME2_GPCHAR35 Name 2
NAME3_CRED_RNAME3_GPCHAR35 Name 3
NAME4_CRED_RNAME4_GPCHAR35 Name 4
STCD1_CREDSTCD1CHAR16 Tax Number 1
STCD3_CREDSTCD3CHAR18 Tax Number 3
XBLNR_INVXBLNR1CHAR16 Reference Document Number
BKTXT_INVBKTXTCHAR25 Document Header Text
XBLNR_PAYXBLNR1CHAR16 Reference Document Number
BKTXT_PAYBKTXTCHAR25 Document Header Text
MM_INV_BUDATJ_3RF_DE_RDATDATS8 Date of Goods Receipt
MM_INV_EBLNEBELNCHAR10
*
Purchasing Document NumberALPHA
MM_INV_VOISOVOISOCHAR2 Prelim. doc.: ISO code of ctry issuing the preliminary doc.
PART_PAYMENTJ_3RF_BUE_F_PPCHAR1 Partial Payment
LIGHTSSCRFICONCHAR4 Icon ID (incl. @)
BOXJ_3RF_BUE_F_BOXCHAR1 Flag for mark rec 01
NUM_LINEBELNR_DCHAR10 Accounting Document NumberALPHA
MM_INV_EBELPEBELPNUMC5
*
Item Number of Purchasing Document
EKBE_BELNR_MMMBLNRCHAR10 Number of Material DocumentALPHA
XREF1_INVXREF1CHAR12 Business partner reference key
XREF1_DATBLDATDATS8 Document Date in Document
HKONT_INVHKONTCHAR10
*
General Ledger AccountALPHA
HKONT_TRNHKONTCHAR10
*
General Ledger AccountALPHA
HKONT_CLNHKONTCHAR10
*
General Ledger AccountALPHA
USNAM_INVUSNAMCHAR12
*
User name
USNAM_PAYUSNAMCHAR12
*
User name
USNAM_PAY_FCTUSNAMCHAR12
*
User name
RESERVINT25 technological field
MM_INV_VORNUCHAR0256LCHR256 Character String - 256 User-Defined Characters


Key field
Non-key field