P_SuplrInvcItm

Supplier Invoice Item Details | view: PPURGDOCITMINV | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKOEKPORBKPRBCORBKPBRBDRSEGRSEGT001TKA02T161T161TPRPS
Column Name Description
SupplierInvoice Document Number of an Accounting Document
SupplierInvoiceItem Document Item in Invoice Document
FiscalYear Fiscal Year
OrdinalNumber Four Character Sequential Number for Coding Block Show values
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
SupplierInvoiceItemAmount Amount in Document Currency
InvoicedAmount Amount in Document Currency
OverallLimitAmount Overall Limit
Column Name Description
PurgDocItemInvoicedQuantity Quantity
Quantity Quantity
Column Name Description
DeliveryDate Delivery Date
Column Name Description
OrdinalNumber Four Character Sequential Number for Coding Block Show values
ObjectType Num1 Show values
DebitCreditCode Debit/Credit Indicator Show values
IsReturnsItem Returns Item Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
Column Name Description Domain name
SupplierInvoiceWithItem null
MaterialDocumentItemText Item Text TEXT50
FormattedPurchaseOrderItem Purchase Order Item
PurchaseOrderHistIsDisplayed null
Status null
ControllingArea Controlling Area CACCD
SalesOrder Sales and Distribution Document Number VBELN
SalesOrderItem null
Supplier Supplier LIFNR
WBSElementExternalID Work Breakdown Structure Element (WBS Element) PS_POSID
ServicePerformer null
WorkItem null
SupplyingPlant null
AccountAssignmentCategory null
PurchasingDocumentItemCategory null
PurchasingDocument Document Number of an Accounting Document
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_SUPLRINVCITM.MANDT == T001.MANDT
  • P_SUPLRINVCITM.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_SUPLRINVCITM.MANDT == TCURC.MANDT
  • P_SUPLRINVCITM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_SUPLRINVCITM.DOCUMENTCURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_SUPLRINVCITM.MANDT == TCURC.MANDT
  • P_SUPLRINVCITM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_SUPLRINVCITM.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • P_SUPLRINVCITM.MANDT == TINC.MANDT
  • P_SUPLRINVCITM.INCOTERMSCLASSIFICATION == TINC.INCO1
Material Number
  • Client
  • Material Number
  • P_SUPLRINVCITM.MANDT == MARA.MANDT
  • P_SUPLRINVCITM.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_SUPLRINVCITM.MANDT == T023.MANDT
  • P_SUPLRINVCITM.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_SUPLRINVCITM.MANDT == T001W.MANDT
  • P_SUPLRINVCITM.PLANT == T001W.WERKS
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_SUPLRINVCITM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_SUPLRINVCITM.MANDT == T006.MANDT
Purchase Order Type
  • Purchase Order Type
  • Client
  • ?
  • P_SUPLRINVCITM.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_SUPLRINVCITM.MANDT == T161.MANDT
  • P_SUPLRINVCITM.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • P_SUPLRINVCITM.MANDT == T024.MANDT
  • P_SUPLRINVCITM.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_SUPLRINVCITM.MANDT == T024E.MANDT
  • P_SUPLRINVCITM.PURCHASINGORGANIZATION == T024E.EKORG
Tax on sales/purchases code
  • Client
  • ?
  • Tax on sales/purchases code
  • P_SUPLRINVCITM.MANDT == T007A.MANDT
  • P_SUPLRINVCITM.[column in domain "KALSM_D"] == T007A.KALSM
  • P_SUPLRINVCITM.TAXCODE == T007A.MWSKZ
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • ?
  • P_SUPLRINVCITM.MANDT == TTXJ.MANDT
  • P_SUPLRINVCITM.TAXJURISDICTION == TTXJ.TXJCD
  • P_SUPLRINVCITM.[column in domain "TAX_KALSM"] == TTXJ.KALSM