I_BPDataControllerProcessTP

DDL: I_BPDATACONTROLLERPROCESSTP Type: view_entity TRANSACTIONAL
21 Fields 1 Data Sources 5 Associations

BP Data Controller - TP

I_BPDataControllerProcessTP is a Transactional CDS View that provides data about "BP Data Controller - TP" in SAP S/4HANA. It reads from 1 data source (I_BPDataControllerProcess) and exposes 21 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, DataController. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPDataControllerProcess I_BPDataControllerProcess from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_DC_DATA_CTRL _DataController $projection.DataController = _DataController.DataCtrlName
[0..*] I_CentralPurposeText _CentralPurposeText $projection.PurposeForPersonalData = _CentralPurposeText.CentralPurposeName
[0..1] I_BPProcessKPIRecordType _RecordType $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordType.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject
[0..1] I_MDChangeProcessKPIRowVH _KPIUpdateStatusText $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
[0..*] I_MDChgProcRecordMessages _RecordMessages $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordMessages.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Data Controller - TP view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY DataController DataController Data Controller
KEY PurposeForPersonalData PurposeForPersonalData Purpose
IsDerivationSet IsDerivationSet DC Derv. Ind.
DataControlAssignmentStatus DataControlAssignmentStatus Asgmt. Status
PurposeDerived PurposeDerived Pur. Derv. Ind.
PurposeType PurposeType Purpose Type
IsBPBusinessPurposeCmpltd IsBPBusinessPurposeCmpltd Purpose Completed
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime Last Changed On
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary Modification
AddressLine1Text
_BusinessPartner _BusinessPartner
_DataController _DataController
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages
_CentralPurposeText _CentralPurposeText

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_BPDataControllerProcessTP.
-- 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_BPDataControllerProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  DataController,
  PurposeForPersonalData,
  IsDerivationSet,
  DataControlAssignmentStatus,
  PurposeDerived,
  PurposeType,
  IsBPBusinessPurposeCmpltd,
  MDChgProcSrceLastChgdDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  cast( '' as abap.char(209) ) AS AddressLine1Text
FROM I_BPDataControllerProcess
LEFT OUTER JOIN I_DC_DATA_CTRL AS _DataController ON DataController = _DataController.DataCtrlName  -- association [1..1]
LEFT OUTER JOIN I_CentralPurposeText AS _CentralPurposeText ON PurposeForPersonalData = _CentralPurposeText.CentralPurposeName  -- association [0..*]
LEFT OUTER JOIN I_BPProcessKPIRecordType AS _RecordType ON MasterDataChangeProcess = _RecordType.MasterDataChangeProcess AND MDChgProcessStep = _RecordType.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessKPIRowVH AS _KPIUpdateStatusText ON MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcRecordMessages AS _RecordMessages ON MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess AND MDChgProcessStep = _RecordMessages.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject  -- association [0..*]
;

Learn More