V_COSP_WO_MUV_1_view

DDL: V_COSP_WO_MUV_1 SQL: V_COSP_WO_MUV_1 Type: view

V_COSP_WO_MUV_1_view is a CDS View in SAP S/4HANA. It reads from 1 data source (tj01).

1 data source(s)

Data Sources (1)

SourceAliasJoin Type
tj01 tj01 inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName V_COSP_WO_MUV_1 view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view 
@AbapCatalog.sqlViewName: 'V_COSP_WO_MUV_1'

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

define view V_COSP_WO_MUV_1_view as
  select 
         coep.mandt,
         kokrs,
         belnr,
         buzei,
         perio,
         wtgbtr,
         wogbtr,
         wkgbtr,
         wkfbtr,
         pagbtr,
         megbtr,
         mefbtr,
         lednr,
         objnr,
         gjahr,
         wrttp,
         versn,
         kstar,
         hrkft,
         coep.vrgng,
         vbund,
         pargb,
         beknz,
         twaer,
         meinh,
         meinb,
         mvflg,
         beltp,
         bukrs,
         fkber,
         segment,
         geber,
         grant_nbr,
         budget_pd,
         timestmp
    from coep
    inner join tj01
       on tj01.vrgng = coep.vrgng
    where wtkat = 'A'
      and xcosp = 'X'
      and (   wrttp = '04'    
           or wrttp = '11' )      
        ; 
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"COEP",
"TJ01"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More