Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

J_3RBUE_BK_TABLE SAP (Transparent table for PurBook (ALV)) Table details

Dictionary Type: Table
Description: Transparent table for PurBook (ALV)

ABAP Code to SELECT data from J_3RBUE_BK_TABLE
Related tables to J_3RBUE_BK_TABLE
Access table J_3RBUE_BK_TABLE

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Table field list including key, data, relationships and ABAP select examples

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

The J_3RBUE_BK_TABLE table consists of various fields, each holding specific information or linking keys about Transparent table for PurBook (ALV) data available in SAP. These include BUKRS (Company Code), BELNR_TRN (Accounting Document Number), GJAHR_TRN (Fiscal Year), BUZEI_TEST (Number of Line Item Within Accounting Document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP J_3RBUE_BK_TABLE table fields - Full list of fields found in SAP data dictionary

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

Key field

Non-key field

How do I retrieve data from SAP table J_3RBUE_BK_TABLE using ABAP code

The following ABAP code Example will allow you to do a basic selection on J_3RBUE_BK_TABLE to SELECT all data from the table
DATA: WA_J_3RBUE_BK_TABLE TYPE J_3RBUE_BK_TABLE.

SELECT SINGLE *
FROM J_3RBUE_BK_TABLE
INTO CORRESPONDING FIELDS OF WA_J_3RBUE_BK_TABLE
WHERE...

How to access SAP table J_3RBUE_BK_TABLE

Within an ECC or HANA version of SAP you can also view further information about J_3RBUE_BK_TABLE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!