Overview

This command will list the requirement mappings and the applicability and implementation results of the entire requirement structure. It allows a summarized vision of the requirement mapping.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
RQMAPPINGREVISION	Table that stores the requirement mapping revision data	CDOBJECT CDREVISION	GNREVISION ADALLUSERS ADTEAM RQMAPPINGCONFIG GNTYPEROLE ADDEPARTMENT GNASSOC OBOBJECT GNSUPPLIER
RQREVISION	Table that stores the requirement revision data	CDREQUIREMENT CDREVISION	RQTYPE GNFAVORITE ADALLUSERS ADTEAM RQREQUIREMENT
RQMAPPINGCONFIG	Requirement mapping configuration table	CDGENTYPE	GNGENTYPE RQTYPE GNEVAL ADDEPARTMENT
RQMAPPINGANALYSIS	Table that stores the requirement mappings	CDMAPPINGANALYSIS	RQREQUIREMENT RQMAPPINGREVISION ADDEPARTMENT PMPROCESS ADDEPARTMENT GNASSOC GNEVALRESULTUSED
RQMAPPINGREQM	Association table between the requirement mapping and the requirement	CDMAPPING CDMAPPINGREVISION CDREQUIREMENT CDREQUIREMENTREV	RQMAPPINGREVISION RQREVISION
RQREQUIREMENT	Requirement record table	CDREQUIREMENT CDREVISION	GNREVISION GNASSOC DCDOCUMENT
RQMAPCOVERAGE	Stores the requirement mapping coverage level	CDMAPCOVERAGE	RQREQUIREMENT RQMAPPINGREVISION ADDEPARTMENT GNEVALRESULTUSED
RQMAPPINGDEPT	Table of the association of departments with the requirement mapping	CDMAPPING CDMAPPINGREVISION CDDEPARTMENT	RQMAPPINGREVISION ADDEPARTMENT
GNREVISION	Revisions	CDREVISION	GNASSOC GNACTIONASSOC GNREVCONFIG GNREASON GNREVISIONSTATUS ADALLUSERS
GNGENTYPE	Generic type	CDGENTYPE	GNELETRONICFILECFG GNEVAL GNFAVORITE GNREVCONFIG GNMASK GNTYPEROLE ADCHECKLIST GNASSOC GNACTIVITYTIMECFG GNMASK GNTYPEROLE GNTRANSLATION GNSECURITY
GNSUPPLIER	Table for the generic supplier record	CDSUPPLIER	CDCOMPANY CDASSOC CDSUPPLIERTYPE CDCOMPLEXFILECONT
GNEVALRESULTUSED	Result of used evaluations	CDEVALRESULTUSED	GNEVALRESULT
GNEVALRESULT	Evaluation method results	CDEVALRESULT	GNEVALREVISION
ADCOMPANY	Customer/Supplier companies	CDCOMPANY	ADCOMPANYTYPE
ADDEPARTMENT	Business unit and department record	CDDEPARTMENT	GNFAVORITE ADALLUSERS COWORKSPACE ADTEAM ADDEPARTMENT GNASSOC GNMAPPING
OBOBJECT	Base object table	CDOBJECT CDREVISION	OBSUBREASON GNASSOC GNREVISION OBOBJECTGROUP ADTEAM

Oracle/Postgres/SQL Server

SELECT RQMAPPINGREVISION.FGOBJECTMAP,
   GNGENTYPE.IDGENTYPE,
   GNGENTYPE.NMGENTYPE,
   RQMAPPINGREVISION.IDMAPPING,
   RQMAPPINGREVISION.NMMAPPING,
   FATHER.IDREQUIREMENT AS IDREQREFERENCE,
   FATHER.NMREQUIREMENT AS NMREQREFERENCE,
   REQUIREMENTS.FGREQMODEL,
   REQUIREMENTS.IDREQUIREMENT,
   REQUIREMENTS.NMREQUIREMENT,
   GNEVALRESULT.NMEVALRESULT,
   RQMAPCOVERAGE.QTAPPLY,
   RQMAPCOVERAGE.QTAPPLYTOTAL - RQMAPCOVERAGE.QTAPPLY AS QTNOTAPPLY,
   RQMAPCOVERAGE.VLIMPLEMENTED,
   RQMAPPINGANALYSIS.DSJUSTIFY,
   ADBU.IDDEPARTMENT AS IDBUSINESSUNIT,
   ADBU.NMDEPARTMENT AS NMBUSINESSUNIT,
   ADAREA.IDDEPARTMENT AS IDAREA,
   ADAREA.NMDEPARTMENT AS NMAREA,
   OBOBJECT.IDOBJECT,
   OBOBJECT.NMOBJECT,
   ADCOMPANY.IDCOMMERCIAL,
   ADCOMPANY.NMCOMPANY
