P_SUPDMNDOVWCUBE

Supply Demand Overview Cube View | view: PSDOOVWDCUBE | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: SCAL_TT_DATE, MATDOC, EKKO, EKPO, EKPV, RESB, EKES, EKKO, EKPO, VBAK, VBAP, VBKD, EKKO, EKPO, EKPV, AFPO, EBAN, EKET, SCAL_TT_WEEK, VBPA, VBPA, LIPS, VBAK, VBAP, VBEP, EKET, EKKO, EKPO, EKPV, CVI_CUST_CT_LINK, BUT000, T001, TKA02, CVI_CUST_LINK, T161T, TVAKT, TVKOT, MARA, MARC, MCHA, KNA1, KNA1, MARC, VBBE, MARA, MARC, PLAF, T001K, T001W, MARA, MARC, ARUN_BDBS, ARUN_PREVIEW, KNVV, CVI_VEND_LINK, VBBE
Column Name Description
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetPriceAmount Net Price
Column Name Description
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
FashionCancelDate Cancellation Date
Column Name Description
RequirementType Requirement Type Show values
SupAssgmtSource Assignment Source Show values
PurchasingDocumentCategory Purchasing Document Category Show values
Column Name Description Domain name
RequirementDocumentItem Sales Document Item POSNR
PurchasingDocumentItem null
SupplyNumber null
SupplyItem null
AssignedSupplyType null
SoldToParty Sold-to Party KUNNR
ShipToParty Customer Number KUNNR
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
ARunApplicationType null
NetAmount null
ARunPriorityValue ARun Demand Priority VBELN
ARunDemandGroupPriority ARun Demand Group Priority VBELN
PurchasingGroup Purchasing Group EKGRP
Supplier Account Number of Supplier LIFNR
PurchasingOrganization Purchasing organization EKORG
AdditionalCustomerGroup1 Customer Group 1 KVGR1
AdditionalCustomerGroup2 Customer Group 2 KVGR2
AdditionalCustomerGroup3 Customer Group 3 KVGR3
AdditionalCustomerGroup4 Customer Group 4 KVGR4
AdditionalCustomerGroup5 Customer Group 5 KVGR5
ReferenceSDDocument Document number of the reference document VBELN
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
ShippingInstruction Shipping Instructions EVERS
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_SUPDMNDOVWCUBE.MANDT == T006.MANDT
  • P_SUPDMNDOVWCUBE.BASEUNIT == T006.MSEHI
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • P_SUPDMNDOVWCUBE.COMPANYCODE == T001.BUKRS
  • P_SUPDMNDOVWCUBE.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • P_SUPDMNDOVWCUBE.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • P_SUPDMNDOVWCUBE.MANDT == MARA.MANDT
Customer Group
  • Client
  • Customer Group
  • P_SUPDMNDOVWCUBE.MANDT == T151.MANDT
  • P_SUPDMNDOVWCUBE.CUSTOMERGROUP == T151.KDGRP
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • P_SUPDMNDOVWCUBE.DELIVERYBLOCKREASON == TVLS.LIFSP
  • P_SUPDMNDOVWCUBE.MANDT == TVLS.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • P_SUPDMNDOVWCUBE.DELIVERYPRIORITY == TPRIO.LPRIO
  • P_SUPDMNDOVWCUBE.MANDT == TPRIO.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • P_SUPDMNDOVWCUBE.SALESORGANIZATION == TVKOV.VKORG
  • P_SUPDMNDOVWCUBE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SUPDMNDOVWCUBE.MANDT == TVKOV.MANDT
