I_BPDataControllerProcessTP

DDL: I_BPDATACONTROLLERPROCESSTP Type: view_entity TRANSACTIONAL

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 20 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, DataController. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPDataControllerProcess I_BPDataControllerProcess from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_DC_DATA_CTRL _DataController $projection.DataController = _DataController.DataCtrlName
[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 (20)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY DataController DataController
KEY PurposeForPersonalData PurposeForPersonalData
IsDerivationSet IsDerivationSet
DataControlAssignmentStatus DataControlAssignmentStatus
PurposeDerived PurposeDerived
PurposeType PurposeType
IsBPBusinessPurposeCmpltd IsBPBusinessPurposeCmpltd
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
AddressLine1Text
_BusinessPartner _BusinessPartner
_DataController _DataController
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Data Controller - TP'
@VDM.viewType: #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #TRANSACTIONAL
}
define view entity I_BPDataControllerProcessTP
  as select from I_BPDataControllerProcess
  association        to parent I_BusinessPartnerProcessTP as _BusinessPartner     on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject
  association [1..1] to I_DC_DATA_CTRL                    as _DataController      on  $projection.DataController = _DataController.DataCtrlName
  association [0..1] to I_BPProcessKPIRecordType          as _RecordType          on  $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _RecordType.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _RecordType.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _RecordType.MDChgProcessSrceObject
  association [0..1] to I_MDChangeProcessKPIRowVH         as _KPIUpdateStatusText on  $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
  association [0..*] to I_MDChgProcRecordMessages         as _RecordMessages      on  $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _RecordMessages.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _RecordMessages.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _RecordMessages.MDChgProcessSrceObject
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key DataController,
  key PurposeForPersonalData,
      @Semantics.booleanIndicator: true
      IsDerivationSet,
      DataControlAssignmentStatus,
      PurposeDerived,
      PurposeType,
      @Semantics.booleanIndicator: true
      IsBPBusinessPurposeCmpltd,
      MDChgProcSrceLastChgdDateTime,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,

      cast( '' as abap.char(209) )                                   as AddressLine1Text,
      cast( case
        when MDChgProcessSourceModified = '' then 'N'
        when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified ) as MDChgProcKPIUpdateStatus,

      _BusinessPartner,
      _DataController,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPDATACONTROLLERPROCESS"
],
"ASSOCIATED":
[
"I_BPPROCESSKPIRECORDTYPE",
"I_BUSINESSPARTNERPROCESSTP",
"I_DC_DATA_CTRL",
"I_MDCHANGEPROCESSKPIROWVH",
"I_MDCHGPROCRECORDMESSAGES"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/