I have the following requirement for a number of BW reports , Data is coming from R/3.
Manufacturing month( BEZEI)=HALD-MAR-2008. It shows the material is manufactured in HALD plant in March,2008.
I need to split it into two info-objects like
Info object-1 = HALD
Info object-1 = MAR-2008.
What to write in the code in BW side?
We have material like ZE00-3TT300. The manufacturing month and manufacturing plant data is stored in table ZMATPLNT.
I need to do the Lookup the ZMATPLNT with reference to material ZE00-3TT300. Here during the lookup it finds with 3TT300
instead of ZE00-3TT300.It omits the first 5 character and find s the Material code like 3TT300.
The table holds the data like this,
Please suggest , How to write the code ?
3. We maintain the manufacturing month like 201203 (MAR-2012). Whenever it calculates the the age of the material , it automatically
takes the manufacturing date as 01-03-2012 ( 01-MAR-2012 ). So that it can get the ages like ,
Age = Current Date – Manf. Date .
How can I assign 01.03.2012 from 201203.
Please sugest , How should I proceed ?