Skip to Content
author's profile photo Former Member
Former Member

Query on S900 and S901

Hi Experts,

I wish to build a query on S900 and S901 but, there is no standard dtasopurce built on it.

Can anyone plz help ?

Regards,

Romil

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 15, 2011 at 11:30 AM

    hi,

    You can activate the LIS DS based on the above structures.

    If the Structures S900 & S901 are already active in the system then follow the steps below.

    T.code – LBW0 - Connection of LIS Information structures to SAPBW

    Information structure : S*

    Select the radio button-Setup LIS environment and Execute.

    Select the radio button-Generate data source and Execute.

    For Delta update:

    Select the radio button-Generate updating and Execute

    Select the radio button -Activate / deactivate and Execute.

    T.code – SBIW – Display IMG (implementation guide)

    Setting for applications specific data source – logistics – Managing transfer information structure – setup of statistical data – applications specific setup of statistical data –perform statistical setup – sales.

    Choose activity

    Setup – Orders, deliveries, billing

    Choose the activities enter the infostructure (S*), give name of the run, date of termination, time of termination, No. of tolerated faulty documents. Then execute

    T.code – RSA3 – Extractor checker

    Give the data source name eg. 2LIS 01S* and execute, result will get some records

    Go to BW side replicate data source – Assign infosource – Create infocube – Create update rules – create infopackage and schedule the package with initialize delta process.

    You can change the update mode in tcode OMO1.

    regards.

    Arvind.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi,

      In LBW0 after you have setup LIS environment and Generated the DS, click on the display setting for the DS.

      If everything is fine goto BW, Replicate DataSource, and run info Package with Initilization.

      Now again in R/3 we need to "Activate" Delta option from transaction code LBW0 and last step is to goto OMO1 to activate LIS Update to Synchronous updating and save. In OMO1 find the structure and double click on it to get the update mode option.

      Sometimes the structure do not support delta mechanism in that case you need to load full data from BW for those.

      regards,

      Arvind,

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.