UPARM_TC_CIP SAP table for – MDP – InfoProvider Column Definition

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

SAP UPARM_TC_CIP table

Table UPARM_TC_CIP technical data

TableUPARM_TC_CIP
Data storingMDP – InfoProvider Column Definition
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 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 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
  • SEQUENCE : Column Sequence
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • KF_UNIT_SOURCE : Key Figure Unit Source (InfoObject or Virtual Column)
    Its data type is CHAR (Character String) with field length 1
  • KF_UNIT_IOBJ : Key Figure Unit InfoObject
    Its data type is CHAR (Character String) with field length 30
  • KF_UNIT_ATTR : Key Figure Unit InfoObject Attribute
    Its data type is CHAR (Character String) with field length 30
  • KF_UNIT_VIRT_COL : Virtual Column Name Holding Key Figure Unit
    Its data type is CHAR (Character String) with field length 30
  • INPUT_ENABLE : Input Enable
    Its data type is CHAR (Character String) with field length 1
  • HIDE : Hide Column
    Its data type is CHAR (Character String) with field length 1
  • INITIAL_VALUE : Initial Value
    Its data type is CHAR (Character String) with field length 60
  • COPY_RULE : Copy Attribute Rule
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • WEIGHTING_FACTOR : Weighting Factor
    Its data type is CHAR (Character String) with field length 1
  • ALLOW_NEGATIVE : Attribute Allow Negative Number
    Its data type is CHAR (Character String) with field length 1