I_MaintObjListInspectionLot

DDL: I_MAINTOBJLISTINSPECTIONLOT Type: view_entity BASIC Package: LO_SN_DB
7 Fields 1 Data Sources 2 Associations

Maint Object List in Inspection Lot

I_MaintObjListInspectionLot is a Basic CDS View that provides data about "Maint Object List in Inspection Lot" in SAP S/4HANA. It reads from 1 data source (ser04) and exposes 7 fields with key field MaintenanceObjectList. It has 2 associations to related views. Part of development package LO_SN_DB.

Data Sources (1)

SourceAliasJoin Type
ser04 ser04 from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_MaintenanceObjectListItem _MaintenanceObjectListItem $projection.MaintenanceObjectList = _MaintenanceObjectListItem.MaintenanceObjectList
[0..1] I_InspectionLot _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Maint Object List in Inspection Lot view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceObjectList obknr Object list
InspectionLot prueflos Inspection Lot
SerialNumberAssignmentDate datum Valid to
SerialNumberAssignmentTime uzeit Time
NumberOfSerialNumbers anzsn No.serial no.
_MaintenanceObjectListItem _MaintenanceObjectListItem
_InspectionLot _InspectionLot

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_MaintObjListInspectionLot.
-- 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_MaintObjListInspectionLot AS
SELECT
  obknr AS MaintenanceObjectList,
  prueflos AS InspectionLot,
  datum AS SerialNumberAssignmentDate,
  uzeit AS SerialNumberAssignmentTime,
  anzsn AS NumberOfSerialNumbers
FROM ser04
LEFT OUTER JOIN I_MaintenanceObjectListItem AS _MaintenanceObjectListItem ON MaintenanceObjectList = _MaintenanceObjectListItem.MaintenanceObjectList  -- association [1..*]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [0..1]
;

Learn More