C_SupDmndOvwPgPurgContrQ

Query View for Purchasing Contract | view: CSDOPPURGCNTRQ | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
Material FK Material Number
Plant FK Plant
Batch Batch Number
StorageLocation Storage location
SupplyNumber null
SupplyItem null
SupplyScheduleLine null
ProductAvailabilityDate Purchasing Document Date
AssignedSupplyType null
Column Name Description
Column Name Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
TotalQuantity null
ReleasedQuantity Target Quantity
OpenReleasedQuantity null
AssignedQuantityInBaseUnit null
OpenSupplyQuantity null
Column Name Description
ProductAvailabilityDate Purchasing Document Date
RequestedDeliveryDate Purchasing Document Date
Column Name Description
Column Name Description Domain name
MaterialType Material type
CrossPlantConfigurableProduct Cross-Plant Configurable Material
Customer null
CompanyCode null
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_SUPDMNDOVWPGPURGCONTRQ.MANDT == T006.MANDT
  • C_SUPDMNDOVWPGPURGCONTRQ.BASEUNIT == T006.MSEHI
Distribution channel for intercompany billing
  • Client
  • Distribution channel for intercompany billing
  • C_SUPDMNDOVWPGPURGCONTRQ.MANDT == TVTW.MANDT
  • C_SUPDMNDOVWPGPURGCONTRQ.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division for intercompany billing
  • Client
  • Division for intercompany billing
  • C_SUPDMNDOVWPGPURGCONTRQ.MANDT == TSPA.MANDT
  • C_SUPDMNDOVWPGPURGCONTRQ.DIVISION == TSPA.SPART
Material Number
  • Client
  • Material Number
  • C_SUPDMNDOVWPGPURGCONTRQ.MANDT == MARA.MANDT
  • C_SUPDMNDOVWPGPURGCONTRQ.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_SUPDMNDOVWPGPURGCONTRQ.MANDT == T023.MANDT
  • C_SUPDMNDOVWPGPURGCONTRQ.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_SUPDMNDOVWPGPURGCONTRQ.MANDT == T001W.MANDT
  • C_SUPDMNDOVWPGPURGCONTRQ.PLANT == T001W.WERKS
Sales District
  • Sales District
  • Client
  • C_SUPDMNDOVWPGPURGCONTRQ.SALESDISTRICT == T171.BZIRK
  • C_SUPDMNDOVWPGPURGCONTRQ.MANDT == T171.MANDT
Sales Organization for Intercompany Billing
  • Client
  • Sales Organization for Intercompany Billing
  • C_SUPDMNDOVWPGPURGCONTRQ.MANDT == TVKO.MANDT
  • C_SUPDMNDOVWPGPURGCONTRQ.SALESORGANIZATION == TVKO.VKORG