topic Re: Data from KONP. in Application Development and Automation Discussions

Data from KONP.

Former Member — Tue, 27 May 2014 09:38:35 GMT

hallo everyone,

my requirement is to get MWSK1 from KONP table.

so i coded as below.

SELECT * FROM konp WHERE knumv = vbak-knumv and kposn = vbap-posnr.

konp-mwsk1 = wa-mwsk1.

It is showing error: Unknown column name "KNUMV" until runtime, you cannot specify a field list.

if iremove the condition i am getting always the same tax code(MWSK1).

please suggest me the corrections.

Thanks & regards,

narsireddy.

Re: Data from KONP.

naveenvishal — Tue, 27 May 2014 09:45:01 GMT

Hi narsi,

- The table with pricing of items order is KONV,

- The link between VBAK and KONV is field KNUMV,

- The link between VBAP and KONV is field KPOSN

- The field KSCHL is the condition type.

SELECT SINGLE * FROM VBAK WHERE VBELN = ........

SELECT * FROM VBAP WHERE VBELN = VBAK-VBELN

SELECT * FROM KONV WHERE KNUMV = VBAK-KNUMV

AND KPOSN = VBAP-PSONR.

Use KONV instead of KONP.

Hope this helps.

Regards,

Naveen

Re: Data from KONP.

Former Member — Tue, 27 May 2014 09:50:14 GMT

Hi naveen,

now i have changed my code as.

SELECT * FROM konp INTO wa WHERE knumh = vbak-knumv and kopos = vbap-posnr.

konp-mwsk1 = wa-mwsk1. (i have attached konp to screen)

ENDSELECT.

....................................................................

SELECT * FROM konp WHERE knumh = vbak-knumv and kopos = vbap-posnr.

konp-mwsk1 = konp-mwsk1.

ENDSELECT.

i tried both and now i am getting empty field. Can you help me with the condition part ?

thanks & regards,

NarsiReddy.

Re: Data from KONP.

Former Member — Tue, 27 May 2014 09:54:00 GMT

Hi,

I am worrying about kposn = vbap-posnr

Make sure that field is present in vbap table or not

Regards,

Kiran

Re: Data from KONP.

anubhab — Tue, 27 May 2014 09:54:54 GMT

Hi Narsi Reddy,

Can you please check below points:

1. If your VBAK or VBAP is initial or they have got values.

2. Are VBAK & VBAP work areas, How did you populate them?

3. Use SELECT SINGLE *

FROM konp

WHERE knumh = vbak-knumv

AND kopos = vbap-posnr.

As you are using KONP in your screen, if you get any value in KONP (work area), it will populate the screen fields automatically. Hope it will be helpful.

Regards,

Anubhab

Re: Data from KONP.

Former Member — Tue, 27 May 2014 09:55:36 GMT

hi naveen,

I tried with konv but getting empty field.

SELECT * FROM konv WHERE knumv = vbak-knumv and kposn = vbap-posnr.

konv-mwsk1 = konv-mwsk1. (i have attached konv-mwsk1 to screen.)

ENDSELECT.

thanks & regards,

narsireddy.

Re: Data from KONP.

naveenvishal — Tue, 27 May 2014 09:58:56 GMT

Hi Narsi,

You can also try these FMs if they suit you.

PRICING_GET_CONDITIONS

PRICING

SD_SALES_PRICING_INFORMATION

SD_SALES_PRICING_PUT

RV_PRICE_PRINT_HEAD

RV_KONV_SELECT

Hope this helps.

Regards,

Naveen

Re: Data from KONP.

Former Member — Tue, 27 May 2014 10:03:57 GMT

hi anubhab,

I wrote code as.

SELECT SINGLE * FROM konp WHERE knumh = vbak-knumv AND kopos = vbap-posnr.
konp-mwsk1 = konp-mwsk1.

and also checked for vbap and vbak, they have values.

now i am getting empty field of konp-mwsk1.

Is there anything wrong in condiion part?

thanks & regards,

Narsireddy.

Re: Data from KONP.

Former Member — Tue, 27 May 2014 10:06:22 GMT

hi naveen,

I want to know what to export and what to import to get the value of konv-mwsk1.

CALL FUNCTION 'RV_KONV_SELECT'

