I_ChgRecdRefProdnOrdTP

DDL: I_CHGRECDREFPRODNORDTP SQL: ICHGRECDREFPPOTP Type: view TRANSACTIONAL
27 Fields 2 Data Sources 2 Associations

Change Record Reference Object Prodn Ord

I_ChgRecdRefProdnOrdTP is a Transactional CDS View that provides data about "Change Record Reference Object Prodn Ord" in SAP S/4HANA. It reads from 2 data sources (I_ChangeRecordMfgOrder, I_ChgRecdRefProdnOrdBsc) and exposes 27 fields with key field ChangeRecordReferenceUUID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_ChangeRecordMfgOrder ProdOrder left_outer
I_ChgRecdRefProdnOrdBsc reference_ppo from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ChangeRecordDraftTP _ChangeRecord $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID
[0..1] E_ChgRecdRefProdnOrdBsc _ProdnOrdExtension $projection.ChangeRecordReferenceUUID = _ProdnOrdExtension.ChangeRecordReferenceUUID

Annotations (11)

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

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdRefProdnOrdBsc ChangeRecordReferenceUUID UUID
ChangeRecordUUID I_ChgRecdRefProdnOrdBsc ChangeRecordUUID NodeID
ChangeRecordReferenceSubtype I_ChgRecdRefProdnOrdBsc ChangeRecordReferenceSubtype Subtype
ChangeRecordReferenceType I_ChgRecdRefProdnOrdBsc ChangeRecordReferenceType Object Type
ChangeRecordRefObjectUUID I_ChgRecdRefProdnOrdBsc ChangeRecordRefObjectUUID GUID-Key
ChangeRecordReference I_ChgRecdRefProdnOrdBsc ChangeRecordReference Ref. Object ID
ParentChangeRecordRefUUID I_ChgRecdRefProdnOrdBsc ParentChangeRecordRefUUID Node ID
IsMainReference I_ChgRecdRefProdnOrdBsc IsMainReference Main Reference
CreatedByUser I_ChgRecdRefProdnOrdBsc CreatedByUser User Name
CreationDateTime I_ChgRecdRefProdnOrdBsc CreationDateTime Timestamp
LastChangedByUser I_ChgRecdRefProdnOrdBsc LastChangedByUser User Name
LastChangeDateTime I_ChgRecdRefProdnOrdBsc LastChangeDateTime Timestamp
ChangeRecordItemRelevance I_ChgRecdRefProdnOrdBsc ChangeRecordItemRelevance Relevance
ChangeRecordVirtualRefInd I_ChgRecdRefProdnOrdBsc ChangeRecordVirtualRefInd Virtual Reference
ManufacturingOrderType I_ChangeRecordMfgOrder ManufacturingOrderType
ManufacturingOrderCategory I_ChangeRecordMfgOrder ManufacturingOrderCategory
ProductionPlant I_ChangeRecordMfgOrder ProductionPlant Prod plnt
ChangeRecordItemProcgStatus I_ChgRecdRefProdnOrdBsc ChangeRecordItemProcgStatus Processing Status
ChgRecdItmTgtSts
ChgRecdItmDSgntr I_ChgRecdRefProdnOrdBsc ChgRecdItmDSgntr Itm. Dgt. Sign.
ChgRecdCurrentItemProcgStatus I_ChgRecdRefProdnOrdBsc ChgRecdCurrentItemProcgStatus Processing Status
ChgRecdReasonForChange I_ChgRecdRefProdnOrdBsc ChgRecdReasonForChange Reason for Chge
ExpdCompltnDte I_ChgRecdRefProdnOrdBsc ExpdCompltnDte Exp Completion Date
ChgRecdAuthznGrpText I_ChgRecdRefProdnOrdBsc ChgRecdAuthznGrpText Authoriz. Group
ChgRecdNmbrChgSts I_ChgRecdRefProdnOrdBsc ChgRecdNmbrChgSts Status
ChangeNumber I_ChgRecdRefProdnOrdBsc ChangeNumber Change Number
_ChangeRecord _ChangeRecord

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_ChgRecdRefProdnOrdTP.
-- 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: ICHGRECDREFPPOTP

CREATE VIEW I_ChgRecdRefProdnOrdTP AS
SELECT
  reference_ppo.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  reference_ppo.ChangeRecordUUID AS ChangeRecordUUID,
  reference_ppo.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  reference_ppo.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  reference_ppo.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  reference_ppo.ChangeRecordReference AS ChangeRecordReference,
  reference_ppo.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  reference_ppo.IsMainReference AS IsMainReference,
  reference_ppo.CreatedByUser AS CreatedByUser,
  reference_ppo.CreationDateTime AS CreationDateTime,
  reference_ppo.LastChangedByUser AS LastChangedByUser,
  reference_ppo.LastChangeDateTime AS LastChangeDateTime,
  reference_ppo.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  reference_ppo.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  ProdOrder.ManufacturingOrderType AS ManufacturingOrderType,
  ProdOrder.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  ProdOrder.ProductionPlant AS ProductionPlant,
  reference_ppo.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus,
  reference_ppo. ChgRecdItmTgtSts AS ChgRecdItmTgtSts,
  reference_ppo.ChgRecdItmDSgntr AS ChgRecdItmDSgntr,
  reference_ppo.ChgRecdCurrentItemProcgStatus AS ChgRecdCurrentItemProcgStatus,
  reference_ppo.ChgRecdReasonForChange AS ChgRecdReasonForChange,
  reference_ppo.ExpdCompltnDte AS ExpdCompltnDte,
  reference_ppo.ChgRecdAuthznGrpText AS ChgRecdAuthznGrpText,
  reference_ppo.ChgRecdNmbrChgSts AS ChgRecdNmbrChgSts,
  reference_ppo.ChangeNumber AS ChangeNumber
FROM I_ChgRecdRefProdnOrdBsc AS reference_ppo
LEFT OUTER JOIN I_ChangeRecordMfgOrder AS ProdOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChangeRecordDraftTP AS _ChangeRecord ON ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN E_ChgRecdRefProdnOrdBsc AS _ProdnOrdExtension ON ChangeRecordReferenceUUID = _ProdnOrdExtension.ChangeRecordReferenceUUID  -- association [0..1]
;

Learn More