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.

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 Editing Client
kokrs coep kokrs Org. Value
BELNR_FI bkpf belnr SD Document
BUZEI_FI bseg buzei Posting View Item
BELNR_CO coep belnr SD Document
BUZEI_CO coep buzei Posting View Item
gjahr bkpf gjahr Settlement Year
bukrs bkpf bukrs Value
budat bkpf budat Posting Date
bktxt bkpf bktxt Header Text
usnam bkpf usnam User Name
awtyp bkpf awtyp Reference Document Type
awsys bkpf awsys Logical System
awkey bkpf awkey RefKey GJE
koart bseg koart Account type
fkber bseg fkber Functional Area
segment bseg segment Segment number
geber bseg geber Fund
grant_nbr bseg grant_nbr Receiver Grant
budget_pd bseg budget_pd Rec BudPer
hkont bseg hkont Transfer acct
saknr bseg saknr G/L Account
kunnr bseg kunnr Stock customer
lifnr bseg lifnr Vendor no.
gsber bseg gsber Business Area
aufnr bseg aufnr SettlementOrder
mwskz bseg mwskz Tax Code
perio coep perio Time unit
objnr coep objnr Val. Obj. No.
paobjnr coep paobjnr Profit. segment
kostl bseg kostl Substitute CC
lstar bseg lstar Activity Type
projk projk WBS Element
versn versn Version
kstar coep kstar Settlement CE
hrkft bseg hrkft Origin group order
vrgng coep vrgng Bus.Transaction
vbund bseg vbund Trading Partner
pargb bseg pargb Trdg Part.BA
beknz beknz Dr/Cr indicator
wrbtr wrbtr Gross Amount
waers bkpf waers Transaction Currency
dmbtr dmbtr Loc. amount
hwaer bkpf hwaer Local Currency
menge menge WarrCountValue
meinh meinh Unit of Measure
wtgbtr coep wtgbtr WTGBTR
twaer coep twaer Trans. Currency
wogbtr coep wogbtr WOGBTR
owaer coep owaer Object Currency
megbtr coep megbtr Total Quantity
MEINH_CO coep meinh Unit of Measure

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FCOV_ACC_DOC.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: FCOV_ACCDOC

CREATE VIEW FCOV_ACC_DOC AS
SELECT
  bkpf.mandt AS mandt,
  coep.kokrs AS kokrs,
  bkpf.belnr AS BELNR_FI,
  bseg.buzei AS BUZEI_FI,
  coep.belnr AS BELNR_CO,
  coep.buzei AS BUZEI_CO,
  bkpf.gjahr AS gjahr,
  bkpf.bukrs AS bukrs,
  bkpf.budat AS budat,
  bkpf.bktxt AS bktxt,
  bkpf.usnam AS usnam,
  bkpf.awtyp AS awtyp,
  bkpf.awsys AS awsys,
  bkpf.awkey AS awkey,
  bseg.koart AS koart,
  bseg.fkber AS fkber,
  bseg.segment AS segment,
  bseg.geber AS geber,
  bseg.grant_nbr AS grant_nbr,
  bseg.budget_pd AS budget_pd,
  bseg.hkont AS hkont,
  bseg.saknr AS saknr,
  bseg.kunnr AS kunnr,
  bseg.lifnr AS lifnr,
  bseg.gsber AS gsber,
  bseg.aufnr AS aufnr,
  bseg.mwskz AS mwskz,
  coep.perio AS perio,
  coep.objnr AS objnr,
  coep.paobjnr AS paobjnr,
  bseg.kostl AS kostl,
  bseg.lstar AS lstar,
  projk,
  versn,
  coep.kstar AS kstar,
  bseg.hrkft AS hrkft,
  coep.vrgng AS vrgng,
  bseg.vbund AS vbund,
  bseg.pargb AS pargb,
  beknz,
  wrbtr,
  bkpf.waers AS waers,
  dmbtr,
  bkpf.hwaer AS hwaer,
  menge,
  meinh,
  coep.wtgbtr AS wtgbtr,
  coep.twaer AS twaer,
  coep.wogbtr AS wogbtr,
  coep.owaer AS owaer,
  coep.megbtr AS megbtr,
  coep.meinh AS MEINH_CO
FROM bseg
INNER JOIN bkpf ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN coep ON /* join condition not captured in parsed metadata */
;