regarding select statements

Former Member — Sat, 11 Aug 2007 06:24:34 GMT

Hi..

good morning..

here is a requirement.

i want to retrieve data from the following table.but how to join these table is my dought.

tables fields

t001w--werks " plant id

t001w--name1 " pl;ant name

t001w--regio " plant address

ekko--ebeln " purchase order

ekko-erdat : creation date

ekko-ernam "name of the person

ekpo-ebelp " item

ekpo-bstyp "purchase order type

eket-erdat " delivery date

mara-matnr " material number

these are the tables and fields.now we want to retrive data from these tables

how we have to code select statement.

selection-screen is

plant id

order type

delivery date

please provide select statement for this requirement.

thanks and regards.

k.swaminath reddy.

Re: regarding select statements

uwe_schieferstein — Sat, 11 Aug 2007 21:38:15 GMT

Hello Swaminath

Your requirements are incomplete thus there is some guessing required.

Materials (table MARA) belong to plants (MARC). Purchase order items (EKPO) have materials. Based on your information about the selection screen it seems that your report should yield the following output:

<i>"Display all purchase orders of the specified order type within the given range of delivery dates and which contain order items (-> materials) of the selected plants."</i>

Thus, your JOIN will contain the following tables: MARC, EKPO and EKKO.

Regards

Uwe

topic Re: regarding select statements in Application Development and Automation Discussions

regarding select statements

Re: regarding select statements