CE1IDEB SAP () Table details

Dictionary Type: Table
Description:




ABAP Code to SELECT data from CE1IDEB
Related tables to CE1IDEB
Access table CE1IDEB




Table field list including key, data, relationships and ABAP select examples

CE1IDEB is a standard SAP Table which is used to store data and is available within R/3 SAP systems depending on the version and release level.

The CE1IDEB 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), VRGAR (Record Type), VERSI (Plan version (CO-PA)), PERIO (Period/year).. 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: Not classified


SAP CE1IDEB 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
MANDTClient MANDTCLNT3T000MANDT
PALEDGERCurrency type for an operating concern LEDBOCHAR2TKELLEDBOLEDBO
VRGARRecord Type RKE_VRGARCHAR1TVGAVRGARVGA
VERSIPlan version (CO-PA) RKEVERSICHAR3TKVSALPHACOVERSIPVS
PERIOPeriod/year JAHRPERNUMC7PERI7JAHRPER
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PASUBNRProfitability segment changes (CO-PA) RKESUBNRNUMC4RKESUBNR
BELNRDocument number of line item in Profitability Analysis RKE_BELNRCHAR10ALPHABELNR
POSNRItem no. of CO-PA line item RKE_POSNRCHAR6RKE_POSNR
HZDATDate on Which Record Was Created ERDATDATS8DATUM
USNAMCreated by ERFASSERCHAR12USNAM
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
PERDEPeriod PERIODENUMC3NUM3GFP
WADATGoods Issue Date WADATDATS8DATUM
FADATInvoice date (date created) FADATDATS8DATUM
BUDATPosting Date DAERFDATS8DATUM
ALTPERIOPeriod/year in alternative period type JAHRPERALTNUMC7PERI7JAHRPER
PAPAOBJNRPartner profitability segment number (CO-PA) RKEPOBJNUMC10RKEOBJNR
PAPASUBNRChanges to partner profitability segments (CO-PA) RKEPSUBNRNUMC4RKESUBNR
KNDNRCustomer KUNDE_PACHAR10KNA1ALPHAKUNNRVAG
ARTNRProduct number ARTNRCHAR18MARAMATN1MATNRMAT
FKARTBilling Type FKARTCHAR4TVFKFKART
FRWAEForeign currency key FRWAECUKY5TCURCWAERS
KURSFExchange rate KURSFDEC9(5) EXCRTKURSF
KURSBKExchange rate for op.concern currency -> Co.code currency KURSBKDEC9(5) KURSF
KURSKZExchange rate op.concern currency -> group currency KURSKZDEC9(5) KURSF
REC_WAERSCurrency of the data record RKE_REC_WAERSCUKY5TCURCWAERS
KAUFNSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
RKAUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
SKOSTSender cost center SKOSTCHAR10CSKSALPHAKOSTLKSK
PRZNRSender Business Process SEPRZCHAR12CBPRALPHACO_PRZNRSEP
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
HRKFTOrigins (CO-PA) RKEHERKCHAR4RKEHERK
PLIKZPlan/Actual Indicator PLIKZCHAR1PLIKZ
KSTARCost Element KSTARCHAR10CSKAALPHAKSTARKAT
PSPNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8PRPSKONPRPS_POSNR
KSTRGCost Object KSTRGCHAR12CKPHKSTRGKTR
RBELNReference document number for CO-PA line item RKERFBELNRCHAR10ALPHABELNR
RPOSNItem number from reference document (CO-PA) RKERFPOSNRCHAR6RKE_POSNR
STO_BELNRCanceled document RKE_STO_BELNRCHAR10ALPHABELNR
STO_POSNRCanceled document item RKE_STO_POSNRCHAR6RKE_POSNR
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
PPRCTRPartner Profit Center PPRCTRCHAR10CEPCALPHAPRCTRPPC
RKESTATUUpdate status for CO-PA line items RKESTATUCHAR10RKESTATU
TIMESTMPTime created (Greenwich Meantime) RKE_HZSTMPDEC16RKE_TSTMP
COPA_AWTYPReference Transaction AWTYPCHAR5Assigned to domainAWTYP
COPA_AWORGReference Organizational Units AWORGCHAR10AWORG
COPA_BWZPTCO-PA Point of valuation BWZPTCHAR1BWZPT
COPA_AWSYSLogical system of source document AWSYSCHAR10TBDLSALPHALOGSYS
KDGRPCustomer group KDGRPCHAR2T151KDGRPVKD
BRSCHIndustry key BRSCHCHAR4T016BRSCH
LAND1Country Key LAND1_GPCHAR3T005LAND1C_LAND1
HIE01Customer hierarchy Level 1 HIEZU01CHAR10KNA1ALPHAKUNNR
HIE02Customer hierarchy Level 2 HIEZU02CHAR10KNA1ALPHAKUNNR
HIE03Customer hierarchy Level 3 HIEZU03CHAR10KNA1ALPHAKUNNR
WW010ww010 RKEG_WW010CHAR6T2541RKEG_WW010
WW020ww020 RKEG_WW020CHAR6T2523RKEG_WW020
WW030ww030 RKEG_WW030CHAR6T2540RKEG_WW030
WW040ww040 RKEG_WW040CHAR6T2539RKEG_WW040
WW050WW050 RKEG_WW050CHAR6T2537RKEG_WW050
WW060WW060 RKEG_WW060CHAR6T2536RKEG_WW060
WW070 RKEG_WW070CHAR6T2535RKEG_WW070
WW080 RKEG_WW080CHAR6T2534RKEG_WW080
WW090 RKEG_WW090CHAR6T2524RKEG_WW090
WW100 RKEG_WW100CHAR6T2533RKEG_WW100
WW110 RKEG_WW110CHAR6T2532RKEG_WW110
WW120 RKEG_WW120CHAR6T2531RKEG_WW120
WW130 RKEG_WW130CHAR6T2530RKEG_WW130
WW140 RKEG_WW140CHAR6T2529RKEG_WW140
WW150 RKEG_WW150CHAR6T2528RKEG_WW150
WW160 RKEG_WW160CHAR6T2527RKEG_WW160
WW170 RKEG_WW170CHAR10T2526RKEG_WW170
WW180 RKEG_WW180CHAR6T2525RKEG_WW180
WW190 RKEG_WW190CHAR6T2542RKEG_WW190
PROVVExt. Commission RKE2_PROVVCURR15(2) WERTV8
VVB01 RKE2_VVB01CURR15(2) WERTV8
VVB02 RKE2_VVB02CURR15(2) WERTV8
VVB03 RKE2_VVB03CURR15(2) WERTV8
VVB04 RKE2_VVB04CURR15(2) WERTV8
VVB05 RKE2_VVB05CURR15(2) WERTV8
VVB06 RKE2_VVB06CURR15(2) WERTV8
VVB07 RKE2_VVB07CURR15(2) WERTV8
VVB08 RKE2_VVB08CURR15(2) WERTV8
VVB09 RKE2_VVB09CURR15(2) WERTV8
VVB10 RKE2_VVB10CURR15(2) WERTV8
VVB11 RKE2_VVB11CURR15(2) WERTV8
VVB12 RKE2_VVB12CURR15(2) WERTV8
VVB13 RKE2_VVB13CURR15(2) WERTV8
VVB14 RKE2_VVB14CURR15(2) WERTV8
VVB15 RKE2_VVB15CURR15(2) WERTV8
VVB16 RKE2_VVB16CURR15(2) WERTV8

Key field Non-key field



How do I retrieve data from SAP table CE1IDEB using ABAP code

The following ABAP code Example will allow you to do a basic selection on CE1IDEB to SELECT all data from the table
DATA: WA_CE1IDEB TYPE CE1IDEB.

SELECT SINGLE *
FROM CE1IDEB
INTO CORRESPONDING FIELDS OF WA_CE1IDEB
WHERE...

How to access SAP table CE1IDEB

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!