SAP ABAP/4 Programmer/Analyst Doug Allard 2870 Pine Knoll Drive #300a Auburn Hills, Michigan 48326 cellular: (816) 255-9877 eMail: dougallard001@yahoo.com + Experience o Environments * Assembly Manufacturing * Process Manufacturing o Systems * 3.1h – 4.7(6.20) * 3.1h implementation * 4.0b to 4.6c upgrade * 3.1i to 4.7(620) upgrade o Modules * FI/CO, SD, MM, WM, PP, PS, PM, TR,QM, CRM o XI/PI (Exchange Infrastructure) * SLD configuration with technical & business systems * Software Component setup * 2 full implementations using File Adapter * User Defined Functions using JAVA * ccBPM using RFC calls to R/3 o ActiveX * Remote communication to R/3 using Visual Basic & Visual Basic for Applications * Remote communication to R/3 using Vbscript & DHTML o BADI’s * Implementation & modifications using SE18 & SE19 o BAPI’s * Creation of custom RFC’s to wrap BAPI calls * Direct calls to BAPI’s o IDOC’s * Outbound 850 * Inbound 810 with mapping * Creation of • RFC destinations • Partner Profiles with Process Codes • Port definitions • User exit modifications o SAPSCRIPTS and SMARTFORMS + Languages: 9 years - Visual Basic & VBA 10 years - ABAP/4 3 years - HTML/DHTML/CSS 2 years - VBScript 2 years - Delphi 1 year - JavaScript 6 months - XI/PI 6 months - VB.Net 8 years - IBM/390, CSP, REXX, DB2/ISQL <--<< Old School Stuff + History: TekSystems, 01/2008 to Present Senior ABAP Consultant: AM General, South Bend, Indiana o R/3 * MM - Purchase Requisition Report ALV showing the number of days between the creation of a purchase requisition, the number of days till release, and the number of days till creation of the subsequent item on a schedule line of a PO. Uses SAP business graphics function GRAPH_MATRIX_3D to display variances * MM - VL10BATCH Modification to user exit LV50R_VEWG15 & V50R_USEREXIT_TRANSF Restricts delivery creation to exclude line items within a specific product hierarchy when using a particular profile while running VL10BATCH * MM - Purchasing Forecast Report ALV displaying a cross reference of scheduled goods receipts, unpaid goods receipts and unpaid invoices with totals by date, vendor or document number for any given due date range * SD - Quotation pricing scales upload Import of Excel file that calls ME47 using a BDC session to update item pricing scales on Quotations * PP - Material Lead Time Analysis Report ALV showing a material's usage for a set of 5 sliding 12 month historical periods Also shows average usage, material on hand, material on order, safety stock & minimum stock level Months of Material Left is calculated and shown to alert user to forecasted future material requirements * PM - Functional Location Upload Import of Excel file Creation of functional location using function module 'BAPI_FUNCLOC_CREATE' * PM - Equipment Record Upload Import of Excel file Functional location validation by retrieval from table IFLOT New equipment validation by cross checking table EQKT Equipment record creation using function module 'BAPI_EQUI_CREATE' Addition of long text for equipment using function module 'SAVE_TEXT' * PM - Equipment BOM Upload Import of Excel file Equipment record existance check Duplicate component cross check BOM creation using function module 'CSAI_BOM_CREATE' BOM read using function module 'CSAI_BOM_READ' BOM component additions using function module 'CSAI_BOM_MAINTAIN o SAPSCRIPTS and SMARTFORMS: * MM - Purchase Order Installation and implementation of /SMB40/MMPO_A * SD - Certificate of Compliance Installation and implementation of /SMB40/SDDLN_A * PM - PM Work Order SAPSCRIPT copy & modification of PM_COMMON Control program copy & modification of RIPRJT01 Customizing setup for Work Order output type + History: TekSystems, 05/2006 to 01/2008 Senior ABAP Consultant: Chrysler Corporation, Auburn Hills, Michigan o Exchange Infrastruture (XI/PI): * Sales Orders (Miscellaneous) ccBPM: Complete Order to Cash implementation Inbound file adapter with scheduled pickup by XI User Defined Functions to split inbound file into multiple sets of sales orders Multiple simultaneous calls to custom RFC wrapper to process each set through BAPI_SALESORDER_CREATEFROMDAT2 Continued processing using RV_INVOICE_CREATE for billing invoices and corresponding FI postings Export of complete document set created and all relevant BAPI messages by RFC wrapper to audit log file Pickup & scan of audit log with R/3 email send on errors * Purchase Orders (SIRIUS Satallite Radio) ccBPM: Complete Purchase to Pay implementation XI mappings & substitutions from inbound file to PO BAPI structures Calls RFC wrapper for BAPI_PO_CREATE1 Continued processing using BAPI_INCOMINGINVOICE_CREATE for logistics invoice Export of complete document set created to audit log file Export of all returned BAPI messages to audit log file Pickup & scan of audit log with R/3 email send on errors o SAP R/3 * BADI - IF_EX_CTS_REQUEST_CHECK - BADI implementation of CTS_REQUEST_CHECK definition Does scan of transport table during transport creation to find & display Prerequiste transports not in Production for any workbench object * ALV - FI Intercompany balancing report ALV to display current days charges against an account(s) Color coding in ALV used to differentiate positve & negative postings Subtotals are displayed by material, company code and G/L account User drills into subtotal to execute call to FB01 which picks up various posting values using an account assignment model Corresponding amount offsetting the subtotals from ALV are then posted * EXIT_SAPLV61A_001(ZXFYTU01) - Vertex user exit Swaps pricing date from orders or debit/credit memos into tax date for back dating documents during Vertex call * EXIT_SAPLV60B_008(ZXVVFU08) - FI postings Addition of offsetting vendor posting during Order to Cash for intercompany transactions Also fills various fields based on document type, Posting key G/L account etc. * EXIT_SAPMM06E_017(ZXM06U42) - Purchase Orders Force override of defaulting statistical date on schedule lines with values from BAPI during purchase order creation * SAPMV60A(RV60B613) - Billing invoice Swap payer into partner table during invoice creation + History: Capgemini, 08/2003 - 05/2006 SAP 4.7 Upgrade team; Senior Member - Kansas City, Missouri o WebAS Business Server Pages * Complete HTML Product Catalog w/Sales Order posting to R/3 - Creation of custom table type definitions for use on WAS Implementation of link between WAS and backend R/3 system Web design of customer's product catalog Material data retrieval using BAPI_MATERIAL_GET_ALL Web design of customer's on-line ordering system Sales Order creation using BAPI_SALESORDER_CREATEFROM_DAT2 * Sales Order Listing by Customer/Period - Custom table type definitions Retrieval from SAP/R3 sales tables onto BSP ABAP/4 and DHTML for page display o EDI * Inbound Sales Orders - Upgrade to 4.7 Correction in EXIT_SAPLVEDA_002 to set document status to EDI blocked Correction in EXIT_SAPLVEDA_002 to read earliest schedule line date from E2EDP03 and promote to requested delivery date at header o ALE * Inter-company Billing Documents - Modification of process codes to 4.7 Modification of partners and logical destinations Creation of RFC destinations for logical systems User Exit ZXEDFU01 to reassign outbound/inbound partners User Exit LZICCF01 modification of intercompany G/L posting User Exit ZUSD9974 modification for invoice processing log update User Exit ZUSD9974 modification for IDOC status update o Interfaces/Customizations: * SAS70 SAP User Identity Verification - Visual Basic application linking to all systems in user's saplogon.ini For User Id searches on multiple systems by User Id or First/Last name Allows use of wildcards in names and Id during search. Tested and deployed on Windows 2000 and Windows XP. * VB Interface to extract & compare 3.1I & 4.7 objects - Retrieved & compared the following + Program Source with include expansion + Function Modules + Screen Source & Text + CUA definitions * CRM Modification to custom business partner upload program to correctly create relationships between contacts and organizational partners * Outbound Check creation - Copy and modification of RFFOUS_C to create outbound text images of checks for input into external check printing application at bank * Inbound Cashed Check posting - Copy and modifcation of RFEBCK00 to load inbound cashed checks file from bank and trigger posting and check encashment events in TR module * Gui version check at logon - User exit to download sapver.exe from application server and execute on workstations at user logon to determine workstation's gui version and save listing of all workstation results back onto server * MV50AFZ1 & SDREPA01 - User Exit to auto-create service notifications with task lists during returns of repair order items * MV45AFZB - User Exit to popup standard text and insert standard text into orders' header text during VA01 o Reports: * Purchase Price Variance Report - Copy & modification of FBL3N to provide additional fields for purchasing side of report call to ALV * Project Turn Time report Z_CN41 - copy & provided specific customer enhancements to CN41 (PS) Additional fields added to fieldcatalog & data table for ALV Calculation of turn-time and total number of projects Addition of further ALV tree elemtns for report & display * Production Yield Report - ALV list showing total quantity, scrap & yield% Based on work center/material/order number With removal of cancelled inspection lots from totals * User Profile Report - ALV grid showing UserId & assigned profile groups Drilldown into SUIM on userid or assigned profile name Dynamic ALV fieldcatalog * Journal Entry Error Report - ALV to display manual journal entries missing key fields Shows erred entries, reversals and corrected entries linked to original erred entries, color coded for debit/credit * BDC Update to TVARVC - Rewrite of update to selection screen variables to change from TVARV to TVARVC for 4.7 standards * Vendor Payment Report - ALV to display vendor payments by company code and account BDC to Update TVARVC - Rewrite of update to selection screen variables to change from TVARV to TVARVC for 4.7 standards o SAPScripts and SmartForms * Billing Invoices (US/DE/DK/FR) - * PM Work Order/Job Tickets(DK) - * Purchase Order/Sevice Agreement modifications(US) - * Dunning Notices (US) - * kanban JIT summary sheet (US) - * Shipping labels using Zebra Printer (US) - + History: Robert Half Technologies, 06/2002 - 12/2002 Consultant, Heidelberg Web Systems - Dover, New Hampshire o EDI Inbound: * Logistics Invoices - Defined translation from ANSI 810 to inbound logistics invoice for middleware vendor Creted front end application to read valid IDOC'S and trigger posting application Integrated status notification into external MAPI compliant email system Created and administered required partner profiles. Created and administered EDI port definitions. o EDI Outbound: * Purchase Orders - Created and administered required partner profiles Created and administered required EDI ports Created output determination and configuration to trigger export of purchase order IDOCS o Reports: * MRBR - Copied transaction MRBR to ZMRBR and added Modifications for additional columns and calculated fields * Empty Bin Listing - Rewrite of RLS10010 to add required columns * Stock Transfer - Rewrite of RLS10034 to allow for transfer of partial bin amounts between storage locations o Interfaces/Customizations: * Bank Reconciliation - Custom RFC to export checks from PAYR table for SAP side of external Bank Recon * RSINFDAT - Mass Update to Material Master to change MARC-LGPRO in 250,000 records * Customization - Changed/Added MRP Controllers in SPRO o Dialogs and User Exits * RV50B901 - Modification to ATP check to include various order types * MV50AFZ1 - Created code to lock modifications to outbound deliveries when being processed by external warehouse management system with notification popup to users in VL02 * EXIT_SAPLMEREQ_007 - User exit to write production order information to purchase requisitions for historical orders * EXIT_SAPLCOZF_001 - User exit to write production order information to purchase requisitions during production order creation o SAPScripts and SmartForms Corrections, additional text elements, text element translation modifications and external program calls added to some or all of the the following documents * Customer Statements (US) - * Order Confirmations (US) - * Credit Notes (US/NL/DE) - * Commercial Invoices (US) - * Service and Parts Invoices (US/NL/DE) - * Proforma Invoices (US/NL/DE) - * Purchase Orders (US) - * Shop Floor Papers - * Quotations - * Packing List - (US/NL) * Goods receipts - + History: Fleming Companies Inc., 03/2000 - 01/2002 o Employed as Chief Programmer o Reports/Interfaces: * A/R Customer Aging Report - Rewrite to disconnect from logical database and optimize performance Restructured ledger entry retrievals for open items * Special Ledger Report - Rewrite to optimize performance at monthtly roll up. * LockBox preprocessor- JES/2 to transmit data from Mainframe to Unix Unix script to trigger S.A.P. event ABAP/4 to retrieve Unix file and parse into proper fields for call to RFBBL010 ABAP/4 Submission of S.A.P. Lockbox with Job monitor coding and email notification of completion status * OLE2 Link to external email (groupwise) - Use of object creation and use in ABAP/4 Created as a work around for not having mail connector * Security application - ABAP/4 to auto create S.A.P. support Id's with default privileges and then link to external email to send notification to support personnel of Id. * Journal Ledger posting Upload from Excel - A distributed copy of an Excel file with embedded Visual Basic code to create SAP logon and call to transaction F-02. BDC data is sent from entries of Excel file and S.A.P. messages are returned to Excel. SM35 session is created for manual error correction. * Special Ledger posting Upload from Excel - Very similar to above however transaction name is GB01 and errors are corrected in the Excel file not in SM35 and retransmitted * RFQ Export to Excel - During RFQ create or print a custom pop up executes to query the user for export. Data is loaded into internal tables and passed to a custom function call containing download coding. N.T. filename controls are included in function call to prevent inadvertent file overwrites * Spool Request extraction to Internet Explorer - VBScript embedded on client page logs onto S.A.P. and retrieves S.A.P. spool numbers for a user or range. Spool numbers are dynamically placed onto client page as buttons and when user clicks a spool number a call back to S.A.P. is executed to retrieve the spool item and display onto new client page o Dialogs and User Exits * SAPLMGD1 - Material Master (MM01, MM02, MM03) Created additional Material Master domains and data elements Extended Material Master Tables with appends Copied SAPMLGD1 for modification and added screen tabs and PBO/PAI processing for the new fields Modified screen sequences for Material Master in IMG to process new screen tabs * SAPMV45A - Sales Order Entry (VA01, VA02, VA03) Created additional domains and data elements Appended elements to Order Entry Tables Added elements to existing screen tabs Added PBO/PAI processing for the new fields * SAPMV50A - Outbound Delivery (VL01N, VL02N, VL03N) Added elements to existing screen tabs Added PBO/PAI processing for the new fields * SAPMV60A - Billing Documents (VF01, VF02, VF03) Added elements to existing screen tabs Added PBO/PAI processing for the new fields * EXIT_SAPLFYTX_USER_001 - Tax Calculation call to Vertex Added coding to correct field extraction rounding errors * EXIT_RFEBBU10_001 - Electronic Bank Statement Added account determinations for incoming cash payments o SAPScripts * Purchase Orders - Correction of addressing and company code display * Checks - Creation of SAPScript variables to hold federal and state sales tax amounts Call to ABAP/4 utility from SAPScript to calculate and return invoice line item state or federal sales tax amounts * Check Remittance Advice - Same as checks above to complete the set of documents required for check printing + History: Millennium Specialty Chemicals, 06/1992 - 03/2000 o Programmer Analyst using IBM/390 with CSP/REXX 7 years o Legacy extraction/scrub of Material Master for load to S.A.P. o Lead S.A.P. programmer after implementation o Reports: * Profitability Report - ABAP/4 Rewrite for program optimization with booked v.s. billed comparison * Agent Commissions Due Report - ABAP/4 Creation of percentages due to Agents based on percentages of sales invoices paid by customers * Purchase Requisition report - ABAP/4 creation of Purchase Requisitions v.s. Purchase Orders completed by employees report o Interfaces: * Full Setup/Implementation of S.A.P. Gateway in N.T. SM59 remote destination setup in S.A.P. Installation of S.A.P. Gateway programs onto N.T. server * Check Reconciliation in Visual Basic - Creation of S.A.P. Logon and RFC objects in Visual Basic Creation of current and history tables for data storage in Access Retrieval of S.A.P. written check information using V.B. Automatic dialup, logon and retrieval of Bank cleared check information using Visual Basic Autobalance of both sets of data with movement to history tables V.B. form for user to correct variances between S.A.P. data and Bank Data also with movement to history Check Reconciliation report listing in V.B. printable to any available network printer * Customer Invoice export to MS Word - Creation of S.A.P. sales invoice data retrieval in custom ABAP/4 application Call to V.B. from ABAP/4 for transmission of invoices to N.T. network. Identical invoice template in M.S. Word mirroring S.A.P. Sales Invoice Layout. V.B. for Applications programming embedded in Word invoice template to load fields from S.A.P. data file. * Available to Promise export to MS Access - ABAP/4 application to correctly extract inventories with corrections for returns and plant transfers. Data is exported to text file and a call to network is executed to load file into Access * Foreign Sales Commissions export to MS Access - Sales data by region exported to Access merged with external sales history using Visual Basic with report in V.B. * Recipe export to MS Access - Recipes with superior activities data is extracted using ABAP/4 then is passed to Access o SAPScripts: * Company wide redesign effort on all SAPScripts including Certificates Of Analysis Purchase Orders Bills of Materials * Customer Invoices Addition of SAPScript variables to hold totals Call from SAPScript to ABAP/4 utility to calculate and return totals + Education: 4 Years United States Navy B.S.C.I.S. University of North Florida 1991