I_BusinessPartnerRoleProcTP

DDL: I_BUSINESSPARTNERROLEPROCTP Type: view_entity TRANSACTIONAL

Business Partner Role (Process Data)

I_BusinessPartnerRoleProcTP is a Transactional CDS View that provides data about "Business Partner Role (Process Data)" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerRoleProc) and exposes 19 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, BusinessPartnerRole. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerRoleProc BusinessPartnerRole from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartnerRole _BusinessPartnerRoleVH $projection.BusinessPartnerRole = _BusinessPartnerRoleVH.BusinessPartnerRole
[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 (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Partner Role (Process Data) view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY BusinessPartnerRole BusinessPartnerRole
BusinessPartner BusinessPartner
ValidFrom ValidFrom
ValidTo ValidTo
datsendasValidityStartDate
datsendasValidityEndDate
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
AddressLine1Text
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
_BusinessPartner _BusinessPartner
_BusinessPartnerRoleVH _BusinessPartnerRoleVH
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Partner Role (Process Data)'

@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view entity I_BusinessPartnerRoleProcTP
  as select from I_BusinessPartnerRoleProc as BusinessPartnerRole
  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 [0..1] to I_BusinessPartnerRole             as _BusinessPartnerRoleVH on  $projection.BusinessPartnerRole = _BusinessPartnerRoleVH.BusinessPartnerRole
  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,
      @Search.defaultSearchElement: true
      @Consumption.valueHelp: '_BusinessPartnerRoleVH'
  key BusinessPartnerRole,
      BusinessPartner,
      ValidFrom,
      ValidTo,
      @Semantics.businessDate.from: true
      case when ValidFrom != 00010101000000
      then tstmp_to_dats(ValidFrom,'UTC',  $session.client, 'NULL')
      else cast ( '00010103' as abap.dats )
      end                                                            as ValidityStartDate,
      @Semantics.businessDate.to: true
      case when ValidTo != 00010101000000
      then tstmp_to_dats(ValidTo,'UTC',  $session.client, 'NULL')
      else cast ( '99991231' as abap.dats)
      end                                                            as ValidityEndDate,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      /* Record Identification */
      /* Has been moved to a virtual field in the projection layer, therefore the dummy entry */
      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,
      MDChgProcSrceLastChgdDateTime,
      
      /* Associations */
      _BusinessPartner,
      _BusinessPartnerRoleVH,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERROLEPROC"
],
"ASSOCIATED":
[
"I_BPPROCESSKPIRECORDTYPE",
"I_BUSINESSPARTNERPROCESSTP",
"I_BUSINESSPARTNERROLE",
"I_MDCHANGEPROCESSKPIROWVH",
"I_MDCHGPROCRECORDMESSAGES"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/