Atov_Pk_Text_Package_Masterlan

DDL: ATOV_PK_TEXT_PACKAGE_MASTERLAN SQL: ATO_V_PK_T_P_ML Type: view

Package Text in MasterLangauge

Atov_Pk_Text_Package_Masterlan is a CDS View that provides data about "Package Text in MasterLangauge" in SAP S/4HANA. It reads from 2 data sources (tadir, tdevct) and exposes 4 fields with key field devclass.

Data Sources (2)

SourceAliasJoin Type
tadir tadir inner
tdevct tdevct from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_PK_T_P_ML view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Package Text in MasterLangauge view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY devclass tdevct devclass
description tdevct ctext
language spras
masterlang tadir masterlang
@AbapCatalog.sqlViewName: 'ATO_V_PK_T_P_ML'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Package Text in MasterLangauge'
define view Atov_Pk_Text_Package_Masterlan as select from tdevct

inner join tadir as tadir
    on tadir.pgmid         = 'R3TR' and
       tadir.object        = 'DEVC' and
       tadir.obj_name      = tdevct.devclass
 {
    key tdevct.devclass,
    tdevct.ctext as description,
    spras as language,
    tadir.masterlang as masterlang
}
where spras = tadir.masterlang
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TADIR",
"TDEVCT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/