SRFAC_TEST_DDL_T100_DETAIL

DDL: SRFAC_TEST_DDL_T100_DETAIL SQL: SRFAC_T100_SUB Type: view

T100 Dummy Messages Sub CDS View

SRFAC_TEST_DDL_T100_DETAIL is a CDS View that provides data about "T100 Dummy Messages Sub CDS View" in SAP S/4HANA. It reads from 1 data source (t100) and exposes 4 fields with key fields arbgb, msgnr, sprsl.

Data Sources (1)

SourceAliasJoin Type
t100 t100 from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SRFAC_T100_SUB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label T100 Dummy Messages Sub CDS View view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY arbgb arbgb
KEY msgnr msgnr
KEY sprsl sprsl
_parent _parent
@AbapCatalog.sqlViewName: 'SRFAC_T100_SUB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'T100 Dummy Messages Sub CDS View'
define view SRFAC_TEST_DDL_T100_DETAIL as select from t100
association to parent SRFAC_TEST_DDL_T100 as _parent
    on $projection.arbgb = _parent.arbgb 
    and $projection.msgnr = _parent.msgnr
    and $projection.sprsl = _parent.sprsl {
    
    key arbgb,
    key msgnr,
    key sprsl,
    
    _parent // Make association public

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