C_BPGovObjPgIdnReferenceRecord

DDL: C_BPGOVOBJPGIDNREFERENCERECORD Type: view_entity CONSUMPTION
18 Fields 2 Data Sources 4 Associations

BP Identification References

C_BPGovObjPgIdnReferenceRecord is a Consumption CDS View that provides data about "BP Identification References" in SAP S/4HANA. It reads from 2 data sources (R_BPIdentificationGovDraft, I_BusPartIdentificationGovTP) and exposes 18 fields with key fields BusinessPartnerUUID, BusinessPartnerIdnUUID, MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 4 associations to related views.

Data Sources (2)

SourceAliasJoin Type
R_BPIdentificationGovDraft _BusinessPartnerIdentification union
I_BusPartIdentificationGovTP I_BusPartIdentificationGovTP from

Associations (4)

CardinalityTargetAliasCondition
[0..1] R_BPIdentificationGovDraft _BusinessPartnerDraftId $projection.MasterDataChangeProcess = _BusinessPartnerDraftId.MasterDataChangeProcess and $projection.MDChgProcessSrceSystem = _BusinessPartnerDraftId.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartnerDraftId.MDChgProcessSrceObject and $projection.MasterDataChangeProcess = _BusinessPartnerDraftId.MasterDataChangeProcess and $projection.BusinessPartnerUUID = _BusinessPartnerDraftId.BusinessPartnerUUID and $projection.BusinessPartnerIdnUUID = _BusinessPartnerDraftId.BusinessPartnerIdnUUID and $projection.BPIdentificationType = _BusinessPartnerDraftId.BPIdentificationType and $projection.BPIdentificationNumber = _BusinessPartnerDraftId.BPIdentificationNumber
[0..*] C_ExtlyPrvddBPInfoSegment _Segment $projection.MasterDataChangeProcess = _Segment.MasterDataChangeProcess and $projection.MDChgProcessSrceSystem = _Segment.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Segment.MDChgProcessSrceObject and $projection.BusinessPartnerUUID = _Segment.BusinessPartnerUUID and $projection.BPIdentificationNumber = _Segment.ExtlyPrvddBusinessPartnerInfo and $projection.BPIdentificationType = _Segment.ExtlyPrvddBPInfoDataProvider
[0..1] I_BusPartIdentificationTypeT_2 _BusPartIdentificationTypeText $projection.BPIdentificationType = _BusPartIdentificationTypeText.BPIdentificationType and _BusPartIdentificationTypeText.Language = $session.system_language
[1..1] I_BusinessPartnerGovTP _BusinessPartnerGov $projection.MasterDataChangeProcess = _BusinessPartnerGov.MasterDataChangeProcess and $projection.MDChgProcessSrceSystem = _BusinessPartnerGov.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartnerGov.MDChgProcessSrceObject and $projection.BusinessPartnerUUID = _BusinessPartnerGov.BusinessPartnerUUID

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label BP Identification References view
UI.headerInfo.typeName Reference Record ID view
UI.headerInfo.typeNamePlural Items view
UI.headerInfo.title.value BPIdentificationType view
UI.headerInfo.description.value BPIdentificationNumber view
UI.headerInfo.description.label Business Partner Reference Record ID view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID BusinessPartnerUUID UUID
KEY BusinessPartnerIdnUUID BusinessPartnerIdnUUID UUID
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY BPIdentificationType BPIdentificationType ID Type
KEY BPIdentificationNumber BPIdentificationNumber ID Number
BPIdentificationTypeName _BusPartIdentificationTypeText BPIdentificationTypeName
_Segment _Segment
KEY BusinessPartnerIdnUUID BusinessPartnerIdnUUID UUID
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY BPIdentificationType BPIdnTypeForEdit ID Type
KEY BPIdentificationNumber BPIdentificationNumberForEdit ID Number
BPIdentificationTypeName _BusPartIdentificationTypeText BPIdentificationTypeName
_Segment _Segment
_BusinessPartnerGov _BusinessPartnerGov

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_BPGovObjPgIdnReferenceRecord.
-- 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_BPGovObjPgIdnReferenceRecord AS
SELECT
  BusinessPartnerUUID,
  BusinessPartnerIdnUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  BPIdentificationType,
  BPIdentificationNumber,
  _BusPartIdentificationTypeText.BPIdentificationTypeName AS BPIdentificationTypeName
FROM I_BusPartIdentificationGovTP
LEFT OUTER JOIN R_BPIdentificationGovDraft AS _BusinessPartnerDraftId ON MasterDataChangeProcess = _BusinessPartnerDraftId.MasterDataChangeProcess AND MDChgProcessSrceSystem = _BusinessPartnerDraftId.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartnerDraftId.MDChgProcessSrceObject AND MasterDataChangeProcess = _BusinessPartnerDraftId.MasterDataChangeProcess AND BusinessPartnerUUID = _BusinessPartnerDraftId.BusinessPartnerUUID AND BusinessPartnerIdnUUID = _BusinessPartnerDraftId.BusinessPartnerIdnUUID AND BPIdentificationType = _BusinessPartnerDraftId.BPIdentificationType AND BPIdentificationNumber = _BusinessPartnerDraftId.BPIdentificationNumber  -- association [0..1]
LEFT OUTER JOIN C_ExtlyPrvddBPInfoSegment AS _Segment ON MasterDataChangeProcess = _Segment.MasterDataChangeProcess AND MDChgProcessSrceSystem = _Segment.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Segment.MDChgProcessSrceObject AND BusinessPartnerUUID = _Segment.BusinessPartnerUUID AND BPIdentificationNumber = _Segment.ExtlyPrvddBusinessPartnerInfo AND BPIdentificationType = _Segment.ExtlyPrvddBPInfoDataProvider  -- association [0..*]
LEFT OUTER JOIN I_BusPartIdentificationTypeT_2 AS _BusPartIdentificationTypeText ON BPIdentificationType = _BusPartIdentificationTypeText.BPIdentificationType AND _BusPartIdentificationTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerGovTP AS _BusinessPartnerGov ON MasterDataChangeProcess = _BusinessPartnerGov.MasterDataChangeProcess AND MDChgProcessSrceSystem = _BusinessPartnerGov.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartnerGov.MDChgProcessSrceObject AND BusinessPartnerUUID = _BusinessPartnerGov.BusinessPartnerUUID  -- association [1..1]
-- UNION with additional select branch(es): R_BPIdentificationGovDraft
;

Learn More