MMIV_SI_D_ROOT

Supplier Invoice Root - #GENERATED# | #transactional | Component: Logistics Invoice Verification
Column Name Description
MANDT Client
DB_KEY NodeID
Column Name Description
💲 Currency Key (WAERS):
RMWWR Gross Invoice Amount in Document Currency
BEZNK Unplanned Delivery Costs
WMWST1 Tax Amount in Document Currency with +/- Sign
WMWST2 Obsolete: tax amount in document currency - do NOT use!
WSKTO Cash Discount Amount in Document Currency
ARKUEN Automatic Invoice Reduction Amount (Net)
ARKUEMW Sales Tax Portion of Automatic Invoice Reduction Amount
MAKZN Manually accepted net difference amount
MAKZMW Tax Amount Accepted Manually
LIEFFN Supplier Error (Exclusive of Tax)
LIEFFMW Tax in Supplier Error
QSSHB Withholding Tax Base Amount
QSFBT Withholding Tax-Exempt Amount (in Document Currency)
RPZIELN Total of Items Selected
RPZIELMW VAT Portion of Target Invoice Amount in Document Currency
DIFFN Document Balance
DIFFMW Sales Tax Portion of the Invoice Verification Difference
UBNKMW Sales tax portion of unplanned delivery costs
RETNR Amount in Document Currency
RETTX Amount in Document Currency
BALANCE Document Balance
💲 Local Currency (PREPAY_HWAER):
PREPAY_AREWR Clearing Value to Prepayment Clearing Account in LC
💲 Document Currency (PREPAY_WAERS):
PREPAY_AREWW Clearing Value to Prepayment Clearing Account in TC
Column Name Description
Column Name Description
BLDAT Document Date in Document
BUDAT Posting Date in the Document
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
TXDAT Date for Determining Tax Rates
TXDAT_FROM Valid-From Date of the Tax Rate
ZFBDT Baseline Date for Due Date Calculation
VATDATE Tax Reporting Date
REINDAT Invoice Receipt Date
FDTAG Planning Date
ASSIGN_NEXT_DATE Date of Next Assignment Test
ASSIGN_END_DATE End Date of Assignment Test Period
WWERT Translation date
GLO_DAT1_HD Country/Region Specific Date 1 in the Document
GLO_DAT2_HD Country/Region Specific Date 2 in the Document
GLO_DAT3_HD Country/Region Specific Date 3 in the Document
GLO_DAT4_HD Country/Region Specific Date 4 in the Document
GLO_DAT5_HD Country/Region Specific Date 5 in the Document
FULFILLDATE Tax Fulfillment Date
REPDAT Invoice Verification date
REPTIM Invoice Verification time
LFDATABLI Delivery date
LFDATBISLI Delivery date
LFDATABRT Delivery date of return
LFDATBISRT Delivery date of return
RET_DUE_PROP Due Date for Retention (Default)
NETDT Net Due Date
Column Name Description
VGART Transaction Type in AG08 (Internal Document Type) Show values
XRECH Indicator: post invoice Show values
XMWST Calculate Tax Automatically Show values
IVTYP Origin of a Logistics Invoice Verification Document Show values
XRBTX Indicator: more than one tax code Show values
REPART Indicator: Invoice Verification Type Show values
RBSTAT Invoice document status Show values
XAUTAKZ Indicates automatically accepted invoices Show values
XINVE Indicator: Capital Goods Affected? Show values
XEGDR Indicator: Triangular Deal Within the EU Show values
STKZU Liable for VAT Show values
STKZA Indicator: Business Partner Subject to Equalization Tax? Show values
DTAMS Report key for data medium exchange Show values
XCPDK Indicator: Is the account a one-time account? Show values
STKZN Natural Person Show values
ZBFIX Fixed Payment Terms Show values
FRGKZ Indicator: Release Required Show values
INV_TRAN Transaction in Logistics Invoice Verification Show values
PREPAY_STATUS Prepayment Status Show values
ASSIGN_STATUS Is the invoice in the assignment test process? Show values
BUSINESS_NETWORK_ORIGIN Origin of the Business Network Document Show values
ISEOPBLOCKED Business Purpose Completed Show values
TMTYPE Transportation Management Version Show values
XKORREKT Indicates if the invoice is correct Show values
XNOTIZ Indicates Whether a Note Exists Show values
ANZLSM Indicator: More Than One Item with Different Del. Note. Qty Show values
XZUORDLI Indicates delivery item allocation Show values
XZUORDRT Indicates returns allocation Show values
XWARE Goods Invoice/Service Indicator Show values
XBEST Checkbox: Allocations Show values
XLIFS Checkbox: Allocations Show values
XFRBR Checkbox: Allocations Show values
XWERK Checkbox: Allocations Show values
XERFB Checkbox: Allocations Show values
BNKSEL Type of delivery cost selection Show values
XRECHL Posting logic for delivery items (invoice/credit memo) Show values
XRECHR Posting logic for returns items (invoice/credit memo) Show values
XNEGDIFF Check for Negative Variances Show values
XTRAN Checkbox: Allocations Show values
XTMTRAN Checkbox: Allocations Show values
XCONTRACT Contract Selection with SRM Contract Number Show values
XTM Checkbox: Allocations Show values
XERFB_NEW Checkbox: Allocations Show values
PREPAY_KUFIX Flag: Fixed Exchange Rate in Prepayment Document Show values
MRM_ZLSPR Logistics payment block Show values
XCPDD Indicator: Address and Bank Data Set Individually Show values
REFERENCE_DOCUMENT_CATEGORY Reference Document Category Show values
KURSF_FIXED Checkbox Show values
DUMMY1 Checkbox Show values
DUMMY3 Checkbox Show values
DRAFT_ORIGIN Supplier Invoice: Draft Origin Show values
DRAFT_EDIT_STATE Draft Edit State Show values
MWART Tax Type Show values
UX_STATUS_FI_HEADER FI Deco: Data Entry Status Code Show values
UX_STATUS_FI_VENDOR_ITEM FI Deco: Data Entry Status Code Show values
GL_ACCOUNT_ACTIVE Checkbox Show values
INCOMPLETE_ITEM_ACTIVE Checkbox Show values
DRAFT_IS_INVISIBLE Checkbox Show values
TAX_CONVERSION_NOT_ACTIVE Checkbox Show values
VORGANG Transaction Show values
XUNKLFEH Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
POSTABILITY_STATUS Postability Status for Supplier Invoice (RM08M-AMPEL) Show values
GLACCT_EDITLOKKT Data entry in local G/L account number Show values
GLACCT_MODE Mode for input into field GLACCT Show values
LOKKT_IS_ACTIVE Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
TAX_JURISDICTION_IS_ACTIVE Checkbox Show values
EXTERNAL_TAX_JURISD_IS_ACTIVE Checkbox Show values
INTERNAL_TAX_JURISD_IS_ACTIVE Checkbox Show values
HAS_MSGS_FROM_APPL_OUTPT_CTRL Checkbox Show values
HAS_MSGS_FROM_LEGCY_OUTPT_CTRL Checkbox Show values
HAS_MSGS_FROM_OUTPT_CTRL Checkbox Show values
KURSF_INVALID Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
CHINA_VAT_INVOICE_ACTIVE Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
INVOICE_UPLOAD_ORIGIN Origin of Uploaded Invoice Show values
LOCK_MODE Draft Lock Mode Show values
TAXATION_ABROAD_IS_ACTIVE Checkbox Show values
Column Name Description Domain name
BELNR Document Number of an Invoice Document BELNR
GJAHR Fiscal Year GJAHR
USNAM User Name XUBNAME
XBLNR Reference Document Number XBLNR1
KURSF Exchange rate KURSF
ZTERM Terms of payment key ZTERM
ZBD1T Cash discount days 1 ZBDXT
ZBD1P Cash discount percentage 1 PRZ23
ZBD2T Cash discount days 2 ZBDXT
ZBD2P Cash Discount Percentage 2 PRZ23
ZBD3T Net Payment Terms Period ZBDXT
BKTXT Document Header Text TEXT25
SAPRL SAP Release SAPRL
LOGSYS Logical system LOGSYS
STBLG Reversal document number BELNR
STJAH Fiscal year of reversal document GJAHR
TXJCD_BNK Tax Jurisdiction TXJCD
KNUMVE Document condition - own conditions KNUMV
KNUMVL Document Condition - Supplier Error KNUMV
ESRNR ISR subscriber number ESRNR
ESRPZ POR check digit CHAR2
ESRRE ISR/QR Reference Number ESRRE
DIEKZ Service Indicator (Foreign Payment) DIEKZ
TXKRS Exchange Rate for Taxes KURSF
CTXKRS Rate for Tax Values in Reporting Currency KURSF
EMPFB Payee/Payer MAXKK
BVTYP Partner bank type BVTYP
HKTID ID for Account Details HKTID
ZUONR Assignment number ZUONR
KIDNO Payment Reference CHAR30
REBZG Invoice reference: Document number for invoice reference AWREF
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
EGMLD Reporting Country/Region for Delivery of Goods Within the EU LAND1
HKONT General Ledger Account SAKNR
MONAT Fiscal period MONAT
NAME1 Name 1 NAME
NAME2 Name 2 NAME
NAME3 Name 3 NAME
NAME4 Name 4 NAME
PSTLZ Postal Code PSTLZ
ORT01 City TEXT35
LAND1 Country/Region Key LAND1
STRAS Street and House Number TEXT35
PFACH PO Box PFACH
PSTL2 P.O. Box Postal Code PSTLZ
PSKTO PO Bank Current Acct No. or Building Society Ref. No. PSKTO
BANKN Bank account number BANKN
BANKL Bank Number BANKL
BANKS Country/Region Key of Bank LAND1
STCD1 Tax Number 1 STCD1
STCD2 Tax Number 2 STCD2
REGIO Region (State, Province, County) REGIO
BKONT Bank Control Key BKONT
DTAWS Instruction Key for Data Medium Exchange DTAWS
SPRAS Character field of length 1 CHAR_LG_01
EMPFG Payment Recipient Code EMPFG
FITYP Tax type J_1AFITP
STCDT Tax Number Type J_1ATOID
STCD3 Tax Number 3 CHAR18
STCD4 Tax Number 4 CHAR18
BKREF Reference Details for Bank Details CHAR20
J_1KFREPRE Name of Representative REPRES
J_1KFTBUS Type of Business GESTYP
J_1KFTIND Type of Industry INDTYP
ANRED Title TEXT15
STCEG VAT Registration Number STCEG
STCD5 Tax Number 5 CHAR60
INTAD Internet address of partner company clerk TXT130
GLO_RE1_OT Country/Region specific Ref. in the One Time Account Data GLO_LOG_REF1_OT
ERNAME Entered by external system user SBNAM
UZAWE Payment method supplement UZAWE
FDLEV Planning Level FDLEV
ERFNAM Name of the Processor Who Entered the Object USNAM
FILKD Account Number of the Branch MAXKK
GSBER Business Area GSBER
LOTKZ Lot Number for Documents LOTKZ
SGTXT Item Text TEXT50
PREPAY_AWKEY Invoice Document Number Created for Prepayment AWKEY
COPY_BY_BELNR Invoice Document Number of Original Invoice BELNR
COPY_BY_YEAR Fiscal Year of Original Invoice GJAHR
COPY_TO_BELNR Invoice Document Number of Copied Invoice BELNR
COPY_TO_YEAR Fiscal Year of Copied Invoice GJAHR
COPY_USER User That Reversed and Copied the Invoice USNAM
KURSX Market Data Exchange Rate GLE_FXR_RATEX28
XREF3 Reference key for line item CHAR20
DUMMY_MMIV_SI_S_HEADER_EEW_PS MMIV_SI_S_HEADER_INCL_EEW MMIV_SI_S_HEADER_INCL_EEW
LASTCHANGEDATETIME UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
GLO_REF1_HD Country/Region Specific Reference 1 in the Document FAC_GLO_REF1_HD
GLO_REF2_HD Country/Region Specific Reference 2 in the Document FAC_GLO_REF2_HD
GLO_REF3_HD Country/Region Specific Reference 3 in the Document FAC_GLO_REF3_HD
GLO_REF4_HD Country/Region Specific Reference 4 in the Document FAC_GLO_REF4_HD
GLO_REF5_HD Country/Region Specific Reference 5 in the Document FAC_GLO_REF5_HD
GLO_BP1_HD Country/Region specific Business Partner 1 in the Document BU_PARTNER
GLO_BP2_HD Country/Region Specific Business Partner 2 in the Document BU_PARTNER
CIM_REPLICATIONTIMESTAMP UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
TAX_COUNTRY Tax Reporting Country/Region LAND1
TAX_COUNTRY_BNK Tax Reporting Country/Region LAND1
NUMPG Number of pages of invoice J_1ANOPG
ANZRPV No. of invoice verification attempts NUMC3
ANZUNF Number of unsolved errors NUMC6
ANZLIF Number of Supplier Errors NUMC6
ANZRPO Number of selected invoice items NUMC6
XBNK Planned Delivery Costs Indicator CHAR1
TBTKZ Indicator: Subsequent Debit/Credit TBTKZ
SELIF Number of the Selection Supplier LIFNR
PREPAY_KURSF Exchange Rate of Prepayment Document KURSF
PREPAY_LIFNR Supplier Account Number in Prepayment Document LIFNR
ADRNR Address ADRNR
PENRC Reason for Late Payment CHAR2
BAPI_EXTBLNR Document Number of an Invoice Document BELNR
BAPI_PROCESS Single-Character Flag CHAR1
IS_DRAFT Indicator for Draft in S-Innovations CHAR1
LIFNR_ENTERED Attribute has been Entered INT1
WAERS_ENTERED Attribute has been Entered INT1
PYMNT_TERMS_ENTERED Attribute has been Entered INT1
PYMNT_CONDITION_ENTERED Attribute has been Entered INT1
CREA_DATE_TIME UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
CREA_UNAME User Name UNAME
LCHG_DATE_TIME UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
LCHG_UNAME User Name UNAME
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
CHANGE_STATE_ID Hash Value (160 Bits)
LAND1_T001 Country/Region Key LAND1
UX_FC_BUKRS UI Field Control Byte (Should be defined centrally) INT1
UX_FC_BLDAT_TS UI Field Control Byte (Should be defined centrally) INT1
UX_FC_BUDAT_TS UI Field Control Byte (Should be defined centrally) INT1
UX_FC_BLDAT UI Field Control Byte (Should be defined centrally) INT1
UX_FC_BUDAT UI Field Control Byte (Should be defined centrally) INT1
UX_FC_LIFNR UI Field Control Byte (Should be defined centrally) INT1
UX_FC_RMWWR UI Field Control Byte (Should be defined centrally) INT1
UX_FC_WAERS UI Field Control Byte (Should be defined centrally) INT1
UX_FC_MWSKZ_BNK UI Field Control Byte (Should be defined centrally) INT1
UX_FC_TXJCD_BNK UI Field Control Byte (Should be defined centrally) INT1
UX_FC_BLART UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ZUONR UI Field Control Byte (Should be defined centrally) INT1
UX_FC_SGTXT UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ZFBDT UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ZBD1T UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ZBD1P UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ZBD2T UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ZBD2P UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ZBD3T UI Field Control Byte (Should be defined centrally) INT1
UX_FC_WSKTO UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ZLSCH UI Field Control Byte (Should be defined centrally) INT1
UX_FC_REBZG UI Field Control Byte (Should be defined centrally) INT1
UX_FC_REBZJ UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ZTERM UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ZBFIX UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ZLSPR UI Field Control Byte (Should be defined centrally) INT1
UX_FC_TXJCD_BNK_EXT UI Field Control Byte (Should be defined centrally) INT1
UX_FC_TXJCD_BNK_INT UI Field Control Byte (Should be defined centrally) INT1
UX_FC_KURSF UI Field Control Byte (Should be defined centrally) INT1
UX_FC_LZBKZ UI Field Control Byte (Should be defined centrally) INT1
UX_FC_LANDL UI Field Control Byte (Should be defined centrally) INT1
UX_FC_VATDATE UI Field Control Byte (Should be defined centrally) INT1
UX_FC_BVTYP UI Field Control Byte (Should be defined centrally) INT1
UX_FC_XBLNR UI Field Control Byte (Should be defined centrally) INT1
UX_FC_BKTXT UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ESRNR UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ESRPZ UI Field Control Byte (Should be defined centrally) INT1
UX_FC_ESRRE UI Field Control Byte (Should be defined centrally) INT1
UX_FC_BUPLA UI Field Control Byte (Should be defined centrally) INT1
UX_FC_KIDNO UI Field Control Byte (Should be defined centrally) INT1
UX_FC_IBAN UI Field Control Byte (Should be defined centrally) INT1
UX_FC_SWIFT UI Field Control Byte (Should be defined centrally) INT1
UX_FC_BANKA UI Field Control Byte (Should be defined centrally) INT1
UX_FC_APPROVAL_STATUS UI Field Control Byte (Should be defined centrally) INT1
UX_FC_APPROVER UI Field Control Byte (Should be defined centrally) INT1
UX_FC_SECCO UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GSBER UI Field Control Byte (Should be defined centrally) INT1
UX_FC_WF_WORKITEMS_EXIST UI Field Control Byte (Should be defined centrally) INT1
UX_FC_WF_BLOCKED_IV_EXIST UI Field Control Byte (Should be defined centrally) INT1
UX_FC_WF_COMPLETED_IV_EXIST UI Field Control Byte (Should be defined centrally) INT1
UX_FC_REINDAT UI Field Control Byte (Should be defined centrally) INT1
UX_FC_UZAWE UI Field Control Byte (Should be defined centrally) INT1
UX_FC_EGMLD UI Field Control Byte (Should be defined centrally) INT1
UX_FC_STCEG UI Field Control Byte (Should be defined centrally) INT1
UX_FC_XEGDR UI Field Control Byte (Should be defined centrally) INT1
UX_FC_TXDAT UI Field Control Byte (Should be defined centrally) INT1
UX_FC_HBKID UI Field Control Byte (Should be defined centrally) INT1
UX_FC_HKTID UI Field Control Byte (Should be defined centrally) INT1
UX_FC_TAX_COUNTRY_BNK UI Field Control Byte (Should be defined centrally) INT1
UX_FC_VORGANG UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GLO_REF1_HD UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GLO_DAT1_HD UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GLO_REF2_HD UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GLO_DAT2_HD UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GLO_REF3_HD UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GLO_DAT3_HD UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GLO_REF4_HD UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GLO_DAT4_HD UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GLO_REF5_HD UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GLO_DAT5_HD UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GLO_BP1_HD UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GLO_BP2_HD UI Field Control Byte (Should be defined centrally) INT1
UX_FC_PREPAY_STATUS UI Field Control Byte (Should be defined centrally) INT1
UX_FC_BEZNK UI Field Control Byte (Should be defined centrally) INT1
UX_FC_NETDT UI Field Control Byte (Should be defined centrally) INT1
UX_FC_GST_PART UI Field Control Byte (Should be defined centrally) INT1
UX_FC_PLC_SUP UI Field Control Byte (Should be defined centrally) INT1
UX_FC_FULFILLDATE UI Field Control Byte (Should be defined centrally) INT1
TAXES_ENTERED Attribute has been Entered INT1
TXJCD_BNK_EXT Tax Jurisdiction TXJCD
TAXCODE_TXT_BNK Tax rates for a tax code TEXT50
BANKA Name of Financial Institution TEXT60
SWIFT SWIFT/BIC for International Payments SWIFT
IBAN IBAN (International Bank Account Number) IBAN
EXCHANGE_RATE_EXT Exchange Rate FAC_KURSF_EXT
INVOICE_UPLOAD_UUID UUID of Invoice Upload MRM_SI_GUID
TXDAT_ENTERED Attribute has been Entered INT1
GLO_REF1_HD_LBL Medium Field Label SCRTEXT_M
GLO_DAT1_HD_LBL Medium Field Label SCRTEXT_M
GLO_REF2_HD_LBL Medium Field Label SCRTEXT_M
GLO_DAT2_HD_LBL Medium Field Label SCRTEXT_M
GLO_REF3_HD_LBL Medium Field Label SCRTEXT_M
GLO_DAT3_HD_LBL Medium Field Label SCRTEXT_M
GLO_REF4_HD_LBL Medium Field Label SCRTEXT_M
GLO_DAT4_HD_LBL Medium Field Label SCRTEXT_M
GLO_REF5_HD_LBL Medium Field Label SCRTEXT_M
GLO_DAT5_HD_LBL Medium Field Label SCRTEXT_M
GLO_BP1_HD_LBL Medium Field Label SCRTEXT_M
GLO_BP2_HD_LBL Medium Field Label SCRTEXT_M
GST_PART GST Partner J_1IG_PARTNER
IRN Invoice Reference Number J_1IG_IRN
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • MMIV_SI_D_ROOT.BLART == T003.BLART
  • MMIV_SI_D_ROOT.MANDT == T003.MANDT
