I_BusPartContactPersonProcTP

DDL: I_BUSPARTCONTACTPERSONPROCTP Type: view_entity TRANSACTIONAL Package: MDC_BP_REL_GOV_BO

Business Partner Contact Person Proc - TP

I_BusPartContactPersonProcTP is a Transactional CDS View that provides data about "Business Partner Contact Person Proc - TP" in SAP S/4HANA. It reads from 1 data source (I_BusPartContactPersonProcess) and exposes 53 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 7 associations to related views. Part of development package MDC_BP_REL_GOV_BO.

1 data source(s) 53 fields

Data Sources (1)

SourceAliasJoin Type
I_BusPartContactPersonProcess I_BusPartContactPersonProcess from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_BPRelshpProcessKPIRecordType _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
[1..*] I_ContactPersonDepartmentT _ContactPersonDepartmentText $projection.ContactPersonDepartment = _ContactPersonDepartmentText.ContactPersonDepartment
[0..*] I_ContactPersonFunctionT _ContactPersonFunctionText $projection.ContactPersonFunction = _ContactPersonFunctionText.ContactPersonFunction
[1..*] I_BPContactPersonAuthorityText _BPContactPersonAuthorityText $projection.ContactPersonAuthorityType = _BPContactPersonAuthorityText.ContactPersonAuthorityType
[1..*] I_BPCntctPersnVIPIndicatorText _BPCntctPersnVIPIndicatorText $projection.ContactPersonVIPType = _BPCntctPersnVIPIndicatorText.ContactPersonVIPType

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Partner Contact Person Proc - TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #TRANSACTIONAL view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
ContactPersonFunction ContactPersonFunction
ContactPersonFunctionName ContactPersonFunctionName
ContactPersonDepartment ContactPersonDepartment
ContactPersonDepartmentName ContactPersonDepartmentName
ContactPersonAuthorityType ContactPersonAuthorityType
ContactPersonVIPType ContactPersonVIPType
ContactPersonRemarkText ContactPersonRemarkText
PhoneNumber PhoneNumber
PhoneNumberExtension PhoneNumberExtension
AddressFaxNumber AddressFaxNumber
FaxNumberExtension FaxNumberExtension
EmailAddress EmailAddress
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
RelationshipCategory RelationshipCategory
BP1AuthorizationGroup BP1AuthorizationGroup
BP2AuthorizationGroup BP2AuthorizationGroup
BusinessPartner1 BusinessPartner1
BusinessPartner2 BusinessPartner2
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
_BPRelProcess _BPRelProcess
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages
_ContactPersonDepartmentText _ContactPersonDepartmentText
_ContactPersonFunctionText _ContactPersonFunctionText
_BPContactPersonAuthorityText _BPContactPersonAuthorityText
_BPCntctPersnVIPIndicatorText _BPCntctPersnVIPIndicatorText 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Partner Contact Person Proc - TP'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BusPartContactPersonProcTP
  as select from I_BusPartContactPersonProcess
  association        to parent I_BusPartRelationshipProcessTP as _BPRelProcess                 on  $projection.MasterDataChangeProcess = _BPRelProcess.MasterDataChangeProcess
                                                                                               and $projection.MDChgProcessStep        = _BPRelProcess.MDChgProcessStep
                                                                                               and $projection.MDChgProcessSrceSystem  = _BPRelProcess.MDChgProcessSrceSystem
                                                                                               and $projection.MDChgProcessSrceObject  = _BPRelProcess.MDChgProcessSrceObject
  association [0..1] to I_BPRelshpProcessKPIRecordType        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
  association [1..*] to I_ContactPersonDepartmentT            as _ContactPersonDepartmentText  on  $projection.ContactPersonDepartment = _ContactPersonDepartmentText.ContactPersonDepartment
  association [0..*] to I_ContactPersonFunctionT              as _ContactPersonFunctionText    on  $projection.ContactPersonFunction = _ContactPersonFunctionText.ContactPersonFunction
  association [1..*] to I_BPContactPersonAuthorityText        as _BPContactPersonAuthorityText on  $projection.ContactPersonAuthorityType = _BPContactPersonAuthorityText.ContactPersonAuthorityType
  association [1..*] to I_BPCntctPersnVIPIndicatorText        as _BPCntctPersnVIPIndicatorText on  $projection.ContactPersonVIPType = _BPCntctPersnVIPIndicatorText.ContactPersonVIPType


{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
      ContactPersonFunction,
      ContactPersonFunctionName,
      ContactPersonDepartment,
      ContactPersonDepartmentName,
      ContactPersonAuthorityType,
      ContactPersonVIPType,
      ContactPersonRemarkText,
      PhoneNumber,
      PhoneNumberExtension,
      AddressFaxNumber,
      FaxNumberExtension,
      EmailAddress,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      cast( case
        when MDChgProcessSourceModified = '' then 'N'
        when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified ) as MDChgProcKPIUpdateStatus,

      RelationshipCategory,
      BP1AuthorizationGroup,
      BP2AuthorizationGroup,
      BusinessPartner1,
      BusinessPartner2,
      BP1DataControllerSet,
      BP1DataController1,
      BP1DataController2,
      BP1DataController3,
      BP1DataController4,
      BP1DataController5,
      BP1DataController6,
      BP1DataController7,
      BP1DataController8,
      BP1DataController9,
      BP1DataController10,
      BP2DataControllerSet,
      BP2DataController1,
      BP2DataController2,
      BP2DataController3,
      BP2DataController4,
      BP2DataController5,
      BP2DataController6,
      BP2DataController7,
      BP2DataController8,
      BP2DataController9,
      BP2DataController10,

      /* Associations */
      _BPRelProcess,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages,
      _ContactPersonDepartmentText,
      _ContactPersonFunctionText,
      _BPContactPersonAuthorityText,
      _BPCntctPersnVIPIndicatorText
}

Learn More