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 need help I cant register my sons ipods or get facetime to confirm e-mail I could use some help pleasTry here: iOS: Troubleshooting FaceTime What error are you receivng?Read other 2 answers [More]
So, I am a little frustrated. After almost two years of trying to get my director to buy off on the CC, he says he will do it. But here's the problem; I work for the DoD on a classified network. I was told that Adobe had a fix for this, but after an [More]
I have not seen this question anywhere but thats right. If a web page is 5 pages long, and we print it on the Acrobat 9 printer we get the first page correctly after which the remaining 4 pages are blank white sheets. I got the same result when I fir [More]
I have created a form in Adobe Acrobat XI Pro and saved it.  Then I want to open it in Adobe Reader, fill it in and then only print the form data but there is not an option to only print form data in Adobe Reader XI.  I'm not sure if it is in the way [More]
Hello, I have tried everything to get Java functioning in our IT rooms, different versions, permissions, etc. But to no avail, we are behind a DMZ and a Proxy Server. This only occours when logged in as a student (differnt proxy server, with filterin [More]
WHENVER WE WANT TO ACCESS FILES FROM OHTER APPLICATIONS,WHICH ONE IS BETTER TO USE,<c:redirect> OR RequestDispatcherPlease stop shouting. It is considered rude.Read other 2 answers [More]
how do you transfer material and is it important?Make sure all content is transferred and device is backed up. Transfer purchases http://support.apple.com/kb/HT1848 How to backup http://support.apple.com/kb/HT1766Read other 3 answers [More]
I'm running iTunes 5 (with quicktime 7 installed too) on a 1.25 G4 powerbook... Library is all legitimate rips or purchased music, about 6400 tracks in all, and I've noticed that 893 of these songs have recently lost their ratings, and even stranger, [More]
Hi All, My client has an Orientation Course, whose purpose is t provide a kind of an orientation of the organization to the new employees. This course has multiple (about 10 - 15) sessions as this requires trainers from different departments to provi [More]
I have a jms client trying to connect to a weblogic server. The program uses a cached service           locator to do the jndi look-ups. My application is deployed to a unix server and executed within           a shell script.           The error occ [More]