I_ProjectObjectShortText

DDL: I_PROJECTOBJECTSHORTTEXT SQL: IPROJSHORTTEXT Type: view BASIC Package: VDM_PS_ST

Language Dependent Short - Text

I_ProjectObjectShortText is a Basic CDS View that provides data about "Language Dependent Short - Text" in SAP S/4HANA. It reads from 2 data sources (cnldst_objs, cnldst_shorttx) and exposes 5 fields with key fields ProjectApplicationIdentifier, ProjectObjectType, Language, ProjectObjectNode. Part of development package VDM_PS_ST.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
cnldst_objs cnldst_objs from
cnldst_shorttx cnldst_shorttx inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPROJSHORTTEXT view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #TEXT view
EndUserText.label Language Dependent Short - Text view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProjectApplicationIdentifier cnldst_objs application
KEY ProjectObjectType cnldst_objs object
KEY Language cnldst_shorttx language
KEY ProjectObjectNode cnldst_shorttx objnr
LanguageBasedShortText cnldst_shorttx shorttext 
@AbapCatalog.sqlViewName: 'IPROJSHORTTEXT'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.dataCategory: #TEXT
@EndUserText.label: 'Language Dependent Short - Text'
define view I_ProjectObjectShortText 
as select from  cnldst_objs 
inner join cnldst_shorttx  on cnldst_objs.application = cnldst_shorttx.application
                           and cnldst_objs.object     = cnldst_shorttx.object
 {
   key cnldst_objs.application as ProjectApplicationIdentifier,
   key cnldst_objs.object as ProjectObjectType,
   key cnldst_shorttx.language as Language,
   key cnldst_shorttx.objnr as ProjectObjectNode,
       cnldst_shorttx.shorttext as LanguageBasedShortText,
   
   case cnldst_objs.object
    when 'MW' then lpad(cast(substring(cnldst_shorttx.objnr , 12,5)as ps_s4_mlst_zaehl), 12, '0' )
    when 'ML' then lpad(cast(substring(cnldst_shorttx.objnr , 16,5) as ps_s4_mlst_zaehl), 12, '0' )
    when 'NP' then cast(substring(cnldst_shorttx.objnr , 3,12) as ps_s4_aufnr )
   end  as RelatedProjectObject

   }

Learn More