A_ProdnOrderItemSerialNumber

DDL: A_PRODNORDERITEMSERIALNUMBER Type: view_entity COMPOSITE Package: ODATA_PP_API_PRODORDER_2
10 Fields 1 Data Sources 1 OData Services

Production Order Serial Numbers

A_ProdnOrderItemSerialNumber is a Composite CDS View that provides data about "Production Order Serial Numbers" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderItemSerialNumber) and exposes 10 fields with key fields ManufacturingOrder, ManufacturingOrderItem, SerialNumber. It is exposed through 1 OData service (ASQL_F8950). Part of development package ODATA_PP_API_PRODORDER_2.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderItemSerialNumber I_MfgOrderItemSerialNumber from

Annotations (9)

NameValueLevelField
EndUserText.label Production Order Serial Numbers view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.deleteEnabled true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F8950 ASQL_F8950 C2 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder ManufacturingOrder Order
KEY ManufacturingOrderItem ManufacturingOrderItem Manufacturing Order Item
KEY SerialNumber SerialNumber Serial Number
SerialNumberProfile SerialNumberProfile SerialNoProfile
Product Product Product Sold
ProductionPlant ProductionPlant Prod plnt
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
DocumentDate DocumentDate Journal Entry Date
LastChangeTimeendasLastChangeDateTime

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_ProdnOrderItemSerialNumber.
-- 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 A_ProdnOrderItemSerialNumber AS
SELECT
  ManufacturingOrder,
  ManufacturingOrderItem,
  SerialNumber,
  SerialNumberProfile,
  Product,
  ProductionPlant,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  DocumentDate,
  case I_MfgOrderItemSerialNumber._MfgOrder.LastChangeDate when '00000000' then concat(I_MfgOrderItemSerialNumber._MfgOrder.MfgOrderCreationDate, I_MfgOrderItemSerialNumber._MfgOrder.MfgOrderCreationTime) else concat(I_MfgOrderItemSerialNumber._MfgOrder.LastChangeDate, I_MfgOrderItemSerialNumber._MfgOrder.LastChangeTime) end as LastChangeDateTime AS LastChangeTimeendasLastChangeDateTime
FROM I_MfgOrderItemSerialNumber
;

Learn More