COEJ

Transparent Table Application Table

CO Object: Line Items (by Fiscal Year)

COEJ is an SAP database table in S/4HANA. CO Object: Line Items (by Fiscal Year). It contains 199 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProjectPlanSettlement view_entity from BASIC Project Plan Settlement Basic

Fields (199)

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
KEY perbl PERBL Period Block
wtg001 WTGXXX Value TranCurr
wtg002 WTGXXX Value TranCurr
wtg003 WTGXXX Value TranCurr
wtg004 WTGXXX Value TranCurr
wtg005 WTGXXX Value TranCurr
wtg006 WTGXXX Value TranCurr
wtg007 WTGXXX Value TranCurr
wtg008 WTGXXX Value TranCurr
wtg009 WTGXXX Value TranCurr
wtg010 WTGXXX Value TranCurr
wtg011 WTGXXX Value TranCurr
wtg012 WTGXXX Value TranCurr
wtg013 WTGXXX Value TranCurr
wtg014 WTGXXX Value TranCurr
wtg015 WTGXXX Value TranCurr
wtg016 WTGXXX Value TranCurr
wog001 WOGXXX Value/Obj. Crcy
wog002 WOGXXX Value/Obj. Crcy
wog003 WOGXXX Value/Obj. Crcy
wog004 WOGXXX Value/Obj. Crcy
wog005 WOGXXX Value/Obj. Crcy
wog006 WOGXXX Value/Obj. Crcy
wog007 WOGXXX Value/Obj. Crcy
wog008 WOGXXX Value/Obj. Crcy
wog009 WOGXXX Value/Obj. Crcy
wog010 WOGXXX Value/Obj. Crcy
wog011 WOGXXX Value/Obj. Crcy
wog012 WOGXXX Value/Obj. Crcy
wog013 WOGXXX Value/Obj. Crcy
wog014 WOGXXX Value/Obj. Crcy
wog015 WOGXXX Value/Obj. Crcy
wog016 WOGXXX Value/Obj. Crcy
wkg001 WKGXXX Val/COArea Crcy
wkg002 WKGXXX Val/COArea Crcy
wkg003 WKGXXX Val/COArea Crcy
wkg004 WKGXXX Val/COArea Crcy
wkg005 WKGXXX Val/COArea Crcy
wkg006 WKGXXX Val/COArea Crcy
wkg007 WKGXXX Val/COArea Crcy
wkg008 WKGXXX Val/COArea Crcy
wkg009 WKGXXX Val/COArea Crcy
wkg010 WKGXXX Val/COArea Crcy
wkg011 WKGXXX Val/COArea Crcy
wkg012 WKGXXX Val/COArea Crcy
wkg013 WKGXXX Val/COArea Crcy
wkg014 WKGXXX Val/COArea Crcy
wkg015 WKGXXX Val/COArea Crcy
wkg016 WKGXXX Val/COArea Crcy
wkf001 WKFXXX FixValue COCurr
wkf002 WKFXXX FixValue COCurr
wkf003 WKFXXX FixValue COCurr
wkf004 WKFXXX FixValue COCurr
wkf005 WKFXXX FixValue COCurr
wkf006 WKFXXX FixValue COCurr
wkf007 WKFXXX FixValue COCurr
wkf008 WKFXXX FixValue COCurr
wkf009 WKFXXX FixValue COCurr
wkf010 WKFXXX FixValue COCurr
wkf011 WKFXXX FixValue COCurr
wkf012 WKFXXX FixValue COCurr
wkf013 WKFXXX FixValue COCurr
wkf014 WKFXXX FixValue COCurr
wkf015 WKFXXX FixValue COCurr
wkf016 WKFXXX FixValue COCurr
pag001 PAGXXX Price Variance
pag002 PAGXXX Price Variance
pag003 PAGXXX Price Variance
pag004 PAGXXX Price Variance
pag005 PAGXXX Price Variance
pag006 PAGXXX Price Variance
pag007 PAGXXX Price Variance
pag008 PAGXXX Price Variance
pag009 PAGXXX Price Variance
pag010 PAGXXX Price Variance
pag011 PAGXXX Price Variance
pag012 PAGXXX Price Variance
pag013 PAGXXX Price Variance
pag014 PAGXXX Price Variance
pag015 PAGXXX Price Variance
pag016 PAGXXX Price Variance
paf001 PAFXXX Price Var. Fxd
paf002 PAFXXX Price Var. Fxd
paf003 PAFXXX Price Var. Fxd
paf004 PAFXXX Price Var. Fxd
paf005 PAFXXX Price Var. Fxd
paf006 PAFXXX Price Var. Fxd
paf007 PAFXXX Price Var. Fxd
paf008 PAFXXX Price Var. Fxd
paf009 PAFXXX Price Var. Fxd
paf010 PAFXXX Price Var. Fxd
paf011 PAFXXX Price Var. Fxd
paf012 PAFXXX Price Var. Fxd
paf013 PAFXXX Price Var. Fxd
paf014 PAFXXX Price Var. Fxd
paf015 PAFXXX Price Var. Fxd
paf016 PAFXXX Price Var. Fxd
meg001 MEGXXX Total Quantity
meg002 MEGXXX Total Quantity
meg003 MEGXXX Total Quantity
meg004 MEGXXX Total Quantity
meg005 MEGXXX Total Quantity
meg006 MEGXXX Total Quantity
meg007 MEGXXX Total Quantity
meg008 MEGXXX Total Quantity
meg009 MEGXXX Total Quantity
meg010 MEGXXX Total Quantity
meg011 MEGXXX Total Quantity
meg012 MEGXXX Total Quantity
meg013 MEGXXX Total Quantity
meg014 MEGXXX Total Quantity
meg015 MEGXXX Total Quantity
meg016 MEGXXX Total Quantity
mef001 MEFXXX Fixed Quantity
mef002 MEFXXX Fixed Quantity
mef003 MEFXXX Fixed Quantity
mef004 MEFXXX Fixed Quantity
mef005 MEFXXX Fixed Quantity
mef006 MEFXXX Fixed Quantity
mef007 MEFXXX Fixed Quantity
mef008 MEFXXX Fixed Quantity
mef009 MEFXXX Fixed Quantity
mef010 MEFXXX Fixed Quantity
mef011 MEFXXX Fixed Quantity
mef012 MEFXXX Fixed Quantity
mef013 MEFXXX Fixed Quantity
mef014 MEFXXX Fixed Quantity
mef015 MEFXXX Fixed Quantity
mef016 MEFXXX Fixed Quantity
mbg001 MBGXXX Total quantity
mbg002 MBGXXX Total quantity
mbg003 MBGXXX Total quantity
mbg004 MBGXXX Total quantity
mbg005 MBGXXX Total quantity
mbg006 MBGXXX Total quantity
mbg007 MBGXXX Total quantity
mbg008 MBGXXX Total quantity
mbg009 MBGXXX Total quantity
mbg010 MBGXXX Total quantity
mbg011 MBGXXX Total quantity
mbg012 MBGXXX Total quantity
mbg013 MBGXXX Total quantity
mbg014 MBGXXX Total quantity
mbg015 MBGXXX Total quantity
mbg016 MBGXXX Total quantity
mbf001 MBFXXX Fix qty entered
mbf002 MBFXXX Fix qty entered
mbf003 MBFXXX Fix qty entered
mbf004 MBFXXX Fix qty entered
mbf005 MBFXXX Fix qty entered
mbf006 MBFXXX Fix qty entered
mbf007 MBFXXX Fix qty entered
mbf008 MBFXXX Fix qty entered
mbf009 MBFXXX Fix qty entered
mbf010 MBFXXX Fix qty entered
mbf011 MBFXXX Fix qty entered
mbf012 MBFXXX Fix qty entered
mbf013 MBFXXX Fix qty entered
mbf014 MBFXXX Fix qty entered
mbf015 MBFXXX Fix qty entered
mbf016 MBFXXX Fix qty entered
lednr LEDNR Ledger
objnr J_OBJNR Object number
gjahr GJAHR Fiscal Year
wrttp CO_WRTTP Value Type
versn VERSN Version
kstar KSTAR Cost Element
hrkft CO_SUBKEY CO subkey
vrgng CO_VORGANG Bus.Transaction
parob PAROB Partner Object
parob1 PAROB1 Partner Object
uspob USPOB Source Object
vbund RASSC Trading Partner
pargb PARGB Trdg Part.BA
beknz BEKNZ Dr/Cr indicator
twaer TWAER Trans. Currency
meinh CO_MEINH Unit of Measure
meinb MEINB Posted UofMeas.
sgtxt CO_SGTXT Name
refbz CO_REFBZ Posting Row
zlenr DZLENR Item
bw_refbz BW_REFBZ Row in op. ver.
beltp BP_INOUT Debit Type
timestmp RKE_HZSTMP Time created
paobjnr RKEOBJNR Profit. segment
fkber FKBER Functional Area
pfkber SFKBER Partner FArea
geber FM_FUND Fund
pgeber FM_PFUND Partner Fund
grant_nbr GM_GRANT_NBR Grant
pgrant_nbr GM_GRANT_PARTNER Partner Grant
segment FB_SEGMENT Segment
psegment FB_PSEGMENT Partner Segment
budget_pd FM_BUDGET_PERIOD Budget Period
pbudget_pd FM_PBUDGET_PERIOD Par. BudPer

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.

