topic Re: Select Query.. in Application Development and Automation Discussions

Select Query..

Former Member — Mon, 04 Jun 2007 05:39:51 GMT

Hi,

Can anybody help me in writing select query to pull out the following fields in PS module.

POSID, POST1,AUFNRD, VORNR,ARBPL,KOSTL,LARNT,LTXA1,ARBEI,ISMNW,NTANF,NTEND,ISDD, IEDD , AUERU

based on the <b>input values in the fields</b> like

PSPS,PROJ,AUFNRD,VORNR,ARBPL,VSTXT,NTANF,NTEND,ISDD,IEDD,WERKS.

Thanks in Advance.

Points will be awarded for the useful replies.

Former Member — Mon, 04 Jun 2007 05:46:01 GMT

Start with writing a query first for PRPS and PROJ tables

then for all entries of this WBS elements you have to fetch the order related tables like AFKO,AFPO and AFRU and CRHD tables

or you can use the views

VIAUF_AFVC

VIAUF_AFVC_IFLOS

VIAUFK_AFVC

VIAUFK_AFVCIFLOS

VIAUFKS

VIAUFKS_IFLOS

to select data for the WBS related orders

Reward points if useful

Regards

Anji

Message was edited by:

Anji Reddy Vangala

Former Member — Mon, 04 Jun 2007 06:31:54 GMT

hi priya,

try this one ,

first create internal tables......

than collect data from PRPS table.......like

select poid pos1....................

from prps

into table it_prps

where prps = s_prps..............................

if it_prps[] is not initial.

select ...............

from second table

for all entries in it_prps

into tablr it_second table

where........................

endif.

reward if helpful,

if u r still have doubt than my id.....saravdi.imran06@gmail.com

Regards,

Imran