What is P_SerialNumberHistoryUnion in SAP S/4HANA?

P_SerialNumberHistoryUnion is a composite CDS view in SAP S/4HANA. Srl Nmbr Logistics and Service Documents It contains 119 fields.

Which tables does P_SerialNumberHistoryUnion read from?

P_SerialNumberHistoryUnion reads data from: P_SrlNmbrHistLogisticsDocument, P_SrlNmbrHistServiceDocument.

What VDM layer is P_SerialNumberHistoryUnion?

P_SerialNumberHistoryUnion is classified as a Composite view that combines data from multiple basic views.

P_SerialNumberHistoryUnion

DDL: P_SERIALNUMBERHISTORYUNION Type: view_entity COMPOSITE Package: ODATA_LO_SN_HISTORY

119 Fields 2 Data Sources

Srl Nmbr Logistics and Service Documents

P_SerialNumberHistoryUnion is a Composite CDS View that provides data about "Srl Nmbr Logistics and Service Documents" in SAP S/4HANA. It reads from 2 data sources (P_SrlNmbrHistLogisticsDocument, P_SrlNmbrHistServiceDocument) and exposes 119 fields with key fields Equipment, SerialNumberBusinessDocument, SrlNmbrBusinessDocumentItem, SrlNmbrBizDocAdditionalKey1, SrlNmbrBizDocAdditionalKey2. Part of development package ODATA_LO_SN_HISTORY.

Data Sources (2)

Source	Alias	Join Type
P_SrlNmbrHistLogisticsDocument	P_SrlNmbrHistLogisticsDocument	from
P_SrlNmbrHistServiceDocument	P_SrlNmbrHistServiceDocument	union_all

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view

Fields (119)

Key	Field	Source Field	Description
KEY	Equipment	Equipment	Equipment check
KEY	SerialNumberBusinessDocument	SerialNumberBusinessDocument	Transaction ID
KEY	SrlNmbrBusinessDocumentItem	SrlNmbrBusinessDocumentItem	Service Document
KEY	SrlNmbrBizDocAdditionalKey1	SrlNmbrBizDocAdditionalKey1
KEY	SrlNmbrBizDocAdditionalKey2	SrlNmbrBizDocAdditionalKey2
KEY	SrlNmbrBizDocumentObjectType	SrlNmbrBizDocumentObjectType
	Material	Material	Vehicle Model
	SerialNumber	SerialNumber	Serial Number
	MaintenanceObjectList	MaintenanceObjectList
	MaintenanceObjectListItem	MaintenanceObjectListItem	Object counters
	DeliveryDocument	DeliveryDocument	Outbound Delivery
	DeliveryDocumentItem	DeliveryDocumentItem	Outb. Delivery Item
	SalesOrder	SalesOrder	SD Document
	SalesOrderItem	SalesOrderItem	Sales Order Item
	MaterialDocumentItem	MaterialDocumentItem	Material Document Item
	MaterialDocumentYear	MaterialDocumentYear	Material Document Year
	OrderItem	OrderItem
	PhysicalInventoryDocumentItem	PhysicalInventoryDocumentItem	Physical Inventory Document Item
	FiscalYear	FiscalYear	G/L Fiscal Year
	SerialNumberPhysicalInvtryType	SerialNumberPhysicalInvtryType	Serial Number Physical Inventory Type
	PurchaseOrderItem	PurchaseOrderItem	Purchasing Document Item
	PurchaseRequisitionItem	PurchaseRequisitionItem	Requisn. item
	JITCallItemNumber	JITCallItemNumber	Call Item Number
	CompGrpNumber	CompGrpNumber	Component Group No.
	SerialNumberAssignmentDateTime	SerialNumberAssignmentDateTime
	UserEnteredTimeZone	UserEnteredTimeZone
	Customer	Customer	Sold-to Party
	CustomerName	CustomerName	Name of Customer
	Supplier	Supplier	Supplier
	SupplierName	SupplierName	Supplier Name
	NumberOfSerialNumbers	NumberOfSerialNumbers	No.serial no.
	SDDocumentCategory	SDDocumentCategory	Document Cat.
	GoodsMovementType	GoodsMovementType	Movement Type
	MovementTypeDescription	MovementTypeDescription
	SalesOrderType	SalesOrderType	Sales Order Type
	SalesDocumentTypeName	SalesDocumentTypeName
	SalesOrderItemCategory	SalesOrderItemCategory	Item Category
	AccountingDocumentType	AccountingDocumentType	Journal Entry Type
	AccountingDocumentTypeName	AccountingDocumentTypeName
	Plant	Plant	Valuation Area
	PlantName	PlantName	Plant Name
	StorageLocation	StorageLocation	StorageLocation
	StorageLocationName	StorageLocationName	Storage Loc. Name
	Batch	Batch	Lot No.
	DebitCreditCode	DebitCreditCode	Single-Character Flag
	DebitCreditCodeName	DebitCreditCodeName
	OrderCategory	OrderCategory	Order Category
	OrderType	OrderType	Order Type
	OrderTypeName	OrderTypeName
	OrderIsRefurbishmentOrder	OrderIsRefurbishmentOrder	Refurbishment
	SrlNumberPhysicalInvtryTypeTxt	SrlNumberPhysicalInvtryTypeTxt
	PhysicalInventoryStockType	PhysicalInventoryStockType	Stock Type
	PhysicalInventoryStockTypeName	PhysicalInventoryStockTypeName
	PurchasingDocumentCategory	PurchasingDocumentCategory	Doc. Category
	PurchasingDocumentType	PurchasingDocumentType	RFQ Type
	PurchasingDocumentTypeName	PurchasingDocumentTypeName	Description
	PurchasingDocumentItemCategory	PurchasingDocumentItemCategory	Item Category
	ExternalJITCallNumber	ExternalJITCallNumber	Ext. JIT Call Number
	ShipToParty	ShipToParty	Ship-To Party (obsolete)
	BusinessPartnerName	BusinessPartnerName	Extracted Customer Name
