SAP table FCOMC_CATEGORY (Category)

SAP table FCOMC_CATEGORY has 2 primary key fields being MANDT,CATEGORY.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
CATEGORY Plan Category CHAR 10 0 FCOM_CATEGORY
FXDIFFOL BPC FX_DIFFERENCE_ONLY Category Dimension Property CHAR 1 0 RTC_FXDIFFOL
FXSRCCAT BPC Fx Source Category CHAR 10 0 FCOMC_CATEGORY RTC_FXSRCCAT
OPECAT BPC Opening Category CHAR 10 0 FCOMC_CATEGORY RTC_OPECAT
OPEYEAR BPC Opening Balance Year CHAR 4 0 RTC_OPEYEAR
OPEPER BPC Opening Period CHAR 10 0 RTC_OPEPER
RATECAT BPC RATE_CATEGORY Dimension Property CHAR 10 0 FCOMC_CATEGORY RTC_RATECAT
RATEYEAR BPC Exchange Rate Year CHAR 4 0 RTC_RATEYEAR
RATEPER BPC Rate Period CHAR 10 0 RTC_RATEPER
OWNCAT BPC OWN_CATEGORY Dimension Property CHAR 10 0 FCOMC_CATEGORY RTC_OWNCAT
OWNYEAR BPC Ownership Year CHAR 4 0 RTC_OWNYEAR
OWNPER BPC Own Period CHAR 10 0 RTC_OWNPER
DIMLIST BPC DIMLIST CHAR 20 0 RTC_DIMLIST
ENABLEJNR BPC ENABLEJNR CHAR 10 0 RTC_ENABLEJNR
DATA_SUBMIT Boolean Variable (X = True, - = False, Space = Unknown) CHAR 1 0 BOOLEAN
unknown
- false
X true
KURST Exchange Rate Type CHAR 4 0 TCURV KURST
APPLICATION_TYPE Application Type NUMC 2 0 FCOM_APPLICATION_TYPE
00 Periodic Planning and Consolidation
01 Project Management
02 Production Cost Controlling
03 Revenue Recognition
04 Fixed Asset
05 Maintenance Order
BASELINE Category is used for baseline plan version CHAR 1 0 FINS_PLAN_CAT_FOR_BASELINE
ONGOING Category is used for ongoing plan version CHAR 1 0 FINS_PLAN_CAT_FOR_ONGOING
PLANORD Category is used for order plan/preliminary cost CHAR 1 0 FINS_PLAN_CAT_FOR_PLANORD
PREPLANORD Category is used for material standard cost CHAR 1 0 FINS_PLAN_CAT_FOR_PREPLANORD
PREDICTION Category is used for sales order cost estimate CHAR 1 0 FCOM_PLAN_CAT_FOR_PREDICTION
UPLOAD_ALLOWED Importing Financial Plan Data Allowed CHAR 1 0 FINS_PLAN_CAT_UPLOAD_ALLOWED
COPY_ALLOWED Copying Financial Plan Data into Category Allowed CHAR 1 0 FINS_PLAN_CAT_COPY_ALLOWED
DELETE_ALLOWED Deleting Financial Plan Data into Category Allowed CHAR 1 0 FINS_PLAN_CAT_DELETE_ALLOWED
CATEGORY_USAGE Category Usage NUMC 3 0 FCOM_CATEGORY_USAGE
000 No specific usage
001 Project Budgeting
002 Cost Center Budget
003 Public Sector Budget
AVAILABILITY_CONTROL Plan Data Used for Availability Control CHAR 1 0 FCOM_PLAN_CAT_FOR_AVC
BUDGET_CONSISTENCY_CHECK Activation of Budget Consistency Checks CHAR 1 0 FCOM_PLAN_CAT_FOR_BCC
PM_ORDER_ESTIMATED_COST Category is used for Plant Maintenance Order Estimated Cost CHAR 1 0 FCOM_PLAN_CAT_PMORDER_ESTICOST
PM_ORDER_PLANNED_COST Category is used for Plant Maintenance Order Planned Cost CHAR 1 0 FCOM_PLAN_CAT_PMORDER_PLANCOST
PM_ORDER_BASELINE_PLANNED_COST Category is used for Plant Maint. Order Baseline Plan. Cost CHAR 1 0 FCOM_PLAN_CAT_PMORDER_BASELINE

FCOMC_CATEGORY foreign key relationships

Table Field Check Table Check Field
0 FCOMC_CATEGORY FXSRCCAT FCOMC_CATEGORY Category CATEGORY
1 FCOMC_CATEGORY KURST TCURV Exchange rate types for currency translation MANDT
1 FCOMC_CATEGORY KURST TCURV Exchange rate types for currency translation KURST
0 FCOMC_CATEGORY MANDT T000 Clients MANDT
1 FCOMC_CATEGORY OPECAT FCOMC_CATEGORY Category CATEGORY
0 FCOMC_CATEGORY OWNCAT FCOMC_CATEGORY Category CATEGORY
1 FCOMC_CATEGORY RATECAT FCOMC_CATEGORY Category CATEGORY