FROM RQMAPPINGREVISION
     INNER JOIN GNREVISION ON GNREVISION.CDREVISION = RQMAPPINGREVISION.CDREVISION
     INNER JOIN RQMAPPINGCONFIG ON RQMAPPINGCONFIG.CDGENTYPE = RQMAPPINGREVISION.CDGENTYPE
     INNER JOIN GNGENTYPE ON GNGENTYPE.CDGENTYPE=RQMAPPINGCONFIG.CDGENTYPE
     INNER JOIN RQMAPPINGREQM ON RQMAPPINGREQM.CDMAPPING=RQMAPPINGREVISION.CDMAPPING
   AND RQMAPPINGREQM.CDMAPPINGREVISION=RQMAPPINGREVISION.CDREVISION
     INNER JOIN (
   SELECT
   1 AS FGREQMODEL,
   GUIDE.CDREQUIREMENT,
   GUIDE.CDREVISION,
   GUIDE.IDREQUIREMENT,
   GUIDE.NMREQUIREMENT,
   GUIDE.CDREQUIREMENTOWNER,
   GUIDE.CDREQUIREMENTBASE,
   REFG.IDREQUIREMENT AS NMREF
   FROM RQREQUIREMENT GUIDE
   INNER JOIN RQREQUIREMENT REFG ON GUIDE.CDREQUIREMENT=REFG.CDREQUIREMENT
   AND GUIDE.CDREVISION=REFG.CDREVISION
   WHERE GUIDE.CDREQUIREMENTOWNER IS NOT NULL
   AND EXISTS (SELECT 1 FROM RQREQUIREMENT WHERE RQREQUIREMENT.CDREQUIREMENTOWNER = GUIDE.CDREQUIREMENT)
   UNION ALL
   SELECT
   2 AS FGREQMODEL,
   LEAF.CDREQUIREMENT,
   LEAF.CDREVISION,
   LEAF.IDREQUIREMENT,
   LEAF.NMREQUIREMENT,
   LEAF.CDREQUIREMENTOWNER,
   LEAF.CDREQUIREMENTBASE,
   REFL.IDREQUIREMENT AS NMREF
   FROM RQREQUIREMENT LEAF
   INNER JOIN RQREQUIREMENT REFL ON REFL.CDREQUIREMENT=LEAF.CDREQUIREMENT
   AND LEAF.CDREVISION=REFL.CDREVISION
   WHERE LEAF.CDREQUIREMENTOWNER IS NOT NULL
   AND NOT EXISTS (SELECT 1 FROM RQREQUIREMENT WHERE RQREQUIREMENT.CDREQUIREMENTOWNER=LEAF.CDREQUIREMENT)
   ) REQUIREMENTS ON REQUIREMENTS.CDREQUIREMENTBASE = RQMAPPINGREQM.CDREQUIREMENT AND REQUIREMENTS.CDREVISION = RQMAPPINGREQM.CDREQUIREMENTREV
     INNER JOIN RQREVISION ON REQUIREMENTS.CDREVISION = RQREVISION.CDREVISION
     INNER JOIN ADDEPARTMENT ADBU ON RQMAPPINGREVISION.CDBUSINESSUNIT=ADBU.CDDEPARTMENT
     INNER JOIN RQMAPPINGANALYSIS ON RQMAPPINGANALYSIS.CDBUSINESSUNIT IS NOT NULL
   AND RQMAPPINGANALYSIS.CDREQUIREMENT=REQUIREMENTS.CDREQUIREMENT
   AND RQMAPPINGANALYSIS.CDREQUIREMENTREV=REQUIREMENTS.CDREVISION
   AND RQMAPPINGANALYSIS.CDMAPPING=RQMAPPINGREQM.CDMAPPING
   AND RQMAPPINGANALYSIS.CDMAPPINGREVISION=RQMAPPINGREQM.CDMAPPINGREVISION
     LEFT OUTER JOIN RQMAPCOVERAGE ON RQMAPCOVERAGE.CDREQUIREMENT=REQUIREMENTS.CDREQUIREMENT
   AND RQMAPCOVERAGE.CDREQUIREMENTREV=REQUIREMENTS.CDREVISION
   AND RQMAPCOVERAGE.CDMAPPING=RQMAPPINGREQM.CDMAPPING
   AND RQMAPCOVERAGE.CDMAPPINGREVISION=RQMAPPINGREQM.CDMAPPINGREVISION
     LEFT OUTER JOIN RQREQUIREMENT FATHER ON FATHER.CDREQUIREMENT=REQUIREMENTS.CDREQUIREMENTBASE
   AND FATHER.CDREVISION=REQUIREMENTS.CDREVISION
     LEFT OUTER JOIN GNEVALRESULTUSED ON GNEVALRESULTUSED.CDEVALRESULTUSED=RQMAPCOVERAGE.CDEVALRESULTUSED
     LEFT OUTER JOIN GNEVALRESULT ON GNEVALRESULT.CDEVALRESULT = GNEVALRESULTUSED.CDEVALRESULT
     LEFT OUTER JOIN RQMAPPINGDEPT ON RQMAPPINGDEPT.CDMAPPING=RQMAPPINGREVISION.CDMAPPING
   AND RQMAPPINGDEPT.CDMAPPINGREVISION=RQMAPPINGREVISION.CDREVISION
     LEFT OUTER JOIN ADDEPARTMENT ADAREA ON ADAREA.CDDEPARTMENT = RQMAPPINGDEPT.CDDEPARTMENT
     LEFT OUTER JOIN OBOBJECT ON OBOBJECT.CDOBJECT=RQMAPPINGREVISION.CDOBJECT
   AND OBOBJECT.CDREVISION=RQMAPPINGREVISION.CDOBJECTREV
     LEFT OUTER JOIN GNSUPPLIER ON GNSUPPLIER.CDSUPPLIER = RQMAPPINGREVISION.CDSUPPLIER
     LEFT OUTER JOIN ADCOMPANY ON ADCOMPANY.CDCOMPANY = GNSUPPLIER.CDSUPPLIER
WHERE RQMAPPINGREVISION.FGCURRENT = 1 /* NOTE1*/
  AND GNREVISION.FGSTATUS = 6 /* NOTE2*/

Notes

▪1: The FGCURRENT field of the RQMAPPINGREVISION table is used to search for the current revision that is not obsolete.

▪2: The FGSTATUS field of the GNREVISION table indicates the revision status, defined as: 1 = Draft; 2 = Review; 3 = Approval; 4 = Release; 5 = Released; 6 = Closed.

Fields used on the view screen

requirement-05

requirement-06

requirement-07