C_SerialNumberValueHelp

DDL: C_SERIALNUMBERVALUEHELP Type: view_entity CONSUMPTION Package: LO_SN_DB
23 Fields 1 Data Sources 1 OData Services 6 Fiori Apps

Selection Help for Serial Numbers

C_SerialNumberValueHelp is a Consumption CDS View that provides data about "Selection Help for Serial Numbers" in SAP S/4HANA. It reads from 1 data source (I_SerialNumberValueHelp) and exposes 23 fields with key fields SerialNumber, Material, Equipment. It is exposed through 1 OData service (UI_SERIALNUMBER_REUSE_V2). It is used in 6 Fiori applications: Post Goods Receipt for Purchasing Document, Transfer Stock - Cross-Plant, Post Goods Receipt for Inbound Delivery, .... Part of development package LO_SN_DB.

Data Sources (1)

SourceAliasJoin Type
I_SerialNumberValueHelp I_SerialNumberValueHelp from

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Selection Help for Serial Numbers view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
ObjectModel.representativeKey SerialNumber view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SERIALNUMBER_REUSE_V2 UI_SERIALNUMBER_REUSE_V2 V2 C1 NOT_RELEASED

Fiori Apps (6)

App IDApp NameTypeDescription
F0843 Post Goods Receipt for Purchasing Document Transactional An application for Inventory Management in S/4HANA that allows to create goods receipt for purchase orders.
F1957 Transfer Stock - Cross-Plant Transactional You can use this app to make the transfer postings from one plant (issuing plant) to another plant (receiving plant). For example as a warehouse clerk, you can perform the following tasks: •Transfer stock within a plant or across plants. •Transfer stock from one stock type to another stock type. •Check the range of coverage based on the consumption of unrestricted-use stock materials in the last 30 days. The app supports you to find the allowed transfer postings.
F2502 Post Goods Receipt for Inbound Delivery Transactional With this app you can post a goods receipt for an inbound delivery.
F3110 Post Goods Receipt for Production Order Transactional With this app you can post goods receipts for production orders.
F5476 Post Subsequent Adjustment Transactional With this app it is possible to post a subsequent adjustment in order to correct the component consumption.
F6352 Post Goods Receipt for Process Order Transactional With this app, you can post the receipt of goods with reference to a process order. The app proposes a selection of process orders as well as the corresponding material item level that can be posted. This app supports you, for example, as a warehouse clerk in your daily work.

Post Goods Receipt for Purchasing Document

Business Role: Warehouse Clerk

With this app you can post the receipt of goods with reference to the purchase order with which you ordered the goods. If a material is delivered for a purchase order, it is important for all of the departments involved that the goods receipt entry in the system references this purchase order.

Transfer Stock - Cross-Plant

Business Role: Warehouse Clerk

With this app, you can make transfer postings from one plant (issuing plant) to another plant (receiving plant).The app supports you in finding the allowed transfer postings and in personalizing the control settings of storage locations and visible columns.This app supports you, for example, as a warehouse clerk in your daily work.

Post Goods Receipt for Inbound Delivery

Business Role: Warehouse Clerk

With this app you can post a receipt of goods with reference to an inbound delivery.

Post Goods Receipt for Production Order

Business Role: Warehouse Clerk

With this app, you can post the receipt of goods with reference to a production order. The app proposes a selection of production orders as well as the corresponding material item level that can be posted. This app supports you, for example, as a warehouse clerk in your daily work.

Post Subsequent Adjustment

Business Role: Warehouse Clerk

With this app, you can carry out a subsequent correction posting of components from the subcontracting purchasing document. This is the case if a subcontractor has consumed a larger or smaller quantity of components than you originally planned and posted. This app focuses on the special process step of the subsequent adjustment posting after the goods receipt process for the subcontracting purchasing document.

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY SerialNumber SerialNumber Serial Number
KEY Material Material Vehicle Model
KEY Equipment Equipment Equipment check
EquipmentHasStockInformation EquipmentHasStockInformation
Batch Batch Lot No.
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
Customer Customer Customer
Supplier Supplier Supplier
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
InventorySpecialStockType InventorySpecialStockType Special Stock Type
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElement WBSElement WBS Internal ID
InventoryStockType InventoryStockType Stock Type
StockOwner StockOwner Owner of stock
ManufacturerSerialNumber ManufacturerSerialNumber Mnf.serial no.
AssetManufacturerName AssetManufacturerName Manufacturer
ManufacturerPartTypeName ManufacturerPartTypeName Model number
ManufacturerCountry ManufacturerCountry Manufacturer Country
ManufacturerPartNmbr ManufacturerPartNmbr Manufacturer Part Number
_Customer _Customer
_Supplier _Supplier

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_SerialNumberValueHelp.
-- 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_SerialNumberValueHelp AS
SELECT
  SerialNumber,
  Material,
  Equipment,
  EquipmentHasStockInformation,
  Batch,
  Plant,
  StorageLocation,
  Customer,
  Supplier,
  SalesOrder,
  SalesOrderItem,
  InventorySpecialStockType,
  WBSElementInternalID,
  WBSElement,
  InventoryStockType,
  StockOwner,
  ManufacturerSerialNumber,
  AssetManufacturerName,
  ManufacturerPartTypeName,
  ManufacturerCountry,
  ManufacturerPartNmbr
FROM I_SerialNumberValueHelp
;

Learn More