How to create a Custom LIS structure?

[Former Member]

Hi,

I want to build a custom LIS like S031.This table is having a date wise data.

I want to SUM them and compress it to monthly data.

Any ideas?

regards

praveen

[Former Member]

Hi,

I want to build a custom LIS like S031.This table is having a date wise data.

I want to SUM them and compress it to monthly data.

Any ideas?

regards

praveen

[Former Member]

Hi Praveeen,

You can use transaction MC21 to create custom info structure by copying from standard info structure S031.

Please ensure you give custom info structure name greater than S500 (i.e S531).

Range from S000 to S500 is belong to SAP.

Then you can use transaction MCSZ to generate a program for transferring data from S031 to S531. Please check the online documentation for step by step processing.

Lastly, you can use transaction MC9C to generate standard report for S531. In this report, you can perform subtotal and total based on the characteristic (key fields) of S531. No need to sum the records.

This is a drill down reporting.

Hope this will help to start with.

Regards,

Ferry Lianto

[Former Member]

Thank you Lianto,

I did create it by MC21 and activated it .Could you send me online link for MCSZ t-code?

Regards

Praveen

[Former Member]

Hi Praveen,

Could you send me online link for MCSZ t-code?

The online documentation is inside transaction MCSZ.

Please try this ...

1. Enter S531 for source info struc.

2. Press Enter.

3. Go to Scenario area. Select the appropriate subject and click on documentation.

4. You can also check the template as well.

Also please check this LIS document.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/LOLIS/LOLIS.pdf

Regards,

Ferry Lianto

[Former Member]

Hai Ferry,

I just wanted to thank you, As I had a problem with LIS structure creation and when I browsed SDN I found your post useful.

Thank you once again.

Can I have your email. ?

-Sri