COEJ SAP (CO Object: Line Items (by Fiscal Year)) Table details
Dictionary Type: Table
Description: CO Object: Line Items (by Fiscal Year)
Description: CO Object: Line Items (by Fiscal Year)
Table field list including key, data, relationships and ABAP select examples
COEJ is a standard SAP Table which is used to store CO Object: Line Items (by Fiscal Year) data and is available within R/3 SAP systems depending on the version and release level.
The COEJ table consists of various fields, each holding specific information or linking keys about CO Object: Line Items (by Fiscal Year) data available in SAP. These include MANDT (Client), KOKRS (Controlling Area), BELNR (Document Number), BUZEI (Posting row).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP COEJ table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
BELNR | Document Number | CO_BELNR | CHAR | 10 | COBK | ALPHA | CO_BELNR | BLN | |
BUZEI | Posting row | CO_BUZEI | NUMC | 3 | BUZEI | ||||
PERBL | Period block | PERBL | NUMC | 3 | PERBL | VPE | |||
WTG001 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG002 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG003 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG004 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG005 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG006 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG007 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG008 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG009 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG010 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG011 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG012 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG013 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG014 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG015 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WTG016 | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WOG001 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG002 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG003 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG004 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG005 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG006 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG007 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG008 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG009 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG010 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG011 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG012 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG013 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG014 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG015 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WOG016 | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WKG001 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG002 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG003 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG004 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG005 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG006 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG007 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG008 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG009 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG010 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG011 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG012 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG013 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG014 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG015 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKG016 | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKF001 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF002 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF003 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF004 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF005 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF006 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF007 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF008 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF009 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF010 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF011 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF012 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF013 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF014 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF015 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
WKF016 | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
PAG001 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG002 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG003 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG004 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG005 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG006 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG007 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG008 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG009 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG010 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG011 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG012 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG013 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG014 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG015 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAG016 | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
PAF001 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF002 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF003 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF004 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF005 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF006 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF007 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF008 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF009 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF010 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF011 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF012 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF013 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF014 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF015 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
PAF016 | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
MEG001 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG002 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG003 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG004 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG005 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG006 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG007 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG008 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG009 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG010 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG011 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG012 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG013 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG014 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG015 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEG016 | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
MEF001 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF002 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF003 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF004 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF005 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF006 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF007 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF008 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF009 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF010 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF011 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF012 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF013 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF014 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF015 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MEF016 | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
MBG001 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG002 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG003 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG004 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG005 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG006 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG007 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG008 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG009 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG010 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG011 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG012 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG013 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG014 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG015 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBG016 | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
MBF001 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF002 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF003 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF004 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF005 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF006 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF007 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF008 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF009 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF010 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF011 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF012 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF013 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF014 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF015 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
MBF016 | Fixed quantity entered | MBFXXX | QUAN | 15(3) | MENGV8 | ||||
LEDNR | Ledger for Controlling objects | LEDNR | CHAR | 2 | ALPHA | LEDNR | |||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
WRTTP | Value Type | CO_WRTTP | CHAR | 2 | CO_WRTTP | ||||
VERSN | Version | VERSN | CHAR | 3 | TKA09 | ALPHA | COVERSI | KVS | |
KSTAR | Cost Element | KSTAR | CHAR | 10 | CSKA | ALPHA | KSTAR | KAT | |
HRKFT | CO key subnumber | CO_SUBKEY | CHAR | 14 | Assigned to domain | CO_SUBKEY | |||
VRGNG | CO Business Transaction | CO_VORGANG | CHAR | 4 | Assigned to domain | J_VORGANG | |||
PAROB | Partner Object | PAROB | CHAR | 22 | ONR00 | J_OBJNR | |||
PAROB1 | Partner object (always filled) | PAROB1 | CHAR | 22 | ONR00 | J_OBJNR | |||
USPOB | Source Object (Cost Center/Activity Type) | USPOB | CHAR | 22 | ONR00 | J_OBJNR | |||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
PARGB | Trading partner's business area | PARGB | CHAR | 4 | TGSB | GSBER | GSB | ||
BEKNZ | Debit/credit indicator | BEKNZ | CHAR | 1 | BEKNZ | BEKNZ | |||
TWAER | Transaction Currency | TWAER | CUKY | 5 | TCURC | WAERS | FWS | ||
MEINH | Unit of Measure | CO_MEINH | UNIT | 3 | T006 | CUNIT | MEINS | ||
MEINB | Posted Unit of Measure | MEINB | UNIT | 3 | T006 | CUNIT | MEINS | ||
SGTXT | Segment text | CO_SGTXT | CHAR | 50 | TEXT50 | ||||
REFBZ | Posting row of reference document | CO_REFBZ | NUMC | 3 | BUZEI | ||||
ZLENR | Document Item Number | DZLENR | NUMC | 3 | NUM3 | ||||
BW_REFBZ | Posting Row in Operative Version | BW_REFBZ | NUMC | 3 | BUZEI | ||||
BELTP | Debit type | BP_INOUT | NUMC | 1 | BP_INOUT | ||||
TIMESTMP | Time created (Greenwich Meantime) | RKE_HZSTMP | DEC | 16 | RKE_TSTMP | ||||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
FKBER | Functional Area | FKBER | CHAR | 16 | TFKB | FKBER | FBE | ||
PFKBER | Partner Functional Area | SFKBER | CHAR | 16 | TFKB | FKBER | |||
GEBER | Fund | FM_FUND | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
PGEBER | Partner Fund | FM_PFUND | CHAR | 10 | Assigned to domain | BP_GEBER | PARTNER_FUND | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
PGRANT_NBR | Partner Grant | GM_GRANT_PARTNER | CHAR | 20 | ALPHA | GM_GRANT_NBR | GRANTS_GENERIC | ||
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | FAGL_SEGM | ALPHA | FB_SEGMENT | ||
PSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | CHAR | 10 | FAGL_SEGM | ALPHA | FB_SEGMENT | ||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
PBUDGET_PD | FM: Partner Budget Period | FM_PBUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER |
Key field | Non-key field |
How do I retrieve data from SAP table COEJ using ABAP code
The following ABAP code Example will allow you to do a basic selection on COEJ to SELECT all data from the tableDATA: WA_COEJ TYPE COEJ.
SELECT SINGLE *
FROM COEJ
INTO CORRESPONDING FIELDS OF WA_COEJ
WHERE...
How to access SAP table COEJ
Within an ECC or HANA version of SAP you can also view further information about COEJ and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects