J_3RBUY_BOOK_12A SAP (Purchase Book) Structure details

Dictionary Type: Structure
Description: Purchase Book




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




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

J_3RBUY_BOOK_12A 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 "Purchase Book" 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_3RBUY_BOOK_12A TYPE J_3RBUY_BOOK_12A.

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


SAP J_3RBUY_BOOK_12A 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
BELNR_INVAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
XBLNR_INVReference Document Number XBLNRCHAR16XBLNR
BLDAT_INVDocument Date in Document BLDATDATS8DATUM
BUDAT_INVPosting Date in the Document BUDATDATS8DATUM
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
BKTXT_INVDocument Header Text BKTXTCHAR25TEXT25
BELNR_PAYAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
XBLNR_PAYReference Document Number XBLNRCHAR16XBLNR
BLDAT_PAYDocument Date in Document BLDATDATS8DATUM
BUDAT_PAYPosting Date in the Document BUDATDATS8DATUM
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
BKTXT_PAYDocument Header Text BKTXTCHAR25TEXT25
BELNR_ORIGPAYAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHR_ORIGPAYFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BLDAT_ORIGPAYDocument Date in Document BLDATDATS8DATUM
BUDAT_ORIGPAYPosting Date in the Document BUDATDATS8DATUM
XBLNR_ORIGPAYReference Document Number XBLNRCHAR16XBLNR
BKTXT_ORIGPAYDocument Header Text BKTXTCHAR25TEXT25
BELNR_TRNAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GSBER_TRNBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
BLDAT_TRNDocument Date in Document BLDATDATS8DATUM
BUDAT_TRNPosting Date in the Document BUDATDATS8DATUM
MONAT_TRNFiscal Period MONATNUMC2MONAT
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
FWSTE_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
FWSTE_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
FWSTE2_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
FWSTE2_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
FWSTE3_TRNTotal transactions in the period in local currency (curr 2) HSLXXCURR15(2) WERTV8
FWSTE3_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
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
LIGHTSIcon ID (incl. @) SCRFICONCHAR4SCRPICON
BOXFlag for mark rec 01 J_3RF_BUE_F_BOXCHAR1KOART
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
MM_INV_BUDATDate of Goods Receipt J_3RF_DE_RDATDATS8DATUM
MM_INV_EBLNPurchasing 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
PART_PAYMENTPartial Payment J_3RF_BUE_F_PPCHAR1
MWSKZ_INVTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
NUM_LINEAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHR_TRNFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
GJAHR_INVFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
GJAHR_PAYFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUTXTName 1 NAME1_BASCHAR35NAME
PAVALParameter value PAVALCHAR48TEXT48
DAT_BEGINField of type DATS DATSDATS8DATS
DAT_ENDField of type DATS DATSDATS8DATS
EKBE_BELNR_MMNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
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
MM_INV_VORNUCharacter String - 256 User-Defined Characters CHAR0256LCHR256CHAR0256
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

Key field Non-key field



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

As J_3RBUY_BOOK_12A 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_3RBUY_BOOK_12A as there is no data to select.

How to access SAP table J_3RBUY_BOOK_12A

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