Amicuk Programming Answers

R/3 table for BW

2015-10-11   Views:0


hi i have to create one or more r/3 tables which will then be used as a source for bw reporting . the data that i have pertains to two kinds of business (say incoming and outgoing ) . for incoming , we have only cost information but for outgoing we h

i have to create one or more r/3 tables which will then be used as a source
for bw reporting . the data that i have pertains to two kinds of business
(say incoming and outgoing ) . for incoming , we have only cost information
but for outgoing we have both cost and revenue information .i am not sure
if i should create a single table for both incoming and outgoing business
information or should i create two different tables .incase , i create two
tables , the incoming table info will have 8 fields and outgoing will have
some more apart from these 8 .
can some one guide me what things should i consider before i design a single/
two tables for acting as source to bw .
all inputs welcome

The replay answer
  Basically , know the source table names and create a view and include these two tables in it  and select all the required fields in the View fields tab and then activate it. Upon this view create a data source and activate and connect this data source to BW infosource.
Hope it helps...

Go to See the other 3 answers

MB5B Report table for Open and Closing stock on date wise

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

Hi Frds, I am trying get values of Open and Closing stock on date wise form the Table MARD and MBEW -Material Valuation but it does not match with MB5B reports, Could anyone suggest correct table to fetch the values Open and Closing stock on date wis[More]

Error while dropping a table

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

Hi All, i got an error while dropping a table which is ORA-00600: internal error code, arguments: [kghstack_free1], [kntgmvm: collst], [], [], [], [], [], [], [], [], [], [] i know learnt that -600 error is related to dba. now how to proceed. thanks[More]

Logical level in Fact tables - best practice

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

Hi all, I am currently working on a complex OBIEE project/solution where I am going straight to the production tables, so the fact (and dimension) tables are pretty complex since I am using more sources in the logical tables to increase performance.[More]

Rendering xml-table into logical filename in SAP R/3

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

Hi, I am trying to translate an xml-table with bytes into a logical filepath in SAP R3. Do I have to use the method gui-download or shall I loop the internal xml-table? When I tried to loop the xml-table into a structure, and then transfering the str[More]

Can you check for data in one table or another but not both in one query?

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

I have a situation where I need to link two tables together but the data may be in another (archive) table or different records are in both but I want the latest record from either table: ACCOUNT AccountID     Name    123               John Doe 124  [More]

Can not insert/update data from table which is created from view

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

Hi all I'm using Oracle database 11g I've created table from view as the following command: Create table table_new as select * from View_Old I can insert/update data into table_new by command line. But I can not Insert/update data of table_new by SI[More]

Not able to refresh the data in a table

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

Hi In my application i fill data in a table on clikc of a button .. Following are the line of code i have user RichColumn richcol = (RichColumn)userTableData.getChildren().get(0);                                           (fetch the first column of m[More]

Unable to capture the adf table column sort icons using open script tool

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

Hi All, I am new to OATS and I am trying to create script for testing ADF application using open script tool. I face issues in recording two events. 1. I am unable to record the event of clicking adf table column sort icons that exist on the column h[More]

How to Activate the Table which Doesn't Exist - Can I create Table in SE11

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

Hi Gurus, I am a BASIS Person, I don't have much idea about ABAP Developement side . But, while applying patches to one of  the SAP Component, I get the following error message ( usr\sap\trans\log ) : Phase Import_Proper >>> SAPAIBIIP7.BID 1[More]

AND / OR  truth table in SQL

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

why null is introduced in the AND and OR truth table?when will a statement/part of a statement return a null value?? |AND               |True          |False             |NULL??        | |True               |True          |False             |Null    [More]

IF statement in Calculated Field for Share point, doesnt calculate sum in my Excel Pivot table.

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

Hi Everyone I used this in SP calculated column field. =IF([Shift Sched]="1pm to 10pm","0",IF([Shift Sched]="2pm to 11pm","1",IF([Shift Sched]="3pm to 12am","2",IF([Shift Sched]="4pm to 1am&[More]

Hi, I am calculating OTD SLA metrics using the Business Object Web Intelligence, but I am stuck with the WorkDay() how to use this in BO, as it is available in Excel.  Requirement is that I need to add business days (Saturdays and Sundays should not [More]
I have a question. Does anyone know if the parts of the 1st and 2nd generation nanos are compatable with each other or are they they dont work togetherRead other 2 answers [More]
Hello, I just completed this huge query and when I performed a check I got a message that “80000 is note in the hierarchy Hier1 for the InfoObject ZTAQ” Both the hierarchy and infoobject have been used repeated in the query. What is the easiest way t [More]
I have a problem with the XML file for a flash chart. I am trying to display a 2dColumn chart of an SQL query with the general form: select null link, x as name, sum(y) as value from z group by (x); this generates multiple rows, which are displayed a [More]
Hi All, I am struck into a particular problem. Please have the patience to read through the problem. I have a report with 2 queries. One query picks ups the invoices from the AR module, and the other query picks up the entries from the GL module beca [More]
Hi,          Please let me know of any documentation on Alert config in PI 7.3 AEX (Advanced Adapter Engine Extended). We have single stack installation of PI 7.3 and need to know how we can setup alert config here as there is no Abap stack and being [More]
Hi, I try to create a rule in Mail such that an Applescript is executed and then other things are done to the message (such as move it to a folder, for example). I want this to be the preceise order of things: first, do script, next, do other things. [More]
OK, so Lion Recovery Disk Assistant "lets you create Lion Recovery on an external drive that has all of the same capabilities as the built-in Lion Recovery." But can I add utility/diagnostic apps to the external drive, such as Disk Warrior?If yo [More]
Hi, I have created a table and a package to perform several maintenance tasks.While creating a procedure to retrieve information. I would like to optimize the sp Please considere that this sp is employed with a VB interface. CREATE TABLE D_METEREOLOG [More]
I have build 9860, and I'm trying to update to the newer build: In the Preview Builds UI, I click Install now Within about 5 seconds it fails and displays the message "Failed to install the new preview build, please try again later. 0x80248008" [More]