I_InspectionLotWithStatus

DDL: I_INSPECTIONLOTWITHSTATUS SQL: IINSPLOTWSTS Type: view COMPOSITE
14 Fields 1 Data Sources

Inspection Lot with Status

I_InspectionLotWithStatus is a Composite CDS View that provides data about "Inspection Lot with Status" in SAP S/4HANA. It reads from 1 data source (I_InspectionLot) and exposes 14 fields with key field InspectionLot.

Data Sources (1)

SourceAliasJoin Type
I_InspectionLot I_InspectionLot from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IINSPLOTWSTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Inspection Lot with Status view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey InspectionLot view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
StatusObject I_InspectionLot StatusObject Status Object
InspectionLotStatusCreated _Status001 StatusCode Statuscode
InspectionLotStatusReleased _Status002 StatusCode Statuscode
InspectionLotStatusSkip _Status209 StatusCode Statuscode
InspLotStatusRsltsConfirmed _Status213 StatusCode Statuscode
InspLotStsDefectsRecorded _Status214 StatusCode Statuscode
InspLotStsShrtTrmInspCmpltd _Status216 StatusCode Statuscode
InspLotStatusInspCompleted _Status217 StatusCode Statuscode
InspLotStatusCanceled _Status224 StatusCode Statuscode
InspLotStatusRepair _Status400 StatusCode Statuscode
Plant I_InspectionLot Plant Valuation Area
InspectionLotType I_InspectionLot InspectionLotType Inspection Type
MatlQualityAuthorizationGroup I_InspectionLot MatlQualityAuthorizationGroup QM Matl Auth.

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 I_InspectionLotWithStatus.
-- 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: IINSPLOTWSTS

CREATE VIEW I_InspectionLotWithStatus AS
SELECT
  InspectionLot,
  I_InspectionLot.StatusObject AS StatusObject,
  _Status001.StatusCode AS InspectionLotStatusCreated,
  _Status002.StatusCode AS InspectionLotStatusReleased,
  _Status209.StatusCode AS InspectionLotStatusSkip,
  _Status213.StatusCode AS InspLotStatusRsltsConfirmed,
  _Status214.StatusCode AS InspLotStsDefectsRecorded,
  _Status216.StatusCode AS InspLotStsShrtTrmInspCmpltd,
  _Status217.StatusCode AS InspLotStatusInspCompleted,
  _Status224.StatusCode AS InspLotStatusCanceled,
  _Status400.StatusCode AS InspLotStatusRepair,
  I_InspectionLot.Plant AS Plant,
  I_InspectionLot.InspectionLotType AS InspectionLotType,
  I_InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup
FROM I_InspectionLot
;

Learn More