Search by table name, fields

SAP CE1MIOC Table – MI Xiaomi Operating

The CE1MIOC table in SAP ERP or S/4HANA stores MI Xiaomi Operating data. There are total 95 fields in CE1MIOC table. The MI Xiaomi Operating table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CE1MIOC table. It is in Profitability Analysis: objects generated by the customer (KEG0) ABAP package and is part of the Profitability Analysis (CO-PA) module.

SAP CE1MIOC Table Fields

Following is the list of fields that are available in SAP CE1MIOC table. The primary key fields of the table are MANDT (Client), PALEDGER (Currency type for an operating concern), VRGAR (Record Type), VERSI (Plan version (CO-PA)), PERIO (Period/Year), PAOBJNR (Profitability Segment Number (CO-PA)), PASUBNR (Profitability Segment Changes (CO-PA)), BELNR (Document number of line item in Profitability Analysis), POSNR (Item no. of CO-PA line item).

Field Description Data Element Check Table Data Type
MANDT Client MANDT T000 CLNT (3)
PALEDGER Currency type for an operating concern LEDBO TKEL CHAR (2)
VRGAR Record Type RKE_VRGAR TVGA CHAR (1)
VERSI Plan version (CO-PA) RKEVERSI TKVS CHAR (3)
PERIO Period/Year JAHRPER NUMC (7)
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC (10)
PASUBNR Profitability Segment Changes (CO-PA) RKESUBNR NUMC (4)
BELNR Document number of line item in Profitability Analysis RKE_BELNR CHAR (10)
POSNR Item no. of CO-PA line item RKE_POSNR CHAR (6)
HZDAT Date on which the record was created ERDAT DATS (8)
USNAM Created by ERFASSER CHAR (12)
GJAHR Fiscal Year GJAHR NUMC (4)
PERDE Period PERIODE NUMC (3)
WADAT Goods Issue Date WADAT DATS (8)
FADAT Invoice date (date created) FADAT DATS (8)
BUDAT Posting Date DAERF DATS (8)
ALTPERIO Period/year in alternative period type JAHRPERALT NUMC (7)
PAPAOBJNR Partner profitability segment number (CO-PA) RKEPOBJ NUMC (10)
PAPASUBNR Changes to partner profitability segments (CO-PA) RKEPSUBNR NUMC (4)
KNDNR Customer KUNDE_PA KNA1 CHAR (10)
ARTNR Product number ARTNR MARA CHAR (40)
FKART Billing Type FKART TVFK CHAR (4)
FRWAE Foreign currency key FRWAE TCURC CUKY (5)
KURSF Exchange rate KURSF DEC (9)
KURSBK Exchange rate for op.concern currency -> Co.code currency KURSBK DEC (9)
KURSKZ Exchange rate op.concern currency -> group currency KURSKZ DEC (9)
REC_WAERS Currency of the data record RKE_REC_WAERS TCURC CUKY (5)
KAUFN Sales Order Number KDAUF CHAR (10)
KDPOS Item number in Sales Order KDPOS NUMC (6)
RKAUFNR Order Number AUFNR AUFK CHAR (12)
SKOST Sender cost center SKOST CSKS CHAR (10)
PRZNR Sender Business Process SEPRZ CBPR CHAR (12)
BUKRS Company Code BUKRS T001 CHAR (4)
KOKRS Controlling Area KOKRS TKA01 CHAR (4)
WERKS Plant WERKS_D T001W CHAR (4)
GSBER Business Area GSBER TGSB CHAR (4)
FKBER Functional Area FKBER TFKB CHAR (16)
SEGMENT Segment for Segmental Reporting FB_SEGMENT FAGL_SEGM CHAR (10)
VKORG Sales Organization VKORG TVKO CHAR (4)
VTWEG Distribution Channel VTWEG TVTW CHAR (2)
SPART Division SPART TSPA CHAR (2)
HRKFT Origins (CO-PA) RKEHERK CHAR (4)
PLIKZ Plan/Actual Indicator PLIKZ CHAR (1)
KSTAR Cost Element KSTAR CSKA CHAR (10)
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC (8)
COPA_KOSTL Cost center COPA_KOSTL CSKS CHAR (10)
KSTRG Cost Object KSTRG CKPH CHAR (12)
RBELN Reference document number for CO-PA line item RKERFBELNR CHAR (10)
RPOSN Item number from reference document (CO-PA) RKERFPOSNR CHAR (6)
STO_BELNR Canceled document RKE_STO_BELNR CHAR (10)
STO_POSNR Canceled document item RKE_STO_POSNR CHAR (6)
PRCTR Profit Center PRCTR CEPC CHAR (10)
PPRCTR Partner Profit Center PPRCTR CEPC CHAR (10)
RKESTATU Update status for CO-PA line items RKESTATU CHAR (10)
TIMESTMP Time created (Greenwich Meantime) RKE_HZSTMP DEC (16)
COPA_AWTYP Reference procedure AWTYP CHAR (5)
COPA_AWORG Reference Organizational Units AWORG CHAR (10)
COPA_BWZPT CO-PA Point of valuation BWZPT CHAR (1)
COPA_AWSYS Logical system of source document AWSYS TBDLS CHAR (10)
SERVICE_DOC_TYPE Service Document Type FCO_SRVDOC_TYPE CRMC_PROC_TYPE CHAR (4)
SERVICE_DOC_ID Service Document ID FCO_SRVDOC_ID FCOV_SRVDOC_TYID CHAR (10)
SERVICE_DOC_ITEM_ID Service Document Item ID FCO_SRVDOC_ITEM_ID FCO_SRVDOC NUMC (6)
LOGSYS_SENDER Logical System of the Sender LOGSYSTEM_SENDER CHAR (10)
ERKRS_SENDER Operating concern ERKRS CHAR (4)
BELNR_SENDER Document number of line item in Profitability Analysis RKE_BELNR CHAR (10)
POSNR_SENDER Item no. of CO-PA line item RKE_POSNR CHAR (6)
VRGAR_SENDER Record Type RKE_VRGAR CHAR (1)
BUKRS_SENDER Company Code BUKRS CHAR (4)
REPROCESSING_STATUS_CODE Reprocessing status code FINS_REPROCESSING_STATUS_CODE CHAR (1)
SOLUTION_ORDER_ID Solution Order ID FCO_SOLUTION_ORDER_ID CRMS4D_SERV_H CHAR (10)
SOLUTION_ORDER_ITEM_ID Solution Order Item ID FCO_SOLUTION_ORDER_ITEM_ID CRMS4D_SERV_I NUMC (6)
KDGRP Customer Group KDGRP T151 CHAR (2)
BZIRK Sales District BZIRK T171 CHAR (6)
VKGRP Sales group VKGRP TVKGR CHAR (3)
BRSCH Industry key BRSCH T016 CHAR (4)
LAND1 Country Key LAND1_GP T005 CHAR (3)
MATKL Material Group MATKL T023 CHAR (9)
MAABC ABC Indicator MAABC TMABC CHAR (1)
BONUS Volume rebate group BONUS TVBO CHAR (2)
VKBUR Sales office VKBUR TVBUR CHAR (4)
EFORM Form of manufacture RKEG_EFORM T2513 CHAR (5)
GEBIE Area RKEG_GEBIE T2538 CHAR (4)
ABSMG_ME Base Unit of Measure MEINS T006 UNIT (3)
ABSMG Sales quantity RKE2_ABSMG QUAN (15)
ERLOS Revenue RKE2_ERLOS CURR (23)
MRABA Quantity discount RKE2_MRABA CURR (23)
PRABA Price reduction RKE2_PRABA CURR (23)
RABAT Other discounts RKE2_RABAT CURR (23)
AUSFR OutgoingFreight RKE2_AUSFR CURR (23)
VSVP Dispatch Packaging RKE2_VSVP CURR (23)
UMSLZ Licensing Fees RKE2_UMSLZ CURR (23)
PROVV External Sales Commission RKE2_PROVV CURR (23)
VWGK Administration Overhead Costs RKE2_VWGK CURR (23)
VTRGK Sales overhead costs RKE2_VTRGK CURR (23)
VRPRS Stock Value RKE2_VRPRS CURR (23)