R/3 table for BW
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
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...
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]
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]
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]
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]
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]
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]
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]
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]
Hi Gurus, I am a BASIS Person ..so, 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]
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.
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]
- 1 How do I use my account wit app.store in another country?
- 2 What is collaboration pane in objetive tab of scoreboard in obiee 11g
- 3 Installing Oracle SOA suite 10.1.3.1.0 on windows server 2008-64 bit.
- 4 Need help......with Girder
- 5 Data source application hier in EC6
- 6 Workflow bus0035
- 7 Runtime error in MSS - Team- General Information- Related links- Employee Dates
- 8 After 10.5.3 Update, System Events at 50% CPU
- 9 Work around portal's export/import problem
- 10 Why does my system crash for no apparent reason
- Barton 2500+ on MSI K7N2 Delta-ILSR nForce400
- How do I get rid of the very annoying "find" tab that appears on the bottom of the page constantly???
- Can I write a SELECT query on maintenance view?
- Regarding normal ALVs
- Can you send a route or waypoints to Nokia 700 GPS...
- How to identify and delete objects after failure of registering XML schema
- Deleted iChat due to problems.... how can i re-download it???
- Sync my current music wit new music in iTUNES deleted all current music.
- Cannot configure RBA to report on deployments to a higher-level collection that flows down to computers in lower collections
- Will deleting the inbox anf inbox.msf files within the smart mailboxs folder delete any emails in my unified folders?