1. Objective
The objective of this blog is to explain how to convert material quantity unit into base unit or another alternative unit of measure as per MARM table (defined in material master).
2. Requirement
Requirement is to fetch material quantity from a DB table and then display that quantity on screen. But the unit of measure in which material quantity needs to be displayed on UI can be different than the unit of measure in which it is saved. The standard quantity conversion function ‘UNIT_CONVERSION’ which is provided in CDS can’t be used in this case as it performs the unit conversion based on the rules stored in transaction CUNI and in the database tables T006. But in our scenario, we need to perform material quantity conversion based on the alternative unit of measures defined in material master (available in MARM table).
Let’s take the below example:
Material Base Unit of Measure = ‘CV’ (Case)
Alternate Unit of measure maintained in material master are: ‘PC’ (Piece) & ‘PAL’(Pallet).
Entries in MARM table:
In CDS view, quantity will be fetched from database table & then it will check if the Unit of measure in which quantity needs to be displayed on UI is different from unit of measure stored in database table, then it will get the conversion formula maintained (in MARM) using associations on standard CDS view I_PRODUCTUNITSOFMEASURE. Therefore the quantity will be converted to the base unit of measure and then it will be converted from base unit of measure to the display unit of measure.
3. Design
The following steps explain step by step configuration:
- Create a CDS view and fetch the quantity data from the DB table.
- In that CDS view make an association on SAP standard CDS view I_MATERIAL (CDS view for MARA table) to get the material base unit of measure.
- Two times Association or Left outer join on I_PRODUCTUNITSOFMEASURE (Standard CDS view of MARM table) using key Material and unit of measure. One with the Display Unit of measure and one with unit of measure in which quantity is stored in DB.
4. Coding
Create the below CDS View:
@AbapCatalog.sqlViewName: 'ZMATQUAN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Material Quantity'
define view Z_MATERIAL_QUANTITY
with parameters
p_disp_unit : meins
as select from zmat_quan as MatQuan
// For Base Unit of Measure
association [0..1] to I_Material as _MARA on MatQuan.matnr = _MARA.Material
// Association on CDS view of MARM table
association [0..1] to I_ProductUnitsOfMeasure as _ProductUnitUI on _ProductUnitUI .Product = MatQuan.matnr
and _ProductUnitUI .AlternativeUnit = :p_disp_unit
association [0..1] to I_ProductUnitsOfMeasure as _ProductUnitEntryUnit on MatQuan.matnr = _ProductUnitEntryUnit.Product
and MatQuan.qty_unit = _ProductUnitEntryUnit.AlternativeUnit
{
bukrs,
plant,
matnr as Material,
del_quan as DeliveryQuantity,
qty_unit as DeliveryUnit,
$parameters.p_disp_unit as DispUnit,
_ProductUnitUI,
_ProductUnitEntryUnit,
_MARA.Material as mat,
case
when MatQuan.qty_unit = :p_disp_unit
then del_quan
else
case
when _MARA.MaterialBaseUnit = $parameters.p_disp_unit
then del_quan* DIVISION( (_ProductUnitEntryUnit.QuantityNumerator), (_ProductUnitEntryUnit.QuantityDenominator), 3)
else
del_quan* DIVISION( (_ProductUnitEntryUnit.QuantityNumerator*_ProductUnitUI.QuantityDenominator), (_ProductUnitEntryUnit.QuantityDenominator*_ProductUnitUI.QuantityNumerator), 3)
end
end as DisplayQuantity
}
5. Test
- Data in the custom table:
- Execute the CDS View & provide Display Unit of Measure (In which unit result is required). In our case we are providing ‘ST’ (which is internal format for ‘PC’ Piece).
- Result:
The material quantity is successfully converted into Piece from Pallet.
6. Limitations
- All unit of measure’s (Base as well as alternative) in which quantity conversion is required should be maintained in material master.
- SAP Managed Tags:
9 Comments
