topic Re: Fetch data from Database table in Application Development and Automation Discussions

Fetch data from Database table

Former Member — Thu, 10 Jun 2010 09:18:34 GMT

Hi,

What are the different ways other that SELECT queries and JOINS to fetch data from Database Tables?

Re: Fetch data from Database table

Former Member — Thu, 10 Jun 2010 09:26:23 GMT

You may check for any standard function modules or BAPIs which SAP has provided to read the data. For eg. to get the sales order information which retrieves the data from VBAK, VBAP tables, we can use the SD_SALES_DOCUMENT_READ FM.

~Vaas

Re: Fetch data from Database table

former_member189059 — Thu, 10 Jun 2010 09:38:16 GMT

From Cluster tables, you can get data using Import statements.

Other methods include logical databases and Hr infotypes.

Re: Fetch data from Database table

Former Member — Thu, 10 Jun 2010 09:42:49 GMT

Hi Naga,

browse abap help for "database access".

regards

rea

Re: Fetch data from Database table

SuhaSaha — Thu, 10 Jun 2010 09:50:08 GMT


> From Cluster tables, you can get data using Import statements.

It should be "data cluster" tables & not "cluster" table. BSEG is a cluster table but we use SELECT to fetch the data

@OP: It is a basic question & you could have ST*W.