R_BPUsrRoleCurrent

DDL: R_BPUSRROLECURRENT Type: view_entity COMPOSITE
8 Fields 1 Data Sources 1 Associations

Business User Role Current (valid today)

R_BPUsrRoleCurrent is a Composite CDS View that provides data about "Business User Role Current (valid today)" in SAP S/4HANA. It reads from 1 data source (R_BPUsrRole) and exposes 8 fields with key field BusinessPartnerUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_BPUsrRole R_BPUsrRole from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartnerRoleText _RoleText $projection.BusinessPartnerRole = _RoleText.BusinessPartnerRole and _RoleText.Language = $session.system_language

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business User Role Current (valid today) view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID R_BPUsrRole BusinessPartnerUUID UUID
BusinessPartner R_BPUsrRole BusinessPartner Issuing Authority
BusinessPartnerRole R_BPUsrRole BusinessPartnerRole BP Role
BPUsrRoleValidFromDate R_BPUsrRole BPUsrRoleValidFromDate
BPUsrRoleValidToDate R_BPUsrRole BPUsrRoleValidToDate
RoleCategory R_BPUsrRole RoleCategory BP Role Cat.
BPIdentificationCategory R_BPUsrRole BPIdentificationCategory ID Categ.
BPRoleCategoryUsageCode R_BPUsrRole BPRoleCategoryUsageCode Role Cat. Usage

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 R_BPUsrRoleCurrent.
-- 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 R_BPUsrRoleCurrent AS
SELECT
  R_BPUsrRole.BusinessPartnerUUID AS BusinessPartnerUUID,
  R_BPUsrRole.BusinessPartner AS BusinessPartner,
  R_BPUsrRole.BusinessPartnerRole AS BusinessPartnerRole,
  R_BPUsrRole.BPUsrRoleValidFromDate AS BPUsrRoleValidFromDate,
  R_BPUsrRole.BPUsrRoleValidToDate AS BPUsrRoleValidToDate,
  R_BPUsrRole.RoleCategory AS RoleCategory,
  R_BPUsrRole.BPIdentificationCategory AS BPIdentificationCategory,
  R_BPUsrRole.BPRoleCategoryUsageCode AS BPRoleCategoryUsageCode
FROM R_BPUsrRole
LEFT OUTER JOIN I_BusinessPartnerRoleText AS _RoleText ON BusinessPartnerRole = _RoleText.BusinessPartnerRole AND _RoleText.Language = $session.system_language  -- association [0..1]
;

Learn More