v_coss_3_view

DDL: V_COSS_3_DDL SQL: V_COSS_3 Type: view

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

v_coss_3_view is a CDS View that provides data about "CO Object: Cost Totals for Internal 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_COSS_3 view
EndUserText.label CO Object: Cost Totals for Internal 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_COSS_3'
@EndUserText.label: 'CO Object: Cost Totals for Internal Postings (part 3)'

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

define view v_coss_3_view as
  select
         c.mandt as mandt,
         c.kokrs as kokrs,
         belnr,
         buzei,
         perio,
         wtgbtr,
         wogbtr,
         wkgbtr,
         wkfbtr,
         pagbtr,
         pafbtr,
         megbtr,
         mefbtr,
         lednr,
         objnr,
         gjahr,
         wrttp,
         versn,
         kstar,
         hrkft,
         c.vrgng,
         parob,
         uspob,
         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 xcoss = 'X'


union all
  select
         c.mandt,
         kokrs,
         belnr,
         buzei,
         perio,
         wtgbtr,
         wogbtr,
         wkgbtr,
         wkfbtr,
         pagbtr,
         pafbtr,
         megbtr,
         mefbtr,
         lednr,
         objnr,
         gjahr,
         wrttp,
         versn,
         kstar,
         hrkft,
         c.vrgng,
         parob,
         uspob,
         beknz,
         twaer,
         meinh,
         meinb,
         beltp,
         bukrs,
         fkber,
         segment,
         geber,
         grant_nbr,
         budget_pd,
         timestmp,
         cast(muvflg as abap.int1) as incomp

    from v_coss_d2_coep_view as c
    inner join tj01
       on tj01.vrgng = c.vrgng
    where wtkat = 'A'
      and xcoss = 'X'


      ;

Learn More