CE1INT1 SAP () Table details

Dictionary Type: Table
Description:




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




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

CE1INT1 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 CE1INT1 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 CE1INT1 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
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
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
VVOQTOrdered quantity RKE2_VVOQTQUAN15(3) MENGV15_3
VVIQTInvoiced quantity RKE2_VVIQTQUAN15(3) MENGV15_3
VVSQTInput Quan. Variance RKE2_VVSQTQUAN15(3) MENGV15_3
VVGRWGross weight RKE2_VVGRWQUAN15(3) MENGV15_3
VV010Revenue RKE2_VV010CURR15(2) WERTV8
VV020Quantity discount RKE2_VV020CURR15(2) WERTV8
VV030Customer discount RKE2_VV030CURR15(2) WERTV8
VV040Material discount RKE2_VV040CURR15(2) WERTV8
VV060Other rebates RKE2_VV060CURR15(2) WERTV8
VV070Accrued Sales deduc. RKE2_VV070CURR15(2) WERTV8
VV090Accrued bonus RKE2_VV090CURR15(2) WERTV8
VV100Outgoing freight RKE2_VV100CURR15(2) WERTV8
VV110Accrued freight RKE2_VV110CURR15(2) WERTV8
VV120Dispatch packaging RKE2_VV120CURR15(2) WERTV8
VV130Internal sales Comm. RKE2_VV130CURR15(2) WERTV8
VV140Cost of goods sold RKE2_VV140CURR15(2) WERTV8
VV150Material Input RKE2_VV150CURR15(2) WERTV8
VV160Trading Goods RKE2_VV160CURR15(2) WERTV8
VV170Production Labor fix RKE2_VV170CURR15(2) WERTV8
VV180Production Labor var RKE2_VV180CURR15(2) WERTV8
VV190Production Setup RKE2_VV190CURR15(2) WERTV8
VV200Produc. machine fix RKE2_VV200CURR15(2) WERTV8
VV210Produc. machine var RKE2_VV210CURR15(2) WERTV8
VV220Produc. Burn-in fix RKE2_VV220CURR15(2) WERTV8
VV230Produc. Burn-in var RKE2_VV230CURR15(2) WERTV8
VV240Outside Processing RKE2_VV240CURR15(2) WERTV8
VV250Material Overhead RKE2_VV250CURR15(2) WERTV8
VV260Administr. Overhead RKE2_VV260CURR15(2) WERTV8
VV270Sales Overhead RKE2_VV270CURR15(2) WERTV8
VV280Miscellaneous Costs RKE2_VV280CURR15(2) WERTV8
VV290Price variance RKE2_VV290CURR15(2) WERTV8
VV300Quant. Variance Mat. RKE2_VV300CURR15(2) WERTV8
VV310Quant. Variance Prod RKE2_VV310CURR15(2) WERTV8
VV320Lot-size Variance RKE2_VV320CURR15(2) WERTV8
VV330Usage variance RKE2_VV330CURR15(2) WERTV8
VV340Input Variances RKE2_VV340CURR15(2) WERTV8
VV350Scrap RKE2_VV350CURR15(2) WERTV8
VV360Remaining Variances RKE2_VV360CURR15(2) WERTV8
VV370Gen.Admin. costs CCA RKE2_VV370CURR15(2) WERTV8
VV380General Market.costs RKE2_VV380CURR15(2) WERTV8
VV390Distribution costs RKE2_VV390CURR15(2) WERTV8
VV400Production costs RKE2_VV400CURR15(2) WERTV8
VV410Marketing activities RKE2_VV410CURR15(2) WERTV8
VV420Research & Develop. RKE2_VV420CURR15(2) WERTV8
VV430Reserv.f.imminent lo RKE2_VV430CURR15(2) WERTV8
VV440Corr:Material Input RKE2_VV440CURR15(2) WERTV8
VV450Corr:Manuf.Costs fix RKE2_VV450CURR15(2) WERTV8
VV460Corr:Manuf.Costs var RKE2_VV460CURR15(2) WERTV8
VV470Corr:Overhead Costs RKE2_VV470CURR15(2) WERTV8
VV480Maintenance RKE2_VV480CURR15(2) WERTV8
VV145COGS alternative RKE2_VV145CURR15(2) WERTV8
VV075Actual Sales deduc. RKE2_VV075CURR15(2) WERTV8
VV500Process 'Production' RKE2_VV500CURR15(2) WERTV8
VV510Process 'Procurement' RKE2_VV510CURR15(2) WERTV8
VV520Process 'Sales' RKE2_VV520CURR15(2) WERTV8
VV530Process 'Administration' RKE2_VV530CURR15(2) WERTV8
VV550Number of sales order items RKE2_VV550QUAN15(3) MENGV15_3
VV560Number of payment problems RKE2_VV560QUAN15(3) MENGV15_3
VV570Number of purchase orders for sales order RKE2_VV570QUAN15(3) MENGV15_3
VV580Input Quan. Variance RKE2_VV580QUAN15(3) MENGV15_3
VV495Number of employees RKE2_VV495QUAN15(3) MENGV15_3
VVSTUStandard Unit of M. RKE2_VVSTUQUAN15(3) MENGV15_3
VV155Grace costs RKE2_VV155CURR15(2) WERTV8
VV365Price differences RKE2_VV365CURR15(2) WERTV8
VV364Mixed-price variance RKE2_VV364CURR15(2) WERTV8
VVK15Group: Material RKE2_VVK15CURR15(2) WERTV8
VVK20Group: Material overhead costs RKE2_VVK20CURR15(2) WERTV8
VVK25Group: Production RKE2_VVK25CURR15(2) WERTV8
VVK30Group: Misc. RKE2_VVK30CURR15(2) WERTV8
VVK10Group price RKE2_VVK10CURR15(2) WERTV8
VVO10PCA: Int. revenues RKE2_VVO10CURR15(2) WERTV8
VVO20PCA: Int. costs RKE2_VVO20CURR15(2) WERTV8
VVOQUPCA: Delivery quantity RKE2_VVOQUQUAN15(3) MENGV15_3
VV366Other Actual Costs RKE2_VV366CURR15(2) WERTV8
VV367Sales and Administration Costs - Actual RKE2_VV367CURR15(2) WERTV8
VV368Process 'Production' Actual RKE2_VV368CURR15(2) WERTV8
VV151Actual Mat. Input RKE2_VV151CURR15(2) WERTV8
VV171Act. Fxd Prod. Costs RKE2_VV171CURR15(2) WERTV8
VV181Actual Variable Production Costs RKE2_VV181CURR15(2) WERTV8
VV191Actual Setup Costs RKE2_VV191CURR15(2) WERTV8
VV201Actual Fixed Machine Hours RKE2_VV201CURR15(2) WERTV8
VV211Actual Variable Machine Hours RKE2_VV211CURR15(2) WERTV8
VV251Actual Material Overhead Costs RKE2_VV251CURR15(2) WERTV8
VV810No. of Inquiries RKE2_VV810QUAN15(3) MENGV15_3
VV820No. of Complaints RKE2_VV820QUAN15(3) MENGV15_3
VV830Cost of Inquiries RKE2_VV830CURR15(2) WERTV8
VV840Cost of Complaints RKE2_VV840CURR15(2) WERTV8
VV095oth. sales deduct. RKE2_VV095CURR15(2) WERTV8
VV713Advertising RKE2_VV713CURR15(2) WERTV8
VV900Revenue fee RKE2_VV900CURR15(2) WERTV8
VV910Revenue from Expenses/Travel Costs RKE2_VV910CURR15(2) WERTV8
VV915Revenues from External Activities RKE2_VV915CURR15(2) WERTV8
VV920Sales Deductions RKE2_VV920CURR15(2) WERTV8
VV930Number of Labor Hours RKE2_VV930QUAN15(3) MENGV15_3
VV931Number of Hours Billed RKE2_VV931QUAN15(3) MENGV15_3
VV940Cost of Labor Hours RKE2_VV940CURR15(2) WERTV8
VV950Travel expenses RKE2_VV950CURR15(2) WERTV8
VV960Other expenses RKE2_VV960CURR15(2) WERTV8
VV970Costs from External Activities RKE2_VV970CURR15(2) WERTV8
VV999X_Technical RKE2_VV999CURR15(2) WERTV8

Key field Non-key field



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

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

SELECT SINGLE *
FROM CE1INT1
INTO CORRESPONDING FIELDS OF WA_CE1INT1
WHERE...

How to access SAP table CE1INT1

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