P_EntProjElmntDlvTypeTextCode

DDL: P_ENTPROJELMNTDLVTYPETEXTCODE Type: view_entity BASIC Package: ODATA_PPM_COMMON_API

Description for Deliverable Type

P_EntProjElmntDlvTypeTextCode is a Basic CDS View that provides data about "Description for Deliverable Type" in SAP S/4HANA. It reads from 2 data sources (csla, cslt) and exposes 6 fields with key fields Lstar, Language. Part of development package ODATA_PPM_COMMON_API.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
csla _md inner
cslt cslt from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
VDM.private true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Lstar cslt lstar
KEY Language cslt spras
ValidityEndDate cslt datbi
Kokrs cslt kokrs
ValidityStartDate csla datab
Ktext cslt ktext 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory:   #S,
  dataClass:      #CUSTOMIZING
}
@VDM.viewType: #BASIC
@VDM.private:true
define view entity P_EntProjElmntDlvTypeTextCode 
  as select from cslt
   inner join csla as _md on cslt.lstar = _md.lstar and
                             cslt.kokrs = _md.kokrs and
                             cslt.datbi = _md.datbi
{     

  key cslt.lstar as Lstar,
      @Semantics.language: true
  key cslt.spras as Language,
      @Semantics.businessDate.to: true
      cslt.datbi as ValidityEndDate,
      cslt.kokrs as Kokrs,
      @Semantics.businessDate.from: true
      _md.datab  as ValidityStartDate,
      @Semantics.text: true
      cslt.ktext as Ktext
}
where _md.datab <= $session.system_date
  and _md.datbi >= $session.system_date
  and cslt.kokrs = 'A000'

Learn More