P_ChmlCmplncInfoPrptyCmbnd

DDL: P_CHMLCMPLNCINFOPRPTYCMBND Type: view CONSUMPTION
10 Fields 3 Data Sources

CCI Property Combined

P_ChmlCmplncInfoPrptyCmbnd is a Consumption CDS View that provides data about "CCI Property Combined" in SAP S/4HANA. It reads from 3 data sources (I_ChmlCmplncInfo, P_ChmlCmplncInfoAssgdPCPrpty, P_WorkViewAssgmtPrptyRootType) and exposes 10 fields with key field ChmlCmplncInfoUUID.

Data Sources (3)

SourceAliasJoin Type
I_ChmlCmplncInfo ChmlCmplncInfo from
P_ChmlCmplncInfoAssgdPCPrpty ChmlCmplncInfoAssgdPCPrpty inner
P_WorkViewAssgmtPrptyRootType WorkViewAssgmtPrptyRootType inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCCIPROPCMB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label CCI Property Combined view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_ChmlCmplncInfo ChmlCmplncInfoUUID Chemical Compliance Information PP
PCPrptyRootType P_ChmlCmplncInfoAssgdPCPrpty PCPrptyRootType Root object type
PCPrptyInProcProcgSts P_ChmlCmplncInfoAssgdPCPrpty PCPrptyInProcProcgSts
PCPrptyReldProcgSts P_ChmlCmplncInfoAssgdPCPrpty PCPrptyReldProcgSts
PCPrptyNavgnLinkUUID P_ChmlCmplncInfoAssgdPCPrpty PCPrptyNavgnLinkUUID
ReleasedByUser P_ChmlCmplncInfoAssgdPCPrpty ReleasedByUser Released By
WorkViewGroupName
PCPrptySequence
WorkView P_WorkViewAssgmtPrptyRootType WorkView Work View ID
WorkViewUUID P_WorkViewAssgmtPrptyRootType WorkViewUUID Work View

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_ChmlCmplncInfoPrptyCmbnd.
-- 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_ChmlCmplncInfoPrptyCmbnd AS
SELECT
  ChmlCmplncInfo.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  ChmlCmplncInfoAssgdPCPrpty.PCPrptyRootType AS PCPrptyRootType,
  ChmlCmplncInfoAssgdPCPrpty.PCPrptyInProcProcgSts AS PCPrptyInProcProcgSts,
  ChmlCmplncInfoAssgdPCPrpty.PCPrptyReldProcgSts AS PCPrptyReldProcgSts,
  ChmlCmplncInfoAssgdPCPrpty.PCPrptyNavgnLinkUUID AS PCPrptyNavgnLinkUUID,
  ChmlCmplncInfoAssgdPCPrpty.ReleasedByUser AS ReleasedByUser,
  WorkViewAssgmtPrptyRootType._WorkViewGroup.WorkViewGroupName AS WorkViewGroupName,
  WorkViewAssgmtPrptyRootType._WorkViewGroup.PCPrptySequence AS PCPrptySequence,
  WorkViewAssgmtPrptyRootType.WorkView AS WorkView,
  WorkViewAssgmtPrptyRootType.WorkViewUUID AS WorkViewUUID
FROM I_ChmlCmplncInfo AS ChmlCmplncInfo
INNER JOIN P_ChmlCmplncInfoAssgdPCPrpty AS ChmlCmplncInfoAssgdPCPrpty ON /* join condition not captured in parsed metadata */
INNER JOIN P_WorkViewAssgmtPrptyRootType AS WorkViewAssgmtPrptyRootType ON /* join condition not captured in parsed metadata */
;

Learn More