SEPM_I_AddressType

-- This view is an example of an entity view for the fix values of a DDIC domain 
@EndUserText.label: 'EPM Demo: Address Type'            -- label of the view, can be translated 
@Analytics.dataCategory:#DIMENSION                      -- view is available for analytics with analytics engine as dimension view
@AccessControl.authorizationCheck: #NOT_REQUIRED        -- instance-based access control not needed
@Analytics.dataExtraction.enabled:true                  -- this view is a good candidate for extraction of data to a data warehouse
//@VDM.viewType: #BASIC                                 -- this would mark the view as BASIC view in the Virtual Data Model (VDM)

@ObjectModel.representativeKey: 'AddressType'           -- the most significant key field, anchor of foreign key associations pointing here
@AbapCatalog.sqlViewName: 'SEPM_IADDRESSTP'             -- for technical reasons, a name for the generated SQL view is needed

@ObjectModel.usageType.serviceQuality:#C
@ObjectModel.usageType.sizeCategory:#L
@ObjectModel.usageType.dataClass: #MASTER










define view SEPM_I_AddressType                          -- CDS view name; prefix "I_" indicates that it is a VDM interface view (released for reuse)
  as select from dd07l                                  -- selected from the table of all domain fix values, filter is given below
  
association [0..*] to SEPM_I_AddressTypeText as _Text   -- association to the text view of the entity; naming convention _Text
  on  $projection.AddressType = _Text.AddressType       -- join condition for the association, defined on the projection list ($projection) of
                                                        -- this entity view and the associated text view (via _Text)

{
  @ObjectModel.text.association: '_Text'                -- association to the text view for this field
  key cast ( substring( domvalue_l, 1, 2 ) as snwd_address_type preserving type ) as AddressType,
              -- shorten the generic char(10) format of domain fix values to the correct char(2) format of this domain
              -- cast the data type to data element SNWD_ADDRESS_TYPE as proper semantic type incl. field labels 
  _Text       -- expose the association to the text view for consumers
} 
where
      domname  = 'D_AD_TYPE'                            -- filter on the requested DDIC domain
  and as4local = 'A'                                    -- filter on the active version in DDIC
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"SEPM_I_ADDRESSTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/