Set up Table filling Error for SD Module

[Former Member]

Hi All,

I am filling setup table with Tcode OLI9BW.I am getting an error as shown below.

I want to pull  data from 1st may 2013 since the data volume is huge (5 Crore Approx) the loading time is more.

Can you please suggest some solution how can I load since data voulume is huge.

Thanks

mayur

[former_member182196 · Accepted solution]

Hi Expert,

I faced this problem before few days ago...So i am giving you solution what i did.

use that red mark option in given screen shot. but before that check the bill doc. no in VBRK and VBRP. Check same doc with other Bill doc in table level match the data for other doc and cress check SD Functional Consultant.

No. tolerated faulty documents = Like 50 or 100

I hope this will help you.

Regards,

Satendra Mishra

[Former Member · Accepted solution]

Hi Dear,

I want to  pull data from 1st May 2013 since there is no date field How can i pull data from 1st MAY 2013

Mayur

[RamanKorrapati · Accepted solution]

Hi Mayur,

You can load based on sales org/doc/comp code. While pulling data into info pack we may have create date/changed/calmonth/fisc period there will be some date field.  thru that we can load into PSA. .

While pulling thru info pack we can load selectively with full info pack on date field wise.

pls  you can  fill the setup tables(based on sales doc/comp code) now.

Thanks

[former_member182470 · Accepted solution]

Hi Mayur,

I did not observe that there is no date field in setup filling.

It is not possible to fillup setup tables from 1st May. Alternatively you can try with Company codes or other fields to reduce the data volume. Also do not forget to specify No. of Faulty documents.

Regards,

Suman

[Former Member · Accepted solution]

Hi,

I have filled according to series wise keeping tolerance 100.The job is started yesterday and it is still running today.Is there any issue.

[former_member182470 · Accepted solution]

If your selection is small, then it should not run for such a long time. It's better to kill this job and run as per my suggestion.Check my latest reply..

[MGrob · Accepted solution]

those setup tables fillups can take long. depends on what you have selected in range.

[RamanKorrapati · Accepted solution]

Hi,

No Issue, As you gave a series number its may loading historic records also. let it be.

Once its finished you can check the records at SE11 with SETUP table name of respective data source or TX - NPRT with help of Name of the run.

Setup table name - Extract str name<SETUP>

As you said its have huge records, its always take time.

Thanks

[former_member182196]

Hi,

Make any answer as a correct answer and assign points who gave you best and and helpful.

And write down i am closing this issue or thread.

Regards

SM

[former_member182196]

Hi,

Good to know that, your issue has been resolved.

Please close the thread.

Regards,

Satendra Mishra

[Former Member]

Hi,

Can you please guide me how to close the thread

Thanks

mayur

[Former Member]

Hi All,

I loaded data using series and issue got Resolved

Thanks a lot

Mayur

[former_member182470]

Good to know that. Please close this thread..

[RamanKorrapati]

Hi,

Thats nice, While pulling into bw side, at info pack selection tab you can use date field created on or changed on if you have. Enter dates  1 MAY 2013 to till today and pull them to PSA.

Thanks

[former_member182196]

Hi,

That you can do in BI side at info package level, but i will suggest you don't filter any data in ECC side, do it in BI side.

Bcz if filtering data in ecc in setup table it will tack long time and schedule the job in background.

I hope this will help you.

Regards,

Satendra Mishra

[MGrob]

Hi

Either you allow faulty records and increase the threshold and then your setuptable filling will work or you have to maintain fx rates for those currencies that it could not convert according to your screenshot.

hope it clarifies

Martin

[former_member182470]

Hi,

Hope you have observed your screen shot closely. It says there are lot of faulty documents found while picking from the tables.

I suggest you to check VBAK and VBAP & other tables randomly for some documents with the help of your functional team.

If everything is Ok, then delete the setup tables once by LBWG and try to run from 1st May '13 to till date. Please lock data postings during filling.

Regards,

Suman

[Former Member]

hi Dear,

Since there is no option of date,How can I fill setup table using date e !st of May 2013.

Mayur

[RamanKorrapati]

Hi Mayur,

As pointed out by suman, your base tables have wrong format sales doc numbers. You need to check/rectify  the sales doc numbers  at base tables of your data source.once the sales doc numbers corrected then only you can delete and refill the setup tables.

as you said you have 5crs records, with help of SD team find the sales doc ranges and split the ranges if have huge transactions. fill the setup tables range( date wise also if possible) wise to finish setup tables filling smoothly. Better to perform this activity where there is no business transactions or lock respective t codes.

Thanks