P_DEPRAREAFORLEDGERTEXT

CDS View

P_DEPRAREAFORLEDGERTEXT is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DeprAreaForLedgerText view from BASIC Depreciation Area - Text 
@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