Branch Number
  • Company Code
  • Branch Number
  • Client
  • ?
  • MMIV_SI_D_ROOT.BUKRS == J_1BBRANCH.BUKRS
  • MMIV_SI_D_ROOT.BRNCH == J_1BBRANCH.BRANCH
  • MMIV_SI_D_ROOT.MANDT == J_1BBRANCH.MANDT
  • MMIV_SI_D_ROOT.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
Company Code
  • MMIV_SI_D_ROOT.MANDT == T001.MANDT
  • MMIV_SI_D_ROOT.BUKRS == T001.BUKRS
Entry profile: Logistics Invoice Verification
  • MMIV_SI_D_ROOT.MANDT == T169H.MANDT
  • MMIV_SI_D_ROOT.ERFPR == T169H.ERFPR
Short Key for a House Bank
  • Short Key for a House Bank
  • Company Code
  • MMIV_SI_D_ROOT.MANDT == T012.MANDT
  • MMIV_SI_D_ROOT.HBKID == T012.HBKID
  • MMIV_SI_D_ROOT.BUKRS == T012.BUKRS
Nota Fiscal Type
  • Nota Fiscal Type
  • Client
  • MMIV_SI_D_ROOT.J_1BNFTYPE == J_1BAA.NFTYPE
  • MMIV_SI_D_ROOT.MANDT == J_1BAA.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • MMIV_SI_D_ROOT.LANDL == T005.LAND1
  • MMIV_SI_D_ROOT.MANDT == T005.MANDT
