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 People, I use iCal in Month view mainly with one or two events there per day... Gig here... Car tax there... Whatever... When adding an event in month view iCal automatically puts it in at 0000 hours. This is ok when I'm using iCal on my Mac. But [More]
Hi, My requirement is to create a Service Ticket in Web IC automatically in background when an enquiry is submitted by an user over the company's website. I am unable to find any function Module or BAPI to do the same. Is it possible to do it in the [More]
I bought my Nokia Lumia 620 a few weeks ago and have been struggling to get it to do what I need. I've been looking online but I haven't found a solution/answer to my doubts. Maybe somebody here knows: Although the Lumia's calendar is compact, it doe [More]
Hello, Please could you tell me if it is possible to get a unique identifier in an FBL3N report? (I would want the unique identifier to remain unchanged for each line item if new line items are entered into SAP.) (i.e. if staff write commentaries for [More]
My wireless phones run on the dame frequency as the AirPort Extreme Base Station. I would like to be able to connect to the internet wirelessly but this seems to be a problem with the AirPort. Are there any subsitutes that would be compatible with my [More]
During a work trip, a folder popped up on my desktop. "No Name" but with an icon below Macintosh HD and iDisk under "Devices". It looks like it has people walking across the box, but I cannot see closely. It could be protractors too... [More]
Hello Over the last couple days I have searched virtually the entire web for a solution for a photo workflow that would allow me to only have my ipad with me when I am on a vacation and still being able to review my images without running out of memo [More]
hi, My Macbook pro crashes when I close the lid. The front light does not pulse... etc... Same behavior for all the users on the system. This article mentions that I should disable Safe Sleep: Is this my ONLY opt [More]
Is it possible to have longer pages (768x1500) and set it to horizontal smooth scroll. I wonder if you could upload several long articles and combine them into one article and set it to horizontal smooth scroll?I think the Smooth Scrolling feature is [More]
I have problem with filesonic website as it is not showing the access to the download time. I couldn't register on firefox did not submit my registration form. I can't login on some website even if I replace the login with new pas [More]