I started this site for helping who needs help. Now I have my own website (www.mehmetavsar.com). But currently its language is Turkish. But Abap’s language is supranational. You can check my forum (http://forum.mehmetavsar.com/) for looking some interesting codes.
Currently I am working a consultant. I know MM and ABAP.
Bu blog Mehmet Avşar tarafından ABAP dünyasını tanımaya çalışan kişilere bir rehber olması amacı ile, yazılım tarafında yaptığı çalışmalarını tuttuğu bir blogtur.
Blog sahibinin ayrıca SAP hakkında yayınladığı bir blogu da bulunmaktadır.
Mehmet Avşar evli ve bir çocuk babasıdır.
1 comment
Comments feed for this article
September 12, 2008 at 12:09 pm
vipul
hi friend,
I want this report using ABAP query (do not use ABAP ALV)
i want to create report with 4 tables MARA,MAKT,MVKE,MARM
You have to create a new report that extract in output:
1.material code(mara-matnr)
2.material description(description in the language you choose)(makt-maktg)3.BaseUnitofMeasure(mara-meins)4.language(makt-spras)5.Sales Organization (mvke-vkorg)6.Sales unit (mvke-vrkme) 7.conversion coefficient from base unit of measure to sales unit of measure 8.conversion coefficient from base unit of measure to box
INPUT :
1.material code
2.base unit of measure
3.Sales Organization
4.language
Description what i want in Output:
i explain here with example.
you use MARM table for extract unit measure.
For example for material ‘0110.10.1L’ you find
matnr meinh umrez umren
0110.10.1L CS 103 100
0110.10.1L FG 103 1.000
0110.10.1L M2 1 1
0110.10.1L SF 250 2.704
it means that base unit of measure is M2 because umrez=umren=1
sales unit of measure is blank (mvke-vkorg ), when it is blank it is equal to base unit measure, so sales unit of measure became M2, so in this case :
conversion coefficient from base unit of measure to sales unit of measure = 1
about the other coefficient…
conversion coefficient from base unit of measure to box
umrez umren
103 100
it means that 1 CS (box) is 1,03 M2 ,
so conversion coefficient from base unit of measure to box = 1,03
thanks
vipul_14228@hotmail.com