v_coss_wodelta_3_view

DDL: V_COSS_WO_BSTAT_C_L3 SQL: V_COSS_WODELTA_3 Type: view

Cost Totals for Internal Postings without records BSTAT=C (part 3)

v_coss_wodelta_3_view is a CDS View that provides data about "Cost Totals for Internal Postings without records BSTAT=C (part 3)" in SAP S/4HANA. It reads from 1 data source (tj01).

1 data source(s)

Data Sources (1)

SourceAliasJoin Type
tj01 tj01 inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName V_COSS_WODELTA_3 view
EndUserText.label Cost Totals for Internal Postings without records BSTAT=C (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_WODELTA_3'
@EndUserText.label: 'Cost Totals for Internal Postings without records BSTAT=C (part 3)'

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

define view v_coss_wodelta_3_view as
  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_coep_l4_view as c
    inner join tj01
       on tj01.vrgng = c.vrgng
    where wtkat = 'A'
      and xcoss = 'X'
      ;    
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"V_COEP_L4_VIEW",
"TJ01"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More