P_PurgDocSuplrConf

Supplier Confirmation per Confirmation Category | view: PPOSUPLRCONF | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKOEKPOEKETT163KT163IT001TKA02MARAMAKTT001WT024T024ET001LLFA1T163FT163ET163G
Column Name Description
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
NetAmount Net Order Value in PO Currency
TargetAmount Target Value for Header Area per Distribution
Column Name Description
📏 Purchase Order Unit of Measure (OrderUnit):
OrderQuantity Purchase Order Quantity
TargetQuantity Target Quantity
ScheduledQuantity Scheduled Quantity
CummulativeSheduleQuantity null
Column Name Description
DocumentDate Purchasing Document Date
ItemDeliveryDate Item delivery date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
CreationDate Creation Date of Purchasing Document
KeyDate null
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
PurchasingProcessingStatus Purchasing document processing state Show values
GoodsReceiptIsExpected Goods Receipt Indicator Show values
Column Name Description Domain name
PurchasingDocumentItemNumber Item Number of Purchasing Document EBELP
ScheduleLine Delivery Schedule Line Counter EETEN
MaterialName Material Description TEXT40
AcctAssignmentCategoryName Account Assignment Category Description TEXT20
CompanyCodeName Name of Company Code or Company TEXT25
SupplierConfCategoryName Confirmation Category: Description TEXT20
NetPriceQuantity Price Unit DEC5
SupplierName Name of Supplier TEXT80
ShortText Short Text TEXT40
PlantName Plant Name TEXT30
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingDocumentName Name of Purchasing Document TEXT40
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
ScheduleLineUniqueID Schedule line id(Concatenation of EBELN, EBELP, EETEN) PURGDOCSCHEDULELINEUNIQUEID
RequirementTracking Requirement Tracking Number CHAR10
StorageLocationName Storage Location Name TEXT16
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • P_PURGDOCSUPLRCONF.MANDT == T163K.MANDT
  • P_PURGDOCSUPLRCONF.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Company Code
  • Company Code
  • Client
  • P_PURGDOCSUPLRCONF.COMPANYCODE == T001.BUKRS
  • P_PURGDOCSUPLRCONF.MANDT == T001.MANDT
Confirmation Control Key
  • Client
  • Confirmation Control Key
  • P_PURGDOCSUPLRCONF.MANDT == T163L.MANDT
  • P_PURGDOCSUPLRCONF.CONFIRMATIONCONTROL == T163L.BSTAE
Currency Key
  • Client
  • Currency Key
  • P_PURGDOCSUPLRCONF.MANDT == TCURC.MANDT
  • P_PURGDOCSUPLRCONF.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_PURGDOCSUPLRCONF.MANDT == MARA.MANDT
  • P_PURGDOCSUPLRCONF.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURGDOCSUPLRCONF.MANDT == T023.MANDT
  • P_PURGDOCSUPLRCONF.MATERIALGROUP == T023.MATKL
Material number
  • Client
  • Material number
  • P_PURGDOCSUPLRCONF.MANDT == MARA.MANDT
  • P_PURGDOCSUPLRCONF.MATERIALNUMBER == MARA.MATNR
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_PURGDOCSUPLRCONF.MANDT == T006.MANDT
  • P_PURGDOCSUPLRCONF.ORDERUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • P_PURGDOCSUPLRCONF.MANDT == T001W.MANDT
  • P_PURGDOCSUPLRCONF.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_PURGDOCSUPLRCONF.MANDT == T163.MANDT
  • P_PURGDOCSUPLRCONF.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • Purchasing Document Category
  • P_PURGDOCSUPLRCONF.MANDT == T161.MANDT
  • P_PURGDOCSUPLRCONF.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_PURGDOCSUPLRCONF.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURGDOCSUPLRCONF.MANDT == T024.MANDT
  • P_PURGDOCSUPLRCONF.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURGDOCSUPLRCONF.MANDT == T024E.MANDT
  • P_PURGDOCSUPLRCONF.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • Client
  • Storage Location
  • Plant
  • P_PURGDOCSUPLRCONF.MANDT == T001L.MANDT
  • P_PURGDOCSUPLRCONF.STORAGELOCATION == T001L.LGORT
  • P_PURGDOCSUPLRCONF.PLANT == T001L.WERKS
Supplier
  • Client
  • Supplier
  • P_PURGDOCSUPLRCONF.MANDT == LFA1.MANDT
  • P_PURGDOCSUPLRCONF.SUPPLIER == LFA1.LIFNR
Confirmation Category
  • Client
  • Confirmation Category
  • P_PURGDOCSUPLRCONF.MANDT == T163E.MANDT
  • P_PURGDOCSUPLRCONF.SUPPLIERCONFIRMATIONCATEGORY == T163E.EBTYP