SAP CE4EMPR_ACCT Table data and field list

CE4EMPR_ACCT is a standard SAP Table which is used to store data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CE4EMPR_ACCT table consists of various fields, each holding specific information or linking keys about data available in SAP. These include AKTBO (Current profitability segment (CO-PA)), PAOBJNR (Profitability Segment Number (CO-PA)), PASUBNR (Profitability segment changes (CO-PA)), BISDAT (Valid to)... 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. .

CE4EMPR_ACCT table Technical Details:

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 CE4EMPR_ACCT table 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 CE4EMPR_ACCT 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
MANDTClient MANDTCLNT3T000MANDT
AKTBOCurrent profitability segment (CO-PA) AKTBOCHAR1CHAR1
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PASUBNRProfitability segment changes (CO-PA) RKESUBNRNUMC4RKESUBNR
BISDATValid to AUFDATBIDATS8DATUM
KNDNRCustomer KUNDE_PACHAR10KNA1ALPHAKUNNRVAG
ARTNRProduct number ARTNRCHAR18MARAMATN1MATNRMAT
FKARTBilling Type FKARTCHAR4TVFKFKART
KAUFNSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
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
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PPRCTRPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
KSTRGCost Object KSTRGCHAR12CKPHKSTRGKTR
PSPNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8PRPSKONPRPS_POSNR
MEINHUnit of Measure CO_MEINHUNIT3T006CUNITMEINS
CE4KEYAssignment Object Key for CO-PA Data Basis (CE4xxxx) COPA_CE4KEYNUMC10RKEOBJNR
ACCT_BUDATPosting Date DAERFDATS8DATUM
ACCT_VRGNGBusiness Transaction J_VORGANGCHAR4Assigned to domainJ_VORGANG
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

Key field Non-key field



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

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

SELECT SINGLE *
FROM CE4EMPR_ACCT
INTO CORRESPONDING FIELDS OF WA_CE4EMPR_ACCT
WHERE...

How to access SAP table CE4EMPR_ACCT

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

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