C_BusPartContactPersonProcTP

DDL: C_BUSPARTCONTACTPERSONPROCTP Type: view_entity CONSUMPTION Package: MDC_BP_REL_GOV_BO
64 Fields 1 Data Sources 2 Associations 2 OData Services

Contact Person

C_BusPartContactPersonProcTP is a Consumption CDS View that provides data about "Contact Person" in SAP S/4HANA. It reads from 1 data source (I_BusPartContactPersonProcTP) and exposes 64 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 2 associations to related views. It is exposed through 2 OData services (C_MDCHGPROCBPRELDETAILSTP_SRV, C_MDCHGPROCBPRELDETAILSTP_SRV). Part of development package MDC_BP_REL_GOV_BO.

Data Sources (1)

SourceAliasJoin Type
I_BusPartContactPersonProcTP I_BusPartContactPersonProcTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_BusPartContactPersonProcChgs _Changes $projection.MasterDataChangeProcess = _Changes.MasterDataChangeProcess and $projection.MDChgProcessStep = _Changes.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject and _Changes.MDChgProcessSourceModified = 'X'
[0..1] I_MDChangeProcessRecordTarget _RecordTarget $projection.MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess and $projection.MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject and _RecordTarget.MDChgProcessSrceObjectTypeCode = '1405'

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Contact Person view

OData Services (2)

ServiceBindingVersionContractRelease
C_MDCHGPROCBPRELDETAILSTP_SRV C_MDCHGPROCBPRELDETTP_SRV V2 C1 NOT_RELEASED
C_MDCHGPROCBPRELDETAILSTP_SRV C_MDCHGPROCBPRELDETTP_V2 V2 C1 NOT_RELEASED

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
ContactPersonFunction ContactPersonFunction Function
ContactPersonFunctionName ContactPersonFunctionName Function
ContactPersonDepartment ContactPersonDepartment Department
ContactPersonDepartmentName ContactPersonDepartmentName Company dept.
ContactPersonAuthorityType ContactPersonAuthorityType Authority
ContactPersonVIPType ContactPersonVIPType VIP
ContactPersonRemarkText ContactPersonRemarkText Note
PhoneNumber PhoneNumber Telephone no.
PhoneNumberExtension PhoneNumberExtension Extension
AddressFaxNumber AddressFaxNumber Fax
FaxNumberExtension FaxNumberExtension Extension
EmailAddress EmailAddress E-Mail Address
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcessRecordObjectText _BPRelProcess MDChgProcessRecordObjectText
sstring260
sstring260
MDChgProcKPIRecordStatusText
MDChgProcessValidationStatus _BPRelProcess MDChgProcessValidationStatus
MDChgProcKPIUpdateStatusText _KPIUpdateStatusText MDChangeProcKPIValueKeyDesc
MDChgProcKPIUpdateStatus MDChgProcKPIUpdateStatus Row Type
virtualMDChangeProcessMessageTypesymsgty Message Type
virtualMDChangeProcessMessageIDmsgid Log Message Class
virtualMDChangeProcessMessageNumbermsgno Log Message Number
MDChgProcessActivationTarget _BPRelProcess MDChgProcessActivationTarget Activation Result
MDChgProcKPIRecordTypeText
MDChgProcKPIRecordType _RecordType MDChgProcKPIRecordType
MDChgProcKPIRecordTargetText
RelationshipCategory RelationshipCategory Relationsh.Cat.
BP1AuthorizationGroup BP1AuthorizationGroup Authorization Group
BP2AuthorizationGroup BP2AuthorizationGroup Authorization Group
BusinessPartner1 BusinessPartner1 Partner
BusinessPartner2 BusinessPartner2 Partner
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
BPContactPersonAuthorityTextlocalized
BPContactPersonVIPTextlocalized
_Changes _Changes
_RecordTarget _RecordTarget
_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 C_BusPartContactPersonProcTP.
-- 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 C_BusPartContactPersonProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  ContactPersonFunction,
  ContactPersonFunctionName,
  ContactPersonDepartment,
  ContactPersonDepartmentName,
  ContactPersonAuthorityType,
  ContactPersonVIPType,
  ContactPersonRemarkText,
  PhoneNumber,
  PhoneNumberExtension,
  AddressFaxNumber,
  FaxNumberExtension,
  EmailAddress,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  _BPRelProcess.MDChgProcessRecordObjectText AS MDChgProcessRecordObjectText,
  virtual SourceSystem : abap.sstring( 260 ) AS sstring260,
  _BPRelProcess._KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  _BPRelProcess.MDChgProcessValidationStatus AS MDChgProcessValidationStatus,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  MDChgProcKPIUpdateStatus,
  virtual MDChangeProcessMessageType : symsgty AS virtualMDChangeProcessMessageTypesymsgty,
  virtual MDChangeProcessMessageID : msgid AS virtualMDChangeProcessMessageIDmsgid,
  virtual MDChangeProcessMessageNumber : msgno AS virtualMDChangeProcessMessageNumbermsgno,
  _BPRelProcess.MDChgProcessActivationTarget AS MDChgProcessActivationTarget,
  _RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType,
  _BPRelProcess._RecordTargetText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTargetText,
  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,
  _BPContactPersonAuthorityText.BPContactPersonAuthorityText : localized AS BPContactPersonAuthorityTextlocalized,
  _BPCntctPersnVIPIndicatorText.BPContactPersonVIPText : localized AS BPContactPersonVIPTextlocalized
FROM I_BusPartContactPersonProcTP
LEFT OUTER JOIN C_BusPartContactPersonProcChgs AS _Changes ON MasterDataChangeProcess = _Changes.MasterDataChangeProcess AND MDChgProcessStep = _Changes.MDChgProcessStep AND MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject AND _Changes.MDChgProcessSourceModified = 'X'  -- association [0..*]
LEFT OUTER JOIN I_MDChangeProcessRecordTarget AS _RecordTarget ON MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess AND MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject AND _RecordTarget.MDChgProcessSrceObjectTypeCode = '1405'  -- association [0..1]
;

Learn More