J_3RSL_BK_TABLE SAP (Transparent table for SaleBook (ALV)) Table details

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




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




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

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

The J_3RSL_BK_TABLE table consists of various fields, each holding specific information or linking keys about Transparent table for SaleBook (ALV) data available in SAP. These include BUKRS (Company Code), BELNR_TRN (Accounting Document Number), GJAHR_TRN (Fiscal Year), BUZEI (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_3RSL_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
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BELNR_TRNAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHR_TRNFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
MONAT_TRNFiscal Period MONATNUMC2MONAT
EX_INDEXDE for EX index J_3RF_BUE_EXINDCHAR10TEXT10
LAUFDDate on Which the Program Is to Be Run LAUFDDATS8DATUM
LAUFIAdditional Identification LAUFICHAR6LAUFI
BUDAT_TRNPosting Date in the Document BUDATDATS8DATUM
BLDAT_TRNDocument Date in Document BLDATDATS8DATUM
DMBTR_TRNAmount in Local Currency DMBTRCURR13(2) WERT7
DMBTR_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
WRBTR_TRNAmount in document currency WRBTRCURR13(2) WERT7
WRBTR_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FLG_BELNR_TRNReversal (Tax Transfer) J_3RF_BUE_F_D0CHAR1KOART
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
BELNR_PAYAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHR_PAYFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUDAT_PAYPosting Date in the Document BUDATDATS8DATUM
BLDAT_PAYDocument Date in Document BLDATDATS8DATUM
DMBTR_PAYAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
DMBTR_WRS_PAYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
WRBTR_PAYAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
WRBTR_WRS_PAYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FLG_BELNR_PAYReversal (Payment) J_3RF_BUE_F_D2CHAR1
FLG_XRAGL_PAYIndicator: Clearing was Reversed XRAGLCHAR1XFELD
BELNR_INVAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHR_INVFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUDAT_INVPosting Date in the Document BUDATDATS8DATUM
BLDAT_INVDocument Date in Document BLDATDATS8DATUM
DMBTR_INVAmount in Local Currency DMBTRCURR13(2) WERT7
DMBTR_WRS_INVCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
WRBTR_INVAmount in document currency WRBTRCURR13(2) WERT7
WRBTR_WRS_INVCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
MWSKZ_INVTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
FLG_BELNR_INVReversal (Invoice) J_3RF_BUE_F_D1CHAR1KOART
FLG_BELNR_ALLReversal (Clearing) J_3RF_BUE_F_ALLCHAR1KOART
BASGRUNOGroup Number for Tax Base Amounts BASGRUNONUMC2NUM2
HWBAS_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
HWBAS_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWBAS_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
FWBAS_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWBAS2_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
HWBAS2_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWBAS2_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
FWBAS2_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWBAS3_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
HWBAS3_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWBAS3_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
FWBAS3_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWBAS4_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
HWBAS4_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWBAS4_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
FWBAS4_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWBAS5_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
FWBAS5_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWBAS5_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
HWBAS5_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
STEGRUNOGroup Number for Tax Amounts STEGRUNONUMC2NUM2
HWSTE_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
HWSTE_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWSTE_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
FWSTE_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWSTE2_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
HWSTE2_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWSTE2_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
FWSTE2_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWSTE3_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
HWSTE3_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWSTE3_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
FWSTE3_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWSTE5_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
HWSTE5_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWSTE5_TRNAmount Posted in Display Currency ANZBT_F05LCURR13(2) WRTV7
FWSTE5_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
BKTXT_TRNDocument Header Text BKTXTCHAR25TEXT25
LIFNR_CREDAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
NAME1_CREDName 1 NAME1_GPCHAR35NAME
NAME2_CREDName 2 NAME2_GPCHAR35NAME
STCD1_CREDTax Number 1 STCD1CHAR16STCD1
STCD3_CREDTax Number 3 STCD3CHAR18CHAR18
XBLNR_INVReference Document Number XBLNR1CHAR16XBLNR1
BKTXT_INVDocument Header Text BKTXTCHAR25TEXT25
XBLNR_PAYReference Document Number XBLNR1CHAR16XBLNR1
BKTXT_PAYDocument Header Text BKTXTCHAR25TEXT25
MM_INV_BUDATDate of Goods Receipt J_3RF_DE_RDATDATS8DATUM
MM_INV_EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
MM_INV_EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
MM_INV_VOISOPrelim. doc.: ISO code of ctry issuing the preliminary doc. VOISOCHAR2INTCA
MM_INV_VORNUPreliminary document: No. of preliminary doc.f.import procg VORNUCHAR25CHAR25
LIGHTSIcon ID (incl. @) SCRFICONCHAR4SCRPICON
BOXFlag for mark rec 01 J_3RF_BUE_F_BOXCHAR1KOART
NUM_LINEAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELJFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
ZUONRAssignment Number J_3RFZUONRCHAR18CHAR18
SGTXTItem Text SGTXTCHAR50TEXT50
XREF1_INVBusiness partner reference key XREF1CHAR12CHAR12
XFER1_DATDocument Date in Document BLDATDATS8DATUM
HKONT_INVGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
HKONT_TRNGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
HKONT_CLNGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
BELNR_ORIGPAYAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHR_ORIGPAYFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BKTXT_ORIGPAYDocument Header Text BKTXTCHAR25TEXT25
XBLNR_ORIGPAYReference Document Number XBLNR1CHAR16XBLNR1
BUDAT_ORIGPAYPosting Date in the Document BUDATDATS8DATUM
BLDAT_ORIGPAYDocument Date in Document BLDATDATS8DATUM

Key field Non-key field



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

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

SELECT SINGLE *
FROM J_3RSL_BK_TABLE
INTO CORRESPONDING FIELDS OF WA_J_3RSL_BK_TABLE
WHERE...

How to access SAP table J_3RSL_BK_TABLE

Within an ECC or HANA version of SAP you can also view further information about J_3RSL_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!