Reg: select statement

[Former Member]

Hi :

i have to select sales orders, item from a table based on plant , shipping point and delivery creation date.

In general how will we frame a select statement for the above fields.

Thx.

[Former Member]

Hi

Use table VBAK and VBAP for the same get the records and use join for the same to fetch the records

regards

Shiva

[Former Member]

Hi,

Select vbeln psonr
          from vbap
          into table i_vbap
          where werks  IN s_werks
          AND vstel   IN s_vstel
          AND date   IN s_date.

[Former Member]

Hi,

<b>SELECT VBELN

POSNR

FROM VBAP

INTO TABLE IT_VBAP

WHERE WERKS IN S_WERKS

AND VSTEL IN S_VSTEL

AND ERDAT IN S_ERDAT.</b>

reward if useful.