/POSDW/TLOGS SAP table for – POS Transaction Data for Small Transactions

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

SAP /POSDW/TLOGS table

Table /POSDW/TLOGS technical data

Table/POSDW/TLOGS
Data storingPOS Transaction Data for Small 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/TLOGS 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/TLOGS 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
  • TRANSINDEX : Transaction Index
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • TRANS_VERSION : Version of POS Transaction
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • WORKSTATIONID : POS Number
    Its data type is CHAR (Character String) with field length 10
  • TRANSNUMBER : Transaction Number
    Its data type is CHAR (Character String) with field length 20
  • TRANSTYPECODE : Transaction Type
    Its data type is CHAR (Character String) with field length 4
  • BEGINTIMESTAMP : Second in Which Transaction Starts
    Its data type is CHAR (Character String) with field length 14
  • ENDTIMESTAMP : Second in Which Transaction Ends
    Its data type is CHAR (Character String) with field length 14
  • DEPARTMENT : Department
    Its data type is CHAR (Character String) with field length 10
  • OPERATORQUAL : Operator Qualifier
    Its data type is CHAR (Character String) with field length 1
  • OPERATORID : Cashier Number or Name
    Its data type is CHAR (Character String) with field length 30
  • PARTNERQUALIFIER : Qualifier for Partner Number
    Its data type is CHAR (Character String) with field length 1
  • PARTNERID : Partner Number
    Its data type is CHAR (Character String) with field length 13
  • CHANGEFLAG : Change Indicator for Transaction Data
    Its data type is CHAR (Character String) with field length 1
  • BUSINESSTYPE : Business Transaction
    Its data type is CHAR (Character String) with field length 1
  • TRANSTURNOVER : Sales Totals Per Transaction
    Its data type is CURR (Currency Field) with field length 15
  • TRANSCURRENCY : Transaction Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • VERSION : Version for Deep Structures in the Database Tables
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • LENGTH : Length Field for Subsequent LRAW Field
  • TRANSACTIONDATA : LRAW Field for Deep Structures
    Its data type is LRAW (Long byte string, requires preceding INT2 field) with field length 32000