Base Table for KONV

[Former Member]

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

[former_member387317]

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

OR

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

[Former Member]

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

[former_member387317]

>

> 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

[Former Member]

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

[Former Member]

Hi,

KONV-KNUMV = VBAK-KNUMV

This is appropriate relation of pricing at sales order.

Regards,

Praveen