I_PPM_ProjectElementTypeText

DDL: I_PPM_PROJECTELEMENTTYPETEXT SQL: IPPMPROELETYPTXT Type: view BASIC

Project Element Type Text

I_PPM_ProjectElementTypeText is a Basic CDS View that provides data about "Project Element Type Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields Language, ProjectElementType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PPM_ProjectElementType _ProjectElementType $projection.ProjectElementType = _ProjectElementType.ProjectElementType
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (14)

NameValueLevelField
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IPPMPROELETYPTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Project Element Type Text 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
ObjectModel.representativeKey ProjectElementType view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language ddlanguage
KEY ProjectElementType
ProjectElementTypeText dd07t ddtext
_ProjectElementType _ProjectElementType
_Language _Language
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IPPMPROELETYPTXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Project Element Type Text'

@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

@ObjectModel.representativeKey: 'ProjectElementType'
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API 

define view I_PPM_ProjectElementTypeText as select from dd07t 
  association [0..1] to I_PPM_ProjectElementType as _ProjectElementType on  $projection.ProjectElementType = _ProjectElementType.ProjectElementType
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
    @Semantics.language: true
    @ObjectModel.foreignKey.association: '_Language'
    key ddlanguage as Language, 
    @ObjectModel.text.element:  [ 'ProjectElementTypeText' ] 
    key substring( domvalue_l, 1, 1 ) as  ProjectElementType,
    @Semantics.text: true
    dd07t.ddtext as  ProjectElementTypeText,
    _ProjectElementType,
    _Language
} where dd07t.domname = 'DPR_PROJECT_ELEMENT_TYPE' and dd07t.as4local = 'A'  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_PPM_PROJECTELEMENTTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/