Skip to Content
-2
Jun 20, 2018 at 09:29 AM

Select query to VBFA is giving dump : zsales report

364 Views Last edit Jun 20, 2018 at 10:07 AM 2 rev

zsdb-1.jpgzsdb-2.jpgzsdb-gst-3.jpgzsdb-gst-4.jpgzsdb-gst-5.jpgDear All,

I have a requirement that in one of the sales report select query to

VBFA going to dump .

SELECT VBELN POSNR FKIMG VRKME VGBEL AUBEL MATNR ARKTX CHARG WERKS
KONDM VKAUS FROM VBRP INTO TABLE IT_VBRP FOR ALL ENTRIES IN IT_VBRK
WHERE VBELN = IT_VBRK-VBELN
AND MATNR IN S_MAT
AND SPART IN P_SPART
AND CHARG IN S_CHARG
AND WERKS IN P_WERKS
AND KONDM IN S_MATNR .

IF SY-SUBRC NE 0.
MESSAGE 'No Data Found' TYPE 'I'.
LEAVE LIST-PROCESSING.
ENDIF.

" The below query is going to dump .

SELECT VBELV VBELN POSNN VBTYP_N VBTYP_V FROM VBFA INTO TABLE IT_VBFA FOR ALL ENTRIES IN IT_VBRP WHERE VBELN = IT_VBRP-AUBEL AND POSNN = IT_VBRP-POSNR AND VBTYP_N = 'C' AND VBTYP_V = 'G'.

Please suggest any ideas or workaround why the query to VBFA going for dump .

I have attached the screenshots of the Error message I am getting after the dump .

Regards

Deep

Attachments

zsdb-1.jpg (81.3 kB)
zsdb-2.jpg (109.2 kB)
zsdb-gst-3.jpg (93.5 kB)
zsdb-gst-4.jpg (79.2 kB)
zsdb-gst-5.jpg (77.8 kB)