Tuesday, July 28, 2009

SAP > How to Find a Table

Posted by Aries Wandari

How to Find a Table of a field
Press F1 of Field
clip_image006
Press Technical Information button.
clip_image008
Double Click data element
clip_image010
Choose where used list.
clip_image012
Select table fields.
clip_image014
I suspect T005T
clip_image016
Go to SE16
clip_image018

SAP > Add User Authority

Posted by Aries Wandari

Add authority
Go to SU01
clip_image002
clip_image004
Go to PFCG
clip_image006
Copy Role from PTP
clip_image008
clip_image010
clip_image012
clip_image014
clip_image016
clip_image018
clip_image020
Save
Generate
Go to PFCG
Transport
clip_image022
clip_image024
Create New Transport
clip_image026
clip_image028
Release transport with SE09
clip_image030
clip_image032
clip_image034
clip_image036
clip_image038
clip_image040
clip_image034[1]
clip_image042

Test From Windows Live Writer

Posted by Aries Wandari

Test posting from Windows Live Writer.

Sunday, May 17, 2009

TRACKING System

Posted by Aries Wandari

Company policy in Health Safety and Environment is No Accident, No Harm to People, and Conserve Environment by Prevent Pollution. The company will regularly identify safety issue associated with all activities and take appropriate action to manage the risks and hence prevent or reduce the impact of potential accidents or incidents. And its all elements of the company mandate to create such safe workplace and environment.




Currently we has built and maintain TRACKING inhouse application software for this HSE matters. Built with VB6 and DBMS MSSQL 2000 .TRACKING is an electronic HSE management system as an automation in recording, reporting and documenting of HSE Input and Output. The system maintain safety issue of the company, such as Incident, Nearmiss, Substandard, Safety Inspection, etc. It provide as a paperless and fast communication since it generate an email notification and weekly reminder to every person related to the safety issue outstanding action. The system try to record all system (potential) failures in the company to prevent future incident. As the (potential) incidents reported and investigated, HSE team will try to discover basic cause of the incident and indentify what action/program need to be taken to control that losses.





Tracking Workflow
















All personnel is responsible to record and entry the safety input and output on tracking system. Personnel who don’t have email facilities can delegate it to tracking system custodian.

Secretary or custodian job:

  • To make sure that the HSE input from his/her department are entry or recorded in tracking system.
  • To monitor and control the close out action from his/her department.


HSE Terms

Incident
An undesired event that result in harm to people, damage to property or loss to process.

Near Miss
An undesired event which under slightly different circumstances could have resulted in harm to people, damage to property or loss to process.

Substandard
  • Action: Activities that can harm people if the activities procedure not getting improved.
  • Condition: A tools or workplace condition that can harm people if such condition not getting improved.

Inspection
Planned or unplanned departmental or personal inspection (safety patrol).

Safety talk
Departmental activities discussing a safety issue.

Suggestion
Personal suggestion about safety issue.

HSE Committee
A group of committee from every level of company organization hopefully to decrease information gap of safety issue.

Emergency drill
A simulation of emergency condition.

SA (safety audit)
Independent assessment of the safety management system to check its validity and reliability.

House keeping
Departmental housekeeping.

Hazard Operation
A physical situation with potential for injury to people, and or damage toproperty or the environment.

We’ve been accepting 6 proposal for our new weighbridge system so far. Two main qualification that the system can read our (old) weighing hardware correctly, and it has to be connected to SAP. This brand new weighbridge system will be:

  • Connected to SAP (customer, material, and transporter master data, pick Delivery Order directly).
  • To release truck, DO must pick directly from SAP. But its also can release truck in offline mode in case the SAP system is down. There is some flag that tell that the system is on offline mode. On offline mode, operator has authority to release truck. But there is validation routine once SAP connection establish.
  • Because SAP not allow user to access directly to SAP, the system must access via BAPI, and its follow as a normal transaction so that it follow normal transaction flow.
  • Approval mechanism in case the weight beyond tolerance, or validation routine after SAP system down. Tolerance configuration defined locally on the system, and it has to be easy to maintain.
  • Source code and manual, to tackle the need of system extension in the future.
  • User authorization: operator, administrator, manager (system approval).
  • Print ticket and update DO data in SAP telling that this DO has been carried out.
  • Weighing routine support for 2 types of material, finish good/non finish good.



My job is making technical evaluation of these vendor and propose rank of them. We can see their qualification based on proposal quality, system understanding on their presentation, and software demo. Source code, manual, and maintenance period is also one of big concern. And the price? We left it for procurement team and boss.


For those 6 proposal, 4 vendor do come and discuss what they have for our requirements.
  • Vendor A, the vendor which I get my SAP training. There is no doubt that this vendor is a SAP master. They also have good understanding on weighbridge business flow. But we have no data whether they can handle legacy weighbridge hardware (read the value of the weighbridge hardware). They do promise a demo on the second meeting.
  • Vendor B, sure an old player in weighbridge world, but not in SAP. Tight schedule of this weighbridge system make us force the vendor do a demo, showing that their software can connect to SAP and connect to weighbridge hardware. They do show us their program connect to weighbridge hardware. Its failed. One big loss for their rank, their system using third party component to connect to weighbridge hardware, and will be separate licence of the system. It does mean –eventhough we had the source code- we can’t extend the system since we don’t have the component.
  • Vendor C, good understanding in both weighbridge and SAP. Good software demo showing its integration with SAP. They miss first trial of demo connect to weighbridge hardware. But on later demo, they succeed reading value of the hardware. They give us VB.NET and VB6 demo, and both work.



  • Vendor D, thanks for their good effort. Old player of weighbridge system with lack of SAP experience. But they fail reading weighbridge hardware. They using many software to read com port traffic data, and even de-compiling our old weighbridge software to see how the software communicate with the hardware.


With that qualification, the sequence is (big point first) is: vendor C, vendor B, vendor A.


SAP Weighbridge Workflow

Weighbridge Software, Legacy

Posted by Aries Wandari



Weighbridge software is one of softwares IT responsible to maintain. Starting its duty on 96-an till now, with Windows 95 operating system using old PC with small harddisk space and without any network slot. We had try install it on Windows 2000, but the system become unstable. Meanwhile, the vendor stop supporting this legacy system. Its hard to maintain the software on those conditions. With current requirement that Weighbridge System must integrate with SAP, its time to replace the system.







Two weighing hardware connect to computer via com port 1 and 2, supporting 2 paralel weighing routine. Software can be configured whether it can only weighing in one direction (in or out only), or both.



Weighing routine flow chart


Monday, April 13, 2009

Interviewing New IT Candidate

Posted by Aries Wandari



Our IT department have few candidates to join to our company. Generally there are three selection steps for those candidates to be accepted. First are general and professional knowledge. At this step candidates will do a written exam, testing their general logic and intelligence, professional knowledge in IT matters, and English proficiency. The second test, which I am managed to be attended, is interview. Representative from IT department will have a discussion with candidates about his/her ‘real’ skill and personality. Hopefully this spoken test can get some point that didn’t grabbed at the first written step. The interviewer have a list of elements need to be scored for the candidate, there are: candidate appearance, self confidence, job relevancy, communication, intelligence, problem solving, initiative, ambition, tendency to stay, special condition, etc. Any candidate look superior to company requirements, he/she will soon meet the general manager, since employee recruitment need big boss approval. The last test is physical test. It has been a common secret the one that announced go to this step will be accepted as a new employee. Unless he has a serious illness that make him fail for the physical test of course.