Reg: customised ALV layout like VA05

[Former Member]

Hi,

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

SELECT A_{KUNNR A}VBELN A_{BSTNK A}AUDAT A_{ERNAM A}AUART A_{VKORG A}VTWEG

A_{SPART A}VKGRP A_{VKBUR A}KURST A_{FAKSK A}GUEBG A~GUEEN

A_{VBTYP A}AWAHR

B_{VRKME B}LGORT B_{VSTEL B}ERZET B_{POSNR B}MATNR B_{CHARG B}ZMENG

B_{NETWR B}NETPR B_{KWMENG B}ARKTX B_{WERKS B}WAERK B~MEINS

B_{ERNAM C}LFSTK C~FKSAK INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM VBAK AS A INNER JOIN VBAP AS B ON A_{VBELN = B}VBELN

INNER JOIN VBUK AS C ON A_{VBELN = C}VBELN

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

[Jelena]

There is no universal "open order" selection criteria because different statuses will be set depending on the configuration. Also from the business standpoint what do you consider "open"? Not delivered? Not billed?

Just go to SE16 and check if there is a single record that fits your criteria. How do we know what's in your S_AUDAT, EBEL and MAT1?

Also as a shortcut you might want to use VBAKUK instead of VBAK and VBUK. And instead of NE use = A or B.