I_CountyCodeText

DDL: I_COUNTYCODETEXT SQL: ICNTYCODET Type: view BASIC Package: VDM_MD_BP_BASE

County Code Text

I_CountyCodeText is a Basic CDS View that provides data about "County Code Text" in SAP S/4HANA. It reads from 1 data source (adrcountyt) and exposes 9 fields with key fields Country, Region, County, Language. It has 4 associations to related views. Part of development package VDM_MD_BP_BASE.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
adrcountyt adrcountyt from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_CountyCode _CountyCode $projection.Country = _CountyCode.Country and $projection.Region = _CountyCode.Region and $projection.County = _CountyCode.County
[1..1] I_Region _Region $projection.Region = _Region.Region and $projection.Country = _Region.Country
[1..1] I_Country _Country $projection.Country = _Country.Country

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ICNTYCODET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label County Code Text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey County view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Country country
KEY Region region
KEY County county
KEY Language langu
CountyName county
_CountyCode _CountyCode
_Language _Language
_Country _Country
_Region _Region 
@AbapCatalog.sqlViewName: 'ICNTYCODET'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED //or #CHECK 

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'County Code Text' //same as DDL description

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.representativeKey: 'County'
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API

define view I_CountyCodeText //must start with 'I_' and end with 'Text' or 'T'

   as select from adrcountyt
     association [0..1] to I_Language as _Language  on $projection.Language = _Language.Language
  
     association [1..1] to I_CountyCode as _CountyCode on $projection.Country = _CountyCode.Country
                                                      and $projection.Region  = _CountyCode.Region
                                                      and $projection.County  = _CountyCode.County
                                                  
     association [1..1] to I_Region as _Region on $projection.Region = _Region.Region
                                             and $projection.Country = _Region.Country
                                             
     association [1..1] to I_Country as _Country on $projection.Country = _Country.Country
{
   @ObjectModel.foreignKey.association: '_Country'
   key country as Country,
   @ObjectModel.foreignKey.association: '_Region'
   key region  as Region ,
   key county  as County ,
   @Semantics.language: true
   key langu as Language, //text views shall always be language dependent

   @Semantics.text: true
   county as CountyName, 
   _CountyCode,
   _Language,
   _Country,
   _Region   
}

Learn More