C_SettlmtDocOPg

DDL: C_SETTLMTDOCOPG Type: view_entity CONSUMPTION Package: WZRE_PC
3 Fields 1 Data Sources 1 Associations

Settlement Document

C_SettlmtDocOPg is a Consumption CDS View that provides data about "Settlement Document" in SAP S/4HANA. It reads from 1 data source (I_SettlmtDoc) and exposes 3 fields. It has 1 association to related views. Part of development package WZRE_PC.

Data Sources (1)

SourceAliasJoin Type
I_SettlmtDoc SettlmtDoc from

Parameters (1)

NameTypeDefault
P_DisplayCurrency displaycurrency

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_SettlmtDocOPgItem _Item $projection.SettlmtDoc = _Item.SettlmtDoc

Annotations (10)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.representativeKey SettlmtDoc view
Analytics.technicalName CWLFSETDOCOP view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Settlement Document view

Fields (3)

KeyFieldSource TableSource FieldDescription
PurchasingGroupasPurchasingGroup
PostingDateasPostingDate
CreationTime

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_SettlmtDocOPg.
-- 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.
-- Parameters: P_DisplayCurrency : displaycurrency

CREATE VIEW C_SettlmtDocOPg AS
SELECT
  entity: { name : 'I_Currency', element : 'Currency' AS PurchasingGroupasPurchasingGroup,
  multipleSelections: false AS PostingDateasPostingDate,
  multipleSelections: false AS CreationTime
FROM I_SettlmtDoc AS SettlmtDoc
LEFT OUTER JOIN C_SettlmtDocOPgItem AS _Item ON SettlmtDoc = _Item.SettlmtDoc  -- association [0..*]
;

Learn More