-- CO Object: Line Items (by Fiscal Year)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE COEJ (
    MANDT,       -- Client [MANDT]
    KOKRS,       -- CO Area [KOKRS]
    BELNR,       -- Document Number [CO_BELNR]
    BUZEI,       -- Posting Row [CO_BUZEI]
    PERBL,       -- Period Block [PERBL]
    WTG001,      -- Value TranCurr [WTGXXX]
    WTG002,      -- Value TranCurr [WTGXXX]
    WTG003,      -- Value TranCurr [WTGXXX]
    WTG004,      -- Value TranCurr [WTGXXX]
    WTG005,      -- Value TranCurr [WTGXXX]
    WTG006,      -- Value TranCurr [WTGXXX]
    WTG007,      -- Value TranCurr [WTGXXX]
    WTG008,      -- Value TranCurr [WTGXXX]
    WTG009,      -- Value TranCurr [WTGXXX]
    WTG010,      -- Value TranCurr [WTGXXX]
    WTG011,      -- Value TranCurr [WTGXXX]
    WTG012,      -- Value TranCurr [WTGXXX]
    WTG013,      -- Value TranCurr [WTGXXX]
    WTG014,      -- Value TranCurr [WTGXXX]
    WTG015,      -- Value TranCurr [WTGXXX]
    WTG016,      -- Value TranCurr [WTGXXX]
    WOG001,      -- Value/Obj. Crcy [WOGXXX]
    WOG002,      -- Value/Obj. Crcy [WOGXXX]
    WOG003,      -- Value/Obj. Crcy [WOGXXX]
    WOG004,      -- Value/Obj. Crcy [WOGXXX]
    WOG005,      -- Value/Obj. Crcy [WOGXXX]
    WOG006,      -- Value/Obj. Crcy [WOGXXX]
    WOG007,      -- Value/Obj. Crcy [WOGXXX]
    WOG008,      -- Value/Obj. Crcy [WOGXXX]
    WOG009,      -- Value/Obj. Crcy [WOGXXX]
    WOG010,      -- Value/Obj. Crcy [WOGXXX]
    WOG011,      -- Value/Obj. Crcy [WOGXXX]
    WOG012,      -- Value/Obj. Crcy [WOGXXX]
    WOG013,      -- Value/Obj. Crcy [WOGXXX]
    WOG014,      -- Value/Obj. Crcy [WOGXXX]
    WOG015,      -- Value/Obj. Crcy [WOGXXX]
    WOG016,      -- Value/Obj. Crcy [WOGXXX]
    WKG001,      -- Val/COArea Crcy [WKGXXX]
    WKG002,      -- Val/COArea Crcy [WKGXXX]
    WKG003,      -- Val/COArea Crcy [WKGXXX]
    WKG004,      -- Val/COArea Crcy [WKGXXX]
    WKG005,      -- Val/COArea Crcy [WKGXXX]
    WKG006,      -- Val/COArea Crcy [WKGXXX]
    WKG007,      -- Val/COArea Crcy [WKGXXX]
    WKG008,      -- Val/COArea Crcy [WKGXXX]
    WKG009,      -- Val/COArea Crcy [WKGXXX]
    WKG010,      -- Val/COArea Crcy [WKGXXX]
    WKG011,      -- Val/COArea Crcy [WKGXXX]
    WKG012,      -- Val/COArea Crcy [WKGXXX]
    WKG013,      -- Val/COArea Crcy [WKGXXX]
    WKG014,      -- Val/COArea Crcy [WKGXXX]
    WKG015,      -- Val/COArea Crcy [WKGXXX]
    WKG016,      -- Val/COArea Crcy [WKGXXX]
    WKF001,      -- FixValue COCurr [WKFXXX]
    WKF002,      -- FixValue COCurr [WKFXXX]
    WKF003,      -- FixValue COCurr [WKFXXX]
    WKF004,      -- FixValue COCurr [WKFXXX]
    WKF005,      -- FixValue COCurr [WKFXXX]
    WKF006,      -- FixValue COCurr [WKFXXX]
    WKF007,      -- FixValue COCurr [WKFXXX]
    WKF008,      -- FixValue COCurr [WKFXXX]
    WKF009,      -- FixValue COCurr [WKFXXX]
    WKF010,      -- FixValue COCurr [WKFXXX]
    WKF011,      -- FixValue COCurr [WKFXXX]
    WKF012,      -- FixValue COCurr [WKFXXX]
    WKF013,      -- FixValue COCurr [WKFXXX]
    WKF014,      -- FixValue COCurr [WKFXXX]
    WKF015,      -- FixValue COCurr [WKFXXX]
    WKF016,      -- FixValue COCurr [WKFXXX]
    PAG001,      -- Price Variance [PAGXXX]
    PAG002,      -- Price Variance [PAGXXX]
    PAG003,      -- Price Variance [PAGXXX]
    PAG004,      -- Price Variance [PAGXXX]
    PAG005,      -- Price Variance [PAGXXX]
    PAG006,      -- Price Variance [PAGXXX]
    PAG007,      -- Price Variance [PAGXXX]
    PAG008,      -- Price Variance [PAGXXX]
    PAG009,      -- Price Variance [PAGXXX]
    PAG010,      -- Price Variance [PAGXXX]
    PAG011,      -- Price Variance [PAGXXX]
    PAG012,      -- Price Variance [PAGXXX]
    PAG013,      -- Price Variance [PAGXXX]
    PAG014,      -- Price Variance [PAGXXX]
    PAG015,      -- Price Variance [PAGXXX]
    PAG016,      -- Price Variance [PAGXXX]
    PAF001,      -- Price Var. Fxd [PAFXXX]
    PAF002,      -- Price Var. Fxd [PAFXXX]
    PAF003,      -- Price Var. Fxd [PAFXXX]
    PAF004,      -- Price Var. Fxd [PAFXXX]
    PAF005,      -- Price Var. Fxd [PAFXXX]
    PAF006,      -- Price Var. Fxd [PAFXXX]
    PAF007,      -- Price Var. Fxd [PAFXXX]
    PAF008,      -- Price Var. Fxd [PAFXXX]
    PAF009,      -- Price Var. Fxd [PAFXXX]
    PAF010,      -- Price Var. Fxd [PAFXXX]
    PAF011,      -- Price Var. Fxd [PAFXXX]
    PAF012,      -- Price Var. Fxd [PAFXXX]
    PAF013,      -- Price Var. Fxd [PAFXXX]
    PAF014,      -- Price Var. Fxd [PAFXXX]
    PAF015,      -- Price Var. Fxd [PAFXXX]
    PAF016,      -- Price Var. Fxd [PAFXXX]
    MEG001,      -- Total Quantity [MEGXXX]
    MEG002,      -- Total Quantity [MEGXXX]
    MEG003,      -- Total Quantity [MEGXXX]
    MEG004,      -- Total Quantity [MEGXXX]
    MEG005,      -- Total Quantity [MEGXXX]
    MEG006,      -- Total Quantity [MEGXXX]
    MEG007,      -- Total Quantity [MEGXXX]
    MEG008,      -- Total Quantity [MEGXXX]
    MEG009,      -- Total Quantity [MEGXXX]
    MEG010,      -- Total Quantity [MEGXXX]
    MEG011,      -- Total Quantity [MEGXXX]
    MEG012,      -- Total Quantity [MEGXXX]
    MEG013,      -- Total Quantity [MEGXXX]
    MEG014,      -- Total Quantity [MEGXXX]
    MEG015,      -- Total Quantity [MEGXXX]
    MEG016,      -- Total Quantity [MEGXXX]
    MEF001,      -- Fixed Quantity [MEFXXX]
    MEF002,      -- Fixed Quantity [MEFXXX]
    MEF003,      -- Fixed Quantity [MEFXXX]
    MEF004,      -- Fixed Quantity [MEFXXX]
    MEF005,      -- Fixed Quantity [MEFXXX]
    MEF006,      -- Fixed Quantity [MEFXXX]
    MEF007,      -- Fixed Quantity [MEFXXX]
    MEF008,      -- Fixed Quantity [MEFXXX]
    MEF009,      -- Fixed Quantity [MEFXXX]
    MEF010,      -- Fixed Quantity [MEFXXX]
    MEF011,      -- Fixed Quantity [MEFXXX]
    MEF012,      -- Fixed Quantity [MEFXXX]
    MEF013,      -- Fixed Quantity [MEFXXX]
    MEF014,      -- Fixed Quantity [MEFXXX]
    MEF015,      -- Fixed Quantity [MEFXXX]
    MEF016,      -- Fixed Quantity [MEFXXX]
    MBG001,      -- Total quantity [MBGXXX]
    MBG002,      -- Total quantity [MBGXXX]
    MBG003,      -- Total quantity [MBGXXX]
    MBG004,      -- Total quantity [MBGXXX]
    MBG005,      -- Total quantity [MBGXXX]
    MBG006,      -- Total quantity [MBGXXX]
    MBG007,      -- Total quantity [MBGXXX]
    MBG008,      -- Total quantity [MBGXXX]
    MBG009,      -- Total quantity [MBGXXX]
    MBG010,      -- Total quantity [MBGXXX]
    MBG011,      -- Total quantity [MBGXXX]
    MBG012,      -- Total quantity [MBGXXX]
    MBG013,      -- Total quantity [MBGXXX]
    MBG014,      -- Total quantity [MBGXXX]
    MBG015,      -- Total quantity [MBGXXX]
    MBG016,      -- Total quantity [MBGXXX]
    MBF001,      -- Fix qty entered [MBFXXX]
    MBF002,      -- Fix qty entered [MBFXXX]
    MBF003,      -- Fix qty entered [MBFXXX]
    MBF004,      -- Fix qty entered [MBFXXX]
    MBF005,      -- Fix qty entered [MBFXXX]
    MBF006,      -- Fix qty entered [MBFXXX]
    MBF007,      -- Fix qty entered [MBFXXX]
    MBF008,      -- Fix qty entered [MBFXXX]
    MBF009,      -- Fix qty entered [MBFXXX]
    MBF010,      -- Fix qty entered [MBFXXX]
    MBF011,      -- Fix qty entered [MBFXXX]
    MBF012,      -- Fix qty entered [MBFXXX]
    MBF013,      -- Fix qty entered [MBFXXX]
    MBF014,      -- Fix qty entered [MBFXXX]
    MBF015,      -- Fix qty entered [MBFXXX]
    MBF016,      -- Fix qty entered [MBFXXX]
    LEDNR,       -- Ledger [LEDNR]
    OBJNR,       -- Object number [J_OBJNR]
    GJAHR,       -- Fiscal Year [GJAHR]
    WRTTP,       -- Value Type [CO_WRTTP]
    VERSN,       -- Version [VERSN]
    KSTAR,       -- Cost Element [KSTAR]
    HRKFT,       -- CO subkey [CO_SUBKEY]
    VRGNG,       -- Bus.Transaction [CO_VORGANG]
    PAROB,       -- Partner Object [PAROB]
    PAROB1,      -- Partner Object [PAROB1]
    USPOB,       -- Source Object [USPOB]
    VBUND,       -- Trading Partner [RASSC]
    PARGB,       -- Trdg Part.BA [PARGB]
    BEKNZ,       -- Dr/Cr indicator [BEKNZ]
    TWAER,       -- Trans. Currency [TWAER]
    MEINH,       -- Unit of Measure [CO_MEINH]
    MEINB,       -- Posted UofMeas. [MEINB]
    SGTXT,       -- Name [CO_SGTXT]
    REFBZ,       -- Posting Row [CO_REFBZ]
    ZLENR,       -- Item [DZLENR]
    BW_REFBZ,    -- Row in op. ver. [BW_REFBZ]
    BELTP,       -- Debit Type [BP_INOUT]
    TIMESTMP,    -- Time created [RKE_HZSTMP]
    PAOBJNR,     -- Profit. segment [RKEOBJNR]
    FKBER,       -- Functional Area [FKBER]
    PFKBER,      -- Partner FArea [SFKBER]
    GEBER,       -- Fund [FM_FUND]
    PGEBER,      -- Partner Fund [FM_PFUND]
    GRANT_NBR,   -- Grant [GM_GRANT_NBR]
    PGRANT_NBR,  -- Partner Grant [GM_GRANT_PARTNER]
    SEGMENT,     -- Segment [FB_SEGMENT]
    PSEGMENT,    -- Partner Segment [FB_PSEGMENT]
    BUDGET_PD,   -- Budget Period [FM_BUDGET_PERIOD]
    PBUDGET_PD,  -- Par. BudPer [FM_PBUDGET_PERIOD]
    PRIMARY KEY (MANDT, KOKRS, BELNR, BUZEI, PERBL)
);