CE2IDES SAP () Table details

Dictionary Type: Table
Description:




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




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

CE2IDES 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 CE2IDES 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)), PAOBJNR (Profitability Segment Number (CO-PA)).. 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 CE2IDES 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
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PASUBNRProfitability segment changes (CO-PA) RKESUBNRNUMC4RKESUBNR
BELNRDocument number of line item in Profitability Analysis RKE_BELNRCHAR10ALPHABELNR
PERBLFiscal year/period block JAHRPERBLNUMC7PERI7JAHRPER
HZDATDate on Which Record Was Created ERDATDATS8DATUM
USNAMCreated by ERFASSERCHAR12USNAM
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
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
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
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
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
PPRCTRPartner Profit Center PPRCTRCHAR10CEPCALPHAPRCTRPPC
RKESTATUUpdate status for CO-PA line items RKESTATUCHAR10RKESTATU
TIMESTMPTime created (Greenwich Meantime) RKE_HZSTMPDEC16RKE_TSTMP
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
MVGR1Material group 1 MVGR1CHAR3TVM1MVGR1
WWPH1Prod.hier.1 bef. 4.5 RKEG_WWPH1CHAR5T2508RKEG_WWPH1
WWPH2Prod.hier.2 bef. 4.5 RKEG_WWPH2CHAR10T2509RKEG_WWPH2
WWPH3Prod.hier.3 bef. 4.5 RKEG_WWPH3CHAR18T2510RKEG_WWPH3
WWPRCProduct category RKEG_WWPRCCHAR8T2520RKEG_WWPRC
WWSOPProd.group for SOP RKEG_WWSOPCHAR18T2511RKEG_WWSOP
WWSBUStrategic Bus.Unit RKEG_WWSBUCHAR8T2515RKEG_WWSBU
KDGRPCustomer group KDGRPCHAR2T151KDGRPVKD
KUKLACustomer classification KUKLACHAR2TKUKLKUKLA
BZIRKSales district BZIRKCHAR6T171BZIRKBZI
BRSCHIndustry key BRSCHCHAR4T016BRSCH
WWREGRegion before 4.5 RKEG_WWREGCHAR6T2516RKEG_WWREG
LAND1Country Key LAND1_GPCHAR3T005LAND1C_LAND1
KUNWEShip-to party KUNWECHAR10KNA1ALPHAKUNNR
WWCSTCountry Ship-to RKEG_WWCSTCHAR3T2517RKEG_WWCST
WWRSTIntern.Region Ship-t RKEG_WWRSTCHAR3T2518RKEG_WWRST
HIE01Customer hierarchy Level 1 HIEZU01CHAR10KNA1ALPHAKUNNR
HIE02Customer hierarchy Level 2 HIEZU02CHAR10KNA1ALPHAKUNNR
HIE03Customer hierarchy Level 3 HIEZU03CHAR10KNA1ALPHAKUNNR
VRTNRSales employee VRTNRNUMC8PERNRPREMV
VKBURSales Office VKBURCHAR4TVBURVKBURVKB
VKGRPSales Group VKGRPCHAR3TVKGRVKGRPVKG
WWICIIntercompany ind. RKEG_WWICICHAR1T2519RKEG_WWICI
AUGRUOrder reason (reason for the business transaction) AUGRUCHAR3TVAUAUGRU
WWPROPromotion KNUMA_PICHAR10KONAALPHAKNUMAVPIVMBO
WWSDLSales deal KNUMA_AGCHAR10KONAALPHAKNUMAVK1VMBO
PAPH1Prod.hierarchy01-1 RKEG_PAPH1CHAR5RKEG_PAPH1
PAPH2Prod.hierarchy01-2 RKEG_PAPH2CHAR10RKEG_PAPH2
PAPH3Prod.hierarchy01-3 RKEG_PAPH3CHAR18RKEG_PAPH3
PAREGCO-PA special characteristic: (Land, Region) RKE_PAREGCHAR6RKE_PAREG
SORHISTSales Order History RKE_SORHICHAR1RKE_SORHI
WWMEAMeasurements RKEG_WWMEACHAR2T2521RKEG_WWMEA
WWQUAQuality RKEG_WWQUACHAR5T2522RKEG_WWQUA
WWSURUser Interface RKEG_WWSURCHAR2T2501RKEG_WWSUR
REGIOSTATE (State, Province, County) REGIOCHAR3T005SREGIO
CRMELEMCRM Marketing Element RKECRMELEMNUMC8PRPSABPSPPS_POSNR
CRMCSTYCRM Cost Element RKECRMCSTYCHAR10CSKAALPHAKSTAR
ROUTERoute ROUTECHAR6TVROROUTE
VVOQT_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VVIQT_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VVSQT_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VVGRW_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VV550_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VV560_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VV570_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VV580_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VV495_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VVSTU_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VVOQU_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VV810_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VV820_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VV930_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VV931_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VVSV_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VVOQT001Ordered quantity RKE2_VVOQTQUAN15(3) MENGV15_3
VVIQT001Invoiced quantity RKE2_VVIQTQUAN15(3) MENGV15_3
VVSQT001Input Quan. Variance RKE2_VVSQTQUAN15(3) MENGV15_3
VVGRW001Gross weight RKE2_VVGRWQUAN15(3) MENGV15_3
VV010001Revenue RKE2_VV010CURR15(2) WERTV8
VV020001Quantity discount RKE2_VV020CURR15(2) WERTV8
VV030001Customer discount RKE2_VV030CURR15(2) WERTV8
VV040001Material discount RKE2_VV040CURR15(2) WERTV8
VV060001Other rebates RKE2_VV060CURR15(2) WERTV8
VV070001Accrued Sales deduc. RKE2_VV070CURR15(2) WERTV8
VV090001Accrued bonus RKE2_VV090CURR15(2) WERTV8
VV100001Outgoing freight RKE2_VV100CURR15(2) WERTV8
VV110001Accrued freight RKE2_VV110CURR15(2) WERTV8
VV120001Dispatch packaging RKE2_VV120CURR15(2) WERTV8
VV130001Internal sales Comm. RKE2_VV130CURR15(2) WERTV8
VV140001Cost of goods sold RKE2_VV140CURR15(2) WERTV8
VV150001Material Input RKE2_VV150CURR15(2) WERTV8
VV160001Trading Goods RKE2_VV160CURR15(2) WERTV8
VV170001Production Labor fix RKE2_VV170CURR15(2) WERTV8
VV180001Production Labor var RKE2_VV180CURR15(2) WERTV8
VV190001Production Setup RKE2_VV190CURR15(2) WERTV8
VV200001Produc. machine fix RKE2_VV200CURR15(2) WERTV8
VV210001Produc. machine var RKE2_VV210CURR15(2) WERTV8
VV220001Produc. Burn-in fix RKE2_VV220CURR15(2) WERTV8
VV230001Produc. Burn-in var RKE2_VV230CURR15(2) WERTV8
VV240001Outside Processing RKE2_VV240CURR15(2) WERTV8
VV250001Material Overhead RKE2_VV250CURR15(2) WERTV8
VV260001Administr. Overhead RKE2_VV260CURR15(2) WERTV8
VV270001Sales Overhead RKE2_VV270CURR15(2) WERTV8
VV280001Miscellaneous Costs RKE2_VV280CURR15(2) WERTV8
VV290001Price variance RKE2_VV290CURR15(2) WERTV8
VV300001Quant. Variance Mat. RKE2_VV300CURR15(2) WERTV8
VV310001Quant. Variance Prod RKE2_VV310CURR15(2) WERTV8
VV320001Lot-size Variance RKE2_VV320CURR15(2) WERTV8
VV330001Usage variance RKE2_VV330CURR15(2) WERTV8
VV340001Input Variances RKE2_VV340CURR15(2) WERTV8
VV350001Scrap RKE2_VV350CURR15(2) WERTV8
VV360001Remaining Variances RKE2_VV360CURR15(2) WERTV8
VV370001Gen.Admin. costs CCA RKE2_VV370CURR15(2) WERTV8
VV380001General Market.costs RKE2_VV380CURR15(2) WERTV8
VV390001Distribution costs RKE2_VV390CURR15(2) WERTV8
VV400001Production costs RKE2_VV400CURR15(2) WERTV8
VV410001Marketing activities RKE2_VV410CURR15(2) WERTV8
VV420001Research & Develop. RKE2_VV420CURR15(2) WERTV8
VV430001Reserv.f.imminent lo RKE2_VV430CURR15(2) WERTV8
VV440001Corr:Material Input RKE2_VV440CURR15(2) WERTV8
VV450001Corr:Manuf.Costs fix RKE2_VV450CURR15(2) WERTV8
VV460001Corr:Manuf.Costs var RKE2_VV460CURR15(2) WERTV8
VV470001Corr:Overhead Costs RKE2_VV470CURR15(2) WERTV8
VV480001Maintenance RKE2_VV480CURR15(2) WERTV8
VV145001COGS alternative RKE2_VV145CURR15(2) WERTV8
VV075001Actual Sales deduc. RKE2_VV075CURR15(2) WERTV8
VV500001Process 'Production' RKE2_VV500CURR15(2) WERTV8
VV510001Process 'Procurement' RKE2_VV510CURR15(2) WERTV8
VV520001Process 'Sales' RKE2_VV520CURR15(2) WERTV8
VV530001Process 'Administration' RKE2_VV530CURR15(2) WERTV8
VV550001Number of sales order items RKE2_VV550QUAN15(3) MENGV15_3
VV560001Number of payment problems RKE2_VV560QUAN15(3) MENGV15_3
VV570001Number of purchase orders for sales order RKE2_VV570QUAN15(3) MENGV15_3
VV580001Input Quan. Variance RKE2_VV580QUAN15(3) MENGV15_3
VV495001Number of employees RKE2_VV495QUAN15(3) MENGV15_3
VVSTU001Standard Unit of M. RKE2_VVSTUQUAN15(3) MENGV15_3
VV155001Grace costs RKE2_VV155CURR15(2) WERTV8
VV365001Price differences RKE2_VV365CURR15(2) WERTV8
VV364001Mixed-price variance RKE2_VV364CURR15(2) WERTV8
VVK15001Group: Material RKE2_VVK15CURR15(2) WERTV8
VVK20001Group: Material overhead costs RKE2_VVK20CURR15(2) WERTV8
VVK25001Group: Production RKE2_VVK25CURR15(2) WERTV8
VVK30001Group: Misc. RKE2_VVK30CURR15(2) WERTV8
VVK10001Group price RKE2_VVK10CURR15(2) WERTV8
VVO10001PCA: Int. revenues RKE2_VVO10CURR15(2) WERTV8
VVO20001PCA: Int. costs RKE2_VVO20CURR15(2) WERTV8
VVOQU001PCA: Delivery quantity RKE2_VVOQUQUAN15(3) MENGV15_3
VV366001Other Actual Costs RKE2_VV366CURR15(2) WERTV8
VV367001Sales and Administration Costs - Actual RKE2_VV367CURR15(2) WERTV8
VV368001Process 'Production' Actual RKE2_VV368CURR15(2) WERTV8
VV151001Actual Mat. Input RKE2_VV151CURR15(2) WERTV8
VV171001Act. Fxd Prod. Costs RKE2_VV171CURR15(2) WERTV8
VV181001Actual Variable Production Costs RKE2_VV181CURR15(2) WERTV8
VV191001Actual Setup Costs RKE2_VV191CURR15(2) WERTV8
VV201001Actual Fixed Machine Hours RKE2_VV201CURR15(2) WERTV8
VV211001Actual Variable Machine Hours RKE2_VV211CURR15(2) WERTV8
VV251001Actual Material Overhead Costs RKE2_VV251CURR15(2) WERTV8
VV810001No. of Inquiries RKE2_VV810QUAN15(3) MENGV15_3
VV820001No. of Complaints RKE2_VV820QUAN15(3) MENGV15_3
VV830001Cost of Inquiries RKE2_VV830CURR15(2) WERTV8
VV840001Cost of Complaints RKE2_VV840CURR15(2) WERTV8
VV095001oth. sales deduct. RKE2_VV095CURR15(2) WERTV8
VV713001Advertising RKE2_VV713CURR15(2) WERTV8
VV900001Revenue fee RKE2_VV900CURR15(2) WERTV8
VV910001Revenue from Expenses/Travel Costs RKE2_VV910CURR15(2) WERTV8
VV915001Revenues from External Activities RKE2_VV915CURR15(2) WERTV8
VV920001Sales Deductions RKE2_VV920CURR15(2) WERTV8
VV930001Number of Labor Hours RKE2_VV930QUAN15(3) MENGV15_3
VV931001Number of Hours Billed RKE2_VV931QUAN15(3) MENGV15_3
VV940001Cost of Labor Hours RKE2_VV940CURR15(2) WERTV8
VV950001Travel expenses RKE2_VV950CURR15(2) WERTV8
VV960001Other expenses RKE2_VV960CURR15(2) WERTV8
VV970001Costs from External Activities RKE2_VV970CURR15(2) WERTV8
VV999001X_Technical RKE2_VV999CURR15(2) WERTV8
VVADV001Advert. Costs SEM215 RKE2_VVADVCURR15(2) WERTV8
VVCGS001COGS in SEM215 RKE2_VVCGSCURR15(2) WERTV8
VVDEP001Deprec. Costs SEM215 RKE2_VVDEPCURR15(2) WERTV8
VVENG001Energy Costs SEM215 RKE2_VVENGCURR15(2) WERTV8
VVNR001NetRevenue in SEM215 RKE2_VVNRCURR15(2) WERTV8
VVPSC001PersonnelCost SEM215 RKE2_VVPSCCURR15(2) WERTV8
VVREN001Rent Costs SEM215 RKE2_VVRENCURR15(2) WERTV8
VVREV001Revenue SEM215 RKE2_VVREVCURR15(2) WERTV8
VVSD001SalesDiscount SEM215 RKE2_VVSDCURR15(2) WERTV8
VVCM2001Contr.Margin2 SEM215 RKE2_VVCM2CURR15(2) WERTV8
VVSV001Sales Volume SEM215 RKE2_VVSVQUAN15(3) MENGV15_3
VVLS1001Costs pre-leg RKE2_VVLS1CURR15(2) WERTV8
VVLS2001Costs main-leg RKE2_VVLS2CURR15(2) WERTV8
VVLS3001Costs sub-leg RKE2_VVLS3CURR15(2) WERTV8

Key field Non-key field



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

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

SELECT SINGLE *
FROM CE2IDES
INTO CORRESPONDING FIELDS OF WA_CE2IDES
WHERE...

How to access SAP table CE2IDES

Within an ECC or HANA version of SAP you can also view further information about CE2IDES 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!