Generic Extractor based on a view

[Former Member]

I am looking at a Generic Extractor which is based on a view which joins 5 tables.

If I run the extractor using RSA3 in the set of results it shows that there are 5 key fields. However one of them (Valuation type) has no value and is not also part of the join condition in the view.

Should it just be the join fields (ignoring MANDT) that make up the key fields. Thanks

[dielom · Accepted solution]

Hi Niten,

Not necesarily the join fields must be the whole key. Think about a Sales Order, with header and position data, where the join it is Client (Mandt) and Document Number, and the key must be Client, Document Number and Position (or material).

Hope it helps. If you need further information, just ask.

Regards,

Diego Lombardini

[Former Member · Accepted solution]

Thanks for that, therefore what determines what fields are key in this case

[dielom · Accepted solution]

Niten,

The key fields are determined by combination of the key fields of the tables you are using.

Regards,

Diego