UPA_MCB_000 SAP table for – Assignment of Budgeting Year to Controlling Area

Here we would like to draw your attention to UPA_MCB_000 table in SAP. As we know it is being mainly used with the SAP BW-BCT (Business Content and Extractors in BW) component which is coming under BW module (Business Warehouse). UPA_MCB_000 is a SAP standard transp table used for storing Assignment of Budgeting Year to Controlling Area related data in SAP. It comes under the package UPA_MCB.

SAP UPA_MCB_000 table

Table UPA_MCB_000 technical data

TableUPA_MCB_000
Data storingAssignment of Budgeting Year to Controlling Area
ModuleBW
Sub ModuleBW-BCT-PLA-MCB
SAP PackageUPA_MCB
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentBI_CONT
Table CategoryTRANSP

SAP UPA_MCB_000 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in UPA_MCB_000 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • CO_AREA : Controlling Area
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • TARGET_YEAR : Target Year for a Budgeting
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • PLAN_AREA : Planning Area for Budgeting
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • FLAG_ACTIVITY : Activity Flag
    Its data type is CHAR (Character String) with field length 1
  • SOURCE_YEAR : Reference Year for a (History-Based) Budgeting
    Its data type is NUMC (Character String with Digits Only) with field length 4