I_SupDmndAllDocPlndOrdCube

Cube View for Planned Order Details | view: ISUPDMNDADPLNDC | TRAN | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
Material FK Planning material
Plant FK Planning Plant
Batch Batch Number
StorageLocation Storage location
SupplyNumber null
SupplyItem null
SupplyScheduleLine null
ProductAvailabilityDate Planned Order End Date
AssignedSupplyType null
Column Name Description
Column Name Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
TotalQuantity Planned Total Order Quantity
OpenSupplyQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
Column Name Description
ProductAvailabilityDate Planned Order End Date
RequestedDeliveryDate Planned Order End Date
Column Name Description
Column Name Description Domain name
PreviewAssignedQuantityInBsUnt null
ARunTmpAssignedQuantityInBsUnt null
CalendarYear Calendar Year
CalendarMonth Calendar Month
CalendarMonthName Short Text for Fixed Values
CalendarWeek null
CalendarDay Calendar Day
SupAssgmtSource null
PurchasingGroup Purchasing Group EKGRP
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_SUPDMNDALLDOCPLNDORDCUBE.MANDT == T006.MANDT
  • I_SUPDMNDALLDOCPLNDORDCUBE.BASEUNIT == T006.MSEHI
Company code
  • Company Code
  • Client
  • I_SUPDMNDALLDOCPLNDORDCUBE.COMPANYCODE == T001.BUKRS
  • I_SUPDMNDALLDOCPLNDORDCUBE.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_SUPDMNDALLDOCPLNDORDCUBE.MANDT == MARA.MANDT
  • I_SUPDMNDALLDOCPLNDORDCUBE.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Number of Plant
  • Customer Number of Plant
  • Client
  • I_SUPDMNDALLDOCPLNDORDCUBE.CUSTOMER == KNA1.KUNNR
  • I_SUPDMNDALLDOCPLNDORDCUBE.MANDT == KNA1.MANDT
Distribution channel for intercompany billing
  • Distribution channel for intercompany billing
  • Client
  • I_SUPDMNDALLDOCPLNDORDCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_SUPDMNDALLDOCPLNDORDCUBE.MANDT == TVTW.MANDT
Division for intercompany billing
  • Division for intercompany billing
  • Client
  • I_SUPDMNDALLDOCPLNDORDCUBE.DIVISION == TSPA.SPART
  • I_SUPDMNDALLDOCPLNDORDCUBE.MANDT == TSPA.MANDT
Material
  • Planning material
  • Client
  • I_SUPDMNDALLDOCPLNDORDCUBE.MATERIAL == MARA.MATNR
  • I_SUPDMNDALLDOCPLNDORDCUBE.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_SUPDMNDALLDOCPLNDORDCUBE.MATERIALGROUP == T023.MATKL
  • I_SUPDMNDALLDOCPLNDORDCUBE.MANDT == T023.MANDT
Material type
  • Material type
  • Client
  • I_SUPDMNDALLDOCPLNDORDCUBE.MATERIALTYPE == T134.MTART
  • I_SUPDMNDALLDOCPLNDORDCUBE.MANDT == T134.MANDT
Plant
  • Client
  • Planning Plant
  • I_SUPDMNDALLDOCPLNDORDCUBE.MANDT == T001W.MANDT
  • I_SUPDMNDALLDOCPLNDORDCUBE.PLANT == T001W.WERKS
Purchasing organization
  • Purchasing organization
  • Client
  • I_SUPDMNDALLDOCPLNDORDCUBE.PURCHASINGORGANIZATION == T024E.EKORG
  • I_SUPDMNDALLDOCPLNDORDCUBE.MANDT == T024E.MANDT
Sales District
  • Sales District
  • Client
  • I_SUPDMNDALLDOCPLNDORDCUBE.SALESDISTRICT == T171.BZIRK
  • I_SUPDMNDALLDOCPLNDORDCUBE.MANDT == T171.MANDT
Sales Organization for Intercompany Billing
  • Sales Organization for Intercompany Billing
  • Client
  • I_SUPDMNDALLDOCPLNDORDCUBE.SALESORGANIZATION == TVKO.VKORG
  • I_SUPDMNDALLDOCPLNDORDCUBE.MANDT == TVKO.MANDT