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]

Since updating to 8.1   Tapping to view videos in full screen goes to portrait full screen instead of landscape full screen while in landscape position. There are also problems  trying to full screen in portrait position. i pad mini retna 16 gig Geen [More]
Hi, I would like to know how data encryption in Oracle 9i differes from that of Oracle 9i database. Thanks in advance ShintoWhat is your national character set? What is NLS_LENGTH_SEMANTICS set to? Justin Distributed Database Consulting, Inc. http:// [More]
Hi, I want to export an ALV grid which has 88 columns to Excel Spreadsheet. The problem here I am facing is after 66  columns the heading and the relevant is going on the next row. I have tried searching SDN but found nothing in vain and finally post [More]
Hi, I am new to data mining and I know the genralize concept of Data Mining. I want to implement the application with Data Mining using or but don't know how to start. So any body know any sample application for data mining using [More]
Are there any drawbacks if you create 2 RAC databases ex Chicago (consisting on 2 nodes Chicago1 and Chicago2) and Orlando (consisting of Oralndo1 and Oralndo2) on the same ASM instance running on Oracle 10G R2. Would it be better to create 2 ASM ins [More]
I have Oracle (version 8.1.7) installed in my XP machine and when I try to (having chosen "Launch DBA Studio standalone") to open a connection I get: "Failed to parse tnsnames.ora file ERROR: 100 -- NLNV-NLNV String Format Error". Also [More]
Dear All,      I have a web service, which is used to convert one currency type to another currency. With help of web service task calling that web service in SSIS package.  After configuration I tested connection and downloaded WSDL file General Tab [More] That number came up in the address what is that did somebody hack in?I found this, don't know if this can help you. [More]
Hi, We have some Ques stuck in APO inbound "Several modes with the same number  at activity 2N". Can anybody help me to fix this.? Sameer.Hi Sameer, indeed your issue seems to be linked to PDS creation. Your PDS CIF jobs must be failing if I am [More]
My VM administrator migrated my server, and gave it a new IP. I'm running SLES 10.1 and GWIM 204. eDir has been fixed, changed nds.conf and the properties in consoleone, ran ndsrepair. GW working fine. Changed the messaging agent host IP to the corre [More]