FAA_1ST_OPEN_FY

CDS View

Asset Accounting: First open Fiscal Year

FAA_1ST_OPEN_FY is a CDS View in S/4HANA. Asset Accounting: First open Fiscal Year. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FAA_REC_ANLC_BASE view from Reconciliation ANLC (Base View)
FAA_REC_ANLC_BASE view union_all Reconciliation ANLC (Base View) 
@AbapCatalog.sqlViewName: 'FAAV_1ST_OPEN_FY'
@EndUserText.label: 'Asset Accounting: First open Fiscal Year'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P

define view Faa_1st_Open_Fy

as select from t093b

 { mandt,
   bukrs,
   afabe,
   case abgja when '2000' then '2001'
              when '2001' then '2002'
              when '2002' then '2003'
              when '2003' then '2004'
              when '2004' then '2005'
              when '2005' then '2006'
              when '2006' then '2007'
              when '2007' then '2008'
              when '2008' then '2009'
              when '2009' then '2010'
              when '2010' then '2011'
              when '2011' then '2012'
              when '2012' then '2013'
              when '2013' then '2014'
              when '2014' then '2015'
              when '2015' then '2016'
              when '2016' then '2017'
              when '2017' then '2018'
              when '2018' then '2019'
              when '2019' then '2020'
              when '2020' then '2021'
              when '2021' then '2022'
              when '2022' then '2023'
              when '2023' then '2024'
              when '2024' then '2025'
              when '2025' then '2026'
              when '2026' then '2027'
              when '2027' then '2028'
              when '2028' then '2029'
              when '2029' then '2030'
              when '2030' then '2031'
              else abgja  end as fyear }
    
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"T093B"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More