topic Base Table for KONV in Application Development and Automation Discussions

Base Table for KONV

Former Member — Fri, 15 Jan 2010 11:57:46 GMT

Hi ,

As i searched and found that KONV is basically combination of KONP and KONH table

But my question is None of the table is having KNUMV Field So where can i get link of

field KNUMV and KNUMH

Regards,

Alpesh

Re: Base Table for KONV

Former Member — Fri, 15 Jan 2010 12:47:56 GMT

Hi Alpesh,

These Tables stores Pricing Details

Relation and how can you pass knumv and knumh is as below..

KONV-KNUMV = VBAK-KNUMV

KONP-KNUMH = VBAK-KNUMV

KONP-KOPOS = VBAP-POSNR

KONP-KNUMH = A606-KNUMH

so it depends on the scenario as well..

Also have a look at FM CONDITION_RECORD_READ

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

Re: Base Table for KONV

Former Member — Sat, 16 Jan 2010 03:45:51 GMT

Thanks Ilesh,

Basically I want condition record for Invoice for Creating Databse View

with help of KONV Table it is not possible(Due to Cluster Table)

I am having KNUMV Field From VBRK

Now i want to link VBRK-KNUMV with KONP-KNUMH

so how can i link this two Field?

because KONV Table is having both knumv and Knumh Field ,

From which table i get link between This teo fields?

Thank in Advance,

Alpesh

Re: Base Table for KONV

Former Member — Sat, 16 Jan 2010 05:09:59 GMT


> Now i want to link VBRK-KNUMV with KONP-KNUMH
> so how can i link this two Field?
> 
> Thank in Advance,
> Alpesh

Hi Alpesh,

while creating Database View you can put join condition manually as VBRK KNUMV = KONP KNUMH

and you can select the fields whatever fields you need..

You are right you can not create Database view with KONV as it's cluster table..

Also at last if nothing is working for you then you can use FOR ALL ENTRIES..

Example..

SELECT  KNUMV
              KPOSN
              KSCHL
              KWERT
              WAERS
              KDATU
          FROM KONV
          INTO TABLE GIT_KONV
          FOR ALL ENTRIES IN GIT_VBRK
          WHERE KNUMV = GIT_VBRK-KNUMV.

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

Re: Base Table for KONV

Former Member — Sat, 16 Jan 2010 06:10:35 GMT

Dear Ilesh,

i cannot use VBRK KNUMV = KONP KNUMH because both are different field,

FAE is also not Possible

is there any other way?

Regrads,

Alpesh

Re: Base Table for KONV

Former Member — Mon, 18 Jan 2010 06:49:17 GMT

Hi,

KONV-KNUMV = VBAK-KNUMV

This is appropriate relation of pricing at sales order.

Regards,

Praveen