P_SupplierInvoiceItemPurOrdRef

Supplier Invoice Item Purchase Order Reference | view: PSIITMPURORDREF | 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
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 null
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
  • Currency Key
  • Client
  • P_SUPPLIERINVOICEITEMPURORDREF.DOCUMENTCURRENCY == TCURC.WAERS
  • P_SUPPLIERINVOICEITEMPURORDREF.MANDT == TCURC.MANDT
Plant
  • Client
  • Plant
  • P_SUPPLIERINVOICEITEMPURORDREF.MANDT == T001W.MANDT
  • P_SUPPLIERINVOICEITEMPURORDREF.PLANT == T001W.WERKS
Material Number
  • Material Number
  • Client
  • P_SUPPLIERINVOICEITEMPURORDREF.PURCHASEORDERITEMMATERIAL == MARA.MATNR
  • P_SUPPLIERINVOICEITEMPURORDREF.MANDT == MARA.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_SUPPLIERINVOICEITEMPURORDREF.PURCHASEORDERPRICEUNIT == T006.MSEHI
  • P_SUPPLIERINVOICEITEMPURORDREF.MANDT == T006.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_SUPPLIERINVOICEITEMPURORDREF.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_SUPPLIERINVOICEITEMPURORDREF.MANDT == T006.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • P_SUPPLIERINVOICEITEMPURORDREF.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • P_SUPPLIERINVOICEITEMPURORDREF.MANDT == T163.MANDT
Company Code
  • Company Code
  • Client
  • P_SUPPLIERINVOICEITEMPURORDREF.SUPLRINVCPURGDOCITMCOMPANYCODE == T001.BUKRS
  • P_SUPPLIERINVOICEITEMPURORDREF.MANDT == T001.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • P_SUPPLIERINVOICEITEMPURORDREF.TAXCODE == T007A.MWSKZ
  • P_SUPPLIERINVOICEITEMPURORDREF.[column in domain "KALSM_D"] == T007A.KALSM
  • P_SUPPLIERINVOICEITEMPURORDREF.MANDT == T007A.MANDT
Tax Jurisdiction
  • Tax Jurisdiction
  • ?
  • Client
  • P_SUPPLIERINVOICEITEMPURORDREF.TAXJURISDICTION == TTXJ.TXJCD
  • P_SUPPLIERINVOICEITEMPURORDREF.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • P_SUPPLIERINVOICEITEMPURORDREF.MANDT == TTXJ.MANDT