ESH_N_QUALITYTASK

DDL: ESH_N_QUALITYTASK SQL: ESH_L_QUALITTASK Type: view
35 Fields 1 Data Sources 3 Associations

ESH_N_QUALITYTASK is a CDS View in SAP S/4HANA. It reads from 1 data source (I_QUALITYTASK) and exposes 35 fields with key field QUALITYTASKINTERNALID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_QUALITYTASK I_QUALITYTASK from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (3)

CardinalityTargetAliasCondition
[0..*] dd07t _QLTYTASKFLLWUPACTIONSTS $projection.QltyTaskFllwUpActionSts=_QLTYTASKFLLWUPACTIONSTS.domvalue_l and _QLTYTASKFLLWUPACTIONSTS.domname='QTSKFOASTAT' and _QLTYTASKFLLWUPACTIONSTS.as4local='A'
[0..*] dd07t _QLTYTASKARCHIVINGSTATUS ( $projection.QualityTaskArchivingStatus=_QLTYTASKARCHIVINGSTATUS.domvalue_l AND _QLTYTASKARCHIVINGSTATUS.domname='QTSKACYCLESTAT' AND _QLTYTASKARCHIVINGSTATUS.as4local='A' )
[0..*] dd07t _QUALITYTASKSTATUS ( $projection.QualityTaskLifecycleStatus=_QUALITYTASKSTATUS.domvalue_l AND _QUALITYTASKSTATUS.domname='QTSKLCYCLESTAT' AND _QUALITYTASKSTATUS.as4local='A' )

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_QUALITTASK view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY QUALITYTASKINTERNALID QUALITYTASKINTERNALID
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATE CREATIONDATE Time Stamp
CREATIONTIME CREATIONTIME Time of Change
DEFECTINTERNALID DEFECTINTERNALID Internal Defect ID
DEFECTTEXT _DEFECT DEFECTTEXT
LASTCHANGEDATE LASTCHANGEDATE Time Stamp
LASTCHANGEDBYUSER LASTCHANGEDBYUSER User Name
LASTCHANGETIME LASTCHANGETIME Time changed
NOTIFTASKCOMPLETEDBYUSER NOTIFTASKCOMPLETEDBYUSER
NOTIFTASKCOMPLETIONDATE NOTIFTASKCOMPLETIONDATE
NOTIFTASKCOMPLETIONTIME NOTIFTASKCOMPLETIONTIME
NOTIFTASKPLANNEDENDDATE NOTIFTASKPLANNEDENDDATE
NOTIFTASKPLANNEDENDTIME NOTIFTASKPLANNEDENDTIME
NOTIFTASKTIMEZONE NOTIFTASKTIMEZONE Task Time Zone
PROBSOLVINGPROC PROBSOLVINGPROC Problem-Solving Process
PROBSOLVINGPROCDESC _PROBSOLVINGPROC PROBSOLVINGPROCDESC
QLTYTASKFLLWUPACTIONSTS QLTYTASKFLLWUPACTIONSTS Follow-Up Action Status
QLTYTASKFLLWUPACTIONSTSTXT
QLTYTASKFOLLOWUPACTION QLTYTASKFOLLOWUPACTION Follow-Up Actn
QLTYTASKTIMEBASEDEFFORT QLTYTASKTIMEBASEDEFFORT Time Effort
QLTYTASKTIMEBASEDEFFORTUOM QLTYTASKTIMEBASEDEFFORTUOM Unit
QLTYTSKPROCGISCTRLDBYTSKORIGIN QLTYTSKPROCGISCTRLDBYTSKORIGIN Task Processing Is Controlled by Origin
QUALITYTASKARCHIVINGSTATUS QUALITYTASKARCHIVINGSTATUS Task Archiving Status
QUALITYTASKARCHIVINGSTATUSTEXT
QUALITYTASKCODE QUALITYTASKCODE Task Code
QUALITYTASKCODEGROUP QUALITYTASKCODEGROUP
QUALITYTASKCODEGROUPTEXT
QUALITYTASKCODETEXT
QUALITYTASKLIFECYCLESTATUS QUALITYTASKLIFECYCLESTATUS Task Status
QUALITYTASKLIFECYCLESTATUSTEXT
QUALITYTASKORIGIN QUALITYTASKORIGIN Task Origin
QUALITYTASKORIGINTEXT
QUALITYTASKPROCESSOR QUALITYTASKPROCESSOR User Name
QUALITYTASKTEXT QUALITYTASKTEXT

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ESH_N_QUALITYTASK.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ESH_L_QUALITTASK
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_QUALITYTASK AS
SELECT
  QUALITYTASKINTERNALID,
  CREATEDBYUSER,
  CREATIONDATE,
  CREATIONTIME,
  DEFECTINTERNALID,
  _DEFECT.DEFECTTEXT AS DEFECTTEXT,
  LASTCHANGEDATE,
  LASTCHANGEDBYUSER,
  LASTCHANGETIME,
  NOTIFTASKCOMPLETEDBYUSER,
  NOTIFTASKCOMPLETIONDATE,
  NOTIFTASKCOMPLETIONTIME,
  NOTIFTASKPLANNEDENDDATE,
  NOTIFTASKPLANNEDENDTIME,
  NOTIFTASKTIMEZONE,
  PROBSOLVINGPROC,
  _PROBSOLVINGPROC.PROBSOLVINGPROCDESC AS PROBSOLVINGPROCDESC,
  QLTYTASKFLLWUPACTIONSTS,
  _QLTYTASKFLLWUPACTIONSTS[1: ddlanguage = $parameters. P_Language].ddtext AS QLTYTASKFLLWUPACTIONSTSTXT,
  QLTYTASKFOLLOWUPACTION,
  QLTYTASKTIMEBASEDEFFORT,
  QLTYTASKTIMEBASEDEFFORTUOM,
  QLTYTSKPROCGISCTRLDBYTSKORIGIN,
  QUALITYTASKARCHIVINGSTATUS,
  _QLTYTASKARCHIVINGSTATUS[1: ddlanguage = $parameters. P_Language].ddtext AS QUALITYTASKARCHIVINGSTATUSTEXT,
  QUALITYTASKCODE,
  QUALITYTASKCODEGROUP,
  _QLTYTSKCODEGROUP._QLTYTSKCODEGROUPTEXT[1: Language = $parameters. P_Language].QUALITYTASKCODEGROUPTEXT AS QUALITYTASKCODEGROUPTEXT,
  _QLTYTSKCODE._QLTYTSKCODETEXT[1: Language = $parameters. P_Language].QUALITYTASKCODETEXT AS QUALITYTASKCODETEXT,
  QUALITYTASKLIFECYCLESTATUS,
  _QUALITYTASKSTATUS[1: ddlanguage = $parameters. P_Language].ddtext AS QUALITYTASKLIFECYCLESTATUSTEXT,
  QUALITYTASKORIGIN,
  _QUALITYTASKORIGIN._TEXT[1: Language = $parameters. P_Language].QUALITYTASKORIGINTEXT AS QUALITYTASKORIGINTEXT,
  QUALITYTASKPROCESSOR,
  QUALITYTASKTEXT
FROM I_QUALITYTASK
LEFT OUTER JOIN dd07t AS _QLTYTASKFLLWUPACTIONSTS ON QltyTaskFllwUpActionSts=_QLTYTASKFLLWUPACTIONSTS.domvalue_l AND _QLTYTASKFLLWUPACTIONSTS.domname='QTSKFOASTAT' AND _QLTYTASKFLLWUPACTIONSTS.as4local='A'  -- association [0..*]
LEFT OUTER JOIN dd07t AS _QLTYTASKARCHIVINGSTATUS ON ( QualityTaskArchivingStatus=_QLTYTASKARCHIVINGSTATUS.domvalue_l AND _QLTYTASKARCHIVINGSTATUS.domname='QTSKACYCLESTAT' AND _QLTYTASKARCHIVINGSTATUS.as4local='A' )  -- association [0..*]
LEFT OUTER JOIN dd07t AS _QUALITYTASKSTATUS ON ( QualityTaskLifecycleStatus=_QUALITYTASKSTATUS.domvalue_l AND _QUALITYTASKSTATUS.domname='QTSKLCYCLESTAT' AND _QUALITYTASKSTATUS.as4local='A' )  -- association [0..*]
;

Learn More