BDSRE12 SAP table for – BDS: Relationship Instances

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

SAP BDSRE12 table

Table BDSRE12 technical data

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

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