TXPDAT SAP table for – Expediting Data

Here we would like to draw your attention to TXPDAT table in SAP. As we know it is being mainly used with the SAP PS-PRG (Progress in PS) component which is coming under PS module (Project Systems). TXPDAT is a SAP standard transparent table used for storing Expediting Data related data in SAP. It comes under the package EXPD.

SAP TXPDAT table

Table TXPDAT technical data

TableTXPDAT
Data storingExpediting Data
ModulePS
ComponentPS-PRG
SAP PackageEXPD
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP TXPDAT Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in TXPDAT table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • XCURRENT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • CURRFIX
    Its data type is C (Character String) with field length 1
  • XFORECAST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FORCFIX
    Its data type is C (Character String) with field length 1
  • XACTUAL
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PERC_COMPL
    Its data type is N (Character String with Digits Only) with field length 3
  • XSCHDSC
    Its data type is C (Character String) with field length 1
  • EXP_PRIO
    Its data type is N (Character String with Digits Only) with field length 2
  • INSP_LOT
    Its data type is N (Character String with Digits Only) with field length 12
  • REMARK : Address notes
    Its data type is C (Character String) with field length 40
  • EXPOBJ
    Its a key field. Its data type is C (Character String) with field length 2
  • EBELN : Purchasing Document Number
    Its data type is C (Character String) with field length 10
  • SEQUENCE : Alert configuration: dataelement integer
    Its data type is N (Character String with Digits Only) with field length 2
  • RSNUM : Number of reservation/dependent requirements
    Its data type is N (Character String with Digits Only) with field length 10
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ERUZT
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AEUZT
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CI_TXPDAT
  • IDENT
    Its a key field. Its data type is C (Character String) with field length 50
  • NMRID
    Its a key field. Its data type is C (Character String) with field length 10
  • EVENT : Time at which the RW interface is called up
    Its a key field. Its data type is C (Character String) with field length 5
  • DTEXT
    Its data type is C (Character String) with field length 40
  • STDEV
    Its data type is C (Character String) with field length 1
  • XBASELINE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BASEFIX
    Its data type is C (Character String) with field length 1