P_ValuationViewByDeprArea

DDL: P_VALUATIONVIEWBYDEPRAREA SQL: PFIASTVALVIEWDA Type: view BASIC

P_ValuationViewByDeprArea is a Basic CDS View in SAP S/4HANA. It reads from 5 data sources (faac_cmp_da0, faac_valview0, faac_valview1a, finsc_ld_cmp, t001) and exposes 4 fields with key fields CompanyCode, ChartOfAccounts, AssetDepreciationArea.

5 data source(s) 4 fields

Data Sources (5)

SourceAliasJoin Type
faac_cmp_da0 faac_cmp_da0 from
faac_valview0 faac_valview0 inner
faac_valview1a faac_valview1a inner
finsc_ld_cmp finsc_ld_cmp inner
t001 t001 inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PFIASTVALVIEWDA view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode faac_cmp_da0 comp_code
KEY ChartOfAccounts t001 ktopl
KEY AssetDepreciationArea faac_cmp_da0 depr_area
AssetValuationView faac_cmp_da0 valview 
@AbapCatalog.sqlViewName: 'PFIASTVALVIEWDA'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_ValuationViewByDeprArea
  as select from faac_cmp_da0
    inner join   t001           on t001.bukrs = faac_cmp_da0.comp_code
    inner join   finsc_ld_cmp   on  finsc_ld_cmp.rldnr = faac_cmp_da0.ledger
                                and finsc_ld_cmp.bukrs = faac_cmp_da0.comp_code
    inner join   faac_valview0  on faac_valview0.valview = faac_cmp_da0.valview
    inner join   faac_valview1a on  faac_valview1a.acc_principle = finsc_ld_cmp.acc_principle
                                and faac_valview1a.valview       = faac_cmp_da0.valview
{
  key faac_cmp_da0.comp_code                                      as CompanyCode,
  key t001.ktopl                                                  as ChartOfAccounts,
  key faac_cmp_da0.depr_area                                      as AssetDepreciationArea,
      faac_cmp_da0.valview                                        as AssetValuationView
}
where
     faac_valview1a.posting_type = '1' //Posts in real time

  or faac_valview1a.posting_type = '3' //Posts depreciation only

  or faac_valview1a.posting_type = '4' //Posts APC immediately and depreciation

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAAC_CMP_DA0",
"FAAC_VALVIEW0",
"FAAC_VALVIEW1A",
"FINSC_LD_CMP",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More