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
Daughter upgraded to ios 7 and now she has like 4 songs that are not age appropriate on her iphone- I went into itunes and they dont show up...they are like hidden or something- and I cannot delete them from the phone...does anyone know why the upgra [More]
Hi, the day before yesterday I turned on my tv which was connected via HDMI out on the mac mini to HDMI in on my TV. Everything was working fine, however I have been trying to set up dual monitoring on another monitor using an HDMI to VGA adapter to [More]
So, when I open certain pdf documents they do not show up, only a gray background.  I believe I changed some setting that is causing this to happen.  The pdf is opened, it will appear in the Window menu list.  It will print, but I can't see it.  I ca [More]
after trying to update my i phone , the update has obviously failed and now itunes asks ,e to restore my iphone , have tried this but the restore has now taken over 24 hours ans still not complete ./ have  tried to reboot pc and i phone and try resto [More]
In a Word document I imported into RoboHelp, my cross references imported as Cross Reference (not inline cross reference) style. When I define this style in the Word template to be the desired color (eg. royal blue), it doesn't import with the desire [More]
Hi all. I have been having this problem since I got this computer in December. I hope someone will be able to help me. I have been using a usb corded optical mouse. It works for about 4-5 weeks then it loses power. For the first few days I can unplug [More]
What is the overall impression of using spry widgets for web design.  I've used it to create a very nice menu/nav bar but with .css seeming so popular I was wondering from a developers and designers preference...  Is it a good choice to use?One shoul [More]
I thinking of making a form for my school website. What i would like to happen is like the visitors to fill in their email address and then like choose from a list of letters available which they then just click on submit or something and then that l [More]
hi guys, I am having trouble converting rows to columns. Read a few articles on Pivot and Decode but still could not figure it out. For eg. Table info Unit_no.                       Unit_id 001                                xyz 002                   [More]
Hi, For multilevel BOM explode I have to use the "Functional Module" CS_BOM_EXPL_MAT_V2. I checked it in system but I didnt understand which input parameters I need to give (Which are mandatory) as ther are lot of input fields available. Please [More]