SAP table reference

TQ79

Table with inspection point/user field combinations

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table TQ79.

SAP table TQ79 has 2 primary key fields: MANDT,SLWBEZ.

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

/ Fields

TQ79 fields.

29 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 T000 MANDT
Key SLWBEZ Identifier for Inspection Point Field CombinationCHAR30 QSLWBEZ
PPKTTYP Inspection Point TypeCHAR10 QPPKTTYP
EQUNRAKT Field ActiveCHAR10 QKZUSRAKT
TPLNRAKT Field ActiveCHAR10 QKZUSRAKT
PHYNRAKT Field ActiveCHAR10 QKZUSRAKT
SFI_AKT Field ActiveCHAR10 QKZUSRAKT
USERC1AKT Field ActiveCHAR10 QKZUSRAKT
USERC2AKT Field ActiveCHAR10 QKZUSRAKT
USERN1AKT Field ActiveCHAR10 QKZUSRAKT
USERN2AKT Field ActiveCHAR10 QKZUSRAKT
USERD1AKT Field ActiveCHAR10 QKZUSRAKT
USERT1AKT Field ActiveCHAR10 QKZUSRAKT
PROBEANZ No. of Inspection Points for Characteristic SummarizationNUMC40 QPROBEANZ
LAST_VALID Last Inspected Sample Is ValidCHAR10 QSAMPLE_LAST_VALID
PPVEMENGE Selected Set for Inspection Point ValuationCHAR80 QPAM QPPVEMENGE
PPVEWERK Plant of Selected Set for Inspection Point ValuationCHAR40 T001W QPPVEWERK
PPVECODGRA Code Group for Inspection Point ValuationCHAR80 QPGR QPPVECODGR
PPVECODEA Code for Inspection Point Valuation (Accepted)CHAR40 QPCD QPPVECODA
PPVECODGRR Code Group for Inspection Point ValuationCHAR80 QPGR QPPVECODGR
PPVECODER Code for Inspection Point Valuation (Rejected)CHAR40 QPCD QPPVECODR
FUNCTION1 Name of Function ModuleCHAR300 TFDIR QFBNAME
FUNCTION1_ACT Function Module Is UsedCHAR10 QFB_ACTIVE
FUNCTION2 Name of Function ModuleCHAR300 TFDIR QFBNAME
FUNCTION2_ACT Function Module Is UsedCHAR10 QFB_ACTIVE
FUNCTION3 Name of Function ModuleCHAR300 TFDIR QFBNAME
FUNCTION3_ACT Function Module Is UsedCHAR10 QFB_ACTIVE
FUNCTION4 Name of Function ModuleCHAR300 TFDIR QFBNAME
FUNCTION4_ACT Function Module Is UsedCHAR10 QFB_ACTIVE
/ Relationships

TQ79 relationships.

22 relationships
TableFieldCheck tableDescriptionCheck field
TQ79FUNCTION1TFDIRFunction ModuleFUNCNAME
TQ79FUNCTION2TFDIRFunction ModuleFUNCNAME
TQ79FUNCTION3TFDIRFunction ModuleFUNCNAME
TQ79FUNCTION4TFDIRFunction ModuleFUNCNAME
TQ79PPVECODEAQPCDInspection catalog codesMANDT
TQ79PPVECODEAQPCDInspection catalog codesKATALOGART
TQ79PPVECODEAQPCDInspection catalog codesCODEGRUPPE
TQ79PPVECODEAQPCDInspection catalog codesCODE
TQ79PPVECODEAQPCDInspection catalog codesVERSION
TQ79PPVECODERQPCDInspection catalog codesMANDT
TQ79PPVECODERQPCDInspection catalog codesKATALOGART
TQ79PPVECODERQPCDInspection catalog codesCODEGRUPPE
TQ79PPVECODERQPCDInspection catalog codesCODE
TQ79PPVECODERQPCDInspection catalog codesVERSION
TQ79PPVECODGRAQPGRInspection catalog code groupsMANDT
TQ79PPVECODGRAQPGRInspection catalog code groupsKATALOGART
TQ79PPVECODGRRQPGRInspection catalog code groupsMANDT
TQ79PPVECODGRRQPGRInspection catalog code groupsKATALOGART
TQ79PPVEMENGEQPAMInspection catalog selected setsMANDT
TQ79PPVEMENGEQPAMInspection catalog selected setsWERKS
TQ79PPVEMENGEQPAMInspection catalog selected setsKATALOGART
TQ79PPVEWERKT001WPlants/BranchesWERKS