P_DeprAreaForLedgerText

DDL: P_DEPRAREAFORLEDGERTEXT Type: view BASIC

P_DeprAreaForLedgerText is a Basic CDS View in SAP S/4HANA. It reads from 7 data sources and exposes 11 fields with key fields CompanyCode, Ledger, AssetDepreciationArea, Language, Ledger.

7 data source(s) 11 fields

Data Sources (7)

SourceAliasJoin Type
faac_cmp_da0_t faac_cmp_da0_t from
faac_cmp_da0_t faac_cmp_da0_t union_all
fagl_tldgrp_map fagl_tldgrp_map inner
P_TF_AssetRedesignSwitchStatus P_TF_AssetRedesignSwitchStatus inner
P_TF_AssetRedesignSwitchStatus P_TF_AssetRedesignSwitchStatus inner
t093 t093 inner
t093t t093t inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFIDEPRAREALDGRT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode t093c bukrs
KEY Ledger fagl_tldgrp_map rldnr
KEY AssetDepreciationArea t093t afaber
KEY Language t093t spras
AssetDepreciationAreaName
IsActiveXkeycomp_codeasCompanyCode
KEY Ledger ledger
KEY AssetDepreciationArea depr_area
KEY Language language
AssetDepreciationAreaName
AssetDepreciationAreaShortName description_short 
@AbapCatalog: { sqlViewName: 'PFIDEPRAREALDGRT', preserveKey: true, compiler.compareFilter: true }
@VDM.viewType: #BASIC
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_DeprAreaForLedgerText
  as select distinct from t093c
    inner join            t093                                                            on t093.afapl = t093c.afapl
    inner join            t093t                                                           on  t093t.afapl  = t093.afapl
                                                                                          and t093t.afaber = t093.afaber
    inner join            fagl_tldgrp_map                                                 on fagl_tldgrp_map.ldgrp = t093.ldgrp_gl
    inner join            P_TF_AssetRedesignSwitchStatus( P_SAPClient : $session.client ) on P_TF_AssetRedesignSwitchStatus.IsActive = ''
{
  key  t093c.bukrs                       as CompanyCode,
  key  fagl_tldgrp_map.rldnr             as Ledger,
  key  t093t.afaber                      as AssetDepreciationArea,
  key  t093t.spras                       as Language,

       cast (t093t.afbtxt as fis_afbtxt) as AssetDepreciationAreaName,
       t093t.afbktx                      as AssetDepreciationAreaShortName
}

union all select from faac_cmp_da0_t
  inner join          P_TF_AssetRedesignSwitchStatus( P_SAPClient : $session.client ) on P_TF_AssetRedesignSwitchStatus.IsActive = 'X'
{
  key                     comp_code                             as CompanyCode,
  key                     ledger                                as Ledger,
  key                     depr_area                             as AssetDepreciationArea,
  key                     language                              as Language,

                          cast (description_long as fis_afbtxt) as AssetDepreciationAreaName,
                          description_short                     as AssetDepreciationAreaShortName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAAC_CMP_DA0_T",
"FAGL_TLDGRP_MAP",
"T093",
"T093C",
"T093T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More