Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_PurOrdMaintainUoMValHelp

DDL: C_PURORDMAINTAINUOMVALHELP SQL: CPOMAINTVHUOM Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN
10 Fields 2 Data Sources 3 Associations 1 OData Services 1 Fiori Apps

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.

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 Material Description
PlantName I_Plant PlantName Plant Name
KEY UnitOfMeasure t006 msehi Unit of Measurement
KEY Plant Plant
MaterialName Material Description
PlantName Plant Name
_uomtext _uomtext

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_PurOrdMaintainUoMValHelp.
-- 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: CPOMAINTVHUOM

CREATE VIEW C_PurOrdMaintainUoMValHelp AS
SELECT
  matnr AS Material,
  meinh AS UnitOfMeasure,
  _MaterialPlant.Plant AS Plant,
  _MaterialText.MaterialName AS MaterialName,
  _Plant.PlantName AS PlantName
LEFT OUTER JOIN I_MaterialPlant AS _MaterialPlant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS _Plant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t006a AS _uomtext ON UnitOfMeasure = _uomtext.msehi  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;

Learn More