KEY	SerialNumberBusinessDocument		Transaction ID
KEY	SrlNmbrBusinessDocumentItem		Service Document
KEY	SrlNmbrBizDocAdditionalKey1
KEY	SrlNmbrBizDocAdditionalKey2
	Material	Material	Vehicle Model
	SerialNumber	SerialNumber	Serial Number
	MaintenanceObjectList
	MaintenanceObjectListItem		Object counters
	DeliveryDocument		Outbound Delivery
	DeliveryDocumentItem		Outb. Delivery Item
	SalesOrder		SD Document
	SalesOrderItem		Sales Order Item
	MaterialDocumentItem		Material Document Item
	MaterialDocumentYear		Material Document Year
	OrderItem
	PhysicalInventoryDocumentItem		Physical Inventory Document Item
	FiscalYear		G/L Fiscal Year
	SerialNumberPhysicalInvtryType		Serial Number Physical Inventory Type
	PurchaseOrderItem		Purchasing Document Item
	PurchaseRequisitionItem		Requisn. item
	JITCallItemNumber		Call Item Number
	CompGrpNumber		Component Group No.
	SerialNumberAssignmentDateTime	SerialNumberAssignmentDateTime
	UserEnteredTimeZone
	Customer		Sold-to Party
	CustomerName		Name of Customer
	Supplier		Supplier
	SupplierName		Supplier Name
	NumberOfSerialNumbers	NumberOfSerialNumbers	No.serial no.
	SDDocumentCategory		Document Cat.
	GoodsMovementType		Movement Type
	MovementTypeDescription
	SalesOrderType		Sales Order Type
	SalesDocumentTypeName
	SalesOrderItemCategory		Item Category
	AccountingDocumentType		Journal Entry Type
	AccountingDocumentTypeName
	Plant		Valuation Area
	PlantName		Plant Name
	StorageLocation		StorageLocation
	StorageLocationName		Storage Loc. Name
	Batch		Lot No.
	DebitCreditCode		Single-Character Flag
	DebitCreditCodeName
	OrderCategory		Order Category
	OrderType		Order Type
	OrderTypeName
	OrderIsRefurbishmentOrder		Refurbishment
	SrlNumberPhysicalInvtryTypeTxt
	PhysicalInventoryStockType		Stock Type
	PhysicalInventoryStockTypeName
	PurchasingDocumentCategory		Doc. Category
	PurchasingDocumentType		RFQ Type
	PurchasingDocumentTypeName		Description
	PurchasingDocumentItemCategory		Item Category
	ExternalJITCallNumber		Ext. JIT Call Number
	ShipToParty		Ship-To Party (obsolete)
	BusinessPartnerName		Extracted Customer Name
	SubcontrgCompOfInbDelivItem

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 P_SerialNumberHistoryUnion.
-- 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 P_SerialNumberHistoryUnion AS
SELECT
  Equipment,
  SerialNumberBusinessDocument,
  SrlNmbrBusinessDocumentItem,
  SrlNmbrBizDocAdditionalKey1,
  SrlNmbrBizDocAdditionalKey2,
  SrlNmbrBizDocumentObjectType,
  Material,
  SerialNumber,
  MaintenanceObjectList,
  MaintenanceObjectListItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  SalesOrder,
  SalesOrderItem,
  MaterialDocumentItem,
  MaterialDocumentYear,
  OrderItem,
  PhysicalInventoryDocumentItem,
  FiscalYear,
  SerialNumberPhysicalInvtryType,
  PurchaseOrderItem,
  PurchaseRequisitionItem,
  JITCallItemNumber,
  CompGrpNumber,
  SerialNumberAssignmentDateTime,
  UserEnteredTimeZone,
  Customer,
  CustomerName,
  Supplier,
  SupplierName,
  NumberOfSerialNumbers,
  SDDocumentCategory,
  GoodsMovementType,
  MovementTypeDescription,
  SalesOrderType,
  SalesDocumentTypeName,
  SalesOrderItemCategory,
  AccountingDocumentType,
  AccountingDocumentTypeName,
  Plant,
  PlantName,
  StorageLocation,
  StorageLocationName,
  Batch,
  DebitCreditCode,
  DebitCreditCodeName,
  OrderCategory,
  OrderType,
  OrderTypeName,
  OrderIsRefurbishmentOrder,
  SrlNumberPhysicalInvtryTypeTxt,
  PhysicalInventoryStockType,
  PhysicalInventoryStockTypeName,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingDocumentTypeName,
  PurchasingDocumentItemCategory,
  ExternalJITCallNumber,
  ShipToParty,
  BusinessPartnerName,
  cast( '' as abap.numc( 6 ) ) AS SubcontrgCompOfInbDelivItem
FROM P_SrlNmbrHistLogisticsDocument
-- UNION ALL with additional select branch(es): P_SrlNmbrHistServiceDocument
;

Depth:

P_SerialNumberHistoryUnion view_entity

P_SrlNmbrHistLogisticsDocument view_entity
P_SrlNmbrHistServiceDocument view_entity

I_SerialNumberHistory view_entity