SAP MCRBHD Table in S/4 HANA - Header Data









MCRBHD is a standard SAP Table which is used to store Header Data data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MCRBHD table(ECC)

Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Structure
Database Table: MCRBHD


MCRBHD table structure field list

Below is the full MCRBHD field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field


Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP SHLP Field
MANDTClientMANDTCLNT3(0) T000MANDT
BELNRDocument Number of an Invoice DocumentRE_BELNRCHAR10(0) ALPHABELNRRBN
GJAHRFiscal YearGJAHRNUMC4(0) GJAHRGJAHRGJR
BLARTDocument typeBLARTCHAR2(0) T003BLARTBAR
BLDATDocument Date in DocumentBLDATDATS8(0) DATUM
BUDATPosting Date in the DocumentBUDATDATS8(0) DATUM
USNAMUser NameUSNAMCHAR12(0) Assigned to domainXUBNAMEUSR
TCODETransaction CodeTCODECHAR20(0) TSTCTCODETCD
CPUDTDay On Which Accounting Document Was EnteredCPUDTDATS8(0) DATUM
CPUTMTime of EntryCPUTMTIMS6(0) UZEIT
VGARTTransaction Type in AG08 (Internal Document Type)M8VGACHAR2(0) M8VGA
XBLNRReference Document NumberXBLNR1CHAR16(0) XBLNR1
BUKRSCompany CodeBUKRSCHAR4(0) T001BUKRSBUKC_T001BUKRS
LIFNRDifferent Invoicing PartyLIFRECHAR10(0) LFA1ALPHALIFNRLRE
WAERSCurrency KeyWAERSCUKY5(0) TCURCWAERSFWS
KURSFExchange rateKURSFDEC9(5) EXCRTKURSF
RMWWRGross Invoice Amount in Document CurrencyRMWWRCURR13(2) WERT7
BEZNKUnplanned Delivery CostsBEZNKCURR13(2) ANLKWERT
TXDATDate for defining tax ratesTXDATDATS8(0) DATUM
TXDAT_FROMValid-From Date of the Tax RateFOT_TXDAT_FROMDATS8(0)
WMWST1Tax Amount in Document Currency with +/- SignFWSTEVCURR13(2) WERTV7
MWSKZ1Tax codeMWSKZ_MRM1CHAR2(0) TMRM007AMRM_MWSKZ
WMWST2Obsolete: tax amount in document currency - do NOT use!FWSTEV_OLDCURR13(2) WERTV7
MWSKZ2Obsolete: sales tax codeMWSKZ_MRMOCHAR2(0) T007AMWSKZ
ZTERMTerms of payment keyDZTERMCHAR4(0) ZTERM
ZBD1TCash discount days 1DZBD1TDEC3(0) ZBDXT
ZBD1PCash discount percentage 1DZBD1PDEC5(3) PRZ23
ZBD2TCash discount days 2DZBD2TDEC3(0) ZBDXT
ZBD2PCash Discount Percentage 2DZBD2PDEC5(3) PRZ23
ZBD3TNet Payment Terms PeriodDZBD3TDEC3(0) ZBDXT
WSKTOCash Discount Amount in Document CurrencyWSKTO_CSCURR13(2) WERT7
XRECHIndicator: post invoiceXRECHCHAR1(0) XRADI
BKTXTDocument Header TextBKTXTCHAR25(0) TEXT25
SAPRLSAP ReleaseSAPRLCHAR4(0) SAPRL
LOGSYSLogical systemLOGSYSCHAR10(0) Assigned to domainALPHALOGSYS
XMWSTCalculate Tax AutomaticallyXMWSTCHAR1(0) XFELDXTX
STBLGReversal document numberRE_STBLGCHAR10(0) ALPHABELNR
STJAHFiscal year of reversal documentRE_STJAHNUMC4(0) GJAHRGJAHR
MWSKZ_BNKTax CodeMWSKZ_MRMCHAR2(0) T007AMWSKZ
TXJCD_BNKTax JurisdictionTXJCDCHAR15(0) Assigned to domainTXJCDTXJ
IVTYPOrigin of a Logistics Invoice Verification DocumentIVTYPCHAR1(0) IVTYP
XRBTXIndicator: more than one tax codeXRBTXCHAR1(0) XFELD
REPARTIndicator: Invoice Verification TypeREPARTCHAR1(0) REPART
RBSTATInvoice document statusRBSTATCHAR1(0) RBSTAT
KNUMVEDocument condition - own conditionsKNUMVECHAR10(0) KNUMV
KNUMVLDocument Condition - Supplier ErrorKNUMVLCHAR10(0) KNUMV
ARKUENAutomatic Invoice Reduction Amount (Net)ARKUENCURR13(2) WERTV7
ARKUEMWSales Tax Portion of Automatic Invoice Reduction AmountARKUEMWCURR13(2) WERTV7
MAKZNManually accepted net difference amountMAKZNCURR13(2) WERTV7
MAKZMWTax Amount Accepted ManuallyMAKZMWCURR13(2) WERTV7
LIEFFNSupplier Error (Exclusive of Tax)LIEFFNCURR13(2) WERTV7
LIEFFMWTax in Supplier ErrorLIEFFMWCURR13(2) WERTV7
XAUTAKZIndicates automatically accepted invoicesXAUTAKZCHAR1(0) XFELD
ESRNRISR subscriber numberESRNRCHAR11(0) ESRNR
ESRPZPOR check digitESRPZCHAR2(0) CHAR2
ESRREISR/QR Reference NumberESRRECHAR27(0) ALPHAESRRE
QSSHBWithholding Tax Base AmountQSSHB_CSCURR13(2) WERT7
QSFBTWithholding Tax-Exempt Amount (in Document Currency)QSFBT_CSCURR13(2) WERT7
QSSKZWithholding Tax CodeQSSKZCHAR2(0) T059QQSSKZ
DIEKZService Indicator (Foreign Payment)DIEKZCHAR1(0) DIEKZ
LANDLSupplying CountryLANDLCHAR3(0) T005LAND1
LZBKZState Central Bank IndicatorLZBKZCHAR3(0) T015LLZBKZ
TXKRSExchange Rate for TaxesTXKRS_BKPFDEC9(5) KURSF
CTXKRSRate for Tax Values in Local Currency (Plants Abroad)CTXKRSDEC9(5) EXCRTKURSF
EMPFBPayee/PayerEMPFBCHAR10(0) ALPHAMAXKK
BVTYPPartner bank typeBVTYPCHAR4(0) BVTYP
HBKIDShort key for a house bankHBKIDCHAR5(0) T012HBKID
ZUONRAssignment numberDZUONRCHAR18(0) ZUONR
ZLSPRPayment Block KeyDZLSPRCHAR1(0) T008ZAHLSSPE
ZLSCHPayment MethodDZLSCHCHAR1(0) T042ZZLSCH
ZFBDTBaseline Date for Due Date CalculationDZFBDTDATS8(0) DATUM
KIDNOPayment ReferenceKIDNOCHAR30(0) CHAR30
REBZGInvoice reference: Document number for invoice referenceAWREF_REBCHAR10(0) ALPHAAWREF
REBZJFiscal Year of the Relevant Invoice (for Credit Memo)REBZJNUMC4(0) GJAHRGJAHR
XINVEIndicator: Capital Goods Affected?XINVECHAR1(0) XFELD
EGMLDReporting Country for Delivery of Goods Within the EUEGMLD_BSEZCHAR3(0) Assigned to domainLAND1
XEGDRIndicator: Triangular Deal Within the EU?XEGDRCHAR1(0) XFELD
VATDATETax Reporting DateVATDATEDATS8(0) DATUM
HKONTGeneral Ledger AccountHKONTCHAR10(0) Assigned to domainALPHASAKNR
MONATFiscal periodMONATNUMC2(0) MONAT
J_1BNFTYPENota Fiscal TypeJ_1BNFTYPECHAR2(0) J_1BAAJ_1BNFTYPE
BRNCHBranch NumberJ_1ABRNCHCHAR4(0) J_1BBRANCHJ_1BBRANCHJEA
ERFPREntry profile: Logistics Invoice VerificationERFPRCHAR12(0) T169HERFPRRPR
SECCOSection CodeSECCOCHAR4(0) SECCODESECCOSECCO_ABASECCODE
NAME1Name 1NAME1_GPCHAR35(0) NAME
NAME2Name 2NAME2_GPCHAR35(0) NAME
NAME3Name 3NAME3_GPCHAR35(0) NAME
NAME4Name 4NAME4_GPCHAR35(0) NAME
PSTLZPostal CodePSTLZCHAR10(0) PSTLZ
ORT01CityORT01_GPCHAR35(0) TEXT35
LAND1Country KeyLAND1_GPCHAR3(0) LAND1C_LAND1LAND1
STRASStreet and House NumberSTRAS_GPCHAR35(0) TEXT35
PFACHPO BoxPFACHCHAR10(0) PFACH
PSTL2P.O. Box Postal CodePSTL2CHAR10(0) PSTLZ
PSKTOAccount Number of Bank Account At Post OfficePSKTOCHAR16(0) PSKTO
BANKNBank account numberBANKNCHAR18(0) BANKN
BANKLBank numberBANKLCHAR15(0) BANKLBLZ
BANKSBank country keyBANKSCHAR3(0) Assigned to domainLAND1BKL
STCD1Tax Number 1STCD1CHAR16(0) STCD1
STCD2Tax Number 2STCD2CHAR11(0) STCD2
STKZULiable for VATSTKZUCHAR1(0) XFELD
STKZAIndicator: Business Partner Subject to Equalization Tax?STKZACHAR1(0) STKZA
REGIORegion (State, Province, County)REGIOCHAR3(0) Assigned to domainREGIO
BKONTBank Control KeyBKONTCHAR2(0) BKONT
DTAWSInstruction key for data medium exchangeDTAWSCHAR2(0) Assigned to domainDTAWS
DTAMSReport key for data medium exchangeDTAMSCHAR1(0) DTAMS
SPRASCharacter field of length 1CHAR_LG_01CHAR1(0) CHAR_LG_01
XCPDKIndicator: Is the account a one-time account?XCPDKCHAR1(0) XFELD
EMPFGPayee codeEMPFGCHAR16(0) EMPFG
FITYPTax typeJ_1AFITP_DCHAR2(0) Assigned to domainJ_1AFITP
STCDTTax Number TypeJ_1ATOIDCHAR2(0) Assigned to domainJ_1ATOID
STKZNNatural PersonSTKZNCHAR1(0) STKZN
STCD3Tax Number 3STCD3CHAR18(0) CHAR18
STCD4Tax Number 4STCD4CHAR18(0) CHAR18
BKREFReference specifications for bank detailsBKREFCHAR20(0) CHAR20
J_1KFREPREName of RepresentativeREPRESCHAR10(0) REPRES
J_1KFTBUSType of BusinessGESTYPCHAR30(0) Assigned to domainGESTYP
J_1KFTINDType of IndustryINDTYPCHAR30(0) Assigned to domainINDTYP
ANREDTitleANREDCHAR15(0) TEXT15
STCEGVAT Registration NumberSTCEGCHAR20(0) STCEG
STCD5Tax Number 5STCD5CHAR60(0) CHAR60
INTADInternet address of partner company clerkINTADCHAR130(0) TXT130
ERNAMEEntered by external system userERNAMECHAR12(0) SBNAM
REINDATInvoice Receipt DateREINDATDATS8(0) DATUM
UZAWEPayment method supplementUZAWECHAR2(0) Assigned to domainUZAWE
FDLEVPlanning LevelFDLEVCHAR2(0) Assigned to domainFDLEVFFE
FDTAGPlanning DateFDTAGDATS8(0) DATUMFDT
ZBFIXFixed Payment TermsDZBFIXCHAR1(0) ZBFIX
FRGKZIndicator: Release RequiredDFRGKZCHAR1(0) XFELD
ERFNAMName of the Processor Who Entered the ObjectERFNAMCHAR12(0) USNAM
BUPLABusiness PlaceBUPLACHAR4(0) Assigned to domainJ_1BBRANCH
FILKDAccount Number of the BranchFILKDCHAR10(0) ALPHAMAXKK
GSBERBusiness AreaGSBERCHAR4(0) Assigned to domainGSBERGSB
LOTKZLot Number for DocumentsLOTKZCHAR10(0) ALPHALOTKZLOT
SGTXTItem TextSGTXTCHAR50(0) TEXT50
INV_TRANTransaction in Logistics Invoice VerificationINV_TRANCHAR1(0) MRM_VORGANG
PREPAY_STATUSPrepayment StatusWRF_PREPAY_STATUSCHAR1(0) WRF_PREPAY_STATUS
PREPAY_AWKEYInvoice Document Number Created for PrepaymentWRF_PREPAY_AWKEYCHAR20(0) AWKEY
ASSIGN_STATUSIs the invoice in the assignment test process?WRF_MRM_ASSIGN_STATUSCHAR1(0) WRF_MRM_ASSIGN_STATUS
ASSIGN_NEXT_DATEDate of Next Assignment TestWRF_MRM_ASSIGN_NEXT_DATEDATS8(0)
ASSIGN_END_DATEEnd Date of Assignment Test PeriodWRF_MRM_ASSIGN_END_DATEDATS8(0)
COPY_BY_BELNRInvoice Document Number of Original InvoiceCOPY_BY_BELNRCHAR10(0) ALPHABELNR
COPY_BY_YEARFiscal Year of Original InvoiceCOPY_BY_YEARNUMC4(0) GJAHRGJAHR
COPY_TO_BELNRInvoice Document Number of Copied InvoiceCOPY_TO_BELNRCHAR10(0) ALPHABELNR
COPY_TO_YEARFiscal Year of Copied InvoiceCOPY_TO_YEARNUMC4(0) GJAHRGJAHR
COPY_USERUser That Reversed and Copied the InvoiceCOPY_USERCHAR12(0) USNAM
KURSXMarket Data Exchange RateGLE_FXR_DTE_RATEX28DEC28(14) EXCRXGLE_FXR_RATEX28
WWERTTranslation dateWWERT_DDATS8(0) DATUM
XREF3Reference key for line itemXREF3CHAR20(0) CHAR20
DUMMY_MMIV_SI_S_HEADER_EEW_PSMMIV_SI_S_HEADER_INCL_EEWMMIV_SI_S_HEADER_INCL_EEWCHAR1(0) MMIV_SI_S_HEADER_INCL_EEW
BUSINESS_NETWORK_ORIGINOrigin of the Business Network DocumentMRM_BUSINESS_NETWORK_ORIGINCHAR2(0) MRM_BUSINESS_NETWORK_ORIGIN
ISEOPBLOCKEDBusiness Purpose CompletedEOPBLOCKEDCHAR1(0) EOPBLOCKED
LASTCHANGEDATETIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)TIMESTAMPLDEC21(7) TZNTSTMPL
GLO_REF1_HDCountry Specific Reference 1 in the DocumentFAC_GLO_REF1_HDCHAR80(0) FAC_GLO_REF1_HD
GLO_DAT1_HDCountry Specific Date 1 in the DocumentFAC_GLO_DAT1_HDDATS8(0) DATUM
GLO_REF2_HDCountry specific Reference 2 in the DocumentFAC_GLO_REF2_HDCHAR25(0) FAC_GLO_REF2_HD
GLO_DAT2_HDCountry specific Date 2 in the DocumentFAC_GLO_DAT2_HDDATS8(0) DATUM
GLO_REF3_HDCountry specific Reference 3 in the DocumentFAC_GLO_REF3_HDCHAR25(0) FAC_GLO_REF3_HD
GLO_DAT3_HDCountry specific Date 3 in the DocumentFAC_GLO_DAT3_HDDATS8(0) DATUM
GLO_REF4_HDCountry specific Reference 4 in the DocumentFAC_GLO_REF4_HDCHAR50(0) FAC_GLO_REF4_HD
GLO_DAT4_HDCountry specific Date 4 in the DocumentFAC_GLO_DAT4_HDDATS8(0) DATUM
GLO_REF5_HDCountry specific Reference 5 in the DocumentFAC_GLO_REF5_HDCHAR50(0) FAC_GLO_REF5_HD
GLO_DAT5_HDCountry specific Date 5 in the DocumentFAC_GLO_DAT5_HDDATS8(0) DATUM
GLO_BP1_HDCountry specific Business Partner 1 in the DocumentFAC_GLO_BP1_HDCHAR10(0) Assigned to domainALPHABU_PARTNER
GLO_BP2_HDCountry specific Business Partner 2 in the DocumentFAC_GLO_BP2_HDCHAR10(0) Assigned to domainALPHABU_PARTNER
CIM_REPLICATIONTIMESTAMPUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)TIMESTAMPLDEC21(7) TZNTSTMPL
NODE_KEYGUID: MM Supplier Invoice in S-InnovationsMRM_SI_GUIDRAW16(0) MRM_SI_GUID
PARENT_KEYGUID: MM Supplier Invoice in S-InnovationsMRM_SI_GUIDRAW16(0) MRM_SI_GUID
ROOT_KEYGUID: MM Supplier Invoice in S-InnovationsMRM_SI_GUIDRAW16(0) MRM_SI_GUID
J_1TPBUPLBranch CodeBCODECHAR5(0) BCODE
LOGMX_UUIDMexico UUIDLOGMX_UUIDCHAR36(0)
.INCLU--AP0(0)
ANXTYPEInvoice Type/ILE/TMTYPCHAR1(0) XFELD
ANXAMNTAnnexation Amount/ILE/TMANXACURR13(2) ANLKWERT
ANXPERCAnnexation Percentage/ILE/TMANXPDEC6(3) DEC3_3V
ZVAT_INDCVAT indicator contain run date of vat file/ILE/TVAT_INDCDATS8(0) /ILE/TVAT_INDC
/ILE/PARKSelectMARKECHAR1(0) CHAR1
/ILE/HOLDSelectMARKECHAR1(0) CHAR1
/ILE/BAPI_SAVESelectMARKECHAR1(0) CHAR1
.INCLU--AP0(0)
GST_PARTGST PartnerJ_1IG_PARTNERCHAR10(0) ALPHAJ_1IG_PARTNER
PLC_SUPPlace of SupplyJ_1IG_REGIONCHAR3(0) T005SREGIO
.INCLU--AP0(0)
PYBASTYPType of Payment Basis DocumentSAFM_AP_PYBSTYPCHAR2(0) SAFM_AP_PYBSTYP
PYBASNOPayment Basis Document NumberSAFM_AP_PYBSNOCHAR16(0) SAFM_AP_PYBSNO
PYBASDATPayment Basis Document DateSAFM_AP_PYBSDATDATS8(0) DATS
PYIBANIBAN (International Bank Account Number)IBANCHAR34(0) IBAN
INWARDNO_HDIncoming Document NumberSAFM_AP_INWARD_NOCHAR30(0)
INWARDDT_HDIncoming Document DateSAFM_AP_INWARD_DTDATS8(0) DATS
DIFFNDocument BalanceRPDIFNCURR13(2) WERTV7
DIFFMWSales Tax Portion of the Invoice Verification DifferenceDIFFMWCURR13(2) WERTV7
MRM_ZLSPRLogistics payment blockMRM_ZLSPRCHAR1(0) MRM_ZLSPR
SUPKZUpdate Indicator: BW ExtractionSUPKZDCHAR1(0) SUPKZD
LAUFNAMEName of runMCLAUFNAMECHAR10(0) CHAR10
KTOPLChart of AccountsKTOPLCHAR4(0) KTOPLKPLC_KTOPLKTOPL
HWAERLocal CurrencyHWAERCUKY5(0) WAERS




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!