I_BPContactPersonAddressProcTP

DDL: I_BPCONTACTPERSONADDRESSPROCTP Type: view_entity TRANSACTIONAL

Base Cntact Persn WplcAddr Proc - TP

I_BPContactPersonAddressProcTP is a Transactional CDS View that provides data about "Base Cntact Persn WplcAddr Proc - TP" in SAP S/4HANA. It reads from 1 data source (I_BPContactPersonAddressProc) and exposes 33 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 8 associations to related views.

1 data source(s) 33 fields

Data Sources (1)

SourceAliasJoin Type
I_BPContactPersonAddressProc I_BPContactPersonAddressProc from

Associations (8)

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
[0..*] I_BPCntctPersnMblNumberProcTP _WorkplaceAddressMobileNumber
[0..*] I_BPCntctPersnTelNmbrProcTP _WorkplaceAddressPhoneNumber
[0..*] I_BPCntctPersnFaxNumberProcTP _WorkplaceAddressFaxNumber
[0..*] I_BPCntctPersnEmailAddrProcTP _WorkplaceAddressEmail
[0..*] I_BPCntctPersnWebsiteURLProcTP _WorkplaceAddressWebsite

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Base Cntact Persn WplcAddr Proc - TP view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #TRANSACTIONAL view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY AddressNumber AddressNumber
BusinessPartnerAddressUUID BusinessPartnerAddressUUID
StandardUsage StandardUsage
ContactRelationshipFunction ContactRelationshipFunction
ContactRelationshipDepartment ContactRelationshipDepartment
Floor Floor
WorkplaceBuilding WorkplaceBuilding
RoomNumber RoomNumber
PrfrdCommMediumType PrfrdCommMediumType
BusinessPartner1 BusinessPartner1
StreetName StreetName
HouseNumber HouseNumber
PostalCode PostalCode
CityName CityName
Country Country
BusinessPartnerName BusinessPartnerName
BusinessPartnerFullName BusinessPartnerFullName
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcessSourceModif2Binary MDChgProcessSourceModif2Binary
_BPRelProcess _BPRelProcess
_WorkplaceAddressMobileNumber _WorkplaceAddressMobileNumber
_WorkplaceAddressPhoneNumber _WorkplaceAddressPhoneNumber
_WorkplaceAddressFaxNumber _WorkplaceAddressFaxNumber
_WorkplaceAddressEmail _WorkplaceAddressEmail
_WorkplaceAddressWebsite _WorkplaceAddressWebsite
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Base Cntact Persn WplcAddr Proc - TP'
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
define view entity I_BPContactPersonAddressProcTP
  as select from I_BPContactPersonAddressProc
  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
  composition [0..*] of I_BPCntctPersnMblNumberProcTP         as _WorkplaceAddressMobileNumber
  composition [0..*] of I_BPCntctPersnTelNmbrProcTP           as _WorkplaceAddressPhoneNumber
  composition [0..*] of I_BPCntctPersnFaxNumberProcTP         as _WorkplaceAddressFaxNumber
  composition [0..*] of I_BPCntctPersnEmailAddrProcTP         as _WorkplaceAddressEmail
  composition [0..*] of I_BPCntctPersnWebsiteURLProcTP        as _WorkplaceAddressWebsite
  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

{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key AddressNumber,
      BusinessPartnerAddressUUID,
      StandardUsage,
      ContactRelationshipFunction,
      ContactRelationshipDepartment,
      Floor,
      WorkplaceBuilding,
      RoomNumber,
      PrfrdCommMediumType,
      BusinessPartner1,
      StreetName,
      HouseNumber,
      PostalCode,
      CityName,
      Country,
      BusinessPartnerName,
      BusinessPartnerFullName,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      MDChgProcessSourceModif2Binary,
      cast( case
        when MDChgProcessSourceModified = '' then 'N'
        when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified ) as MDChgProcKPIUpdateStatus,
      /* Associations */
      _BPRelProcess,
      _WorkplaceAddressMobileNumber,
      _WorkplaceAddressPhoneNumber,
      _WorkplaceAddressFaxNumber,
      _WorkplaceAddressEmail,
      _WorkplaceAddressWebsite,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCONTACTPERSONADDRESSPROC"
],
"ASSOCIATED":
[
"I_BPCNTCTPERSNEMAILADDRPROCTP",
"I_BPCNTCTPERSNFAXNUMBERPROCTP",
"I_BPCNTCTPERSNMBLNUMBERPROCTP",
"I_BPCNTCTPERSNTELNMBRPROCTP",
"I_BPCNTCTPERSNWEBSITEURLPROCTP",
"I_BPRELSHPPROCESSKPIRECORDTYPE",
"I_BUSPARTRELATIONSHIPPROCESSTP",
"I_MDCHANGEPROCESSKPIROWVH",
"I_MDCHGPROCRECORDMESSAGES"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More