C_BusinessPartnerRole
Consumption view for Business Partner Role
C_BusinessPartnerRole is a Consumption CDS View that provides data about "Consumption view for Business Partner Role" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerRoleTP) and exposes 10 fields with key fields BusinessPartner, BusinessPartnerRole. It has 3 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_BusinessPartnerRoleTP | BusinessPartnerRole | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | C_BusinessPartner | _BusinessPartner | $projection.BusinessPartner = _BusinessPartner.BusinessPartner |
| [0..1] | I_BusinessPartnerRole | _BPRoleValueHelp | $projection.BusinessPartnerRoleForEdit = _BPRoleValueHelp.BusinessPartnerRole |
| [0..1] | I_BusinessPartnerRoleText | _BPRoleText | $projection.BusinessPartnerRoleForEdit = _BPRoleText.BusinessPartnerRole and _BPRoleText.Language = $session.system_language |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CBUPAROLE | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| EndUserText.label | Consumption view for Business Partner Role | view | |
| Metadata.allowExtensions | true | view | |
| ObjectModel.type | #CONSUMPTION | view | |
| ObjectModel.writeEnabled | true | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| Search.searchable | true | view | |
| UI.headerInfo.typeName | Role | view | |
| UI.headerInfo.typeNamePlural | Roles | view | |
| UI.headerInfo.title.label | Role Description | view | |
| UI.headerInfo.title.value | _BPRoleText.RoleText | view | |
| VDM.viewType | #CONSUMPTION | view |
Fields (10)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BusinessPartner | I_BusinessPartnerRoleTP | BusinessPartner | |
| KEY | BusinessPartnerRole | I_BusinessPartnerRoleTP | BusinessPartnerRole | |
| BusinessPartnerForEdit | I_BusinessPartnerRoleTP | BusinessPartnerForEdit | ||
| BusinessPartnerRoleForEdit | I_BusinessPartnerRoleTP | BusinessPartnerRoleForEdit | ||
| ValidityStartDate | I_BusinessPartnerRoleTP | ValidityStartDate | Role Validity Start Date | |
| ValidityEndDate | I_BusinessPartnerRoleTP | ValidityEndDate | Role Validity End Date | |
| RoleCategory | I_BusinessPartnerRoleTP | RoleCategory | ||
| _BusinessPartner | _BusinessPartner | |||
| _BPRoleValueHelp | _BPRoleValueHelp | |||
| _BPRoleText | _BPRoleText |
@AbapCatalog.sqlViewName: 'CBUPAROLE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Consumption view for Business Partner Role'
@Metadata.allowExtensions: true
@ObjectModel.type: #CONSUMPTION
@ObjectModel.writeEnabled: true
@ObjectModel: {
semanticKey: ['BusinessPartner', 'BusinessPartnerRoleForEdit'],
createEnabled,
updateEnabled,
deleteEnabled
}
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@UI.headerInfo:{
typeName: 'Role',
typeNamePlural: 'Roles',
title: { label:'Role Description', value: '_BPRoleText.RoleText' }
}
@VDM.viewType: #CONSUMPTION
define view C_BusinessPartnerRole
as select from I_BusinessPartnerRoleTP as BusinessPartnerRole
association [1..1] to C_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [0..1] to I_BusinessPartnerRole as _BPRoleValueHelp on $projection.BusinessPartnerRoleForEdit = _BPRoleValueHelp.BusinessPartnerRole
association [0..1] to I_BusinessPartnerRoleText as _BPRoleText on $projection.BusinessPartnerRoleForEdit = _BPRoleText.BusinessPartnerRole
and _BPRoleText.Language = $session.system_language
{
key BusinessPartnerRole.BusinessPartner,
key BusinessPartnerRole.BusinessPartnerRole,
BusinessPartnerRole.BusinessPartnerForEdit,
@ObjectModel: {
text.association: '_BPRoleText'
}
BusinessPartnerRole.BusinessPartnerRoleForEdit,
@EndUserText.label: 'Role Validity Start Date'
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
BusinessPartnerRole.ValidityStartDate,
@EndUserText.label: 'Role Validity End Date'
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
BusinessPartnerRole.ValidityEndDate,
BusinessPartnerRole.RoleCategory,
@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
_BusinessPartner,
_BPRoleValueHelp, // used for value help for multiple search on role selection field
_BPRoleText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERROLETP"
],
"ASSOCIATED":
[
"C_BUSINESSPARTNER",
"I_BUSINESSPARTNERROLE",
"I_BUSINESSPARTNERROLETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA