P_SuplrInvcItmOverview

Supplier Invoice Item Overview | view: PSUPLRINVITMOVW | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKOEKPORBKPRBCORBKPBRBDRSEGRSEGPRPS
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
Column Name Description
Column Name Description
DeliveryDate Delivery Date
Column Name Description
OrdinalNumber Four Character Sequential Number for Coding Block Show values
ObjectType Num1 Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
Column Name Description Domain name
MaterialDocumentItemText Item Text TEXT50
Status null
SalesOrder Sales and Distribution Document Number VBELN
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
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_SUPLRINVCITMOVERVIEW.COMPANYCODE == T001.BUKRS
  • P_SUPLRINVCITMOVERVIEW.MANDT == T001.MANDT
Material Number
  • Material Number
  • Client
  • P_SUPLRINVCITMOVERVIEW.MATERIAL == MARA.MATNR
  • P_SUPLRINVCITMOVERVIEW.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_SUPLRINVCITMOVERVIEW.MATERIALGROUP == T023.MATKL
  • P_SUPLRINVCITMOVERVIEW.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • P_SUPLRINVCITMOVERVIEW.PLANT == T001W.WERKS
  • P_SUPLRINVCITMOVERVIEW.MANDT == T001W.MANDT
Purchase Order Type
  • Purchase Order Type
  • ?
  • Client
  • P_SUPLRINVCITMOVERVIEW.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_SUPLRINVCITMOVERVIEW.[column in domain "BSTYP"] == T161.BSTYP
  • P_SUPLRINVCITMOVERVIEW.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_SUPLRINVCITMOVERVIEW.PURCHASINGGROUP == T024.EKGRP
  • P_SUPLRINVCITMOVERVIEW.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_SUPLRINVCITMOVERVIEW.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SUPLRINVCITMOVERVIEW.MANDT == T024E.MANDT