C_SerialNumbersForGdsMvtVH

DDL: C_SERIALNUMBERSFORGDSMVTVH SQL: CSRNRGDSMVTVH Type: view CONSUMPTION Package: MBND_CLOUD_BL

Value Help for Serial numbers for Goods Movement

C_SerialNumbersForGdsMvtVH is a Consumption CDS View that provides data about "Value Help for Serial numbers for Goods Movement" in SAP S/4HANA. It reads from 1 data source (I_Equipment) and exposes 20 fields with key fields SerialNumber, Material, Equipment. It has 1 association to related views. It is exposed through 1 OData service (UI_PROCESS_RECEIPTS). It is used in 1 Fiori application: Process Receipt. Part of development package MBND_CLOUD_BL.

1 data source(s) Exposed by 1 service(s) Used in 1 Fiori app(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_Equipment I_Equipment from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EquipmentStockSegment _stocksegment $projection.Equipment = _stocksegment.Equipment

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CSRNRGDSMVTVH view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Value Help for Serial numbers for Goods Movement view
Search.searchable true view
Consumption.ranked true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PROCESS_RECEIPTS UI_PROCESS_RECEIPTS V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F5316 Process Receipt Transactional This application is used to Receive Purchase Order Items and Inbound delivery items at Base Plant and Remote Plant. The items can consist of both Stock and Supplier Items.

Process Receipt

Business Role: Receiving Specialist (Oil & Gas)

This feature enables you to: Create batches with supplier batches using the Create Batch action. View additional fields such as Order Category, Order Number, Recipient, Requisitioner, and Unloading Point details on the list page. Perform a two-step Goods Receipt (GR) process with an alternate unit of measurement. Create a Putaway Warehouse Task for non-stock and supplier items in a single-plant scenario.

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SerialNumber SerialNumber
KEY Material Material
KEY Equipment Equipment
EquipmentHasStockInformation EquipmentHasStockInformation
Batch Batch
Plant _stocksegment Plant
StorageLocation _stocksegment StorageLocation
InventoryStockType _stocksegment InventoryStockType
InventorySpecialStockType _stocksegment InventorySpecialStockType
StockIdentifyingBatch _stocksegment Batch
SpecialStockIdfgSupplier _stocksegment Supplier
SalesOrder _stocksegment SalesOrder
SalesOrderItem _stocksegment SalesOrderItem
WBSElement
AuthorizationGroup AuthorizationGroup
Customer Customer
Supplier Supplier
_Customer _Customer
_Supplier _Supplier
_Material _Material 
@AbapCatalog.sqlViewName: 'CSRNRGDSMVTVH'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true

@VDM.viewType: #CONSUMPTION

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:#NOT_REQUIRED

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@ObjectModel.dataCategory:#VALUE_HELP

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Value Help for Serial numbers for Goods Movement'

@Search.searchable: true
@Consumption.ranked: true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view C_SerialNumbersForGdsMvtVH
  as select from I_Equipment
  association [0..1] to I_EquipmentStockSegment as _stocksegment on $projection.Equipment = _stocksegment.Equipment

{
        @Search.defaultSearchElement: true
        @Search.fuzzinessThreshold: 0.8
        @Search.ranking: #HIGH
  key   SerialNumber,
  key   Material,
  key   Equipment,
        EquipmentHasStockInformation,
        Batch,
        @Search.defaultSearchElement: true
        @Search.fuzzinessThreshold: 0.8
        @Search.ranking: #LOW
        _stocksegment.Plant                                                                       as Plant,
        @Search.defaultSearchElement: true
        @Search.fuzzinessThreshold: 0.8
        @Search.ranking: #LOW
        _stocksegment.StorageLocation                                                             as StorageLocation,

        _stocksegment.InventoryStockType                                                          as InventoryStockType,

        _stocksegment.InventorySpecialStockType                                                   as InventorySpecialStockType,

        _stocksegment.Batch                                                                       as StockIdentifyingBatch,

        _stocksegment.Supplier                                                                    as SpecialStockIdfgSupplier,

        @UI.hidden: true
        @ObjectModel.foreignKey.association: null
        _stocksegment.SalesOrder                                                                  as SalesOrder,
        @UI.hidden: true
        @ObjectModel.foreignKey.association: null
        _stocksegment.SalesOrderItem                                                              as SalesOrderItem,
        @UI.hidden: true
         _stocksegment._WBSElementByInternalKey.WBSElementExternalID                              as WBSElement,

        /* Associations */
        @Consumption.hidden: true
        AuthorizationGroup,

        @Consumption.hidden: true
        Customer,

        @Consumption.hidden: true
        Supplier,

        @Consumption.hidden: true
        _Customer,
        @Consumption.hidden: true
        _Supplier,

        @Consumption.hidden: true
        _Material



}
where
  SerialNumber <> ' ' // AND SerialNumber is not null.

Learn More