I_InspectionLotOriginSettings

DDL: I_INSPECTIONLOTORIGINSETTINGS Type: view_entity BASIC Package: VDM_QM_INSPECTION
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 Public 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. 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
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 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 (10)

NameValueLevelField
EndUserText.label Settings for Inspection Lot Origin view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey InspectionLotOrigin view
Analytics.technicalName IINSPLOTORGNSTGS 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.

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