ESH_N_INSPECTIONSUBSETSFI

DDL: ESH_N_INSPECTIONSUBSETSFI SQL: ESH_L_INSPSUBS4 Type: view
33 Fields 1 Data Sources 1 Associations

ESH_N_INSPECTIONSUBSETSFI is a CDS View in SAP S/4HANA. It reads from 1 data source (I_INSPECTIONSUBSET) and exposes 33 fields with key fields INSPECTIONLOT, INSPECTIONSUBSETINTERNALID, INSPPLANOPERATIONINTERNALID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_INSPECTIONSUBSET I_INSPECTIONSUBSET from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..*] dd07t _INSPSUBSETUSAGEDCSNVALN $projection.InspSubsetUsageDcsnValuation=_INSPSUBSETUSAGEDCSNVALN.domvalue_l and _INSPSUBSETUSAGEDCSNVALN.domname='QBEWERTUNG' and _INSPSUBSETUSAGEDCSNVALN.as4local='A'

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ESH_L_INSPSUBS4 view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY INSPECTIONLOT INSPECTIONLOT Inspection Lot
KEY INSPECTIONSUBSETINTERNALID INSPECTIONSUBSETINTERNALID Sample Number
KEY INSPPLANOPERATIONINTERNALID INSPPLANOPERATIONINTERNALID Node Number
CREATIONDATE CREATIONDATE Time Stamp
CREATIONTIME CREATIONTIME Time of Change
INSPECTIONLOTTYPE _INSPECTIONLOT INSPECTIONLOTTYPE Inspection Type
INSPECTIONLOTTYPETEXT
INSPECTIONOPERATION _INSPECTIONOPERATION INSPECTIONOPERATION
INSPECTIONSUBSETDATE INSPECTIONSUBSETDATE
INSPECTIONSUBSETLONGCHARKEY INSPECTIONSUBSETLONGCHARKEY
INSPECTIONSUBSETSHORTCHARKEY INSPECTIONSUBSETSHORTCHARKEY
INSPECTIONSUBSETSORTKEY INSPECTIONSUBSETSORTKEY Inspection pt
INSPECTIONSUBSETTIME INSPECTIONSUBSETTIME
INSPECTIONSUBSETTYPE _INSPECTIONLOT INSPECTIONSUBSETTYPE
INSPLOTUSGEDCSNVALUATIONTEXT
INSPSUBSETDATEFIELDNAME
INSPSUBSETFIELDCOMBINATION
INSPSUBSETFLDCOMBINATIONTXT
INSPSUBSETLONGTXTFIELDNAME
INSPSUBSETSHORTTXTFIELDNAME
INSPSUBSETTIMEFIELDNAME
INSPSUBSETUSAGEDCSNVALUATION INSPSUBSETUSAGEDCSNVALUATION Code Valuation
ISBUSINESSPURPOSECOMPLETED _INSPECTIONLOT ISBUSINESSPURPOSECOMPLETED Purpose Completed
MATERIAL _SHOPFLOORITEM MATERIAL Vehicle Model
MATERIALNAME
MATLQUALITYAUTHORIZATIONGROUP _INSPECTIONLOT MATLQUALITYAUTHORIZATIONGROUP QM Matl Auth.
OPERATIONTEXT _INSPECTIONOPERATION OPERATIONTEXT Description
PLANT _INSPECTIONLOT PLANT Valuation Area
SHOPFLOORITEM SHOPFLOORITEM Serial.Mat. ID
USAGEDECISIONCODE _USAGEDECISIONCODE USAGEDECISIONCODE
USAGEDECISIONCODETEXT
WORKCENTER
WORKCENTERTEXT

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_INSPECTIONSUBSETSFI.
-- 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_INSPSUBS4
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_INSPECTIONSUBSETSFI AS
SELECT
  INSPECTIONLOT,
  INSPECTIONSUBSETINTERNALID,
  INSPPLANOPERATIONINTERNALID,
  CREATIONDATE,
  CREATIONTIME,
  _INSPECTIONLOT.INSPECTIONLOTTYPE AS INSPECTIONLOTTYPE,
  _INSPECTIONLOT._INSPECTIONLOTTYPE._TEXT[1: Language = $parameters. P_Language].INSPECTIONLOTTYPETEXT AS INSPECTIONLOTTYPETEXT,
  _INSPECTIONOPERATION.INSPECTIONOPERATION AS INSPECTIONOPERATION,
  INSPECTIONSUBSETDATE,
  INSPECTIONSUBSETLONGCHARKEY,
  INSPECTIONSUBSETSHORTCHARKEY,
  INSPECTIONSUBSETSORTKEY,
  INSPECTIONSUBSETTIME,
  _INSPECTIONLOT.INSPECTIONSUBSETTYPE AS INSPECTIONSUBSETTYPE,
  _INSPSUBSETUSAGEDCSNVALN[1: ddlanguage = $parameters. P_Language].ddtext AS INSPLOTUSGEDCSNVALUATIONTEXT,
  _INSPECTIONLOT._INSPSUBSETFIELDCOMBINATION._TEXT[1: Language = $parameters. P_Language].INSPSUBSETDATEFIELDNAME AS INSPSUBSETDATEFIELDNAME,
  _INSPECTIONLOT._INSPSUBSETFIELDCOMBINATION.INSPSUBSETFIELDCOMBINATION AS INSPSUBSETFIELDCOMBINATION,
  _INSPECTIONLOT._INSPSUBSETFIELDCOMBINATION._TEXT[1: Language = $parameters. P_Language].INSPSUBSETFLDCOMBINATIONTXT AS INSPSUBSETFLDCOMBINATIONTXT,
  _INSPECTIONLOT._INSPSUBSETFIELDCOMBINATION._TEXT[1: Language = $parameters. P_Language].INSPSUBSETLONGTXTFIELDNAME AS INSPSUBSETLONGTXTFIELDNAME,
  _INSPECTIONLOT._INSPSUBSETFIELDCOMBINATION._TEXT[1: Language = $parameters. P_Language].INSPSUBSETSHORTTXTFIELDNAME AS INSPSUBSETSHORTTXTFIELDNAME,
  _INSPECTIONLOT._INSPSUBSETFIELDCOMBINATION._TEXT[1: Language = $parameters. P_Language].INSPSUBSETTIMEFIELDNAME AS INSPSUBSETTIMEFIELDNAME,
  INSPSUBSETUSAGEDCSNVALUATION,
  _INSPECTIONLOT.ISBUSINESSPURPOSECOMPLETED AS ISBUSINESSPURPOSECOMPLETED,
  _SHOPFLOORITEM.MATERIAL AS MATERIAL,
  _SHOPFLOORITEM._MATERIAL._TEXT[1: Language = $parameters. P_Language].MATERIALNAME AS MATERIALNAME,
  _INSPECTIONLOT.MATLQUALITYAUTHORIZATIONGROUP AS MATLQUALITYAUTHORIZATIONGROUP,
  _INSPECTIONOPERATION.OPERATIONTEXT AS OPERATIONTEXT,
  _INSPECTIONLOT.PLANT AS PLANT,
  SHOPFLOORITEM,
  _USAGEDECISIONCODE.USAGEDECISIONCODE AS USAGEDECISIONCODE,
  _USAGEDECISIONCODE._TEXT[1: Language = $parameters. P_Language].USAGEDECISIONCODETEXT AS USAGEDECISIONCODETEXT,
  _INSPECTIONOPERATION._WORKCENTER.WORKCENTER AS WORKCENTER,
  _INSPECTIONOPERATION._WORKCENTER._TEXT[1: Language = $parameters. P_Language].WORKCENTERTEXT AS WORKCENTERTEXT
FROM I_INSPECTIONSUBSET
LEFT OUTER JOIN dd07t AS _INSPSUBSETUSAGEDCSNVALN ON InspSubsetUsageDcsnValuation=_INSPSUBSETUSAGEDCSNVALN.domvalue_l AND _INSPSUBSETUSAGEDCSNVALN.domname='QBEWERTUNG' AND _INSPSUBSETUSAGEDCSNVALN.as4local='A'  -- association [0..*]
;

Learn More