SAP Community will be read-only this weekend (Saturday, August 31, through Sunday, September 1). Activities requiring log-in won't be possible. Learn more in this What's New post.
Hello.
I have an Item last purchase price .
I am trying to find out where this last comes from ;
looked in the following tables :AITM,ITM1,IGN1 found nothing.
Any Ideas ?
Thank Dov
Hello
How can I use the following in query generator:
/* select * from AITM T1 */
DECLARE @Date1 DATETIME
DECLARE @SaleItem INT
DECLARE @MinQnty Numeric (19,6)
SET @Date1 = /* T1.UpdateDate*/ '[%0]'
SET @SaleItem = /* T1.U_SaleIetm*/ '[%1]'
SET ...
When I execute the following query I can select value for parameter '[%]' only from a list of dates that exists in the column AITM.upDatedate .
How can I pass values to parameter '[%]' independent from the values in the column.
for example I to s...
I have the following query that works perfectly on MSSQL ( without the parameters).
But in SBO I get the following error msg:
1). [Microsoft][SQL Server Native Client 11.0][SQL Server]The multi-part identifier "t2.UpdateDate" could not be bound. ...
Thanks Maya,If I execute the query with out passing parameters the query excutes,but when I declare parameters like :/* select * from AITM T1 */
DECLARE @Date1 DATETIME
SET @Date1 = /* T1.UpdateDate*/ '[%0]'
with tb as
(
select t0.itemCode,t0.U...
Thanks.In principle , is this syntax acceptable in SB1 querying ?My query is much longer and goes like this and ,at lust for me is much readablethanksdoc:with tb (itemCode,UpdateDate,U_SalIetm,OnHand,LogInstanc,LastPurCur,ItemName)
as
(
select t0.i...