SAP: substitution/validation transactions
A quick and simple way to locate a validation/substitution rules can be achieved through the utilization of two transactions GGB0/GGB1 respectfully.
Within the transaction if accessed the menu panel Environment – Directory one can select the level of detail and display an entire collection of all the rules that exist in the system.
SAP: Payment Run: err – “overlap with payment run” – DB fix
I faced a problem while automating a payment run process, the log from the run spit out the following error message:
”
Log for payment run for payment on [Date], identification [PR#] Overlap with payment run [Date] [PR#A] ... the execution of the payment program is terminated
”
Some online digging has resulted in an identification of two different tables:
T042X: Company Codes Blocked by the Payment Program – this table contained an entry for the company code with which I was working.
REGUV: Control records for the payment program – this table contained records for each of the payment runs and specifically tracks the status of each in the field XECHT. The failed records that I’ve encountered has a value S where a blank would identify that a production run has not been carried out yet.
Fixing these two tables will set the runs in to the original state.
SAP: prompt user for a job-name when scheduling program in the background using SE38
When you want to execute a standard program and run it in the background typically SAP will name the job with the same identification as the program name.
To compensate for this behaviour you can implement a badi [JOB_NAME_SELF] . Import parameters will include program name and export parameters will contain jobname.
To make the process more flexible you can enhance the functionality by prompting the user to populate the actual program name, here’s how you can accomplish that:
SAP: substitution rule exclude fields
Changing a value in a substitution rule might be perhibited based on the configurations in the GB01 table.
ABAP: link company code and controlling area
Quick way to find a controlling area derived from the company code is to use the following BAPI_CONTROLLINGAREA_FIND. Examining further you will see that there is a reference to table TKA02 with parameters of company code and business area.
SAP: Enable substitution rule changes
If your substitute changes are not taking effect make sure that you have an entry in the GB01 table. Once you mark down the column you want to change be sure to re-generate the programs. Here’s how you can do that.
SAP: Send an Email with executable SAP command
If you want to send an email with an attachment that can link you directly to an SAP transaction here’s how you do it:
- Create an attachment.sap file in your ABAP application
- Populate the file with the following information
[System]Name=<sysid>Description=Short DescriptionClient=<clientid>[User]Name=<userid>Language=EN[Function]Title=Display PO informationCommand=ME23 RM06E-BSTNR = <PO Number>; BDC_OKCODE=/00
When you double click on the file you’ll be redirected to the ME23 screen.
SAP: FM READ_TEXT – where to look
Reading text string can be tricky to debugg but a good start is to look at tables STXH & STXL.
SAP: ABAP: ALV grid color scheme
Here’s a list of colors that you can use to color your ALV grid.
To actually use create a field of 4 characters and use ‘CX00′ where X is the number specified above.
SAP: transport classes
If you know how to transport copies of objects then you are half way there. So a quick and easy way to figure out what to put in to your transport [Change Object List] perform the following steps:
- go to SE24
- type in your class name
- click Goto – Object Directory Entry
At this point you should see your object definition entries: R3TR – CLAS – <CLASS NAME>. Grab that and move your transport.
