cancel
Showing results for 
Search instead for 
Did you mean: 

Extraction from table.

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

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
0 Kudos

Hi AHP.

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

Regards,

Rambo.

0 Kudos

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.

Answers (2)

Answers (2)

Former Member
0 Kudos

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
0 Kudos

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