FCOV_ACC_DOC

DDL: FCOV_ACC_DOC SQL: FCOV_ACCDOC Type: view

FCOV_ACC_DOC is a CDS View in SAP S/4HANA. It reads from 3 data sources (bkpf, bseg, coep) and exposes 52 fields.

3 data source(s) 52 fields

Data Sources (3)

SourceAliasJoin Type
bkpf bkpf inner
bseg bseg from
coep coep left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName FCOV_ACCDOC view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (52)

KeyFieldSource TableSource FieldDescription
mandt bkpf mandt
kokrs coep kokrs
BELNR_FI bkpf belnr
BUZEI_FI bseg buzei
BELNR_CO coep belnr
BUZEI_CO coep buzei
gjahr bkpf gjahr
bukrs bkpf bukrs
budat bkpf budat
bktxt bkpf bktxt
usnam bkpf usnam
awtyp bkpf awtyp
awsys bkpf awsys
awkey bkpf awkey
koart bseg koart
fkber bseg fkber
segment bseg segment
geber bseg geber
grant_nbr bseg grant_nbr
budget_pd bseg budget_pd
hkont bseg hkont
saknr bseg saknr
kunnr bseg kunnr
lifnr bseg lifnr
gsber bseg gsber
aufnr bseg aufnr
mwskz bseg mwskz
perio coep perio
objnr coep objnr
paobjnr coep paobjnr
kostl bseg kostl
lstar bseg lstar
projk projk
versn versn
kstar coep kstar
hrkft bseg hrkft
vrgng coep vrgng
vbund bseg vbund
pargb bseg pargb
beknz beknz
wrbtr wrbtr
waers bkpf waers
dmbtr dmbtr
hwaer bkpf hwaer
menge menge
meinh meinh
wtgbtr coep wtgbtr
twaer coep twaer
wogbtr coep wogbtr
owaer coep owaer
megbtr coep megbtr
MEINH_CO coep meinh 
@AbapCatalog.sqlViewName: 'FCOV_ACCDOC'

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

define view FCOV_ACC_DOC as
   select from bseg 
      inner join bkpf 
            on  bkpf.mandt = bseg.mandt 
            and bkpf.bukrs = bseg.bukrs 
            and bkpf.belnr = bseg.belnr  
            and bkpf.gjahr = bseg.gjahr             
      left outer join coep 
            on  coep.mandt = bseg.mandt 
            and coep.awtyp = bseg.awtyp 
            and coep.awsys = bseg.awsys 
            and coep.awkey = bseg.awkey 
            and coep.posnr = bseg.posnr
      { bkpf.mandt, coep.kokrs, 
        bkpf.belnr as BELNR_FI, bseg.buzei as BUZEI_FI,
        coep.belnr as BELNR_CO, coep.buzei as BUZEI_CO,
        bkpf.gjahr, bkpf.bukrs, bkpf.budat, bkpf.bktxt, bkpf.usnam,  
        bkpf.awtyp, bkpf.awsys, bkpf.awkey,
        bseg.koart, bseg.fkber, bseg.segment,
        bseg.geber, bseg.grant_nbr, bseg.budget_pd, 
        bseg.hkont, bseg.saknr, bseg.kunnr, bseg.lifnr, bseg.gsber, bseg.aufnr, bseg.mwskz,
        coep.perio,
        coep.objnr, coep.paobjnr, bseg.kostl, bseg.lstar, projk, versn, coep.kstar, bseg.hrkft, coep.vrgng,
        bseg.vbund, bseg.pargb, beknz,  
        wrbtr, bkpf.waers, dmbtr, bkpf.hwaer, menge, meinh, 
        coep.wtgbtr, coep.twaer, coep.wogbtr, coep.owaer, coep.megbtr, coep.meinh as MEINH_CO }
  /* UNION ALL
   SELECT FROM COEP 
      INNER JOIN COBK
            ON  COBK.MANDT = COEP.MANDT 
            AND COBK.KOKRS = COEP.KOKRS 
            AND COBK.BELNR = COEP.BELNR  
      { COEP.MANDT, COEP.KOKRS, 
        COEP.BELNR AS BELNR_CO, BUZEI AS BUZEI_CO,
        COEP.GJAHR, BUKRS, COBK.BUDAT, USNAM,  
        COEP.AWTYP, COEP.AWSYS, COEP.AWKEY, 'S',
        // 'S' as KOART, 

        FKBER, SEGMENT,
        GEBER, GRANT_NBR, BUDGET_PD, 
        // HKONT, SAKNR, KUNNR, LIFNR, 

        GSBER, // AUFNR, MWSKZ,

        PERIO,
        OBJNR, PAOBJNR, // KOSTL, LSTAR, PROJK, 

        COEP.VERSN, KSTAR, HRKFT, COEP.VRGNG,
        VBUND, PARGB, BEKNZ,  
        // WRBTR, WAERS, DMBTR, HWAER, MENGE, MEINH, 

        WTGBTR, TWAER, WOGBTR, OWAER, MEGBTR, MEINH AS MEINH_CO }
   */

Learn More