Pricing Condition in SMARTFORMS

[Former Member]

Hi All,

I am working on smartforms.I have given select query for codition records like following.

SELECT SINGLE KBETR FROM KONV INTO TOTAL WHERE KNUMV = VBDKA-KNUMV AND KPOSN = VBDPA-POSNR AND KSCHL = 'PR00'.

Its displaying error that VBDKA is not maintained in DICTIONARY.

I need to check condition from VBDKA(not a header table).

How to get condition from the table VBDKA AND VBDPA?

I want to do it smartform only.

Thanks,

Murthy

[Former Member]

if you do the select in the smartform then you should also add the tables

tables: VBDKA

in the header coding

kind regards

arthur

[Former Member]

Hi

Try like this

select kbetr kwert kschl from konv INTO CORRESPONDING FIELDS OF table it_konv

for all entries in IT_VBRK where KNUMV = IT_VBrK-KNUMV and kschl eq 'ZRPR'

AND KPOSN = IT_VBRK-KNUMV.

Ranga