TQ79 SAP table for – Table with inspection point/user field combinations

Here we would like to draw your attention to TQ79 table in SAP. As we know it is being mainly used with the SAP QM-IM (Quality Inspection) component which is coming under QM module (Quality Management). TQ79 is a SAP standard transparent table used for storing Table with inspection point/user field combinations related data in SAP. It comes under the package QLPP.

SAP TQ79 table

Table TQ79 technical data

TableTQ79
Data storingTable with inspection point/user field combinations
ModuleQM
ComponentQM-IM
SAP PackageQLPP
Delivery ClassG – Customer table, SAP may insert new data records but may not overwrite or delete existing ones
Table CategoryTRANSPARENT

SAP TQ79 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 TQ79 table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • USERN2AKT
    Its data type is C (Character String) with field length 1
  • USERD1AKT
    Its data type is C (Character String) with field length 1
  • USERT1AKT
    Its data type is C (Character String) with field length 1
  • PROBEANZ
    Its data type is N (Character String with Digits Only) with field length 4
  • LAST_VALID
    Its data type is C (Character String) with field length 1
  • PPVEMENGE
    Its data type is C (Character String) with field length 8
  • PPVEWERK
    Its data type is C (Character String) with field length 4
  • PPVECODGRA
    Its data type is C (Character String) with field length 8
  • PPVECODEA
    Its data type is C (Character String) with field length 4
  • PPVECODGRR
    Its data type is C (Character String) with field length 8
  • SLWBEZ
    Its a key field. Its data type is C (Character String) with field length 3
  • PPVECODER
    Its data type is C (Character String) with field length 4
  • FUNCTION1
    Its data type is C (Character String) with field length 30
  • FUNCTION1_ACT
    Its data type is C (Character String) with field length 1
  • FUNCTION2
    Its data type is C (Character String) with field length 30
  • FUNCTION2_ACT
    Its data type is C (Character String) with field length 1
  • FUNCTION3
    Its data type is C (Character String) with field length 30
  • FUNCTION3_ACT
    Its data type is C (Character String) with field length 1
  • FUNCTION4
    Its data type is C (Character String) with field length 30
  • FUNCTION4_ACT
    Its data type is C (Character String) with field length 1
  • PPKTTYP
    Its data type is C (Character String) with field length 1
  • EQUNRAKT
    Its data type is C (Character String) with field length 1
  • TPLNRAKT
    Its data type is C (Character String) with field length 1
  • PHYNRAKT
    Its data type is C (Character String) with field length 1
  • USERC1AKT
    Its data type is C (Character String) with field length 1
  • USERC2AKT
    Its data type is C (Character String) with field length 1
  • USERN1AKT
    Its data type is C (Character String) with field length 1