I_PlngScopeDetsAssgdToChgRecd

DDL: I_PLNGSCOPEDETSASSGDTOCHGRECD SQL: IPLNGSCPCRASSGD Type: view COMPOSITE
21 Fields 4 Data Sources

Details of Planning Scopes Assigned to Change Record

I_PlngScopeDetsAssgdToChgRecd is a Composite CDS View that provides data about "Details of Planning Scopes Assigned to Change Record" in SAP S/4HANA. It reads from 4 data sources (P_MngUnassgdEBOMChgRecdType, I_ChangeRecordBsc, I_ChgRecdRefEBOM, I_ChgRecdRefPlngScpBsc) and exposes 21 fields with key fields ChangeRecordUUID, ChangeRecordRefPlngScpUUID, ChgRecdRefEngBillOfMatlUUID.

Data Sources (4)

SourceAliasJoin Type
P_MngUnassgdEBOMChgRecdType _EBOMChangeRecordType inner
I_ChangeRecordBsc ChangeRecord from
I_ChgRecdRefEBOM ChgRecdRefEngBOM left_outer
I_ChgRecdRefPlngScpBsc ChgRecdRefPlngScp left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPLNGSCPCRASSGD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Details of Planning Scopes Assigned to Change Record view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordUUID I_ChangeRecordBsc ChangeRecordUUID NodeID
KEY ChangeRecordRefPlngScpUUID I_ChgRecdRefPlngScpBsc ChangeRecordReferenceUUID UUID
KEY ChgRecdRefEngBillOfMatlUUID I_ChgRecdRefEBOM ChangeRecordReferenceUUID UUID
ChgRecRefInternalKey1PlngScp I_ChgRecdRefPlngScpBsc ChgRecRefInternalKey1 Key
ChgRecRefInternalKey2PlngScp I_ChgRecdRefPlngScpBsc ChgRecRefInternalKey2 Key
ChgRecdRefInternalKey1EngBOM I_ChgRecdRefEBOM ChgRecRefInternalKey1 Key
ChgRecdRefInternalKey2EngBOM I_ChgRecdRefEBOM ChgRecRefInternalKey2 Key
ChgRecdRefInternalKey3EngBOM I_ChgRecdRefEBOM ChgRecRefInternalKey3 Key
ChgRecdRefInternalKey4EngBOM I_ChgRecdRefEBOM ChgRecRefInternalKey4 Key
ChangeRecord I_ChangeRecordBsc ChangeRecord Char20
ChangeRecordCategory I_ChangeRecordBsc ChangeRecordCategory Issue Cat.
ChangeRecordStatus I_ChangeRecordBsc ChangeRecordStatus
ChangeRecordType I_ChangeRecordBsc ChangeRecordType Record Type
ChangeNumber I_ChangeRecordBsc ChangeNumber Change Number
Partner I_ChangeRecordBsc Partner With Partner
ChgRecordApplication I_ChangeRecordBsc ChgRecordApplication UI Application
CreatedByUser I_ChangeRecordBsc CreatedByUser User Name
ChangeRecordLifecycleStatus I_ChangeRecordBsc ChangeRecordLifecycleStatus Issue Lifecycle
ChgRecordDescriptionText I_ChangeRecordBsc ChgRecordDescriptionText
ChgRecdEngEffectiveDate I_ChangeRecordBsc ChgRecdEngEffectiveDate Eng Effective Date
ChgRecdMfgEffectiveDate I_ChangeRecordBsc ChgRecdMfgEffectiveDate Mfg Effective Date

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 I_PlngScopeDetsAssgdToChgRecd.
-- 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: IPLNGSCPCRASSGD

CREATE VIEW I_PlngScopeDetsAssgdToChgRecd AS
SELECT
  ChangeRecord.ChangeRecordUUID AS ChangeRecordUUID,
  ChgRecdRefPlngScp.ChangeRecordReferenceUUID AS ChangeRecordRefPlngScpUUID,
  ChgRecdRefEngBOM.ChangeRecordReferenceUUID AS ChgRecdRefEngBillOfMatlUUID,
  ChgRecdRefPlngScp.ChgRecRefInternalKey1 AS ChgRecRefInternalKey1PlngScp,
  ChgRecdRefPlngScp.ChgRecRefInternalKey2 AS ChgRecRefInternalKey2PlngScp,
  ChgRecdRefEngBOM.ChgRecRefInternalKey1 AS ChgRecdRefInternalKey1EngBOM,
  ChgRecdRefEngBOM.ChgRecRefInternalKey2 AS ChgRecdRefInternalKey2EngBOM,
  ChgRecdRefEngBOM.ChgRecRefInternalKey3 AS ChgRecdRefInternalKey3EngBOM,
  ChgRecdRefEngBOM.ChgRecRefInternalKey4 AS ChgRecdRefInternalKey4EngBOM,
  ChangeRecord.ChangeRecord AS ChangeRecord,
  ChangeRecord.ChangeRecordCategory AS ChangeRecordCategory,
  ChangeRecord.ChangeRecordStatus AS ChangeRecordStatus,
  ChangeRecord.ChangeRecordType AS ChangeRecordType,
  ChangeRecord.ChangeNumber AS ChangeNumber,
  ChangeRecord.Partner AS Partner,
  ChangeRecord.ChgRecordApplication AS ChgRecordApplication,
  ChangeRecord.CreatedByUser AS CreatedByUser,
  ChangeRecord.ChangeRecordLifecycleStatus AS ChangeRecordLifecycleStatus,
  ChangeRecord.ChgRecordDescriptionText AS ChgRecordDescriptionText,
  ChangeRecord.ChgRecdEngEffectiveDate AS ChgRecdEngEffectiveDate,
  ChangeRecord.ChgRecdMfgEffectiveDate AS ChgRecdMfgEffectiveDate
FROM I_ChangeRecordBsc AS ChangeRecord
INNER JOIN P_MngUnassgdEBOMChgRecdType AS _EBOMChangeRecordType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChgRecdRefPlngScpBsc AS ChgRecdRefPlngScp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChgRecdRefEBOM AS ChgRecdRefEngBOM ON /* join condition not captured in parsed metadata */
;

Learn More