Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Question from rgarzae on Jun 28 at 4:13 PM Hello gurus,
We have material ledger and the need of several standard reports with both currencies.
Currently I am struggling with standard MI07 report.
I started from scratch using table ISEG as starting point.
I know I won't be able to have the price conversion at the time the Phis. Inv. Doc. was created or counted because there is no posting in MM and therefore I can only use an approximation. But I want to be able to display the value in both currencies prior to posting (provided that MAP does not change while the document is not posted).
I used the following logic:
•From MBEW using material (ISEG-MATNR) and Plant (ISEG-WERKS) retrieve the value of Cost Estimate (MBEW-KALNR).
•From IKPF using physical document number (ISEG- IBLNR) retrieve Fiscal year (IKPF- GJAHR), Fiscal Period (IKPF- MONAT), Date of last count (IKPF- ZLDAT)
•From CKMLCR using Cost estimate number (MBEW-KALNR), Fiscal year (IKPF- GJAHR), Fiscal Period (IKPF- MONAT), and group currency (CKMLCR- CURTP = 30) retrieve total value (CKMLCR-SALK3).
•Calculate MAP in new variable as ((CKMLCR-SALK3 * 100) / MBEW-LBKUM))
•Multipy MAP in new variable by quantity difference (ISEG-MENGE - ISEG-BUCHM) / 100.
However I get some inconsistencies with MBEW prices.
Your help will be appreciated.
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
