C_PurOrdMaintainUoMValHelp

DDL: C_PURORDMAINTAINUOMVALHELP SQL: CPOMAINTVHUOM Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN

Value Help Unit of measure

C_PurOrdMaintainUoMValHelp is a Consumption CDS View that provides data about "Value Help Unit of measure" in SAP S/4HANA. It reads from 2 data sources (I_MaterialPlant, I_Plant) and exposes 10 fields with key fields Material, UnitOfMeasure, Plant, UnitOfMeasure, Plant. It has 3 associations to related views. It is exposed through 1 OData service (UI_RCPTSRETSOVERVIEW). It is used in 1 Fiori application: Receipts and Returns Overview. Part of development package ODATA_MM_PUR_PO_MAINTAIN.

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

Data Sources (2)

SourceAliasJoin Type
I_MaterialPlant _MaterialPlant left_outer
I_Plant _Plant left_outer

Associations (3)

CardinalityTargetAliasCondition
[0..1] t006a _uomtext $projection.UnitOfMeasure = _uomtext.msehi
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CPOMAINTVHUOM view
EndUserText.label Value Help Unit of measure view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.status #DEPRECATED view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RCPTSRETSOVERVIEW UI_RCPTSRETSOVERVIEW V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F5479 Receipts and Returns Overview Transactional, Analytical This application is to have an overview of KPIs for items to be received at the base and remote location and aggregated information of item type (rentals, non-stock, stock and supplier owned items, Overdue items and Failed receipts, Delayed Receipts, items initiated at the remote location.

Receipts and Returns Overview

Business Role: Receiving Specialist (Oil & Gas)

This feature enables you to view the logistics items to be received for a certain date range in a consolidated chart view. You can view them by item type (stock, rental, or supplier items) as well as by status (to be received, received, or failed receipts). You can view items that are delayed, by item value or duration. For failed receipts, you can view the reason for failure re-initiate a new receipt. You can view the number of items for which returns action has been initiated, or dispatched items. You can also navigate from the cards of the overview pages to the underlaying apps: Process Receipts and Process Returns.

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Material matnr Material
KEY UnitOfMeasure meinh Unit of Measurement
KEY Plant I_MaterialPlant Plant Plant
MaterialName _MaterialText MaterialName
PlantName I_Plant PlantName
KEY UnitOfMeasure t006 msehi Unit of Measurement
KEY Plant Plant
MaterialName
PlantName
_uomtext _uomtext 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'CPOMAINTVHUOM'
@EndUserText.label: 'Value Help Unit of measure' //PO Maintenance: Value Help for Unit of Measure

@AccessControl.authorizationCheck: #CHECK
@VDM.lifecycle.status: #DEPRECATED

//-----------------------------------------------------------------------------------------------------------------

// Remark: only Unit of Measures with "T006-KZKEH <> SPACE" are selected (see function module HELP_VALUES_MEINS)

//-----------------------------------------------------------------------------------------------------------------


define view C_PurOrdMaintainUoMValHelp
  as select distinct from marm as marm

    left outer join I_MaterialPlant as _MaterialPlant on marm.matnr           = _MaterialPlant.Material
    left outer join I_Plant         as _Plant         on _MaterialPlant.Plant = _Plant.Plant
  
    association [0..1] to t006a           as _uomtext       on $projection.UnitOfMeasure    = _uomtext.msehi
    association [0..*] to I_MaterialText  as _MaterialText  on $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language
{
  @EndUserText.label: 'Material'            key matnr                as Material,
  @EndUserText.label: 'Unit of Measurement' key meinh                as UnitOfMeasure,
  @EndUserText.label: 'Plant'               key _MaterialPlant.Plant as Plant,
  _MaterialText.MaterialName                                         as MaterialName,
  _Plant.PlantName                                                   as PlantName,
  _uomtext //to be used in SADL Mapping to access texts that are depending on language

}
union select distinct from t006
association [0..1] to t006a   as _uomtext on t006.msehi        = _uomtext.msehi
association [0..1] to I_Plant as _Plant   on $projection.Plant = _Plant.Plant

{
  @EndUserText.label: 'Material'            key cast('' as matnr )   as Material,
  @EndUserText.label: 'Unit of Measurement' key t006.msehi           as UnitOfMeasure,
  @EndUserText.label: 'Plant'               key cast(''  as ewerk )  as Plant,
  cast(''  as maktx )                                                as MaterialName,
  cast(''  as ewerk )                                                as PlantName,
  _uomtext
}
where
  t006.kzkeh <> ''

Learn More