-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
- Autonomous Enterprise
- Artificial intelligence
- Data and analytics
- Autonomous Suite
- Technology platform
- Transformation management
- Midsize business solutions
- Financial management
- Spend management
- Supply chain management
- Human capital management
- Customer experience
- Enterprise resource planning
- Business network
- Sustainability management
- SAP Store
- Try SAP
- View all industries
- Partners
- Services
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- Autonomous Enterprise
- Artificial intelligence
- Data and analytics
- Autonomous Suite
- Technology platform
- Transformation management
- Midsize business solutions
- Financial management
- Spend management
- Supply chain management
- Human capital management
- Customer experience
- Enterprise resource planning
- Business network
- Sustainability management
- SAP Store
- Try SAP
- View all industries
- Partners
- Services
- Learning and Support
- About
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
block alv
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007 Aug 12 7:50 PM
- SAP Managed Tags
- ABAP Development
Hi,
I have a doubt in block ALV.If in the first block,If I have fields that need 2 be extracted from different database tables.
How can I extract the data by using SELECT.
For ex,In the first block,If I have employee name,organisation,ID.........which are from different database tables.Hou can I write SELECT statement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007 Aug 13 12:36 AM
- SAP Managed Tags
- ABAP Development
Probably you need to write a JOIN (Check Help under Open SQL syntax).
Check <a href="http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb39c4358411d1829f0000e829fbfe/content.htm">this link</a>.
Regards.
Please reward points if helpful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007 Aug 13 12:36 AM
- SAP Managed Tags
- ABAP Development
Probably you need to write a JOIN (Check Help under Open SQL syntax).
Check <a href="http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb39c4358411d1829f0000e829fbfe/content.htm">this link</a>.
Regards.
Please reward points if helpful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007 Aug 13 4:27 AM
- SAP Managed Tags
- ABAP Development
If you are not sure where data is coming from, you can turn the SQL Trace (Performance Trace = transaction ST05) on and run the standard SAP transaction / report where you normally see this data. Then turn the trace off and examine the output... not only can you see which tables are used, but you can often pick up really good examples of how SAP have structured their database accesses, and even possibly find function modules that return the data you want.
Bluesky