Skip to Content
avatar image
Former Member

SAP EXtraction using BODS produces Duplicates while unnesting??/

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers