PLMM_QUEST_RES
Audit Question/Reply List/Item
PLMM_QUEST_RES is an SAP database table in S/4HANA. Audit Question/Reply List/Item. It contains 64 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_FMEANode | view | from | EXTENSION | Function or other node of FMEA Extension |
| I_FMEANode | view | from | BASIC | Function or other node of FMEA |
Fields (64)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | guid | PLMT_AUDIT_QUEST_GUID | Audit Question | |||
| project_guid | PLMT_AUDIT_GUID | Audit | ||||
| old_guid | PLMT_QUEST_GUID | Question List | ||||
| original_langu | PLMT_ORIGINAL_LANGU_QUEST | Original Lang. | ||||
| auth_group | PLMT_AUTH_GROUP | Authoriz. Group | ||||
| hierarchy_profil | PLMT_HIERARCHY_PROFIL | Hierarchy Prof. | ||||
| quest_changeable | PLMT_QUEST_CHANGEABLE | Changeability | ||||
| listtyp | PLMT_TV_LISTTYP | List Type | ||||
| hierarchy_level | PLMT_HIERARCHY_LEVEL | Hier. Level | ||||
| node_type | PLMT_NODE_TYPE | Node Type | ||||
| control_quest | PLMT_CONTROL_QUEST | Control | ||||
| control_proc | PLMT_CONTROL_PROC_BADI | Cont. Proc. | ||||
| listityp | PLMT_TV_LISTITYP | Item Type | ||||
| grouping | PLMT_GROUPING | Grouping | ||||
| search_field | PLMT_SEARCH_FIELD | Keyword | ||||
| ext_position | PLMT_EXT_POSITION | External Item | ||||
| assessm_profil | PLMT_ASSESSMENT_PROFIL | Valuatn Profile | ||||
| assessment_sug | PLMT_ASSESSMENT_SUGGESTION | Val. Proposal | ||||
| suggestion_score | PLMT_SUGGESTION_SCORE | ValuatnProposal | ||||
| audit_calculate | PLMT_AUDIT_CALCULATE | Procedure | ||||
| min_result | PLMT_MIN_RESULT | Minimum Result | ||||
| weighting | PLMT_WEIGHTING | Weighting | ||||
| priority | PLMT_PRIORITY | Priority | ||||
| unplanned_item | PLMT_UNPLANNED_ITEM | Unplanned Entry | ||||
| not_relevant | PLMT_NOT_RELEVANT | Not Relevant | ||||
| assessment_rec | PLMT_ASSESSMENT_REC | Val. Entered | ||||
| assessment_res | PLMT_ASSESSMENT_RESULT | Valuation | ||||
| score_rec | PLMT_SCORE_RECORDED | No. of Points | ||||
| score_res | PLMT_SCORE_RESULT | Calc. Result | ||||
| score_manual | PLMT_SCORE_MANUAL | Res. Corrected | ||||
| score_max | PLMT_SCORE_MAX | Max. Points | ||||
| result_percent | PLMT_RESULT_PERCENT | Deg. of Fulfill | ||||
| corr_required | PLMT_CORR_REQUIRED | Action Required | ||||
| controlled | PLMT_CONTROLLED | Qst. Controlled | ||||
| classification_code | PLMT_CLASSIFICATION_CODE | Rating | ||||
| quest_ref_guid | PLMT_QUEST_REF_GUID | GUID Link | ||||
| reference | PLMT_TV_REFERENCE | Object | ||||
| reference_obtyp | CGPL_OBJECT_TYPE | Object Type | ||||
| changeddatetime | TZNTSTMPS | Time Stamp | ||||
| txt_has_fact | PLMT_AUDIT_TEXT_HAS_FACT | Findings | ||||
| txt_has_posi | PLMT_AUDIT_TEXT_HAS_POSI | Strengths | ||||
| txt_has_nega | PLMT_AUDIT_TEXT_HAS_NEGA | Has Potential | ||||
| rbnr | PLMT_TV_CAT_PROFILE | Catalog Profile | ||||
| katalgart | QKATAUSW | Catalog Type | ||||
| gruppe | QCODEGRP | Code Group | ||||
| code | QCODE | Code | ||||
| version | QVERSNR | Version | ||||
| fekat | FEKAT | Defect types | ||||
| urkat | URKAT | Catalog type | ||||
| functioncat | PLMT_TV_FUNCTIONCAT | Funct. Catalog | ||||
| effectcat | PLMT_TV_EFFECTCAT | Effects Catalog | ||||
| makat | MAKAT | Catalog type | ||||
| verwmerkm | QMERKNR | Master IC | ||||
| qpmk_werks | QZAEHLER | Plant | ||||
| merkgew | QMERKGEW | Weighting | ||||
| char_type | PLMT_TV_CHAR_TYPE | Char. Type | ||||
| template_guid | PLMT_QUEST_GUID | Question List | ||||
| qmnum | QMNUM | Notification | ||||
| fenum | FENUM | Item | ||||
| urnum | URNUM | Cause | ||||
| manum | MANUM | Task | ||||
| ref_decoupled | PLMT_REF_DECOUPLED | Val. Decoupled | ||||
| dummy_fmea_listitm_incl_eew_ps | DUMMY | Dummy function in length 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Audit Question/Reply List/Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLMM_QUEST_RES (
CLIENT, -- Client [MANDT]
GUID, -- Audit Question [PLMT_AUDIT_QUEST_GUID]
PROJECT_GUID, -- Audit [PLMT_AUDIT_GUID]
OLD_GUID, -- Question List [PLMT_QUEST_GUID]
ORIGINAL_LANGU, -- Original Lang. [PLMT_ORIGINAL_LANGU_QUEST]
AUTH_GROUP, -- Authoriz. Group [PLMT_AUTH_GROUP]
HIERARCHY_PROFIL, -- Hierarchy Prof. [PLMT_HIERARCHY_PROFIL]
QUEST_CHANGEABLE, -- Changeability [PLMT_QUEST_CHANGEABLE]
LISTTYP, -- List Type [PLMT_TV_LISTTYP]
HIERARCHY_LEVEL, -- Hier. Level [PLMT_HIERARCHY_LEVEL]
NODE_TYPE, -- Node Type [PLMT_NODE_TYPE]
CONTROL_QUEST, -- Control [PLMT_CONTROL_QUEST]
CONTROL_PROC, -- Cont. Proc. [PLMT_CONTROL_PROC_BADI]
LISTITYP, -- Item Type [PLMT_TV_LISTITYP]
GROUPING, -- Grouping [PLMT_GROUPING]
SEARCH_FIELD, -- Keyword [PLMT_SEARCH_FIELD]
EXT_POSITION, -- External Item [PLMT_EXT_POSITION]
ASSESSM_PROFIL, -- Valuatn Profile [PLMT_ASSESSMENT_PROFIL]
ASSESSMENT_SUG, -- Val. Proposal [PLMT_ASSESSMENT_SUGGESTION]
SUGGESTION_SCORE, -- ValuatnProposal [PLMT_SUGGESTION_SCORE]
AUDIT_CALCULATE, -- Procedure [PLMT_AUDIT_CALCULATE]
MIN_RESULT, -- Minimum Result [PLMT_MIN_RESULT]
WEIGHTING, -- Weighting [PLMT_WEIGHTING]
PRIORITY, -- Priority [PLMT_PRIORITY]
UNPLANNED_ITEM, -- Unplanned Entry [PLMT_UNPLANNED_ITEM]
NOT_RELEVANT, -- Not Relevant [PLMT_NOT_RELEVANT]
ASSESSMENT_REC, -- Val. Entered [PLMT_ASSESSMENT_REC]
ASSESSMENT_RES, -- Valuation [PLMT_ASSESSMENT_RESULT]
SCORE_REC, -- No. of Points [PLMT_SCORE_RECORDED]
SCORE_RES, -- Calc. Result [PLMT_SCORE_RESULT]
SCORE_MANUAL, -- Res. Corrected [PLMT_SCORE_MANUAL]
SCORE_MAX, -- Max. Points [PLMT_SCORE_MAX]
RESULT_PERCENT, -- Deg. of Fulfill [PLMT_RESULT_PERCENT]
CORR_REQUIRED, -- Action Required [PLMT_CORR_REQUIRED]
CONTROLLED, -- Qst. Controlled [PLMT_CONTROLLED]
CLASSIFICATION_CODE, -- Rating [PLMT_CLASSIFICATION_CODE]
QUEST_REF_GUID, -- GUID Link [PLMT_QUEST_REF_GUID]
REFERENCE, -- Object [PLMT_TV_REFERENCE]
REFERENCE_OBTYP, -- Object Type [CGPL_OBJECT_TYPE]
CHANGEDDATETIME, -- Time Stamp [TZNTSTMPS]
TXT_HAS_FACT, -- Findings [PLMT_AUDIT_TEXT_HAS_FACT]
TXT_HAS_POSI, -- Strengths [PLMT_AUDIT_TEXT_HAS_POSI]
TXT_HAS_NEGA, -- Has Potential [PLMT_AUDIT_TEXT_HAS_NEGA]
RBNR, -- Catalog Profile [PLMT_TV_CAT_PROFILE]
KATALGART, -- Catalog Type [QKATAUSW]
GRUPPE, -- Code Group [QCODEGRP]
CODE, -- Code [QCODE]
VERSION, -- Version [QVERSNR]
FEKAT, -- Defect types [FEKAT]
URKAT, -- Catalog type [URKAT]
FUNCTIONCAT, -- Funct. Catalog [PLMT_TV_FUNCTIONCAT]
EFFECTCAT, -- Effects Catalog [PLMT_TV_EFFECTCAT]
MAKAT, -- Catalog type [MAKAT]
VERWMERKM, -- Master IC [QMERKNR]
QPMK_WERKS, -- Plant [QZAEHLER]
MERKGEW, -- Weighting [QMERKGEW]
CHAR_TYPE, -- Char. Type [PLMT_TV_CHAR_TYPE]
TEMPLATE_GUID, -- Question List [PLMT_QUEST_GUID]
QMNUM, -- Notification [QMNUM]
FENUM, -- Item [FENUM]
URNUM, -- Cause [URNUM]
MANUM, -- Task [MANUM]
REF_DECOUPLED, -- Val. Decoupled [PLMT_REF_DECOUPLED]
DUMMY_FMEA_LISTITM_INCL_EEW_PS, -- Dummy function in length 1 [DUMMY]
PRIMARY KEY (CLIENT, GUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA