Mark Alexander
- Total activity 12
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 1
- Subscriptions 3
Activity overview
Latest activity by Mark Alexander-
Mark Alexander created a post,
Calculation Query
I'm trying to write a query that will list all make items with their corresponding direct material costs and labour costs, as per the data in the calculation section of the Item Master. I don't kno...
-
Mark Alexander commented,
Hi Martin, I found it now. I was querying on the wrong attribute (DocNum instead of DocEntry), and it was returning nothing for the view. Now I'm getting all the rows, with the planned time. Thanks...
-
Mark Alexander commented,
Hi Martin, If I query the view (BEASV_WORKORDER_ROUTING), I get nothing for the work order in question (33780). If I query table BEAS_FTAPL I get the 3 rows for each operation, but none of the valu...
-
Mark Alexander commented,
Hi Martin, Thanks for replying. I see planned time and reserved time, which are taken from BEAS_FTAPL and BEAS_RESOURCEN respectively. I can't find the planned time in BEAS_FTAPL and the BEAS_RESOU...
-
Mark Alexander created a post,
Booked time for operations/routers
AnsweredI am trying to write a query that will display the booked time for an operation/router and the actual time that was logged against it. I don't have a problem getting the time logged for each scan, ...
-
Mark Alexander commented,
Hi Daniel, Thanks for the response, I put the missing text into the query and it worked great. I didn't put them in originally as I thought they were comments (Similar to C++ code), and didn't real...
-
Mark Alexander commented,
Hi Daniel, thanks for the response. I did as you suggested but I still get an error. Here's my new SQL statement below: DECLARE @ItemCode NVARCHAR(100)SET @ItemCode = '[%0]' SELECT t1.ItemCode, t2....
-
Mark Alexander created a post,
Beas User Input Query
AnsweredWe've just started using Beas and I'm formatting a few queries that combine SAP and Beas tables. I need to create a query that prompts the user for a value to search on. I can do this in SAP by usi...