I_ChgRecdRefRoutingTP

DDL: I_CHGRECDREFROUTINGTP SQL: ICRREFROUTINGTP Type: view TRANSACTIONAL
26 Fields 2 Data Sources 2 Associations

Change Record Reference Object Routing TP

I_ChgRecdRefRoutingTP is a Transactional CDS View that provides data about "Change Record Reference Object Routing TP" in SAP S/4HANA. It reads from 2 data sources (I_ProductionRoutingVersion, I_ChgRecdRefRoutingBsc) and exposes 26 fields with key field ChangeRecordReferenceUUID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_ProductionRoutingVersion Routing left_outer
I_ChgRecdRefRoutingBsc routingReference from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ChangeRecordDraftTP _ChangeRecordTP $projection.ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID
[0..1] E_ChgRecdRefRoutingBsc _RoutingExtension $projection.ChangeRecordReferenceUUID = _RoutingExtension.ChangeRecordReferenceUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICRREFROUTINGTP view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Change Record Reference Object Routing TP view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence PLMCRREFROU_D view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdRefRoutingBsc ChangeRecordReferenceUUID UUID
ChangeRecordUUID I_ChgRecdRefRoutingBsc ChangeRecordUUID NodeID
ChangeRecordReferenceType I_ChgRecdRefRoutingBsc ChangeRecordReferenceType Object Type
ChangeRecordReferenceSubtype I_ChgRecdRefRoutingBsc ChangeRecordReferenceSubtype Subtype
ChangeRecordRefObjectUUID I_ChgRecdRefRoutingBsc ChangeRecordRefObjectUUID GUID-Key
ChangeRecordReference I_ChgRecdRefRoutingBsc ChangeRecordReference Ref. Object ID
ParentChangeRecordRefUUID I_ChgRecdRefRoutingBsc ParentChangeRecordRefUUID Node ID
IsMainReference I_ChgRecdRefRoutingBsc IsMainReference Main Reference
CreatedByUser I_ChgRecdRefRoutingBsc CreatedByUser User Name
CreationDateTime I_ChgRecdRefRoutingBsc CreationDateTime Timestamp
LastChangedByUser I_ChgRecdRefRoutingBsc LastChangedByUser User Name
LastChangeDateTime I_ChgRecdRefRoutingBsc LastChangeDateTime Timestamp
ChangeRecordItemRelevance I_ChgRecdRefRoutingBsc ChangeRecordItemRelevance Relevance
ChangeRecordVirtualRefInd I_ChgRecdRefRoutingBsc ChangeRecordVirtualRefInd Virtual Reference
Plant I_ProductionRoutingVersion Plant Valuation Area
OrderID I_ProductionRoutingVersion OrderID Order ID
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus Processing Status
ChgRecdItmTgtSts ChgRecdItmTgtSts Tgt Proc. Sts
ChgRecdItmDSgntr ChgRecdItmDSgntr Itm. Dgt. Sign.
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus Processing Status
ChgRecdReasonForChange I_ChgRecdRefRoutingBsc ChgRecdReasonForChange Reason for Chge
ExpdCompltnDte I_ChgRecdRefRoutingBsc ExpdCompltnDte Exp Completion Date
ChgRecdAuthznGrpText I_ChgRecdRefRoutingBsc ChgRecdAuthznGrpText Authoriz. Group
ChgRecdNmbrChgSts I_ChgRecdRefRoutingBsc ChgRecdNmbrChgSts Status
ChangeNumber I_ChgRecdRefRoutingBsc ChangeNumber Change Number
_ChangeRecordTP _ChangeRecordTP

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_ChgRecdRefRoutingTP.
-- 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: ICRREFROUTINGTP

CREATE VIEW I_ChgRecdRefRoutingTP AS
SELECT
  routingReference.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  routingReference.ChangeRecordUUID AS ChangeRecordUUID,
  routingReference.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  routingReference.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  routingReference.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  routingReference.ChangeRecordReference AS ChangeRecordReference,
  routingReference.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  routingReference.IsMainReference AS IsMainReference,
  routingReference.CreatedByUser AS CreatedByUser,
  routingReference.CreationDateTime AS CreationDateTime,
  routingReference.LastChangedByUser AS LastChangedByUser,
  routingReference.LastChangeDateTime AS LastChangeDateTime,
  routingReference.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  routingReference.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  Routing.Plant AS Plant,
  Routing.OrderID AS OrderID,
  ChangeRecordItemProcgStatus,
  ChgRecdItmTgtSts,
  ChgRecdItmDSgntr,
  ChgRecdCurrentItemProcgStatus,
  routingReference.ChgRecdReasonForChange AS ChgRecdReasonForChange,
  routingReference.ExpdCompltnDte AS ExpdCompltnDte,
  routingReference.ChgRecdAuthznGrpText AS ChgRecdAuthznGrpText,
  routingReference.ChgRecdNmbrChgSts AS ChgRecdNmbrChgSts,
  routingReference.ChangeNumber AS ChangeNumber
FROM I_ChgRecdRefRoutingBsc AS routingReference
LEFT OUTER JOIN I_ProductionRoutingVersion AS Routing ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChangeRecordDraftTP AS _ChangeRecordTP ON ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN E_ChgRecdRefRoutingBsc AS _RoutingExtension ON ChangeRecordReferenceUUID = _RoutingExtension.ChangeRecordReferenceUUID  -- association [0..1]
;

Learn More