I_ChangeRecordProdnRouting_2

DDL: I_CHANGERECORDPRODNROUTING_2 Type: view_entity COMPOSITE Package: VDM_PLMB_CR_RAP
8 Fields 4 Data Sources

Change Record Production Routing

I_ChangeRecordProdnRouting_2 is a Composite CDS View that provides data about "Change Record Production Routing" in SAP S/4HANA. It reads from 4 data sources (I_ChangeRecordItemDetail, I_ChgRecdProdnRoutingDetail, R_CHGRECDATAMIGRATIONSTATUS, R_CHGRECDATAMIGRATIONSTATUS) and exposes 8 fields with key field ChangeRecordReferenceUUID. Part of development package VDM_PLMB_CR_RAP.

Data Sources (4)

SourceAliasJoin Type
I_ChangeRecordItemDetail itemsOld from
I_ChgRecdProdnRoutingDetail ProdnRouting union_all
R_CHGRECDATAMIGRATIONSTATUS tf inner
R_CHGRECDATAMIGRATIONSTATUS tf inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Change Record Production Routing view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChangeRecordItemDetail ChangeRecordReferenceUUID UUID
ChangeRecordUUID I_ChangeRecordItemDetail ChangeRecordUUID NodeID
ChangeRecordUUID I_ChgRecdProdnRoutingDetail ChangeRecordUUID NodeID
Material I_ChgRecdProdnRoutingDetail Material Vehicle Model
Plant I_ChgRecdProdnRoutingDetail Plant Valuation Area
BillOfOperationsType I_ChgRecdProdnRoutingDetail BillOfOperationsType Task List Type
BillOfOperationsGroup I_ChgRecdProdnRoutingDetail BillOfOperationsGroup Group
BillOfOperationsVariant I_ChgRecdProdnRoutingDetail BillOfOperationsVariant Group Counter

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_ChangeRecordProdnRouting_2.
-- 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 I_ChangeRecordProdnRouting_2 AS
SELECT
  itemsOld.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  itemsOld.ChangeRecordUUID AS ChangeRecordUUID,
  ProdnRouting.Material AS Material,
  ProdnRouting.Plant AS Plant,
  ProdnRouting.BillOfOperationsType AS BillOfOperationsType,
  ProdnRouting.BillOfOperationsGroup AS BillOfOperationsGroup,
  ProdnRouting.BillOfOperationsVariant AS BillOfOperationsVariant
FROM I_ChangeRecordItemDetail AS itemsOld
INNER JOIN R_CHGRECDATAMIGRATIONSTATUS AS tf ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_ChgRecdProdnRoutingDetail
;

Learn More