Saturday, November 03, 2007
Thursday, October 18, 2007
SCC1 - Transport Copy
RSTXSCRP - SAPScript Export/Import
is sky the limit... transaction codes
Wednesday, October 17, 2007
Therry: okay shoot
Wilstroth: When user says update vendor GL, say, 323XXX, it means I go to F-02 to do a posting key 40… then 50 right?
Therry: First, what kind of transaction they want to post?
Wilstroth: The transaction is regarding to payroll
Wilstroth: DR vendor
Wilstroth: CR bank
Therry: can you tell me the description of GL 323XXX?
Wilstroth: It’s reimbursement.
Therry: I assumed the vendor is the employee, correct?
Wilstroth: yes, you are right!
Therry: Okay, can you go to TCODE FS00?
Therry: Then type that GL 323XXX…
Therry: Check that GL with your specific company code…
Therry: Choose TAB "Control Data"…
Therry: Choose the Display icon first…
Therry: Then only choose “Control Data”…
Therry: Is there any field called "Recon. Account For Acct Type"?
Wilstroth: Yes, there is…
Therry: Are they referring to Vendor?
Wilstroth : Yes, they are!
Therry: You can post directly to 323XXX with posting key 40…
Therry: And 50 for the bank account (credit)…
Wilstroth: ic... ic...
Therry: Ok now... find the vendor master data first.
Wilstroth: How do I search for the vendor master data?
Therry: The TCODE is FK03.
Wilstroth: From the list given by user, the vendor (employee) GL is 11000XXX.
Therry Mully: Type this TCODE S_ALR_87012086.
Therry Mully: and type the company code
Therry Mully: choose DYNAMIC SELECTIONS button
Therry Mully: on the right find reconciliation acct…
Therry Mully: then fill it with 11000XXX… and execute it (F8)
Therry Mully: you will see all vendors under that 11000XXX GL account
Therry Mully: Okay, now about the posting…
Therry Mully: usually it began with this journal entries:
Therry Mully: Dr. (40) Expense
Therry Mully: Cr. (31) Payable (Employee vendor)
Therry Mully: then it will be cleared with these journal entries:
Therry Mully: Dr. (25) Payable (Employee vendor)
Therry Mully: Cr. (50) Bank
Wilstroth: Okay... Now I see the picture!
Therry: you cannot use posting key 40 or 50 for vendor since you cannot post directly to 11000XXX!
Therry: 11000XXX is reconciliation account I assume, under this account you have employee vendor accounts and you only can post into the sub ledger or vendor accounts
Wilstroth: Yes, you are right!
Therry: please check 11000232 account again with tcode FS00, the one previously I taught you
Wilstroth: ok... hold on
Therry: check whether it is reconciliation account or not
Wilstroth: but its not existing
wilstroth: yeah i am at QAS
Therry: then let the user know
wilstroth: so there will do it right?
Therry: if they use the same concept i told u for salary...
Therry: then they should have payable account and employee vendor under it
wilstroth: ... ok let me go check further... thanks man...
wilstroth: because i am doing update part on DR(25) and CR(50)... i will be using posting key 25 and posting key 50 right?
wilstroth: that is the only part i am doing... journal entries... will be done by user
Therry: but you need the first journal entries before you do 25-50 posting
Therry: otherwise, the payable account will have OPEN status
wilstroth: ok.. i take note of that
Wednesday, October 10, 2007
That is because the space is not recognized during upload by GUI_UPLOAD function module. The SPACE among the strings of line items will be replace by '#'. However, this hash or '#' is not your average character '#' but it is an ASCII character of value 09. Thus it showed as '#' in your strings of line items.
is sky the limit... split with ASCII 09... not #...
Thursday, July 19, 2007
Wednesday, May 30, 2007
Tuesday, May 29, 2007
Although SAP did provide 2 BADI for developers to enhance those forms but it only work on certain way and i find it hard to fullfil my functional request thus forcing me to activate enhancement on the standard program itself. This solved one issue over another. Perhaps I would like to meet people who have experience similar situation in modifying or enhancing the EC Form.
1. HRPAYMY_ECFORM - calculation for BIK (Benefit In Kind). This generally displays a lump sum of benefit in kind into the section B (Manfaat Barangan). Unfortunately, my request was to display the breakdown list of all the benefits to one person.
Note : RPCTEAL0 is the original version given by SAP. RPCTEAL0_01 in this context is the new version given to the customer by SAP after a report was make to correct a certain mistake in the past.
1. HR_MY_TAXECLM05Y - EC Form
2. HR_MY_TAXEABL007 - EC BreakDown List
IMPORTANT: You will need to open up your SAPScript EC Form to see what fields are displaying your value as you do your enhancement.
Thursday, May 17, 2007
- IT0003 (Payroll Status)
- IT0009 (Bank Details)
- IT0185 (Personnel IDs)
- IT0196 (EPF)
- IT0000 (BackDated Pay)
- IT0198 (Check if record exist)
When you need to create or add functions to payroll driver of a certain country, you will need to know three things and there are:
Step 2: Click create to get into the schema attributes. (Note : Choose country grouping accordingly to which payroll is being used. E.g. 14 is for Malaysia because this example is using Malaysian payroll).Figure 1.1 : Schema attributes.
Step 3: Choose program class either payroll or time management.
Figure 1.3 : Program class selection
Step 4 : Save and exit. (Note : For the time being we go to PE04 to create functions before we come back to link both of them up)
- PE04 - Maintain Functions and Directories
PE04 allows you to create functions/operations for either payroll or time management. This functions will be saved and enabled in the following program and link to the schema directory above. Thus completing your setting up of additional schemas to your payroll program.
Steps to create function(s) in schema functions
Step 1: create a new name e.g. zsub1.
Figure 2.0 : Create a function
Step 2: Click create to go into characteristics of function payroll. Provide description and country assignment should be according to which country payroll are being run by the client.
Figure 2.1 : Choosing country assignment and description.
Step 3 : Click Save. (Note : Ensure your country assignment is selected correctly.)
After performing the above steps, you can start to insert functions into include program (PCBURZMY0) of main program (RPCALCL0). Additional functions of payroll schema/driver are added to PCBURZMY0. RPCALCL0 will go through each of the functions in PCBURZMY0 when payroll administrator runs payroll.
is sky the limit... payroll driver... how-to
Friday, April 27, 2007
It will take 5 types of table
IT0008 - Basic Pay
IT0017 - Tabung Haji
IT0198 - Income Tax
IT0014 - Koperasi
IT0196 - EPF
All these data when user modified and click the SAVE button will be captured and sent to a customized table. Eventually this data saved in the customized table can be utilized by another program.
DME is also known as international payment transfer
2. You will need to modify 3 function modules that will create the header file, item file and the trailer file. In order to do this, you can copy the following standard Malaysia file format (Malaysian Banking Berhad) and modified it. Thus, the standard are:
With this three standard function modules, you will copy and modified to become your custom file:
In each of this function module, please take note that certain lines you will need to retain and do some modifications so it could pass your parameters back to RFFOM100 (DME) program. The DME program will take this customized files and download accordingly to it.
In this three standard function modules, you do not need to copy and modified it. You just have to activate enhancement that is provided by ECC6.0. This feature is provided in ECC6.0 to make adjustment to standard programs easier. So to enhance the three function modules:
1. Open up enhancement feature by going to Function Module/Enhancement.
Now you can start to enhance the three standard function modules to call your customized function module to use your customized file format.
2. Creation of this requires particulars such as bank key, bank account, country, reference key (payee code), name, date begin, date end, and payment method (restricted to P or S).
If payment method is P then bank key and bank account fields
are not required. Else payment method is S thus the reversed.
3. Either able to modify or display after payee key is created.
4. Delimit the payee key. Delimit actually restricts certain validity of the payee key in this context.
Unlike delimiting a record in a table which creating a few record with similar key and different dates.
Tables that are affected by the process are T521B (payee key) and T521C (check table payee key)
This program is very much similar cheque number program but purpose is to maintain payee key.
More on how to DELIMIT record.
Is Sky The Limit... Payee Key
In order to maintain cheque numbers, a dialog program is required to create, modify, display and delimit it by users manually. Currently, this program will be used by the conversion team to create cheque numbers by batch for testing. Other particulars that required by user is only the payee description.
I will explain more on infotype and infotype creation in the next entry.
At PE04 (schema maintenance for payroll and time management) will be used to create a new payroll function to replace existing wage type to the new wage type based on the above content in customized table. Thus, a payroll driver will be created to maintain old wage type with new wage type.
Known tables or structure involved:
1. RT Table (Result Table) - holds all income/deduction wage types for a person
2. BT Table (Basic Pay Table) - holds all basic pay information (ie pay method, pers. area, etc)
3. V_T012 – House Banks - view of all banks alias with the company/org.
After payroll function has been defined, the new function will be added in PCBURZMY0. (this will require a developer key).
Bank Cover Slip
Summary of Bank Credit Report
Summary of Employees Report
First, the bank cover slip will calculate the total number of amount payroll to be credited and the total number of employees to be credited. This is an overall calculated by the program when its process report 1 and report 2.
Second, the summary of employees report will display all the eligible employee for payroll. In this report, it will show the employee numbers (PNALT-PERNR), employee’s name, employee IC, employee bank account no and total amount paid. Each of this employee will be group according to a bank code. This bank code determine which bank will be credited.
Third, the summary of bank credit report, simply shows a list of bank and its total amount to be credited. The bank code, bank name and total amount are fields in the report.
My first assignment was to come out with a payroll control statement that will display every employees income and benefit and deductions in a list. This control statement will be group accordingly to its WERKS-personnel area and ANSVH-work contract. This is due to large number of department (with 9XK employees) or states to manage its payroll. In this control statement, the payroll department will be able to validate all of its recipient correct amount of take home wage types and deductible wage types.
Apart from this, the technicality behind this program can be found in my previous entry on flexible spending account.
is sky the limit… payroll revisited for two months
Wednesday, March 21, 2007
(Reversal meaning reversing a charge document in moments when there is a wrong charge or cancellation of order. This is my own definition and it could technically meant something else in a functional prospective as well as SAP's definition; so pardon me.)
Saturday, February 17, 2007
While I was troubleshooting, the application crashed indefinitely and it wouldn't budge. So i make the very wrong move by pressing, you know what, CTRL-ALT-DELETE. The all-mighty Microsoft GOD forbidden function to kill off crashed or stalled program. Why i would say it wrong or in fact you guys out there are shooting my brains off is because when an SAP or ABAP program is running, even though it may looked stalled, but behind it - IT IS STILL RUNNING...!
So i made the terrible mistake.
When i opened up the editor to edit the program, it was locked. So again, i went to SM12 to unlock the program. However, this doesn't really solve our problem. Why? Because, you have to remember that my friend is using EN-QUEUE and DE-QUEUE functions. It means, when your program has begun an EN-QUEUE function you must always DE-QUEUE it at the end immediately. Now, because i make the ever blunder CTRL-ALT-DEL before the ABAP program got the chance to DE-QUEUE it, the report will not execute properly in the next session.
So we were turning in cycles for at least one hour and looking for an answer until someone said, "Eh, you guys should check out SM51... maybe your process is still running" By GOLLY, it was still running and it was there. We delete the session and instantly everything came back to normal.
Lesson learnt :
1. Never use the almighty God Forbidden Microsoft invented CTRL-ALT-DEL to kill off your ABAP process. Think twice before doing it.
2. SM51 to maintain and monitor processes
3. SM12 to maintain and monitor locked programs or transactions.
is sky the limit... CTRL-ALT-DEL and EN-QUEUE vis DE-QUEUE...
Friday, February 09, 2007
- Summary Cost of SalesBased on Cost Code Group, GL account number and the unknowns (items that are bought but not specific to which project) are group into the cost of sales. Not to mention, this include known invoices which are already identified to projects.- Vendor and Vendor & InvoiceIt will display all related vendors and its invoice the summary cost of sales.