C_MDChgProcBPHierDetailsTP

DDL: C_MDCHGPROCBPHIERDETAILSTP Type: view_entity CONSUMPTION Package: MDC_BP_HIER_GOV_BO
36 Fields 1 Data Sources 5 Associations 3 OData Services

Proj. for BP Details of MD Change Proc.

C_MDChgProcBPHierDetailsTP is a Consumption CDS View that provides data about "Proj. for BP Details of MD Change Proc." in SAP S/4HANA. It reads from 1 data source (I_MDChangeProcessStepTP_2) and exposes 36 fields with key field MDChgProcessStepUUID. It has 5 associations to related views. It is exposed through 3 OData services (C_MDCHGPRCBPHDETAILSTP_SRV, C_MDCHGPRCBPHDETAILSTP_SRV, C_MDCHGPRCBPHDETAILSTP_SRV). Part of development package MDC_BP_HIER_GOV_BO.

Data Sources (1)

SourceAliasJoin Type
I_MDChangeProcessStepTP_2 I_MDChangeProcessStepTP_2 projection

Associations (5)

CardinalityTargetAliasCondition
[0..*] C_BPHierarchyProcessTP _Hierarchy $projection.MasterDataChangeProcess = _Hierarchy.MasterDataChangeProcess and $projection.MDChgProcessStep = _Hierarchy.MDChgProcessStep
[0..*] C_BPHierDescriptionProcessTP _HierarchyDescription $projection.MasterDataChangeProcess = _HierarchyDescription.MasterDataChangeProcess and $projection.MDChgProcessStep = _HierarchyDescription.MDChgProcessStep
[0..*] C_BPHierarchyNodeProcessTP _HierarchyNode $projection.MasterDataChangeProcess = _HierarchyNode.MasterDataChangeProcess and $projection.MDChgProcessStep = _HierarchyNode.MDChgProcessStep
[0..*] C_BPHierNodeDescriptionProcTP _HierarchyNodeDescription $projection.MasterDataChangeProcess = _HierarchyNodeDescription.MasterDataChangeProcess and $projection.MDChgProcessStep = _HierarchyNodeDescription.MDChgProcessStep
[0..*] C_BPHierNodeTimeSliceProcessTP _HierarchyNodeTimeSlice $projection.MasterDataChangeProcess = _HierarchyNodeTimeSlice.MasterDataChangeProcess and $projection.MDChgProcessStep = _HierarchyNodeTimeSlice.MDChgProcessStep

Annotations (8)

NameValueLevelField
EndUserText.label Proj. for BP Details of MD Change Proc. view
Metadata.allowExtensions true view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view

OData Services (3)

