topic Re: PO in Application Development and Automation Discussions

PO

Former Member — Fri, 24 Jul 2009 12:18:23 GMT

When i run a PO tcode and in its "Invoice" tab i have a button called "Taxes". When I click on that button , i get a tabstrip control depicting all tax conditions and its condional value.

I am unable to find out from which table that amount is getting fetched ,i mean in its technical info its showing a structure called komv.Now this structure refres to a table konv but konv does nt contain these contions.Infact this conditions are either present in BSET or T685 but which field in these tables contain the conditional value is still not knwn does anyone have any idea about this

Edited by: Julius Bussche on Jul 25, 2009 7:19 AM

Please use meaningfull subject titles otherwise your threads will be rejected

Re: PO

Former Member — Fri, 24 Jul 2009 12:24:25 GMT

All price conditions are in KONV, PO (Purchase Order?) table, EKKO, have the field KNUMV is field ke of KONV table.

So u need to find out the condition number (KNUMV) from EKKO and then read KONV table with condition type for tax.

Max

Re: PO

Former Member — Fri, 24 Jul 2009 12:24:59 GMT

From EKKO TABLE u get KNUMV field and then go to

o KONV table give KNUMV u get all the conditions

in KSCHL and Values in KAWRT KBETR KWERT

Surya

Re: PO

Former Member — Fri, 24 Jul 2009 12:37:46 GMT

Use the fm CALCULATE_TAX_ITEM and pass the value from EKPO to I_TAXCOM.

Regards

Shiba Prasad Dutta

Re: PO

Former Member — Fri, 24 Jul 2009 12:50:35 GMT

pass document cond KUNMV and KNTYP(Condit.category)= 'D' (for TAX) in KONV and fetch your desired record

Edited by: soumya prakash mishra on Jul 24, 2009 2:51 PM

Re: PO

Former Member — Fri, 24 Jul 2009 12:54:09 GMT

and yuo can fetch KUNMV from EKKO or BKPF according to your need

Re: PO

Former Member — Sat, 25 Jul 2009 05:09:19 GMT

Hello all,

thanks for your answers but in table KONV the KSCHL field does not contain the conditions "JEC4" and "JSVD" that i am looking for . Instead i can see them in table BSET and T685 (KSCHL). Now how can i link these to get the condition value fron KONV or any other table that contain this value . Please guide me through this.

Regards

Nupur Bhattacharya.

Re: PO

Former Member — Sat, 25 Jul 2009 18:18:17 GMT

Hi,

You can try the following.

1. Pass the conditions "JEC4" and "JSVD" in BSET and get the corresponding condition record number (BSET-KNUMH) for those conditions..

2. Pass the fetched (BSET-KNUMH) into table KONV for the field ( KONV-KNUMH) and get the corresponding document condition number (KONV-KNUMV).

3. pass KONV-KNUMV with EKKO-KNUMV and get the corresponding EBELN to get the PO's.

Regards,

Vik

Re: PO

Former Member — Sun, 26 Jul 2009 09:33:42 GMT

Hi,

Try this logic as reference ,you will get the desired output values,you should pass all values to the function module,what i have passed in TAXCOM structure,from the table IT_komv,you can get the values ,what they maintained in PO taxes,

TAXCOM-BUKRS = WA_EKPO-BUKRS.

TAXCOM-WAERS = WA_EKKO-WAERS.

TAXCOM-KPOSN = WA_EKPO-EBELP.

TAXCOM-MWSKZ = WA_EKPO-MWSKZ.

TAXCOM-SHKZG = 'H'.

TAXCOM-WRBTR = WA_EKPO-NETPR. "you should pass the value,otherwise,the condition value amount,it wont come

TAXCOM-XMWST = 'X'.

TAXCOM-EKORG = WA_EKKO-EKORG.

TAXCOM-MATNR = WA_J_1IEXCDTL-MATNR.

TAXCOM-WERKS = WA_EKPO-WERKS.

TAXCOM-MTART = WA_EKPO-MTART.

TAXCOM-EBELN = WA_EKPO-EBELN.

TAXCOM-EBELP = WA_EKPO-EBELP.

CALL FUNCTION 'CALCULATE_TAX_ITEM'

EXPORTING

ANZAHLUNG = ' '
DIALOG = ' '
DISPLAY_ONLY = ' '
INKLUSIVE = ' '
I_ANWTYP = ' '
I_DMBTR = '0'
I_MWSTS = '0'

I_TAXCOM = TAXCOM

PRUEFEN = ' '
RESET = ' '
IMPORTING
E_NAVFW =
E_TAXCOM =
E_XSTVR =
NAV_ANTEIL =

TABLES

T_XKOMV = IT_KOMV

EXCEPTIONS

MWSKZ_NOT_DEFINED = 1

MWSKZ_NOT_FOUND = 2

MWSKZ_NOT_VALID = 3

STEUERBETRAG_FALSCH = 4

COUNTRY_NOT_FOUND = 5

OTHERS = 6.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

LOOP AT IT_KOMV INTO WA_KOMV.

CASE WA_KOMV-KSCHL.

TAXCOM-BUKRS = WA_EKPO-BUKRS.

TAXCOM-WAERS = WA_EKKO-WAERS.

TAXCOM-KPOSN = WA_EKPO-EBELP.

TAXCOM-MWSKZ = WA_EKPO-MWSKZ.

TAXCOM-SHKZG = 'H'.

TAXCOM-WRBTR = WA_EKPO-NETPR.

TAXCOM-XMWST = 'X'.

TAXCOM-EKORG = WA_EKKO-EKORG.

TAXCOM-MATNR = WA_J_1IEXCDTL-MATNR.

TAXCOM-WERKS = WA_EKPO-WERKS.

TAXCOM-MTART = WA_EKPO-MTART.

TAXCOM-EBELN = WA_EKPO-EBELN.

TAXCOM-EBELP = WA_EKPO-EBELP.

CALL FUNCTION 'CALCULATE_TAX_ITEM'

EXPORTING

ANZAHLUNG = ' '
DIALOG = ' '
DISPLAY_ONLY = ' '
INKLUSIVE = ' '
I_ANWTYP = ' '
I_DMBTR = '0'
I_MWSTS = '0'

I_TAXCOM = TAXCOM

PRUEFEN = ' '
RESET = ' '
IMPORTING
E_NAVFW =
E_TAXCOM =
E_XSTVR =
NAV_ANTEIL =

TABLES

T_XKOMV = IT_KOMV

EXCEPTIONS

MWSKZ_NOT_DEFINED = 1

MWSKZ_NOT_FOUND = 2

MWSKZ_NOT_VALID = 3

STEUERBETRAG_FALSCH = 4

COUNTRY_NOT_FOUND = 5

OTHERS = 6.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Note:

IT_KOMV-KWERT ---> AMOUNT

IT_KOMV-KBETR / 10 ---> Percentage

I hope,It will help you

<=<< Sharing Knowledge is a way to Innovative >>=>

By,

Yoga