I_BPUsrExternalID

DDL: I_BPUSREXTERNALID Type: view_entity BASIC
6 Fields 1 Data Sources 1 Associations

Business Partner External ID (BUM)

I_BPUsrExternalID (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_BPUsrExternalID is a Basic CDS View that provides data about "Business Partner External ID (BUM)" in SAP S/4HANA. It reads from 1 data source (but0id) and exposes 6 fields with key fields BusinessPartner, BPIdentificationType, BPIdentificationNumber. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Business User Management
Purpose
This CDS view retrieves the (person) external ID of a business user. The (person) external ID is the unique identifier of the business user which can be used across different systems. The (person) external ID has different types, in case of Employee (BUP003) it is HCM001. This CDS view provides the data to answer the following business questions: What is the (person) external ID of a business user? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: B_BUPA_GRP (Business Partner: Authorization Groups) B_BUPA_RLT (Business Partner: BP Roles)

Structure
Fields used for filtering The main optional filter is as follows: BPIdentificationNumber used to filter for the (person) external ID. Further important fields Important fields in this view include the following: Field Name Description BusinessPartner Business partner ID (unique in one system). BPIdentificationType The (person) external ID has different types: in case of Employee (BUP003) it is HCM001. BPIdentificationNumber Caution This is the (person) external ID. ValidityStartDate Start date of the (person) external ID. ValidityEndDate End date of the (person) external ID.

Related Information
Simplification Item - Business User Management

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentBC-SRV-BUM
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view retrieves the (person) external ID of a business user. The (person) external ID is the unique identifier of the business user which can be used across different systems. The (person) external ID has different types, in case of Employee (BUP003) it is HCM001.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>What is the (person) external ID of a business user?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
but0id but0id from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusinessUserBasic _BusinessUserBasic $projection.BusinessPartner = _BusinessUserBasic.BusinessPartner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Partner External ID (BUM) view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner partner Business Partner Number
KEY BPIdentificationType type Identification Type
KEY BPIdentificationNumber idnumber Identification Number
ValidityStartDate valid_date_from Validity Start for ID Number
ValidityEndDate valid_date_to Validity End for ID Number
_BusinessUserBasic _BusinessUserBasic

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_BPUsrExternalID.
-- 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_BPUsrExternalID AS
SELECT
  partner AS BusinessPartner,
  type AS BPIdentificationType,
  idnumber AS BPIdentificationNumber,
  valid_date_from AS ValidityStartDate,
  valid_date_to AS ValidityEndDate
FROM but0id
LEFT OUTER JOIN I_BusinessUserBasic AS _BusinessUserBasic ON BusinessPartner = _BusinessUserBasic.BusinessPartner  -- association [0..1]
;

Learn More