v_cosp_3_view

DDL: V_COSP_3_DDL SQL: V_COSP_3 Type: view

CO Object: Cost Totals for External Postings (part 3)

v_cosp_3_view is a CDS View that provides data about "CO Object: Cost Totals for External Postings (part 3)" in SAP S/4HANA. It reads from 4 data sources (t000, tka01, tj01, tj01).

4 data source(s)

Data Sources (4)

SourceAliasJoin Type
t000 s inner
tka01 t inner
tj01 tj01 inner
tj01 tj01 inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName V_COSP_3 view
EndUserText.label CO Object: Cost Totals for External Postings (part 3) 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'
@EndUserText.label: 'CO Object: Cost Totals for External Postings (part 3)'

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

define view v_cosp_3_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,
         cast(MUVFLG as abap.int1) as incomp

    from v_coep_v2_l4_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
         c.mandt as mandt,
         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,
         cast(muvflg as abap.int1) as incomp
    from v_cosp_d2_coep_view as c
    inner join tj01
       on tj01.vrgng = c.vrgng
    where wtkat = 'A'
      and xcosp = 'X'
    ;
        
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"V_COEP_V2_L4_VIEW",
"V_COSP_D2_COEP_VIEW",
"T000",
"TJ01",
"TKA01"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More