table VK13

[Former Member]

For customer/material/route combination in transaction VK13, I need the table name from where I can extract rate/description/route/unit etc.

How can I find the related table name.

[Former Member]

Hi,

Go to VK13

give the condition type..

Choose the key combination..

Press enter..

you will get a selection screen..

In there place the cursor on one of the fields..

Press F1..

Press Technical info button..

There you can find the table name behind the key combination..

Once you get the condition table..to get the rate use the table KONP.

The relation is..

lets say the condition table is A005

A005-KNUMH = KONP-KNUMH...

Thanks

Naren

[Former Member]

Hello Guru's,

I want to write ABAP report to list out Material,Customer,Tax type and Tax amount. The data is available in tables A005 and KONP and the joining condition would be A005-KNUMH and KONP-KNUMH.

But since A005 s a Pooled table am not able to write a correct join condition.

Can any one guide me on how we can write this join condition?

Thanks,

B P Shah

[Former Member]

Hi

It will be in some A* table, based on the Access sequence

Check the A* tables in Se11

It is like A005 or A117

check for route search string option

and fine the right table

Take the KNUMH field from this A8 table and pass to KONP-KNUMH and take the KBETR or KWERT fields for that

Reward points for useful Answers

Regards

Anji

Message was edited by:

Anji Reddy Vangala

[kiran_k8]

SV,

Go to VK13.

and place the curose on the field for which you want to get the info.

press f1.

go to the technical info button,where you can see from which table it fetches the field.Sometimes it shows a structure,then you need to find the table related to that structure.

K.Kiran.

[Former Member]

check with

KONV

KONP

A004

A005

A006