/POSDW/OBJREL SAP table for – Default Table for Object Relationship Service

Here we would like to draw your attention to /POSDW/OBJREL table in SAP. As we know it is being mainly used with the SAP BW-BCT (Business Content and Extractors in BW) component which is coming under BW module (Business Warehouse). /POSDW/OBJREL is a SAP standard transp table used for storing Default Table for Object Relationship Service related data in SAP. It comes under the package /POSDW/CORE.

SAP /POSDW/OBJREL table

Table /POSDW/OBJREL technical data

Table/POSDW/OBJREL
Data storingDefault Table for Object Relationship Service
ModuleBW
Sub ModuleBW-BCT-ISR-PIP
SAP Package/POSDW/CORE
Delivery ClassA – Application table (master and transaction data)
ComponentBI_CONT
Table CategoryTRANSP

SAP /POSDW/OBJREL 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 /POSDW/OBJREL table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BRELGUID : Globally Unique Identifier
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • RELTYPE : Relationship type
    Its data type is CHAR (Character String) with field length 10
  • INSTID_A : Instance Ident. in BOR Compat. Persistent Object References
    Its data type is CHAR (Character String) with field length 70
  • TYPEID_A : Type of Objects in Persistent Object References
    Its data type is CHAR (Character String) with field length 32
  • CATID_A : Category of Objects in Persistent Object References
    Its data type is CHAR (Character String) with field length 2
  • INSTID_B : Instance Ident. in BOR Compat. Persistent Object References
    Its data type is CHAR (Character String) with field length 70
  • TYPEID_B : Type of Objects in Persistent Object References
    Its data type is CHAR (Character String) with field length 32
  • CATID_B : Category of Objects in Persistent Object References
    Its data type is CHAR (Character String) with field length 2
  • LOGSYS_A : Logical system
    Its data type is CHAR (Character String) with field length 10
  • ARCH_A : Archiving Flag for Object Relationships
    Its data type is CHAR (Character String) with field length 1
  • LOGSYS_B : Logical system
    Its data type is CHAR (Character String) with field length 10
  • ARCH_B : Archiving Flag for Object Relationships
    Its data type is CHAR (Character String) with field length 1
  • UTCTIME : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • HOMESYS : Logical system
    Its data type is CHAR (Character String) with field length 10