BDSREPR31 SAP table for – BDS: Relationship Attributes

Here we would like to draw your attention to BDSREPR31 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). BDSREPR31 is a SAP standard transp table used for storing BDS: Relationship Attributes related data in SAP. It comes under the package UPS.

SAP BDSREPR31 table

Table BDSREPR31 technical data

TableBDSREPR31
Data storingBDS: Relationship Attributes
ModuleBW
Sub ModuleBW-PLA-BPS
SAP PackageUPS
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

SAP BDSREPR31 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 BDSREPR31 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