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

lis setup

Posted on Dec 02, 2004 at 07:23 AM 27 Views

for lis when i am try to get data frm r/3.

i am using the infostructure and using version comparision i m tryting to get data into s001. the problem is i am getting only 9 records for sales order setup(i.e. in transaction OLI7).

but when i check in VBAK table it has 500 records.

can anybody tell from which table is OLI7 transaction is getting the sales order details.

thanx in adv

vijay vedhere

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 02, 2004 at 07:42 AM
    0

    Hi,

    you need to check your materials (may be also the sales order types) for statistical relevance. If there is no statistics group assigned to the material, it doesn't get posted to the statistics infostructures.

    And yes, vbak is one of the relevant tables, but also vbap, vbpa, vbfa, vbuk, vbup...

    regards

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Dec 02, 2004 at 11:26 AM

      Hi,

      is there any special reason why you're dealing with the S001 info structure? State of the art, for extracting sales order data, are the datasources 2LIS_11_VAHDR, 2LIS_11_VAITM and 2LIS_11_VASCL for header, item and schedule line data. These datasources are much more flexible and easier to use than the old info structures. Check out, if the data you need can be extracted by those datasources.

      Unfortunately it is some years ago that I worked with the old info structures S*, so in the moment I'm not able to help you out with that, but what you can do is, check S001 and S001BIW1. Check the structure, the field types ... Reactivate your datasource for S001 from BCT.

      regards

      Siggi

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2004 at 03:58 PM
    0

    Maybe try and re-order the delta table in SE11 so that it matchs S001. Reactivate the table and try again.

    Looks similar to sap note 115192 (i think)

    Regards

    Dave

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2004 at 10:21 PM
    0

    Let us know if S001 is being used for Std. R/3 reporting at all or is it that you are doing this for the purpose of BW. While I understand that there has been no replacement for Structure S001 in LO. However, you have the LO structures 2LIS_11_xxxx.

    If you still wish to work on S001, then you need to change the delta structure S001SBIW1. Some of the fields are transposed and hence you cannot generate the LIS environment. Once you do this and activate your problem will be solved. The best way to do is look at the table def of S001 and make necessary changes to S001SBIW1 (I dont think S001SBIW2 has this problem just chack).

    There is a note as Dave pointed out.

    KRK

    Add a comment
    10|10000 characters needed characters exceeded

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.