I_InspectionLotStdVH

DDL: I_INSPECTIONLOTSTDVH SQL: IIL__VH Type: view COMPOSITE Package: VDM_QM_INSPECTION
5 Fields 1 Data Sources 10 OData Services

Inspection Lot

I_InspectionLotStdVH (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Manufacturing

I_InspectionLotStdVH is a Composite CDS View that provides data about "Inspection Lot" in SAP S/4HANA. It reads from 1 data source (I_InspectionLot) and exposes 5 fields with key field InspectionLot. It is exposed through 10 OData services (ASQL_F2181, ASQL_F2265, ASQL_F2266, ...). Part of development package VDM_QM_INSPECTION.

SAP API Hub

CategoryComposite
StateC1
Line of BusinessManufacturing
Application ComponentQM-IM-2CL
CapabilitiesData Provider for Value Help
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageManufacturing for SAP S/4HANA Cloud Public Edition
Description <p>These views provide value help for inspection lots. They should be used for value help purposes only. If you intend to select the entire business data, use the Inspection Lot view instead.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_InspectionLot I_InspectionLot from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IIL__VH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey InspectionLot view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Consumption.ranked true view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Inspection Lot view

OData Services (10)

ServiceBindingVersionContractRelease
ASQL_F2181 ASQL_F2181 C2 NOT_RELEASED
ASQL_F2265 ASQL_F2265 C2 NOT_RELEASED
ASQL_F2266 ASQL_F2266 C2 NOT_RELEASED
ASQL_F2428 ASQL_F2428 C2 NOT_RELEASED
ASQL_F2649 ASQL_F2649 C2 NOT_RELEASED
ASQL_F2914 ASQL_F2914 C2 NOT_RELEASED
ASQL_F2929 ASQL_F2929 C2 NOT_RELEASED
ASQL_F2987 ASQL_F2987 C2 NOT_RELEASED
ASQL_F4587 ASQL_F4587 C2 NOT_RELEASED
ASQL_F5323 ASQL_F5323 C2 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot Number
InspectionLotType InspectionLotType Inspection Type
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Business Purpose Completed Flag
MatlQualityAuthorizationGroup MatlQualityAuthorizationGroup Material Authorization Group for Activities in QM
Plant Plant Valuation Area

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_InspectionLotStdVH.
-- 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: IIL__VH

CREATE VIEW I_InspectionLotStdVH AS
SELECT
  InspectionLot,
  InspectionLotType,
  IsBusinessPurposeCompleted,
  MatlQualityAuthorizationGroup,
  Plant
FROM I_InspectionLot
;

Learn More