What is C_ARunAnlytsTotDmndQry in SAP S/4HANA?

C_ARunAnlytsTotDmndQry is a consumption CDS view in SAP S/4HANA. Consumption View for Total Demand It contains 66 fields.

Which tables does C_ARunAnlytsTotDmndQry read from?

C_ARunAnlytsTotDmndQry reads data from: I_ARunAnlytsTotDmndCube.

What VDM layer is C_ARunAnlytsTotDmndQry?

C_ARunAnlytsTotDmndQry is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ARunAnlytsTotDmndQry

DDL: C_ARUNANLYTSTOTDMNDQRY Type: view CONSUMPTION

66 Fields 1 Data Sources

Consumption View for Total Demand

C_ARunAnlytsTotDmndQry (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

C_ARunAnlytsTotDmndQry is a Consumption CDS View that provides data about "Consumption View for Total Demand" in SAP S/4HANA. It reads from 1 data source (I_ARunAnlytsTotDmndCube) and exposes 66 fields with key fields RequirementDocumentNumber, RequirementDocumentItem, RequestedDate, ProductAvailabilityDate, RequirementType.

SAP Help Documentation

Category	Demand Overview - Cube
Data Category	Consumption, Query
Corresponding DataSource	2CCARNALYTSTOTDMND

Purpose
This CDS view helps analyze the data and determine the supply assignment related quantities for all supply assignment relevant products. This CDS view provides the data to answer the following business questions: What is the open demand and open supply per plant for a combination of country and region? What is the amount per ship-to country? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: ARUN_SDO (Authorization object for supply demand overview)

Structure
Parameters The parameters of the CDS view are as follows: Display Currency (P_DisplayCurrency) : This parameter is used to calculate the amount in the specified currency. Fields Used for Filtering The main filters are as follows: RequestedDeliveryDate : This field is used to filter the data for a range of requested delivery date. Plant : This field is used to filter the data for different plants. DistributionChannel : This field is used to filter the data for different distribution channels. SalesOrganization : This field is used to filter the data by different sales organizations. Further Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute RequestedRqmtQtyInBaseUnit Ordered Quantity in Base Unit Measure ConfirmedRqmtQtyInBaseUnit Confirmed Quantity in Base Unit Measure DeliveredQuantityInBaseUnit Delivered Quantity in Base Unit Measure OpenDemandQuantity Open Demand Quantity Measure AssignedQuantityInBaseUnit Total Assignment Quantity in Base Unit Measure NormalAssignedQuantityInBsUnt Normal Assigned Quantity in Base Unit Measure PreviewAssignedQuantityInBsUnt Preview Assigned Quantity in Base Unit Measure ARunTmpAssignedQuantityInBsUnt Temporary Assigned Quantity in Base Unit Measure SupAssgmtReservedQtyInBaseUnit Reserved Quantity in Base Unit Measure FixedQuantityInBaseUnit Fixed quantity in Base Unit Measure OnHoldQuantityInBaseUnit On Hold Quantity in Base Unit Measure

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	LO-RFM-ARN
Capabilities	Analytical Query
Package	Cross Applications for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view helps analyze the data and determine the supply assignment related quantities for all supply assignment relevant products.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What is the open demand and open supply per plant for a combination of country and region?</p></li> <li><p>What is the amount per ship-to country?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_ARunAnlytsTotDmndCube	I_ARunAnlytsTotDmndCube	from

Parameters (1)

Name	Type	Default
P_DisplayCurrency	vdm_v_display_currency

Annotations (15)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
ClientHandling.type	#INHERITED	view
VDM.viewType	#CONSUMPTION	view
AccessControl.personalData.blocking	#REQUIRED	view
AbapCatalog.sqlViewName	CARNALYTSTOTDMND	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
Metadata.ignorePropagatedAnnotations	true	view
Analytics.query	true	view
EndUserText.label	Consumption View for Total Demand	view
ObjectModel.supportedCapabilities	#ANALYTICAL_QUERY	view

Fields (66)

Key	Field	Source Table	Source Field	Description
KEY	RequirementDocumentNumber		RequirementDocumentNumber	Requirement Document Number
KEY	RequirementDocumentItem		RequirementDocumentItem	Requirement Document Item
KEY	RequestedDate		RequestedDate	Material Staging/Availability Date
KEY	ProductAvailabilityDate		ProductAvailabilityDate	Material Staging/Availability Date
KEY	RequirementType	Demand	RequirementType	Demand Type
	RequestedDeliveryDate		RequestedDeliveryDate	Requested Delivery Date
	RequestedRqmtQtyInBaseUnit		RequestedRqmtQtyInBaseUnit	Ordered Quantity
	ConfirmedRqmtQtyInBaseUnit		ConfirmedRqmtQtyInBaseUnit	Confirmed Quantity
	AssignedQuantityInBaseUnit		AssignedQuantityInBaseUnit	Total Assigned Quantity
	SupAssgmtReservedQtyInBaseUnit		SupAssgmtReservedQtyInBaseUnit	On Reservation (R)
	FixedQuantityInBaseUnit		FixedQuantityInBaseUnit	Ready for Delivery (F)
	OnHoldQuantityInBaseUnit		OnHoldQuantityInBaseUnit	On Hold (H)
	SimulationRdyForRelQtyInBsUnt		ReadyForReleaseQtyInBaseUnit	Open for Release (O)
	DeliveredQuantityInBaseUnit		DeliveredQuantityInBaseUnit	Delivered Quantity
	OpenDemandQuantity		OpenDemandQuantity	Open Demand Quantity
	UnconfirmedQuantityInBaseUnit		UnconfirmedQuantityInBaseUnit	Unconfirmed Quantity
	NormalAssignedQuantityInBsUnt		NormalAssignedQuantityInBsUnt	Normal Assigned Quantity
	PreviewAssignedQuantityInBsUnt		PreviewAssignedQuantityInBsUnt	Preview Assigned Quantity
	ARunTmpAssignedQuantityInBsUnt		ARunTmpAssignedQuantityInBsUnt	Temporary Assigned Quantity
	ARunPhysSupAssgdQtyInBsUnt		ARunPhysSupAssgdQtyInBsUnt	Assigned by Physical Supply
	BaseUnit		BaseUnit	Base Unit of Measure
	SupAssgmtAggrgQtyUnit		SupAssgmtAggrgQtyUnit	Base Unit of Measure
	Product		Product	Material Number
	ProductGroup		ProductGroup	Material Group
	ProductType		ProductType	Material Type
	RequirementSegment		RequirementSegment	Requirement Segment
	SupplyProtectionName		SupplyProtectionName	Name
	CrossPlantConfigurableProduct		CrossPlantConfigurableProduct	Cross-Plant Configurable Material
	Plant		Plant	Plant
	PlantCountry		PlantCountry	Country/Region Key
	PlantRegion		PlantRegion	Region (State, Province, County)
	SalesOrganization		SalesOrganization	Sales Organization
	Country		Country	Sales Org. Country
	Region		Region	Region (State, Province, County)
	DistributionChannel		DistributionChannel	Distribution Channel
	Division		Division	Internal Division ID
	SalesDistrict		SalesDistrict	Sales District
	SalesOffice		SalesOffice	Sales Office
	SalesGroup		SalesGroup	Sales Group
	ShipToParty		ShipToParty	Customer Number
	ShipToCountry		ShipToCountry	Ship To Party Country
	CustomerRegion		CustomerRegion	Region (State, Province, County)
	SoldToParty		SoldToParty	Customer Number
	SoldToPartyCountry		SoldToPartyCountry	Sold To Party Country
	SoldToPartyRegion		SoldToPartyRegion	Region (State, Province, County)
	CompanyCode		CompanyCode	Company Code to Be Billed
	DisplayCurrency		DisplayCurrency	Display Currency
	TotActualAmtInDisplayCurrency		TotActualAmtInDisplayCurrency	Net Value in Display Currency
	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
	FashionCancelDate		FashionCancelDate	Cancellation Date
	ARunCancDteSupDlyTmeHrznCode		ARunCancDteSupDlyTmeHrznCode	Cancel Date Horizon
	ProductSeasonYear		ProductSeasonYear	Season Year
	ProductSeason		ProductSeason	Season
	ProductCollection		ProductCollection	Fashion Collection
	ProductTheme		ProductTheme	Fashion Theme
	ProductCharacteristic1		ProductCharacteristic1	Product Characteristic 1
	ProductCharacteristic2		ProductCharacteristic2	Product Characteristic 2
	ProductCharacteristic3		ProductCharacteristic3	Product Characteristic 3
	ConfirmedDeliveryDate		ConfirmedDeliveryDate	Confirmed Delivery Date
	ScheduleLine		ScheduleLine	Schedule Line
	OrderType		OrderType	Sales Document Type

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ARunAnlytsTotDmndQry.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW C_ARunAnlytsTotDmndQry AS
SELECT
  RequirementDocumentNumber,
  RequirementDocumentItem,
  RequestedDate,
  ProductAvailabilityDate,
  Demand.RequirementType AS RequirementType,
  RequestedDeliveryDate,
  RequestedRqmtQtyInBaseUnit,
  ConfirmedRqmtQtyInBaseUnit,
  AssignedQuantityInBaseUnit,
  SupAssgmtReservedQtyInBaseUnit,
  FixedQuantityInBaseUnit,
  OnHoldQuantityInBaseUnit,
  ReadyForReleaseQtyInBaseUnit AS SimulationRdyForRelQtyInBsUnt,
  DeliveredQuantityInBaseUnit,
  OpenDemandQuantity,
  UnconfirmedQuantityInBaseUnit,
  NormalAssignedQuantityInBsUnt,
  PreviewAssignedQuantityInBsUnt,
  ARunTmpAssignedQuantityInBsUnt,
  ARunPhysSupAssgdQtyInBsUnt,
  BaseUnit,
  SupAssgmtAggrgQtyUnit,
  Product,
  ProductGroup,
  ProductType,
  RequirementSegment,
  SupplyProtectionName,
  CrossPlantConfigurableProduct,
  Plant,
  PlantCountry,
  PlantRegion,
  SalesOrganization,
  Country,
  Region,
  DistributionChannel,
  Division,
  SalesDistrict,
  SalesOffice,
  SalesGroup,
  ShipToParty,
  ShipToCountry,
  CustomerRegion,
  SoldToParty,
  SoldToPartyCountry,
  SoldToPartyRegion,
  CompanyCode,
  DisplayCurrency,
  TotActualAmtInDisplayCurrency,
  cast(1 as req_unconf_so_itm_ratio) AS ARunReqdRqmtQtyFlfmtPercent,
  cast(1 as req_unconf_so_itm_ratio) AS ARunConfdRqmtQtyFlfmtPercent,
  cast(1 as req_unconf_so_itm_ratio) AS ARunConfdAsReqdPercent,
  cast(1 as req_unconf_so_itm_ratio) AS ARunDeliveredQtyFlfmtPercent,
  cast(1 as req_unconf_so_itm_ratio) AS ARunDeliveredAsConfdPercent,
  cast(1 as req_unconf_so_itm_ratio) AS ARunOpenDemandQtyFlfmtPercent,
  FashionCancelDate,
  ARunCancDteSupDlyTmeHrznCode,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  ConfirmedDeliveryDate,
  ScheduleLine,
  OrderType
FROM I_ARunAnlytsTotDmndCube
;

Depth:

C_ARunAnlytsTotDmndQry view

I_ARunAnlytsTotDmndCube view