I_MstrProjBusPartRoleCodeTxt

DDL: I_MSTRPROJBUSPARTROLECODETXT SQL: IMPBPROLECODETXT Type: view BASIC Package: VDM_CPM_WS

Master Project Business Partner Role Code Text

I_MstrProjBusPartRoleCodeTxt is a Basic CDS View that provides data about "Master Project Business Partner Role Code Text" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerRoleText) and exposes 6 fields with key fields client, BusinessPartnerRole, Language. It has 2 associations to related views. Part of development package VDM_CPM_WS.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerRoleText I_BusinessPartnerRoleText from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MstrProjBusPartRoleCode _MstrProjBusPartRoleCode $projection.BusinessPartnerRole = _MstrProjBusPartRoleCode.BusinessPartnerRole
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMPBPROLECODETXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.buffering.status #SWITCHED_OFF view
AbapCatalog.buffering.type #NONE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
ObjectModel.representativeKey BusinessPartnerRole view
EndUserText.label Master Project Business Partner Role Code Text view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY client client
KEY BusinessPartnerRole BusinessPartnerRole
KEY Language Language
BusinessPartnerRoleShortName BusinessPartnerRoleShortName
_MstrProjBusPartRoleCode _MstrProjBusPartRoleCode
_Language _Language 
@AbapCatalog.sqlViewName: 'IMPBPROLECODETXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.buffering.status: #SWITCHED_OFF
@AbapCatalog.buffering.type: #NONE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'BusinessPartnerRole'
@EndUserText.label: 'Master Project Business Partner Role Code Text'
define view I_MstrProjBusPartRoleCodeTxt
  as select from I_BusinessPartnerRoleText
  association [0..1] to I_MstrProjBusPartRoleCode as _MstrProjBusPartRoleCode on $projection.BusinessPartnerRole = _MstrProjBusPartRoleCode.BusinessPartnerRole
  association [0..1] to I_Language                as _Language                on $projection.Language = _Language.Language
{


  key client,
  key BusinessPartnerRole,
      @Semantics.language: true
  key Language,
      @Semantics.text: true
      BusinessPartnerRoleShortName,
      _MstrProjBusPartRoleCode,
      _Language

}
where
     BusinessPartnerRole = 'BUP003'
  or BusinessPartnerRole = 'FLCU01'
  or BusinessPartnerRole = 'FLVN01'

Learn More