topic Re: report - value fetching in Application Development and Automation Discussions

report - value fetching

Former Member — Fri, 19 Mar 2010 08:19:50 GMT

Hi All,

I am generating one report wherein I am trying to fetch the duty values and vat from Invoice verification document and CST, freight also. From which table and field, can I fetch these things. Can anybody help me?

Thanks & Regards,

Re: report - value fetching

Former Member — Fri, 19 Mar 2010 08:27:48 GMT

You can get all these information from KONV table.

Re: report - value fetching

StMou — Fri, 19 Mar 2010 08:38:44 GMT

Hi,

you can see also table konh konp

Rgds

Re: report - value fetching

Former Member — Fri, 19 Mar 2010 08:39:04 GMT

Hi,

Your functional consultant can help you out with this.

Also, can you give more details of your requirement?

Thanks,

Archana

Re: report - value fetching

Former Member — Fri, 19 Mar 2010 08:48:07 GMT

Hi ,

Check the below select queries:

SELECT KONV~KPOSN

KONV~KNUMV

KONV~KWERT

KONV~KBETR

KONV~KWAEH

KONV~KAWRT

KONV~KNUMH

KONV~KSCHL

INTO CORRESPONDING FIELDS OF TABLE IT_KONV

FROM KONV

FOR ALL ENTRIES IN IT_VBRP

WHERE KNUMV = IT_VBRP-KNUMV

AND KPOSN = IT_VBRP-POSNR

AND KSCHL IN S_KSCHL2 .

CHECK NOT IT_KONV[] IS INITIAL.

get the conditions data

SELECT KPOSN

KNUMV

KWERT

KBETR

KWAEH

KAWRT

KNUMH

KSCHL

INTO CORRESPONDING FIELDS OF TABLE IT_KONV2

FROM KONV

FOR ALL ENTRIES IN IT_VBRP

WHERE KNUMV = IT_VBRP-KNUMV

AND KPOSN = IT_VBRP-POSNR

AND KSCHL IN ('ZSTL' , 'ZFR3' , 'ZLD2' ,

'ZFRI' , 'ZFR2' , 'ZINS' ,

'ZLDI' , 'ZCUS' , 'ZCNF') .

Here 'ZSTL' , 'ZFR3' , 'ZLD2' , 'ZFRI' , 'ZFR2' , 'ZINS' , 'ZLDI' , 'ZCUS' , 'ZCNF' are nothing but condition types.

So to retrieve your frieght ,VAT etc details you need to check with the relavant condition types.

Hope this will help you.

Regards,

Ravinder.

Re: report - value fetching

Former Member — Fri, 19 Mar 2010 08:55:18 GMT

Thanks for replying. My requirement is I have 2 columns in report. One is rate with duty, other one is without duty. i..e, alongwith basic price duty amount to be displayed for a particular period.

Regards,