P_SuplrConfItems

Private View for Visual Filters | view: PSUPLRCONFITEMS | Extraction: Not supported | Component: Purchase Orders

Tables used: EKKO, EKPO, EKET, EKES, EKBE, EKBEH, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, NAST, T163K, T163I, T001, TKA02, MARA, MAKT, T001W, T163B, T024, T024E, T001L, LFA1, T163F, T163E, T163G, T161M

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities (5)
📅 Dates (3)
☰ Categorical (1)
Other (8)
🔗 Relations (16)

Column Name	Description
PurchasingDocument FK	Purchasing Document Number
PurchasingDocumentItem	Item Number of Purchasing Document

Column Name	Description
💲 Currency Key (DocumentCurrency):
NetAmount	Net Order Value in PO Currency

Column Name	Description
📏 Purchase Order Unit of Measure (OrderUnit):
OrderQuantity	Purchase Order Quantity
CummulativeSheduleQuantity	null
OrderedQuantity	null
CommittedQuantity	null
BalanceQuantity	null

Column Name	Description
DocumentDate	Purchasing Document Date
DeliveryDate	Item delivery date
KeyDate	null

Column Name	Description
PurchasingDocumentCategory	Purchasing Document Category	Show values

Column Name	Description	Domain name
ScheduleLine	Delivery Schedule Line Counter	EETEN
CompanyCodeName	Name of Company Code or Company	TEXT25
SupplierName	Name of Supplier	TEXT80
PurchasingDocumentDeletionCode	Deletion Indicator in Purchasing Document	ELOEK
ShortText	Short Text	TEXT40
PurchasingDocumentStatus	null
PurchasingDocumentStatusName	Purchasing Document Status Name	DDTEXT
AuthorizationGroup	Authorization Group	BRGRU

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`P_SUPLRCONFITEMS.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `P_SUPLRCONFITEMS.MANDT == T163K.MANDT`
Company Code Company Code Client	`P_SUPLRCONFITEMS.COMPANYCODE == T001.BUKRS` `P_SUPLRCONFITEMS.MANDT == T001.MANDT`
Confirmation Control Key Confirmation Control Key Client	`P_SUPLRCONFITEMS.CONFIRMATIONCONTROL == T163L.BSTAE` `P_SUPLRCONFITEMS.MANDT == T163L.MANDT`
Currency Key Currency Key Client	`P_SUPLRCONFITEMS.DOCUMENTCURRENCY == TCURC.WAERS` `P_SUPLRCONFITEMS.MANDT == TCURC.MANDT`
Material number Material number Client	`P_SUPLRCONFITEMS.MATERIALNUMBER == MARA.MATNR` `P_SUPLRCONFITEMS.MANDT == MARA.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`P_SUPLRCONFITEMS.ORDERUNIT == T006.MSEHI` `P_SUPLRCONFITEMS.MANDT == T006.MANDT`
Plant Plant Client	`P_SUPLRCONFITEMS.PLANT == T001W.WERKS` `P_SUPLRCONFITEMS.MANDT == T001W.MANDT`
Purchase Order Type Purchasing Document Category Purchase Order Type Purchasing Document Type Client	`P_SUPLRCONFITEMS.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `P_SUPLRCONFITEMS.PURCHASEORDERTYPE == T161.BSART` `P_SUPLRCONFITEMS.PURCHASINGDOCUMENTTYPE == T161.BSART` `P_SUPLRCONFITEMS.MANDT == T161.MANDT`
Item category in purchasing document Item category in purchasing document Client	`P_SUPLRCONFITEMS.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP` `P_SUPLRCONFITEMS.MANDT == T163.MANDT`
Purchasing Document Type Purchasing Document Category Purchase Order Type Purchasing Document Type Client	`P_SUPLRCONFITEMS.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `P_SUPLRCONFITEMS.PURCHASEORDERTYPE == T161.BSART` `P_SUPLRCONFITEMS.PURCHASINGDOCUMENTTYPE == T161.BSART` `P_SUPLRCONFITEMS.MANDT == T161.MANDT`
Purchasing Group Purchasing Group Client	`P_SUPLRCONFITEMS.PURCHASINGGROUP == T024.EKGRP` `P_SUPLRCONFITEMS.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`P_SUPLRCONFITEMS.PURCHASINGORGANIZATION == T024E.EKORG` `P_SUPLRCONFITEMS.MANDT == T024E.MANDT`
Supplier Supplier Client	`P_SUPLRCONFITEMS.SUPPLIER == LFA1.LIFNR` `P_SUPLRCONFITEMS.MANDT == LFA1.MANDT`
Vendor account group Vendor account group Client	`P_SUPLRCONFITEMS.SUPPLIERACCOUNTGROUP == T077K.KTOKK` `P_SUPLRCONFITEMS.MANDT == T077K.MANDT`
Confirmation Category Confirmation Category Client	`P_SUPLRCONFITEMS.SUPPLIERCONFIRMATIONCATEGORY == T163E.EBTYP` `P_SUPLRCONFITEMS.MANDT == T163E.MANDT`