‎2011 Oct 17 4:42 PM
Hi Gurus,
I have to do a query on Client System ( I cannot use abap code..).
I have to extract data from KONV ( KWERT) so I have to create a Query with logical DB (VFV).
I have to start with :
VBPK then VBRP con VBPK-VBELN then VPBA -VBELN with VBRP-VGBEL ( until here a query with Join tables is ok ) but after I have to add KONV to take the value of KWERT for each materials of my delivery.
When I create a query with quick viewer , the system advised me there were some errors :
The query specifications cannot be used to generate a list,
i.e. the query will probably not return the list you desire.
Fields from parallel tables within a line
Field: Customer Number 1
(VBPAPO-KUNNR, table VBPAPO)
Field: Condition type
(KONV-KSCHL, table KONV)
(VBPAPO-KUNNR, table VBPAPO)
Field: Condition changed manually
(KONV-KMPRS, table KONV)
Fields from parallel tables within a line
(VBPAPO-KUNNR, table VBPAPO)
Field: Condition for configuration
(KONV-KVARC, table KONV)
(VBPAPO-KUNNR, table VBPAPO)
(KONV-KFKIV, table KONV)
(VBPAPO-KUNNR, table VBPAPO)
(KONV-KWERT K, table KONV)
(VBPAPO-KUNNR, table VBPAPO)
Field: Condition currency (for cumulation fields)
(KONV-KWAEH, table KONV)
(VBPAPO-KUNNR, table VBPAPO)
Field: Condition base value
(VBPA-PARVW, table VBPA)
(VBPAPO-KUNNR, table VBPAPO)
Somebody could help me?
Maybe I have to use another table but I don't know which.
Thanks in advance
Vanessa
(KONV-KAWRT K, table KONV)
‎2011 Oct 17 5:24 PM
Hi Vanessa,
I have to do a query on Client System ( I cannot use abap code..).
is there any issue if you go with abap code.I will suggest you instead of going for query better to develop a custom report.
Regards,
Madhu.
‎2011 Oct 17 9:18 PM
Hi
yes I cannot do any abap code...
Otherwise I should have not wriiten the message!!!
Best regards