2008 Sep 10 10:41 AM
Hi,
How to get tax value in PO.
for ex:
SELECT SINGLE MWSKZ FROM EKPO INTO W_MWSKZ WHERE EBELN = W_EBELN
AND EBELP = W_EBELP.
MWSKZ is V1.
then how to get 4% tax.
Can you suggest me the way to get it.
Thanks in advance.
Esaki
2008 Sep 10 10:53 AM
Esaki,
For gettingt he tax value in PO you have to write a subroutine in an external program.
In PO form youhave to call the subroutine by passing the PO number (EBELN) and then import the Tax value.
In the subroutine you can calculate the 4% of the tax value and then pass it back to PO Form.
Example:
IN SAPP Script
DEFINE <VAR1-EBELN>
DEFINE <VAR2-TAX>
PERFORM GET_ADDRESS IN PROGRAM ZProgram
USING <VAR1>
CHANGING <VAR2>
ENDPERFORM
You have to write a subroutine pool program in ABAP where in you fetch the data and pass/export back the relavant data to SAP Script.
Regards..
Thanks,
But my req is to get TAX %,
Ex: 4 %
Thanks
Esaki
2008 Sep 10 10:53 AM
Esaki,
For gettingt he tax value in PO you have to write a subroutine in an external program.
In PO form youhave to call the subroutine by passing the PO number (EBELN) and then import the Tax value.
In the subroutine you can calculate the 4% of the tax value and then pass it back to PO Form.
Example:
IN SAPP Script
DEFINE <VAR1-EBELN>
DEFINE <VAR2-TAX>
PERFORM GET_ADDRESS IN PROGRAM ZProgram
USING <VAR1>
CHANGING <VAR2>
ENDPERFORM
You have to write a subroutine pool program in ABAP where in you fetch the data and pass/export back the relavant data to SAP Script.
Regards..
2008 Sep 10 11:27 AM
2008 Sep 10 11:38 AM
Hi Esaki,
You can use a function module "PRICING" to get tax details.
Please acknowledge.
With Best Regards,
Bodhisattwa Debnath
2008 Sep 10 11:38 AM
well if u have access to [ME23N] tcode for standard PO, in for a PO you can see in the item details tab under it ther you will find a conditions tab,,in this you can get whatever you want,,
if still u are unable to get then please let me know your problem in more detail.
the percentage value is stored in KBETR field and the corresponding amount in KWERT .
SId.
Edited by: Siddhartha Prakash on Sep 10, 2008 1:40 PM
Edited by: Siddhartha Prakash on Sep 10, 2008 1:40 PM
2008 Sep 11 5:49 AM
Hi Everybody,
Thanks for your suggestions.
Solved by using the fn: GET_TAX_PERCENTAGE
Regards,
ESAKI
2008 Sep 10 10:54 AM
you can find the tax details in KONV table in field you can relate KONV-KNUMV = EKKO-KNUMV.
you can get the tax values in condition type field KBETR and their corresponding values in field KWERT.
hope this may be useful for you.
Sid
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |