P_CmbndChmlAssocdPCPrpty

DDL: P_CMBNDCHMLASSOCDPCPRPTY SQL: PCCASSPCPRPTY Type: view COMPOSITE Package: EHFND_CNS_CCI
2 Fields

Combined Chemical associated PC property

P_CmbndChmlAssocdPCPrpty is a Composite CDS View that provides data about "Combined Chemical associated PC property" in SAP S/4HANA. Part of development package EHFND_CNS_CCI.

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCCASSPCPRPTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID ChmlCmplncInfo ChmlCmplncInfoUUID Chemical Compliance Information PP
PCPrptyProcgStselseendasPCPrptyProcgSts

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_CmbndChmlAssocdPCPrpty.
-- 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: PCCASSPCPRPTY

CREATE VIEW P_CmbndChmlAssocdPCPrpty AS
SELECT
  ChmlCmplncInfo.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  case when PhysicalChemicalInProcess.PhysChmlPrptyUUID is not null then PhysicalChemicalInProcess.PCPrptyProcgSts when PhysicalChemicalReleased.PhysChmlPrptyUUID is not null then PhysicalChemicalReleased.PCPrptyProcgSts else '' end as PCPrptyProcgSts AS PCPrptyProcgStselseendasPCPrptyProcgSts
;

Learn More