Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

regarding select statements

Former Member

‎08-11-2007 7:24 AM

0 Kudos

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.

1 REPLY 1

uwe_schieferstein
Active Contributor

‎08-11-2007 10:38 PM

0 Kudos

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