FUNKLAS_CDS

DDL: DDL_FUNKLAS SQL: H_FUNKLAS_CDS Type: view

FUNKLAS_CDS is a CDS View in SAP S/4HANA. It reads from 2 data sources (t002, te055t) and exposes 5 fields.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
t002 t002 inner
te055t te055t left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName H_FUNKLAS_CDS view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view

Fields (5)

KeyFieldSource TableSource FieldDescription
MANDT te055 mandt
SPARTYP te055 spartyp
FUNKLAS te055 funklas
spras t002 spras
FUNKTXT te055t funktxt 
@AbapCatalog.sqlViewName: 'H_FUNKLAS_CDS'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
  define view FUNKLAS_CDS as
  select from (te055 inner join t002  on ( te055.funklas <> '' or t002.spras <> '')) left outer join te055t
      on te055.mandt = te055t.mandt 
      and te055.funklas = te055t.funklas
      and t002.spras = te055t.spras
      {
        te055.mandt  as MANDT,
        te055.spartyp as SPARTYP,
        te055.funklas as FUNKLAS,
        t002.spras as spras,
        te055t.funktxt as FUNKTXT
      }      
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T002",
"TE055",
"TE055T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More