P_AssociatedSubstLglProcCmpstn

DDL: P_ASSOCIATEDSUBSTLGLPROCCMPSTN Type: view CONSUMPTION Package: EHFND_CNS_CCI

Associated legal Compositon with Status In Process

P_AssociatedSubstLglProcCmpstn is a Consumption CDS View that provides data about "Associated legal Compositon with Status In Process" in SAP S/4HANA. It reads from 1 data source (I_ChmlComposition) and exposes 2 fields. It has 1 association to related views. Part of development package EHFND_CNS_CCI.

Data Sources (1)

SourceAliasJoin Type
I_ChmlComposition CompositionInProcess from

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_CChmlCmplConstants _Constants _Constants.Constant1 = _Constants.Constant1

Annotations (7)

NameValueLevelField
EndUserText.label Associated legal Compositon with Status In Process view
AbapCatalog.sqlViewName PAASLNIPCMPS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
ChmlCmplncInfoUUID
ChmlCompositionType

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 P_AssociatedSubstLglProcCmpstn.
-- 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 P_AssociatedSubstLglProcCmpstn AS
SELECT *  -- field list not available in parsed metadata
FROM I_ChmlComposition AS CompositionInProcess
LEFT OUTER JOIN P_CChmlCmplConstants AS _Constants ON _Constants.Constant1 = _Constants.Constant1  -- association [1..1]
;