COVPR

70 Fields 2 CDS Views

Generated Table for View

COVPR is an SAP database table in S/4HANA. Generated Table for View. It contains 70 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_StstclKeyFigureValueItem view from BASIC Statistical Key Figure Value Item
P_ActlStatisticKeyFig view from BASIC

Fields (70)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kokrs KOKRS CO Area
KEY belnr CO_BELNR Document Number
KEY buzei CO_BUZEI Posting Row
perio CO_PERIO Period
smebtr SMEXXX Statistical qty
smabtr SMAXXX MaxStatQty
meinh CO_MEINH_R Unit of measure
grtyp GRTYP Key fig. cat.
sgtxt CO_SGTXT Name
lednr LEDNR Ledger
objnr J_OBJNR Object number
gjahr GJAHR Fiscal Year
wrttp CO_WRTTP Value Type
versn VERSN Version
stagr STAGR Stat. key fig.
hrkft CO_SUBKEY CO subkey
vrgng CO_VORGANG Bus.Transaction
zlenr DZLENR Item
pernr PERNR_D Personnel No.
dabrz DABRBEZ Reference date
fkber FKBER Functional Area
geber FM_FUND Fund
grant_nbr GM_GRANT_NBR Grant
budget_pd FM_BUDGET_PERIOD Budget Period
perab CO_PERAB From Period
perbi CO_PERBI to
bldat CO_BLDAT Document Date
budat CO_BUDAT Posting Date
cpudt CO_CPUDT Created on
usnam SYUNAME User Name
bltxt CO_BLTXT Doc.Header Text
stflg CO_STFLG Reversal doc.
stokz CO_STOKZ Reversed
refbt CO_REFBT RefDocType
refbn CO_REFBN Ref.document no
refbk CO_REFBK RefCompanyCode
refgj CO_REFGJ RefFiscalYear
blart CO_REFBA Document Type
ldgrp FAGL_LDGRP Ledger Group
orgvg CO_ORGVG Original BTran.
sumbz CO_SUMBZ Line Item Total
delbz CO_DELBZ Del. Line Items
wsdat WSDAT Value Date
kurst KURST Exch. Rate Type
varnr CO_VARNR Screen variant
kwaer KWAER COarea currency
ctyp1 CO_CTYP1 Currency Type 1
ctyp2 CO_CTYP2 Currency Type 2
ctyp3 CO_CTYP3 Currency Type 3
ctyp4 CO_CTYP4 Currency Type 4
awtyp AWTYP Ref. procedure
aworg AWORG Refer. Org.Unit
logsystem LOGSYSTEM Logical System
cputm CPUTM Entered at
alebz CO_ALEBZ Post Rows Ext.
alebn CO_ALEBN ALE: Org.DocNr
awsys AWSYS Logical System
awref_rev AWREF_REV Reversal Ref.
aworg_rev AWORG_REV Reversal Org.
awkey AWKEY Reference Key
valdt CO_VALDT Valuation Date
kokrs_sender KOKRS_SENDER Sender CO Area
belnr_sender COBELNR_SENDER Send. CO Doc.No.
logsystem_sender LOGSYSTEM_SENDER Sender Log Sys.
reprocessing_status_code FINS_REPROCESSING_STATUS_CODE Reproc status code
k_gjahr GJAHR Fiscal Year
k_versn VERSN_COBK Version
k_vrgng CO_VORGANG Bus.Transaction
k_timestmp RKE_HZSTMP Time created

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE COVPR (
    MANDT,                     -- Client [MANDT]
    KOKRS,                     -- CO Area [KOKRS]
    BELNR,                     -- Document Number [CO_BELNR]
    BUZEI,                     -- Posting Row [CO_BUZEI]
    PERIO,                     -- Period [CO_PERIO]
    SMEBTR,                    -- Statistical qty [SMEXXX]
    SMABTR,                    -- MaxStatQty [SMAXXX]
    MEINH,                     -- Unit of measure [CO_MEINH_R]
    GRTYP,                     -- Key fig. cat. [GRTYP]
    SGTXT,                     -- Name [CO_SGTXT]
    LEDNR,                     -- Ledger [LEDNR]
    OBJNR,                     -- Object number [J_OBJNR]
    GJAHR,                     -- Fiscal Year [GJAHR]
    WRTTP,                     -- Value Type [CO_WRTTP]
    VERSN,                     -- Version [VERSN]
    STAGR,                     -- Stat. key fig. [STAGR]
    HRKFT,                     -- CO subkey [CO_SUBKEY]
    VRGNG,                     -- Bus.Transaction [CO_VORGANG]
    ZLENR,                     -- Item [DZLENR]
    PERNR,                     -- Personnel No. [PERNR_D]
    DABRZ,                     -- Reference date [DABRBEZ]
    FKBER,                     -- Functional Area [FKBER]
    GEBER,                     -- Fund [FM_FUND]
    GRANT_NBR,                 -- Grant [GM_GRANT_NBR]
    BUDGET_PD,                 -- Budget Period [FM_BUDGET_PERIOD]
    PERAB,                     -- From Period [CO_PERAB]
    PERBI,                     -- to [CO_PERBI]
    BLDAT,                     -- Document Date [CO_BLDAT]
    BUDAT,                     -- Posting Date [CO_BUDAT]
    CPUDT,                     -- Created on [CO_CPUDT]
    USNAM,                     -- User Name [SYUNAME]
    BLTXT,                     -- Doc.Header Text [CO_BLTXT]
    STFLG,                     -- Reversal doc. [CO_STFLG]
    STOKZ,                     -- Reversed [CO_STOKZ]
    REFBT,                     -- RefDocType [CO_REFBT]
    REFBN,                     -- Ref.document no [CO_REFBN]
    REFBK,                     -- RefCompanyCode [CO_REFBK]
    REFGJ,                     -- RefFiscalYear [CO_REFGJ]
    BLART,                     -- Document Type [CO_REFBA]
    LDGRP,                     -- Ledger Group [FAGL_LDGRP]
    ORGVG,                     -- Original BTran. [CO_ORGVG]
    SUMBZ,                     -- Line Item Total [CO_SUMBZ]
    DELBZ,                     -- Del. Line Items [CO_DELBZ]
    WSDAT,                     -- Value Date [WSDAT]
    KURST,                     -- Exch. Rate Type [KURST]
    VARNR,                     -- Screen variant [CO_VARNR]
    KWAER,                     -- COarea currency [KWAER]
    CTYP1,                     -- Currency Type 1 [CO_CTYP1]
    CTYP2,                     -- Currency Type 2 [CO_CTYP2]
    CTYP3,                     -- Currency Type 3 [CO_CTYP3]
    CTYP4,                     -- Currency Type 4 [CO_CTYP4]
    AWTYP,                     -- Ref. procedure [AWTYP]
    AWORG,                     -- Refer. Org.Unit [AWORG]
    LOGSYSTEM,                 -- Logical System [LOGSYSTEM]
    CPUTM,                     -- Entered at [CPUTM]
    ALEBZ,                     -- Post Rows Ext. [CO_ALEBZ]
    ALEBN,                     -- ALE: Org.DocNr [CO_ALEBN]
    AWSYS,                     -- Logical System [AWSYS]
    AWREF_REV,                 -- Reversal Ref. [AWREF_REV]
    AWORG_REV,                 -- Reversal Org. [AWORG_REV]
    AWKEY,                     -- Reference Key [AWKEY]
    VALDT,                     -- Valuation Date [CO_VALDT]
    KOKRS_SENDER,              -- Sender CO Area [KOKRS_SENDER]
    BELNR_SENDER,              -- Send. CO Doc.No. [COBELNR_SENDER]
    LOGSYSTEM_SENDER,          -- Sender Log Sys. [LOGSYSTEM_SENDER]
    REPROCESSING_STATUS_CODE,  -- Reproc status code [FINS_REPROCESSING_STATUS_CODE]
    K_GJAHR,                   -- Fiscal Year [GJAHR]
    K_VERSN,                   -- Version [VERSN_COBK]
    K_VRGNG,                   -- Bus.Transaction [CO_VORGANG]
    K_TIMESTMP,                -- Time created [RKE_HZSTMP]
    PRIMARY KEY (MANDT, KOKRS, BELNR, BUZEI)
);

Learn More