topic Re: Creating LIS tables in Application Development and Automation Discussions

Creating LIS tables

Former Member — Wed, 09 Jan 2008 09:42:36 GMT

Hi all,

I need to create LIS tables, tables that start with 'S'.

How can I create them?

Thanks.

Re: Creating LIS tables

Former Member — Wed, 09 Jan 2008 09:52:32 GMT

Use the TCode - MC21

awrd points if useful

Bhupal

Re: Creating LIS tables

Former Member — Wed, 09 Jan 2008 10:26:37 GMT

good

This is bound to happened especially if the users made changes to the Purchase Order and you have set the online updates for your LIS. Fields like Material groups are consider keys fields and should not be change as it somehow impact the updates to LIS.

If the figures are wrong for a particular period, you can do a reorganization for all the Purchase Order for the particular months.

Assuming that you want to reorganize the whole S012.

When you execute OLI3, it will locked any Purchase Order that it is processing. Therefore, it is advisable to run it during off office hours.

First Step :-

OLI3 - Statistical setup of info structures from purchasing documents

Info structure to be set up S012

Save under version &(

Tick Delete/create indices

Specify the Purchasing Documents or Document Date

Name of run S012-1

Tick New run?

Date of termination 99.99.9999

Time of termination 99:99:99

Tick Redetermine update group?

Tick Update documents?

NPRT - Log for Setup of Statistical Data

thanks

mrutyun^

Re: Creating LIS tables

Former Member — Wed, 09 Jan 2008 11:12:43 GMT

Thank you Mrutyunjaya Tripathy.

What will I do to create a table S540.

And another question is that are these lis tables standard at all systems? Or they are created according to needs?

Could you please write me step by step to create a lis table?

Thanks.

Re: Creating LIS tables

Former Member — Wed, 09 Jan 2008 11:31:17 GMT

Goto Transaction MC21.

Enter S540. Enter Ur application and execute.

Then from the displaying Screen Select ur Characteristics and Key figures of ur LIS table..

Save.

LIS Tables from S001 to S500 are standard to any system. We can create from S501 to S999 tables for user needs.

awrd points if useful

Bhupal

Re: Creating LIS tables

Former Member — Wed, 09 Jan 2008 13:15:33 GMT

Thank you Bhupal.

Could you provide a little more detail?

What can I enter for characteristics etc...

Thanks all.