ENT5790 SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
ENT5790 is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The ENT5790 table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include PLNTY (Task List Type), PLNNR (Key for Task List Group), PLNKN (Number of the task list node), KZEINSTELL (Characteristic Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP ENT5790 table view fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
| PLNTY | Task List Type | PLNTY | CHAR | 1 | PLNTY | PTY | H_TCA01 | ||
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
| PLNKN | Number of the task list node | PLNKN | NUMC | 8 | KNTNR | ||||
| KZEINSTELL | Characteristic Type | QKZEINSTMK | CHAR | 1 | QKZEINSTMK | ||||
| MERKNR | Inspection Characteristic Number | QMERKNRP | NUMC | 4 | QMERKNRP | ||||
| ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| GUELTIGAB | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
| SERNV | Technical status from | TECHV | CHAR | 12 | TECHS | ||||
| LOEKZ | Deletion Indicator | LKENZ | CHAR | 1 | XFELD | ||||
| PARKZ | Indicator: inactive changes | PARKZ | CHAR | 1 | XFELD | ||||
| AENDERGNR | Change Number | AENNR | CHAR | 12 | AENNR | AENNR | AEN | ||
| AENDERER | Name of User who Most Recently Changed the Data Record | QAENDERER | CHAR | 12 | QAENDERER | ||||
| AENDERDAT | Date on Which Data Record Was Changed | QDATUMAEND | DATS | 8 | DATUM | ||||
| STEUERKZ | Cntrl Indicator String for Insp. Char./Master Insp. Char. | QMKCONTROL | CHAR | 30 | QMKCONTROL | ||||
| QMTB_WERKS | Plant for Inspection Method | Q_METH_PLANT | CHAR | 4 | T001W | WERKS | WRK | H_T001W | |
| PMETHODE | Inspection Method | QPMETHODE | CHAR | 8 | QMTB | ALPHA | QPMETHODE | PMT | |
| PMTVERSION | Version Number of the Inspection Method | QVERSNRPM | CHAR | 6 | ALPHA | QVERSNR | |||
| QPMK_REF | Reference to Master Insp. Characteristic in Task List | QKZ_REF | CHAR | 1 | QKZ | ||||
| QPMK_ZAEHL | Plant for the Master Inspection Characteristic | QZAEHLER | CHAR | 4 | QZAEHLER | WRK | |||
| VERWMERKM | Master Inspection Characteristics | QMERKNR | CHAR | 8 | QPMK | ALPHA | QMERKNR | PMK | |
| MKVERSION | Version Number of the Master Inspection Characteristic | QVERSNRMK | CHAR | 6 | ALPHA | QVERSNR | |||
| MKVERSDAT | Key Date for Version Selection | QVERSDAT | DATS | 8 | DATUM | ||||
| MERKGEW | Weighting of the Characteristic | QMERKGEW | CHAR | 2 | TQ17A | QMERKKLAS | |||
| PROBENR | Partial Sample No. for Inspection Charac. in Task List | QPROBEPL | NUMC | 3 | QPROBEPL | ||||
| PRUEFQUALI | Inspector Qualification | QPRQUALIF | CHAR | 5 | TQ11 | QPRQUALIF | |||
| TOLERANZSL | Tolerance Key | QTOLERANZ | CHAR | 4 | TQ29 | QTOLERANZ | |||
| KURZTEXT | Short Text for Inspection Characteristic | QTXT_CHA | CHAR | 40 | QKURZTEXT | ||||
| LTEXTKZ | Inspection Characteristic Long Text Exists | QLTEXTKZ | CHAR | 1 | QKZ | ||||
| LTEXTSPR | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
| LTEXTEKZ | Physical-Sample-Drawing Text Exists | QKZPRZIEH | CHAR | 1 | QKZWSP | ||||
| LTXTENTSPR | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
| STELLEN | Number of Places to the Right of a Decimal Point (Accuracy) | QSTELLEN | INT1 | 3 | QSTELLEN | ||||
| MASSEINHSW | Unit of Measurement, in Which Quantitative Data Is Stored | QMASSEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| SOLLWERT | Target Value for a Quantitative Characteristic | QSOLLWERTE | FLTP | 16(16) | QSOLLWERTE | ||||
| SOLLWNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
| TOLERANZOB | Upper Specification Limit | QTOLOB | FLTP | 16(16) | QSOLLWERTE | ||||
| TOLOBNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
| TOLERANZUN | Lower Tolerance Limit | QTOLUN | FLTP | 16(16) | QSOLLWERTE | ||||
| TOLUNNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
| KLASANZAHL | Number of Value Classes for Inspection Results | QKLASSZAHL | INT1 | 3 | QKLASSZAHL | ||||
| KLASBREITE | Class Width | QKLASSBR | FLTP | 16(16) | QSOLLWERTE | ||||
| KLASBRNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
| KLASMITTE | Class Midpoint | QKLASSMIT | FLTP | 16(16) | QSOLLWERTE | ||||
| KLASMINI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
| GRENZEOB1 | First Upper Specification Limit | QGRENZOB1 | FLTP | 16(16) | QSOLLWERTE | ||||
| GRENZOB1NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
| GRENZEUN1 | First Lower Specification Limit | QGRENZUN1 | FLTP | 16(16) | QSOLLWERTE | ||||
| GRENZUN1NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
| GRENZEOB2 | Second Upper Specification Limit | QGRENZOB2 | FLTP | 16(16) | QSOLLWERTE | ||||
| GRENZOB2NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
| GRENZEUN2 | Second Lower Specification Limit | QGRENZUN2 | FLTP | 16(16) | QSOLLWERTE | ||||
| GRENZUN2NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
| PLAUSIOBEN | Upper Plausibility Limit | QPLAUSIOB | FLTP | 16(16) | QSOLLWERTE | ||||
| PLAUSIOBNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
| PLAUSIUNTE | Lower Plausibility Limit | QPLAUSIUN | FLTP | 16(16) | QSOLLWERTE | ||||
| PLAUSIUNNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
| TOLERWEIOB | Change to Upper Specification Limit | QTOLWOB | FLTP | 16(16) | QSOLLWERTE | ||||
| TOLWOBNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
| TOLERWEIUN | Change to Lower Specification Limit | QTOLWUN | FLTP | 16(16) | QSOLLWERTE | ||||
| TOLWUNNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
| TOLERWAB | Date from Which the Tolerance Change Is Valid | QTOLWAB | DATS | 8 | DATUM | ||||
| TOLERWBIS | Date Until Which the Tolerance Change Is Valid | QTOLWBIS | DATS | 8 | DATUM | ||||
| STICHPRVER | Sampling Procedure in Inspection Characteristic | QSTICHVERF | CHAR | 8 | QSTPRVER | ||||
| FAKPLANME | Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure | QUMREN | FLTP | 16(16) | QUMRENFAK | ||||
| FAKPROBME | Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure | QUMRENPME | FLTP | 16(16) | QUMRENFAK | ||||
| PROBEMGEH | Sample Unit of Measure | QPROBME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| PRUEFEINH | Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) | QPROBEFAK | DEC | 5(2) | QPROBEFAK | ||||
| DYNKRIT | String for Dynamic Modification Criteria (Database Relevant) | QDYNSTRING | CHAR | 10 | QDYNSTRING | ||||
| FORMELSL | Check and Calculate Formula in QM | QFORMELSL | CHAR | 1 | QFORMELSL | ||||
| FORMEL1 | Formula Field | QFORMEL | CHAR | 60 | QFORMEL | ||||
| FORMEL2 | Formula Field | QFORMEL | CHAR | 60 | QFORMEL | ||||
| CODEGR9U | Defect Code Group for Rejection at Lower Tolerance | QCODEGRPU | CHAR | 8 | QCODEGRP | CGP | |||
| CODE9U | Defect Code for Rejection at Lower Specification Limit | QCODEU | CHAR | 4 | QCODE | ||||
| CODEVR9U | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
| CODEGR9O | Defect Code Group for Rejection at Upper Tolerance | QCODEGRPO | CHAR | 8 | QCODEGRP | CGP | |||
| CODE9O | Defect Code for Rejection at Upper Specification Limit | QCODEO | CHAR | 4 | QCODE | ||||
| CODEVR9O | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
| DUMMY10 | Text Line for Additional Information | QTXT10 | CHAR | 10 | QTXT10 | ||||
| DUMMY20 | Text Line for Additional Information | QTXT20 | CHAR | 20 | QTXT20 | ||||
| DUMMY40 | Text Line for Additional Information | QTXT40 | CHAR | 40 | QTXT40 | ||||
| EEANTVERF | Fraction Calculation | QEANTVERF | CHAR | 2 | TQ72 | QEANTVERF |
| Key field | Non-key field |
How do I retrieve data from SAP table ENT5790 using ABAP code
The following ABAP code Example will allow you to do a basic selection on ENT5790 to SELECT all data from the tableDATA: WA_ENT5790 TYPE ENT5790.
SELECT SINGLE *
FROM ENT5790
INTO CORRESPONDING FIELDS OF WA_ENT5790
WHERE...
How to access SAP table ENT5790
Within an ECC or HANA version of SAP you can also view further information about ENT5790 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects