BDSLOPR31 SAP table for – BDS: Attribute Values of Logical Information Objects

Here we would like to draw your attention to BDSLOPR31 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). BDSLOPR31 is a SAP standard transp table used for storing BDS: Attribute Values of Logical Information Objects related data in SAP. It comes under the package UPS.

SAP BDSLOPR31 table

Table BDSLOPR31 technical data

TableBDSLOPR31
Data storingBDS: Attribute Values of Logical Information Objects
ModuleBW
Sub ModuleBW-PLA-BPS
SAP PackageUPS
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • OBJECT_ID : ID for documents and relations
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • PROP_NAME : Attribute of a document or a relationship
    Its a key field. Its data type is CHAR (Character String) with field length 25
  • PROP_INDEX : KPro: General counter (uniqueness in DB)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • IO_CLASS : Document class
    Its data type is CHAR (Character String) with field length 10
  • PROP_VALUE : Attribute Value
    Its data type is CHAR (Character String) with field length 64
  • PROP_SECI : Attribute feature (shortened)
    Its data type is CHAR (Character String) with field length 12