SAP Table CE2IDEA
Op. Concern IDES Wor
CE2IDEA (Op. Concern IDES Wor) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link CE2IDEA to other SAP tables.
CE2IDEA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||
| PALEDGER | Currency type for an operating concern | LEDBO | TKEL | CHAR | 2 | 0 | ||||||||||||
| VRGAR | Record Type | RKE_VRGAR | TVGA | CHAR | 1 | 0 | ||||||||||||
| VERSI | Plan version (CO-PA) | RKEVERSI | TKVS | CHAR | 3 | 0 | ||||||||||||
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | 0 | |||||||||||||
| PASUBNR | Profitability segment changes (CO-PA) | RKESUBNR | NUMC | 4 | 0 | |||||||||||||
| BELNR | Document number of line item in Profitability Analysis | RKE_BELNR | CHAR | 10 | 0 | |||||||||||||
| PERBL | Fiscal year/period block | JAHRPERBL | NUMC | 7 | 0 | |||||||||||||
| HZDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||||||
| USNAM | Created by | ERFASSER | CHAR | 12 | 0 | |||||||||||||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | 0 | |||||||||||||
| PAPAOBJNR | Partner profitability segment number (CO-PA) | RKEPOBJ | NUMC | 10 | 0 | |||||||||||||
| PAPASUBNR | Changes to partner profitability segments (CO-PA) | RKEPSUBNR | NUMC | 4 | 0 | |||||||||||||
| KNDNR | Customer | KUNDE_PA | KNA1 | CHAR | 10 | 0 | ||||||||||||
| ARTNR | Product number | ARTNR | MARA | CHAR | 18 | 0 | ||||||||||||
| FKART | Billing Type | FKART | TVFK | CHAR | 4 | 0 | ||||||||||||
| FRWAE | Foreign currency key | FRWAE | TCURC | CUKY | 5 | 0 | ||||||||||||
| REC_WAERS | Currency of the data record | RKE_REC_WAERS | TCURC | CUKY | 5 | 0 | ||||||||||||
| KAUFN | Sales Order Number | KDAUF | VBUK | CHAR | 10 | 0 | ||||||||||||
| KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | 0 | |||||||||||||
| RKAUFNR | Order Number | AUFNR | AUFK | CHAR | 12 | 0 | ||||||||||||
| SKOST | Sender cost center | SKOST | CSKS | CHAR | 10 | 0 | ||||||||||||
| PRZNR | Sender Business Process | SEPRZ | CBPR | CHAR | 12 | 0 | ||||||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||||||||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||||
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||||||||||||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||||||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||||||||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||||||||||||
| HRKFT | Origins (CO-PA) | RKEHERK | CHAR | 4 | 0 | |||||||||||||
| KSTAR | Cost Element | KSTAR | CSKA | CHAR | 10 | 0 | ||||||||||||
| PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 | 0 | ||||||||||||
| KSTRG | Cost Object | KSTRG | CKPH | CHAR | 12 | 0 | ||||||||||||
| RBELN | Reference document number for CO-PA line item | RKERFBELNR | CHAR | 10 | 0 | |||||||||||||
| RPOSN | Item number from reference document (CO-PA) | RKERFPOSNR | CHAR | 6 | 0 | |||||||||||||
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 | 0 | ||||||||||||
| PPRCTR | Partner Profit Center | PPRCTR | CEPC | CHAR | 10 | 0 | ||||||||||||
| RKESTATU | Update status for CO-PA line items | RKESTATU | CHAR | 10 | 0 | |||||||||||||
| TIMESTMP | Time created (Greenwich Meantime) | RKE_HZSTMP | DEC | 16 | 0 | |||||||||||||
| MATKL | Material Group | MATKL | T023 | CHAR | 9 | 0 | ||||||||||||
| MVGR1 | Material group 1 | MVGR1 | TVM1 | CHAR | 3 | 0 | ||||||||||||
| WWPH1 | Prod.hier.1 bef. 4.5 | RKEG_WWPH1 | T2508 | CHAR | 5 | 0 | ||||||||||||
| WWPH2 | Prod.hier.2 bef. 4.5 | RKEG_WWPH2 | T2509 | CHAR | 10 | 0 | ||||||||||||
| WWPH3 | Prod.hier.3 bef. 4.5 | RKEG_WWPH3 | T2510 | CHAR | 18 | 0 | ||||||||||||
| WWPRC | Product category | RKEG_WWPRC | T2520 | CHAR | 8 | 0 | ||||||||||||
| WWSOP | Prod.group for SOP | RKEG_WWSOP | T2511 | CHAR | 18 | 0 | ||||||||||||
| WWSBU | Strategic Bus.Unit | RKEG_WWSBU | T2515 | CHAR | 8 | 0 | ||||||||||||
| KDGRP | Customer group | KDGRP | T151 | CHAR | 2 | 0 | ||||||||||||
| KUKLA | Customer classification | KUKLA | TKUKL | CHAR | 2 | 0 | ||||||||||||
| BZIRK | Sales district | BZIRK | T171 | CHAR | 6 | 0 | ||||||||||||
| BRSCH | Industry key | BRSCH | T016 | CHAR | 4 | 0 | ||||||||||||
| WWREG | Region before 4.5 | RKEG_WWREG | T2516 | CHAR | 6 | 0 | ||||||||||||
| LAND1 | Country Key | LAND1_GP | T005 | CHAR | 3 | 0 | ||||||||||||
| KUNWE | Ship-to party | KUNWE | KNA1 | CHAR | 10 | 0 | ||||||||||||
| WWCST | Country Ship-to | RKEG_WWCST | T2517 | CHAR | 3 | 0 | ||||||||||||
| WWRST | Intern.Region Ship-t | RKEG_WWRST | T2518 | CHAR | 3 | 0 | ||||||||||||
| HIE01 | Customer hierarchy Level 1 | HIEZU01 | KNA1 | CHAR | 10 | 0 | ||||||||||||
| HIE02 | Customer hierarchy Level 2 | HIEZU02 | KNA1 | CHAR | 10 | 0 | ||||||||||||
| HIE03 | Customer hierarchy Level 3 | HIEZU03 | KNA1 | CHAR | 10 | 0 | ||||||||||||
| VRTNR | Sales employee | VRTNR | NUMC | 8 | 0 | |||||||||||||
| VKBUR | Sales Office | VKBUR | TVBUR | CHAR | 4 | 0 | ||||||||||||
| VKGRP | Sales Group | VKGRP | TVKGR | CHAR | 3 | 0 | ||||||||||||
| WWICI | Intercompany ind. | RKEG_WWICI | T2519 | CHAR | 1 | 0 | ||||||||||||
| AUGRU | Order reason (reason for the business transaction) | AUGRU | TVAU | CHAR | 3 | 0 | ||||||||||||
| WWPRO | Promotion | KNUMA_PI | KONA | CHAR | 10 | 0 | ||||||||||||
| WWSDL | Sales deal | KNUMA_AG | KONA | CHAR | 10 | 0 | ||||||||||||
| PAPH1 | Prod.hierarchy01-1 | RKEG_PAPH1 | CHAR | 5 | 0 | |||||||||||||
| PAPH2 | Prod.hierarchy01-2 | RKEG_PAPH2 | CHAR | 10 | 0 | |||||||||||||
| PAPH3 | Prod.hierarchy01-3 | RKEG_PAPH3 | CHAR | 18 | 0 | |||||||||||||
| PAREG | CO-PA special characteristic: (Land, Region) | RKE_PAREG | CHAR | 6 | 0 | |||||||||||||
| SORHIST | Sales Order History | RKE_SORHI | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| WWMEA | Measurements | RKEG_WWMEA | T2521 | CHAR | 2 | 0 | ||||||||||||
| WWQUA | Quality | RKEG_WWQUA | T2522 | CHAR | 5 | 0 | ||||||||||||
| WWSUR | User Interface | RKEG_WWSUR | T2501 | CHAR | 2 | 0 | ||||||||||||
| REGIO | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||||||||
| CRMELEM | CRM Marketing Element | RKECRMELEM | PRPS | NUMC | 8 | 0 | ||||||||||||
| CRMCSTY | CRM Cost Element | RKECRMCSTY | CSKA | CHAR | 10 | 0 | ||||||||||||
| ROUTE | Route | ROUTE | TVRO | CHAR | 6 | 0 | ||||||||||||
| VVOQT_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VVIQT_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VVSQT_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VVGRW_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VV550_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VV560_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VV570_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VV580_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VV495_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VVSTU_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VVOQU_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VV810_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VV820_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VV930_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VV931_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VVSV_ME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
| VVOQT001 | Ordered quantity | RKE2_VVOQT | QUAN | 15 | 3 | |||||||||||||
| VVIQT001 | Invoiced quantity | RKE2_VVIQT | QUAN | 15 | 3 | |||||||||||||
| VVSQT001 | Invoic. qty in SKU | RKE2_VVSQT | QUAN | 15 | 3 | |||||||||||||
| VVGRW001 | Gross weight | RKE2_VVGRW | QUAN | 15 | 3 | |||||||||||||
| VV010001 | Revenue | RKE2_VV010 | CURR | 15 | 2 | |||||||||||||
| VV020001 | Quantity discount | RKE2_VV020 | CURR | 15 | 2 | |||||||||||||
| VV030001 | Customer discount | RKE2_VV030 | CURR | 15 | 2 | |||||||||||||
| VV040001 | Material discount | RKE2_VV040 | CURR | 15 | 2 | |||||||||||||
| VV060001 | Other rebates | RKE2_VV060 | CURR | 15 | 2 | |||||||||||||
| VV070001 | Accrued Sales deduc. | RKE2_VV070 | CURR | 15 | 2 | |||||||||||||
| VV090001 | Accrued bonus | RKE2_VV090 | CURR | 15 | 2 | |||||||||||||
| VV100001 | Outgoing freight | RKE2_VV100 | CURR | 15 | 2 | |||||||||||||
| VV110001 | Accrued freight | RKE2_VV110 | CURR | 15 | 2 | |||||||||||||
| VV120001 | Dispatch packaging | RKE2_VV120 | CURR | 15 | 2 | |||||||||||||
| VV130001 | Internal sales Comm. | RKE2_VV130 | CURR | 15 | 2 | |||||||||||||
| VV140001 | Cost of goods sold | RKE2_VV140 | CURR | 15 | 2 | |||||||||||||
| VV150001 | Material Input | RKE2_VV150 | CURR | 15 | 2 | |||||||||||||
| VV160001 | Trading Goods | RKE2_VV160 | CURR | 15 | 2 | |||||||||||||
| VV170001 | Production Labor fix | RKE2_VV170 | CURR | 15 | 2 | |||||||||||||
| VV180001 | Production Labor var | RKE2_VV180 | CURR | 15 | 2 | |||||||||||||
| VV190001 | Production Setup | RKE2_VV190 | CURR | 15 | 2 | |||||||||||||
| VV200001 | Produc. machine fix | RKE2_VV200 | CURR | 15 | 2 | |||||||||||||
| VV210001 | Produc. machine var | RKE2_VV210 | CURR | 15 | 2 | |||||||||||||
| VV220001 | Produc. Burn-in fix | RKE2_VV220 | CURR | 15 | 2 | |||||||||||||
| VV230001 | Produc. Burn-in var | RKE2_VV230 | CURR | 15 | 2 | |||||||||||||
| VV240001 | Outside Processing | RKE2_VV240 | CURR | 15 | 2 | |||||||||||||
| VV250001 | Material Overhead | RKE2_VV250 | CURR | 15 | 2 | |||||||||||||
| VV260001 | Administr. Overhead | RKE2_VV260 | CURR | 15 | 2 | |||||||||||||
| VV270001 | Sales Overhead | RKE2_VV270 | CURR | 15 | 2 | |||||||||||||
| VV280001 | Miscellaneous Costs | RKE2_VV280 | CURR | 15 | 2 | |||||||||||||
| VV290001 | Price variance | RKE2_VV290 | CURR | 15 | 2 | |||||||||||||
| VV300001 | Quant. Variance Mat. | RKE2_VV300 | CURR | 15 | 2 | |||||||||||||
| VV310001 | Quant. Variance Prod | RKE2_VV310 | CURR | 15 | 2 | |||||||||||||
| VV320001 | Lot-size Variance | RKE2_VV320 | CURR | 15 | 2 | |||||||||||||
| VV330001 | Usage variance | RKE2_VV330 | CURR | 15 | 2 | |||||||||||||
| VV340001 | Input Variances | RKE2_VV340 | CURR | 15 | 2 | |||||||||||||
| VV350001 | Scrap | RKE2_VV350 | CURR | 15 | 2 | |||||||||||||
| VV360001 | Remaining Variances | RKE2_VV360 | CURR | 15 | 2 | |||||||||||||
| VV370001 | Gen.Admin. costs CCA | RKE2_VV370 | CURR | 15 | 2 | |||||||||||||
| VV380001 | General Market.costs | RKE2_VV380 | CURR | 15 | 2 | |||||||||||||
| VV390001 | Distribution costs | RKE2_VV390 | CURR | 15 | 2 | |||||||||||||
| VV400001 | Production costs | RKE2_VV400 | CURR | 15 | 2 | |||||||||||||
| VV410001 | Marketing activities | RKE2_VV410 | CURR | 15 | 2 | |||||||||||||
| VV420001 | Research & Develop. | RKE2_VV420 | CURR | 15 | 2 | |||||||||||||
| VV430001 | Reserv.f.imminent lo | RKE2_VV430 | CURR | 15 | 2 | |||||||||||||
| VV440001 | Corr:Material Input | RKE2_VV440 | CURR | 15 | 2 | |||||||||||||
| VV450001 | Corr:Manuf.Costs fix | RKE2_VV450 | CURR | 15 | 2 | |||||||||||||
| VV460001 | Corr:Manuf.Costs var | RKE2_VV460 | CURR | 15 | 2 | |||||||||||||
| VV470001 | Corr:Overhead Costs | RKE2_VV470 | CURR | 15 | 2 | |||||||||||||
| VV480001 | Maintenance | RKE2_VV480 | CURR | 15 | 2 | |||||||||||||
| VV145001 | COGS alternative | RKE2_VV145 | CURR | 15 | 2 | |||||||||||||
| VV075001 | Actual Sales deduc. | RKE2_VV075 | CURR | 15 | 2 | |||||||||||||
| VV500001 | Process "Production" | RKE2_VV500 | CURR | 15 | 2 | |||||||||||||
| VV510001 | Process "Procurement" | RKE2_VV510 | CURR | 15 | 2 | |||||||||||||
| VV520001 | Process "Sales" | RKE2_VV520 | CURR | 15 | 2 | |||||||||||||
| VV530001 | Process "Administration" | RKE2_VV530 | CURR | 15 | 2 | |||||||||||||
| VV550001 | Number of sales order items | RKE2_VV550 | QUAN | 15 | 3 | |||||||||||||
| VV560001 | Number of payment problems | RKE2_VV560 | QUAN | 15 | 3 | |||||||||||||
| VV570001 | Number of purchase orders for sales order | RKE2_VV570 | QUAN | 15 | 3 | |||||||||||||
| VV580001 | Number of goods receipts for sales orders | RKE2_VV580 | QUAN | 15 | 3 | |||||||||||||
| VV495001 | Number of employees | RKE2_VV495 | QUAN | 15 | 3 | |||||||||||||
| VVSTU001 | Standard Unit of M. | RKE2_VVSTU | QUAN | 15 | 3 | |||||||||||||
| VV155001 | Grace costs | RKE2_VV155 | CURR | 15 | 2 | |||||||||||||
| VV365001 | Price differences | RKE2_VV365 | CURR | 15 | 2 | |||||||||||||
| VV364001 | Mixed-price variance | RKE2_VV364 | CURR | 15 | 2 | |||||||||||||
| VVK15001 | Group: Material | RKE2_VVK15 | CURR | 15 | 2 | |||||||||||||
| VVK20001 | Group: Material overhead costs | RKE2_VVK20 | CURR | 15 | 2 | |||||||||||||
| VVK25001 | Group: Production | RKE2_VVK25 | CURR | 15 | 2 | |||||||||||||
| VVK30001 | Group: Misc. | RKE2_VVK30 | CURR | 15 | 2 | |||||||||||||
| VVK10001 | Group price | RKE2_VVK10 | CURR | 15 | 2 | |||||||||||||
| VVO10001 | PCA: Int. revenues | RKE2_VVO10 | CURR | 15 | 2 | |||||||||||||
| VVO20001 | PCA: Int. costs | RKE2_VVO20 | CURR | 15 | 2 | |||||||||||||
| VVOQU001 | PCA: Delivery quantity | RKE2_VVOQU | QUAN | 15 | 3 | |||||||||||||
| VV366001 | Other Actual Costs | RKE2_VV366 | CURR | 15 | 2 | |||||||||||||
| VV367001 | S/A Costs - Actual | RKE2_VV367 | CURR | 15 | 2 | |||||||||||||
| VV368001 | Process "Production" Actual | RKE2_VV368 | CURR | 15 | 2 | |||||||||||||
| VV151001 | Actual Mat. Input | RKE2_VV151 | CURR | 15 | 2 | |||||||||||||
| VV171001 | Act. Fxd Prod. Costs | RKE2_VV171 | CURR | 15 | 2 | |||||||||||||
| VV181001 | Actual Variable Production Costs | RKE2_VV181 | CURR | 15 | 2 | |||||||||||||
| VV191001 | Actual Setup Costs | RKE2_VV191 | CURR | 15 | 2 | |||||||||||||
| VV201001 | Actual Fixed Machine Hours | RKE2_VV201 | CURR | 15 | 2 | |||||||||||||
| VV211001 | Actual Variable Machine Hours | RKE2_VV211 | CURR | 15 | 2 | |||||||||||||
| VV251001 | Actual Material Overhead Costs | RKE2_VV251 | CURR | 15 | 2 | |||||||||||||
| VV810001 | No. of Inquiries | RKE2_VV810 | QUAN | 15 | 3 | |||||||||||||
| VV820001 | No. of Complaints | RKE2_VV820 | QUAN | 15 | 3 | |||||||||||||
| VV830001 | Cost of Inquiries | RKE2_VV830 | CURR | 15 | 2 | |||||||||||||
| VV840001 | Cost of Complaints | RKE2_VV840 | CURR | 15 | 2 | |||||||||||||
| VV095001 | oth. sales deduct. | RKE2_VV095 | CURR | 15 | 2 | |||||||||||||
| VV713001 | Advertising | RKE2_VV713 | CURR | 15 | 2 | |||||||||||||
| VV900001 | Revenue fee | RKE2_VV900 | CURR | 15 | 2 | |||||||||||||
| VV910001 | Revenue from Expenses/Travel Costs | RKE2_VV910 | CURR | 15 | 2 | |||||||||||||
| VV915001 | Revenues from External Activities | RKE2_VV915 | CURR | 15 | 2 | |||||||||||||
| VV920001 | Sales Deductions | RKE2_VV920 | CURR | 15 | 2 | |||||||||||||
| VV930001 | Number of Labor Hours | RKE2_VV930 | QUAN | 15 | 3 | |||||||||||||
| VV931001 | Number of Hours Billed | RKE2_VV931 | QUAN | 15 | 3 | |||||||||||||
| VV940001 | Cost of Labor Hours | RKE2_VV940 | CURR | 15 | 2 | |||||||||||||
| VV950001 | Travel expenses | RKE2_VV950 | CURR | 15 | 2 | |||||||||||||
| VV960001 | Other expenses | RKE2_VV960 | CURR | 15 | 2 | |||||||||||||
| VV970001 | Ext. activity costs | RKE2_VV970 | CURR | 15 | 2 | |||||||||||||
| VV999001 | X_Technical | RKE2_VV999 | CURR | 15 | 2 | |||||||||||||
| VVADV001 | Advert. Costs SEM215 | RKE2_VVADV | CURR | 15 | 2 | |||||||||||||
| VVCGS001 | COGS in SEM215 | RKE2_VVCGS | CURR | 15 | 2 | |||||||||||||
| VVDEP001 | Deprec. Costs SEM215 | RKE2_VVDEP | CURR | 15 | 2 | |||||||||||||
| VVENG001 | Energy Costs SEM215 | RKE2_VVENG | CURR | 15 | 2 | |||||||||||||
| VVNR001 | NetRevenue in SEM215 | RKE2_VVNR | CURR | 15 | 2 | |||||||||||||
| VVPSC001 | PersonnelCost SEM215 | RKE2_VVPSC | CURR | 15 | 2 | |||||||||||||
| VVREN001 | Rent Costs SEM215 | RKE2_VVREN | CURR | 15 | 2 | |||||||||||||
| VVREV001 | Revenue SEM215 | RKE2_VVREV | CURR | 15 | 2 | |||||||||||||
| VVSD001 | SalesDiscount SEM215 | RKE2_VVSD | CURR | 15 | 2 | |||||||||||||
| VVCM2001 | Contr.Margin2 SEM215 | RKE2_VVCM2 | CURR | 15 | 2 | |||||||||||||
| VVSV001 | Sales Volume SEM215 | RKE2_VVSV | QUAN | 15 | 3 | |||||||||||||
| VVLS1001 | Costs pre-leg | RKE2_VVLS1 | CURR | 15 | 2 | |||||||||||||
| VVLS2001 | Costs main-leg | RKE2_VVLS2 | CURR | 15 | 2 | |||||||||||||
| VVLS3001 | Costs sub-leg | RKE2_VVLS3 | CURR | 15 | 2 | |||||||||||||
CE2IDEA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| CE2IDEA | ARTNR | CE2IDEA | MANDT | MARA | General Material Data | MANDT |
| CE2IDEA | ARTNR | CE2IDEA | ARTNR | MARA | General Material Data | MATNR |
| CE2IDEA | AUGRU | CE2IDEA | AUGRU | TVAU | Sales Documents: Order Reasons | AUGRU |
| CE2IDEA | AUGRU | CE2IDEA | MANDT | TVAU | Sales Documents: Order Reasons | MANDT |
| CE2IDEA | BRSCH | CE2IDEA | MANDT | T016 | Industries | MANDT |
| CE2IDEA | BRSCH | CE2IDEA | BRSCH | T016 | Industries | BRSCH |
| CE2IDEA | BUKRS | CE2IDEA | MANDT | T001 | Company Codes | MANDT |
| CE2IDEA | BUKRS | CE2IDEA | BUKRS | T001 | Company Codes | BUKRS |
| CE2IDEA | BZIRK | CE2IDEA | MANDT | T171 | Customers: Sales Districts | MANDT |
| CE2IDEA | BZIRK | CE2IDEA | BZIRK | T171 | Customers: Sales Districts | BZIRK |
| CE2IDEA | CRMCSTY | CE2IDEA | CRMCSTY | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KSTAR |
| CE2IDEA | CRMCSTY | CE2IDEA | MANDT | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | MANDT |
| CE2IDEA | CRMCSTY | * | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KTOPL | |
| CE2IDEA | CRMELEM | CE2IDEA | MANDT | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| CE2IDEA | CRMELEM | CE2IDEA | CRMELEM | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| CE2IDEA | FKART | CE2IDEA | MANDT | TVFK | Billing: Document Types | MANDT |
| CE2IDEA | FKART | CE2IDEA | FKART | TVFK | Billing: Document Types | FKART |
| CE2IDEA | FRWAE | CE2IDEA | MANDT | TCURC | Currency Codes | MANDT |
| CE2IDEA | FRWAE | CE2IDEA | FRWAE | TCURC | Currency Codes | WAERS |
| CE2IDEA | GSBER | CE2IDEA | MANDT | TGSB | Business Areas | MANDT |
| CE2IDEA | GSBER | CE2IDEA | GSBER | TGSB | Business Areas | GSBER |
| CE2IDEA | HIE01 | CE2IDEA | MANDT | KNA1 | General Data in Customer Master | MANDT |
| CE2IDEA | HIE01 | CE2IDEA | HIE01 | KNA1 | General Data in Customer Master | KUNNR |
| CE2IDEA | HIE02 | CE2IDEA | HIE02 | KNA1 | General Data in Customer Master | KUNNR |
| CE2IDEA | HIE02 | CE2IDEA | MANDT | KNA1 | General Data in Customer Master | MANDT |
| CE2IDEA | HIE03 | CE2IDEA | MANDT | KNA1 | General Data in Customer Master | MANDT |
| CE2IDEA | HIE03 | CE2IDEA | HIE03 | KNA1 | General Data in Customer Master | KUNNR |
| CE2IDEA | KAUFN | CE2IDEA | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| CE2IDEA | KAUFN | CE2IDEA | KAUFN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| CE2IDEA | KDGRP | CE2IDEA | KDGRP | T151 | Customers: Customer Groups | KDGRP |
| CE2IDEA | KDGRP | CE2IDEA | MANDT | T151 | Customers: Customer Groups | MANDT |
| CE2IDEA | KNDNR | CE2IDEA | MANDT | KNA1 | General Data in Customer Master | MANDT |
| CE2IDEA | KNDNR | CE2IDEA | KNDNR | KNA1 | General Data in Customer Master | KUNNR |
| CE2IDEA | KOKRS | CE2IDEA | MANDT | TKA01 | Controlling Areas | MANDT |
| CE2IDEA | KOKRS | CE2IDEA | KOKRS | TKA01 | Controlling Areas | KOKRS |
| CE2IDEA | KSTAR | CE2IDEA | MANDT | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | MANDT |
| CE2IDEA | KSTAR | * | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KTOPL | |
| CE2IDEA | KSTAR | CE2IDEA | KSTAR | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KSTAR |
| CE2IDEA | KSTRG | CE2IDEA | MANDT | CKPH | Master Record: Cost Object ID Number | MANDT |
| CE2IDEA | KSTRG | CE2IDEA | KSTRG | CKPH | Master Record: Cost Object ID Number | KSTRG |
| CE2IDEA | KSTRG | * | CKPH | Master Record: Cost Object ID Number | DATBI | |
| CE2IDEA | KUKLA | CE2IDEA | KUKLA | TKUKL | Customers: Customer Classifications | KUKLA |
| CE2IDEA | KUKLA | CE2IDEA | MANDT | TKUKL | Customers: Customer Classifications | MANDT |
| CE2IDEA | KUNWE | CE2IDEA | MANDT | KNA1 | General Data in Customer Master | MANDT |
| CE2IDEA | KUNWE | CE2IDEA | KUNWE | KNA1 | General Data in Customer Master | KUNNR |
| CE2IDEA | LAND1 | CE2IDEA | MANDT | T005 | Countries | MANDT |
| CE2IDEA | LAND1 | CE2IDEA | LAND1 | T005 | Countries | LAND1 |
| CE2IDEA | MANDT | CE2IDEA | MANDT | T000 | Clients | MANDT |
| CE2IDEA | MATKL | CE2IDEA | MANDT | T023 | Material Groups | MANDT |
| CE2IDEA | MATKL | CE2IDEA | MATKL | T023 | Material Groups | MATKL |
| CE2IDEA | MVGR1 | CE2IDEA | MANDT | TVM1 | Material Pricing Group 1 | MANDT |
| CE2IDEA | MVGR1 | CE2IDEA | MVGR1 | TVM1 | Material Pricing Group 1 | MVGR1 |
| CE2IDEA | PALEDGER | CE2IDEA | MANDT | TKEL | CO-PA ledger | MANDT |
| CE2IDEA | PALEDGER | CE2IDEA | PALEDGER | TKEL | CO-PA ledger | PALEDGER |
| CE2IDEA | PPRCTR | * | CEPC | Profit Center Master Data Table | DATBI | |
| CE2IDEA | PPRCTR | CE2IDEA | KOKRS | CEPC | Profit Center Master Data Table | KOKRS |
| CE2IDEA | PPRCTR | CE2IDEA | MANDT | CEPC | Profit Center Master Data Table | MANDT |
| CE2IDEA | PPRCTR | CE2IDEA | PPRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| CE2IDEA | PRCTR | CE2IDEA | MANDT | CEPC | Profit Center Master Data Table | MANDT |
| CE2IDEA | PRCTR | CE2IDEA | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| CE2IDEA | PRCTR | * | CEPC | Profit Center Master Data Table | DATBI | |
| CE2IDEA | PRCTR | CE2IDEA | KOKRS | CEPC | Profit Center Master Data Table | KOKRS |
| CE2IDEA | PRZNR | CE2IDEA | KOKRS | CBPR | CO-ABC: Activity Master Table | KOKRS |
| CE2IDEA | PRZNR | CE2IDEA | PRZNR | CBPR | CO-ABC: Activity Master Table | PRZNR |
| CE2IDEA | PRZNR | * | CBPR | CO-ABC: Activity Master Table | DATBI | |
| CE2IDEA | PRZNR | CE2IDEA | MANDT | CBPR | CO-ABC: Activity Master Table | MANDT |
| CE2IDEA | PSPNR | CE2IDEA | PSPNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| CE2IDEA | PSPNR | CE2IDEA | MANDT | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| CE2IDEA | REC_WAERS | CE2IDEA | REC_WAERS | TCURC | Currency Codes | WAERS |
| CE2IDEA | REC_WAERS | CE2IDEA | MANDT | TCURC | Currency Codes | MANDT |
| CE2IDEA | REGIO | CE2IDEA | REGIO | T005S | Taxes: Region (Province) Key | BLAND |
| CE2IDEA | REGIO | CE2IDEA | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| CE2IDEA | REGIO | CE2IDEA | LAND1 | T005S | Taxes: Region (Province) Key | LAND1 |
| CE2IDEA | RKAUFNR | CE2IDEA | MANDT | AUFK | Order master data | MANDT |
| CE2IDEA | RKAUFNR | CE2IDEA | RKAUFNR | AUFK | Order master data | AUFNR |
| CE2IDEA | ROUTE | CE2IDEA | MANDT | TVRO | Routes | MANDT |
| CE2IDEA | ROUTE | CE2IDEA | ROUTE | TVRO | Routes | ROUTE |
| CE2IDEA | SKOST | CE2IDEA | KOKRS | CSKS | Cost Center Master Data | KOKRS |
| CE2IDEA | SKOST | CE2IDEA | SKOST | CSKS | Cost Center Master Data | KOSTL |
| CE2IDEA | SKOST | * | CSKS | Cost Center Master Data | DATBI | |
| CE2IDEA | SKOST | CE2IDEA | MANDT | CSKS | Cost Center Master Data | MANDT |
| CE2IDEA | SPART | CE2IDEA | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| CE2IDEA | SPART | CE2IDEA | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| CE2IDEA | VERSI | CE2IDEA | MANDT | TKVS | CO Versions | MANDT |
| CE2IDEA | VERSI | CE2IDEA | VERSI | TKVS | CO Versions | VERSI |
| CE2IDEA | VKBUR | CE2IDEA | MANDT | TVBUR | Organizational Unit: Sales Offices | MANDT |
| CE2IDEA | VKBUR | CE2IDEA | VKBUR | TVBUR | Organizational Unit: Sales Offices | VKBUR |
| CE2IDEA | VKGRP | CE2IDEA | MANDT | TVKGR | Organizational Unit: Sales Groups | MANDT |
| CE2IDEA | VKGRP | CE2IDEA | VKGRP | TVKGR | Organizational Unit: Sales Groups | VKGRP |
| CE2IDEA | VKORG | CE2IDEA | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| CE2IDEA | VKORG | CE2IDEA | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| CE2IDEA | VRGAR | CE2IDEA | MANDT | TVGA | Record types for CO-PA | MANDT |
| CE2IDEA | VRGAR | CE2IDEA | VRGAR | TVGA | Record types for CO-PA | VRGAR |
| CE2IDEA | VTWEG | CE2IDEA | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| CE2IDEA | VTWEG | CE2IDEA | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| CE2IDEA | VV495_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VV495_ME | CE2IDEA | VV495_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VV550_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VV550_ME | CE2IDEA | VV550_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VV560_ME | CE2IDEA | VV560_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VV560_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VV570_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VV570_ME | CE2IDEA | VV570_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VV580_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VV580_ME | CE2IDEA | VV580_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VV810_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VV810_ME | CE2IDEA | VV810_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VV820_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VV820_ME | CE2IDEA | VV820_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VV930_ME | CE2IDEA | VV930_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VV930_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VV931_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VV931_ME | CE2IDEA | VV931_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VVGRW_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VVGRW_ME | CE2IDEA | VVGRW_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VVIQT_ME | CE2IDEA | VVIQT_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VVIQT_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VVOQT_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VVOQT_ME | CE2IDEA | VVOQT_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VVOQU_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VVOQU_ME | CE2IDEA | VVOQU_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VVSQT_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VVSQT_ME | CE2IDEA | VVSQT_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VVSTU_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | VVSTU_ME | CE2IDEA | VVSTU_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VVSV_ME | CE2IDEA | VVSV_ME | T006 | Units of Measurement | MSEHI |
| CE2IDEA | VVSV_ME | CE2IDEA | MANDT | T006 | Units of Measurement | MANDT |
| CE2IDEA | WERKS | CE2IDEA | WERKS | T001W | Plants/Branches | WERKS |
| CE2IDEA | WERKS | CE2IDEA | MANDT | T001W | Plants/Branches | MANDT |
| CE2IDEA | WWCST | CE2IDEA | WWCST | T2517 | Table of Characteristic Values | WWCST |
| CE2IDEA | WWCST | CE2IDEA | MANDT | T2517 | Table of Characteristic Values | MANDT |
| CE2IDEA | WWICI | CE2IDEA | MANDT | T2519 | Table of Characteristic Values | MANDT |
| CE2IDEA | WWICI | CE2IDEA | WWICI | T2519 | Table of Characteristic Values | WWICI |
| CE2IDEA | WWMEA | CE2IDEA | MANDT | T2521 | Values for characteristic "Measurements " | MANDT |
| CE2IDEA | WWMEA | CE2IDEA | WWMEA | T2521 | Values for characteristic "Measurements " | WWMEA |
| CE2IDEA | WWPH1 | CE2IDEA | MANDT | T2508 | Table of Characteristic Values | MANDT |
| CE2IDEA | WWPH1 | CE2IDEA | WWPH1 | T2508 | Table of Characteristic Values | WWPH1 |
| CE2IDEA | WWPH2 | CE2IDEA | MANDT | T2509 | Table of Characteristic Values | MANDT |
| CE2IDEA | WWPH2 | CE2IDEA | WWPH2 | T2509 | Table of Characteristic Values | WWPH2 |
| CE2IDEA | WWPH3 | CE2IDEA | MANDT | T2510 | Table of Characteristic Values | MANDT |
| CE2IDEA | WWPH3 | CE2IDEA | WWPH3 | T2510 | Table of Characteristic Values | WWPH3 |
| CE2IDEA | WWPRC | CE2IDEA | MANDT | T2520 | Table of Characteristic Values | MANDT |
| CE2IDEA | WWPRC | CE2IDEA | WWPRC | T2520 | Table of Characteristic Values | WWPRC |
| CE2IDEA | WWPRO | CE2IDEA | MANDT | KONA | Agreements | MANDT |
| CE2IDEA | WWPRO | CE2IDEA | WWPRO | KONA | Agreements | KNUMA |
| CE2IDEA | WWQUA | CE2IDEA | WWQUA | T2522 | Values for characteristic "Qlty " | WWQUA |
| CE2IDEA | WWQUA | CE2IDEA | MANDT | T2522 | Values for characteristic "Qlty " | MANDT |
| CE2IDEA | WWREG | CE2IDEA | MANDT | T2516 | Table of Characteristic Values | MANDT |
| CE2IDEA | WWREG | CE2IDEA | WWREG | T2516 | Table of Characteristic Values | WWREG |
| CE2IDEA | WWRST | CE2IDEA | MANDT | T2518 | Table of Characteristic Values | MANDT |
| CE2IDEA | WWRST | CE2IDEA | WWRST | T2518 | Table of Characteristic Values | WWRST |
| CE2IDEA | WWSBU | CE2IDEA | MANDT | T2515 | Table of Characteristic Values | MANDT |
| CE2IDEA | WWSBU | CE2IDEA | WWSBU | T2515 | Table of Characteristic Values | WWSBU |
| CE2IDEA | WWSDL | CE2IDEA | WWSDL | KONA | Agreements | KNUMA |
| CE2IDEA | WWSDL | CE2IDEA | MANDT | KONA | Agreements | MANDT |
| CE2IDEA | WWSOP | CE2IDEA | WWSOP | T2511 | Table of Characteristic Values | WWSOP |
| CE2IDEA | WWSOP | CE2IDEA | MANDT | T2511 | Table of Characteristic Values | MANDT |
| CE2IDEA | WWSUR | CE2IDEA | MANDT | T2501 | MANDT | |
| CE2IDEA | WWSUR | CE2IDEA | WWSUR | T2501 | WWSUR | |
