vfco_dll_co88_wo_op_l1

DDL: VFCO_CO88_WO_OP_L1 SQL: VFCO_CO88_A_L1 Type: view Package: KABR

CDS-View for transaction CO88 - first step

vfco_dll_co88_wo_op_l1 is a CDS View that provides data about "CDS-View for transaction CO88 - first step" in SAP S/4HANA. It reads from 5 data sources (afko, afpo, jest, jsto, vfco_tj07_koao). Part of development package KABR.

5 data source(s)

Data Sources (5)

SourceAliasJoin Type
afko ak inner
afpo ap left_outer
jest je inner
jsto js inner
vfco_tj07_koao t7 inner

Annotations (5)

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

  select au.mandt,
         au.kokrs,
         au.gsber,
         au.prctr,         
         au.bukrs,
         au.werks,
         au.func_area,
         au.aufex,
         au.aufnr,
         au.auart,
         au.autyp,
         au.objnr,
         au.pspel,   --      as pspel_aufk,
         au.awsls,
         au.abgsl,
         au.astkz,
         au.loekz,
         au.kdauf,
         au.cckey,
         au.waers,
         au.kvewe,
         au.kappl,
         au.kalsm,
         au.zschl,
         au.pkosa,
         au.flg_mltps,
         au.procnr,         
         au.scope,
         au.plint,
         au.ivpro,
         au.rsord,
         au.logsystem,
         au.idat2      as tadat, 
         au.ktext,        

         ak.ntzue,
         ak.vorue,
         ak.profid,
         ak.pronr,
         ak.aufnt,
         ak.aufpt,
         ak.netzkont,
         ak.plnbez,
         ak.plnbez     as matnr,
         ak.plnal,
         ak.plnnr,
         ak.maufnr,
         ak.colordproc,
         ak.atrkz,
         
         ap.projn,   --      as pspel_afpo,
         ap.posnr,
         ap.matnr      as matnr_afpo,
         ap.safnr,
         ap.verid,
         ap.sobkz,
         ap.kzbws,
         ap.objnp,
      
         case ap.projn 
           when '00000000' then au.pspel
           else                 ap.projn
         end as pspel_calc,      
         
         js.obtyp,
         js.stsma,
         je.stat,
         t7.modkz,
        
         case  t7.modkz
           when '3' then 1           
           else          0
         end as relevant      
    from aufk         as au
      inner join afko as ak       on au.mandt = ak.mandt and
                                     au.aufnr = ak.aufnr    
      
      left outer join afpo as ap  on au.mandt = ap.mandt and
                                     au.aufnr = ap.aufnr                                       
      inner join jsto as js       on au.mandt = js.mandt and
                                     au.objnr = js.objnr
      inner join jest as je       on js.mandt = je.mandt and
                                     js.objnr = je.objnr 
      inner join vfco_tj07_koao as t7  on je.stat  = t7.istat     
   where   ( au.autyp = '04' or au.autyp = '05' or au.autyp = '06' or
             au.autyp = '10' or au.autyp = '20' or au.autyp = '30' or au.autyp = '40' ) and
            au.astkz = ' ' and
            au.loekz = ' ' and
            ak.netzkont <> '2' and            
            je.inact <> 'X'  
   ;

Learn More