Tables:
PTREQ_HEADER:
Every Leave request will have a 32 character document ID. This will have one entry for every document status and also have a time stamp for each of those entry. This has a 32 character field called "ID of the item list" which will link this table to the next table PTREQ_ITEMS.
PTREQ_ITEMS:
Every leave will have one or more items. Items ar enothing but leave operaitons.
Example: If it is a new leave, it will have one item for 'INS' (inserting) a new leave.
If it is a deletion leave, there iwll be one item for 'DEL' (deletion) of a leave.
If it is for changing an existing leave, then there will be two items. One for DEL of old leave, another for INS with changed leave values.
PTREQ_ATTABSDATA:
Every item in PTREQ_ITEMS will have one entry in PTREQ_ATTABSDATA giving details of pernr, leave date, type, operation (INS or DEL) etc. The link between these tables is again through a 32 character field ITEM_INS.
Reports:
Leave Request "Home page": Tcode: PTARQ or use the report RPTARQ
Above "Home Page" provides many reports and tools to work with Leaves. They are listed below.
1. RPTARQDBVIEW: This report allows you to see all leaves applied by a user. You can even use the work item id (top) to fetch a leave request.
2. RPTARQPOST: Post Leave requests to Infotype 2001
3. RPTARQDBDEL: Delete a leave request. This should be used carefully in Production. This has a 'Test Run' option. This report in Test Run option can be used to view leave requests instead of RPTARQDBVIEW, which is much slower.
4. RPTARQUIATEST: This is not released for customers. (That means SAP will not support any problems you face). But a very useful report which can be used to create new leaves, approve/reject existing leaves,
Wednesday, December 29, 2010
Friday, December 17, 2010
SAP Workflow Reporting
Reporting on Workflow data is a skill in itself.
In addition to ABAP skills, Workflow reporting requires you to have Workflow skills, knowledge of Workflow technical architecture and tables. Here is an effort to quickly equip you with those skills.
FAQs on Workflow reporting
For the code refer
http://learnhrabap.blogspot.com/2010/09/workflow-how-to-read-multi-line.html
Here are other useful books on SAP Workflow topic.
In addition to ABAP skills, Workflow reporting requires you to have Workflow skills, knowledge of Workflow technical architecture and tables. Here is an effort to quickly equip you with those skills.
FAQs on Workflow reporting
1. Which is the transaction table of ALL work items?
Answer: SWWWIHEAD is the transaction table of all work items.
This table contains one entry for every work item in the system.
This table also says if the WI is dialog or background, creator of the WI, creation time stamp, and current status of the WI, Parent WI and Top WI.
2. Where will I get Work Item completion date and time? (Complete / Logically deleted)
Answer: Table SWWWIRET. This table will also provide any errors occurred for the Work item. SWWVHEARET is a Joint view of SWWWIHEAD and SWWWIRET.
3. Where can I get different deadline date and time for each work item?
Answer: SWWWIDEADL will give all the deadline dates for each work item.
4. Which table can give me the dialog work items pending with a user?
Answer: SWWUSERWI or use the FM SWN_UWL_GET_WORKLIST
5. Which table can give me the dialog tasks executed by me?
Answer: SWW_OUTBOX or use the FM SWN_UWL_GET_OUTBOX
6. I have a Notification which triggers a workflow. (I use ISR framework). Where can I see the link between Notification number (QMEL) and the workflow?
Answer: Use table SWW_WI2OBJ
7. Where can I see the entire log for work item? I want to see how it was created? (Triggered by an event?), any one changed its container? Any one changed the deadline? Etc.
Answer: Use table SWWLOGHIST.
8. Is there any table which will provide container of a work item?
8. Is there any table which will provide container of a work item?
SWW_CONT - Container Contents for Work Item Data Container
SWW_CONTOB- Container Cont. for Work Item Data Container (Only Business Objects
SWW_CONTOB- Container Cont. for Work Item Data Container (Only Business Objects
For the code refer
http://learnhrabap.blogspot.com/2010/09/workflow-how-to-read-multi-line.html
Here are other useful books on SAP Workflow topic.
Subscribe to:
Posts (Atom)