What is A_InbDeliverySerialNmbr_1 in SAP S/4HANA?

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

Which tables does A_InbDeliverySerialNmbr_1 read from?

A_InbDeliverySerialNmbr_1 reads data from: I_SerialNmbrDelivery.

What VDM layer is A_InbDeliverySerialNmbr_1?

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

A_InbDeliverySerialNmbr_1

DDL: A_INBDELIVERYSERIALNMBR_1 SQL: AINBDLVSERNO1 Type: view BASIC Package: VDM_LE_SHP_IBD_API_V2

8 Fields 1 Data Sources 3 Associations

CDS View for Serial Numbers

A_InbDeliverySerialNmbr_1 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. Part of development package VDM_LE_SHP_IBD_API_V2.

Data Sources (1)

Source	Alias	Join Type
I_SerialNmbrDelivery	I_SerialNmbrDelivery	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	A_InbDeliveryItem_1	_DeliveryDocumentItem	`$projection.DeliveryDocument = _DeliveryDocumentItem.DeliveryDocument and $projection.DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem`
[1..*]	A_MaintenanceItemObjList_1	_MaintenanceItemObject	`_MaintenanceItemObject.MaintenanceItemObjectList = $projection.MaintenanceItemObjectList`
[1..1]	A_InbDeliveryHeader_1	_DeliveryDocumentHeader	`$projection.DeliveryDocument = _DeliveryDocumentHeader.DeliveryDocument`

Annotations (11)

Name	Value	Level
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.sqlViewName	AINBDLVSERNO1	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	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_1.
-- 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: AINBDLVSERNO1

CREATE VIEW A_InbDeliverySerialNmbr_1 AS
SELECT
  MaintenanceItemObjectList,
  DeliveryDate,
  DeliveryDocument,
  DeliveryDocumentItem,
  SDDocumentCategory
FROM I_SerialNmbrDelivery
LEFT OUTER JOIN A_InbDeliveryItem_1 AS _DeliveryDocumentItem ON DeliveryDocument = _DeliveryDocumentItem.DeliveryDocument AND DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem  -- association [1..1]
LEFT OUTER JOIN A_MaintenanceItemObjList_1 AS _MaintenanceItemObject ON _MaintenanceItemObject.MaintenanceItemObjectList = MaintenanceItemObjectList  -- association [1..*]
LEFT OUTER JOIN A_InbDeliveryHeader_1 AS _DeliveryDocumentHeader ON DeliveryDocument = _DeliveryDocumentHeader.DeliveryDocument  -- association [1..1]
;

Depth:

A_InbDeliverySerialNmbr_1 view

I_SerialNmbrDelivery view_entity