2007 Jun 15 7:21 AM
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.
2007 Jun 15 7:25 AM
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
2007 Nov 29 11:01 AM
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
2007 Jun 15 7:25 AM
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
2007 Jun 15 7:26 AM
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.
2007 Jun 15 7:29 AM