I_SupDmndAllDocDmndAmt
View for Demand of All Documents
I_SupDmndAllDocDmndAmt is a Composite CDS View that provides data about "View for Demand of All Documents" in SAP S/4HANA. It reads from 5 data sources (I_SupDmndAllDocOpenDeliveries, I_SupDmndAllDocRetsSup, I_SupDmndAllDocSDItm, I_SupDmndAllDocSTOItm, I_SupDmndAllDocStkTransptReqn) and exposes 110 fields. Part of development package VDM_ARUN_ANALYTICS_ALL.
Data Sources (5)
| Source | Alias | Join Type |
|---|---|---|
| I_SupDmndAllDocOpenDeliveries | OpenDelivery | union_all |
| I_SupDmndAllDocRetsSup | RetsSup | union_all |
| I_SupDmndAllDocSDItm | SD | from |
| I_SupDmndAllDocSTOItm | STO | union_all |
| I_SupDmndAllDocStkTransptReqn | STR | union_all |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| AbapCatalog.sqlViewName | ISUPDMNDADDAMT | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| EndUserText.label | View for Demand of All Documents | view |
Fields (110)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| RequirementDocumentNumber | RequirementDocumentNumber | Source PurchDoc | ||
| RequirementDocumentItem | RequirementDocumentItem | WBS Element | ||
| RequestedDate | RequestedDate | Mat.Avail.Date | ||
| ProductAvailabilityDate | ProductAvailabilityDate | Mat.Avail.Date | ||
| RequestedDeliveryDate | RequestedDeliveryDate | Requested Delivery Date | ||
| RequirementType | RequirementType | RequirementType | ||
| BaseUnit | BaseUnit | Unit of Measure | ||
| Material | Material | Vehicle Model | ||
| MaterialGroup | MaterialGroup | Product Group | ||
| Plant | Plant | Valuation Area | ||
| CrossPlantConfigurableProduct | CrossPlantConfigurableProduct | Cross-plant CP | ||
| MaterialType | MaterialType | Material Type | ||
| RequirementSegment | RequirementSegment | Req. Segment | ||
| SalesOrganization | SalesOrganization | Sales Organization | ||
| DistributionChannel | DistributionChannel | RefDistCh-Cust/Mat. | ||
| Division | Division | Internal Division ID | ||
| SalesDistrict | SalesDistrict | Sales District | ||
| Customer | SoldToParty | Sold-to Party | ||
| CompanyCode | CompanyCode | Receiver Company Code | ||
| StorageLocation | StorageLocation | StorageLocation | ||
| NetPriceAmount | NetPriceAmount | Net Price | ||
| DocumentCurrency | DocumentCurrency | Document Currency | ||
| RequirementDocumentItem | RequirementDocumentItem | WBS Element | ||
| RequestedDate | RequestedDate | Mat.Avail.Date | ||
| ProductAvailabilityDate | ProductAvailabilityDate | Mat.Avail.Date | ||
| RequestedDeliveryDate | RequestedDeliveryDate | Requested Delivery Date | ||
| RequirementType | RequirementType | RequirementType | ||
| BaseUnit | BaseUnit | Unit of Measure | ||
| Material | Material | Vehicle Model | ||
| MaterialGroup | MaterialGroup | Product Group | ||
| Plant | Plant | Valuation Area | ||
| CrossPlantConfigurableProduct | CrossPlantConfigurableProduct | Cross-plant CP | ||
| MaterialType | MaterialType | Material Type | ||
| RequirementSegment | RequirementSegment | Req. Segment | ||
| SalesOrganization | SalesOrganization | Sales Organization | ||
| DistributionChannel | DistributionChannel | RefDistCh-Cust/Mat. | ||
| Division | Division | Internal Division ID | ||
| SalesDistrict | SalesDistrict | Sales District | ||
| Customer | SoldToParty | Sold-to Party | ||
| CompanyCode | CompanyCode | Receiver Company Code | ||
| StorageLocation | StorageLocation | StorageLocation | ||
| NetPriceAmount | NetPriceAmount | Net Price | ||
| DocumentCurrency | DocumentCurrency | Document Currency | ||
| RequirementDocumentItem | RequirementDocumentItem | WBS Element | ||
| RequestedDate | RequestedDate | Mat.Avail.Date | ||
| ProductAvailabilityDate | ProductAvailabilityDate | Mat.Avail.Date | ||
| RequestedDeliveryDate | RequestedDeliveryDate | Requested Delivery Date | ||
| RequirementType | RequirementType | RequirementType | ||
| OpenDemandQuantity | OpenDemandQuantity | Qty. in OPUn | ||
| BaseUnit | BaseUnit | Unit of Measure | ||
| Material | Material | Vehicle Model | ||
| MaterialGroup | MaterialGroup | Product Group | ||
| Plant | Plant | Valuation Area | ||
| CrossPlantConfigurableProduct | CrossPlantConfigurableProduct | Cross-plant CP | ||
| MaterialType | MaterialType | Material Type | ||
| RequirementSegment | RequirementSegment | Req. Segment | ||
| SalesOrganization | Sales Organization | |||
| DistributionChannel | RefDistCh-Cust/Mat. | |||
| Division | Internal Division ID | |||
| SalesDistrict | Sales District | |||
| Customer | SoldToParty | Sold-to Party | ||
| CompanyCode | CompanyCode | Receiver Company Code | ||
| StorageLocation | StorageLocation | StorageLocation | ||
| NetPriceAmount | NetPriceAmount | Net Price | ||
| DocumentCurrency | DocumentCurrency | Document Currency | ||
| RequirementDocumentItem | RequirementDocumentItem | WBS Element | ||
| RequestedDate | RequestedDate | Mat.Avail.Date | ||
| ProductAvailabilityDate | ProductAvailabilityDate | Mat.Avail.Date | ||
| RequestedDeliveryDate | RequestedDeliveryDate | Requested Delivery Date | ||
| RequirementType | RequirementType | RequirementType | ||
| OpenDemandQuantity | OpenDemandQuantity | Qty. in OPUn | ||
| BaseUnit | BaseUnit | Unit of Measure | ||
| Material | Material | Vehicle Model | ||
| MaterialGroup | MaterialGroup | Product Group | ||
| Plant | Plant | Valuation Area | ||
| CrossPlantConfigurableProduct | CrossPlantConfigurableProduct | Cross-plant CP | ||
| MaterialType | MaterialType | Material Type | ||
| RequirementSegment | RequirementSegment | Req. Segment | ||
| SalesOrganization | Sales Organization | |||
| DistributionChannel | RefDistCh-Cust/Mat. | |||
| Division | Internal Division ID | |||
| SalesDistrict | Sales District | |||
| Customer | Sold-to Party | |||
| CompanyCode | CompanyCode | Receiver Company Code | ||
| StorageLocation | StorageLocation | StorageLocation | ||
| NetPriceAmount | NetPriceAmount | Net Price | ||
| DocumentCurrency | DocumentCurrency | Document Currency | ||
| RequirementDocumentItem | RequirementDocumentItem | WBS Element | ||
| RequestedDate | RequestedDate | Mat.Avail.Date | ||
| ProductAvailabilityDate | ProductAvailabilityDate | Mat.Avail.Date | ||
| RequestedDeliveryDate | RequestedDeliveryDate | Requested Delivery Date | ||
| RequirementType | RequirementType | RequirementType | ||
| OpenDemandQuantity | DeliveredQuantity | Qty. in OPUn | ||
| BaseUnit | BaseUnit | Unit of Measure | ||
| Material | Material | Vehicle Model | ||
| MaterialGroup | MaterialGroup | Product Group | ||
| Plant | Plant | Valuation Area | ||
| CrossPlantConfigurableProduct | CrossPlantConfigurableProduct | Cross-plant CP | ||
| MaterialType | MaterialType | Material Type | ||
| RequirementSegment | RequirementSegment | Req. Segment | ||
| SalesOrganization | SalesOrganization | Sales Organization | ||
| DistributionChannel | DistributionChannel | RefDistCh-Cust/Mat. | ||
| Division | Division | Internal Division ID | ||
| SalesDistrict | SalesDistrict | Sales District | ||
| Customer | SoldToParty | Sold-to Party | ||
| CompanyCode | Receiver Company Code | |||
| StorageLocation | StorageLocation | StorageLocation | ||
| NetPriceAmount | NetPriceAmount | Net Price | ||
| DocumentCurrency | DocumentCurrency | Document Currency | ||
| ActlAmt |
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 I_SupDmndAllDocDmndAmt.
-- 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 I_SupDmndAllDocDmndAmt AS
SELECT
RequirementDocumentNumber,
RequirementDocumentItem,
RequestedDate,
ProductAvailabilityDate,
RequestedDeliveryDate,
RequirementType,
BaseUnit,
Material,
MaterialGroup,
Plant,
CrossPlantConfigurableProduct,
MaterialType,
RequirementSegment,
SalesOrganization,
DistributionChannel,
Division,
SalesDistrict,
SoldToParty AS Customer,
CompanyCode,
StorageLocation,
NetPriceAmount,
DocumentCurrency,
OpenDemandQuantity,
cast ( DeliveredQuantity * NetPriceAmount as netwr ) AS ActlAmt
FROM I_SupDmndAllDocSDItm AS SD
-- UNION ALL with additional select branch(es): I_SupDmndAllDocSTOItm, I_SupDmndAllDocStkTransptReqn, I_SupDmndAllDocRetsSup, I_SupDmndAllDocOpenDeliveries
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA