11-19-2007 10:47 AM
hello experts
I want to know how to get the Tax break ups In Sales Order Or purchase order under the conditions tab as it is not stored in Database.
And The Text Fields In Miro screen where it is stored In Db and how can i retrieve it ???
How to retrieve Data using fuction Module. from Database??
if possible Plz attach a Code.
sap_abap1982@rediffmail.com
Plz reply as it is urgent
Thanx and Regards
11-19-2007 10:58 AM
hi
See table LFA1 AND USE TCODE :SE16
U WILL GET GENERAL INFORMATION
BYE
K
11-19-2007 10:59 AM
Hi
All tax related amounts are stored in KONV and KONp tables based on condition Types(KSCHL) field
so for sales order take the VBAK-KNUMV and pass to KONV table and take the different tax amount sbased on the KSCHL field
similarly for PO
Take the EKKO (po Header) KNUMV field and pass it to KONV-KNUMV and get the condition type based amounts (KBETR and KWERT) from table KONV
Or search for the Condition tables in which the tax related COnditions are maintained for that Tax COde (like A003 or some other A* table) and take the KNUMH field from it and pass it to the table KONP and take the condition type based all tax amounts from KONP tables.
Regards
Anji
11-20-2007 4:18 AM
hii anji
Thanx for your Co-opration I will try it
and another thing in Delivery Or In mIGO there are some text fields
where this text fields are stored in SAP and how can i retrieve it in a a report??
ANOTHER THING HOW CAN I RETRIVE DATA USING A FUNCTION MODULE FROM DATABASE?
Thank You
11-20-2007 4:18 AM
hii anji
Thanx for your Co-opration I will try it
and another thing in Delivery(VL01N) Or In MIROthere are some text fields
where this text fields are stored in SAP and how can i retrieve it in a a report??
ANOTHER THING HOW CAN I RETRIVE DATA USING A FUNCTION MODULE FROM DATABASE?
Thank You