Data Extraction

[Former Member]

Hi

I need to extract country specific data from tables. For example I need to get the details of the list of payment terms used for Japan or Payment Method from KNB1 applicable for Japan only. Please help

Regards

Srikkanth

[Lakshmipathi]

You have to table join in SQVI for the following fields

VBRK::::LAND1:::Destination country

KONP::::MWSK1:::Tax Code

thanks

G. Lakshmipathi

[Former Member]

Hi,

Check T005A table,

Thanks,

Raja

[Former Member]

Hi Raja,

T005A is not active in dictionary. Can I get some more suggestions.

Regards

Srikkanth

[Former Member]

Srikanth,

Try T005, as this is the country specific table

Thanks,

Raja