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 Album Artist
- 2 File To Mail - Error in sender CC
- 3 Mapping canvas of the mapping editor doesn't display
- 4 I have a iPad Air and iPhone 4s and I have a app on my iPhone that I can watch movie on but as the screens to small I would like to watch the. On my ipad, how do I connect my iPhone to my ipad to watch the movie?
- 5 Completion of one workflow is triggering another workflow
- 6 WLC 5508 126.96.36.199 has vpn client connection issues
- 7 Creating a web provider for java portlets
- 8 BD64 filter IDoc with Z-Segments
- 9 Isync stopped working with ical
- 10 Color in both Bridge CS5 and ACR look yellow.
- Create a new Buffered Image using Raster and ColorModel
- Cancel of debit Memo, Don't want debit memo request in VF04
- HT203167 Due to system error, I couldnt backup one of the purchased game. Is it possible for me to get this app free of cost again?
- Simple SWF File problems
- Invisible objects made visible revert to their invisible state after saving and opening
- Problem in Oracle9i dbca
- Retrieving WCM content from UCM and displaying on webcenter 11g
- Changing SID of Windows Installation
- Which MacBook Air should I get? 13 inch or 11 inch
- HT4928 My Mac App Store account page does not show any options for unhiding purchases.