ServiceBindingVersionContractRelease
C_MDCHGPRCBPHDETAILSTP_SRV C_MDCHGPRCBPHDETAILSTP_SRV V2 C1 NOT_RELEASED
C_MDCHGPRCBPHDETAILSTP_SRV C_MDCHGPRCBPHDETAILSTP_V2 V2 C1 NOT_RELEASED
C_MDCHGPRCBPHDETAILSTP_SRV C_MDCHGPRCBPHDETAILSTP_V4 V4 C1 NOT_RELEASED

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessStepUUID MDChgProcessStepUUID
MasterDataChangeProcessUUID MasterDataChangeProcessUUID NodeID
MasterDataChangeProcess MasterDataChangeProcess Process ID
MDChgProcessStep MDChgProcessStep Step Number
MDChgProcessStepType MDChgProcessStepType
char100
MDChgProcessStepDescription MDChgProcessStepDescription
MDChgProcessStepStatus MDChgProcessStepStatus
MDChgProcessStepAdapter MDChgProcessStepAdapter
MDChgProcessStepAdapterConfign MDChgProcessStepAdapterConfign
MDChgProcessStepChkPointIsActv MDChgProcessStepChkPointIsActv
MDChgProcessStepOriglNumber MDChgProcessStepOriglNumber
MDChgProcessStepOriglSqncNmbr MDChgProcessStepOriglSqncNmbr
MDChgProcessStepStartIsReqd MDChgProcessStepStartIsReqd
MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode Bus. Obj. Type
MDChgProcessStepFilterChain MDChgProcessStepFilterChain
MDChgProcessStepStartDateTime MDChgProcessStepStartDateTime
MDChgProcessStepFinishDateTime MDChgProcessStepFinishDateTime
MDChgProcessStepConfign MDChgProcessStepConfign
MDChgProcessStpOwnConfignIsRqd MDChgProcessStpOwnConfignIsRqd
MDChgProcessDescription _MasterDataChangeProcess MDChgProcessDescription Process Description
MDChgProcessGoal MDChgProcessGoal Process Goal
MDChgProcessGoalNamelocalized
MDChgProcessNmbrOfSrceRecords MDChgProcessNmbrOfSrceRecords
MDChgProcessCurrentStepNumber MDChgProcessCurrentStepNumber Step Number
MDChgProcessStepWrkflwDefID MDChgProcessStepWrkflwDefID
MDChgProcessStepWrkflwHandle MDChgProcessStepWrkflwHandle
MDChgProcessStepWrkflwSts MDChgProcessStepWrkflwSts
MDChgProcessStepWrkflwOvrlDcsn MDChgProcessStepWrkflwOvrlDcsn
virtualMDChgProcNodeIsHiddenabap_boolean
_MasterDataChangeProcess _MasterDataChangeProcess
_Hierarchy _Hierarchy
_HierarchyDescription _HierarchyDescription
_HierarchyNode _HierarchyNode
_HierarchyNodeDescription _HierarchyNodeDescription
_HierarchyNodeTimeSlice _HierarchyNodeTimeSlice

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 C_MDChgProcBPHierDetailsTP.
-- 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 C_MDChgProcBPHierDetailsTP AS
SELECT
  MDChgProcessStepUUID,
  MasterDataChangeProcessUUID,
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessStepType,
  virtual MDChgProcessStepTypeName : abap.char(100) AS char100,
  MDChgProcessStepDescription,
  MDChgProcessStepStatus,
  MDChgProcessStepAdapter,
  MDChgProcessStepAdapterConfign,
  MDChgProcessStepChkPointIsActv,
  MDChgProcessStepOriglNumber,
  MDChgProcessStepOriglSqncNmbr,
  MDChgProcessStepStartIsReqd,
  MDChgProcessSrceObjectTypeCode,
  MDChgProcessStepFilterChain,
  MDChgProcessStepStartDateTime,
  MDChgProcessStepFinishDateTime,
  MDChgProcessStepConfign,
  MDChgProcessStpOwnConfignIsRqd,
  _MasterDataChangeProcess.MDChgProcessDescription AS MDChgProcessDescription,
  MDChgProcessGoal,
  _ProcessGoal._Text.MDChgProcessGoalName : localized AS MDChgProcessGoalNamelocalized,
  MDChgProcessNmbrOfSrceRecords,
  MDChgProcessCurrentStepNumber,
  MDChgProcessStepWrkflwDefID,
  MDChgProcessStepWrkflwHandle,
  MDChgProcessStepWrkflwSts,
  MDChgProcessStepWrkflwOvrlDcsn,
  virtual MDChgProcNodeIsHidden : abap_boolean AS virtualMDChgProcNodeIsHiddenabap_boolean
FROM I_MDChangeProcessStepTP_2
LEFT OUTER JOIN C_BPHierarchyProcessTP AS _Hierarchy ON MasterDataChangeProcess = _Hierarchy.MasterDataChangeProcess AND MDChgProcessStep = _Hierarchy.MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN C_BPHierDescriptionProcessTP AS _HierarchyDescription ON MasterDataChangeProcess = _HierarchyDescription.MasterDataChangeProcess AND MDChgProcessStep = _HierarchyDescription.MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN C_BPHierarchyNodeProcessTP AS _HierarchyNode ON MasterDataChangeProcess = _HierarchyNode.MasterDataChangeProcess AND MDChgProcessStep = _HierarchyNode.MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN C_BPHierNodeDescriptionProcTP AS _HierarchyNodeDescription ON MasterDataChangeProcess = _HierarchyNodeDescription.MasterDataChangeProcess AND MDChgProcessStep = _HierarchyNodeDescription.MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN C_BPHierNodeTimeSliceProcessTP AS _HierarchyNodeTimeSlice ON MasterDataChangeProcess = _HierarchyNodeTimeSlice.MasterDataChangeProcess AND MDChgProcessStep = _HierarchyNodeTimeSlice.MDChgProcessStep  -- association [0..*]
;

Learn More