Different Invoicing Party
  • MMIV_SI_D_ROOT.MANDT == LFA1.MANDT
  • MMIV_SI_D_ROOT.LIFNR == LFA1.LIFNR
State Central Bank Indicator
  • MMIV_SI_D_ROOT.MANDT == T015L.MANDT
  • MMIV_SI_D_ROOT.LZBKZ == T015L.LZBKZ
FK Tax code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Obsolete: sales tax code
  • MMIV_SI_D_ROOT.MANDT == T007A.MANDT
  • MMIV_SI_D_ROOT.KALSM == T007A.KALSM
  • MMIV_SI_D_ROOT.MWSKZ2 == T007A.MWSKZ
Tax Code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Tax Code
  • MMIV_SI_D_ROOT.MANDT == T007A.MANDT
  • MMIV_SI_D_ROOT.KALSM == T007A.KALSM
  • MMIV_SI_D_ROOT.MWSKZ_BNK == T007A.MWSKZ
Place of Supply
  • ?
  • Place of Supply
  • MMIV_SI_D_ROOT.MANDT == T005S.MANDT
  • MMIV_SI_D_ROOT.[column in domain "LAND1"] == T005S.LAND1
  • MMIV_SI_D_ROOT.PLC_SUP == T005S.BLAND
Withholding Tax Code
  • Supplying Country/Region
  • Client
  • Withholding Tax Code
  • MMIV_SI_D_ROOT.LANDL == T059Q.LAND1
  • MMIV_SI_D_ROOT.MANDT == T059Q.MANDT
  • MMIV_SI_D_ROOT.QSSKZ == T059Q.QSSKZ
