C_SupDmndOvwSupAssgmtQuery

Consumption view for Assignments | view: CSDOOVWQUERY | TRAN | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
Plant Plant
Material Material Number
StorageLocation Storage location
Batch Batch Number
RequirementType Requirement Type
RequirementDocumentNumber Purchasing requirement document
RequirementDocumentItem null
AssignedSupplyType ARun Stock Source
SupplyNumber null
SupplyItem null
SupplyScheduleLine null
RequestedDate Requested date
ProductAvailabilityDate Material Staging/Availability Date
Column Name Description
Column Name Description
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
FixedQuantityInBaseUnit null
OnHoldQuantityInBaseUnit null
ReadyForReleaseQtyInBaseUnit null
InboundAssignedQuantityInBsUnt null
Column Name Description
RequestedDate Requested date
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate null
SupplyDeliveryDate Confirmed Delivery Date for Future Receipts
Column Name Description
Column Name Description Domain name
AssignedDemandTypeName null
AssignedSupplyTypeName null
TimeHorizonInDays null
PreviewFixedAssignedQtyInBsUnt null
PreviewReservedAssgdQtyInBsUnt null
PreviewOnHoldAssgdQtyInBsUnt null
PreviewRdyForReleaseQtyInBsUnt null
PreviewAssignedQuantityInBsUnt null
RequirementSegment Requirement Segment SGT_SRCA
StockSegment Stock Segment SGT_SRCA
ShippingGroupRule PSST Grouping Rule RFM_PSST_RULE
ShippingGroupNumber PSST Group RFM_PSST_GROUP_ID
SalesOrganizationName Sales Organization Description TEXT20
MaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
PlantName Plant Name TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
Master Data Relations Join Conditions
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • C_SUPDMNDOVWSUPASSGMTQUERY.COMPANYCODE == T001.BUKRS
  • C_SUPDMNDOVWSUPASSGMTQUERY.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_SUPDMNDOVWSUPASSGMTQUERY.MANDT == MARA.MANDT
  • C_SUPDMNDOVWSUPASSGMTQUERY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Customer Group
  • Client
  • C_SUPDMNDOVWSUPASSGMTQUERY.CUSTOMERGROUP == T151.KDGRP
  • C_SUPDMNDOVWSUPASSGMTQUERY.MANDT == T151.MANDT
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_SUPDMNDOVWSUPASSGMTQUERY.MANDT == TVKOV.MANDT
  • C_SUPDMNDOVWSUPASSGMTQUERY.SALESORGANIZATION == TVKOV.VKORG
  • C_SUPDMNDOVWSUPASSGMTQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Material Group
  • Client
  • Material Group
  • C_SUPDMNDOVWSUPASSGMTQUERY.MANDT == T023.MANDT
  • C_SUPDMNDOVWSUPASSGMTQUERY.MATERIALGROUP == T023.MATKL
Order type in order header
  • Client
  • Sales Document Type
  • C_SUPDMNDOVWSUPASSGMTQUERY.MANDT == TVAK.MANDT
  • C_SUPDMNDOVWSUPASSGMTQUERY.ORDERTYPE == TVAK.AUART
Fashion Collection
  • Fashion Collection
  • Client
  • Season Year
  • Season
Season
  • Client
  • Season Year
  • Season
  • C_SUPDMNDOVWSUPASSGMTQUERY.MANDT == FSH_SEASONS.MANDT
  • C_SUPDMNDOVWSUPASSGMTQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_SUPDMNDOVWSUPASSGMTQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Season Year
  • Client
  • Season Year
  • Season
  • C_SUPDMNDOVWSUPASSGMTQUERY.MANDT == FSH_SEASONS.MANDT
  • C_SUPDMNDOVWSUPASSGMTQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_SUPDMNDOVWSUPASSGMTQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Fashion Theme
  • Fashion Collection
  • Client
  • Season Year
  • Season
  • Fashion Theme
  • C_SUPDMNDOVWSUPASSGMTQUERY.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • C_SUPDMNDOVWSUPASSGMTQUERY.MANDT == FSH_THEMES.MANDT
  • C_SUPDMNDOVWSUPASSGMTQUERY.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • C_SUPDMNDOVWSUPASSGMTQUERY.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • C_SUPDMNDOVWSUPASSGMTQUERY.PRODUCTTHEME == FSH_THEMES.FSH_THEME
Sales District
  • Sales District
  • Client
  • C_SUPDMNDOVWSUPASSGMTQUERY.SALESDISTRICT == T171.BZIRK
  • C_SUPDMNDOVWSUPASSGMTQUERY.MANDT == T171.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • C_SUPDMNDOVWSUPASSGMTQUERY.MANDT == TVKO.MANDT
  • C_SUPDMNDOVWSUPASSGMTQUERY.SALESORGANIZATION == TVKO.VKORG