FCOV_ACC_DOC
FCOV_ACC_DOC is a CDS View in SAP S/4HANA. It reads from 3 data sources (bkpf, bseg, coep) and exposes 52 fields.
Annotations (4)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | FCOV_ACCDOC | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ObjectModel.usageType.serviceQuality | #P | view |
Fields (52)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 */
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA