I_BusinessPartnerRoleGovTP

DDL: I_BUSINESSPARTNERROLEGOVTP Type: view_entity TRANSACTIONAL
15 Fields 1 Data Sources 1 Associations

TP for BP Roles with RAP (Governance)

I_BusinessPartnerRoleGovTP is a Transactional CDS View that provides data about "TP for BP Roles with RAP (Governance)" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerRoleGov) and exposes 15 fields with key fields BusinessPartnerUUID, BPRoleUUID, MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerRoleGov BusinessPartnerRole from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartnerRole _BusinessPartnerRoleVH $projection.BusinessPartnerRole = _BusinessPartnerRoleVH.BusinessPartnerRole

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label TP for BP Roles with RAP (Governance) view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID
KEY BPRoleUUID
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY BusinessPartnerRole BusinessPartnerRole BP Role
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerRoleForEdit BusinessPartnerRole BP Role
MDChgProcessStep MDChgProcessStep Step Number
ValidFrom I_BusinessPartnerRoleGov ValidFrom Vers.Valid From
ValidTo I_BusinessPartnerRoleGov ValidTo Vers.Valid To
datsendasValidityStartDate
datsendasValidityEndDate
_BusinessPartnerGov _BusinessPartnerGov
_BusinessPartnerRoleVH _BusinessPartnerRoleVH

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_BusinessPartnerRoleGovTP.
-- 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_BusinessPartnerRoleGovTP AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS BusinessPartnerUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS BPRoleUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  BusinessPartnerRole,
  BusinessPartner,
  BusinessPartnerRole AS BusinessPartnerRoleForEdit,
  MDChgProcessStep,
  BusinessPartnerRole.ValidFrom AS ValidFrom,
  BusinessPartnerRole.ValidTo AS ValidTo,
  case when BusinessPartnerRole.ValidFrom != 00010101000000 then tstmp_to_dats(BusinessPartnerRole.ValidFrom,'UTC', $session.client, 'NULL') else cast ( '00010103' as abap.dats ) end as ValidityStartDate AS datsendasValidityStartDate,
  case when BusinessPartnerRole.ValidTo != 00010101000000 then tstmp_to_dats(BusinessPartnerRole.ValidTo,'UTC', $session.client, 'NULL') else cast ( '99991231' as abap.dats) end as ValidityEndDate AS datsendasValidityEndDate
FROM I_BusinessPartnerRoleGov AS BusinessPartnerRole
LEFT OUTER JOIN I_BusinessPartnerRole AS _BusinessPartnerRoleVH ON BusinessPartnerRole = _BusinessPartnerRoleVH.BusinessPartnerRole  -- association [0..1]
;

Learn More