I_SupplierInvoiceItemPurOrdRef

Supplier Invoice Item Purchase Order Reference | view: ISIITMPURORDREF | TRAN | Extraction: Not supported | Component: Logistics Invoice Verification
Tables used: RBKP, RBKPB, RBDRSEG, RSEG
Column Name Description
SupplierInvoice Document Number of an Accounting Document
FiscalYear Fiscal Year
SupplierInvoiceItem Document Item in Invoice Document
Column Name Description
💲 Currency Key (DocumentCurrency):
SupplierInvoiceItemAmount Amount in Document Currency
SuplrInvcItmUnplndDelivCost Delivery costs' share of item value
IN_CustomDutyAssessableValue Assessable Value
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
QuantityInPurchaseOrderUnit Quantity
📏 Order Price Unit (Purchasing) (PurchaseOrderPriceUnit):
QtyInPurchaseOrderPriceUnit Quantity in Purchase Order Price Unit
Column Name Description
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
IsNotCashDiscountLiable Indicator: Line Item Not Liable to Cash Discount? Show values
SuplrInvcItemHasPriceVariance Blocking Reason: Price Show values
SuplrInvcItemHasQtyVariance Blocking Reason: Quantity Show values
SuplrInvcItemHasDateVariance Blocking Reason: Date Show values
SuplrInvcItemHasOrdPrcQtyVarc Blocking Reason: Order Price Quantity Show values
SuplrInvcItemHasOtherVariance Manual Blocking Reason Show values
SuplrInvcItemHasAmountOutsdTol Blocking Reason: Item Amount Show values
SuplrInvcItmHasQualityVariance Blocking Reason: Quality Show values
Column Name Description Domain name
SupplierInvoiceItemText Item Text TEXT50
SuplrInvcDeliveryCostCndnType Condition Type KSCHL
SuplrInvcDeliveryCostCndnStep Step Number STUNR
SuplrInvcDeliveryCostCndnCount Condition Counter ZAEHK
IsSubsequentDebitCredit Indicator: Subsequent Debit/Credit TBTKZ
ReferenceDocument Document No. of a Reference Document BELNR
ReferenceDocumentFiscalYear Fiscal Year of Current Period GJAHR
ReferenceDocumentItem Item of a Reference Document MBLPO
FreightSupplier Account Number of Supplier LIFNR
IsOnlineSupplierInvoiceItem null
ProductType Product Type Group CHAR2
TaxCountry Tax Reporting Country/Region LAND1
IN_HSNOrSACCode HSN or SAC Code J_1IG_HSN_SAC
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • I_SUPPLIERINVOICEITEMPURORDREF.MANDT == TCURC.MANDT
  • I_SUPPLIERINVOICEITEMPURORDREF.DOCUMENTCURRENCY == TCURC.WAERS
Valuation Type
  • Client
  • Valuation Type
  • I_SUPPLIERINVOICEITEMPURORDREF.MANDT == T149D.MANDT
  • I_SUPPLIERINVOICEITEMPURORDREF.INVENTORYVALUATIONTYPE == T149D.BWTAR
Plant
  • Client
  • Plant
  • I_SUPPLIERINVOICEITEMPURORDREF.MANDT == T001W.MANDT
  • I_SUPPLIERINVOICEITEMPURORDREF.PLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • I_SUPPLIERINVOICEITEMPURORDREF.MANDT == MARA.MANDT
  • I_SUPPLIERINVOICEITEMPURORDREF.PURCHASEORDERITEMMATERIAL == MARA.MATNR
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • I_SUPPLIERINVOICEITEMPURORDREF.MANDT == T006.MANDT
  • I_SUPPLIERINVOICEITEMPURORDREF.PURCHASEORDERPRICEUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • I_SUPPLIERINVOICEITEMPURORDREF.MANDT == T006.MANDT
  • I_SUPPLIERINVOICEITEMPURORDREF.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • I_SUPPLIERINVOICEITEMPURORDREF.MANDT == T163.MANDT
  • I_SUPPLIERINVOICEITEMPURORDREF.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Company Code
  • Client
  • Company Code
  • I_SUPPLIERINVOICEITEMPURORDREF.MANDT == T001.MANDT
  • I_SUPPLIERINVOICEITEMPURORDREF.SUPLRINVCPURGDOCITMCOMPANYCODE == T001.BUKRS
Tax on sales/purchases code
  • Client
  • ?
  • Tax on sales/purchases code
  • I_SUPPLIERINVOICEITEMPURORDREF.MANDT == T007A.MANDT
  • I_SUPPLIERINVOICEITEMPURORDREF.[column in domain "KALSM_D"] == T007A.KALSM
  • I_SUPPLIERINVOICEITEMPURORDREF.TAXCODE == T007A.MWSKZ
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • ?
  • I_SUPPLIERINVOICEITEMPURORDREF.MANDT == TTXJ.MANDT
  • I_SUPPLIERINVOICEITEMPURORDREF.TAXJURISDICTION == TTXJ.TXJCD
  • I_SUPPLIERINVOICEITEMPURORDREF.[column in domain "TAX_KALSM"] == TTXJ.KALSM