P_ChmlCmplncInfoAssmt

DDL: P_CHMLCMPLNCINFOASSMT Type: view CONSUMPTION
16 Fields 2 Data Sources 2 Associations

CCI assesment

P_ChmlCmplncInfoAssmt is a Consumption CDS View that provides data about "CCI assesment" in SAP S/4HANA. It reads from 2 data sources (P_ChmlCmplncInfoAssmtCmbnd, P_ChmlCmplncInfoAssmtLastDate) and exposes 16 fields with key field ChmlCmplncInfoUUID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_ChmlCmplncInfoAssmtCmbnd ChmlCmplncInfoAssmtCmbnd from
P_ChmlCmplncInfoAssmtLastDate ChmlCmplncInfoAssmtLastDate inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusinessUserBasic _ReleasedByUser $projection.ReleasedByUser = _ReleasedByUser.BusinessPartner
[0..1] I_BusinessUserBasic _ProcessorUser $projection.Processor = _ProcessorUser.BusinessPartner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCCIASSMT 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 assesment view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID P_ChmlCmplncInfoAssmtCmbnd ChmlCmplncInfoUUID Chemical Compliance Information PP
CmplRqRsltUUID P_ChmlCmplncInfoAssmtCmbnd CmplRqRsltUUID SDS Assessment
CmplRqVersUUID P_ChmlCmplncInfoAssmtCmbnd CmplRqVersUUID NodeID
ComplianceRequirement P_ChmlCmplncInfoAssmtCmbnd ComplianceRequirement Compliance Requirement
CmplRqVersName P_ChmlCmplncInfoAssmtCmbnd CmplRqVersName Compliance Requirement Name
ProcessingStatus Processing Status
CmplRqPattern P_ChmlCmplncInfoAssmtCmbnd CmplRqPattern Compliance Pattern
Processor P_ChmlCmplncInfoAssmtCmbnd Processor User Name
ReleasedByUser P_ChmlCmplncInfoAssmtCmbnd ReleasedByUser Released By
CreationDateTime P_ChmlCmplncInfoAssmtCmbnd CreationDateTime Timestamp
WorkViewGroupName P_ChmlCmplncInfoAssmtCmbnd WorkViewGroupName Work View Group Name
WorkView P_ChmlCmplncInfoAssmtCmbnd WorkView Work View ID
WorkViewUUID P_ChmlCmplncInfoAssmtCmbnd WorkViewUUID Work View
PCPrptySequence PCPrptySequence Sequence
_ReleasedByUser _ReleasedByUser
_ProcessorUser _ProcessorUser

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_ChmlCmplncInfoAssmt.
-- 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_ChmlCmplncInfoAssmt AS
SELECT
  ChmlCmplncInfoAssmtCmbnd.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  ChmlCmplncInfoAssmtCmbnd.CmplRqRsltUUID AS CmplRqRsltUUID,
  ChmlCmplncInfoAssmtCmbnd.CmplRqVersUUID AS CmplRqVersUUID,
  ChmlCmplncInfoAssmtCmbnd.ComplianceRequirement AS ComplianceRequirement,
  ChmlCmplncInfoAssmtCmbnd.CmplRqVersName AS CmplRqVersName,
  cast (CmplRqRsltProcessingStatus as ehfnd_crr_proc_status preserving type ) AS ProcessingStatus,
  ChmlCmplncInfoAssmtCmbnd.CmplRqPattern AS CmplRqPattern,
  ChmlCmplncInfoAssmtCmbnd.Processor AS Processor,
  ChmlCmplncInfoAssmtCmbnd.ReleasedByUser AS ReleasedByUser,
  ChmlCmplncInfoAssmtCmbnd.CreationDateTime AS CreationDateTime,
  ChmlCmplncInfoAssmtCmbnd.WorkViewGroupName AS WorkViewGroupName,
  ChmlCmplncInfoAssmtCmbnd.WorkView AS WorkView,
  ChmlCmplncInfoAssmtCmbnd.WorkViewUUID AS WorkViewUUID,
  PCPrptySequence
FROM P_ChmlCmplncInfoAssmtCmbnd AS ChmlCmplncInfoAssmtCmbnd
INNER JOIN P_ChmlCmplncInfoAssmtLastDate AS ChmlCmplncInfoAssmtLastDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessUserBasic AS _ReleasedByUser ON ReleasedByUser = _ReleasedByUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _ProcessorUser ON Processor = _ProcessorUser.BusinessPartner  -- association [0..1]
;

Learn More