I_BPContactPersonAddressProcTP

DDL: I_BPCONTACTPERSONADDRESSPROCTP Type: view_entity TRANSACTIONAL Package: MDC_BP_REL_GOV_BO
34 Fields 1 Data Sources 9 Associations

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 34 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 9 associations to related views. Part of development package MDC_BP_REL_GOV_BO.

Data Sources (1)

SourceAliasJoin Type
I_BPContactPersonAddressProc I_BPContactPersonAddressProc from

Associations (9)

CardinalityTargetAliasCondition
[0..1] I_BusPartCommMdmTypeVH _CommType $projection.PrfrdCommMediumType = _CommType.CommunicationMediumType
[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 #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #TRANSACTIONAL view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY AddressNumber AddressNumber Src Address No
BusinessPartnerAddressUUID BusinessPartnerAddressUUID UUID
StandardUsage StandardUsage TRUE
ContactRelationshipFunction ContactRelationshipFunction Function
ContactRelationshipDepartment ContactRelationshipDepartment Department
Floor Floor Floor
WorkplaceBuilding WorkplaceBuilding Building code
RoomNumber RoomNumber Room Number
PrfrdCommMediumType PrfrdCommMediumType Comm. Method
BusinessPartner1 BusinessPartner1 Partner
StreetName StreetName Text
HouseNumber HouseNumber House Number
PostalCode PostalCode Postal Code
CityName CityName Name
Country Country Venue: Ctry/Reg
BusinessPartnerName BusinessPartnerName Extracted Customer Name
BusinessPartnerFullName BusinessPartnerFullName Broker Name
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary Modification
MDChgProcessSourceModif2Binary MDChgProcessSourceModif2Binary Modification
_BPRelProcess _BPRelProcess
_WorkplaceAddressMobileNumber _WorkplaceAddressMobileNumber
_WorkplaceAddressPhoneNumber _WorkplaceAddressPhoneNumber
_WorkplaceAddressFaxNumber _WorkplaceAddressFaxNumber
_WorkplaceAddressEmail _WorkplaceAddressEmail
_WorkplaceAddressWebsite _WorkplaceAddressWebsite
_CommType _CommType
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BPContactPersonAddressProcTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_BPContactPersonAddressProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  BusinessPartnerAddressUUID,
  StandardUsage,
  ContactRelationshipFunction,
  ContactRelationshipDepartment,
  Floor,
  WorkplaceBuilding,
  RoomNumber,
  PrfrdCommMediumType,
  BusinessPartner1,
  StreetName,
  HouseNumber,
  PostalCode,
  CityName,
  Country,
  BusinessPartnerName,
  BusinessPartnerFullName,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcessSourceModif2Binary
FROM I_BPContactPersonAddressProc
LEFT OUTER JOIN I_BusPartCommMdmTypeVH AS _CommType ON PrfrdCommMediumType = _CommType.CommunicationMediumType  -- association [0..1]
LEFT OUTER JOIN I_BPRelshpProcessKPIRecordType AS _RecordType ON MasterDataChangeProcess = _RecordType.MasterDataChangeProcess AND MDChgProcessStep = _RecordType.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessKPIRowVH AS _KPIUpdateStatusText ON MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcRecordMessages AS _RecordMessages ON MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess AND MDChgProcessStep = _RecordMessages.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject  -- association [0..*]
LEFT OUTER JOIN I_BPCntctPersnMblNumberProcTP AS _WorkplaceAddressMobileNumber ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCntctPersnTelNmbrProcTP AS _WorkplaceAddressPhoneNumber ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCntctPersnFaxNumberProcTP AS _WorkplaceAddressFaxNumber ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCntctPersnEmailAddrProcTP AS _WorkplaceAddressEmail ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCntctPersnWebsiteURLProcTP AS _WorkplaceAddressWebsite ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More