/POSDW/TIBQ SAP table for – Inbound Queue for POS Transactions

Here we would like to draw your attention to /POSDW/TIBQ 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/TIBQ is a SAP standard transp table used for storing Inbound Queue for POS Transactions related data in SAP. It comes under the package /POSDW/DATABASE.

SAP /POSDW/TIBQ table

Table /POSDW/TIBQ technical data

Table/POSDW/TIBQ
Data storingInbound Queue for POS Transactions
ModuleBW
Sub ModuleBW-BCT-ISR-PIP
SAP Package/POSDW/DATABASE
Delivery ClassA – Application table (master and transaction data)
ComponentBI_CONT
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RETAILSTOREID : Store
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • BUSINESSDAYDATE : Posting Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • GUID : GUID for a TIBQ Entry
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • TIMESTAMP : Time at Which a TIBQ Entry Was Created
    Its data type is CHAR (Character String) with field length 14
  • TRANSCOUNT : Number of POS Transactions in TIBQ Entry
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • RECORDSTATUS : Processing Status of a TIBQ Entry
    Its data type is CHAR (Character String) with field length 1
  • OBJKEY : Object key
    Its data type is CHAR (Character String) with field length 70
  • OBJTYPE : Object Type
    Its data type is CHAR (Character String) with field length 10
  • LOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10
  • ORIGIN : Origin of POS Transaction
    Its data type is CHAR (Character String) with field length 1
  • RECORDDATA : RAWSTRING Field for Deep Structures
    Its data type is RSTR (Byte string of variable length – ABAP type XSTRING) with field length 0