C_PurOrdDelivInvcVal

DDL: C_PURORDDELIVINVCVAL SQL: CMMPODELINVVAL Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
34 Fields 1 Data Sources

Purchase Order Delivery Invoice Value

C_PurOrdDelivInvcVal is a Consumption CDS View that provides data about "Purchase Order Delivery Invoice Value" in SAP S/4HANA. It reads from 1 data source (C_PurOrdDeliveryInvoiceValue4) and exposes 34 fields with key field PurchaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
C_PurOrdDeliveryInvoiceValue4 C_PurOrdDeliveryInvoiceValue4 from

Parameters (5)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_Language sylangu
P_StartDate bedat
P_EndDate bedat
P_DateFunction datefunctionid

Annotations (11)

NameValueLevelField
EndUserText.label Purchase Order Delivery Invoice Value view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CMMPODELINVVAL view
Analytics.query true view
OData.publish true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (34)

KeyFieldSource TableSource FieldDescription
resultElementDateFunctionStartDate
resultElementDateFunctionEndDate
P_DisplayCurrency
P_StartDate
P_EndDatekeyPurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
Supplier Supplier Supplier
SupplierCountry SupplierCountry
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization
MaterialGroup MaterialGroup Product Group
PurchasingCategory PurchasingCategory Purchasing Category
PurgCatName PurgCatName Purchasing Cat. Name
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
Material Material Vehicle Model
MaterialName
CompanyCodeCurrency CompanyCodeCurrency Local Currency
Currency Currency Valuation Crcy
DisplayCurrency DisplayCurrency Display Currency
ComparisonPurchasingGroup ComparisonPurchasingGroup
ComparisonPurchasingOrg ComparisonPurchasingOrg
ComparisonMaterialGroup ComparisonMaterialGroup
ComparisonSupplierCountry ComparisonSupplierCountry
ComparisonSupplier ComparisonSupplier
PurchaseOrderNetAmount PurchaseOrderNetAmount Net Value
GoodsReceiptAmountInDspCrcy GoodsReceiptAmountInDspCrcy
InvoiceAmtInDisplayCurrency InvoiceAmtInDisplayCurrency
ComparisonNetAmtInDspCrcy ComparisonNetAmtInDspCrcy
ComprnGoodsReceiptAmtInDspCrcy ComprnGoodsReceiptAmtInDspCrcy
ComprnInvoiceAmtInDspCrcy ComprnInvoiceAmtInDspCrcy
PurchasingSpendRatio Purchasing Spend %
PurchaseOrderGoodsReceiptRatio Purchase Order Goods Receipt Amt %
PurchaseOrderInvoiceRcptRatio Purchase Order Invoice Amt %

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_PurOrdDelivInvcVal.
-- 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: CMMPODELINVVAL
-- Parameters: P_DisplayCurrency : displaycurrency, P_Language : sylangu, P_StartDate : bedat, P_EndDate : bedat, P_DateFunction : datefunctionid

CREATE VIEW C_PurOrdDelivInvcVal AS
SELECT
  resultElement: 'DateFunctionStartDate' AS resultElementDateFunctionStartDate,
  resultElement: 'DateFunctionEndDate' AS resultElementDateFunctionEndDate,
  binding: [ { targetParameter: 'P_DateFunction', type: #PARAMETER, value : 'P_DateFunction' AS P_DisplayCurrency,
  P_StartDate : $parameters.P_StartDate AS P_StartDate,
  PurchaseOrderItem,
  Supplier,
  SupplierCountry,
  PurchasingGroup,
  PurchasingOrganization,
  MaterialGroup,
  PurchasingCategory,
  PurgCatName,
  Plant,
  _Plant.PlantName AS PlantName,
  Material,
  _Material._Text[1: Language = $parameters.P_Language].MaterialName AS MaterialName,
  CompanyCodeCurrency,
  Currency,
  DisplayCurrency,
  ComparisonPurchasingGroup,
  ComparisonPurchasingOrg,
  ComparisonMaterialGroup,
  ComparisonSupplierCountry,
  ComparisonSupplier,
  PurchaseOrderNetAmount,
  GoodsReceiptAmountInDspCrcy,
  InvoiceAmtInDisplayCurrency,
  ComparisonNetAmtInDspCrcy,
  ComprnGoodsReceiptAmtInDspCrcy,
  ComprnInvoiceAmtInDspCrcy,
  cast( 1 as abap.dec( 15, 3 ) ) AS PurchasingSpendRatio,
  cast( 1 as abap.dec( 15, 3 ) ) AS PurchaseOrderGoodsReceiptRatio,
  cast( 1 as abap.dec( 15, 3 ) ) AS PurchaseOrderInvoiceRcptRatio
FROM C_PurOrdDeliveryInvoiceValue4
;

Learn More