UPARM_TC_CIP_DR SAP table for – MDP – InfoProvider Dimension Restriction

Here we would like to draw your attention to UPARM_TC_CIP_DR 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). UPARM_TC_CIP_DR is a SAP standard transp table used for storing MDP – InfoProvider Dimension Restriction related data in SAP. It comes under the package UPARM.

SAP UPARM_TC_CIP_DR table

Table UPARM_TC_CIP_DR technical data

TableUPARM_TC_CIP_DR
Data storingMDP – InfoProvider Dimension Restriction
ModuleBW
Sub ModuleBW-BCT-PLA-RAP
SAP PackageUPARM
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentBI_CONT
Table CategoryTRANSP

SAP UPARM_TC_CIP_DR 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 UPARM_TC_CIP_DR table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • VIEW_ID : View ID
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • TABLE_TYPE : Results Table Type (Main or Second Table)
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • INFO_PROVIDER : Info Provider
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • KEY_FIGURE : Info Provider’s Key Figure
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • KEY_FIGURE_NO : Key Figure Number in Column
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • RESTRICTED_DIM : Restricted Dimension
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • FIXED_VALUE : Dimension Fixed Value
    Its data type is CHAR (Character String) with field length 60