SupplierInvoice

Proxy View for Supplier Invoice | view: SUPPLINV | TRAN | Extraction: Not supported | Component: Logistics Invoice Verification
Tables used: RBKP
Column Name Description
BELNR Document Number of an Invoice Document
GJAHR Fiscal Year
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)
ANXAMNT Annexation Amount
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
ZVAT_INDC VAT indicator contain run date of vat file
PYBASDAT Payment Basis Document Date
INWARDDT_HD Incoming Document 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
ANXTYPE Invoice Type Show values
Column Name Description Domain name
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
NODE_KEY GUID: MM Supplier Invoice in S-Innovations MRM_SI_GUID
PARENT_KEY GUID: MM Supplier Invoice in S-Innovations MRM_SI_GUID
ROOT_KEY GUID: MM Supplier Invoice in S-Innovations MRM_SI_GUID
J_1TPBUPL Branch Code BCODE
LOGMX_UUID (obsolete) Mexico UUID
ANXPERC Annexation Percentage DEC3_3V
/ILE/PARK Select CHAR1
/ILE/HOLD Select CHAR1
/ILE/BAPI_SAVE Select CHAR1
GST_PART GST Partner J_1IG_PARTNER
IRN Invoice Reference Number J_1IG_IRN
PYBASTYP Type of Payment Basis Document SAFM_AP_PYBSTYP
PYBASNO Payment Basis Document Number SAFM_AP_PYBSNO
PYIBAN IBAN (International Bank Account Number) IBAN
INWARDNO_HD Incoming Document Number
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • SUPPLIERINVOICE.BLART == T003.BLART
  • SUPPLIERINVOICE.MANDT == T003.MANDT
Branch Number
  • Branch Number
  • ?
  • Company Code
  • Client
  • SUPPLIERINVOICE.BRNCH == J_1BBRANCH.BRANCH
  • SUPPLIERINVOICE.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
  • SUPPLIERINVOICE.BUKRS == J_1BBRANCH.BUKRS
  • SUPPLIERINVOICE.MANDT == J_1BBRANCH.MANDT
Company Code
  • Company Code
  • Client
  • SUPPLIERINVOICE.BUKRS == T001.BUKRS
  • SUPPLIERINVOICE.MANDT == T001.MANDT
Entry profile: Logistics Invoice Verification
  • Client
  • Entry profile: Logistics Invoice Verification
  • SUPPLIERINVOICE.MANDT == T169H.MANDT
  • SUPPLIERINVOICE.ERFPR == T169H.ERFPR
Allowed house banks
  • Short Key for a House Bank
  • Company Code
  • Client
  • SUPPLIERINVOICE.HBKID == T012.HBKID
  • SUPPLIERINVOICE.BUKRS == T012.BUKRS
  • SUPPLIERINVOICE.MANDT == T012.MANDT
Nota Fiscal Type
  • Nota Fiscal Type
  • Client
  • SUPPLIERINVOICE.J_1BNFTYPE == J_1BAA.NFTYPE
  • SUPPLIERINVOICE.MANDT == J_1BAA.MANDT
FK Supplying country
  • Client
  • Supplying Country/Region
  • SUPPLIERINVOICE.MANDT == T005.MANDT
  • SUPPLIERINVOICE.LANDL == T005.LAND1
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • SUPPLIERINVOICE.MANDT == LFA1.MANDT
  • SUPPLIERINVOICE.LIFNR == LFA1.LIFNR
FK State central bank indicator
  • State Central Bank Indicator
  • Client
  • SUPPLIERINVOICE.LZBKZ == T015L.LZBKZ
  • SUPPLIERINVOICE.MANDT == T015L.MANDT
Obsolete: sales tax code
  • ?
  • Client
  • Obsolete: sales tax code
  • SUPPLIERINVOICE.[column in domain "KALSM_D"] == T007A.KALSM
  • SUPPLIERINVOICE.MANDT == T007A.MANDT
  • SUPPLIERINVOICE.MWSKZ2 == T007A.MWSKZ
Tax Code
  • Tax Code
  • ?
  • Client
  • SUPPLIERINVOICE.MWSKZ_BNK == T007A.MWSKZ
  • SUPPLIERINVOICE.[column in domain "KALSM_D"] == T007A.KALSM
  • SUPPLIERINVOICE.MANDT == T007A.MANDT
Place of Supply
  • Place of Supply
  • ?
  • Client
  • SUPPLIERINVOICE.PLC_SUP == T005S.BLAND
  • SUPPLIERINVOICE.[column in domain "LAND1"] == T005S.LAND1
  • SUPPLIERINVOICE.MANDT == T005S.MANDT
FK Withholding tax code
  • Withholding Tax Code
  • Client
  • Supplying Country/Region
  • SUPPLIERINVOICE.QSSKZ == T059Q.QSSKZ
  • SUPPLIERINVOICE.MANDT == T059Q.MANDT
  • SUPPLIERINVOICE.LANDL == T059Q.LAND1
Section Code
  • Section Code
  • Company Code
  • Client
  • SUPPLIERINVOICE.SECCO == SECCODE.SECCODE
  • SUPPLIERINVOICE.BUKRS == SECCODE.BUKRS
  • SUPPLIERINVOICE.MANDT == SECCODE.MANDT
Currency Key
  • Client
  • Currency Key
  • SUPPLIERINVOICE.MANDT == TCURC.MANDT
  • SUPPLIERINVOICE.WAERS == TCURC.WAERS
Payment Method
  • Client
  • Payment Method
  • Country/Region Key
  • SUPPLIERINVOICE.MANDT == T042Z.MANDT
  • SUPPLIERINVOICE.ZLSCH == T042Z.ZLSCH
  • SUPPLIERINVOICE.LAND1 == T042Z.LAND1
Payment Block Key
  • Client
  • Payment Block Key
  • SUPPLIERINVOICE.MANDT == T008.MANDT
  • SUPPLIERINVOICE.ZLSPR == T008.ZAHLS
Other Relations | to Master Data Relations ↑ Join Conditions
Tax code
  • ?
  • ?
  • Client
  • Tax code
  • SUPPLIERINVOICE.[column in domain "KOART_MWSKZ"] == TMRM007A.KOART
  • SUPPLIERINVOICE.[column in domain "KALSM_D"] == TMRM007A.KALSM
  • SUPPLIERINVOICE.MANDT == TMRM007A.MANDT
  • SUPPLIERINVOICE.MWSKZ1 == TMRM007A.MWSKZ