Skip to Content
0

SAP EXtraction using BODS produces Duplicates while unnesting??/

Jun 08, 2017 at 02:51 PM

38

avatar image
Former Member

Hi Gurus,

Scenario:

I am extracting data using a Function module in normal data-flow.

Input Type: Table carrying Product Numbers

Out Put type: Table

I am unnesting output Table as required for table loading.

Question:

When I am passing 5 Product Numbers, SAP is giving me 5 lines in output while unnesting same BODS produces 25 lines by producing each line 5 times.

And when I am passing 48 product numbers, SAP is giving correct 48 records but while unnesting BODS is repeating each single record 48 times and producing 48*48 lines in output.

Is it normal functionality in BODS to use Distinct in further queries to obtain unique records.

As I am supposed to pass 10K product numbers in production, so it will create huge loop and huge output while unnesting.

Please provide me with Solution.

Thanks,

Parijatam

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers