I_SupDmndOvwCube

Supply Demand Overview Cube View | view: ISDOOVWDCUBE | TRAN | Extraction: Full only | Component: Order Allocation Run
Column Name Description
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetPriceAmount Net Price
Column Name Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
DeliveredQuantityInBaseUnit null
RequestedRqmtQtyInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
OpenDemandQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
FixedQuantityInBaseUnit null
SupAssgmtReservedQtyInBaseUnit null
OnHoldQuantityInBaseUnit null
ReadyForReleaseQtyInBaseUnit null
InboundAssignedQuantityInBsUnt null
OpenSupplyQuantity null
AssignedSupplyQtyInBaseUnit null
NormalSupplyQtyInBaseUnit null
PreviewSupplyQtyInBaseUnit null
Column Name Description
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate null
Column Name Description
RequirementType Requirement Type Show values
SupAssgmtSource Assignment Source Show values
Column Name Description Domain name
RequirementDocumentItem Sales Document Item POSNR
PurchasingDocumentItem null
SupplyNumber null
SupplyItem null
AssignedSupplyType null
Plant Plant (Own or External) WERKS
Batch null
RequirementSegment Requirement Segment SGT_SRCA
StockSegment null
ShippingGroupRule PSST Grouping Rule RFM_PSST_RULE
ShippingGroupNumber PSST Group RFM_PSST_GROUP_ID
CalendarMonth Calendar Month NUM2
CalendarWeek null
CalendarYear Calendar Year NUM4
CalendarMonthName Short Text for Fixed Values DDTEXT
PreviewFixedAssignedQtyInBsUnt null
PreviewReservedAssgdQtyInBsUnt null
PreviewOnHoldAssgdQtyInBsUnt null
PreviewRdyForReleaseQtyInBsUnt null
PreviewAssignedQuantityInBsUnt null
SupAssgmtCategory null
SupAssgmtCategoryName Short Text for Fixed Values DDTEXT
SupAssgmtSourceName Short Text for Fixed Values DDTEXT
SalesOrganizationName Sales Organization Description TEXT20
MaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
SalesDistrictName Name of the district TEXT20
PlantName Plant Name TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
ARunApplicationType null
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_SUPDMNDOVWCUBE.MANDT == T006.MANDT
  • I_SUPDMNDOVWCUBE.BASEUNIT == T006.MSEHI
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • I_SUPDMNDOVWCUBE.MANDT == T001.MANDT
  • I_SUPDMNDOVWCUBE.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_SUPDMNDOVWCUBE.MANDT == MARA.MANDT
  • I_SUPDMNDOVWCUBE.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • I_SUPDMNDOVWCUBE.MANDT == TVKOV.MANDT
  • I_SUPDMNDOVWCUBE.SALESORGANIZATION == TVKOV.VKORG
  • I_SUPDMNDOVWCUBE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Client
  • Division
  • I_SUPDMNDOVWCUBE.MANDT == TSPA.MANDT
  • I_SUPDMNDOVWCUBE.DIVISION == TSPA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • I_SUPDMNDOVWCUBE.MANDT == TCURC.MANDT
  • I_SUPDMNDOVWCUBE.DOCUMENTCURRENCY == TCURC.WAERS
Material: order item
  • Client
  • Material Number
  • I_SUPDMNDOVWCUBE.MANDT == MARA.MANDT
  • I_SUPDMNDOVWCUBE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_SUPDMNDOVWCUBE.MANDT == T023.MANDT
  • I_SUPDMNDOVWCUBE.MATERIALGROUP == T023.MATKL
Fashion Collection
  • Fashion Collection
  • Client
  • Season
  • Season Year
Season
  • Client
  • Season
  • Season Year
  • I_SUPDMNDOVWCUBE.MANDT == FSH_SEASONS.MANDT
  • I_SUPDMNDOVWCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_SUPDMNDOVWCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Season Year
  • Client
  • Season
  • Season Year
  • I_SUPDMNDOVWCUBE.MANDT == FSH_SEASONS.MANDT
  • I_SUPDMNDOVWCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_SUPDMNDOVWCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Fashion Theme
  • Fashion Collection
  • Client
  • Fashion Theme
  • Season
  • Season Year
  • I_SUPDMNDOVWCUBE.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_SUPDMNDOVWCUBE.MANDT == FSH_THEMES.MANDT
  • I_SUPDMNDOVWCUBE.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • I_SUPDMNDOVWCUBE.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_SUPDMNDOVWCUBE.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
Sales District
  • Client
  • Sales District
  • I_SUPDMNDOVWCUBE.MANDT == T171.MANDT
  • I_SUPDMNDOVWCUBE.SALESDISTRICT == T171.BZIRK
Sales organization in order header
  • Client
  • Sales Organization
  • I_SUPDMNDOVWCUBE.MANDT == TVKO.MANDT
  • I_SUPDMNDOVWCUBE.SALESORGANIZATION == TVKO.VKORG
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_SUPDMNDOVWCUBE.MANDT == TVST.MANDT
  • I_SUPDMNDOVWCUBE.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Client
  • Storage location
  • Plant (Own or External)
  • I_SUPDMNDOVWCUBE.MANDT == T001L.MANDT
  • I_SUPDMNDOVWCUBE.STORAGELOCATION == T001L.LGORT
  • I_SUPDMNDOVWCUBE.PLANT == T001L.WERKS