I_MDChgProcStepEffctvConfignTP

DDL: I_MDCHGPROCSTEPEFFCTVCONFIGNTP SQL: IMDCHGPSTECONFTP Type: view TRANSACTIONAL
28 Fields 1 Data Sources 6 Associations

MD Chg Proc Step Effective Configuration

I_MDChgProcStepEffctvConfignTP is a Transactional CDS View that provides data about "MD Chg Proc Step Effective Configuration" in SAP S/4HANA. It reads from 1 data source (I_MDChgProcStepEffctvConfign) and exposes 28 fields with key field MDChgProcessStepUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MDChgProcStepEffctvConfign MDChgProcStepConfiguration from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_MDEffctvConfignEvaluationTP _MDEffctvConfignEval
[0..1] I_MDEffctvConfignActivationTP _MDEffctvConfignActivation
[0..1] I_MDEffctvConfignBstRecdCalcTP _MDEffctvConfignBRC
[0..1] I_MDEffctvConfignFuzzyTP _MDEffctvConfignFuzzy
[0..1] I_MDEffctvConfignValidationTP _MDEffctvConfignValidation
[0..1] I_MDEffctvConfignFilterTP _MDEffctvConfignFilter

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPSTECONFTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label MD Chg Proc Step Effective Configuration view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessStepUUID I_MDChgProcStepEffctvConfign MDChgProcessStepUUID UUID
MasterDataChangeProcessUUID I_MDChgProcStepEffctvConfign MasterDataChangeProcessUUID NodeID
MasterDataChangeProcess I_MDChgProcStepEffctvConfign MasterDataChangeProcess Process ID
MDChgProcessStep I_MDChgProcStepEffctvConfign MDChgProcessStep Step Number
MDChgProcessStepType I_MDChgProcStepEffctvConfign MDChgProcessStepType VSS Sol. Step Type
MDChgProcessStepDescription I_MDChgProcStepEffctvConfign MDChgProcessStepDescription Well Code Des.
MDChgProcessStepStatus I_MDChgProcStepEffctvConfign MDChgProcessStepStatus Workflow Status
MDChgProcessStepAdapter I_MDChgProcStepEffctvConfign MDChgProcessStepAdapter Step Adapter
MDChgProcessStepAdapterConfign I_MDChgProcStepEffctvConfign MDChgProcessStepAdapterConfign Configuration ID
MDChgProcessStepChkPointIsActv I_MDChgProcStepEffctvConfign MDChgProcessStepChkPointIsActv Check Point active
MDChgProcessStepOriglNumber I_MDChgProcStepEffctvConfign MDChgProcessStepOriglNumber Step Number
MDChgProcessStepOriglSqncNmbr I_MDChgProcStepEffctvConfign MDChgProcessStepOriglSqncNmbr Step Sequence
MDChgProcessStepStartIsReqd I_MDChgProcStepEffctvConfign MDChgProcessStepStartIsReqd Start Requested
MDChgProcessSrceObjectTypeCode I_MDChgProcStepEffctvConfign MDChgProcessSrceObjectTypeCode Bus. Obj. Type
MDChgProcessStepStartDateTime I_MDChgProcStepEffctvConfign MDChgProcessStepStartDateTime Time Stamp
MDChgProcessStepFinishDateTime I_MDChgProcStepEffctvConfign MDChgProcessStepFinishDateTime Time Stamp
MDChgProcessStepConfign I_MDChgProcStepEffctvConfign MDChgProcessStepConfign Config. UUID
MDChgProcessStpOwnConfignIsRqd I_MDChgProcStepEffctvConfign MDChgProcessStpOwnConfignIsRqd Use Own
MDChgProcIsAdhocStep I_MDChgProcStepEffctvConfign MDChgProcIsAdhocStep Ad hoc Step
MDChgProcessStepActionControl I_MDChgProcStepEffctvConfign MDChgProcessStepActionControl Process Action Ctrl
MDChgProcessStepAuthznGroup I_MDChgProcStepEffctvConfign MDChgProcessStepAuthznGroup AuthorizGroup
_MDChgProcEffctvConfign _MDChgProcEffctvConfign
_MDEffctvConfignEval _MDEffctvConfignEval
_MDEffctvConfignActivation _MDEffctvConfignActivation
_MDEffctvConfignBRC _MDEffctvConfignBRC
_MDEffctvConfignFuzzy _MDEffctvConfignFuzzy
_MDEffctvConfignValidation _MDEffctvConfignValidation
_MDEffctvConfignFilter _MDEffctvConfignFilter

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_MDChgProcStepEffctvConfignTP.
-- 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: IMDCHGPSTECONFTP

