P_ChmlCmplncReqMigration

DDL: P_CHMLCMPLNCREQMIGRATION SQL: PCCMPLCNREQMIG Type: view COMPOSITE
14 Fields 2 Data Sources

P_ChmlCmplncReqMigration is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_ChmlCmplncReq, I_ChmlCmplncReq) and exposes 14 fields with key field ChmlCmplncRequestUUID.

Data Sources (2)

SourceAliasJoin Type
I_ChmlCmplncReq _ChmlCmplncReqSell inner
I_ChmlCmplncReq ChmlCmplncReqProduce from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCCMPLCNREQMIG view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncRequestUUID I_ChmlCmplncReq ChmlCmplncRequestUUID Chemical Compliance Request
ChmlCmplncReqCmplncProc I_ChmlCmplncReq ChmlCmplncReqCmplncProc Solution Area
ChmlCmplncRequestOriginType I_ChmlCmplncReq ChmlCmplncRequestOriginType Origin
ChmlCmplncReqOriginProc I_ChmlCmplncReq ChmlCmplncReqOriginProc Reason for Request
ChmlCmplncRequestPrgrsStatus I_ChmlCmplncReq ChmlCmplncRequestPrgrsStatus Status
ChmlCmplncBusinessProcess I_ChmlCmplncReq ChmlCmplncBusinessProcess Business Process
Material I_ChmlCmplncReq Material Vehicle Model
ChmlCmplncInfoType
ChmlCmplncInfoUUID I_ChmlCmplncReq ChmlCmplncInfoUUID Chemical Compliance Information PP
ChmlCmplncProdUUID I_ChmlCmplncReq ChmlCmplncProdUUID Product Assignment
CreationUTCDateTime I_ChmlCmplncReq CreationUTCDateTime Time Stamp
CreatedByUser I_ChmlCmplncReq CreatedByUser User Name
LastChangeUTCDateTime I_ChmlCmplncReq LastChangeUTCDateTime Time Stamp
LastChangedByUser I_ChmlCmplncReq LastChangedByUser User Name

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_ChmlCmplncReqMigration.
-- 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: PCCMPLCNREQMIG

CREATE VIEW P_ChmlCmplncReqMigration AS
SELECT
  ChmlCmplncReqProduce.ChmlCmplncRequestUUID AS ChmlCmplncRequestUUID,
  ChmlCmplncReqProduce.ChmlCmplncReqCmplncProc AS ChmlCmplncReqCmplncProc,
  ChmlCmplncReqProduce.ChmlCmplncRequestOriginType AS ChmlCmplncRequestOriginType,
  ChmlCmplncReqProduce.ChmlCmplncReqOriginProc AS ChmlCmplncReqOriginProc,
  ChmlCmplncReqProduce.ChmlCmplncRequestPrgrsStatus AS ChmlCmplncRequestPrgrsStatus,
  ChmlCmplncReqProduce.ChmlCmplncBusinessProcess AS ChmlCmplncBusinessProcess,
  ChmlCmplncReqProduce.Material AS Material,
  ChmlCmplncReqProduce._ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  ChmlCmplncReqProduce.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  ChmlCmplncReqProduce.ChmlCmplncProdUUID AS ChmlCmplncProdUUID,
  ChmlCmplncReqProduce.CreationUTCDateTime AS CreationUTCDateTime,
  ChmlCmplncReqProduce.CreatedByUser AS CreatedByUser,
  ChmlCmplncReqProduce.LastChangeUTCDateTime AS LastChangeUTCDateTime,
  ChmlCmplncReqProduce.LastChangedByUser AS LastChangedByUser
FROM I_ChmlCmplncReq AS ChmlCmplncReqProduce
INNER JOIN I_ChmlCmplncReq AS _ChmlCmplncReqSell ON /* join condition not captured in parsed metadata */
;

Learn More