Tagged Questions

1
vote
1answer
78 views

Specifying a DB table using its path? Is it possible?

I am writing a BSP and based on user-input I need to select data from different DB tables. These tables are in different packages. Is it possible to specify the table I want to use, based on its path, ...
1
vote
1answer
49 views

The results viewer cannot execute a query with more than 655 columns in the project list

I am using Visual Studio 2008's server explorer and I need to search through a database for invoice lines. So I find this one table named ixvFact but when I try to retrieve the results, visual studio ...
1
vote
1answer
244 views

Mapping the fields of two database tables in ABAP

The scenario is that, I have 2 database tables A and B. The table B is an upgraded version of the table A. (ie It might possibly have different field names and some extra fields). I need to compare ...
1
vote
2answers
2k views

SQL Server 2008 R2: Import table from text file when column names have a / in them

How do you import a table into a database from a text file when that table has /'s in the column names? I have a SQL Server 2008 R2 table with columns that have /'s in their name. (SAP Database) For ...
1
vote
2answers
750 views

SQL Error invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause

Here is my query - created through SAP Query tool: SELECT DISTINCT T1.CardCode, T1.CardName, T1.Phone1, T1.GroupCode, T1.Territory, T2.Street, T2.Block, T2.City, ...
1
vote
2answers
74 views

T-SQL query help - Join on based on IF/ELSE

I am trying to find the retail price for articles in SAP using SQL but the nature of the Articles means that the current price can either be put against a parent or the child. The only way to tell ...
0
votes
3answers
874 views

Select for all Entries

I was trying to do with select for all entries in select statement - abap. I'm not getting the clear idea what will the select for entries will do ?? Does any one know about it Kindly have a look in ...
0
votes
1answer
150 views

SAP Business Objects - Create a WHERE condition based on user prompt input

I have a report with a typical date column. I want the user to select a start date from @prompt. Then I want the end date to be 3 months less than the user selected start date. Example: SELECT ...
0
votes
3answers
6k views

ABAP: How to combine select max and count?

select ordernr from users having count(ordernr) = ( select max(count(ordernr)) from users where ordernr = ordernr group by ordernr ) group by ordernr to get the most used order-number ...
0
votes
0answers
27 views

SAP BO XI3 US Date format being used when generating “Where Clause”

I'm running into an issue when using date objects in business objects where clause's. The underlying tables are held on SQL Server 2008 r2 and an example calendar value is 2000-01-06 ...
0
votes
3answers
80 views

I need to Create 3 Variables from 1 Variable SQL Oracle SAP

I’m working on creating three variables in the my Universe. The variables are Applications, Operating System, and Physical Location. The problem I’m running into is that all three of these is pulled ...