topic Reg: select statement in Application Development and Automation Discussions

Reg: select statement

Former Member — Wed, 21 Feb 2007 04:52:06 GMT

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.

Re: Reg: select statement

Former Member — Wed, 21 Feb 2007 04:53:35 GMT

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

regards

Shiva

Re: Reg: select statement

Former Member — Wed, 21 Feb 2007 05:01:28 GMT

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.

Re: Reg: select statement

Former Member — Wed, 21 Feb 2007 05:11:11 GMT

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.