MCRBHD SAP (Header Data) Structure details
Description: Header Data
Structure field list including key, data, relationships and ABAP select examples
MCRBHD 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 "Header Data" 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_MCRBHD TYPE MCRBHD.
The MCRBHD table consists of various fields, each holding specific information or linking keys about Header Data data available in SAP. These include MANDT (Client), BELNR (Document Number of an Invoice Document), GJAHR (Fiscal Year), BLART (Document Type).. 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 (Deep)
SAP MCRBHD 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BELNR | Document Number of an Invoice Document | RE_BELNR | CHAR | 10 | ALPHA | BELNR | RBN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
USNAM | User name | USNAM | CHAR | 12 | Assigned to domain | XUBNAME | USR | ||
TCODE | Transaction Code | TCODE | CHAR | 20 | TSTC | TCODE | TCD | ||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
VGART | Transaction Type in AG08 (Internal Document Type) | M8VGA | CHAR | 2 | M8VGA | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
LIFNR | Different Invoicing Party | LIFRE | CHAR | 10 | LFA1 | ALPHA | LIFNR | LRE | |
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
KURSF | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
RMWWR | Gross invoice amount in document currency | RMWWR | CURR | 13(2) | WERT7 | ||||
BEZNK | Unplanned delivery costs | BEZNK | CURR | 13(2) | ANLKWERT | ||||
WMWST1 | Tax Amount in Document Currency with +/- Sign | FWSTEV | CURR | 13(2) | WERTV7 | ||||
MWSKZ1 | Tax code | MWSKZ_MRM1 | CHAR | 2 | TMRM007A | MRM_MWSKZ | |||
WMWST2 | Obsolete: tax amount in document currency - do NOT use! | FWSTEV_OLD | CURR | 13(2) | WERTV7 | ||||
MWSKZ2 | Obsolete: sales tax code | MWSKZ_MRMO | CHAR | 2 | T007A | MWSKZ | |||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
WSKTO | Cash discount amount in document currency | WSKTO | CURR | 13(2) | WERT7 | ||||
XRECH | Indicator: post invoice | XRECH | CHAR | 1 | XRADI | ||||
BKTXT | Document Header Text | BKTXT | CHAR | 25 | TEXT25 | ||||
SAPRL | SAP Release | SAPRL | CHAR | 4 | SAPRL | ||||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
XMWST | Calculate tax automatically | XMWST | CHAR | 1 | XFELD | XTX | |||
STBLG | Reversal document number | RE_STBLG | CHAR | 10 | ALPHA | BELNR | |||
STJAH | Fiscal year of reversal document | RE_STJAH | NUMC | 4 | GJAHR | GJAHR | |||
MWSKZ_BNK | Tax Code | MWSKZ_MRM | CHAR | 2 | T007A | MWSKZ | |||
TXJCD_BNK | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
IVTYP | Origin of a Logistics Invoice Verification Document | IVTYP | CHAR | 1 | IVTYP | ||||
XRBTX | Indicator: more than one tax code | XRBTX | CHAR | 1 | XFELD | ||||
REPART | Indicator: Invoice Verification Type | REPART | CHAR | 1 | REPART | ||||
RBSTAT | Invoice document status | RBSTAT | CHAR | 1 | RBSTAT | ||||
KNUMVE | Document condition - own conditions | KNUMVE | CHAR | 10 | KNUMV | ||||
KNUMVL | Document condition - vendor error | KNUMVL | CHAR | 10 | KNUMV | ||||
ARKUEN | Automatic Invoice Reduction Amount (Net) | ARKUEN | CURR | 13(2) | WERTV7 | ||||
ARKUEMW | Sales Tax Portion of Automatic Invoice Reduction Amount | ARKUEMW | CURR | 13(2) | WERTV7 | ||||
MAKZN | Manually accepted net difference amount | MAKZN | CURR | 13(2) | WERTV7 | ||||
MAKZMW | Tax Amount Accepted Manually | MAKZMW | CURR | 13(2) | WERTV7 | ||||
LIEFFN | Vendor error (exclusive of tax) | LIEFFN | CURR | 13(2) | WERTV7 | ||||
LIEFFMW | Tax in vendor error | LIEFFMW | CURR | 13(2) | WERTV7 | ||||
XAUTAKZ | Indicates automatically accepted invoices | XAUTAKZ | CHAR | 1 | XFELD | ||||
ESRNR | ISR Subscriber Number | ESRNR | CHAR | 11 | ESRNR | ||||
ESRPZ | ISR Check Digit | ESRPZ | CHAR | 2 | CHAR2 | ||||
ESRRE | ISR Reference Number | ESRRE | CHAR | 27 | ALPHA | ESRRE | |||
QSSHB | Withholding Tax Base Amount | QSSHB | CURR | 13(2) | WERT7 | ||||
QSFBT | Withholding Tax-Exempt Amount (in Document Currency) | QSFBT | CURR | 13(2) | WERT7 | ||||
QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | T059Q | QSSKZ | |||
DIEKZ | Service Indicator (Foreign Payment) | DIEKZ | CHAR | 1 | DIEKZ | ||||
LANDL | Supplying Country | LANDL | CHAR | 3 | T005 | LAND1 | |||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | T015L | LZBKZ | |||
TXKRS | Exchange Rate for Taxes | TXKRS_BKPF | DEC | 9(5) | KURSF | ||||
EMPFB | Payee/Payer | EMPFB | CHAR | 10 | ALPHA | MAXKK | |||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | T008 | ZAHLS | SPE | ||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
REBZG | Invoice Reference: Document Number for Invoice Reference | AWREF_REB | CHAR | 10 | ALPHA | AWREF | |||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
XINVE | Indicator: Capital Goods Affected? | XINVE | CHAR | 1 | XFELD | ||||
EGMLD | Reporting Country for Delivery of Goods within the EU | EGMLD_BSEZ | CHAR | 3 | Assigned to domain | LAND1 | |||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
VATDATE | Tax Reporting Date | VATDATE | DATS | 8 | DATUM | ||||
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
J_1BNFTYPE | Nota Fiscal Type | J_1BNFTYPE | CHAR | 2 | J_1BAA | J_1BNFTYPE | |||
BRNCH | Branch Number | J_1ABRNCH | CHAR | 4 | J_1BBRANCH | J_1BBRANCH | JEA | ||
ERFPR | Entry profile: Logistics Invoice Verification | ERFPR | CHAR | 12 | T169H | ERFPR | RPR | ||
SECCO | Section Code | SECCO | CHAR | 4 | SECCODE | SECCO | SECCO_ABA | ||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
LAND1 | Country Key | LAND1_GP | CHAR | 3 | Assigned to domain | LAND1 | C_LAND1 | ||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
PSKTO | Account Number of Bank Account At Post Office | PSKTO | CHAR | 16 | PSKTO | ||||
BANKN | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BANKL | Bank number | BANKL | CHAR | 15 | BANKL | BLZ | |||
BANKS | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
BKONT | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | Assigned to domain | DTAWS | |||
DTAMS | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | DTAMS | ||||
SPRAS | Character field of length 1 | CHAR_LG_01 | CHAR | 1 | CHAR_LG_01 | ||||
XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | XFELD | ||||
EMPFG | Payee code | EMPFG | CHAR | 16 | EMPFG | ||||
FITYP | Tax type | J_1AFITP_D | CHAR | 2 | Assigned to domain | J_1AFITP | |||
STCDT | Tax Number Type | J_1ATOID | CHAR | 2 | Assigned to domain | J_1ATOID | |||
STKZN | Natural Person | STKZN | CHAR | 1 | STKZN | ||||
STCD3 | Tax Number 3 | STCD3 | CHAR | 18 | CHAR18 | ||||
STCD4 | Tax Number 4 | STCD4 | CHAR | 18 | CHAR18 | ||||
BKREF | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
J_1KFREPRE | Name of Representative | REPRES | CHAR | 10 | REPRES | ||||
J_1KFTBUS | Type of Business | GESTYP | CHAR | 30 | Assigned to domain | GESTYP | |||
J_1KFTIND | Type of Industry | INDTYP | CHAR | 30 | Assigned to domain | INDTYP | |||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
ERNAME | Entered by external system user | ERNAME | CHAR | 12 | SBNAM | ||||
REINDAT | Invoice Receipt Date | REINDAT | DATS | 8 | DATUM | ||||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
FDLEV | Planning level | FDLEV | CHAR | 2 | Assigned to domain | FDLEV | FFE | ||
FDTAG | Planning date | FDTAG | DATS | 8 | DATUM | FDT | |||
ZBFIX | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
FRGKZ | Indicator: Release Required | DFRGKZ | CHAR | 1 | XFELD | ||||
ERFNAM | Name of the Processor Who Entered the Object | ERFNAM | CHAR | 12 | USNAM | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
LOTKZ | Lot Number for Documents | LOTKZ | CHAR | 10 | ALPHA | LOTKZ | LOT | ||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
INV_TRAN | Transaction in Logistics Invoice Verification | INV_TRAN | CHAR | 1 | MRM_VORGANG | ||||
PREPAY_STATUS | Prepayment Status | WRF_PREPAY_STATUS | CHAR | 1 | WRF_PREPAY_STATUS | ||||
PREPAY_AWKEY | Invoice Document Number Created for Prepayment | WRF_PREPAY_AWKEY | CHAR | 20 | AWKEY | ||||
ASSIGN_STATUS | Is the invoice in the assignment test process? | WRF_MRM_ASSIGN_STATUS | CHAR | 1 | WRF_MRM_ASSIGN_STATUS | ||||
ASSIGN_NEXT_DATE | Date of Next Assignment Test | WRF_MRM_ASSIGN_NEXT_DATE | DATS | 8 | |||||
ASSIGN_END_DATE | End Date of Assignment Test Period | WRF_MRM_ASSIGN_END_DATE | DATS | 8 | |||||
COPY_BY_BELNR | Invoice Document Number of Original Invoice | COPY_BY_BELNR | CHAR | 10 | ALPHA | BELNR | |||
COPY_BY_YEAR | Fiscal Year of Original Invoice | COPY_BY_YEAR | NUMC | 4 | GJAHR | GJAHR | |||
COPY_TO_BELNR | Invoice Document Number of Copied Invoice | COPY_TO_BELNR | CHAR | 10 | ALPHA | BELNR | |||
COPY_TO_YEAR | Fiscal Year of Copied Invoice | COPY_TO_YEAR | NUMC | 4 | GJAHR | GJAHR | |||
COPY_USER | User That Reversed and Copied the Invoice | COPY_USER | CHAR | 12 | USNAM | ||||
KURSX | Market Data Exchange Rate | GLE_FXR_DTE_RATEX28 | DEC | 28(14) | EXCRX | GLE_FXR_RATEX28 | |||
WWERT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
DIFFN | Document Balance | RPDIFN | CURR | 13(2) | WERTV7 | ||||
DIFFMW | Sales Tax Portion of the Invoice Verification Difference | DIFFMW | CURR | 13(2) | WERTV7 | ||||
MRM_ZLSPR | Logistics payment block | MRM_ZLSPR | CHAR | 1 | MRM_ZLSPR | ||||
SUPKZ | Update Indicator: BW Extraction | SUPKZD | CHAR | 1 | SUPKZD | ||||
LAUFNAME | Name of run | MCLAUFNAME | CHAR | 10 | CHAR10 | ||||
KTOPL | Chart of Accounts | KTOPL | CHAR | 4 | Assigned to domain | KTOPL | KPL | C_KTOPL | |
HWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS |
Key field | Non-key field |
How do I retrieve data from SAP structure MCRBHD using ABAP code?
As MCRBHD 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 MCRBHD as there is no data to select.How to access SAP table MCRBHD
Within an ECC or HANA version of SAP you can also view further information about MCRBHD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects