C_SupDmndAllDocPurgContrRefQ

Query View for Purchasing Contract Reference Details | view: CSUPDMNDADPCRQ | Extraction: Not supported | Component: Order Allocation Run
Tables used: SCAL_TT_DATEEKKOEKPOEKABSCAL_TT_WEEKT16FBMARAMARCT001KT001W
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
PurchasingDocumentCategory Purchasing Document Category Show values
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
ReleasedQuantity null
Column Name Description
ProductAvailabilityDate Purchasing Document Date
RequestedDeliveryDate Purchasing Document Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
Column Name Description Domain name
SupAssgmtSource null
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarMonthName Short Text for Fixed Values DDTEXT
CalendarWeek null
CalendarDay Calendar Day NUM2
MaterialType Material type MTART
CrossPlantConfigurableProduct Cross-Plant Configurable Material MATNR
Customer null
CompanyCode null
PurchasingOrganization null
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_SUPDMNDALLDOCPURGCONTRREFQ.BASEUNIT == T006.MSEHI
  • C_SUPDMNDALLDOCPURGCONTRREFQ.MANDT == T006.MANDT
Distribution channel for intercompany billing
  • Client
  • Distribution channel for intercompany billing
  • C_SUPDMNDALLDOCPURGCONTRREFQ.MANDT == TVTW.MANDT
  • C_SUPDMNDALLDOCPURGCONTRREFQ.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division for intercompany billing
  • Client
  • Division for intercompany billing
  • C_SUPDMNDALLDOCPURGCONTRREFQ.MANDT == TSPA.MANDT
  • C_SUPDMNDALLDOCPURGCONTRREFQ.DIVISION == TSPA.SPART
Currency Key
  • Client
  • Currency Key
  • C_SUPDMNDALLDOCPURGCONTRREFQ.MANDT == TCURC.MANDT
  • C_SUPDMNDALLDOCPURGCONTRREFQ.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • C_SUPDMNDALLDOCPURGCONTRREFQ.MANDT == MARA.MANDT
  • C_SUPDMNDALLDOCPURGCONTRREFQ.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_SUPDMNDALLDOCPURGCONTRREFQ.MANDT == T023.MANDT
  • C_SUPDMNDALLDOCPURGCONTRREFQ.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_SUPDMNDALLDOCPURGCONTRREFQ.MANDT == T001W.MANDT
  • C_SUPDMNDALLDOCPURGCONTRREFQ.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • C_SUPDMNDALLDOCPURGCONTRREFQ.MANDT == T024.MANDT
  • C_SUPDMNDALLDOCPURGCONTRREFQ.PURCHASINGGROUP == T024.EKGRP
Sales District
  • Client
  • Sales District
  • C_SUPDMNDALLDOCPURGCONTRREFQ.MANDT == T171.MANDT
  • C_SUPDMNDALLDOCPURGCONTRREFQ.SALESDISTRICT == T171.BZIRK
Sales Organization for Intercompany Billing
  • Client
  • Sales Organization for Intercompany Billing
  • C_SUPDMNDALLDOCPURGCONTRREFQ.MANDT == TVKO.MANDT
  • C_SUPDMNDALLDOCPURGCONTRREFQ.SALESORGANIZATION == TVKO.VKORG