C_PurgDocSuplrConfSitn

Situation for Supplier Confirmations | view: CPURGDOCSITN | TRAN | Extraction: Not supported | Component: Purchase Orders

Tables used: SCAL_TT_DATE, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKET, EKES, EKBE, EKBEH, APOC_D_OR_ITEM, NAST, T163K, T163I, T001, TKA02, MARA, MAKT, T001W, T163B, T161T, T024, T024E, T163, T163Y, T001L, LFA1, T163F, T163E, USR21, T163G, T161M

🔑 Keys (2)
💰 Amounts
∑ Quantities
📅 Dates (5)
☰ Categorical (1)
Other (7)
🔗 Relations (13)

Column Name	Description
PurOrdSchedLineConcatenatedID	Schedule line id(Concatenation of EBELN, EBELP, EETEN)
SupplierConfirmationCategory FK	Supplier Confirmation Category

Column Name	Description

Column Name	Description

Column Name	Description
ScheduleLineDeliveryDate	Item delivery date
DocumentDate	Purchasing Document Date
KeyDate	null
ValidityStartDate	Start of Validity Period
ValidityEndDate	End of Validity Period

Column Name	Description
PurchasingDocumentCategory	Purchasing Document Category	Show values

Column Name	Description	Domain name
PurchasingDocumentItem	Item Number of Purchasing Document	EBELP
ScheduleLine	Delivery Schedule Line Counter	EETEN
PurchasingCategory	Purchasing Category ID	/SRMSMC/OBJECT_ID
PurchasingDocumentItemText	Short Text	TEXT40
PurchasingProcessingStatus	Purchasing document processing state
SchedAgrmtValidityStatus	null
PurchasingDocumentStatus	null

Master Data Relations	Join Conditions
Account Assignment Category Client Account Assignment Category	`C_PURGDOCSUPLRCONFSITN.MANDT == T163K.MANDT` `C_PURGDOCSUPLRCONFSITN.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP`
Company Code Client Company Code	`C_PURGDOCSUPLRCONFSITN.MANDT == T001.MANDT` `C_PURGDOCSUPLRCONFSITN.COMPANYCODE == T001.BUKRS`
Material Number Client Material Number	`C_PURGDOCSUPLRCONFSITN.MANDT == MARA.MANDT` `C_PURGDOCSUPLRCONFSITN.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_PURGDOCSUPLRCONFSITN.MANDT == T023.MANDT` `C_PURGDOCSUPLRCONFSITN.MATERIALGROUP == T023.MATKL`
Plant Client Plant	`C_PURGDOCSUPLRCONFSITN.MANDT == T001W.MANDT` `C_PURGDOCSUPLRCONFSITN.PLANT == T001W.WERKS`
Item category in purchasing document Client Item category in purchasing document	`C_PURGDOCSUPLRCONFSITN.MANDT == T163.MANDT` `C_PURGDOCSUPLRCONFSITN.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP`
Document Type Client Document Type Purchasing Document Category	`C_PURGDOCSUPLRCONFSITN.MANDT == T161.MANDT` `C_PURGDOCSUPLRCONFSITN.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_PURGDOCSUPLRCONFSITN.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP`
Purchasing Group Client Purchasing Group	`C_PURGDOCSUPLRCONFSITN.MANDT == T024.MANDT` `C_PURGDOCSUPLRCONFSITN.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Client Purchasing organization	`C_PURGDOCSUPLRCONFSITN.MANDT == T024E.MANDT` `C_PURGDOCSUPLRCONFSITN.PURCHASINGORGANIZATION == T024E.EKORG`
Storage Location Storage Location Client Plant	`C_PURGDOCSUPLRCONFSITN.STORAGELOCATION == T001L.LGORT` `C_PURGDOCSUPLRCONFSITN.MANDT == T001L.MANDT` `C_PURGDOCSUPLRCONFSITN.PLANT == T001L.WERKS`
Supplier Supplier Client	`C_PURGDOCSUPLRCONFSITN.SUPPLIER == LFA1.LIFNR` `C_PURGDOCSUPLRCONFSITN.MANDT == LFA1.MANDT`
Supplier Confirmation Category Client Supplier Confirmation Category	`C_PURGDOCSUPLRCONFSITN.MANDT == T163E.MANDT` `C_PURGDOCSUPLRCONFSITN.SUPPLIERCONFIRMATIONCATEGORY == T163E.EBTYP`