ESH_N_DEFECT

DDL: ESH_N_DEFECT SQL: ESH_L_DEFECT Type: view Package: BSESH_QM_QN

Anchor view -DEFECT

ESH_N_DEFECT is a CDS View that provides data about "Anchor view -DEFECT" in SAP S/4HANA. It reads from 1 data source (I_DEFECT) and exposes 37 fields with key field DEFECTINTERNALID. It has 1 association to related views. Part of development package BSESH_QM_QN.

1 data source(s) 37 fields

Data Sources (1)

SourceAliasJoin Type
I_DEFECT I_DEFECT from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..*] dd07t _DEFECTSTATUS $projection.DefectLifecycleStatus=_DEFECTSTATUS.domvalue_l and _DEFECTSTATUS.domname='QDEFLCYCLESTAT' and _DEFECTSTATUS.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_DEFECT view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY DEFECTINTERNALID DEFECTINTERNALID
BATCH BATCH
CREATEDBYUSER CREATEDBYUSER
CREATIONDATE CREATIONDATE
CREATIONTIME CREATIONTIME
DEFECTCATEGORY DEFECTCATEGORY
DEFECTCATEGORYTEXT
DEFECTCLASS DEFECTCLASS
DEFECTCLASSTEXT
DEFECTCODE DEFECTCODE
DEFECTCODEGROUP DEFECTCODEGROUP
DEFECTCODEGROUPTEXT
DEFECTCODETEXT
DEFECTLIFECYCLESTATUS DEFECTLIFECYCLESTATUS
DEFECTLIFECYCLESTATUSTEXT
DEFECTLONGTEXT
DEFECTTEXT DEFECTTEXT
INSPECTIONLOT INSPECTIONLOT
INSPECTIONLOTTEXT _INSPECTIONLOT INSPECTIONLOTTEXT
ISBUSINESSPURPOSECOMPLETED _INSPECTIONLOT ISBUSINESSPURPOSECOMPLETED
ISDELETED ISDELETED
LASTCHANGEDATE LASTCHANGEDATE
LASTCHANGEDBYUSER LASTCHANGEDBYUSER
LASTCHANGETIME LASTCHANGETIME
MAINWORKCENTER MAINWORKCENTER
MAINWORKCENTERPLANT MAINWORKCENTERPLANT
MANUFACTURINGORDERCATEGORY _MANUFACTURINGORDER MANUFACTURINGORDERCATEGORY
MANUFACTURINGORDERTEXT _MANUFACTURINGORDER MANUFACTURINGORDERTEXT
MANUFACTURINGORDERTYPE _MANUFACTURINGORDER MANUFACTURINGORDERTYPE
MANUFACTURINGORDERTYPENAME
MATERIAL MATERIAL
PLANT PLANT
PLANTNAME _PLANT PLANTNAME
PRODUCTIONORDER PRODUCTIONORDER
PRODUCTNAME
QUALITYISSUEREFERENCE QUALITYISSUEREFERENCE
WORKCENTERTEXT 
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'ESH_L_DEFECT'
define view ESH_N_DEFECT
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_DEFECT
association [0..*] to dd07t as _DEFECTSTATUS on  $projection.DefectLifecycleStatus=_DEFECTSTATUS.domvalue_l and  _DEFECTSTATUS.domname='QDEFLCYCLESTAT' and  _DEFECTSTATUS.as4local='A'  {

key DEFECTINTERNALID,

BATCH,

CREATEDBYUSER,

CREATIONDATE,

CREATIONTIME,

DEFECTCATEGORY,

_DEFECTCATEGORY._TEXT[1: LANGUAGE = $parameters. P_Language].DEFECTCATEGORYTEXT,

DEFECTCLASS,

_DEFECTCLASS._TEXT[1: LANGUAGE = $parameters. P_Language].DEFECTCLASSTEXT,

DEFECTCODE,

DEFECTCODEGROUP,

_DEFECTCODEGROUP._TEXT[1: LANGUAGE = $parameters. P_Language].DEFECTCODEGROUPTEXT,

_DEFECTCODE._TEXT[1: LANGUAGE = $parameters. P_Language].DEFECTCODETEXT,

DEFECTLIFECYCLESTATUS,

_DEFECTSTATUS[1: ddlanguage = $parameters. P_Language].ddtext as DEFECTLIFECYCLESTATUSTEXT,

_DEFECTLONGTEXT[1: LANGUAGE = $parameters. P_Language].DEFECTLONGTEXT,

DEFECTTEXT,

INSPECTIONLOT,

_INSPECTIONLOT.INSPECTIONLOTTEXT,

_INSPECTIONLOT.ISBUSINESSPURPOSECOMPLETED,

ISDELETED,

LASTCHANGEDATE,

LASTCHANGEDBYUSER,

LASTCHANGETIME,

MAINWORKCENTER,

MAINWORKCENTERPLANT,

_MANUFACTURINGORDER.MANUFACTURINGORDERCATEGORY,

_MANUFACTURINGORDER.MANUFACTURINGORDERTEXT,

_MANUFACTURINGORDER.MANUFACTURINGORDERTYPE,

_MANUFACTURINGORDER._MFGORDERTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].MANUFACTURINGORDERTYPENAME,

MATERIAL,

PLANT,

_PLANT.PLANTNAME,

PRODUCTIONORDER,

_PRODUCT._TEXT[1: LANGUAGE = $parameters. P_Language].PRODUCTNAME,

QUALITYISSUEREFERENCE,

_WORKCENTER._WORKCENTER._WORKCENTERTEXTBYSEMANTICKEY[1: LANGUAGE = $parameters. P_Language].WORKCENTERTEXT
}where ISDELETED <> 'X'

Learn More