Which tables does SEPM_I_CountryText use?

SEPM_I_CountryText reads from 1 data source(s): t005t.

How many fields does SEPM_I_CountryText have?

SEPM_I_CountryText has 10 fields. Key fields: Language, Country.

SEPM_I_CountryText

DDL: SEPM_I_COUNTRYTEXT SQL: SEPM_ICOUNTRYT Type: view

EPM Demo: Country Texts

SEPM_I_CountryText is a CDS View that provides data about "EPM Demo: Country Texts" in SAP S/4HANA. It reads from 1 data source (t005t) and exposes 10 fields with key fields Language, Country. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
t005t	t005t	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	SEPM_I_Language	_Language	`$projection.Language = _Language.Language`
[1..1]	SEPM_I_Country	_Country	`$projection.Country = _Country.Country`

Annotations (12)

Name	Value	Level
EndUserText.label	EPM Demo: Country Texts	view
ObjectModel.dataCategory	#TEXT	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
Analytics.dataExtraction.enabled	true	view
ObjectModel.representativeKey	Country	view
AbapCatalog.sqlViewName	SEPM_ICOUNTRYT	view
AbapCatalog.buffering.type	#GENERIC	view
AbapCatalog.buffering.status	#ACTIVE	view
AbapCatalog.buffering.numberOfKeyFields	2	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view

Fields (10)

Key	Field	Source Field
KEY	Language	spras
KEY	Country	land1
	CountryName	landx50
	NationalityName	natio50
	CountryShortName	landx
	NationalityShortName	natio
	CountryLongName	landx50
	NationalityLongName	natio50
	_Language	_Language
	_Country	_Country

@EndUserText.label: 'EPM Demo: Country Texts'
//@VDM.viewType: #BASIC

@ObjectModel.dataCategory: #TEXT
@AccessControl.authorizationCheck: #NOT_REQUIRED        -- instance-based access control not needed
@Analytics.dataExtraction.enabled: true
@ObjectModel.representativeKey: 'Country'
@AbapCatalog.sqlViewName: 'SEPM_ICOUNTRYT'

@AbapCatalog.buffering.type: #GENERIC
@AbapCatalog.buffering.status:#ACTIVE
@AbapCatalog.buffering.numberOfKeyFields: 2

@ObjectModel.usageType.serviceQuality:#A
@ObjectModel.usageType.sizeCategory:#S
@ObjectModel.usageType.dataClass: #CUSTOMIZING


define view SEPM_I_CountryText as
select
  from t005t

association [0..1] to SEPM_I_Language as _Language
  on $projection.Language = _Language.Language
association [1..1] to SEPM_I_Country  as _Country
  on $projection.Country = _Country.Country

{
  @Semantics.language: true
  @ObjectModel.foreignKey.association: '_Language'
  key spras     as Language,   
  key land1     as Country,      
  @Semantics.text: true           
  landx50       as CountryName,
  @Semantics.text: true
  natio50       as NationalityName,
  @Semantics.text: true
//  landx         as CountryName,   

  landx         as CountryShortName,   
  @Semantics.text: true
//  natio         as NationalityName,                

  natio         as NationalityShortName,                
  @Semantics.text: true           
  landx50       as CountryLongName,     //obsolete field, do not use!

  @Semantics.text: true
  natio50       as NationalityLongName, //obsolete field, do not use!

  _Language,
  _Country
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T005T"
],
"ASSOCIATED":
[
"SEPM_I_COUNTRY",
"SEPM_I_LANGUAGE"
],
"BASE":
[],
"VERSION":0
}
}*/

Depth:

SEPM_I_CountryText view

t005t