SAPSCRIPT - PO - STANDARD

[Former Member]

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

[Former Member]

Hi Esaki,

You can use a function module "PRICING" to get tax details.

Please acknowledge.

With Best Regards,

Bodhisattwa Debnath

[Former Member]

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..

[Former Member]

Thanks,

But my req is to get TAX %,

Ex: 4 %

Thanks

Esaki

[Former Member]

Hi Esaki,

You can use a function module "PRICING" to get tax details.

Please acknowledge.

With Best Regards,

Bodhisattwa Debnath

[Former Member]

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

[Former Member]

Hi Everybody,

Thanks for your suggestions.

Solved by using the fn: GET_TAX_PERCENTAGE

Regards,

ESAKI

[Former Member]

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