C_BusPartRelshpTmeDpndcyProcTP

DDL: C_BUSPARTRELSHPTMEDPNDCYPROCTP Type: view_entity CONSUMPTION
57 Fields 1 Data Sources 2 Associations 1 OData Services

BP Relationship Tme Dpndcy Proc

C_BusPartRelshpTmeDpndcyProcTP is a Consumption CDS View that provides data about "BP Relationship Tme Dpndcy Proc" in SAP S/4HANA. It reads from 1 data source (I_BusPartRelshpTmeDpndcyProcTP) and exposes 57 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, ValidityEndDate. It has 2 associations to related views. It is exposed through 1 OData service (C_MDCHGPROCBPRELDETAILSTP_SRV).

Data Sources (1)

SourceAliasJoin Type
I_BusPartRelshpTmeDpndcyProcTP I_BusPartRelshpTmeDpndcyProcTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_BPRelshpTmeDpndcyProcChgs _Changes $projection.MasterDataChangeProcess = _Changes.MasterDataChangeProcess and $projection.MDChgProcessStep = _Changes.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject and _Changes.MDChgProcessSourceModified = 'X'
[0..1] I_MDChangeProcessRecordTarget _RecordTarget $projection.MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess and $projection.MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject and _RecordTarget.MDChgProcessSrceObjectTypeCode = '1405'

Annotations (7)

NameValueLevelField
EndUserText.label BP Relationship Tme Dpndcy Proc view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
C_MDCHGPROCBPRELDETAILSTP_SRV C_MDCHGPROCBPRELDETTP_SRV V2 C1 NOT_RELEASED

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY ValidityEndDate ValidityEndDate ValidTo
RelationshipCategory RelationshipCategory Relationsh.Cat.
IsStandardRelationship IsStandardRelationship Standard
ValidityStartDate ValidityStartDate Validity Start Date
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
MDChgProcessRecordObjectText _BPRelProcess MDChgProcessRecordObjectText
sstring260
sstring260
MDChgProcKPIRecordStatusText
MDChgProcessValidationStatus _BPRelProcess MDChgProcessValidationStatus
MDChgProcKPIUpdateStatusText _KPIUpdateStatusText MDChangeProcKPIValueKeyDesc
MDChgProcKPIUpdateStatus MDChgProcKPIUpdateStatus Row Type
virtualMDChangeProcessMessageTypesymsgty Message Type
virtualMDChangeProcessMessageIDmsgid Log Message Class
virtualMDChangeProcessMessageNumbermsgno Log Message Number
MDChgProcessActivationTarget _BPRelProcess MDChgProcessActivationTarget Activation Result
MDChgProcKPIRecordTypeText
MDChgProcKPIRecordType _RecordType MDChgProcKPIRecordType
MDChgProcKPIRecordTargetText
BP1AuthorizationGroup BP1AuthorizationGroup Authorization Group
BP2AuthorizationGroup BP2AuthorizationGroup Authorization Group
BP1DataControllerSet BP1DataControllerSet
BP1DataController1 BP1DataController1
BP1DataController2 BP1DataController2
BP1DataController3 BP1DataController3
BP1DataController4 BP1DataController4
BP1DataController5 BP1DataController5
BP1DataController6 BP1DataController6
BP1DataController7 BP1DataController7
BP1DataController8 BP1DataController8
BP1DataController9 BP1DataController9
BP1DataController10 BP1DataController10
BP2DataControllerSet BP2DataControllerSet
BP2DataController1 BP2DataController1
BP2DataController2 BP2DataController2
BP2DataController3 BP2DataController3
BP2DataController4 BP2DataController4
BP2DataController5 BP2DataController5
BP2DataController6 BP2DataController6
BP2DataController7 BP2DataController7
BP2DataController8 BP2DataController8
BP2DataController9 BP2DataController9
BP2DataController10 BP2DataController10
_Changes _Changes
_RecordTarget _RecordTarget
_RecordMessages _RecordMessages

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_BusPartRelshpTmeDpndcyProcTP.
-- 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_BusPartRelshpTmeDpndcyProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  ValidityEndDate,
  RelationshipCategory,
  IsStandardRelationship,
  ValidityStartDate,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  _BPRelProcess.MDChgProcessRecordObjectText AS MDChgProcessRecordObjectText,
  virtual SourceSystem : abap.sstring( 260 ) AS sstring260,
  _BPRelProcess._KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  _BPRelProcess.MDChgProcessValidationStatus AS MDChgProcessValidationStatus,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  MDChgProcKPIUpdateStatus,
  virtual MDChangeProcessMessageType : symsgty AS virtualMDChangeProcessMessageTypesymsgty,
  virtual MDChangeProcessMessageID : msgid AS virtualMDChangeProcessMessageIDmsgid,
  virtual MDChangeProcessMessageNumber : msgno AS virtualMDChangeProcessMessageNumbermsgno,
  _BPRelProcess.MDChgProcessActivationTarget AS MDChgProcessActivationTarget,
  _RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType,
  _BPRelProcess._RecordTargetText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTargetText,
  BP1AuthorizationGroup,
  BP2AuthorizationGroup,
  BP1DataControllerSet,
  BP1DataController1,
  BP1DataController2,
  BP1DataController3,
  BP1DataController4,
  BP1DataController5,
  BP1DataController6,
  BP1DataController7,
  BP1DataController8,
  BP1DataController9,
  BP1DataController10,
  BP2DataControllerSet,
  BP2DataController1,
  BP2DataController2,
  BP2DataController3,
  BP2DataController4,
  BP2DataController5,
  BP2DataController6,
  BP2DataController7,
  BP2DataController8,
  BP2DataController9,
  BP2DataController10
FROM I_BusPartRelshpTmeDpndcyProcTP
LEFT OUTER JOIN I_BPRelshpTmeDpndcyProcChgs AS _Changes ON MasterDataChangeProcess = _Changes.MasterDataChangeProcess AND MDChgProcessStep = _Changes.MDChgProcessStep AND MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject AND _Changes.MDChgProcessSourceModified = 'X'  -- association [0..*]
LEFT OUTER JOIN I_MDChangeProcessRecordTarget AS _RecordTarget ON MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess AND MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject AND _RecordTarget.MDChgProcessSrceObjectTypeCode = '1405'  -- association [0..1]
;

Learn More