LIS updation

[krishnaswamy_kumaraswamy]

HI

in a roll out project

i have not activated the LIS ,

subsequent data have been entered

recently i have activated the LIS

i need to pull the data in to LIS

kindly tell me the step how to get data in all LIS reports

[krishnaswamy_kumaraswamy]

Pls help

[Former Member]

HI

If you are trying this first time and on production system

PLEASE BE CAREFUL......

You can first try it at Qulaity or development and then actually perform the steps at production

Once you activate the LIS , the update happens as and when you create the transaction data ( Eg orders, delivery. billing etc)

But you need to get your old data also

for that go to trasaction

OLI7

OLI8

OLI9

You ca upload your old data into the LIS structure you have created.

Eg for orders ,

you need to specify the order number from starting till end

and continue process same for delivery and billing .

&( is the temp storage and later you should delete the data from that.

Regards

KRSNA

[Former Member]

LIS

The LIS is a central integrated information system where one can create specific tables that are updated at specific stages and that can be used to report on values contained in specific fields. SAP has standard information structures for reporting purposes. The std info structures can be accessed via: LOSDSISStandard analysis. The reports use the following characteristics: customer, material, sales org, shipping point, sales employee, and sales office.

IMG menu path for SIS: IMG>Logistics General>Logistics Information System (LIS)

The Logistics data warehouse is divided into two main sections: data basis and updating. Data basis is responsible for the actual design of the info structure, that is, what key fields are reported on or displayed. Updating is responsible for the updating rules used by the system, determining how the info structure is to be updated, and when this updating is to take place.

Task 1: Create Self-Defined Information Structure

Use transaction code MC21 (menu path Logistics Data Warehouse>Data Basis>Information Structures>Maintain self-defined information structures> Create) to create a Self-Defined Information Structure. Give a customer-range number 990 (any available number between 501 and 999). To make it easier, use ‘copy from’ to copy structure from S001.

Task 2: Maintain Update Groups

SIS IMG>Logistics Data Warehouse>Updating>Updating Definition>General Definition Using Update Groups>Maintain Update Groups

You can use the existing system-delivered update groups. Use Update Group (UpdGrp) 1 for the standard order process of: SIS: Sales Document, Delivery, Billing Document and use UpdGrp 2 for the SIS: Returns, Returns Delivery, Credit Memo.

Task 3: Maintain Update Rules

SIS IMG>Logistics Data Warehouse>Updating>Updating Definition>Specific definition using Update Rules>Maintain Update Rules>Create Create (transaction code MC24). To make it easier, use ‘copy from’ to copy update rules from S001.

Please make sure the Source information is properly updated for all the characteristics. Since you copied the rules, the sales order and item rules are defaulted too. Make sure appropriate changes are made for events VC (delivery) and VD (Invoice).

Task 4: Maintain Statistics Groups

Maintain Statistics Groups

Maintain Statistics Groups for Customers, Materials, and SD Document Types etc. Most of the pre-defined settings are enough. Make sure that settings are updated for customized objects too, e.g., SD document types for your organizations.

Also, make sure that the customer (sales view) and material Master records are updated with appropriate Statistics Groups.

Maintain Statistics Groups for Customers, Material and Sales documents. Assign Statistics Groups for relevant Sales Document Type, item type, delivery type, item type, Determine Billing Document Types Relevant to Statistics.

Update Customer Master for Statistics Relevancy

Transaction Code XD02 (Sales view, field “Cust stats.Grp”)

Update Material for Statistics Relevancy

Transaction Code MM02 (Sales 2 view, field “Matl statistics grp”)

Task 5: Assign Update Groups to Header and Item Levels

Assign Update Groups on Header and Item levels

For combinations of Sales Area (Sales Org, Distribution Channel, Division), assign Update groups (transaction codes OVRO and OVRP).

SIS IMG>Logistics Data Warehouse>Updating>Updating Control>Settings: Sales>Update Group

- Update Groups at Item Level

- Update Groups at Header Level

Task 6: Activate SIS Update

Lastly, Activate SIS Update for the Structure (transaction code OMO1)

SIS IMG path: Logistics Data Warehouse>Updating>Updating Control>Activate Update>Choose Activity as Sales and Distribution.

Last update our SIS structure S677 with period as ‘Month’ and update option of ‘Asynchronous Updating (2)’.

Regards,

Rajesh Banka

[Former Member]

Hi Krishna swamy,

i am not sure on this but i have an idea, if you are not assigned Statistical values to all the masters and Sales document type this data will not update and also u need to choose asynchronies filed at the time of activation Info Structure..(OMO1) double click the Info structure..

We need to Assign Statistical value to CMR, MMR and Sales order Header and item category, delivery doct type and Delivery item category and activate the filed statistical in billing document type.

Path:

IMG --> Logistic general --> LIS ---> Databasis..

Here u can assign all these this things...

rewards, if it is useful...

Regards,

Durga Prasad