DEMO_CDS_OVERALL_PRICE

DDL: DEMO_CDS_OVERALL_PRICE Type: view_entity
11 Fields 1 Data Sources

CDS view entity, purchdoc, overall price

DEMO_CDS_OVERALL_PRICE is a CDS View that provides data about "CDS view entity, purchdoc, overall price" in SAP S/4HANA. It reads from 1 data source (Demo_Cds_Purch_Doc) and exposes 11 fields with key field PurchaseDocument.

Data Sources (1)

SourceAliasJoin Type
Demo_Cds_Purch_Doc Demo_Cds_Purch_Doc from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS view entity, purchdoc, overall price view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PurchaseDocument PurchaseDocument Purchase Doc ID
OverallPrice
Currency _PurchaseDocumentItem Currency Valuation Crcy
PurchasingOrganization PurchasingOrganization Purchasing Organization
Description Description Well Code Des.
Status Status Workflow Status
Priority Priority Workflow priority
PurchaseDocumentImageURL PurchaseDocumentImageURL
crea_uname crea_uname User Name
lchg_uname lchg_uname User Name
_PurchaseDocumentItem _PurchaseDocumentItem

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 DEMO_CDS_OVERALL_PRICE.
-- 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 DEMO_CDS_OVERALL_PRICE AS
SELECT
  PurchaseDocument,
  sum( _PurchaseDocumentItem.OverallItemPrice ) AS OverallPrice,
  _PurchaseDocumentItem.Currency AS Currency,
  PurchasingOrganization,
  Description,
  Status,
  Priority,
  PurchaseDocumentImageURL,
  crea_uname,
  lchg_uname
FROM Demo_Cds_Purch_Doc
;

Learn More