FAC_CDSPARAMETERSVH

DDL: FAC_CDSPARAMETERSVH SQL: FACCDSPARASVH Type: view

CDS view parameters value help

FAC_CDSPARAMETERSVH is a CDS View that provides data about "CDS view parameters value help" in SAP S/4HANA. It reads from 3 data sources (fac_ve_datasrc, dd04t, dd10b) and exposes 3 fields with key fields data_source, strucobjn.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
fac_ve_datasrc _VE_DATASRC inner
dd04t dd04t left_outer
dd10b dd10b from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FACCDSPARASVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
EndUserText.label CDS view parameters value help view
Search.searchable true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY data_source fac_ve_datasrc data_source
KEY strucobjn dd10b strucobjn
description dd04t ddtext 
@AbapCatalog.sqlViewName: 'FACCDSPARASVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality:  #P
@EndUserText.label: 'CDS view parameters value help'
@Search.searchable: true
define view FAC_CDSPARAMETERSVH as select from dd10b
   inner join fac_ve_datasrc as _VE_DATASRC on dd10b.strucobjn = _VE_DATASRC.cds_ddl_name
   left outer join dd04t on dd10b.rollname = dd04t.rollname and dd04t.ddlanguage = $session.system_language
   and dd04t.as4local = 'A'
{
    key _VE_DATASRC.data_source,
    key dd10b.strucobjn,
    @ObjectModel.text.element:  [ 'description' ]
    @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }
    key dd10b.parametername,
    @Semantics.text: true
    @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.7 }
    dd04t.ddtext as description
    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD04T",
"DD10B",
"FAC_VE_DATASRC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More