Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Reg: customised ALV layout like VA05

Hi,

IF P_OPEN = 'X' AND P_MYOR NE 'X' .

SELECT AKUNNR AVBELN ABSTNK AAUDAT AERNAM AAUART AVKORG AVTWEG

ASPART AVKGRP AVKBUR AKURST AFAKSK AGUEBG A~GUEEN

AVBTYP AAWAHR

BVRKME BLGORT BVSTEL BERZET BPOSNR BMATNR BCHARG BZMENG

BNETWR BNETPR BKWMENG BARKTX BWERKS BWAERK B~MEINS

BERNAM CLFSTK C~FKSAK INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM VBAK AS A INNER JOIN VBAP AS B ON AVBELN = BVBELN

INNER JOIN VBUK AS C ON AVBELN = CVBELN

WHERE A~KUNNR IN CUST

AND A~AUDAT IN S_AUDAT

AND A~BSTNK IN EBEL

AND B~MATNR IN MAT1

AND C~LFSTK NE 'C'

and c~lfstk ne ' '

AND C~FKSAK NE 'C'

and c~fksak ne ' '.

AND C~ABSTK NE 'C' .

Is the above query correct for open sales order and what ever the charge

is there in vbap is not getting displayed in ALV output

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question