topic Pricing Condition in SMARTFORMS in Application Development and Automation Discussions

Pricing Condition in SMARTFORMS

Former Member — Mon, 08 Dec 2008 12:21:21 GMT

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 — Mon, 08 Dec 2008 12:23:44 GMT

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 — Mon, 08 Dec 2008 12:30:55 GMT

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