C_ARunAnlytsTotDmndQry

Consumption View for Total Demand | view: CARNALYTSTOTDMND | Extraction: Not supported | Component: Order Allocation Run

Tables used: VBAP, SCAL_TT_DATE, EKKO, EKPO, EKPV, EKET, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, PBED, PBIM, RESB, AFPO, RESB, RESB, EBAN, RESB, EKKO, EKPO, EBAN, EBKN, EKET, EKKO, EKPO, EKET, SCAL_TT_WEEK, VBPA, VBPA, LIPS, EKPO, MATDOC, EKET, EKKO, EKPO, ADCP, ADRC, ARUN_BDBS, ARUN_PREVIEW, ARUN_SDO_ALLDOC, SUP_CVC, SUP_OBJECT, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, PACTLG_PATH, TVAK, TVKO, ARUN_SDO_ALLDOC, PBID, PLAF, LFA1, TVEP, MARA, MARC, T001K, T001W, KNVV, CVI_VEND_LINK, SUP_TIMEBUCKET, SUP_PCP, VBBE

🔑 Keys (5)
💰 Amounts (1)
∑ Quantities (11)
📅 Dates (4)
☰ Categorical
Other (20)
🔗 Relations (20)

Column Name	Description
RequirementDocumentNumber	Sales Document
RequirementDocumentItem	Sales Document Item
RequestedDate	Material Staging/Availability Date
ProductAvailabilityDate	Material Staging/Availability Date
RequirementType	null

Column Name	Description
💲 Display Currency (DisplayCurrency):
TotActualAmtInDisplayCurrency	Net Value in Display Currency

Column Name	Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
RequestedRqmtQtyInBaseUnit	null
ConfirmedRqmtQtyInBaseUnit	null
AssignedQuantityInBaseUnit	null
SupAssgmtReservedQtyInBaseUnit	null
FixedQuantityInBaseUnit	null
OnHoldQuantityInBaseUnit	null
SimulationRdyForRelQtyInBsUnt	null
DeliveredQuantityInBaseUnit	null
OpenDemandQuantity	null
NormalAssignedQuantityInBsUnt	null
ARunPhysSupAssgdQtyInBsUnt	null

Column Name	Description
RequestedDate	Material Staging/Availability Date
ProductAvailabilityDate	Material Staging/Availability Date
RequestedDeliveryDate	null
FashionCancelDate	Cancellation Date

Column Name	Description

Column Name	Description	Domain name
PreviewAssignedQuantityInBsUnt	null
RequirementSegment	Requirement Segment
SupplyProtectionName	Name	DDTEXT
SalesOrganization	Sales Organization
DistributionChannel	Distribution Channel	VTWEG
Division	Division	SPART
SalesDistrict	Sales District
ShipToParty	null
SoldToParty	null
CompanyCode	Company Code to Be Billed
ARunReqdRqmtQtyFlfmtPercent	Ratio of Unconfirmed Sales Order Items as Requested
ARunConfdRqmtQtyFlfmtPercent	Ratio of Unconfirmed Sales Order Items as Requested
ARunConfdAsReqdPercent	Ratio of Unconfirmed Sales Order Items as Requested
ARunDeliveredQtyFlfmtPercent	Ratio of Unconfirmed Sales Order Items as Requested
ARunDeliveredAsConfdPercent	Ratio of Unconfirmed Sales Order Items as Requested
ARunOpenDemandQtyFlfmtPercent	Ratio of Unconfirmed Sales Order Items as Requested
ARunCancDteSupDlyTmeHrznCode	null
ProductCharacteristic1	Characteristic Value 1
ProductCharacteristic2	Characteristic Value 2
ProductCharacteristic3	Characteristic Value 3

