A_EquipMatlSerialNumber

DDL: A_EQUIPMATLSERIALNUMBER Type: view_entity CONSUMPTION Package: VDM_EAM_EQUIPMENT
50 Fields 1 Data Sources 3 OData Services

Material Serial Number

A_EquipMatlSerialNumber is a Consumption CDS View that provides data about "Material Serial Number" in SAP S/4HANA. It reads from 1 data source (R_EquipMatlSerialNumberTP) and exposes 50 fields with key fields Material, SerialNumber. It is exposed through 3 OData services (API_MATERIALSERIALNUMBER, ASQL_F6973, ASQL_F8474). Part of development package VDM_EAM_EQUIPMENT.

Data Sources (1)

SourceAliasJoin Type
R_EquipMatlSerialNumberTP R_EquipMatlSerialNumberTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Material Serial Number view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
OData.entityType.name MaterialSerialNumber_Type view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

OData Services (3)

ServiceBindingVersionContractRelease
API_MATERIALSERIALNUMBER API_MATERIALSERIALNUMBER V4 C2 C1
ASQL_F6973 ASQL_F6973 C2 NOT_RELEASED
ASQL_F8474 ASQL_F8474 C2 NOT_RELEASED

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY SerialNumber SerialNumber Serial Number
Equipment Equipment Equipment check
EquipmentCategory EquipmentCategory EquipCategory
UniqueItemIdentifier UniqueItemIdentifier UII
UniqueItemIdentifierStrucType UniqueItemIdentifierStrucType
UniqueItemIdentifierRespPlant UniqueItemIdentifierRespPlant
MaintObjectInternalID MaintObjectInternalID Object number
HasEquipmentData HasEquipmentData
EquipmentHasStockInformation EquipmentHasStockInformation
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
LastChangeDateTime LastChangeDateTime Timestamp
MatlSrlNmbrMasterBatch MatlSrlNmbrMasterBatch
MatlSrlNmbrLastGdsMvtDte MatlSrlNmbrLastGdsMvtDte
MaterialSerialNumberStockBatch MaterialSerialNumberStockBatch
InventoryStockType InventoryStockType Stock Type
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
InventorySpecialStockType InventorySpecialStockType Special Stock Type
Customer Customer Sold-to Party
Supplier Supplier Supplier
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElement WBSElement WBS Internal ID
StockOwner StockOwner Owner of stock
CompanyCode CompanyCode Receiver Company Code
MatlSrlNmbrIsAvailable MatlSrlNmbrIsAvailable
MatlSrlNmbrIsDeleted MatlSrlNmbrIsDeleted
MatlSrlNmbrIsMrkdForDeltn MatlSrlNmbrIsMrkdForDeltn
MatlSrlNmbrIsInactive MatlSrlNmbrIsInactive
MatlSrlNmbrIsInstalled MatlSrlNmbrIsInstalled
MatlSrlNmbrIsAllcToParent MatlSrlNmbrIsAllcToParent
MatlSrlNmbrIsInWarehouse MatlSrlNmbrIsInWarehouse
MatlSrlNmbrIsAssgdToDeliv MatlSrlNmbrIsAssgdToDeliv
MatlSrlNmbrIsAtCustomer MatlSrlNmbrIsAtCustomer
MatlSrlNmbrIsUndrCnstrctn MatlSrlNmbrIsUndrCnstrctn
MatlSrlNmbrIsOnHold MatlSrlNmbrIsOnHold
MatlSrlNmbrIsLocked MatlSrlNmbrIsLocked
MatlSrlNmbrIsIDUndefined MatlSrlNmbrIsIDUndefined
MatlSrlNmbrIsAssgdToJITCall MatlSrlNmbrIsAssgdToJITCall
MatlSrlNmbrDocIsCreated MatlSrlNmbrDocIsCreated
MatlSrlNmbrHndlgUntIsAssgd MatlSrlNmbrHndlgUntIsAssgd
MatlSrlNmbrInvtryIsActv MatlSrlNmbrInvtryIsActv
MatlSrlNmbrUUIDIsGnrtd MatlSrlNmbrUUIDIsGnrtd
MatlSrlNmbrUUIDIsAttached MatlSrlNmbrUUIDIsAttached
MatlSrlNmbrUUIDIsSent MatlSrlNmbrUUIDIsSent
MatlSrlNmbrUUIDIsConfd MatlSrlNmbrUUIDIsConfd

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_EquipMatlSerialNumber.
-- 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_EquipMatlSerialNumber AS
SELECT
  Material,
  SerialNumber,
  Equipment,
  EquipmentCategory,
  UniqueItemIdentifier,
  UniqueItemIdentifierStrucType,
  UniqueItemIdentifierRespPlant,
  MaintObjectInternalID,
  HasEquipmentData,
  EquipmentHasStockInformation,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  LastChangeDate,
  LastChangeDateTime,
  MatlSrlNmbrMasterBatch,
  MatlSrlNmbrLastGdsMvtDte,
  MaterialSerialNumberStockBatch,
  InventoryStockType,
  Plant,
  StorageLocation,
  InventorySpecialStockType,
  Customer,
  Supplier,
  SalesOrder,
  SalesOrderItem,
  WBSElement,
  StockOwner,
  CompanyCode,
  MatlSrlNmbrIsAvailable,
  MatlSrlNmbrIsDeleted,
  MatlSrlNmbrIsMrkdForDeltn,
  MatlSrlNmbrIsInactive,
  MatlSrlNmbrIsInstalled,
  MatlSrlNmbrIsAllcToParent,
  MatlSrlNmbrIsInWarehouse,
  MatlSrlNmbrIsAssgdToDeliv,
  MatlSrlNmbrIsAtCustomer,
  MatlSrlNmbrIsUndrCnstrctn,
  MatlSrlNmbrIsOnHold,
  MatlSrlNmbrIsLocked,
  MatlSrlNmbrIsIDUndefined,
  MatlSrlNmbrIsAssgdToJITCall,
  MatlSrlNmbrDocIsCreated,
  MatlSrlNmbrHndlgUntIsAssgd,
  MatlSrlNmbrInvtryIsActv,
  MatlSrlNmbrUUIDIsGnrtd,
  MatlSrlNmbrUUIDIsAttached,
  MatlSrlNmbrUUIDIsSent,
  MatlSrlNmbrUUIDIsConfd
FROM R_EquipMatlSerialNumberTP
;

Learn More