Sitemap

Amicuk Programming Answers

Query to show Change in Payment Terms BPs

-0001-11-30   Views:0

Advertisement

Hi All Since we cannot restrict users from updating Customer Payment Terms if thay have access to BP Master Data, I would like to create a query (to set as an Alert) to show when BP Payment Terms have been updated Has anyone written such a Query that

Hi All
Since we cannot restrict users from updating Customer Payment Terms if thay have access to BP Master Data, I would like to create a query (to set as an Alert) to show when BP Payment Terms have been updated
Has anyone written such a Query that they wouldn't mind sharing?
Thanks
Peter

The replay answer
Advertisement
To get the payment terms modified today you can use this query:
SELECT t.CardCode, t.GroupNum New, p.GroupNum Previous,
  t.UpdateDate,t.UserSign,u.U_Name
FROM ACRD t
  inner join ACRD p On t.CardCode=p.CardCode and t.Loginstanc-1=p.Loginstanc
  inner join OUSR u On t.UserSign=u.Internal_k
Where datediff(d,t.[UpdateDate],getdate() )=0
   and  p.[GroupNum]!=t.[GroupNum]

Go to See the other 5 answers

Query to show Change in Payment Terms BPs

Category:DefaultRelease time:-0001-11-30Views:130

Hi All Since we cannot restrict users from updating Customer Payment Terms if thay have access to BP Master Data, I would like to create a query (to set as an Alert) to show when BP Payment Terms have been updated Has anyone written such a Query that[More]

Receivables - Query of Customers, sorted by Payment Terms?

Category:DefaultRelease time:-0001-11-30Views:130

I'm looking for an easy way to run a query (through the Applications layer) of all customers, sorted by their Payment Terms (Net 30, Net 45, etc.) Any ideas?Hi Robert....... You can consider the Days of intervals as the payment temrs. For Example put[More]

Query to check BP Payment terms and Document Payment terms

Category:DefaultRelease time:2015-10-11Views:130

Hi All, Can any one help me to create an approval query to check the BP payment terms and Document Payment terms are same or not? Normally we change our BP payment terms regularly as per the agreements between Customer and us. but when we copy any pr[More]

Query on Payment Terms

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus, I need a report that will show me the payment terms for all plants in the Co codes for 1.The Accounts Payable Vendor Master 2. The Purchasing Vendor Master If the Accounts Payable Vendor Master and the Purchasing Vendor Master are always th[More]

Authorisations for Changing BP Payment Terms

Category:DefaultRelease time:-0001-11-30Views:130

Hi Experts Is there any way which I can prevent certain user changing BP Payment Terms using authorisations?  Alternately, would it be possible to write a query which shows me which users have changed Payment Terms of BPs which I can then setup as a[More]

Payment Terms fetch Issue(Plant Level) @ SRM 7.0

Category:DefaultRelease time:2015-10-11Views:130

Hello Experts, We are currently implementing SRM 7.0 system(Classical Scenario) across regions.In one such scenario we found out that when we create a PO directly in SRM the Payment Terms is fetched correctly from the Vendor Master at Plant Level(Byp[More]

AR Invoice with Installment Payment Terms

Category:DefaultRelease time:2015-10-11Views:130

Hi to All, We have an invoice where the payment terms are based on installment. The installment is for 18 months.  Automatic cash receipts have been applied correctly for Installment 1 and Installment. Our situation is this where we want to apply an[More]

PO release in case of changes in Variance or Payment terms

Category:DefaultRelease time:2015-10-11Views:130

Dear All, In case of any changes in the PO other than the qty and rate, if we want new release to be effected for other fields tehn what is the way out. Eg. Changes have been made in the payment terms, or delivery variance (over and under) then what[More]

Payment Terms in Third Party Sales Invoice.

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, We are facing the problem in third party sales process. Suppose X is our customer and Y is our vendor, here Y is supplying the material directly to X and Y sending us the bill of entry and other documents to us, and then we create the sal[More]

Vendor  payment terms replication

Category:DefaultRelease time:2015-10-11Views:130

Hi, Vendor payment terms are not getting replicated to SRM 4.0 from ECC 5.0.We have batch jobs running for vendor replication ( new and update).When i change the payment terms  in ECC , it is  not coming to SRM.I checked in Manage BPs. Thanks for sug[More]

Vendor Payment Terms Changes - Listing?

Category:DefaultRelease time:2015-10-11Views:130

Hi SDN We are trying to track all the Vendor Payment Terms Changes done in the Vendor Master, and I was wondering if SAP offers some reports that could list, for a given time period, all the vendors that their payment terms changed, as well as what w[More]

Hot
Hi, I have to delete a member from a the EAS outline. Tried deleting it manually. It throws a error stating that outline cannot be saved. Hence they restarted the services and i was able to delete the member manually. I later had a thought that may b [More]
Hi All, I am using A Statment like this a BADI. EXPORT XXXXX TO MEMORY ID 'YYY'. But this statement is not supported in ABAP Objects can any one please let me know how i can use export statment is abap objects? Thanks in advance.I have pass a structu [More]
How can I remove the 6.1 upadte so I can receive text messages again? I've tried deactivating Icloud; setting up a new account not shared w/ anyone or any other devices and it's still not working. HELP!! my money is on a hardware issueRead other 2 an [More]
Hello Everyone, Lately I have been having a problem where suddenly the letter and number keys stop working in the Finder, but JUST in the Finder. For example, if I make a new folder on the desktop, I cannot rename it, because the letter keys aren't w [More]
Hey, i keep seeing people saying they've got the compressor version 2.3.1, and i cant seem to find the update anywhere... if you could assist me in finding where and how i can update my compressor v 2.0.1 to the 2.3.1 version that would be awesome!Ha [More]
hi if some one can tell me why i can't add my sms saved message from my pc to my mobile... i have update my nokia 6125 but before update i have saved my sms message copy from my phone and paste to pc but now i can't copy and paste to the phone some h [More]
Do static or class methods exist in TOOL? If they do, I would appreciate a pointer to the documentation. If they don't exist, what is best practice for creating utility or helper methods for things like string operations, getting random numbers withi [More]
Hi all, Binding Input and Output nodes of a model node. Most of the time, we create a object of the input model node and then, bind that object with wdContext. Do we need to bind output node objects too in RFC Models? Regards Neha SinghHi Neha, There [More]
am trying to filter out some search results in eclipse with regular expressions, but am not having any luck. I am trying to find all jsp pages that contain html:text tags that DON'T have a maxlength attribute. I have tried this, but it doesn't seem t [More]
I got an ipod shuffle yesterday and loaded 70 songs. today i plugged it back into the computer to load another 30 songs and a message came up saying 'unknown error (-36)'. i then got another message saying 'cannot locate folder'. i restored my ipod, [More]