/XNFE/TSTAT SAP table for – NF-e: Authority Status

Here we would like to draw your attention to /XNFE/TSTAT 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). /XNFE/TSTAT is a SAP standard transp table used for storing NF-e: Authority Status related data in SAP. It comes under the package /POSDW/TASK.

SAP /XNFE/TSTAT table

Table /XNFE/TSTAT technical data

Table/XNFE/TSTAT
Data storingNF-e: Authority Status
ModuleBW
Sub ModuleBW-BCT-ISR-PIP
SAP Package/POSDW/TASK
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentBI_CONT
Table CategoryTRANSP

SAP /XNFE/TSTAT 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 /XNFE/TSTAT 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
  • TRANSINDEXBEGIN : Index of the First Transaction in the Task Status Area
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • TRANSINDEXEND : Index of the Last Transaction of the Task Status Area
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • TASK : Task
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • TASKSTATUS : Task Status
    Its data type is CHAR (Character String) with field length 1
  • TRANSCOUNT : Number of POS Transactions in the Area of the Status Record
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10