I_ChangeRecordDraftTP

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_ChangeRecordDraftTP.
-- 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: ICHGRECD_DRAFTTP

CREATE VIEW I_ChangeRecordDraftTP AS
SELECT
  ChangeRecordBsc.ChangeRecordUUID AS ChangeRecordUUID,
  ChangeRecord,
  ChangeRecordType,
  ParentChangeRecordUUID,
  RootChangeRecordUUID,
  ChangeRecordPriority AS ChangeRecordHdrPriorityCode,
  ChangeRecordStatus,
  cast( _LogAccMContext.LogAccMContext as /plmb/auth_owning_acc_id_ext preserving type) AS AccessControlContext,
  ChangeRecordBsc.LogAccMSecureIDOwnerID AS LogAccMSecureIDOwnerID,
  ChangeNumber,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  Partner,
  ChangeRecordLifecycleStatus,
  ChgRecdDigitalSignatureStatus,
  ChgRecordDescriptionText,
  ChgRecdAuthGroup,
  ChgRecdEffectivityType,
  ChgRecdPrflIdn,
  ChgRecdReasonForChange,
  ChgRecdChangeStatus,
  ChgRecdExpectedCompletionDate,
  ChangeRecordDetailDescription,
  ChgRecdHdrExtnUUID,
  ChgRecdInitiatedStatusAction,
  ChgRecdEngEffectiveDate,
  ChgRecdMfgEffectiveDate,
  ChangeRecordItemIsNotEditable,
  ChangeRecordItmIsAddDelEnabled,
  ChangeRecordItemEditMode,
  ChgRecdHdrRsnForChgCode,
  ChangeRecordBsc._LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn,
  ChangeRecordBsc._LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt
FROM I_ChangeRecordBsc AS ChangeRecordBsc
LEFT OUTER JOIN I_ChangeRecordType AS _ChangeRecordCategory ON _ChangeRecordCategory.ChangeRecordType = ChangeRecordType  -- association [1..1]
LEFT OUTER JOIN I_ChangeRecordDescriptionTP AS _ChangeRecordDescriptionTP ON _ChangeRecordDescriptionTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordReferenceMatTP AS _ChangeRecordReferenceMatTP ON _ChangeRecordReferenceMatTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordReferenceBOMTP AS _ChangeRecordReferenceBOMTP ON _ChangeRecordReferenceBOMTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordRefBOMItmTP AS _ChangeRecordRefBOMItmTP ON _ChangeRecordRefBOMItmTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefPlngScpTP AS _ChgRecdRefPlngScpTP ON _ChgRecdRefPlngScpTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefEngBOMTP AS _ChgRecdRefEngBOMTP ON _ChgRecdRefEngBOMTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefMfgBOMTP AS _ChgRecdRefMfgBOMTP ON _ChgRecdRefMfgBOMTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefProdnOrdTP AS _ChgRecdRefProdnOrdTP ON _ChgRecdRefProdnOrdTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefPurOrdTP AS _ChgRecdRefPurOrdTP ON _ChgRecdRefPurOrdTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefRoutingTP AS _ChgRecdRefRoutingTP ON _ChgRecdRefRoutingTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefOrdSpcfcRoutingTP AS _ChgRecdRefOrdSpcfcRoutingTP ON _ChgRecdRefOrdSpcfcRoutingTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordReferenceDOCTP AS _ChangeRecordReferenceDocTP ON _ChangeRecordReferenceDocTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefProdStrucVarTP AS _ChgRecdRefProdStrucVarTP ON _ChgRecdRefProdStrucVarTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordReferenceSpecTP AS _ChangeRecordReferenceSpecTP ON _ChangeRecordReferenceSpecTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefEngSnpshtTP AS _ChgRecdRefEngSnpshtTP ON _ChgRecdRefEngSnpshtTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordAccCtrlContext AS _LogAccMContext ON _LogAccMContext.LogAccMContextInternalId = LogAccMSecureIDOwnerID  -- association [0..1]
LEFT OUTER JOIN I_ChgRecdRefMasterRecipeTP AS _ChgRecdRefMasterRecipeTP ON _ChgRecdRefMasterRecipeTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefInspectionPlanTP AS _ChgRecdRefInspectionPlanTP ON _ChgRecdRefInspectionPlanTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefRecipeTP AS _ChgRecdRefRecipeTP ON _ChgRecdRefRecipeTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefLabelTP AS _ChgRecdRefLabelTP ON _ChgRecdRefLabelTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefProdnRoutingTP AS _ChgRecdRefProdnRoutingTP ON _ChgRecdRefProdnRoutingTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefPlngRoutingTP AS _ChgRecdRefPlngRoutingTP ON _ChgRecdRefPlngRoutingTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefTmplRoutingTP AS _ChgRecdRefTmplRoutingTP ON _ChgRecdRefTmplRoutingTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN E_ChangeRecordBsc AS _HeaderExtension ON ChangeRecordUUID = _HeaderExtension.ChangeRecordUUID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON LastChangedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_ChgRecdCmntTopTP AS _ChgRecdCmntTopTP ON _ChgRecdCmntTopTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdObjRefCmntTopTP AS _ChgRecdObjRefCmntTopTP ON _ChgRecdObjRefCmntTopTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdChildTP AS _ChgRecdChildTP ON _ChgRecdChildTP.ParentChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordRefOrderBOMTP AS _ChangeRecordRefOrderBOMTP ON _ChangeRecordRefOrderBOMTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordRefCharcTP AS _ChangeRecordRefCharcTP ON _ChangeRecordRefCharcTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordRefClassTP AS _ChangeRecordRefClassTP ON _ChangeRecordRefClassTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefMaintTskListTP AS _ChgRecdRefMaintTskListTP ON _ChgRecdRefMaintTskListTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordRefStdBOMTP AS _ChangeRecordRefStdBOMTP ON _ChangeRecordRefStdBOMTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefEquipTskListTP AS _ChgRecdRefEquipTskListTP ON _ChgRecdRefEquipTskListTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordRefWBSElmntBOMTP AS _ChangeRecordRefWBSElmntBOMTP ON _ChangeRecordRefWBSElmntBOMTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefEquipBOMTP AS _ChgRecdRefEquipBOMTP ON _ChgRecdRefEquipBOMTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefRateRtgTskListTP AS _ChgRecdRefRateRtgTskListTP ON _ChgRecdRefRateRtgTskListTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRateRtgTskListTP AS _ChgRecdRateRtgTskListTP ON _ChgRecdRateRtgTskListTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefCutPlngPrflTP AS _ChgRecdRefCutPlngPrflTP ON _ChgRecdRefCutPlngPrflTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefOpSetTskListTP AS _ChgRecdRefOpSetTskListTP ON _ChgRecdRefOpSetTskListTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefFuncLocBOMTP AS _ChgRecdRefFuncLocBOMTP ON _ChgRecdRefFuncLocBOMTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdFuncLocTskListTP AS _ChgRecdFuncLocTskListTP ON _ChgRecdFuncLocTskListTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefVarBOMTP AS _ChgRecdRefVarBOMTP ON _ChgRecdRefVarBOMTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefMfgSnpshtTP AS _ChgRecdRefMfgSnpshtTP ON _ChgRecdRefMfgSnpshtTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefETOVersBOMTP AS _ChgRecdRefETOVersBOMTP ON _ChgRecdRefETOVersBOMTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefDefectTP AS _ChgRecdRefDefectTP ON _ChgRecdRefDefectTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefNotificationTP AS _ChgRecdRefNotificationTP ON _ChgRecdRefNotificationTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordRelatedChangeTP AS _ChangeRecordRelatedChangeTP ON _ChangeRecordRelatedChangeTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefScopeOfChangeTP AS _ChgRecdRefScopeOfChangeTP ON _ChgRecdRefScopeOfChangeTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordCustomObjectTP AS _ChangeRecordCustomObjectTP ON _ChangeRecordCustomObjectTP.ChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
;