P_PPM_DomainValue

DDL: P_PPM_DOMAINVALUE SQL: PPPMDOMAINVALUE Type: view BASIC

P_PPM_DomainValue is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 7 fields with key fields domname, as4local, valpos, as4vers.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
dd07l value from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPPMDOMAINVALUE view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
Search.searchable true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY domname dd07l domname
KEY as4local dd07l as4local
KEY valpos dd07l valpos
KEY as4vers dd07l as4vers
domvalue_l dd07l domvalue_l
domvalue_h dd07l domvalue_h
appval dd07l appval 
@AbapCatalog.sqlViewName: 'PPPMDOMAINVALUE'
@AbapCatalog.compiler.compareFilter: true

@ClientHandling.algorithm: #SESSION_VARIABLE  

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED

@VDM.viewType: #BASIC
@VDM.private: true

@ObjectModel: {
   usageType: {
     serviceQuality:  #A,
     dataClass:       #MASTER,
     sizeCategory:    #S
    }
}

// Association on P_Level leads to ATC issues


@Search.searchable: true

// @EndUserText.label: 'Access to Domain Values for PPM'

define view P_PPM_DomainValue as select from dd07l as value
//  association [0..*] to P_PPM_DomainValueText as _Text on  $projection.domname  = _Text.domname

//                                                        and $projection.as4local = _Text.as4local

//                                                        and $projection.valpos   = _Text.valpos

//                                                        and $projection.as4vers  = _Text.as4vers

{
  key    value.domname,
  key    value.as4local,
  key    value.valpos,
  key    value.as4vers,
//         @ObjectModel.text.association: '_Text'

         @Search.defaultSearchElement: true
         value.domvalue_l,
         value.domvalue_h,
         value.appval

//         , _Text

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More