J_3RSELL_BOOK_12 SAP (Extended structure for sales ledger) Structure details

Dictionary Type: Structure
Description: Extended structure for sales ledger




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




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

J_3RSELL_BOOK_12 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Extended structure for sales ledger" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_J_3RSELL_BOOK_12 TYPE J_3RSELL_BOOK_12.

The J_3RSELL_BOOK_12 table consists of various fields, each holding specific information or linking keys about Extended structure for sales ledger data available in SAP. These include BUKRS (Company Code), GJAHR_INV (Fiscal Year), BELNR_INV (Accounting Document Number), XBLNR_INV (Reference Document Number).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP J_3RSELL_BOOK_12 structure 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
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
GJAHR_INVFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BELNR_INVAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
XBLNR_INVReference Document Number XBLNRCHAR16XBLNR
BUDAT_INVPosting Date in the Document BUDATDATS8DATUM
BLDAT_INVDocument Date in Document BLDATDATS8DATUM
DMBTR_INVTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
DMBTR_WRS_INVCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
WRBTR_INVTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
WRBTR_WRS_INVCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
GJAHR_PAYFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BELNR_PAYAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
XBLNR_PAYReference Document Number XBLNRCHAR16XBLNR
BUDAT_PAYPosting Date in the Document BUDATDATS8DATUM
BLDAT_PAYDocument Date in Document BLDATDATS8DATUM
DMBTR_PAYTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
DMBTR_WRS_PAYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
WRBTR_PAYTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
WRBTR_WRS_PAYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
GJAHR_TRNFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BELNR_TRNAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BLDAT_TRNDocument Date in Document BLDATDATS8DATUM
BUDAT_TRNPosting Date in the Document BUDATDATS8DATUM
DMBTR_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
DMBTR_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
WRBTR_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
WRBTR_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWBAS_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
HWBAS_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWBAS_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
FWBAS_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWBAS2_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
HWBAS2_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWBAS2_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
FWBAS2_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWBAS3_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
HWBAS3_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWBAS3_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
FWBAS3_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWBAS4_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
HWBAS4_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWBAS4_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
FWBAS4_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWBAS5_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
HWBAS5_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWBAS5_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
FWBAS5_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
BASGRUNOGroup Number for Tax Base Amounts BASGRUNONUMC2NUM2
HWSTE_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
HWSTE_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWSTE2_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
HWSTE2_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWSTE3_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
HWSTE3_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWSTE4_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
HWSTE4_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HWSTE5_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
HWSTE5_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWSTE_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
FWSTE_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWSTE2_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
FWSTE2_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWSTE3_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
FWSTE3_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWSTE4_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
FWSTE4_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FWSTE5_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
FWSTE5_WRS_TRNCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
STEGRUNOGroup Number for Tax Amounts STEGRUNONUMC2NUM2
GJAHR_TESTFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEI_TESTNumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
XBLNR_TESTReference Document Number XBLNRCHAR16XBLNR
LIFNR_CREDAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
NAME1_CREDName 1 NAME1_GPCHAR35NAME
NAME2_CREDName 2 NAME2_GPCHAR35NAME
NAME3_CREDName 3 NAME3_GPCHAR35NAME
NAME4_CREDName 4 NAME4_GPCHAR35NAME
NAME1_CRED_RName 1 NAME1_GPCHAR35NAME
NAME2_CRED_RName 2 NAME2_GPCHAR35NAME
NAME3_CRED_RName 3 NAME3_GPCHAR35NAME
NAME4_CRED_RName 4 NAME4_GPCHAR35NAME
STCD1_CREDTax Number 1 STCD1CHAR16STCD1
STCD3_CREDTax Number 3 STCD3CHAR18CHAR18
FLG_BELNR_TRNReversal (Tax Transfer) J_3RF_BUE_F_D0CHAR1KOART
BKTXT_TRNDocument Header Text BKTXTCHAR25TEXT25
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
FLG_BELNR_PAYReversal (Payment) J_3RF_BUE_F_D2CHAR1
FLG_BELNR_INVReversal (Invoice) J_3RF_BUE_F_D1CHAR1KOART
FLG_XRAGL_PAYIndicator: Clearing was Reversed XRAGLCHAR1XFELD
FLG_BELNR_ALLReversal (Clearing) J_3RF_BUE_F_ALLCHAR1KOART
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
LINENUMBAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BELNR_BUYAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRBUYFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEIBUYNumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
FLG_BARTERIndicator: Clearing was Reversed XRAGLCHAR1XFELD
BKTXT_PAYDocument Header Text BKTXTCHAR25TEXT25
BKTXT_INVDocument Header Text BKTXTCHAR25TEXT25
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PART_PAYMPartial Payment J_3RF_BUE_F_PPCHAR1
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELJFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
ZUONRAssignment Number J_3RFZUONRCHAR18CHAR18
SGTXTItem Text SGTXTCHAR50TEXT50
XREF1_INVBusiness partner reference key XREF1CHAR12CHAR12
XREF1_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 XBLNRCHAR16XBLNR
BUDAT_ORIGPAYPosting Date in the Document BUDATDATS8DATUM
BLDAT_ORIGPAYDocument Date in Document BLDATDATS8DATUM
USNAM_INVUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
USNAM_PAYUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
USNAM_PAY_FCTUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
BUKRS_ADDCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BELNR_ADDAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHR_ADDFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
MONAT_ADDFiscal Period MONATNUMC2MONAT
BUZEI_ADDNumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
FLAG_ADDIndicator: Document is reversed STORNCHAR1XFELD
CORR_TYPECorrection Type J_3RF_BUE_CORR_TYPECHAR1J_3RF_BUE_CORR_TYPE
CORR_BOOKCorrection invoice from opposite book J_3RF_BUE_CORR_BOOKCHAR1FLAG
BELNR_ORIG_INVNumber of Original VAT Invoice J_3RFINV_ORIGSCHAR10ALPHABELNR
GJAHR_ORIG_INVYear of Original VAT Invoice J_3RFINV_ORIGYNUMC4GJAHRGJAHR
BLDAT_ORIG_INVDate of Original VAT Invoice J_3RFINV_ORIGDDATS8DATUM
BUDAT_ORIG_INVPosting Date in the Document BUDATDATS8DATUM
XBLNR_ORIG_INVExternal Document Number J_3RF_EXT_NUMBERCHAR50TEXT50
NUMBER_REVRevision Number J_3RFINV_REVNONUMC3NUM03
NUMBER_CORR_REVRevision Number of Correction J_3RFINV_REVNO_CORRNUMC3NUM03
VATDATE_INVTax Reporting Date VATDATEDATS8DATUM
VATDATE_TRNTax Reporting Date VATDATEDATS8DATUM
BLDAT_CORR_INVDate of Corrective VAT Invoice J_3RFINV_CORRDDATS8DATUM
XBLNR_CORR_INVExternal Document Number J_3RF_EXT_NUMBERCHAR50TEXT50
JOURNALRegister in Journal J_3RFINV_REGFLAGCHAR1J_3RF_REGFLAG
BELNR_CORR_INVNumber of Corrective VAT Invoice J_3RFINV_CORRSCHAR10ALPHABELNR
GJAHR_CORR_INVYear of Corrective VAT Invoice J_3RFINV_CORRYNUMC4GJAHRGJAHR
BELNR_ORIG_REVNumber of Revised VAT Invoice J_3RFINV_REVSCHAR10ALPHABELNR
GJAHR_ORIG_REVYear of Revised VAT Invoice J_3RFINV_REVYNUMC4GJAHRGJAHR
BLDAT_ORIG_REVRevision Date J_3RFINV_REVDDATS8DATUM
BELNR_CORR_REVNumber of Revised Correction Invoice J_3RFINV_CORR_REVSCHAR10ALPHABELNR
GJAHR_CORR_REVYear of Revised Correction Invoice J_3RFINV_CORR_REVYNUMC4GJAHRGJAHR
BLDAT_CORR_REVRevision Date of Correction J_3RFINV_CORR_REVDDATS8DATUM
EXT_TEXT_ORIGGeneral Flag FLAGCHAR1FLAG
EXT_TEXT_CORRGeneral Flag FLAGCHAR1FLAG

Key field Non-key field



How do I retrieve data from SAP structure J_3RSELL_BOOK_12 using ABAP code?

As J_3RSELL_BOOK_12 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on J_3RSELL_BOOK_12 as there is no data to select.

How to access SAP table J_3RSELL_BOOK_12

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