Extraction from table.

[Former Member]

Hi gurus,

i would like to extract data from a Transparent say SAP table.that's fine but when i supposed to save ..it raised an error with "invalid extract structure template"

Also in the error diagnosis i got this "You tried to generate an extract structure with the template structure XXX. This operation failed, because the template structure quantity fields or currency fields, for example, field CLABS refer to a different table."

So, for this how can i rectify and proceed furthur.

Regards,

Rambo.

[edwin_harpino · Accepted solution]

hi Rambo,

what sap table you are try to use ?

you cannot use table that has quantity or currency field that refer to other table, check the table you used, in tab 'check table' something, you should see the table is different from the table itself.

you may use table with quantity/currency refer to itself, alternatively you may use view, or function module. let's know your requirement, what data are you going to extract ?

hope this helps.

[Former Member · Accepted solution]

Hi AHP.

Yes there are quantity and currencey fields in the table ZC012.so for this how to do..

Regards,

Rambo.

[edwin_harpino · Accepted solution]

hi Rambo,

add/include the currency and quantity unit in your table zco12, then change the table check for the field to 'zco12'. this should remove the error. hope this helps.

[Former Member]

A better alternative is:

When you are creating a Z table/str from this sap table.

for your example :

click CLABS field (which you mentioned having ref to currency) there is describing of dat field

and in dat (in middle )there reference field for currency/quantity.

enter referenced table name and currency.

rdgs,

San!

[Former Member]

Hi Rambo,

as A.H.P mentioned, you need to create a view on your table and the corresponding unit tables to include the units into your extractor. Then it will work.

regards

Siggi