N_SupplierInvoiceItemPurOrdRef

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