Master Data Relations	Join Conditions
Base Unit of Measure Client Base Unit of Measure	`C_ARUNANLYTSTOTDMNDQRY.MANDT == T006.MANDT` `C_ARUNANLYTSTOTDMNDQRY.BASEUNIT == T006.MSEHI`
Country key Client Country/Region Key	`C_ARUNANLYTSTOTDMNDQRY.MANDT == T005.MANDT` `C_ARUNANLYTSTOTDMNDQRY.COUNTRY == T005.LAND1`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`C_ARUNANLYTSTOTDMNDQRY.MANDT == MARA.MANDT` `C_ARUNANLYTSTOTDMNDQRY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR`
Region (State, Province, County) Client Country/Region Key Country/Region Key Country/Region Key Region (State, Province, County) Region (State, Province, County) Region (State, Province, County)	`C_ARUNANLYTSTOTDMNDQRY.MANDT == T005S.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PLANTCOUNTRY == T005S.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SHIPTOCOUNTRY == T005S.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SOLDTOPARTYCOUNTRY == T005S.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SOLDTOPARTYREGION == T005S.BLAND` `C_ARUNANLYTSTOTDMNDQRY.CUSTOMERREGION == T005S.BLAND` `C_ARUNANLYTSTOTDMNDQRY.PLANTREGION == T005S.BLAND`
Plant Client Plant	`C_ARUNANLYTSTOTDMNDQRY.MANDT == T001W.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PLANT == T001W.WERKS`
Country key Client Country/Region Key Country/Region Key Country/Region Key	`C_ARUNANLYTSTOTDMNDQRY.MANDT == T005.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PLANTCOUNTRY == T005.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SHIPTOCOUNTRY == T005.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SOLDTOPARTYCOUNTRY == T005.LAND1`
Region Client Country/Region Key Country/Region Key Country/Region Key Region (State, Province, County) Region (State, Province, County) Region (State, Province, County)	`C_ARUNANLYTSTOTDMNDQRY.MANDT == T005S.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PLANTCOUNTRY == T005S.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SHIPTOCOUNTRY == T005S.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SOLDTOPARTYCOUNTRY == T005S.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SOLDTOPARTYREGION == T005S.BLAND` `C_ARUNANLYTSTOTDMNDQRY.CUSTOMERREGION == T005S.BLAND` `C_ARUNANLYTSTOTDMNDQRY.PLANTREGION == T005S.BLAND`
Material Number Client Material Number	`C_ARUNANLYTSTOTDMNDQRY.MANDT == MARA.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PRODUCT == MARA.MATNR`
Fashion Collection Client Season Fashion Collection Season Year	`C_ARUNANLYTSTOTDMNDQRY.MANDT == FSH_COLLECTIONS.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PRODUCTSEASON == FSH_COLLECTIONS.FSH_SEASON` `C_ARUNANLYTSTOTDMNDQRY.PRODUCTCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `C_ARUNANLYTSTOTDMNDQRY.PRODUCTSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR`
Material Group Client Material Group	`C_ARUNANLYTSTOTDMNDQRY.MANDT == T023.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PRODUCTGROUP == T023.MATKL`
Season Client Season Season Year	`C_ARUNANLYTSTOTDMNDQRY.MANDT == FSH_SEASONS.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `C_ARUNANLYTSTOTDMNDQRY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR`
Season Year Client Season Season Year	`C_ARUNANLYTSTOTDMNDQRY.MANDT == FSH_SEASONS.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `C_ARUNANLYTSTOTDMNDQRY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR`
Fashion Theme Client Season Fashion Collection Season Year Fashion Theme	`C_ARUNANLYTSTOTDMNDQRY.MANDT == FSH_THEMES.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PRODUCTSEASON == FSH_THEMES.FSH_SEASON` `C_ARUNANLYTSTOTDMNDQRY.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION` `C_ARUNANLYTSTOTDMNDQRY.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR` `C_ARUNANLYTSTOTDMNDQRY.PRODUCTTHEME == FSH_THEMES.FSH_THEME`
Material type Client Material type	`C_ARUNANLYTSTOTDMNDQRY.MANDT == T134.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PRODUCTTYPE == T134.MTART`
Region code Client Country/Region Key Region (State, Province, County)	`C_ARUNANLYTSTOTDMNDQRY.MANDT == T005S.MANDT` `C_ARUNANLYTSTOTDMNDQRY.COUNTRY == T005S.LAND1` `C_ARUNANLYTSTOTDMNDQRY.REGION == T005S.BLAND`
Sales group Client Sales office Sales group	`C_ARUNANLYTSTOTDMNDQRY.MANDT == TVBVK.MANDT` `C_ARUNANLYTSTOTDMNDQRY.SALESOFFICE == TVBVK.VKBUR` `C_ARUNANLYTSTOTDMNDQRY.SALESGROUP == TVBVK.VKGRP`
Country/Region Key Client Country/Region Key Country/Region Key Country/Region Key	`C_ARUNANLYTSTOTDMNDQRY.MANDT == T005.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PLANTCOUNTRY == T005.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SHIPTOCOUNTRY == T005.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SOLDTOPARTYCOUNTRY == T005.LAND1`
Country/Region Key Client Country/Region Key Country/Region Key Country/Region Key	`C_ARUNANLYTSTOTDMNDQRY.MANDT == T005.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PLANTCOUNTRY == T005.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SHIPTOCOUNTRY == T005.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SOLDTOPARTYCOUNTRY == T005.LAND1`
Region (State, Province, County) Client Country/Region Key Country/Region Key Country/Region Key Region (State, Province, County) Region (State, Province, County) Region (State, Province, County)	`C_ARUNANLYTSTOTDMNDQRY.MANDT == T005S.MANDT` `C_ARUNANLYTSTOTDMNDQRY.PLANTCOUNTRY == T005S.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SHIPTOCOUNTRY == T005S.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SOLDTOPARTYCOUNTRY == T005S.LAND1` `C_ARUNANLYTSTOTDMNDQRY.SOLDTOPARTYREGION == T005S.BLAND` `C_ARUNANLYTSTOTDMNDQRY.CUSTOMERREGION == T005S.BLAND` `C_ARUNANLYTSTOTDMNDQRY.PLANTREGION == T005S.BLAND`

Other Relations \| to Master Data Relations ↑	Join Conditions
Sales office Client ? ? Sales office ?	`C_ARUNANLYTSTOTDMNDQRY.MANDT == TVKBZ.MANDT` `C_ARUNANLYTSTOTDMNDQRY.[column in domain "SPART"] == TVKBZ.SPART` `C_ARUNANLYTSTOTDMNDQRY.[column in domain "VTWEG"] == TVKBZ.VTWEG` `C_ARUNANLYTSTOTDMNDQRY.SALESOFFICE == TVKBZ.VKBUR` `C_ARUNANLYTSTOTDMNDQRY.[column in domain "VKORG"] == TVKBZ.VKORG`