EXPORTING

    comm_head_i                 =

*   COMM_ITEM_I                 =

*   GENERAL_READ                = ' '

*   READ_CONDITION_RECORD       = ' '

*   NO_PRESTEP                  = ' '

* IMPORTING

*   COMM_HEAD_E                 =

tables

    tkomv                       =

thanks & regards,

NarsiReddy Cheruku.

Re: Data from KONP.

naveenvishal — Tue, 27 May 2014 10:07:28 GMT

Hi Narsi,

Pl debug to see which condition is failing or where value is getting cleared ( you can use watchpoint on konp-mwsk1).

Hope this helps.

Regards,

Naveen

Re: Data from KONP.

Former Member — Tue, 27 May 2014 10:09:00 GMT

Hi,

Share your codes

Re: Data from KONP.

Former Member — Tue, 27 May 2014 10:11:31 GMT

hi kiran,

SELECT SINGLE * FROM konp WHERE knumh = vbak-knumv AND kopos = vbap-posnr.

konp-mwsk1 = konp-mwsk1. (added konp-mwsk1 to screen.)

thanks & regards,

narsireddy.

Re: Data from KONP.

anubhab — Tue, 27 May 2014 10:13:35 GMT

Hi Narsireddy,

Did you check manually in SE16 for table KONV, if you have any record with knumh = vbak-knumv & kopos = vbap-posnr. Please let me know.

Note: KONV-KOPOS is of type NUMC of length 2 & VBAP-POSNR is of type NUMC of length 6. Are you sure about your condition checking?

Regards,

Anubhab

Re: Data from KONP.

naveenvishal — Tue, 27 May 2014 10:15:59 GMT

Hi Narsi,

Since you are using select single, pl check in KONV or KONP that mwsk1 is not initial for 1st record.

Regards,

Naveen

Re: Data from KONP.

Former Member — Tue, 27 May 2014 10:19:30 GMT

hi anubhab,

I am not sure about the condition part,

please tell me how to check for the correct condition.

thanks & regards,

NarsiReddy,

Re: Data from KONP.

naveenvishal — Tue, 27 May 2014 10:20:29 GMT

Hi Anubhab,

Thats why I said to use table KONV instead of KONP.

SELECT * FROM KONV WHERE KNUMV = VBAK-KNUMV

AND KPOSN = VBAP-PSONR.

Regards,

Naveen

Re: Data from KONP.

Former Member — Tue, 27 May 2014 10:24:02 GMT

hi naveen,

I want to know what to export and what to import to get the value of "konv-mwsk1".

thanks & regards,

NarsiReddy Cheruku.

Re: Data from KONP.

Former Member — Tue, 27 May 2014 10:27:07 GMT

Hi,

you could see this example code

LOOP AT TB_VBAK.

SELECT * FROM VBAP INTO TABLE TB_VBAP WHERE VBELN = TB_VBAK-VBELN.

SORT TB_VBAP BY POSNR.

REFRESH: TB_KONV.

      IF NOT TB_VBAP[] IS INITIAL.
      SELECT KPOSN KSCHL KWERT KAWRT KBETR KRECH KPEIN KMEIN MWSK1
         FROM KONV
           INTO CORRESPONDING FIELDS OF TABLE TB_KONV
                              FOR ALL ENTRIES IN TB_VBAP
                                          WHERE KNUMV = TB_VBAK-KNUMV
                                            AND KPOSN = TB_VBAP-POSNR
                                            AND KINAK = SPACE.

ENDIF.

ENDLOOP.

Best Regards

Ivan

Re: Data from KONP.

anubhab — Tue, 27 May 2014 10:32:52 GMT

Hi Narsireddy,

If you want to read item level condition value (make sure they are maintained at item level) then as suggested by use:

SELECT SINGLE *

FROM konv

WHERE knumv = vbak-knumv

AND kposn = vbap-posnr.

If you want to use only header level condition value, please use:

SELECT SINGLE *

FROM konv

WHERE knumv = vbak-knumv.

Regards,

Anubhab

Re: Data from KONP.

Former Member — Tue, 03 Jun 2014 09:44:46 GMT

Hi anubhab,

Can you help me on this.

http://scn.sap.com/message/15100088#15100088