V_Cosp_3_Ddl_Age_view

DDL: V_COSP_3_DDL_AGE SQL: V_COSP_3_AGE Type: view

Cold Data: Primary Actuals from ACDOCA per period

V_Cosp_3_Ddl_Age_view is a CDS View that provides data about "Cold Data: Primary Actuals from ACDOCA per period" in SAP S/4HANA. It reads from 3 data sources (t000, tka01, tj01).

3 data source(s)

Data Sources (3)

SourceAliasJoin Type
t000 s inner
tka01 t inner
tj01 tj01 inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName V_COSP_3_AGE view
EndUserText.label Cold Data: Primary Actuals from ACDOCA per period view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view 
@AbapCatalog.sqlViewName: 'V_COSP_3_AGE'
@EndUserText.label: 'Cold Data: Primary Actuals from ACDOCA per period'

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

define view V_Cosp_3_Ddl_Age_view as
  select
         c.mandt as mandt,
         c.kokrs as kokrs,
         belnr,
         buzei,
         perio,
         wtgbtr,
         wogbtr,
         wkgbtr,
         wkfbtr,
         pagbtr,
         megbtr,
         mefbtr,
         lednr,
         objnr,
         gjahr,
         wrttp,
         versn,
         kstar,
         hrkft,
         c.vrgng,
         vbund,
         pargb,
         beknz,
         twaer,
         meinh,
         meinb,
         beltp,
         bukrs,
         fkber,
         segment,
         geber,
         grant_nbr,
         budget_pd,
         timestmp,
         case when mvflg = 'X' then 0            -- complete          
              else 1 
         end as incomp

    from V_Coep_04_Age_view as c
    inner join tka01       as t  on     t.mandt    = c.mandt
                                and     t.kokrs    = c.kokrs
    inner join t000        as s  on     s.mandt    = c.mandt
                                and (   s.logsys   = c.logsyso
                                     or c.logsyso  = ''
                                     or (    ( c.accasty = 'KS'       or c.accasty = 'KL' )
                                         and ( s.logsys = t.logsystem or t.logsystem = '' )
                                         )
                                     )
    inner join tj01
       on tj01.vrgng = c.vrgng
    where wtkat = 'A'
      and xcosp = 'X'

union all
  select
         mandt as mandt,
         kokrs,
         belnr,
         buzei,
         perio,
         wtgbtr,
         wogbtr,
         wkgbtr,
         wkfbtr,
         pagbtr,
         megbtr,
         mefbtr,
         lednr,
         objnr,
         gjahr,
         wrttp,
         versn,
         kstar,
         hrkft,
         vrgng,
         vbund,
         pargb,
         beknz,
         twaer,
         meinh,
         meinb,
         beltp,
         bukrs,
         fkber,
         segment,
         geber,
         grant_nbr,
         budget_pd,
         timestmp,
         cast(muvflg as abap.int1) as incomp
    from V_Cosp_D_as_Coep_Age_View
    ;
    
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"V_COEP_04_AGE_VIEW",
"V_COSP_D_AS_COEP_AGE_VIEW",
"T000",
"TJ01",
"TKA01"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More