topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Fri, 25 Jan 2008 16:09:14 GMT

I have to display price(netpr) of a material group matkl(74055)

for a particular costcentre (kostl) and purchase document(ebeln)

i found one table ACCTIT vth keys kostl and eblen

ekpo has netpr vth key ebeln

and zmm_dscs contains kostl as key also

csks table has key kostl.

i have to fill the field of netpr in a custom table zmm_dscs

i wrote the query as

select ekpo~netpr into corresponding fields of table i_netpr

from ekpo inner join acctit

on ekpo_{ebeln = acctit}ebeln

where ekpo~matkl eq '74055'.

but i have to netpr based on kostl

PLZ SUGGEST ME\

bump to top

Edited by: Rich Heilman on Jan 25, 2008 1:26 PM

Former Member — Fri, 25 Jan 2008 18:31:40 GMT

Not sure exaclty what you are looking for. Is it the net prices of all the materials in the group?

Rob

Former Member — Fri, 25 Jan 2008 18:36:11 GMT

hi Rob,

I am looking for the netpr of a material group 74055

based on puchase document number (ebeln) and costcentre

value (kostl)

ekpo contains netpr and ebeln(key)

but i have to get netpr based on kostl also

i found kostl ebeln as keys in acctit table

how to display netpr.