I_ChgRecdRefProdnRoutingTP

DDL: I_CHGRECDREFPRODNROUTINGTP SQL: ICRREFPRDNRTGTP Type: view TRANSACTIONAL
26 Fields 1 Data Sources 2 Associations

Change Record Reference Object Production Routing TP

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

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefProdnRoutingBsc reference_PRG from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ChangeRecordDraftTP _ChangeRecordTP $projection.ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID
[0..1] E_ChgRecdRefProdnRoutingBsc _ProdnRoutingExtension $projection.ChangeRecordReferenceUUID = _ProdnRoutingExtension.ChangeRecordReferenceUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ICRREFPRDNRTGTP view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Change Record Reference Object Production Routing TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence PLMCRREFPRG_D view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION 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
AbapCatalog.preserveKey true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdRefProdnRoutingBsc ChangeRecordReferenceUUID UUID
ChangeRecordUUID I_ChgRecdRefProdnRoutingBsc ChangeRecordUUID NodeID
ChangeRecordReferenceType I_ChgRecdRefProdnRoutingBsc ChangeRecordReferenceType Object Type
ChangeRecordReferenceSubtype I_ChgRecdRefProdnRoutingBsc ChangeRecordReferenceSubtype Subtype
ChangeRecordRefObjectUUID I_ChgRecdRefProdnRoutingBsc ChangeRecordRefObjectUUID GUID-Key
ChangeRecordReference I_ChgRecdRefProdnRoutingBsc ChangeRecordReference Ref. Object ID
ParentChangeRecordRefUUID I_ChgRecdRefProdnRoutingBsc ParentChangeRecordRefUUID Node ID
IsMainReference I_ChgRecdRefProdnRoutingBsc IsMainReference Main Reference
ChgRecdReasonForChange ChgRecdReasonForChange Reason for Chge
ExpdCompltnDte ExpdCompltnDte Exp Completion Date
ChgRecdAuthznGrpText ChgRecdAuthznGrpText Authoriz. Group
ChgRecdNmbrChgSts ChgRecdNmbrChgSts Status
ChangeNumber ChangeNumber Change Number
ChgRecdDescription ChgRecdDescription Well Code Des.
ChgRecdEffectivityType ChgRecdEffectivityType Effect. Type
CreatedByUser I_ChgRecdRefProdnRoutingBsc CreatedByUser User Name
CreationDateTime I_ChgRecdRefProdnRoutingBsc CreationDateTime Timestamp
LastChangedByUser I_ChgRecdRefProdnRoutingBsc LastChangedByUser User Name
LastChangeDateTime I_ChgRecdRefProdnRoutingBsc LastChangeDateTime Timestamp
ChangeRecordItemRelevance I_ChgRecdRefProdnRoutingBsc ChangeRecordItemRelevance Relevance
ChangeRecordVirtualRefInd I_ChgRecdRefProdnRoutingBsc ChangeRecordVirtualRefInd Virtual Reference
ChangeRecordItemProcgStatus I_ChgRecdRefProdnRoutingBsc ChangeRecordItemProcgStatus Processing Status
ChgRecdCurrentItemProcgStatus I_ChgRecdRefProdnRoutingBsc ChgRecdCurrentItemProcgStatus Processing Status
ChgRecdItmTgtSts I_ChgRecdRefProdnRoutingBsc ChgRecdItmTgtSts Tgt Proc. Sts
ChgRecdItmDSgntr I_ChgRecdRefProdnRoutingBsc ChgRecdItmDSgntr Itm. Dgt. Sign.
_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_ChgRecdRefProdnRoutingTP.
-- 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: ICRREFPRDNRTGTP

CREATE VIEW I_ChgRecdRefProdnRoutingTP AS
SELECT
  reference_PRG.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  reference_PRG.ChangeRecordUUID AS ChangeRecordUUID,
  reference_PRG.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  reference_PRG.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  reference_PRG.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  reference_PRG.ChangeRecordReference AS ChangeRecordReference,
  reference_PRG.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  reference_PRG.IsMainReference AS IsMainReference,
  ChgRecdReasonForChange,
  ExpdCompltnDte,
  ChgRecdAuthznGrpText,
  ChgRecdNmbrChgSts,
  ChangeNumber,
  ChgRecdDescription,
  ChgRecdEffectivityType,
  reference_PRG.CreatedByUser AS CreatedByUser,
  reference_PRG.CreationDateTime AS CreationDateTime,
  reference_PRG.LastChangedByUser AS LastChangedByUser,
  reference_PRG.LastChangeDateTime AS LastChangeDateTime,
  reference_PRG.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  reference_PRG.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  reference_PRG.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus,
  reference_PRG.ChgRecdCurrentItemProcgStatus AS ChgRecdCurrentItemProcgStatus,
  reference_PRG.ChgRecdItmTgtSts AS ChgRecdItmTgtSts,
  reference_PRG.ChgRecdItmDSgntr AS ChgRecdItmDSgntr
FROM I_ChgRecdRefProdnRoutingBsc AS reference_PRG
LEFT OUTER JOIN I_ChangeRecordDraftTP AS _ChangeRecordTP ON ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN E_ChgRecdRefProdnRoutingBsc AS _ProdnRoutingExtension ON ChangeRecordReferenceUUID = _ProdnRoutingExtension.ChangeRecordReferenceUUID  -- association [0..1]
;

Learn More