topic SAPSCRIPT - PO - STANDARD in Application Development and Automation Discussions

SAPSCRIPT - PO - STANDARD

Former Member — Wed, 10 Sep 2008 09:41:10 GMT

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

Re: SAPSCRIPT - PO - STANDARD

Former Member — Wed, 10 Sep 2008 09:53:31 GMT

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

Re: SAPSCRIPT - PO - STANDARD

Former Member — Wed, 10 Sep 2008 09:54:46 GMT

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

Re: SAPSCRIPT - PO - STANDARD

Former Member — Wed, 10 Sep 2008 10:27:49 GMT

Thanks,

But my req is to get TAX %,

Ex: 4 %

Thanks

Esaki

Re: SAPSCRIPT - PO - STANDARD

Former Member — Wed, 10 Sep 2008 10:38:21 GMT

Hi Esaki,

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

Please acknowledge.

With Best Regards,

Bodhisattwa Debnath

Re: SAPSCRIPT - PO - STANDARD

Former Member — Wed, 10 Sep 2008 10:38:23 GMT

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

Re: SAPSCRIPT - PO - STANDARD

Former Member — Thu, 11 Sep 2008 04:49:49 GMT

Hi Everybody,

Thanks for your suggestions.

Solved by using the fn: GET_TAX_PERCENTAGE

Regards,

ESAKI