1. Home
  2. Resources
  3. SAP Tables
  4. J_3RBUE_BK_TABLE - Transparent table for PurBook (ALV)

SAP Table J_3RBUE_BK_TABLE

Transparent table for PurBook (ALV)

J_3RBUE_BK_TABLE (Transparent table for PurBook (ALV)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link J_3RBUE_BK_TABLE to other SAP tables.

Source: J_3RBUE_BK_TABLE (Transparent table for PurBook (ALV))

J_3RBUE_BK_TABLE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS CHAR 4 0
BELNR_TRN Accounting Document Number BELNR_D CHAR 10 0
GJAHR_TRN Fiscal Year GJAHR NUMC 4 0
BUZEI_TEST Number of Line Item Within Accounting Document BUZEI NUMC 3 0
MONAT_TRN Fiscal Period MONAT NUMC 2 0
EX_INDEX DE for EX index J_3RF_BUE_EXIND CHAR 10 0
EX_INDEX_POS Extracts counter for PBOOK_03 J_3RF_EX_INDEX_POS CHAR 10 0
LAUFI Additional Identification LAUFI CHAR 6 0
LAUFD Date on Which the Program Is to Be Run LAUFD DATS 8 0
GSBER_TRN Business Area GSBER CHAR 4 0
BLDAT_TRN Document Date in Document BLDAT DATS 8 0
BUDAT_TRN Posting Date in the Document BUDAT DATS 8 0
DMBTR_TRN Amount in company code currency FM_WTBUKRS CURR 15 2
DMBTR_WRS_TRN Currency Key WAERS CUKY 5 0
WRBTR_TRN Gross Amount in Document Currency FWBTR_DEFTAX_ITEM CURR 15 2
WRBTR_WRS_TRN Currency Key WAERS CUKY 5 0
FLG_BELNR_TRN Reversal (Tax Transfer) J_3RF_BUE_F_D0 CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
BELNR_PAY Accounting Document Number BELNR_D CHAR 10 0
GJAHR_PAY Fiscal Year GJAHR NUMC 4 0
BLDAT_PAY Document Date in Document BLDAT DATS 8 0
BUDAT_PAY Posting Date in the Document BUDAT DATS 8 0
DMBTR_PAY Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
DMBTR_WRS_PAY Currency Key WAERS CUKY 5 0
WRBTR_PAY Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
WRBTR_WRS_PAY Currency Key WAERS CUKY 5 0
FLG_BELNR_PAY Reversal (Payment) J_3RF_BUE_F_D2 CHAR 1 0
FLG_XRAGL_PAY Indicator: Clearing was Reversed XRAGL CHAR 1 0
X Yes
NULL No
BELNR_ORIGPAY Accounting Document Number BELNR_D CHAR 10 0
GJAHR_ORIGPAY Fiscal Year GJAHR NUMC 4 0
BLDAT_ORIGPAY Document Date in Document BLDAT DATS 8 0
BUDAT_ORIGPAY Posting Date in the Document BUDAT DATS 8 0
XBLNR_ORIGPAY Reference Document Number XBLNR1 CHAR 16 0
BKTXT_ORIGPAY Document Header Text BKTXT CHAR 25 0
BELNR_INV Accounting Document Number BELNR_D CHAR 10 0
GJAHR_INV Fiscal Year GJAHR NUMC 4 0
BLDAT_INV Document Date in Document BLDAT DATS 8 0
BUDAT_INV Posting Date in the Document BUDAT DATS 8 0
DMBTR_INV Amount in company code currency FM_WTBUKRS CURR 15 2
DMBTR_WRS_INV Currency Key WAERS CUKY 5 0
WRBTR_INV Gross Amount in Document Currency FWBTR_DEFTAX_ITEM CURR 15 2
WRBTR_WRS_INV Currency Key WAERS CUKY 5 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
MWSKZ_INV Tax on sales/purchases code MWSKZ CHAR 2 0
FLG_BELNR_INV Reversal (Invoice) J_3RF_BUE_F_D1 CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
FLG_BELNR_ALL Reversal (Clearing) J_3RF_BUE_F_ALL CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
BASGRUNO Group Number for Tax Base Amounts BASGRUNO NUMC 2 0
HWBAS_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
HWBAS_WRS_TRN Currency Key WAERS CUKY 5 0
FWBAS_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
FWBAS_WRS_TRN Currency Key WAERS CUKY 5 0
HWBAS2_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
HWBAS2_WRS_TRN Currency Key WAERS CUKY 5 0
FWBAS2_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
FWBAS2_WRS_TRN Currency Key WAERS CUKY 5 0
HWBAS3_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
HWBAS3_WRS_TRN Currency Key WAERS CUKY 5 0
FWBAS3_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
FWBAS3_WRS_TRN Currency Key WAERS CUKY 5 0
HWBAS4_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
HWBAS4_WRS_TRN Currency Key WAERS CUKY 5 0
FWBAS4_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
FWBAS4_WRS_TRN Currency Key WAERS CUKY 5 0
HWBAS5_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
HWBAS5_WRS_TRN Currency Key WAERS CUKY 5 0
FWBAS5_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
FWBAS5_WRS_TRN Currency Key WAERS CUKY 5 0
STEGRUNO Group Number for Tax Amounts STEGRUNO NUMC 2 0
HWSTE_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
HWSTE_WRS_TRN Currency Key WAERS CUKY 5 0
FWSTE_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
FWSTE_WRS_TRN Currency Key WAERS CUKY 5 0
HWSTE2_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
HWSTE2_WRS_TRN Currency Key WAERS CUKY 5 0
FWSTE2_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
FWSTE2_WRS_TRN Currency Key WAERS CUKY 5 0
HWSTE3_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
HWSTE3_WRS_TRN Currency Key WAERS CUKY 5 0
FWSTE3_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
FWSTE3_WRS_TRN Currency Key WAERS CUKY 5 0
HWSTE5_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
HWSTE5_WRS_TRN Currency Key WAERS CUKY 5 0
FWSTE5_TRN Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
FWSTE5_WRS_TRN Currency Key WAERS CUKY 5 0
BKTXT_TRN Document Header Text BKTXT CHAR 25 0
LIFNR_CRED Account Number of Vendor or Creditor LIFNR CHAR 10 0
NAME1_CRED Name 1 NAME1_GP CHAR 35 0
NAME2_CRED Name 2 NAME2_GP CHAR 35 0
NAME3_CRED Name 3 NAME3_GP CHAR 35 0
NAME4_CRED Name 4 NAME4_GP CHAR 35 0
NAME1_CRED_R Name 1 NAME1_GP CHAR 35 0
NAME2_CRED_R Name 2 NAME2_GP CHAR 35 0
NAME3_CRED_R Name 3 NAME3_GP CHAR 35 0
NAME4_CRED_R Name 4 NAME4_GP CHAR 35 0
STCD1_CRED Tax Number 1 STCD1 CHAR 16 0
STCD3_CRED Tax Number 3 STCD3 CHAR 18 0
XBLNR_INV Reference Document Number XBLNR1 CHAR 16 0
BKTXT_INV Document Header Text BKTXT CHAR 25 0
XBLNR_PAY Reference Document Number XBLNR1 CHAR 16 0
BKTXT_PAY Document Header Text BKTXT CHAR 25 0
MM_INV_BUDAT Date of Goods Receipt J_3RF_DE_RDAT DATS 8 0
MM_INV_EBLN Purchasing Document Number EBELN CHAR 10 0
MM_INV_VOISO Prelim. doc.: ISO code of ctry issuing the preliminary doc. VOISO CHAR 2 0
PART_PAYMENT Partial Payment J_3RF_BUE_F_PP CHAR 1 0
LIGHTS Icon ID (incl. @) SCRFICON CHAR 4 0
BOX Flag for mark rec 01 J_3RF_BUE_F_BOX CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
NUM_LINE Accounting Document Number BELNR_D CHAR 10 0
MM_INV_EBELP Item Number of Purchasing Document EBELP NUMC 5 0
EKBE_BELNR_MM Number of Material Document MBLNR CHAR 10 0
XREF1_INV Business partner reference key XREF1 CHAR 12 0
XREF1_DAT Document Date in Document BLDAT DATS 8 0
HKONT_INV General Ledger Account HKONT CHAR 10 0
HKONT_TRN General Ledger Account HKONT CHAR 10 0
HKONT_CLN General Ledger Account HKONT CHAR 10 0
USNAM_INV User name USNAM CHAR 12 0
USNAM_PAY User name USNAM CHAR 12 0
USNAM_PAY_FCT User name USNAM CHAR 12 0
RESERV INT2 5 0
MM_INV_VORNU Character String - 256 User-Defined Characters CHAR0256 LCHR 256 0