Division
  • Division
  • Client
  • P_SUPDMNDOVWCUBE.DIVISION == TSPA.SPART
  • P_SUPDMNDOVWCUBE.MANDT == TSPA.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • P_SUPDMNDOVWCUBE.MANDT == TCURC.MANDT
  • P_SUPDMNDOVWCUBE.DOCUMENTCURRENCY == TCURC.WAERS
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • P_SUPDMNDOVWCUBE.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • P_SUPDMNDOVWCUBE.MANDT == TVFS.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • P_SUPDMNDOVWCUBE.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • P_SUPDMNDOVWCUBE.MANDT == TVFS.MANDT
Material: order item
  • Material Number
  • Client
  • P_SUPDMNDOVWCUBE.MATERIAL == MARA.MATNR
  • P_SUPDMNDOVWCUBE.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • P_SUPDMNDOVWCUBE.MANDT == T023.MANDT
  • P_SUPDMNDOVWCUBE.MATERIALGROUP == T023.MATKL
Order type in order header
  • Sales Document Type
  • Client
  • P_SUPDMNDOVWCUBE.ORDERTYPE == TVAK.AUART
  • P_SUPDMNDOVWCUBE.MANDT == TVAK.MANDT
Fashion Collection
  • Fashion Collection
  • Season
  • Client
  • Season Year
Season
  • Season
  • Client
  • Season Year
  • P_SUPDMNDOVWCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • P_SUPDMNDOVWCUBE.MANDT == FSH_SEASONS.MANDT
  • P_SUPDMNDOVWCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Season Year
  • Season
  • Client
  • Season Year
  • P_SUPDMNDOVWCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • P_SUPDMNDOVWCUBE.MANDT == FSH_SEASONS.MANDT
  • P_SUPDMNDOVWCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Fashion Theme
  • Fashion Theme
  • Fashion Collection
  • Season
  • Client
  • Season Year
  • P_SUPDMNDOVWCUBE.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • P_SUPDMNDOVWCUBE.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • P_SUPDMNDOVWCUBE.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • P_SUPDMNDOVWCUBE.MANDT == FSH_THEMES.MANDT
  • P_SUPDMNDOVWCUBE.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
Sales District
  • Client
  • Sales District
  • P_SUPDMNDOVWCUBE.MANDT == T171.MANDT
  • P_SUPDMNDOVWCUBE.SALESDISTRICT == T171.BZIRK
Sales document item category
  • Sales document item category
  • Client
  • P_SUPDMNDOVWCUBE.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • P_SUPDMNDOVWCUBE.MANDT == TVPT.MANDT
Sales group
  • Sales office
  • Client
  • Sales group
  • P_SUPDMNDOVWCUBE.SALESOFFICE == TVBVK.VKBUR
  • P_SUPDMNDOVWCUBE.MANDT == TVBVK.MANDT
  • P_SUPDMNDOVWCUBE.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Sales Organization
  • Client
  • P_SUPDMNDOVWCUBE.SALESORGANIZATION == TVKO.VKORG
  • P_SUPDMNDOVWCUBE.MANDT == TVKO.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • P_SUPDMNDOVWCUBE.SDDOCUMENTREASON == TVAU.AUGRU
  • P_SUPDMNDOVWCUBE.MANDT == TVAU.MANDT
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • P_SUPDMNDOVWCUBE.MANDT == TVST.MANDT
  • P_SUPDMNDOVWCUBE.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Plant (Own or External)
  • Storage location
  • Client
  • P_SUPDMNDOVWCUBE.PLANT == T001L.WERKS
  • P_SUPDMNDOVWCUBE.STORAGELOCATION == T001L.LGORT
  • P_SUPDMNDOVWCUBE.MANDT == T001L.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Sales Organization
  • Division
  • Distribution Channel
  • Client
  • P_SUPDMNDOVWCUBE.SALESOFFICE == TVKBZ.VKBUR
  • P_SUPDMNDOVWCUBE.SALESORGANIZATION == TVKBZ.VKORG
  • P_SUPDMNDOVWCUBE.DIVISION == TVKBZ.SPART
  • P_SUPDMNDOVWCUBE.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_SUPDMNDOVWCUBE.MANDT == TVKBZ.MANDT