Atov_Pk_Text_Package

DDL: ATOV_PK_TEXT_PACKAGE SQL: ATO_V_PK_T_P Type: view

Description of Package

Atov_Pk_Text_Package is a CDS View that provides data about "Description of Package" in SAP S/4HANA. It reads from 3 data sources (Atov_Pk_Text_Package_Masterlan, Atov_Pk_Text_Package_Sylangu, tdevc) and exposes 1 field with key field devclass.

3 data source(s) 1 fields

Data Sources (3)

SourceAliasJoin Type
Atov_Pk_Text_Package_Masterlan Atov_Pk_Text_Package_Masterlan left_outer
Atov_Pk_Text_Package_Sylangu Atov_Pk_Text_Package_Sylangu left_outer
tdevc tdevc from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_PK_T_P view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Description of Package view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY devclass tdevc devclass 
@AbapCatalog.sqlViewName: 'ATO_V_PK_T_P'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@EndUserText.label: 'Description of Package'
define view Atov_Pk_Text_Package as select from tdevc

left outer join Atov_Pk_Text_Package_Sylangu
  on Atov_Pk_Text_Package_Sylangu.devclass = tdevc.devclass

left outer join Atov_Pk_Text_Package_Masterlan 
on Atov_Pk_Text_Package_Masterlan.devclass = tdevc.devclass

 {
    key tdevc.devclass,
    
    case COALESCE( Atov_Pk_Text_Package_Sylangu.description, '' ) 
      when ''
        then
          case COALESCE( Atov_Pk_Text_Package_Masterlan.description, '' )
            when ''
              then ''
              else Atov_Pk_Text_Package_Masterlan.description
            end
        else Atov_Pk_Text_Package_Sylangu.description
    end as description
} 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_PK_TEXT_PACKAGE_MASTERLAN",
"ATOV_PK_TEXT_PACKAGE_SYLANGU",
"TDEVC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More