I_SuplrInvcItemPurOrdRefAPI01

Purchase Order Ref of Supplier Invoice | view: ISIPORDREFAPI01 | TRAN | Extraction: Not supported | Component: Logistics Invoice Verification
Tables used: RBKPRBKPBRBDRSEGRSEG
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
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
TaxCountry Tax Reporting Country/Region LAND1
Master Data Relations Join Conditions
Currency Key
  • Currency Key
  • Client
  • I_SUPLRINVCITEMPURORDREFAPI01.DOCUMENTCURRENCY == TCURC.WAERS
  • I_SUPLRINVCITEMPURORDREFAPI01.MANDT == TCURC.MANDT
Plant
  • Plant
  • Client
  • I_SUPLRINVCITEMPURORDREFAPI01.PLANT == T001W.WERKS
  • I_SUPLRINVCITEMPURORDREFAPI01.MANDT == T001W.MANDT
Material Number
  • Client
  • Material Number
  • I_SUPLRINVCITEMPURORDREFAPI01.MANDT == MARA.MANDT
  • I_SUPLRINVCITEMPURORDREFAPI01.PURCHASEORDERITEMMATERIAL == MARA.MATNR
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • I_SUPLRINVCITEMPURORDREFAPI01.MANDT == T006.MANDT
  • I_SUPLRINVCITEMPURORDREFAPI01.PURCHASEORDERPRICEUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • I_SUPLRINVCITEMPURORDREFAPI01.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • I_SUPLRINVCITEMPURORDREFAPI01.MANDT == T006.MANDT
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • I_SUPLRINVCITEMPURORDREFAPI01.[column in domain "KALSM_D"] == T007A.KALSM
  • I_SUPLRINVCITEMPURORDREFAPI01.MANDT == T007A.MANDT
  • I_SUPLRINVCITEMPURORDREFAPI01.TAXCODE == T007A.MWSKZ
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • I_SUPLRINVCITEMPURORDREFAPI01.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_SUPLRINVCITEMPURORDREFAPI01.MANDT == TTXJ.MANDT
  • I_SUPLRINVCITEMPURORDREFAPI01.TAXJURISDICTION == TTXJ.TXJCD