P_SlsAcctgParamTrnsfmtn

DDL: P_SLSACCTGPARAMTRNSFMTN SQL: PSAPATR1 Type: view COMPOSITE

P_SlsAcctgParamTrnsfmtn is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_Ledger) and exposes 46 fields.

1 data source(s) 46 fields

Data Sources (1)

SourceAliasJoin Type
I_Ledger I_Ledger from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PSAPATR1 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (46)

KeyFieldSource TableSource FieldDescription
Ledger Ledger
P_LeftOperandNodeContentType
P_RightOperandNodeContentType
P_FullYear
P_Interval1Type
P_Interval2Type
P_Interval1YearDm
P_Interval2YearDm
P_Interval1FromFiscalPeriod
P_Interval2FromFiscalPeriod
P_Interval1ToFiscalPeriod
P_Interval2ToFiscalPeriod
P_LeftOperandNodeContentType
P_RightOperandNodeContentType
P_FullYear
P_Interval1Type
P_Interval2Type
P_Interval1YearDm
P_Interval2YearDm
P_Interval1FromFiscalPeriod
P_Interval2FromFiscalPeriod
P_Interval1ToFiscalPeriod
P_Interval2ToFiscalPeriod
P_LeftOperandNodeContentType
P_RightOperandNodeContentType
P_FullYear
P_Interval1Type
P_Interval2Type
P_Interval1YearDm
P_Interval2YearDm
P_Interval1FromFiscalPeriod
P_Interval2FromFiscalPeriod
P_Interval1ToFiscalPeriod
P_Interval2ToFiscalPeriod
P_LeftOperandNodeContentType
P_RightOperandNodeContentType
P_FullYear
P_Interval1Type
P_Interval2Type
P_Interval1YearDm
P_Interval2YearDm
P_Interval1FromFiscalPeriod
P_Interval2FromFiscalPeriod
P_Interval1ToFiscalPeriod
P_Interval2ToFiscalPeriod
ThisYear 
@AbapCatalog.sqlViewName: 'PSAPATR1'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType: { dataClass: #TRANSACTIONAL, serviceQuality: #C, sizeCategory: #S } }
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE


define view P_SlsAcctgParamTrnsfmtn
with parameters    
                 P_CurrentPeriod               : fis_jahrper
as 

-- actual vs plan 001-selected period --
select from I_Ledger {
     
        Ledger,
        cast ( 'AC' as fco_sls_acctg_ovw_variant )                                        as P_LeftOperandNodeContentType,
        cast ( 'PC' as fco_sls_acctg_ovw_variant )                                        as P_RightOperandNodeContentType,
        cast ( 'X'  as char1 )                                                            as P_FullYear,
        cast ( 'A'  as fac_revvar_interval_type )                                         as P_Interval1Type,
        cast ( 'P'  as fac_revvar_interval_type )                                         as P_Interval2Type,
        
        cast (  0   as abap.int4 )                                                        as P_Interval1YearDm, 
        cast (  0   as abap.int4 )                                                        as P_Interval2YearDm,
        
        cast('001'  as fins_fiscalperiod )                                                as P_Interval1FromFiscalPeriod,
        cast('001'  as fins_fiscalperiod )                                                as P_Interval2FromFiscalPeriod,
        cast(right($parameters.P_CurrentPeriod, 3)  as fins_fiscalperiod )                 as P_Interval1ToFiscalPeriod,
        cast(right($parameters.P_CurrentPeriod, 3)  as fins_fiscalperiod )                 as P_Interval2ToFiscalPeriod,  
        
        cast(left($parameters.P_CurrentPeriod, 4) as fins_gjahr)                         as ThisYear
        
}
where Ledger = '0L'

union

-- actual vs plan for selected period --
select from I_Ledger {
     
        
        Ledger,
        cast ( 'AC' as fco_sls_acctg_ovw_variant )                                        as P_LeftOperandNodeContentType,
        cast ( 'PC' as fco_sls_acctg_ovw_variant )                                        as P_RightOperandNodeContentType,
        cast ( 'Y'  as char1 )                                                            as P_FullYear,
        cast ( 'A'  as fac_revvar_interval_type )                                         as P_Interval1Type,
        cast ( 'P'  as fac_revvar_interval_type )                                         as P_Interval2Type,
        
        cast (  0   as abap.int4 )                                                        as P_Interval1YearDm, 
        cast (  0   as abap.int4 )                                                        as P_Interval2YearDm,         
        
        cast(right($parameters.P_CurrentPeriod, 3)  as fins_fiscalperiod )                 as P_Interval1FromFiscalPeriod,
        cast(right($parameters.P_CurrentPeriod, 3)  as fins_fiscalperiod )                 as P_Interval2FromFiscalPeriod,
        cast(right($parameters.P_CurrentPeriod, 3)  as fins_fiscalperiod )                 as P_Interval1ToFiscalPeriod,
        cast(right($parameters.P_CurrentPeriod, 3)  as fins_fiscalperiod )                 as P_Interval2ToFiscalPeriod,   
             
        cast(left($parameters.P_CurrentPeriod, 4) as fins_gjahr)                         as ThisYear
        
}
where Ledger = '0L'

union

-- actual year vs last year --
select from I_Ledger {
     
        Ledger,
        cast ( 'AC' as fco_sls_acctg_ovw_variant )                                        as P_LeftOperandNodeContentType,
        cast ( 'AP' as fco_sls_acctg_ovw_variant )                                        as P_RightOperandNodeContentType,
        cast ( 'X'  as char1 )                                                            as P_FullYear,
        cast ( 'A'  as fac_revvar_interval_type )                                         as P_Interval1Type,
        cast ( 'A'  as fac_revvar_interval_type )                                         as P_Interval2Type,   
        
        cast (  0   as abap.int4 )                                                        as P_Interval1YearDm, 
        cast ( -12   as abap.int4 )                                                       as P_Interval2YearDm, 
        
        cast('001'  as fins_fiscalperiod )                                                as P_Interval1FromFiscalPeriod,
        cast('001'  as fins_fiscalperiod )                                                as P_Interval2FromFiscalPeriod,
        cast(right($parameters.P_CurrentPeriod, 3)  as fins_fiscalperiod )                 as P_Interval1ToFiscalPeriod,
        cast(right($parameters.P_CurrentPeriod, 3)  as fins_fiscalperiod )                 as P_Interval2ToFiscalPeriod,              
            
        cast(left($parameters.P_CurrentPeriod, 4) as fins_gjahr)                         as ThisYear
}
where Ledger = '0L'

union

-- actual year's selected period vs last year's selected period --
select from I_Ledger {
     
        Ledger,
        cast ( 'AC' as fco_sls_acctg_ovw_variant )                                        as P_LeftOperandNodeContentType,
        cast ( 'AP' as fco_sls_acctg_ovw_variant )                                        as P_RightOperandNodeContentType,
        cast ( 'Y'  as char1 )                                                            as P_FullYear,
        cast ( 'A'  as fac_revvar_interval_type )                                         as P_Interval1Type,
        cast ( 'A'  as fac_revvar_interval_type )                                         as P_Interval2Type,   
        
        cast (  0   as abap.int4 )                                                        as P_Interval1YearDm, 
        cast ( -12   as abap.int4 )                                                       as P_Interval2YearDm, 
        
        cast(right($parameters.P_CurrentPeriod, 3)  as fins_fiscalperiod )                 as P_Interval1FromFiscalPeriod,
        cast(right($parameters.P_CurrentPeriod, 3)  as fins_fiscalperiod )                 as P_Interval2FromFiscalPeriod,
        cast(right($parameters.P_CurrentPeriod, 3)  as fins_fiscalperiod )                 as P_Interval1ToFiscalPeriod,
        cast(right($parameters.P_CurrentPeriod, 3)  as fins_fiscalperiod )                 as P_Interval2ToFiscalPeriod,              
                    
        cast(left($parameters.P_CurrentPeriod, 4) as fins_gjahr)                         as ThisYear      
}
where Ledger = '0L'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More