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 What is Implicit Enhancement and what is explicit enhancement.
- 2 IMac, graphics card and Final Cut Studio
- 3 Original files unable to be located???
- 4 N80 Media player exclamation mark flaw
- 5 Yet another person who can't drag songs into a playlist
- 6 Cycle back to unanswered questions
- 7 Link Tables for Delivery,Outgoing Excise Invoice, A/R Invoice
- 8 Photo upload
- 9 White frame around the pictures
- 10 No HDR pro option in drop down tools on bridge cs6
- How much ram support my macbook pro 8.1
- How to create a playlist on my computer of all the songs on a device?
- How to Use the Average, Count, or Sum to Validate a Collection
- Multiple email address in OIM 11g
- What codec do i need to play .mov on windows7
- Ghost Pictures of Desktop and Screen Saver best practice.
- HT4009 Can you buy in-app purchases with itunes giftcard money?
- Moving iWeb site from one computer to another
- Enhancement (HR ABAP)
- Ipad Photo - Making File Size Smaller for emailing