Question Re: Set up Table filling Error for SD Module in Technology Q&A

Set up Table filling Error for SD Module

Former Member — Sat, 14 Sep 2013 07:03:26 GMT

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

Re: Set up Table filling Error for SD Module

RamanKorrapati — Sat, 14 Sep 2013 12:36:23 GMT

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

Re: Set up Table filling Error for SD Module

former_member182470 — Sat, 14 Sep 2013 12:52:00 GMT

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

Re: Set up Table filling Error for SD Module

MGrob — Sat, 14 Sep 2013 15:00:38 GMT

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

Re: Set up Table filling Error for SD Module

former_member182196 — Sat, 14 Sep 2013 16:34:31 GMT

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

Re: Set up Table filling Error for SD Module

Former Member — Sun, 15 Sep 2013 09:22:26 GMT

hi Dear,

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

Mayur

Re: Set up Table filling Error for SD Module

Former Member — Sun, 15 Sep 2013 09:25:40 GMT

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

Re: Set up Table filling Error for SD Module

RamanKorrapati — Sun, 15 Sep 2013 09:32:33 GMT

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

Re: Set up Table filling Error for SD Module

former_member182470 — Sun, 15 Sep 2013 10:05:50 GMT

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

Re: Set up Table filling Error for SD Module

Former Member — Sun, 15 Sep 2013 10:49:28 GMT

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.

Re: Set up Table filling Error for SD Module

former_member182470 — Sun, 15 Sep 2013 11:02:14 GMT

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..

Re: Set up Table filling Error for SD Module

MGrob — Sun, 15 Sep 2013 11:05:12 GMT

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

Re: Set up Table filling Error for SD Module

RamanKorrapati — Sun, 15 Sep 2013 12:04:14 GMT

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

Re: Set up Table filling Error for SD Module

former_member182196 — Mon, 16 Sep 2013 05:56:18 GMT

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

Re: Set up Table filling Error for SD Module

Former Member — Mon, 16 Sep 2013 08:12:18 GMT

Hi All,

I loaded data using series and issue got Resolved

Thanks a lot

Mayur

Re: Set up Table filling Error for SD Module

former_member182470 — Mon, 16 Sep 2013 08:14:02 GMT

Good to know that. Please close this thread..

Re: Set up Table filling Error for SD Module

RamanKorrapati — Mon, 16 Sep 2013 08:14:46 GMT

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

Re: Set up Table filling Error for SD Module

former_member182196 — Mon, 16 Sep 2013 09:35:30 GMT

Hi,

Good to know that, your issue has been resolved.

Please close the thread.

Regards,

Satendra Mishra

Re: Set up Table filling Error for SD Module

Former Member — Fri, 27 Sep 2013 08:05:23 GMT

Hi,

Can you please guide me how to close the thread

Thanks

mayur

Re: Set up Table filling Error for SD Module

former_member182196 — Fri, 27 Sep 2013 08:11:13 GMT

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