ABAP code - KONV cluster table

[Former Member]

Hi All!

I have to create a report (SQ01) for the price condition VBRP-WAVWR, VBRP-NETWR, VBAP-NETWR, VBAP-WAVWR and KONV-KBETR. I created a InfoSet (SQ02) with table join between VBRK, VBRP, VBPA, PA0002, VBAK and VBAP (I use different fields from this tables). I created 2 Additional fields AD_Z004 and DS_KA00 like KONV-KBETR and coding selection for this fields is:

SELECT SINGLE KBETR FROM KONV INTO DS_KA00

WHERE KNUMV EQ VBAK-KNUMV AND

KPOSN EQ VBAP-POSNR AND

KSCHL EQ 'KA00' AND

STUNR EQ '101' AND

ZAEHK EQ '01'.

SELECT SINGLE KBETR FROM KONV INTO AD_Z004

WHERE KNUMV EQ VBAK-KNUMV AND

KPOSN EQ VBAP-POSNR AND

KSCHL EQ 'Z004' AND

STUNR EQ '015' AND

ZAEHK EQ '01'.

When I run the report this additional fields don't have any value. I set a BREAK before this code and the system is ignoring the code.

What am I doing wrong?

All the help will be appreciated. Thank you.

[Former Member]

When i generate the Infoset, I receive the warning:

Warning messasages

Compare field group fields with Data Dictionary

Currency field RV61A-KOEI1 will not be filled

Affected currency amount fields:

DS_KA00

AD_Z004

[Former Member]

Solved on my own.

[Former Member]

Hi Cheta Florina,

May I know how you solved the problem because I also encounter this problem.

Thanks in advance.

Leng

[Former Member]

Hi Leng!

I create additional information for VBRK table - two additional fields: DS_KA00, AD_Z004 (SQ02). In Coding section for the additional field I witted the code:

-

---

BREAK FLORINA_C .

SELECT SINGLE KBETR FROM KONV INTO DS_KA00

WHERE KNUMV EQ VBAK-KNUMV AND

KPOSN EQ VBAP-POSNR AND

KSCHL EQ 'KA00' AND

STUNR EQ '101' AND

ZAEHK EQ '01'.

SELECT SINGLE KBETR FROM KONV INTO AD_Z004

WHERE KNUMV EQ VBAK-KNUMV AND

KPOSN EQ VBAP-POSNR AND

KSCHL EQ 'Z004' AND

STUNR EQ '015' AND

ZAEHK EQ '01'.

-

---

In SQ01 I created other two local fields because the value of AD_Z004 and DS_KA00 should be divided by 10 in order to be correct.

I hope it was helpful. Sorry for answering so late.

Florina C