What is C_ARunAnlytsSupDmndOvwQry in SAP S/4HANA?

C_ARunAnlytsSupDmndOvwQry is a consumption CDS view in SAP S/4HANA. Overview of Supply and Demand Query It contains 55 fields.

Which tables does C_ARunAnlytsSupDmndOvwQry read from?

C_ARunAnlytsSupDmndOvwQry reads data from: I_ARunAnlytsSupDmndOvwCube.

What VDM layer is C_ARunAnlytsSupDmndOvwQry?

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

C_ARunAnlytsSupDmndOvwQry

DDL: C_ARUNANLYTSSUPDMNDOVWQRY Type: view CONSUMPTION

55 Fields 1 Data Sources

Overview of Supply and Demand Query

C_ARunAnlytsSupDmndOvwQry (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_ARunAnlytsSupDmndOvwQry is a Consumption CDS View that provides data about "Overview of Supply and Demand Query" in SAP S/4HANA. It reads from 1 data source (I_ARunAnlytsSupDmndOvwCube) and exposes 55 fields with key fields RequirementDocumentNumber, RequirementDocumentItem, SupProtTimeBucketUUID, ProductAvailabilityDate, RequirementType.

SAP Help Documentation

Category	Overview of Demand and Supply - Cube
Data Category	Consumption,Query
Corresponding DataSource	2CCARNANLYTSADOVWQ

Purpose
This CDS view helps analyse the supply and demand overview for a product for a requirement document and item. 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? 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
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 OpenSupplyQuantity Open Supply Quantity Measure AssignedSupplyQtyInBaseUnit Assigned Supply Quantity in Base Unit Measure NormalSupplyQtyInBaseUnit Normal Supply Assigned Quantity in Base Unit Measure PreviewSupplyQtyInBaseUnit Preview Supply Assigned Quantity in Base Unit Measure ARunTmpAssgdSupQtyInBaseUnit Temporary Assigned 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 analyse the supply and demand overview for a product for a requirement document and item.</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> </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_ARunAnlytsSupDmndOvwCube	I_ARunAnlytsSupDmndOvwCube	from

Annotations (15)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
ClientHandling.type	#INHERITED	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
AccessControl.personalData.blocking	#REQUIRED	view
AbapCatalog.sqlViewName	CARNANLYTSADOVWQ	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XXL	view
Metadata.ignorePropagatedAnnotations	true	view
Analytics.query	true	view
EndUserText.label	Overview of Supply and Demand Query	view
ObjectModel.supportedCapabilities	#ANALYTICAL_QUERY	view

Fields (55)

Key	Field	Source Field	Description
KEY	RequirementDocumentNumber	RequirementDocumentNumber	Sales Document
KEY	RequirementDocumentItem	RequirementDocumentItem	Sales Document Item
KEY	SupProtTimeBucketUUID	SupProtTimeBucketUUID	SUP UUID
KEY	ProductAvailabilityDate	ProductAvailabilityDate	Material Staging/Availability Date
KEY	RequirementType	RequirementType	Demand Type
KEY	SupplyNumber	SupplyNumber	Supply Number
KEY	SupplyItem	SupplyItem	Supply Item
KEY	SupplyScheduleLine	SupplyScheduleLine	Supply Schedule Line
KEY	AssignedSupplyType	AssignedSupplyType	Supply Source
KEY	Product	Product	Material Number
KEY	Plant	Plant	Plant
KEY	Batch	Batch	Batch Number
KEY	StorageLocation	StorageLocation	Storage Location
	RequestedDeliveryDate	RequestedDeliveryDate	Schedule Line Date
	SupAssgmtSource	SupAssgmtSource	Supply Assignment Source
	RequestedRqmtQtyInBaseUnit	RequestedRqmtQtyInBaseUnit	Ordered
	ConfirmedRqmtQtyInBaseUnit	ConfirmedRqmtQtyInBaseUnit	Confirmed
	DeliveredQuantityInBaseUnit	DeliveredQuantityInBaseUnit	Delivered
	OpenDemandQuantity	OpenDemandQuantity	Open Demand
	AssignedQuantityInBaseUnit	AssignedQuantityInBaseUnit	Total Assigned Quantity
	NormalAssignedQuantityInBsUnt	NormalAssignedQuantityInBsUnt	Normal Assigned
	PreviewAssignedQuantityInBsUnt	PreviewAssignedQuantityInBsUnt	Preview Assigned
	ARunTmpAssignedQuantityInBsUnt	ARunTmpAssignedQuantityInBsUnt	Temporary Assigned
	OpenSupplyQuantity	OpenSupplyQuantity	Open Supply
	AssignedSupplyQtyInBaseUnit	AssignedSupplyQtyInBaseUnit	Total Assigned(Supply)
	NormalSupplyQtyInBaseUnit	NormalSupplyQtyInBaseUnit	Normal Assigned(Supply)
	PreviewSupplyQtyInBaseUnit	PreviewSupplyQtyInBaseUnit	Preview Assigned(Supply)
	ARunTmpAssgdSupQtyInBaseUnit	ARunTmpAssgdSupQtyInBaseUnit	Temporary Assigned(Supply)
	BaseUnit	BaseUnit	Base Unit of Measure
	CalendarYear	CalendarYear	Calendar Year
	CalendarMonth	CalendarMonth	Calendar Month
	CalendarMonthName	CalendarMonthName	Short Text for Fixed Values
	CalendarWeek	CalendarWeek	Week
	CalendarDay	CalendarDay	Calendar Day
	ProductGroup	ProductGroup	Material Group
	ProductType	ProductType	Material Type
	CrossPlantConfigurableProduct	CrossPlantConfigurableProduct	Cross-Plant Configurable Material
	SalesOrganization	SalesOrganization	Sales Organization
	Country	Country	Sales Org. Country/Region
	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
	CompanyCode	CompanyCode	Company Code to Be Billed
	SoldToParty	SoldToParty	Customer Number
	SoldToPartyCountry	SoldToPartyCountry	Sold To Party Country/Region
	SoldToPartyRegion	SoldToPartyRegion	Region (State, Province, County)
	ShipToParty	ShipToParty	Customer Number
	ShipToCountry	ShipToCountry	Ship To Party Country/Region
	CustomerRegion	CustomerRegion	Region (State, Province, County)
	PlantCountry	PlantCountry	Plant Country/Region
	NetPriceAmount	NetPriceAmount	Net Price
	DocumentCurrency	DocumentCurrency	SD Document Currency

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_ARunAnlytsSupDmndOvwQry.
-- 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.

CREATE VIEW C_ARunAnlytsSupDmndOvwQry AS
SELECT
  RequirementDocumentNumber,
  RequirementDocumentItem,
  SupProtTimeBucketUUID,
  ProductAvailabilityDate,
  RequirementType,
  SupplyNumber,
  SupplyItem,
  SupplyScheduleLine,
  AssignedSupplyType,
  Product,
  Plant,
  Batch,
  StorageLocation,
  RequestedDeliveryDate,
  SupAssgmtSource,
  RequestedRqmtQtyInBaseUnit,
  ConfirmedRqmtQtyInBaseUnit,
  DeliveredQuantityInBaseUnit,
  OpenDemandQuantity,
  AssignedQuantityInBaseUnit,
  NormalAssignedQuantityInBsUnt,
  PreviewAssignedQuantityInBsUnt,
  ARunTmpAssignedQuantityInBsUnt,
  OpenSupplyQuantity,
  AssignedSupplyQtyInBaseUnit,
  NormalSupplyQtyInBaseUnit,
  PreviewSupplyQtyInBaseUnit,
  ARunTmpAssgdSupQtyInBaseUnit,
  BaseUnit,
  CalendarYear,
  CalendarMonth,
  CalendarMonthName,
  CalendarWeek,
  CalendarDay,
  ProductGroup,
  ProductType,
  CrossPlantConfigurableProduct,
  SalesOrganization,
  Country,
  Region,
  DistributionChannel,
  Division,
  SalesDistrict,
  SalesOffice,
  SalesGroup,
  CompanyCode,
  SoldToParty,
  SoldToPartyCountry,
  SoldToPartyRegion,
  ShipToParty,
  ShipToCountry,
  CustomerRegion,
  PlantCountry,
  NetPriceAmount,
  DocumentCurrency
FROM I_ARunAnlytsSupDmndOvwCube
;

Depth:

C_ARunAnlytsSupDmndOvwQry view

I_ARunAnlytsSupDmndOvwCube view