I_BUSPARTCONTACTPERSONPROCESS

CDS View

Business Partner Contact Person Process

I_BUSPARTCONTACTPERSONPROCESS is a CDS View in S/4HANA. Business Partner Contact Person Process. It contains 31 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_BusPartContactPersonGov view_entity from TRANSACTIONAL Base Contact Person General Data
I_BusPartContactPersonGov view_entity union_all TRANSACTIONAL Base Contact Person General Data
I_BusPartContactPersonProcChgs view_entity from TRANSACTIONAL BP Relationship Contact Person Process Changes
I_BusPartContactPersonProcChgs view_entity union_all TRANSACTIONAL BP Relationship Contact Person Process Changes
I_BusPartContactPersonProcTP view_entity from TRANSACTIONAL Business Partner Contact Person Proc - TP
P_BPGovContactPersonList view_entity from BASIC Base list for all Contact Persons of BP

Fields (31)

KeyField CDS FieldsUsed in Views
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
BP1DataController1 BP1DataController1 1
BP1DataController10 BP1DataController10 1
BP1DataController2 BP1DataController2 1
BP1DataController3 BP1DataController3 1
BP1DataController4 BP1DataController4 1
BP1DataController5 BP1DataController5 1
BP1DataController6 BP1DataController6 1
BP1DataController7 BP1DataController7 1
BP1DataController8 BP1DataController8 1
BP1DataController9 BP1DataController9 1
BP1DataControllerSet BP1DataControllerSet 1
BP2DataController1 BP2DataController1 1
BP2DataController10 BP2DataController10 1
BP2DataController2 BP2DataController2 1
BP2DataController3 BP2DataController3 1
BP2DataController4 BP2DataController4 1
BP2DataController5 BP2DataController5 1
BP2DataController6 BP2DataController6 1
BP2DataController7 BP2DataController7 1
BP2DataController8 BP2DataController8 1
BP2DataController9 BP2DataController9 1
BP2DataControllerSet BP2DataControllerSet 1
ContactPersonAuthorityType ContactPersonAuthorityType 1
ContactPersonDepartment ContactPersonDepartment 1
ContactPersonFunction ContactPersonFunction 1
ContactPersonVIPType ContactPersonVIPType 1
MDChgProcessSourceModified MDChgProcessSourceModified 1
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Partner Contact Person Process'
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #BASIC
define view entity I_BusPartContactPersonProcess
  as select from but051_prc
  association [0..1] to I_BusPartRelationshipProcess 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_ContactPersondepartment    as _CntctPersnDeptValueHelp     on  $projection.ContactPersonDepartment = _CntctPersnDeptValueHelp.ContactPersonDepartment
  association [1..*] to I_ContactPersonDepartmentT   as _ContactPersonDepartmentText on  $projection.ContactPersonDepartment = _ContactPersonDepartmentText.ContactPersonDepartment

{
  key but051_prc.process_id               as MasterDataChangeProcess,
  key but051_prc.process_step_no          as MDChgProcessStep,
  key but051_prc.source_id                as MDChgProcessSrceObject,
  key but051_prc.source_system            as MDChgProcessSrceSystem,
      but051_prc.pafkt                    as ContactPersonFunction,
      but051_prc.fnctn                    as ContactPersonFunctionName,
      but051_prc.abtnr                    as ContactPersonDepartment,
      but051_prc.dprtmnt                  as ContactPersonDepartmentName,
      but051_prc.paauth                   as ContactPersonAuthorityType,
      but051_prc.pavip                    as ContactPersonVIPType,
      but051_prc.parem                    as ContactPersonRemarkText,
      but051_prc.tel_number               as PhoneNumber,
      but051_prc.tel_extens               as PhoneNumberExtension,
      but051_prc.fax_number               as AddressFaxNumber,
      but051_prc.fax_extens               as FaxNumberExtension,
      but051_prc.smtp_address             as EmailAddress,
      but051_prc.source_modified          as MDChgProcessSourceModified,
      but051_prc.source_modification_blip as MDChgProcessSourceModifBinary,
      _BPRelProcess.RelationshipCategory,
      _BPRelProcess.BP1AuthorizationGroup,
      _BPRelProcess.BP2AuthorizationGroup,
      _BPRelProcess.BP1DataControllerSet,
      _BPRelProcess.BP1DataController1,
      _BPRelProcess.BP1DataController2,
      _BPRelProcess.BP1DataController3,
      _BPRelProcess.BP1DataController4,
      _BPRelProcess.BP1DataController5,
      _BPRelProcess.BP1DataController6,
      _BPRelProcess.BP1DataController7,
      _BPRelProcess.BP1DataController8,
      _BPRelProcess.BP1DataController9,
      _BPRelProcess.BP1DataController10,
      _BPRelProcess.BP2DataControllerSet,
      _BPRelProcess.BP2DataController1,
      _BPRelProcess.BP2DataController2,
      _BPRelProcess.BP2DataController3,
      _BPRelProcess.BP2DataController4,
      _BPRelProcess.BP2DataController5,
      _BPRelProcess.BP2DataController6,
      _BPRelProcess.BP2DataController7,
      _BPRelProcess.BP2DataController8,
      _BPRelProcess.BP2DataController9,
      _BPRelProcess.BP2DataController10,

      _BPRelProcess,
      _CntctPersnDeptValueHelp,
      _ContactPersonDepartmentText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSPARTRELATIONSHIPPROCESS",
"BUT051_PRC"
],
"ASSOCIATED":
[
"I_BUSPARTRELATIONSHIPPROCESS",
"I_CONTACTPERSONDEPARTMENT",
"I_CONTACTPERSONDEPARTMENTT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/