Section Code
  • Company Code
  • Section Code
  • Client
  • MMIV_SI_D_ROOT.BUKRS == SECCODE.BUKRS
  • MMIV_SI_D_ROOT.SECCO == SECCODE.SECCODE
  • MMIV_SI_D_ROOT.MANDT == SECCODE.MANDT
Currency Key
  • MMIV_SI_D_ROOT.MANDT == TCURC.MANDT
  • MMIV_SI_D_ROOT.WAERS == TCURC.WAERS
Payment Method
  • Payment Method
  • Country/Region Key
  • MMIV_SI_D_ROOT.MANDT == T042Z.MANDT
  • MMIV_SI_D_ROOT.ZLSCH == T042Z.ZLSCH
  • MMIV_SI_D_ROOT.LAND1 == T042Z.LAND1
Payment Block Key
  • Payment Block Key
  • Client
  • MMIV_SI_D_ROOT.ZLSPR == T008.ZAHLS
  • MMIV_SI_D_ROOT.MANDT == T008.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Tax code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • Tax code
  • ?
  • MMIV_SI_D_ROOT.KALSM == TMRM007A.KALSM
  • MMIV_SI_D_ROOT.MANDT == TMRM007A.MANDT
  • MMIV_SI_D_ROOT.MWSKZ1 == TMRM007A.MWSKZ
  • MMIV_SI_D_ROOT.[column in domain "KOART_MWSKZ"] == TMRM007A.KOART