Skip to Content
0
Dec 24, 2012 at 06:31 AM

Reporting requirement..

23 Views

Dear Experts,

I have the following requirement for a number of BW reports , Data is coming from R/3.

1. 1)

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?

2.

2)

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,

Plnt

Material

Month

Loc.curr.amount

Quantity

HALD

3TT300

200803

1,175,934.00

150

SHAM

3TT300

200803

1,694,415.84

208

Please suggest , How to write the code ?

3)

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 ?

Regards,

Sanjana