What is I_SerialNmbrSalesOrder in SAP S/4HANA?

I_SerialNmbrSalesOrder is a basic CDS view in SAP S/4HANA. Serial Number Sales Order It contains 7 fields.

Which tables does I_SerialNmbrSalesOrder read from?

I_SerialNmbrSalesOrder reads data from: ser02.

What VDM layer is I_SerialNmbrSalesOrder?

I_SerialNmbrSalesOrder is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_SerialNmbrSalesOrder

DDL: I_SERIALNMBRSALESORDER SQL: ISERNOSLSORD Type: view BASIC

7 Fields 1 Data Sources 2 Associations

Serial Number Sales Order

I_SerialNmbrSalesOrder is a Basic CDS View that provides data about "Serial Number Sales Order" in SAP S/4HANA. It reads from 1 data source (ser02) and exposes 7 fields with key field MaintenanceItemObjectList. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
ser02	ser02	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_SalesOrder	_SalesOrder	`$projection.SalesOrder = _SalesOrder.SalesOrder`
[1..1]	I_SalesOrderItem	_SalesOrderItem	`$projection.SalesOrder = _SalesOrderItem.SalesOrder and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	ISERNOSLSORD	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
EndUserText.label	Serial Number Sales Order	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
VDM.viewType	#BASIC	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	I_MaintItmObjListSalesOrder	view

Fields (7)

Key	Field	Source Field	Description
KEY	MaintenanceItemObjectList	obknr	Object list
	SalesOrder	sdaufnr	Sales Document
	SalesOrderItem	posnr	WBS Element
	SalesOrderDate	datum	Valid to
	SDDocumentCategory	vbtyp	TSW Det.Doc typ
	_SalesOrder	_SalesOrder
	_SalesOrderItem	_SalesOrderItem

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_SerialNmbrSalesOrder.
-- 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: ISERNOSLSORD

CREATE VIEW I_SerialNmbrSalesOrder AS
SELECT
  obknr AS MaintenanceItemObjectList,
  sdaufnr AS SalesOrder,
  posnr AS SalesOrderItem,
  datum AS SalesOrderDate,
  vbtyp AS SDDocumentCategory
FROM ser02
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [1..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [1..1]
;

Depth:

I_SerialNmbrSalesOrder view

ser02