BDSLORE12 SAP table for – BDS: Outgoing Relationships of Logical Information Objects

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

SAP BDSLORE12 table

Table BDSLORE12 technical data

TableBDSLORE12
Data storingBDS: Outgoing Relationships of Logical Information Objects
ModuleBW
Sub ModuleBW-PLA-BPS
SAP PackageUPP
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • REP1_ID : Logical document
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • REIO_ID : Relationship between logical and physical documents
    Its a key field. 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
  • RE_CLASS : Relationship 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