ESH_S_DEFECT

DDL: ESH_S_DEFECT SQL: ESH_U_DEFECT Type: view
36 Fields 1 Data Sources

ESH_S_DEFECT is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_DEFECT) and exposes 36 fields with key field DEFECTINTERNALID.

Data Sources (1)

SourceAliasJoin Type
ESH_N_DEFECT ESH_N_DEFECT from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (18)

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
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name Defect view
UI.headerInfo.typeName Defect view
UI.headerInfo.typeNamePlural Defects view
Consumption.semanticObject Defect view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value DEFECTINTERNALID view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_DEFECT view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY DEFECTINTERNALID DEFECTINTERNALID Internal Defect ID
BATCH BATCH Lot No.
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATE CREATIONDATE Time Stamp
CREATIONTIME CREATIONTIME Time of Change
DEFECTCATEGORY DEFECTCATEGORY
DEFECTCLASS DEFECTCLASS Defect Class
DEFECTCLASSTEXT DEFECTCLASSTEXT Defect Class Text
DEFECTCODE DEFECTCODE Damage Code
DEFECTCODEGROUP DEFECTCODEGROUP Code Group
DEFECTCODEGROUPTEXT DEFECTCODEGROUPTEXT Defect Code Group Text
DEFECTCODETEXT DEFECTCODETEXT Defect Code Text
DEFECTLIFECYCLESTATUS DEFECTLIFECYCLESTATUS
DEFECTLIFECYCLESTATUSTEXT DEFECTLIFECYCLESTATUSTEXT Defect Status Text
DEFECTLONGTEXT DEFECTLONGTEXT Defect Detailed Description
DEFECTTEXT DEFECTTEXT Defect Description
INSPECTIONLOT INSPECTIONLOT Inspection Lot
INSPECTIONLOTTEXT INSPECTIONLOTTEXT Inspection Lot Text
ISBUSINESSPURPOSECOMPLETED ISBUSINESSPURPOSECOMPLETED Purpose Completed
ISDELETED ISDELETED TRUE
LASTCHANGEDATE LASTCHANGEDATE Time Stamp
LASTCHANGEDBYUSER LASTCHANGEDBYUSER User Name
LASTCHANGETIME LASTCHANGETIME Time changed
MAINWORKCENTER MAINWORKCENTER Work Center
MAINWORKCENTERPLANT MAINWORKCENTERPLANT Plnt WorkCenter
MANUFACTURINGORDERCATEGORY MANUFACTURINGORDERCATEGORY
MANUFACTURINGORDERTEXT MANUFACTURINGORDERTEXT Manufacturing Order Text
MANUFACTURINGORDERTYPE MANUFACTURINGORDERTYPE
MANUFACTURINGORDERTYPENAME MANUFACTURINGORDERTYPENAME Order Type Text
MATERIAL MATERIAL Vehicle Model
PLANT PLANT Valuation Area
PLANTNAME PLANTNAME Plant Name
PRODUCTIONORDER PRODUCTIONORDER Manufacturing Order
PRODUCTNAME PRODUCTNAME Defective Material Text
QUALITYISSUEREFERENCE QUALITYISSUEREFERENCE Reference Number
WORKCENTERTEXT WORKCENTERTEXT Work Center Text

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_S_DEFECT.
-- 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_U_DEFECT
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_DEFECT AS
SELECT
  DEFECTINTERNALID,
  BATCH,
  CREATEDBYUSER,
  CREATIONDATE,
  CREATIONTIME,
  DEFECTCATEGORY,
  DEFECTCLASS,
  DEFECTCLASSTEXT,
  DEFECTCODE,
  DEFECTCODEGROUP,
  DEFECTCODEGROUPTEXT,
  DEFECTCODETEXT,
  DEFECTLIFECYCLESTATUS,
  DEFECTLIFECYCLESTATUSTEXT,
  DEFECTLONGTEXT,
  DEFECTTEXT,
  INSPECTIONLOT,
  INSPECTIONLOTTEXT,
  ISBUSINESSPURPOSECOMPLETED,
  ISDELETED,
  LASTCHANGEDATE,
  LASTCHANGEDBYUSER,
  LASTCHANGETIME,
  MAINWORKCENTER,
  MAINWORKCENTERPLANT,
  MANUFACTURINGORDERCATEGORY,
  MANUFACTURINGORDERTEXT,
  MANUFACTURINGORDERTYPE,
  MANUFACTURINGORDERTYPENAME,
  MATERIAL,
  PLANT,
  PLANTNAME,
  PRODUCTIONORDER,
  PRODUCTNAME,
  QUALITYISSUEREFERENCE,
  WORKCENTERTEXT
FROM ESH_N_DEFECT
;

Learn More