CREATE VIEW I_MDChgProcStepEffctvConfignTP AS
SELECT
  MDChgProcStepConfiguration.MDChgProcessStepUUID AS MDChgProcessStepUUID,
  MDChgProcStepConfiguration.MasterDataChangeProcessUUID AS MasterDataChangeProcessUUID,
  MDChgProcStepConfiguration.MasterDataChangeProcess AS MasterDataChangeProcess,
  MDChgProcStepConfiguration.MDChgProcessStep AS MDChgProcessStep,
  MDChgProcStepConfiguration.MDChgProcessStepType AS MDChgProcessStepType,
  MDChgProcStepConfiguration.MDChgProcessStepDescription AS MDChgProcessStepDescription,
  MDChgProcStepConfiguration.MDChgProcessStepStatus AS MDChgProcessStepStatus,
  MDChgProcStepConfiguration.MDChgProcessStepAdapter AS MDChgProcessStepAdapter,
  MDChgProcStepConfiguration.MDChgProcessStepAdapterConfign AS MDChgProcessStepAdapterConfign,
  MDChgProcStepConfiguration.MDChgProcessStepChkPointIsActv AS MDChgProcessStepChkPointIsActv,
  MDChgProcStepConfiguration.MDChgProcessStepOriglNumber AS MDChgProcessStepOriglNumber,
  MDChgProcStepConfiguration.MDChgProcessStepOriglSqncNmbr AS MDChgProcessStepOriglSqncNmbr,
  MDChgProcStepConfiguration.MDChgProcessStepStartIsReqd AS MDChgProcessStepStartIsReqd,
  MDChgProcStepConfiguration.MDChgProcessSrceObjectTypeCode AS MDChgProcessSrceObjectTypeCode,
  MDChgProcStepConfiguration.MDChgProcessStepStartDateTime AS MDChgProcessStepStartDateTime,
  MDChgProcStepConfiguration.MDChgProcessStepFinishDateTime AS MDChgProcessStepFinishDateTime,
  MDChgProcStepConfiguration.MDChgProcessStepConfign AS MDChgProcessStepConfign,
  MDChgProcStepConfiguration.MDChgProcessStpOwnConfignIsRqd AS MDChgProcessStpOwnConfignIsRqd,
  MDChgProcStepConfiguration.MDChgProcIsAdhocStep AS MDChgProcIsAdhocStep,
  MDChgProcStepConfiguration.MDChgProcessStepActionControl AS MDChgProcessStepActionControl,
  MDChgProcStepConfiguration.MDChgProcessStepAuthznGroup AS MDChgProcessStepAuthznGroup
FROM I_MDChgProcStepEffctvConfign AS MDChgProcStepConfiguration
LEFT OUTER JOIN I_MDEffctvConfignEvaluationTP AS _MDEffctvConfignEval ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_MDEffctvConfignActivationTP AS _MDEffctvConfignActivation ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_MDEffctvConfignBstRecdCalcTP AS _MDEffctvConfignBRC ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_MDEffctvConfignFuzzyTP AS _MDEffctvConfignFuzzy ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_MDEffctvConfignValidationTP AS _MDEffctvConfignValidation ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_MDEffctvConfignFilterTP AS _MDEffctvConfignFilter ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More