topic Re: table VK13 in Application Development and Automation Discussions

table VK13

Former Member — Fri, 15 Jun 2007 06:21:30 GMT

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.

Re: table VK13

Former Member — Fri, 15 Jun 2007 06:25:07 GMT

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

Re: table VK13

Former Member — Fri, 15 Jun 2007 06:25:28 GMT

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

Re: table VK13

kiran_k8 — Fri, 15 Jun 2007 06:26:33 GMT

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.

Re: table VK13

Former Member — Fri, 15 Jun 2007 06:29:07 GMT

check with

KONV

KONP

A004

A005

A006

Re: table VK13

Former Member — Thu, 29 Nov 2007 11:01:48 GMT

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