SAP CE7IDEB Table data and field list

CE7IDEB is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CE7IDEB TYPE CE7IDEB.

The CE7IDEB table consists of various fields, each holding specific information or linking keys about data available in SAP. These include PALEDGER (Currency type for an operating concern), ERKRS (Operating concern), VRGAR (Record Type), PLIKZ (Plan/Actual Indicator)... 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. .

CE7IDEB structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP CE7IDEB structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CE7IDEB table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
PALEDGER	Currency type for an operating concern	LEDBO	CHAR	2	TKEL	LEDBO	LEDBO
ERKRS	Operating concern	ERKRS	CHAR	4	TKEB		ERKRS	ERB
VRGAR	Record Type	RKE_VRGAR	CHAR	1	TVGA		VRGAR	VGA
PLIKZ	Plan/Actual Indicator	PLIKZ	CHAR	1			PLIKZ
VERSI	Receiver version (CO-PA)	RKEVERSI_R	CHAR	3	TKVS	ALPHA	COVERSI	PVS
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
FIELDNAME	Field Name	FIELDNAME	CHAR	30	Assigned to domain		FDNAME	DFD
KNDNR	Customer	KUNDE_PA	CHAR	10	KNA1	ALPHA	KUNNR	VAG
ARTNR	Product number	ARTNR	CHAR	18	MARA	MATN1	MATNR	MAT
FKART	Billing Type	FKART	CHAR	4	TVFK		FKART
WAERS	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
PERIV	Fiscal Year Variant	PERIV	CHAR	2	T009		PERIV
PERFLAG2	Alternative period type indicator	PERFLAG2	CHAR	1			PERFLAG2
FRWAE	Foreign currency key	FRWAE	CUKY	5	TCURC		WAERS
KURSF	Exchange rate	KURSF	DEC	9(5)		EXCRT	KURSF
KURST	Exchange Rate Type	KURST	CHAR	4	TCURV		KURST	KUT
ABLEDA	Date for derivation of characteristics in planning	ABLEITDAT	DATS	8			DATUM
KAUFN	Sales Order Number	KDAUF	CHAR	10	VBUK	ALPHA	VBELN	AUN
KDPOS	Item Number in Sales Order	KDPOS	NUMC	6			NUM06	KPO
RKAUFNR	Order Number	AUFNR	CHAR	12	AUFK	ALPHA	AUFNR	ANR
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
S_BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
KOKRS	Controlling Area	KOKRS	CHAR	4	TKA01		CACCD	CAC
WERKS	Plant	WERKS_D	CHAR	4	T001W		WERKS	WRK	H_T001W_C
GSBER	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
S_GSBER	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
VKORG	Sales Organization	VKORG	CHAR	4	TVKO		VKORG	VKO	C_VKORG
VTWEG	Distribution Channel	VTWEG	CHAR	2	TVTW		VTWEG	VTW	C_VTWEG
SPART	Division	SPART	CHAR	2	TSPA		SPART	SPA	C_SPART
KSTRG	Cost Object	KSTRG	CHAR	12	CKPH		KSTRG	KTR
PSPNR	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR	NUMC	8	PRPS	KONPR	PS_POSNR
COPA_POSID	Work Breakdown Structure Element (WBS Element)	PS_POSID	CHAR	24		PROJN	PS_POSID	PRO
COPA_CRMID	CRM Marketing Element	RKECRMELEM_POSID	CHAR	24		ABPSN	PS_POSID	PRO
PA_TYPE	Type of CO-PA as Basis for Determining Tracing Factor	RKE_PATYP1	NUMC	1			RKE_PATYP2
LEDNR	Ledger for Controlling objects	LEDNR	CHAR	2		ALPHA	LEDNR
OBJNR	Object number	J_OBJNR	CHAR	22	ONR00		J_OBJNR	ONR
WRTTP	Value Type	CO_WRTTP	CHAR	2			CO_WRTTP
VERSN	Sender version	VERSN_S	CHAR	3	TKA09	ALPHA	COVERSI	KVS
KSTAR	Cost Element	KSTAR	CHAR	10	Assigned to domain	ALPHA	KSTAR	KAT
VRGNG	CO Business Transaction	CO_VORGANG	CHAR	4	TJ01		J_VORGANG
PAROB	Partner Object	PAROB	CHAR	22	ONR00		J_OBJNR
USPOB	Source Object (Cost Center/Activity Type)	USPOB	CHAR	22	ONR00		J_OBJNR
BEKNZ	Debit/credit indicator	BEKNZ	CHAR	1		BEKNZ	BEKNZ
TWAER	Transaction Currency	TWAER	CUKY	5	TCURC		WAERS	FWS
BUPER	Posting period	POPER	NUMC	3			POPER	POPR
KOSTL	Cost Center	KOSTL	CHAR	10	CSKS	ALPHA	KOSTL	KOS
LSTAR	Activity Type	LSTAR	CHAR	6	CSLA		LSTAR	LAR	LART_EMPTY
PRZNR	Business Process	CO_PRZNR	CHAR	12	CBPR	ALPHA	CO_PRZNR	KWP
OWAER	Currency Key	OWAER	CUKY	5	TCURC		WAERS	OWS
KWAER	Controlling area currency	KWAER	CUKY	5	TCURC		WAERS	KWS
MEINH	Unit of Measure	CO_MEINH	UNIT	3	T006	CUNIT	MEINS
KTOPL	Chart of Accounts	KTOPL	CHAR	4	T004		KTOPL	KPL	C_KTOPL
LMONA	Fiscal Year Variant	PERIV	CHAR	2	T009		PERIV
INUMKR	Internal number range	INUMKR	CHAR	2			CHAR2
SETKIND	Type of set	SETKIND	CHAR	1			SETKIND
BUDAT	Posting Date	DAERF	DATS	8			DATUM
VNAME	Joint Venture	JV_NAME	CHAR	6	T8JV	ALPHA	JV_NAME	JVV
RECID	Recovery Indicator	JV_RECIND	CHAR	2	T8JJ	ALPHA	JV_RECIND
ETYPE	Equity type	JV_ETYPE	CHAR	3	T8JE	ALPHA	JV_ETYPE
PRCTR	Profit Center	PRCTR	CHAR	10	CEPC	ALPHA	PRCTR	PRC	PRCTR_EMPTY
S_PRCTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
PPRCTR	Partner Profit Center	PPRCTR	CHAR	10	CEPC	ALPHA	PRCTR	PPC
AUTYP	Order category	AUFTYP	NUMC	2			AUFTYP
SCOPE	Object Class	SCOPE_CV	CHAR	2		SCOPE	SCOPE_CV	PCO
LOGSYSTEM	Logical System	LOGSYSTEM	CHAR	10	Assigned to domain	ALPHA	LOGSYS
TARKZ	Price Indicator: Calculate Allocation Price	TARKZ	CHAR	3	TKA10	ALPHA	TARKZ
VKSTA	Allocation Cost Element	VKSTA	CHAR	10	CSKA	ALPHA	KSTAR
YRATE	Price Calculation with Period-Based Average Prices	CO_YRATE	CHAR	1			XFELD
FIXVO	Predistribution of fixed costs for acty type/bus. process	CO_FIXVO	CHAR	1			XFELD
TARKZ_I	Indicator: Actual Allocation Price	CO_TARKZ_I	CHAR	3	TKA10	ALPHA	TARKZ
MANIST	Indicator: Confirm quantity manually in actual	CO_MANIST	CHAR	1			XFELD
AUSFK	Output factor	AUSFK	DEC	5(2)			AUSFK
AUSEH	Output Unit	AUSEH	UNIT	3	Assigned to domain	CUNIT	MEINS
LEINH	Activity Unit	LEINH	UNIT	3	T006	CUNIT	MEINS
ERZUO	PA Transfer structure assignment	ERZUO	CHAR	3	Assigned to domain	ALPHA	ERZUO
KDGRP	Customer group	KDGRP	CHAR	2	T151		KDGRP	VKD
BRSCH	Industry key	BRSCH	CHAR	4	T016		BRSCH
LAND1	Country Key	LAND1_GP	CHAR	3	T005		LAND1		C_LAND1
HIE01	Customer hierarchy Level 1	HIEZU01	CHAR	10	KNA1	ALPHA	KUNNR
HIE02	Customer hierarchy Level 2	HIEZU02	CHAR	10	KNA1	ALPHA	KUNNR
HIE03	Customer hierarchy Level 3	HIEZU03	CHAR	10	KNA1	ALPHA	KUNNR
WW010	ww010	RKEG_WW010	CHAR	6	T2541		RKEG_WW010
WW020	ww020	RKEG_WW020	CHAR	6	T2523		RKEG_WW020
WW030	ww030	RKEG_WW030	CHAR	6	T2540		RKEG_WW030
WW040	ww040	RKEG_WW040	CHAR	6	T2539		RKEG_WW040
WW050	WW050	RKEG_WW050	CHAR	6	T2537		RKEG_WW050
WW060	WW060	RKEG_WW060	CHAR	6	T2536		RKEG_WW060
WW070		RKEG_WW070	CHAR	6	T2535		RKEG_WW070
WW080		RKEG_WW080	CHAR	6	T2534		RKEG_WW080
WW090		RKEG_WW090	CHAR	6	T2524		RKEG_WW090
WW100		RKEG_WW100	CHAR	6	T2533		RKEG_WW100
WW110		RKEG_WW110	CHAR	6	T2532		RKEG_WW110
WW120		RKEG_WW120	CHAR	6	T2531		RKEG_WW120
WW130		RKEG_WW130	CHAR	6	T2530		RKEG_WW130
WW140		RKEG_WW140	CHAR	6	T2529		RKEG_WW140
WW150		RKEG_WW150	CHAR	6	T2528		RKEG_WW150
WW160		RKEG_WW160	CHAR	6	T2527		RKEG_WW160
WW170		RKEG_WW170	CHAR	10	T2526		RKEG_WW170
WW180		RKEG_WW180	CHAR	6	T2525		RKEG_WW180
WW190		RKEG_WW190	CHAR	6	T2542		RKEG_WW190

Key field

Non-key field

< CE7IDEA - CE7IDES - >

How do I retrieve data from SAP structure CE7IDEB using ABAP code?

As CE7IDEB is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CE7IDEB as there is no data to select.

How to access SAP table CE7IDEB

Within an ECC or HANA version of SAP you can also view further information about CE7IDEB and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).