Hello,
I hope you're all doing great. I'm trying to build a query to create a check in a SBO_TransactionNotification Procedure which will prevent the SAP B1 to add same Lead# (e.g Cost Ref ID UDF) to other items. e.g 1 Lead# per Item. As users are ...
Greetings,
I have been trying to retrieve data from a Production Order related to a resource. Here, the setup time and running time of the machines are mentioned in Planned Quantity. I want to retrieve those.
But, i can't seem to show their Pl...
Greetings,
I'm a complete newbie to the SAP Crystal Reports. I would really appreciate some guidance regarding this. (Please check the attached screenshot). How can I add these details in Report Header Section e.g Dynamically picking up Requester...
Greetings,
I have been trying to find customers who has no sales in the past two months. I'm basing it on the fact that they have had no product delivered in the past two months. But, how can I exactly get the name of those people?
I've tried:
...
Greetings, Hope you're having a great day.
What I'm trying to find?
I am trying to understand the logic behind these tables like how are they calculated? I'd really appreciate if someone can explain to me how are these values calculated in the f...
Thank you so much, that is so helpful. Luckily, i found a solution to this just today as well by hit and trial. IF :object_type='4' AND (:transaction_type = 'A' ) THEN Select COUNT(*) INTO CNTfrom OITM T0INNER JOIN OITM T1 ON T0."ItemCode" <> T1."It...
Thanks for the response.We're trying to attach a third-party CRM Lead# with an Item. Based on the trend, that every Item will have a unique Lead#.However, some users are trying to add the same Lead# to multiple items. A check that will prevent users ...
Thank you so much for your input. I have just started learning SAP. Don't know about these views. But, I will try to figure it out on my own from here. Regards,Dee Dee.