I_ProjDmndPurchaseOrdersSum

DDL: I_PROJDMNDPURCHASEORDERSSUM SQL: IPRJDMNDPURORD Type: view COMPOSITE Package: ODATA_PS_DMND_MAINTAIN
21 Fields 1 Data Sources

Project demand purchase orders sum

I_ProjDmndPurchaseOrdersSum is a Composite CDS View that provides data about "Project demand purchase orders sum" in SAP S/4HANA. It reads from 1 data source (P_MngProjDmndPurReqnOrd) and exposes 21 fields with key fields WBSElementInternalID, PurchaseRequisition, PurchaseRequisitionItem. Part of development package ODATA_PS_DMND_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
P_MngProjDmndPurReqnOrd P_MngProjDmndPurReqnOrd from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPRJDMNDPURORD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Project demand purchase orders sum view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID WBSElementInternalID WBS Internal ID
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
OrderedQuantity
BaseUnit BaseUnit Unit of Measure
RequestedQuantity
StillToBeDeliveredQuantity
StockTransferDeliveredQuantity
DocumentCurrency DocumentCurrency Document Currency
NetValueAmountInDocCurrency
InvoiceReceiptAmount
ScheduleLineDeliveryDate
SchedLineStscDeliveryDate
PerformancePeriodStartDate
PerformancePeriodEndDate
Supplier Supplier Supplier
GoodsReceiptAmount
PurchasingDocumentType PurchasingDocumentType RFQ Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Plant Plant Valuation Area

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_ProjDmndPurchaseOrdersSum.
-- 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.
-- SQL view name: IPRJDMNDPURORD

CREATE VIEW I_ProjDmndPurchaseOrdersSum AS
SELECT
  WBSElementInternalID,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  sum(OrderedQuantity) AS OrderedQuantity,
  BaseUnit,
  sum(RequestedQuantity) AS RequestedQuantity,
  sum(StillToBeDeliveredQuantity) AS StillToBeDeliveredQuantity,
  sum(StockTransferDeliveredQuantity) AS StockTransferDeliveredQuantity,
  DocumentCurrency,
  sum(NetValueAmountInDocCurrency) AS NetValueAmountInDocCurrency,
  sum(InvoiceReceiptAmount) AS InvoiceReceiptAmount,
  min(ScheduleLineDeliveryDate) AS ScheduleLineDeliveryDate,
  max(SchedLineStscDeliveryDate) AS SchedLineStscDeliveryDate,
  min(PerformancePeriodStartDate) AS PerformancePeriodStartDate,
  max(PerformancePeriodEndDate) AS PerformancePeriodEndDate,
  Supplier,
  sum(GoodsReceiptAmount) AS GoodsReceiptAmount,
  PurchasingDocumentType,
  PurchasingOrganization,
  PurchasingGroup,
  Plant
FROM P_MngProjDmndPurReqnOrd
;

Learn More