C_SupDmndTotSlsOrdQuery

Query View for Total Demand | view: CSDOSOQRY | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: SCAL_TT_DATE, EKKO, EKPO, EKPV, RESB, VBAK, VBAP, VBKD, EKKO, EKPO, EKPV, SCAL_TT_WEEK, VBPA, VBPA, LIPS, VBAK, VBAP, VBEP, EKET, EKKO, EKPO, EKPV, CVI_CUST_CT_LINK, BUT000, T001, TKA02, KNA1, CVI_CUST_LINK, TVTWT, TSPAT, MARA, T023T, MAKT, T001W, T161T, WRF_CHARVALT, T171T, TVAKT, TVKBT, TVKOT, MARA, MARC, KNA1, KNA1, ARUN_BDBS, ARUN_PREVIEW, KNVV, CVI_VEND_LINK, VBBE
Column Name Description
RequirementDocumentNumber FK Sales Document
RequirementDocumentItem Sales Document Item
RequestedDate Schedule line date
ProductAvailabilityDate Material Staging/Availability Date
RequirementType Requirement Type
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetAmount Net Value of the Order Item in Document Currency
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
RequestedQuantityInBaseUnit null
Column Name Description
RequestedDate Schedule line date
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate null
FashionCancelDate Cancellation Date
Column Name Description
Column Name Description Domain name
ARunDocumentItemUniqueID Unique Identification for Supply Assignment Document Item
DocumentItemConcatenatedID Unique Identification for Supply Assignment Document Item CHAR17
RequirementTypeName Short Text for Fixed Values
SoldToParty Sold-to Party KUNNR
ShipToParty Customer Number KUNNR
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
Plant Plant (Own or External) WERKS
NetPriceQuantity Condition Pricing Unit KPEIN
RequirementSegment Requirement Segment SGT_SRCA
ShippingGroupRule PSST Grouping Rule RFM_PSST_RULE
ShippingGroupNumber PSST Group RFM_PSST_GROUP_ID
CalendarMonth Calendar Month NUM2
CalendarWeek null
CalendarYear Calendar Year
CalendarMonthName Short Text for Fixed Values
PreviewFixedAssignedQtyInBsUnt null
PreviewReservedAssgdQtyInBsUnt null
PreviewOnHoldAssgdQtyInBsUnt null
PreviewRdyForReleaseQtyInBsUnt null
PreviewAssignedQuantityInBsUnt null
SupAssgmtCategory null
SupAssgmtCategoryName Short Text for Fixed Values
SupAssgmtOrdStatusName Short Text for Fixed Values
SupAssgmtSource Assignment Source
SupAssgmtSourceName Short Text for Fixed Values
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
OrderTypeName Sales Document Type Description
ARunCancDteSupDlyTmeHrznCode null
ARunCancDteSupDlyTmeHrznTxt Short Text for Fixed Values
CustomerName Name of Customer TEXT80
PurchaseOrderByCustomer Customer Reference BSTKD
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic1Desc Characteristic value description ATWRT
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic2Desc Characteristic value description ATWRT
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
ProductCharacteristic3Desc Characteristic value description ATWRT
SalesOfficeName Sales Office Description TEXT20
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_SUPDMNDTOTSLSORDQUERY.BASEUNIT == T006.MSEHI
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == T006.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • C_SUPDMNDTOTSLSORDQUERY.COMPANYCODE == T001.BUKRS
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • C_SUPDMNDTOTSLSORDQUERY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == MARA.MANDT
Customer Group
  • Customer Group
  • Client
  • C_SUPDMNDTOTSLSORDQUERY.CUSTOMERGROUP == T151.KDGRP
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == T151.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SUPDMNDTOTSLSORDQUERY.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == TVLS.MANDT
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • C_SUPDMNDTOTSLSORDQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == TVKOV.MANDT
  • C_SUPDMNDTOTSLSORDQUERY.SALESORGANIZATION == TVKOV.VKORG
