C_MfgOrderAssembledSerialVH

DDL: C_MFGORDERASSEMBLEDSERIALVH SQL: CMFGORDASSMBLSN Type: view CONSUMPTION Package: MPE_EXEC_NON_CONFORMANCE
24 Fields 1 Data Sources

Serial Number

C_MfgOrderAssembledSerialVH is a Consumption CDS View that provides data about "Serial Number" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderCompAssemblyAggrgn) and exposes 24 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. Part of development package MPE_EXEC_NON_CONFORMANCE.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderCompAssemblyAggrgn I_MfgOrderCompAssemblyAggrgn from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMFGORDASSMBLSN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Serial Number view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Reservation Reservation Reservation
KEY ReservationItem ReservationItem Reservation Item
KEY RecordType RecordType Reservation Record Type
KEY OpActyNtwkInstance OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement OpActyNtwkElement Element Number
KEY AssemblyShopFloorItem AssemblyShopFloorItem
KEY ShopFloorItem ShopFloorItem Serial.Mat. ID
KEY Batch Batch Lot No.
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY OriglDgtlMockUpCharcsUUID OriglDgtlMockUpCharcsUUID DMU GUID
StorageLocation StorageLocation StorageLocation
DgtlMockUpCharcsUUID DgtlMockUpCharcsUUID DMU GUID
AssembledSerialNumber AssembledSerialNumber
ManufacturerSerialNumber ManufacturerSerialNumber Mnf.serial no.
_Material _Material
_OpActyNtwkInstance _OpActyNtwkInstance
_OperationActivityInstance _OperationActivityInstance
_ParentShopFloorItem _ParentShopFloorItem
_Plant _Plant
_Reservation _Reservation
_ReservationItem _ReservationItem
_ShopFloorItem _ShopFloorItem
_StorageLocation _StorageLocation

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_MfgOrderAssembledSerialVH.
-- 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: CMFGORDASSMBLSN

CREATE VIEW C_MfgOrderAssembledSerialVH AS
SELECT
  Reservation,
  ReservationItem,
  RecordType,
  OpActyNtwkInstance,
  OpActyNtwkElement,
  AssemblyShopFloorItem,
  ShopFloorItem,
  Batch,
  Material,
  Plant,
  OriglDgtlMockUpCharcsUUID,
  StorageLocation,
  DgtlMockUpCharcsUUID,
  AssembledSerialNumber,
  ManufacturerSerialNumber
FROM I_MfgOrderCompAssemblyAggrgn
;

Learn More