Sitemap

Amicuk Programming Answers

Joining two output tables in ONE table

-0001-11-30   Views:0

Advertisement

Hi All, I have 1 read query and 1 bapi... I need to show the output of these two into a table. EXAMPLE: Query returns 2 columns FIRST NAME and ID NUMBER. Bapi returns   2 columns LAST NAME  and ID NUMBER. now table should show 3 columns like FIRST NA

Hi All,
I have 1 read query and 1 bapi... I need to show the output of these two into a table.
EXAMPLE:
Query returns 2 columns FIRST NAME and ID NUMBER.
Bapi returns   2 columns LAST NAME  and ID NUMBER.
now table should show 3 columns like FIRST NAME.....LAST NAME...... ID NUMBER.
FIRST NAME is from Query....LAST NAME is from bapi.... where ID NUMBER is same.
Fname 1(from Query)           Lname 1 (from Bapi)               id 1(matching in both Query and Bapi)
Fname 2(from Query)           Lname 2 (from Bapi)               id 2(matching in both Query and Bapi)
In other words.... when ID NUMBER is same in query and bapi those record should come in single line.
Thanks,
PradeeP
Note: Right now I am using UNION operator which is showing both the results line by line....
USING UNION OPERATOR, RESULT IS.....
Fname1                                           id 1
Fname 2                                          id 2
                       Lname1                    id 1
                       Lanem2                     id 2
DESIRED RESULT...
Fname 1           Lname 1                id 1
Fname2            Lname 2               id 2
same question raised in forum union info from two datasources but no correct answers. its not possible in VC 7.1?????
I am thinking it is not possible after reading below threads.... please share your thoughts.....
Merging Two Tables from BAPI into single VC Table
union info from two datasources

The replay answer
Advertisement
Hi,
VC doesn't have a join operator, so it can't be done just with VC.
Instead, you should create a service that receives the 2 tables and performs the join, and consume the service in VC.
Best regards,
Tal.

Go to See the other 3 answers

Join multiple output tables of BAPI into new table

Category:DefaultRelease time:-0001-11-30Views:130

Hi, In my model (VC 7.0), I have a BAPI which outputs two different tables. Tables have many multiple records. Each table has several fields and a common field also. I want to combine these tables into one table form. I used the following methods and[More]

Joining two output tables in ONE table

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I have 1 read query and 1 bapi... I need to show the output of these two into a table. EXAMPLE: Query returns 2 columns FIRST NAME and ID NUMBER. Bapi returns   2 columns LAST NAME  and ID NUMBER. now table should show 3 columns like FIRST NA[More]

Best approach to join multiple statistics tables into one

Category:DefaultRelease time:2015-10-11Views:130

I have read different approaches to join multiple statistics tables into one, they all have a column "productobjectid". I want to get all data for each product and put it to excel and output a jpg statistic with cfchart. How would you do this, t[More]

How to select from multiple output tables in the SAP Data Source

Category:DefaultRelease time:2015-10-11Views:130

Hi, We're using the SAP Data Source to display SAP data in our portal from the Bapi: BAPI_INFORECORD_GETLIST. When defining the Bapi Meta Data we can select data from one of the two output tables (INFORECORD_GENERAL and INFORECORD_PURCHORG). But we w[More]

How to join two internal table rows in alternative manner into one internal table?

Category:DefaultRelease time:-0001-11-30Views:130

How to join two internal table rows in alternative manner into one internal table? two internal tables are suppose itab1 &  itab2 & its data Header 1 Header 2 Header 3 a b c d e f g h i Header 1 Header 2 Header 3 1 2 3 4 5 6 7 8 9 INTO itab3 data[More]

Filter and Join on same table

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I am having a bit of hard time, implementing following. All suggestions welcome. (1) I have a file being mapped into an initial table with say, 10 fields (field1...field10). (2) I want to execute following logic for mapping For all records in[More]

Join of Multiple Tables

Category:DefaultRelease time:-0001-11-30Views:130

We are experiencing an unpredictable error in a simple form and have experimented it in different scenarios it behaves in the same way. The problem description is as under: We are using "Join of Multiple Tables" feature of Developer-6i. In our f[More]

Performance for join 9 custom table with native SQL ?

Category:DefaultRelease time:2015-10-11Views:130

Hi Expert, I need your opinion regarding performance to join 9 tables with native sql. Recently i have to tunning some customize extraction cost  report. This report extract about 10 million cost of material everyday. The current program actually, tr[More]

Right way to preserve all parent table entries in a join with many tables!!

Category:DefaultRelease time:2015-10-11Views:130

This problem is quite interesting to me. I have asked this question to others but no body is able to provide me with proper answers. The problem is: How do I join a huge parent table with many child tables (more than 5 child tables) preserving all of[More]

Adding a single table without a logical join to another table (OBIEE 10g)

Category:DefaultRelease time:2015-10-11Views:130

Sometimes I want to just display a single table without a logical join to another table in the repository. However, everytime I move it to the Business Model and Mapping layer and perform a Global Consistency Check, it tells me that it needs a logica[More]

How to hide columns in the output table in webdynpro based on input

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts,    I have 2 inputs and 1 input is optional.If both inputs are given proper table output is displayed,but if only 1 input is given a column is empty in the output table  so i want to hide this column dynamically at runtime based on my inpu[More]

Hot
I've run diagnostics on the mac air, reloaded firefox, and tried eerything I could think of. The 'show all bookmarks' page works perfectly- it's just the dropdown menu that has problems. All the folders have numerous items in them except for one- whi [More]
Hi all, I am new to Berkeley XML DB. I have the following simple XML content: <s:scxml xmlns:s="http://www.w3.org/2005/07/scxml"> <s:state id="a"/> <s:state id="b"/> <s:state id="c"/> </s: [More]
Hi, I am new to BW. I created an exception and set the from and to limits with an alert level of green for an amount column. When I run this query in the web, it does not change the color to green for the condition in the amount column. What is the v [More]
Hello everyone, I used Catalyst to design my interaction and navigation and then use Flash Builder to add all my logic. Everything works as expected but i have one issue regarding my item renderer data list. Here is my issue : i set up an itemRendere [More]
Often when I open itunes I get an error message saying that it cannot be opened because the library was created by a newer version of itunes. When I try to update itunes, even when I know there are updates available, the system updater doesn't find a [More]
Hi, I am trying to make BAPI function call in JAVA. I am using the following libraries for IBM AIX version and the sapjco.jar 1) librfccm.o 2) libsapjcorfc.so The above 2 libraries are in my java lib path. But I get a exception and it is referring to [More]
i have jsp page whice i insert data into ms access. but nothing work. no new data inserted to table this is the code: <%@ page language="java"%> <%@ page import="javax.servlet.*" %> <%@ page import="javax.servlet.ht [More]
Hi, We have implemented the EHP 3 and not activated New GL. We want to convert a GL account in SD account determintaion to OI Management. The Account has huge data since 2002. 1. There is a "Switch on"  field in the screen and help for this fiel [More]
Hi, I have a problem with my E50 which is some thing like this, During call waiting (While I am receiving a second call, when I am already on a call) the incoming audio is switching to loud speaker automatically with out any commands. Then I can not [More]
Dear Gurus, Last Saturday, i post my first document in SAP document management Space. but still it was in awaiting for moderator approval status. please help me how to make it available for all. document link is below. [content server installation in [More]