Division
  • Client
  • Division
  • Division
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == TSPA.MANDT
  • C_SUPDMNDTOTSLSORDQUERY.DIVISION == TSPA.SPART
  • C_SUPDMNDTOTSLSORDQUERY.ORGANIZATIONDIVISION == TSPA.SPART
SD Document Currency
  • SD Document Currency
  • Client
  • C_SUPDMNDTOTSLSORDQUERY.DOCUMENTCURRENCY == TCURC.WAERS
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == TCURC.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • C_SUPDMNDTOTSLSORDQUERY.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == TVFS.MANDT
Material: order item
  • Client
  • Material Number
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == MARA.MANDT
  • C_SUPDMNDTOTSLSORDQUERY.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == T023.MANDT
  • C_SUPDMNDTOTSLSORDQUERY.MATERIALGROUP == T023.MATKL
Order type in order header
  • Sales Document Type
  • Client
  • C_SUPDMNDTOTSLSORDQUERY.ORDERTYPE == TVAK.AUART
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == TVAK.MANDT
Division in order header
  • Distribution Channel
  • Client
  • Division
  • Division
  • Sales Organization
  • C_SUPDMNDTOTSLSORDQUERY.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == TVTA.MANDT
  • C_SUPDMNDTOTSLSORDQUERY.DIVISION == TVTA.SPART
  • C_SUPDMNDTOTSLSORDQUERY.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SUPDMNDTOTSLSORDQUERY.SALESORGANIZATION == TVTA.VKORG
Partner function - Document partner
  • Client
  • Partner Function
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == TPAR.MANDT
  • C_SUPDMNDTOTSLSORDQUERY.PARTNERFUNCTION == TPAR.PARVW
Fashion Collection
  • Season Year
  • Client
  • Fashion Collection
  • Season
Season
  • Season Year
  • Client
  • Season
  • C_SUPDMNDTOTSLSORDQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == FSH_SEASONS.MANDT
  • C_SUPDMNDTOTSLSORDQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Season Year
  • Season Year
  • Client
  • Season
  • C_SUPDMNDTOTSLSORDQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == FSH_SEASONS.MANDT
  • C_SUPDMNDTOTSLSORDQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Fashion Theme
  • Season Year
  • Fashion Theme
  • Client
  • Fashion Collection
  • Season
  • C_SUPDMNDTOTSLSORDQUERY.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • C_SUPDMNDTOTSLSORDQUERY.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == FSH_THEMES.MANDT
  • C_SUPDMNDTOTSLSORDQUERY.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • C_SUPDMNDTOTSLSORDQUERY.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
Sales District
  • Client
  • Sales District
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == T171.MANDT
  • C_SUPDMNDTOTSLSORDQUERY.SALESDISTRICT == T171.BZIRK
Sales document item category
  • Sales document item category
  • Client
  • C_SUPDMNDTOTSLSORDQUERY.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == TVPT.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == TVKO.MANDT
  • C_SUPDMNDTOTSLSORDQUERY.SALESORGANIZATION == TVKO.VKORG
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == TVST.MANDT
  • C_SUPDMNDTOTSLSORDQUERY.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Storage location
  • Plant (Own or External)
  • Client
  • C_SUPDMNDTOTSLSORDQUERY.STORAGELOCATION == T001L.LGORT
  • C_SUPDMNDTOTSLSORDQUERY.PLANT == T001L.WERKS
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == T001L.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Distribution Channel
  • Sales office
  • Client
  • Division
  • Division
  • Sales Organization
  • C_SUPDMNDTOTSLSORDQUERY.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_SUPDMNDTOTSLSORDQUERY.SALESOFFICE == TVKBZ.VKBUR
  • C_SUPDMNDTOTSLSORDQUERY.MANDT == TVKBZ.MANDT
  • C_SUPDMNDTOTSLSORDQUERY.DIVISION == TVKBZ.SPART
  • C_SUPDMNDTOTSLSORDQUERY.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_SUPDMNDTOTSLSORDQUERY.SALESORGANIZATION == TVKBZ.VKORG