I know that the new SCN is a fact and we just have to learn to live with it, and eventually we will be able to use it the way the makers have designed it for, but changes are sometimes hard to live with when you are used to a perfecty good system, a...
Hi Everyone,Today I got a request from a customers user for a report with contactpersons and their e-mail adresses. I said it would be very simple to generate this with the query generator. Unfortunately this user had never heard of queries, let alon...
Hello everyone,Some time ago I came across the DI commander henry.nordstrm/blog/2007/08/19/get-your-kicks-with-di-commander and later the henry.nordstrm/blog/2008/05/05/di-commander-20--the-new-generation-scripting-toolboth great work from Henry Nord...
In some situations it is possible that you are missing a license to assign to a user. This might happen if you are working in a test administration where you created a test user and assigned a license to this user. If you then delete the test adminis...
Hi everyone,My name is Andy and I wanted to tell you about the vlogs I create for SAP users. The vlogs are about functions in SAP and are beginners to intermediate level. As we are focusing on customers in The Netherlands the vlogs are in Dutch. You ...
Hi,You will have to create two businesspartners for the same entity. One as a customer and one as a supplier. When invoicing (both A/R and A/P), you can apply internal reconciliation.Cheers, Andy
Try thisIF(@object_type = '17') and (@transaction_type in ('A', 'U'))
BEGIN
DECLARE @Customer NVARCHAR(50)
DECLARE @check INT
SET @Customer = (SELECT CardCode FROM OINV T0 WHERE T0.DocEntry = @List_of_cols_val_tab_del)
SET @check = (SELECT COUNT(T0...
This is a functionality descibed in SAP Note 2399156 https://me.sap.com/notes/2399156Go to Administration → System Initialization → Authorizations → General AuthorizationsSelect the relevant user and under General → Access to Masked Data, select Ful...
Hello all,This is perfectly possible with DTW.First of all the sourcefile must exist. In my example it is C:\Temp\test.pdfThe import files should be the OACT and ACT1 which you can find in the Templates folder of the DTW. This is my OACT.txt (tab del...
