BDSRE31 SAP table for – BDS: Relationship Instances

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

SAP BDSRE31 table

Table BDSRE31 technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • REIO_ID : Relationship between logical and physical documents
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • RE_CLASS : Relationship class
    Its data type is CHAR (Character String) with field length 10
  • REP1_ID : ID for documents and relations
    Its data type is CHAR (Character String) with field length 32
  • REP1_CLASS : Document class
    Its data type is CHAR (Character String) with field length 10
  • REP2_ID : ID for documents and relations
    Its data type is CHAR (Character String) with field length 32
  • REP2_CLASS : Document class
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : SDOK: Fields for relationship instances
  • CREA_USER : Created by
    Its data type is CHAR (Character String) with field length 12
  • CREA_TIME : Creation time (UTC)
    Its data type is NUMC (Character String with Digits Only) with field length 14
  • CHNG_USER : Last changed by
    Its data type is CHAR (Character String) with field length 12
  • CHNG_TIME : Time of change (UTC)
    Its data type is NUMC (Character String with Digits Only) with field length 14