Skip to Content
0
Oct 12, 2016 at 08:53 AM

Value VBFA-VBELN not generated in SQ01 by using inforset with logical database VAV

204 Views

Hi SAP expert and guru,

I am facing some difficulties to get the Billing document from the SQ01.

Have created an info set with logical database VAV and table selected are VBAK, VBFA and KONV.

The field to join within the table in order to get the Billing document will be as shown below.

Key in value in KONV-KSCHL to get value KONV-KNUMV, then pass the value to VBAK-KNUMV, then get VBAK-VBELN to table VBFA to get the value VBFA-VBELN with condition VBFA-VBTYP_N = M and VBFA-FKTYP=L.

Everything goes fine, but not in SQ02 where I hit the error as stated below when the output button is clicked.

i.e. the query will probably not return the list you desire.
If you still want to execute the query, please use the
"Generate" function
-> 'Generate'


** Fields from parallel tables within a line
Line: 01
Field: Subsequent sales and distribution document
(VBFA-VBELN, table VBFA)
Field: Condition type
(KONV-KSCHL, table KONV)

** Fields from parallel tables within a line
Line: 01
Field: Subsequent sales and distribution document
(VBFA-VBELN, table VBFA)
Field: Number of the document condition
(KONV-KNUMV, table KONV)

** 2 warnings for query BASIS12161240 **

Would like to seek for your advise whether is there any other step that I have missed out that need to be inserted in order to get the value.


Thank you

Regards

Leonard Tan