Skip to Content
0

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

Oct 12, 2016 at 08:53 AM

61

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jelena Perfiljeva
Oct 17, 2016 at 04:56 PM
0

Logical database concept is obsolete already, just build your own logic. However, with KONV as the first table you are likely to have a very bad performance. I'd suggest to check with an ABAPer on how to proceed best in your system.

Also based on what you are actually trying to achieve (which is not mentioned) there could be a completely different solution.

Share
10 |10000 characters needed characters left characters exceeded