C_SerialNmbrHistory

DDL: C_SERIALNMBRHISTORY SQL: CSERNOHIST Type: view CONSUMPTION
21 Fields 1 Data Sources 3 Associations

Serial Numbers History

C_SerialNmbrHistory is a Consumption CDS View that provides data about "Serial Numbers History" in SAP S/4HANA. It reads from 1 data source (P_SerialNmbrHistory) and exposes 21 fields with key fields Equipment, DeliveryDocument, DeliveryDocumentItem, SalesOrder, SalesOrderItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_SerialNmbrHistory P_SerialNmbrHistory from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Equipment _Equipment $projection.Equipment = _Equipment.Equipment
[1..1] C_SerialNumberObjPage _SerialNumberObjPage $projection.Equipment = _SerialNumberObjPage.Equipment
[0..1] I_SerialNmbrDocType _SerialNmbrDocType $projection.SerialNmbrHistoryDocumentType = _SerialNmbrDocType.SerialNmbrHistoryDocumentType

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSERNOHIST view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Serial Numbers History view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Equipment Equipment Equipment check
KEY DeliveryDocument DeliveryDocument Outbound Delivery
KEY DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
KEY SalesOrder SalesOrder SD Document
KEY SalesOrderItem SalesOrderItem Sales Order Item
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY InspectionLot InspectionLot Inspection Lot
KEY PhysicalInventoryDocument PhysicalInventoryDocument Physical Inventory Document
KEY PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem Physical Inventory Document Item
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
DocumentDate DocumentDate Journal Entry Date
SerialNmbrHistoryDocumentType SerialNmbrHistoryDocumentType Order Type
_SerialNumberObjPage _SerialNumberObjPage
_Equipment _Equipment
_SerialNmbrDocType _SerialNmbrDocType

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_SerialNmbrHistory.
-- 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: CSERNOHIST

CREATE VIEW C_SerialNmbrHistory AS
SELECT
  Equipment,
  DeliveryDocument,
  DeliveryDocumentItem,
  SalesOrder,
  SalesOrderItem,
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  InspectionLot,
  PhysicalInventoryDocument,
  PhysicalInventoryDocumentItem,
  FiscalYear,
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  DocumentDate,
  SerialNmbrHistoryDocumentType
FROM P_SerialNmbrHistory
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [1..1]
LEFT OUTER JOIN C_SerialNumberObjPage AS _SerialNumberObjPage ON Equipment = _SerialNumberObjPage.Equipment  -- association [1..1]
LEFT OUTER JOIN I_SerialNmbrDocType AS _SerialNmbrDocType ON SerialNmbrHistoryDocumentType = _SerialNmbrDocType.SerialNmbrHistoryDocumentType  -- association [0..1]
;

Learn More