I_InspectionLotOriginSettings

DDL: I_INSPECTIONLOTORIGINSETTINGS SQL: IINSPLOTORGNSTGS Type: view BASIC
6 Fields 1 Data Sources 3 Associations

Settings for Inspection Lot Origin

I_InspectionLotOriginSettings (Basic)

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

Manufacturing

I_InspectionLotOriginSettings is a Basic CDS View that provides data about "Settings for Inspection Lot Origin" in SAP S/4HANA. It reads from 1 data source (tq33) and exposes 6 fields with key field InspectionLotOrigin. It has 3 associations to related views.

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentQM-IM
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides access to the settings for inspection lot origins. </p>

Documentation

Data Sources (1)

SourceAliasJoin Type
tq33 tq33 from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_InspectionLotOrigin _InspectionLotOrigin $projection.InspectionLotOrigin = _InspectionLotOrigin.InspectionLotOrigin
[0..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
[0..1] I_BillOfOperationsStatus _BillOfOperationsStatus $projection.BillOfOperationsStatus = _BillOfOperationsStatus.BillOfOperationsStatus

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IINSPLOTORGNSTGS view
EndUserText.label Settings for Inspection Lot Origin view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey InspectionLotOrigin view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY InspectionLotOrigin Inspection Lot Origin
BillOfOperationsType Bill of Operations Type
BillOfOperationsStatus Bill of Operations Status
_InspectionLotOrigin _InspectionLotOrigin
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsStatus _BillOfOperationsStatus

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_InspectionLotOriginSettings.
-- 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: IINSPLOTORGNSTGS

CREATE VIEW I_InspectionLotOriginSettings AS
SELECT
  cast( tq33.herkunft as vdm_qherk preserving type ) AS InspectionLotOrigin,
  cast( tq33.plnty as vdm_plnty preserving type ) AS BillOfOperationsType,
  cast( tq33.plnst as vdm_qplnst preserving type ) AS BillOfOperationsStatus
FROM tq33
LEFT OUTER JOIN I_InspectionLotOrigin AS _InspectionLotOrigin ON InspectionLotOrigin = _InspectionLotOrigin.InspectionLotOrigin  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsStatus AS _BillOfOperationsStatus ON BillOfOperationsStatus = _BillOfOperationsStatus.BillOfOperationsStatus  -- association [0..1]
;

Learn More