I_InspectionLotOriginText

DDL: I_INSPECTIONLOTORIGINTEXT SQL: IINSPLOTORIGINT Type: view BASIC Package: VDM_QM_INSPECTION
3 Fields 1 Data Sources 2 OData Services

Inspection Lot Origin - Text

I_InspectionLotOriginText (Basic)

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

Manufacturing

I_InspectionLotOriginText is a Basic CDS View (Dimension) that provides data about "Inspection Lot Origin - Text" in SAP S/4HANA. It reads from 1 data source (tq31t) and exposes 3 fields with key fields InspectionLotOrigin, Language. It is exposed through 2 OData services (ASQL_F2428, ASQL_F2649). Part of development package VDM_QM_INSPECTION.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessManufacturing
Application ComponentQM-IM-2CL
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Language-Dependent Text
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>This CDS view provides access to the definition of inspection lot origins that are delivered by SAP. </p>

Documentation

Data Sources (1)

SourceAliasJoin Type
tq31t tq31t from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IINSPLOTORIGINT view
AbapCatalog.preserveKey true view
EndUserText.label Inspection Lot Origin - Text view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey InspectionLotOrigin view
Metadata.ignorePropagatedAnnotations true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F2428 ASQL_F2428 C2 NOT_RELEASED
ASQL_F2649 ASQL_F2649 C2 NOT_RELEASED

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY InspectionLotOrigin tq31t herkunft Inspection Lot Origin
KEY Language tq31t sprache Language Key
InspectionLotOriginText tq31t herktxt Inspection Lot Origin 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 I_InspectionLotOriginText.
-- 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: IINSPLOTORIGINT

CREATE VIEW I_InspectionLotOriginText AS
SELECT
  tq31t.herkunft AS InspectionLotOrigin,
  tq31t.sprache AS Language,
  tq31t.herktxt AS InspectionLotOriginText
FROM tq31t
;

Learn More