What is A_InbDeliverySerialNmbr in SAP S/4HANA?

A_InbDeliverySerialNmbr is a basic CDS view in SAP S/4HANA. CDS View for Serial Numbers It contains 8 fields.

Which tables does A_InbDeliverySerialNmbr read from?

A_InbDeliverySerialNmbr reads data from: I_SerialNmbrDelivery.

What VDM layer is A_InbDeliverySerialNmbr?

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

A_InbDeliverySerialNmbr

DDL: A_INBDELIVERYSERIALNMBR SQL: AINBDLVSERNO Type: view BASIC

8 Fields 1 Data Sources 3 Associations

CDS View for Serial Numbers

A_InbDeliverySerialNmbr is a Basic CDS View that provides data about "CDS View for Serial Numbers" in SAP S/4HANA. It reads from 1 data source (I_SerialNmbrDelivery) and exposes 8 fields with key field MaintenanceItemObjectList. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_SerialNmbrDelivery	I_SerialNmbrDelivery	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	A_InbDeliveryItem	_DeliveryDocumentItem	`$projection.DeliveryDocument = _DeliveryDocumentItem.DeliveryDocument and $projection.DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem`
[1..*]	A_MaintenanceItemObjList	_MaintenanceItemObject	`_MaintenanceItemObject.MaintenanceItemObjectList = $projection.MaintenanceItemObjectList`
[1..1]	A_InbDeliveryHeader	_DeliveryDocumentHeader	`$projection.DeliveryDocument = _DeliveryDocumentHeader.DeliveryDocument`

Annotations (11)

Name	Value	Level
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.sqlViewName	AINBDLVSERNO	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	CDS View for Serial Numbers	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view

Fields (8)

Key	Field	Source Field	Description
KEY	MaintenanceItemObjectList		Object list
	DeliveryDate	DeliveryDate	Delivery Date
	DeliveryDocument	DeliveryDocument	Outbound Delivery
	DeliveryDocumentItem	DeliveryDocumentItem	Outb. Delivery Item
	SDDocumentCategory	SDDocumentCategory	Document Cat.
	_DeliveryDocumentItem	_DeliveryDocumentItem
	_MaintenanceItemObject	_MaintenanceItemObject
	_DeliveryDocumentHeader	_DeliveryDocumentHeader

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 A_InbDeliverySerialNmbr.
-- 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: AINBDLVSERNO

CREATE VIEW A_InbDeliverySerialNmbr AS
SELECT
  cast ( MaintenanceItemObjectList as abap.int4 ) AS MaintenanceItemObjectList,
  DeliveryDate,
  DeliveryDocument,
  DeliveryDocumentItem,
  SDDocumentCategory
FROM I_SerialNmbrDelivery
LEFT OUTER JOIN A_InbDeliveryItem AS _DeliveryDocumentItem ON DeliveryDocument = _DeliveryDocumentItem.DeliveryDocument AND DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem  -- association [1..1]
LEFT OUTER JOIN A_MaintenanceItemObjList AS _MaintenanceItemObject ON _MaintenanceItemObject.MaintenanceItemObjectList = MaintenanceItemObjectList  -- association [1..*]
LEFT OUTER JOIN A_InbDeliveryHeader AS _DeliveryDocumentHeader ON DeliveryDocument = _DeliveryDocumentHeader.DeliveryDocument  -- association [1..1]
;

Depth:

A_InbDeliverySerialNmbr view

I_SerialNmbrDelivery view