I_MDChgProcBPRelshpMatchGrpTP

DDL: I_MDCHGPROCBPRELSHPMATCHGRPTP Type: view_entity TRANSACTIONAL
24 Fields 1 Data Sources 3 Associations

MD Cons BP Rel Match Group - TP

I_MDChgProcBPRelshpMatchGrpTP is a Transactional CDS View that provides data about "MD Cons BP Rel Match Group - TP" in SAP S/4HANA. It reads from 1 data source (I_MDChgProcessMatchGroupTP) and exposes 24 fields with key fields MasterDataChangeProcess, MDChgProcessMatchGroupID, MDChgProcessSrceObjectTypeCode. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MDChgProcessMatchGroupTP I_MDChgProcessMatchGroupTP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_MDChgProcBPRelshpGrpRecdTP _BestRecordDetails $projection.MasterDataChangeProcess = _BestRecordDetails.MasterDataChangeProcess and $projection.MDChgProcessMatchGroupID = _BestRecordDetails.MDChgProcessMatchGroupID and _BestRecordDetails.MDChgProcMatchGrpIsBestRecord = 'X'
[0..1] I_MDChgProcessStepTP _Step _Step.MasterDataChangeProcess = $projection.MasterDataChangeProcess and _Step.MDChgProcessStep = $projection.MDChgProcessStep
[0..*] I_MDChgProcBPRelshpGrpRecdTP _MatchGroupRecord

Annotations (8)

NameValueLevelField
Search.searchable false view
AccessControl.authorizationCheck #CHECK view
EndUserText.label MD Cons BP Rel Match Group - TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessMatchGroupID MDChgProcessMatchGroupID
KEY MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode Bus. Obj. Type
MDChgProcessNmbrOfSrceRecords MDChgProcessNmbrOfSrceRecords
MDChgProcessGoal MDChgProcessGoal Process Goal
MDChgProcessStep MDChgProcessStep Step Number
MDChgProcessCurrentStepNumber MDChgProcessCurrentStepNumber Step Number
MasterDataChangeProcessUUID MasterDataChangeProcessUUID NodeID
MDChgProcMatchGrpApprvlStatus MDChgProcMatchGrpApprvlStatus
_MatchGroupRecord _MatchGroupRecord
_MatchGroupApprovalStatus _MatchGroupApprovalStatus
BP1AuthorizationGroup _BestRecordDetails BP1AuthorizationGroup Authorization Group
BP2AuthorizationGroup _BestRecordDetails BP2AuthorizationGroup Authorization Group
MDChgProcessMatchGroupName _BestRecordDetails MDChgProcessRecordObjectText
MDChgProcessSrceSystem _BestRecordDetails MDChgProcessSrceSystem Source System
MDChgProcessSrceObject _BestRecordDetails MDChgProcessSrceObject Source ID
MDChgProcessStepWrkflwDefID _Step MDChgProcessStepWrkflwDefID
MDChgProcessStepWrkflwHandle _Step MDChgProcessStepWrkflwHandle
MDChgProcessStepWrkflwSts _Step MDChgProcessStepWrkflwSts
MDChgProcessStepWrkflwOvrlDcsn _Step MDChgProcessStepWrkflwOvrlDcsn
RelationshipCategory _BestRecordDetails RelationshipCategory Relationsh.Cat.
_BestRecordDetails _BestRecordDetails
_CurrentProcessStep _CurrentProcessStep
_Step _Step

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_MDChgProcBPRelshpMatchGrpTP.
-- 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 I_MDChgProcBPRelshpMatchGrpTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessMatchGroupID,
  MDChgProcessSrceObjectTypeCode,
  MDChgProcessNmbrOfSrceRecords,
  MDChgProcessGoal,
  MDChgProcessStep,
  MDChgProcessCurrentStepNumber,
  MasterDataChangeProcessUUID,
  MDChgProcMatchGrpApprvlStatus,
  _BestRecordDetails.BP1AuthorizationGroup AS BP1AuthorizationGroup,
  _BestRecordDetails.BP2AuthorizationGroup AS BP2AuthorizationGroup,
  _BestRecordDetails.MDChgProcessRecordObjectText AS MDChgProcessMatchGroupName,
  _BestRecordDetails.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  _BestRecordDetails.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  _Step.MDChgProcessStepWrkflwDefID AS MDChgProcessStepWrkflwDefID,
  _Step.MDChgProcessStepWrkflwHandle AS MDChgProcessStepWrkflwHandle,
  _Step.MDChgProcessStepWrkflwSts AS MDChgProcessStepWrkflwSts,
  _Step.MDChgProcessStepWrkflwOvrlDcsn AS MDChgProcessStepWrkflwOvrlDcsn,
  _BestRecordDetails.RelationshipCategory AS RelationshipCategory
FROM I_MDChgProcessMatchGroupTP
LEFT OUTER JOIN I_MDChgProcBPRelshpGrpRecdTP AS _BestRecordDetails ON MasterDataChangeProcess = _BestRecordDetails.MasterDataChangeProcess AND MDChgProcessMatchGroupID = _BestRecordDetails.MDChgProcessMatchGroupID AND _BestRecordDetails.MDChgProcMatchGrpIsBestRecord = 'X'  -- association [1..1]
LEFT OUTER JOIN I_MDChgProcessStepTP AS _Step ON _Step.MasterDataChangeProcess = MasterDataChangeProcess AND _Step.MDChgProcessStep = MDChgProcessStep  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcBPRelshpGrpRecdTP AS _MatchGroupRecord ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More