UPC_OPTIOS SAP table for – Planning: Conditions for Fields

Here we would like to draw your attention to UPC_OPTIOS table in SAP. As we know it is being mainly used with the SAP BW-PLA (Planning in BW) component which is coming under BW module (Business Warehouse). UPC_OPTIOS is a SAP standard transp table used for storing Planning: Conditions for Fields related data in SAP. It comes under the package UPC.

SAP UPC_OPTIOS table

Table UPC_OPTIOS technical data

TableUPC_OPTIOS
Data storingPlanning: Conditions for Fields
ModuleBW
Sub ModuleBW-PLA-BPS
SAP PackageUPC
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GUID : UUID in compressed form (22 character UUENCODEd)
    Its a key field. Its data type is CHAR (Character String) with field length 22
  • FIELDNAME : Field Name
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • ATRNM : Master data attribute
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • SEQNO : Sequence Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • INIVL : Field has initial value
    Its data type is CHAR (Character String) with field length 1
  • SIGN : +/- Sign of Selection Condition
    Its data type is CHAR (Character String) with field length 1
  • OPTIO : Selection Condition: EQ, BT,…
    Its data type is CHAR (Character String) with field length 2
  • LOW : Lower Limit of the Selection Conditions
    Its data type is CHAR (Character String) with field length 60
  • HIGH : Upper Limit of Selection Conditions
    Its data type is CHAR (Character String) with field length 60
  • VARNM : Variable
    Its data type is CHAR (Character String) with field length 8
  • OFFST : Offset of Variable
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10