Fetch data from Database table

[Former Member]

Hi,

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

[Former Member]

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

[former_member189059]

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

Other methods include logical databases and Hr infotypes.

[SuhaSaha]

>

> 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.

[Former Member]

Hi Naga,

browse abap help for "database access".

regards

rea