I_BusPartContactPersonGov

DDL: I_BUSPARTCONTACTPERSONGOV Type: view_entity TRANSACTIONAL Package: MDC_BP_REL_GOV_BO
68 Fields 2 Data Sources 2 Associations

Base Contact Person General Data

I_BusPartContactPersonGov is a Transactional CDS View that provides data about "Base Contact Person General Data" in SAP S/4HANA. It reads from 2 data sources (I_BusPartContactPersonProcess, I_BusPartContactPersonProcess) and exposes 68 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, BPRelshpCatIsInFwdDirection. It has 2 associations to related views. Part of development package MDC_BP_REL_GOV_BO.

Data Sources (2)

SourceAliasJoin Type
I_BusPartContactPersonProcess _Current from
I_BusPartContactPersonProcess _Current union_all

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusPartRelationshipGov _RelationshipGov $projection.MasterDataChangeProcess = _RelationshipGov.MasterDataChangeProcess and $projection.MDChgProcessStep = _RelationshipGov.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RelationshipGov.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RelationshipGov.MDChgProcessSrceObject and $projection.BPRelshpCatIsInFwdDirection = _RelationshipGov.BPRelshpCatIsInFwdDirection
[0..1] I_MasterDataChangeProcess _MasterDataChangeProcess $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Base Contact Person General Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #TRANSACTIONAL view

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY BPRelshpCatIsInFwdDirection
ContactPersonFunction ContactPersonFunction
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 Number
FaxNumberExtension FaxNumberExtension Extension
EmailAddress EmailAddress E-Mail Address
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY BPRelshpCatIsInFwdDirection
ContactPersonFunction ContactPersonFunction
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 Number
FaxNumberExtension FaxNumberExtension Extension
EmailAddress EmailAddress E-Mail Address
KEY MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject Source ID
KEY BPRelshpCatIsInFwdDirection
ContactPersonFunction BPContactPersonFunction
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 FaxNumber Fax Number
FaxNumberExtension FaxNumberExtension Extension
EmailAddress EmailAddress E-Mail Address
MasterDataIsCurrent
KEY MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject Source ID
KEY BPRelshpCatIsInFwdDirection
ContactPersonFunction BPContactPersonFunction
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 FaxNumber Fax Number
FaxNumberExtension FaxNumberExtension Extension
EmailAddress EmailAddress E-Mail Address
MasterDataIsCurrent
_RelationshipGov _RelationshipGov

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_BusPartContactPersonGov.
-- 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_BusPartContactPersonGov AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  cast( 'X' as abap.char(1) ) AS BPRelshpCatIsInFwdDirection,
  ContactPersonFunction,
  ContactPersonFunctionName,
  ContactPersonDepartment,
  ContactPersonDepartmentName,
  ContactPersonAuthorityType,
  ContactPersonVIPType,
  ContactPersonRemarkText,
  PhoneNumber,
  PhoneNumberExtension,
  AddressFaxNumber,
  FaxNumberExtension,
  EmailAddress,
  cast( 'X' as abap_boolean preserving type ) AS MasterDataIsCurrent
FROM I_BusPartContactPersonProcess AS _Current
LEFT OUTER JOIN I_BusPartRelationshipGov AS _RelationshipGov ON MasterDataChangeProcess = _RelationshipGov.MasterDataChangeProcess AND MDChgProcessStep = _RelationshipGov.MDChgProcessStep AND MDChgProcessSrceSystem = _RelationshipGov.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RelationshipGov.MDChgProcessSrceObject AND BPRelshpCatIsInFwdDirection = _RelationshipGov.BPRelshpCatIsInFwdDirection  -- association [0..1]
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess  -- association [0..1]
-- UNION ALL with additional select branch(es): I_BusPartContactPersonProcess
;

Learn More