C_SerialNumberHistory

DDL: C_SERIALNUMBERHISTORY Type: view_entity CONSUMPTION Package: ODATA_LO_SN_HISTORY
56 Fields 1 Data Sources 2 OData Services

Serial Number History

C_SerialNumberHistory is a Consumption CDS View that provides data about "Serial Number History" in SAP S/4HANA. It reads from 1 data source (I_SerialNumberHistory) and exposes 56 fields with key fields Equipment, SerialNumberBusinessDocument, SrlNmbrBusinessDocumentItem, SrlNmbrBizDocAdditionalKey1, SrlNmbrBizDocAdditionalKey2. It is exposed through 2 OData services (ASQL_F7368, UI_SERIALNUMBER_HISTORY_V4). Part of development package ODATA_LO_SN_HISTORY.

Data Sources (1)

SourceAliasJoin Type
I_SerialNumberHistory I_SerialNumberHistory projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Serial Number History view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7368 ASQL_F7368 C2 NOT_RELEASED
UI_SERIALNUMBER_HISTORY_V4 UI_SERIALNUMBER_HISTORY_V4 V4 C1 NOT_TO_BE_RELEASED_STABLE

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY Equipment Equipment Equipment check
KEY SerialNumberBusinessDocument SerialNumberBusinessDocument
KEY SrlNmbrBusinessDocumentItem SrlNmbrBusinessDocumentItem
KEY SrlNmbrBizDocAdditionalKey1 SrlNmbrBizDocAdditionalKey1
KEY SrlNmbrBizDocAdditionalKey2 SrlNmbrBizDocAdditionalKey2
KEY SrlNmbrBizDocumentObjectType SrlNmbrBizDocumentObjectType
MaintenanceObjectList MaintenanceObjectList
MaintenanceObjectListItem MaintenanceObjectListItem Object counters
Material Material Vehicle Model
SerialNumber SerialNumber Serial Number
DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
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.
SerialNumberAssignmentDate SerialNumberAssignmentDate
SerialNumberAssignmentDateTime SerialNumberAssignmentDateTime
Customer Customer Sold-to Party
CustomerName CustomerName Name of Customer
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
NumberOfSerialNumbers NumberOfSerialNumbers No.serial no.
GoodsMovementType GoodsMovementType Movement Type
MovementTypeDescription MovementTypeDescription
SalesOrderType SalesOrderType Sales Order Type
SalesDocumentTypeName SalesDocumentTypeName
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
OrderType OrderType Order Type
OrderTypeName OrderTypeName
SrlNumberPhysicalInvtryTypeTxt SrlNumberPhysicalInvtryTypeTxt
PhysicalInventoryStockType PhysicalInventoryStockType Stock Type
PhysicalInventoryStockTypeName PhysicalInventoryStockTypeName
PurchasingDocumentType PurchasingDocumentType RFQ Type
PurchasingDocumentTypeName PurchasingDocumentTypeName Description
ExternalJITCallNumber ExternalJITCallNumber Ext. JIT Call Number
ShipToParty ShipToParty Ship-To Party (obsolete)
BusinessPartnerName BusinessPartnerName Extracted Customer Name
SubcontrgCompOfInbDelivItem SubcontrgCompOfInbDelivItem
SrlNmbrBizDocObjectTypeText _ObjectTypeText SrlNmbrBizDocObjectTypeText
DeliveryDocumentItemText _DeliveryDocumentItem DeliveryDocumentItemText
SalesDocumentItemText _SalesDocumentItem SalesDocumentItemText Item Descr.

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 C_SerialNumberHistory.
-- 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 C_SerialNumberHistory AS
SELECT
  Equipment,
  SerialNumberBusinessDocument,
  SrlNmbrBusinessDocumentItem,
  SrlNmbrBizDocAdditionalKey1,
  SrlNmbrBizDocAdditionalKey2,
  SrlNmbrBizDocumentObjectType,
  MaintenanceObjectList,
  MaintenanceObjectListItem,
  Material,
  SerialNumber,
  DeliveryDocumentItem,
  SalesOrderItem,
  MaterialDocumentItem,
  MaterialDocumentYear,
  OrderItem,
  PhysicalInventoryDocumentItem,
  FiscalYear,
  SerialNumberPhysicalInvtryType,
  PurchaseOrderItem,
  PurchaseRequisitionItem,
  JITCallItemNumber,
  CompGrpNumber,
  SerialNumberAssignmentDate,
  SerialNumberAssignmentDateTime,
  Customer,
  CustomerName,
  Supplier,
  SupplierName,
  NumberOfSerialNumbers,
  GoodsMovementType,
  MovementTypeDescription,
  SalesOrderType,
  SalesDocumentTypeName,
  AccountingDocumentType,
  AccountingDocumentTypeName,
  Plant,
  PlantName,
  StorageLocation,
  StorageLocationName,
  Batch,
  DebitCreditCode,
  DebitCreditCodeName,
  OrderType,
  OrderTypeName,
  SrlNumberPhysicalInvtryTypeTxt,
  PhysicalInventoryStockType,
  PhysicalInventoryStockTypeName,
  PurchasingDocumentType,
  PurchasingDocumentTypeName,
  ExternalJITCallNumber,
  ShipToParty,
  BusinessPartnerName,
  SubcontrgCompOfInbDelivItem,
  _ObjectTypeText.SrlNmbrBizDocObjectTypeText AS SrlNmbrBizDocObjectTypeText,
  _DeliveryDocumentItem.DeliveryDocumentItemText AS DeliveryDocumentItemText,
  _SalesDocumentItem.SalesDocumentItemText AS SalesDocumentItemText
FROM I_SerialNumberHistory
;

Learn More