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

Records in setup table

Hi Gurus,

I had a query regarding the total no. of records in setup table of a particular datasource say for 2LIS_13_VDKON

If i want to know the number of entries in the setup table for this datasource how can i do that ? RSA3 extractor can do this but i just want number of entires only.

Is there any database table to store the data of setuptable for it ?

Sonal...

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 07:33 AM

    Hi Sonal,

    U can try in SE16 --> MC13*KONSETUP which is a structure name (F4).. and then select ur structure name and then enter. And check for the number of entries.

    Or u can use RSA3 to findout the same where u need to provide the proper celll info to get the total count.

    Or u can check NPRT T-code to get the total count for that application from the previous setups.

    thanks

    Hope this helps

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 17, 2008 at 07:23 AM

    Hi,

    For each extract structure, one setup table with the name of the extract structure and 'SETUP' as a suffix exists.

    for sales order setup tables will be like this

    for header : mc11va0hdrsetup

    for item level : mc11va0itmsetup

    for schedule line : mc11va0sclsetup

    You can view the data of setup tables in se11 or se16.

    Hope this helps.

    Thanks,

    JituK

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      yes, have checked up with mc13vd0konsetup for 2LIS_13_VDKON

      but it doesnot actually shows the number of entires. moreover it stores the data cluster . so it doesnot gives exact no of records for 2LIS_13_VDKON.

  • Posted on Jun 17, 2008 at 07:26 AM

    Hi,

    In RSA3 itself you can see the no.of records.

    Give the datasource name, just click on Extraction you will get a message which gives the no.of records count.

    You want to see the list, just click on display list

    Thanks

    sreeakanth

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 17, 2008 at 09:36 AM

    Hi you can try to check the log of the SET UP TABLES inizialization . There you can find for each structure the number of records of the inizialization

    Transaction CODE--> NPRT in r/3 you will find the inialization jobs with the records extracted

    Hope it helps

    Andreas

    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.