SETTLUNIT_CDS

DDL: DDL_EEDMSETTLUNIT SQL: V_SETTLUNIT_CDS Type: view

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

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
eedmsettlunitt eedmsettlunitt left_outer
t002 t002 inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName V_SETTLUNIT_CDS view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (11)

KeyFieldSource TableSource FieldDescription
SETTLUNIT eedmsettlunit settlunit
SETTLUNITTXT eedmsettlunitt settlunittxt
SPARTYP eedmsettlunit spartyp
SUNITCAT eedmsettlunit sunitcat
SETTLVIEW eedmsettlunit settlview
SETTLCOORD eedmsettlunit settlcoord
SETTLTRANSCO eedmsettlunit settltransco
SETTLSUPPLIER eedmsettlunit settlsupplier
SETTLVIEWADD eedmsettlunit settlviewadd
SETTLUNITEXT eedmsettlunit settlunitext
SPRAS t002 spras 
@AbapCatalog.sqlViewName: 'V_SETTLUNIT_CDS'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
   define view SETTLUNIT_CDS as
    select from (eedmsettlunit inner join t002 on (eedmsettlunit.settlunit <> '' or t002.spras <> '')) left outer join eedmsettlunitt
      on eedmsettlunitt.mandt = eedmsettlunit.mandt
      and eedmsettlunitt.settlunit = eedmsettlunit.settlunit
      and t002.spras =  eedmsettlunitt.spras
      {
        eedmsettlunit.settlunit  as SETTLUNIT,
        eedmsettlunitt.settlunittxt as SETTLUNITTXT,        
        eedmsettlunit.spartyp as SPARTYP,
        eedmsettlunit.sunitcat as SUNITCAT,
        eedmsettlunit.settlview as SETTLVIEW, 
        eedmsettlunit.settlcoord  as SETTLCOORD,     
        eedmsettlunit.settltransco as SETTLTRANSCO,
        eedmsettlunit.settlsupplier as SETTLSUPPLIER,
        eedmsettlunit.settlviewadd as SETTLVIEWADD,
        eedmsettlunit.settlunitext as SETTLUNITEXT,
        t002.spras as SPRAS
      }

Learn More