I_BPCONTACTPERSONADDRESSPROC
BP Contact Person Workplace Address
I_BPCONTACTPERSONADDRESSPROC is a CDS View in S/4HANA. BP Contact Person Workplace Address. It contains 16 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BPContactPersonAddressGov | view_entity | from | TRANSACTIONAL | Base Contact Person Workplace Address |
| I_BPContactPersonAddressGov | view_entity | union_all | TRANSACTIONAL | Base Contact Person Workplace Address |
| I_BPContactPersonAddressProcTP | view_entity | from | TRANSACTIONAL | Base Cntact Persn WplcAddr Proc - TP |
| I_BPContactPersonAddrProcChgs | view_entity | from | TRANSACTIONAL | BP Contact Person WplcAddr Process Chgs |
| I_BPContactPersonAddrProcChgs | view_entity | union_all | TRANSACTIONAL | BP Contact Person WplcAddr Process Chgs |
Fields (16)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AddressNumber | AddressNumber | 2 |
| KEY | MasterDataChangeProcess | MasterDataChangeProcess | 2 |
| KEY | MDChgProcessSrceObject | MDChgProcessSrceObject | 2 |
| KEY | MDChgProcessSrceSystem | MDChgProcessSrceSystem | 2 |
| KEY | MDChgProcessStep | MDChgProcessStep | 2 |
| BusinessPartner1 | BusinessPartner1,BusinessPartner2 | 1 | |
| BusinessPartner2 | BusinessPartner1,BusinessPartner2 | 1 | |
| BusinessPartnerAddressUUID | BusinessPartnerAddressUUID | 1 | |
| ContactRelationshipDepartment | ContactRelationshipDepartment | 1 | |
| ContactRelationshipFunction | ContactRelationshipFunction | 1 | |
| Floor | Floor | 1 | |
| MDChgProcessSourceModified | MDChgProcessSourceModified | 1 | |
| PrfrdCommMediumType | PrfrdCommMediumType | 1 | |
| RoomNumber | RoomNumber | 1 | |
| StandardUsage | StandardUsage | 1 | |
| WorkplaceBuilding | WorkplaceBuilding | 1 |
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'BP Contact Person Workplace Address'
@ObjectModel.usageType.serviceQuality: #X
@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_BPContactPersonAddressProc
as select from but052_prc as BPRelCntctPersnAddr
inner join bur_adcp_prc as BPRelWorkplaceData on BPRelCntctPersnAddr.process_id = BPRelWorkplaceData.process_id
and BPRelCntctPersnAddr.process_step_no = BPRelWorkplaceData.process_step_no
and BPRelCntctPersnAddr.source_system = BPRelWorkplaceData.source_system
and BPRelCntctPersnAddr.source_id = BPRelWorkplaceData.source_id
and BPRelCntctPersnAddr.source_addrnumber = BPRelWorkplaceData.source_addrnumber
and BPRelCntctPersnAddr.nation = BPRelWorkplaceData.nation
inner join but050_prc as BPRelationship on BPRelCntctPersnAddr.process_id = BPRelationship.process_id
and BPRelCntctPersnAddr.process_step_no = BPRelationship.process_step_no
and BPRelCntctPersnAddr.source_system = BPRelationship.source_system
and BPRelCntctPersnAddr.source_id = BPRelationship.source_id
left outer to one join but020 as BPAddressLinkActive on BPRelationship.source_partner1 = BPAddressLinkActive.partner
and BPRelCntctPersnAddr.source_addr_guid = BPAddressLinkActive.address_guid
left outer to one join I_Address as BPAddressActive on BPAddressLinkActive.addrnumber = BPAddressActive.AddressID
association [1..1] to I_BusPartRelationshipProcess as _BPRelProcess on BPRelCntctPersnAddr.process_id = _BPRelProcess.MasterDataChangeProcess
and BPRelCntctPersnAddr.process_step_no = _BPRelProcess.MDChgProcessStep
and BPRelCntctPersnAddr.source_system = _BPRelProcess.MDChgProcessSrceSystem
and BPRelCntctPersnAddr.source_id = _BPRelProcess.MDChgProcessSrceObject
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
association [0..1] to I_BusinessPartnerAddressProc as _BPAddressDetailsProc on $projection.MasterDataChangeProcess = _BPAddressDetailsProc.MasterDataChangeProcess
and $projection.MDChgProcessStep = _BPAddressDetailsProc.MDChgProcessStep
// and $projection.MDChgProcessSrceSystem = _BPAddressDetailsProc.MDChgProcessSrceSystem
and $projection.BusinessPartner1 = _BPAddressDetailsProc.MDChgProcessSrceObject
and $projection.AddressNumber = _BPAddressDetailsProc.AddressNumber
association [0..1] to I_BusinessPartner as _BusinessPartnerActive on $projection.BusinessPartner1 = _BusinessPartnerActive.BusinessPartner
{
key BPRelCntctPersnAddr.process_id as MasterDataChangeProcess,
key BPRelCntctPersnAddr.process_step_no as MDChgProcessStep,
key BPRelCntctPersnAddr.source_system as MDChgProcessSrceSystem,
key BPRelCntctPersnAddr.source_id as MDChgProcessSrceObject,
key BPRelCntctPersnAddr.source_addrnumber as AddressNumber,
BPRelCntctPersnAddr.source_addr_guid as BusinessPartnerAddressUUID,
BPRelCntctPersnAddr.xdfadr as StandardUsage,
BPRelWorkplaceData.function as ContactRelationshipFunction,
BPRelWorkplaceData.department as ContactRelationshipDepartment,
BPRelWorkplaceData.floor as Floor,
BPRelWorkplaceData.building as WorkplaceBuilding,
BPRelWorkplaceData.roomnumber as RoomNumber,
BPRelWorkplaceData.deflt_comm as PrfrdCommMediumType,
BPRelationship.source_partner1 as BusinessPartner1,
BPRelationship.source_partner2 as BusinessPartner2,
//needed for Record identification/description
case
when _BPAddressDetailsProc.AddressNumber is not null
then _BPAddressDetailsProc.StreetName
else BPAddressActive.StreetName
end as StreetName,
case
when _BPAddressDetailsProc.AddressNumber is not null
then _BPAddressDetailsProc.HouseNumber
else BPAddressActive.HouseNumber
end as HouseNumber,
case
when _BPAddressDetailsProc.AddressNumber is not null
then _BPAddressDetailsProc.PostalCode
else BPAddressActive.PostalCode
end as PostalCode,
case
when _BPAddressDetailsProc.AddressNumber is not null
then _BPAddressDetailsProc.CityName
else BPAddressActive.CityName
end as CityName,
case
when _BPAddressDetailsProc.AddressNumber is not null
then _BPAddressDetailsProc.Country
else BPAddressActive.Country
end as Country,
case
when _BPAddressDetailsProc.AddressNumber is not null
then _BPAddressDetailsProc._BusinessPartner.BusinessPartnerName
else _BusinessPartnerActive.BusinessPartnerName
end as BusinessPartnerName,
case
when _BPAddressDetailsProc.AddressNumber is not null
then _BPAddressDetailsProc._BusinessPartner.BusinessPartnerFullName
else _BusinessPartnerActive.BusinessPartnerFullName
end as BusinessPartnerFullName,
BPRelWorkplaceData.source_modified as MDChgProcessSourceModified,
BPRelCntctPersnAddr.source_modification_blip as MDChgProcessSourceModifBinary,
BPRelWorkplaceData.source_modification_blip as MDChgProcessSourceModif2Binary,
_BPRelProcess
}
where
BPRelCntctPersnAddr.nation = ' '