Use the following function modules to help build your dynamic where clauses for your select statements....
- DYNSQL_GENERATE_WHERE_CLAUSE
- CONVERT_SELECT_INTO_WHERE
- FREE_SELECTIONS_RANGE_2_WHERE
- ADSPC_CREATE_WHERE_CLAUSE
- SAP Technical
- Utilities
- Revelation Software Concepts Releases Salt Apps for SAP®
- Displaying old Output using NAST and SOST
- ABAP retrieve statistical data from the STAT file
- ABAP Function Module for Calculator
- Using the SQVI transaction
- TIP: Create EMail addresses for all users automatically
- Transport Manager
- Using LSMW
- Convert to .PDF file
- Additional Printer Information
- Make User PW Same in All Clients
- Reset User's Password History
- Keep Printer Status 'Alive'
- OneAccess-UserManager for SAP
- Function modules: Amount and Currency
- Virtualization in SAP environments for stronger outsourcing
- Scripting in a Box v0.0.5
- Step-by-Step Guide for using LSMW
- What is SAP Adobe forms??
- Finding objects in transports
- Transferring data using IBIP
- Working with eCATT
- 3rd Party Utilities
- ALE Utilities
- EDI Utilities
- Basis Utilities
- ZUSRMON - User Monitor Utility
- Symmetry - Change Management Solution
- ABAP Utilities
- List of SAP related utilities
- Barcoding
- InfoShuttle (Gamma Enterprise Technologies, Inc.)
- Rev-Trac by Revelation Software Concepts
- EzySolutions for SAP (Gesix)
- TxShuttle (Winshuttle)
- Legacy System Migration Workbench (LSMW)
- CATT (Computer Aided Test Tool)
- BAdI Examples
- ABAP
- Dynamic where clauses for selects
- Displaying BAPI messages
- System Field SY-DATAR
- Speed up a program by pausing all the other work processes
- Subtract the comment lines from an ABAP source for documentation purposes
- Transaction variant
- SAP Transaction Tables
- User / Customer exits and VOFM routines
- Generic Object Services (GOS) Toolbar - Handle added Service in the Toolbar
- Generic Object Services (GOS) Toolbar - Add New Option in the Toolbar
- Generic Object Services (GOS) Toolbar - Add toolbar in Custom Program
- ABAP Game Tic-Tac-Toe
- Function Module to Reverse a String
- Checking the Validity of a Date
- ABAP Function Module for Displaying Clock
- Add months to a date
- Passing Data From One ABAP Program to Another
- Using sets instead of TVARV
- Calling a method to browse for a filename
- ABAP Runtime Errors - Dump analysis
- Processing Blocks in ABAP
- ABAP Function Module for Displaying Clock
- SAP ABAP Copy to ClipBoard Function Module
- SAP ABAP CALL TRANSACTION from a remote system
- Calling a BDC in parallel using update task
- My SDN list of ABAP tips and tricks
- ABAP Modularization & Catch Statement
- List Processing in ABAP
- Introduction to ABAP
- ABAP Open SQL & Internal Table
- ABAP Advanced List
- ABAP Message, Debugging, File Transfer and Type Group
- Abap Dialog Programming Overview
- Beautify your ABAP source Code
- TIP: Editing any table in SAP using SE16N
- ABAP Event Driven Programming
- IMPORT and EXPORT in Methods
- Updating custom fields on VBAP and VBAK using a BAPI call
- List of User Exits in SAP R/3 Enterprise 4.7
- How to create a cluster view for complex customizing table maintenance
- BAPI_SALESORDER_CREATEFROMDAT2 termination due to DATA_OFFSET_LENGTH_TOO_LARGE
- Alternative to FM FORMAT_MESSAGE or T100
- Different methods of converting dates in ABAP
- TIP: Display table buffer
- Submitting selection in report
- Writing out a message structure
- Select-options in a module pool screen
- Logs and Traces - transactions
- Creating a dynamic internal table
- How to find BAdIs
- Maths in ABAP
- Beneath Abstraction!
- BAPI_SALESORDER_CREATEFROMDAT2 - Sales Order Create
- Implement enhancment SQUE0001, user-exit EXIT_RSAQEXCE_001.
- OO ABAP Dynpro Programming
- Software Development Lifecycle: V-Model & Use of V-Model in ABAP Developments
- Create Equipment using 'BAPI_EQUI_CREATE'
- Finding out where data is stored in SAP tables
- Downloading attachments of services for objects
- An Example of a ListBox Program
- Sample ABAP Code Review Walk Through
- Example index tables
- Internal Tables Described
- Report writing notes / tips
- ABAP Performance "Do's and Don'ts"
- SQL Performance "Do's and Don'ts"
- ABAP Memory & SAP Memory
- Creating a transaction to reference your table maintenance code
- Getting Spool Request Number for the Output type
- What are logical databases? What are the advantages/ disadvantages of logical databases?
- Explaining several ABAP commands
- Important BDC repoorts
- ABAP T-codes
- ABAP BDC Interview Questions
- Field groups, field symbols and type pools described
- TIP: ABAP Coding Guidelines
- SAP System fields
- Dialog Programming explained
- Create a link between Classic BAdI and Enhancement spot
- ABAP Memory & SAP Memory
- What is Extract dataset?
- Handling SAP Performance issues in General
- ALE EDI IDoc function modules
- GUI FMs
- Pop-up screen function modules
- User FMs
- Units of measure (UOM) function modules
- XML function modules
- Address function modules
- Currency function modules
- Text function modules
- Mail and Office Function Modules
- Date-Time FMs
- Customized Function to get Long Date
- Add Dynamic Buttons to Selection Screen
- Send Email but with a attachment
- Password Field on Selection-screen
- Sample Codes for SAP Graphs & Graphics
- Need to search variants for a report
- Customized Spell Amount Function
- Display the total number of pages in report
- Displaying a box with a title
- SAPGUI Progress Indicator Function Module
- Upload an Excel File to Internal Table
- Submit a Background Job Dynamically
- Running a report that creates another program and runs it
- Transporting a variant
- Nice include with string handling macros
- Std. Include with some good macros
- Triggering events in SAP
- Batch Input and Call Transaction
- Reading multiple selected lines in a list
- Enhancement spots in ECC 6.0
- Change documents and change pointers
- Language Dependent Formatting of Amount and Currency
- ALV Grid Control
- Customizing Objects Using Address Functionality
- ALV Grid Using Function Modules
- GUI-Status - Default codes for standard buttons
- Format the font for one or more words on a line
- Call F4 help from selection-screen
- Field symbols
- Dynamically read fields, field names and field contents using field symbols
- Calling F4 help for date
- Dynamic program generation
- Tools for Troubleshooting ABAP Programs
- Using FTP from ABAP
- Working with logs
- Output and Spool function modules
- Using Directories in ABAP
- How to start a transaction in a new session
- Find User Exit for Transaction Code
- Business Transaction Events (BTE)
- BAdI
- Rev-Trac - change request and transport management
- Debug SE16 to allow record changes
- ABAP Memory
- SAP Memory
- Internal Tables described
- ALV Grid Control Example
- Performance Tuning
- SAP Tree Control vs. SAP Tree Model
- Function modules to construct tree reports
- How to Create a Tree Control
- Convert currency value from SAP to display
- Copy password to other clients
- Performance Tuning In Programming ABAP
- ABAP Questions
- CL_GUI_ALV_GRID documentation
- BAPI Sample To Upload Data From Flat File To VA01
- Multiple ALV list display
- Developing ABAP Applications Using Web Dynpro
- Transport return codes
- Adding a custom User Parameter
- Parallel Processing with Asynchronous RFC
- Password Field on Selection-screen
- Report to remove Editor Lock
- Handling changes to multiple ALV grids
- SAP ABAP Certification
- SQ01 - SQVI Graphical Join issue
- How do you link an RFC to a logical system
- Purpose of ok_code in Dialog Program
- BAPI List for ECC, CRM and SCM
- Resubmitting a BDC session in the background
- Useful programs
- Search for sales doc by Partner function
- How to upload an XML document?
- Check ALV grid for changes
- Find the SAP menu path for a transaction
- Business Object Repository (BOR)
- ABAP Tables
- New error exception concept
- Discussing Unicode
- Enhancement points
- Fieldinfo and values for download for a DB table
- Percentage Complete progress indicator
- Switching Runtime Analysis on in code
- ALV GRID TRANSPOSED
- The new error exception concept
- Frequently accessed tables in PS
- SAP RFC
- ABAP CBT Training Materials
- Sample ABAP interview questions
- Hiding Select options on a selection screen
- Adding fields to standard Infotype
- Debug SE16 to allow record changes
- Changing Data Element documentation (F1 help text)
- Record Count progress indicator
- Changing Data Element field text
- Percentage Complete progress indicator
- Calling a transaction on another system
- ABAP code to display SAP icons
- Send SAP mail to specific users workplace inbox
- Automatic Refresh Report - periodically refreshes
- Building the text for a return message
- Updating Item 10 of PO using BDC
- Trying to find a SMOD/CMOD enhancement?
- The new error exception concept
- Transfer Table Along With Its Contents
- Working with Extracts
- ABAP Control Framework
- Passing data using SAP memory
- Hide technique in reports
- ENQUE_SLEEP function
- SAP ABAP Report,Program Example Code for Connect 4
- A sample program using the BDC_INSERT functions
- ABAP READ_TEXT functions to read the SAP Long Text
- SE30 - Runtime Analysis Tool
- ABAP Development Skills to SAP NetWeaver 7.0
- Create a Directory in the user local hardisk
- ABAP Program to Extract the Units of Measure
- A comparison between enhancement techniques
- Field exits
- BAdI vs. User Exit
- BAdI Import Procedure
- Calling a Business Add-In in your Program
- What are hash tables?
- Pool and transparent table...
- Front-end tool for SE38
- About ABAP Objects
- Purchase Order History Mass Display
- ABAP OBJECTS -- Sample Project
- Finding the user-exits of a SAP transaction code
- Creating a subscreen in your ABAP Program
- Batch Input with 'Call Transaction'
- SQL Examples
- Interactive Reporting
- A program to load a database table from a UNIX file
- Creating Extract Dataset
- Reading database tables - logical database
- Useful standard reports
- Introduction to SAP SmartForms
- SHDB - Record a transaction
- Transporting Objects and Standard Text
- SQL Trace
- SE30 - Runtime Analysis Tool
- ABAP Syntax performance tuning
- Good Function Modules
- SYSTEM fields
- Developer Transactions
- Interactive reporting Q and A
- ABAP Reporting questions and answers
- Formatting in ABAP Reports
- Field list of an Internal Table
- BDC FAQ
- What does ABAP stand for?
- How To use 'REUSE_ALV_GRID_DISPLAY'
- Batch Input Program for Transaction VA01
- SAP R/3 Enhancements
- Most used SAP extensions and their components
- Pretty Printer
- Creating Update Function Modules-BDC
- Eg. of Sending XLS file as a mail via SAPCONNECT
- Business Add-Ins: Import Procedure
- Calling a Business Add-In in your Program
- Defining a BAdI
- A Comparison of Different Enhancement Techniques
- BAdI - Business Add-Ins
- Table Maintenance Generator
- ABAP Interview Questions
- Object oriented programming (OOP)
- Creating F1 help
- Modularization in ABAP
- Toolbar Control Object
- How to use ABAP Control Objects
- Picture Control
- HTML Viewer Control
- Programming a BAPI
- BAPI Step by Step Example
- BAPI Conventions
- Download programs / function modules
- How to create Change documents
- ABAP OO Syntax
- ABAP OO Example - Employee
- ABAP OO Example
- Replacing a CR in a string
- TIP:Bypassing the system timeout value
- ABAP Function Modules
- ABAP Whitepapers
- System Tables
- PM Tables
- Production Planning (PP) Tables
- Purchasing Tables
- PS / PP Tables
- MM Tables
- SAP Transactions
- FI Tables
- SD Tables and their relationships
- ABAP OO Definitions
- Field exits
- Preventing duplicate jobs
- Drill Down Reports
- ERPGenie ABAP Tips and Tricks Database
- NetWeaver
- Generate ABAP Webservice Proxy from RFC Function
- Call URL from SAP ABAP Web dynpro ACTION
- Virtualization in SAP environments for stronger outsourcing
- About the Alert Framework
- SAP-Business Objects Skills Transitions
- mySAP Netweaver Certification
- Displaying data with ABAP WebDynpro table
- WebDynpro to display 'Hello world'
- Adding a IMAGE to Web Dynpro view
- Display popup screen within ABAP Web dynpro
- Integration Scenarios - Interface Reference Table
- The Home of SAP NetWeaver
- Process Integration
- People Integration
- Life Cycle Management (LCM)
- Information Integration
- Application Framework (AF)
- Composite Application Framework (CAF)
- XI Tips
- SAP XI How To Documents
- Integrate the UWL to ccBPM via BW
- XI SAP Notes
- SAP Exchange Infrastructure (XI)
- XI Links
- SAP xApps
- WAS CBT Training CDs
- Web Application Server (WAS)
- Mobile Infrastructure (MI)
- Master Data Management (MDM)
- NetWeaver Magazines
- NetWeaver for Dummies
- NetWeaver Whitepapers
- Portal
- XI
- Testing an Inbound Proxy if the test interface is unavailable
- The Essentials on SAP NetWeaver Process Integration - A SAP Mentor 2010 Series
- What is UML?
- Procedure to generate an ABAP Proxy
- Tips for generating ABAP Proxies
- Where can I find the Idoc structure in XI?
- File-to-File scenario using J2SE Engine
- XI/PI: Consuming XI Web Services using Web Dynpro – Part II
- XI/PI: Consuming XI Web Services using Web Dynpro – Part I
- PI 7.1: XML Validation in Integration Engine
- XI/PI: SAP XI Troubleshooting Guide
- XI/PI: Introduction to Context Handling in Message Mapping
- XI/PI - 1:n Multi-Mapping using BPM
- SDN "PI 7.0 & 7.1 Mapping - Blogs,Articles,Wiki,Code Samples and Videos Collections"
- How to enable SSO for XI
- XI Alerts
- Restarting failed messages in XI
- Consuming web services from ECC
- What is an XI IDoc Adapter?
- Enabling SSO in XI
- Can XI publish to Topics?
- XI eLearning material on SDN
- Benefits of XI
- XI RFC-to-Web Service Scenario
- Defining your roadmap to Enterprise SOA
- XI File Adapter Not working
- ESOA Described
- Checking if your ABAP proxy is configured right
- Process Integration Content Delivered by SAP
- SLD Documentation
- XI Links
- SLDCHECK failing in ABAP
- SAP Exchange Infrastructure (XI)
- XI SAP Notes
- Integrate the UWL to ccBPM via BW
- SAP XI How To Documents
- XI Tips
- Java
- WAS / ITS
- Developing Web Transactions in ITS - Part IV
- Developing Web Transactions in ITS - Part III
- Developing Web Transactions in ITS - Part II
- Developing Web Transactions in ITS - Part I
- BSP Tips and Tricks
- BSP Concepts
- BSP Exception - FQDN
- Creating a BSP using the Model View Controller Tut3
- Building a simple BSP Application
- Creating a BSP using the Model View Controller Tut2
- SAP R-3 SAP@Studio Described
- ITS User Maintenance
- Creating a BSP using the Model View Controller Tut1
- Debugging an Internal ITS (WAS 6.40 systems)
- Internet Application Components (IACs)
- ITS Related Development
- Sales Order Web Status IAC Example
- Developing a new ITS IAC
- Options for accessing SAP using the ITS
- Web Application Server (WAS)
- WAS CBT Training CDs
- ITS Web Reporting
- ITS WEBRFC
- SAP GUI for HTML
- ITS internet application component (IAC) Configuration
- ITS Flow Logic
- Example Business HTML (bHTML)
- Business HTML
- ITS Benefits
- ITS Described
- ITS Security
- xApps
- Interfaces
- Working with files on SAP
- SAP Integration Experts
- SAP and VBA (Visual Basic for Applications)
- Setup of SCOT Internet Mail Connector
- Configuring SAP 4.6x Internet mail Gateway
- SAP Business Connector
- EDIGenie.COM
- Table ARFCRSTATE
- Queue Status in SMQ1
- tRFC & qRFC queue in Transaction Recorded status
- Reseting SMQ1 queue - WAITUPDA
- ASP.NET Eg: Creating a Purchase Order via BAPI
- Transferring data from SAP to .NET
- Integration & Certification - Scenarios
- SAP RFC PERL Connection
- SAP WAS - Web Application Platform
- SAPphone
- SAPconnect
- .NET Connector
- Duet (Formerly The Mendocino Project)
- RFC IDoc Tip
- Communications Interfaces
- Exchange Connector
- Java Connector
- DCOM Connector
- Communication interfaces
- Business Connector
- RF
- ALE / EDI / B2B
- Displaying an IDoc Using an XSL Stylesheet
- Update IDoc status in mass
- SAP R/3 IDoc Cookbook for EDI and Interfaces by Axel Angeli
- Articles on EDI by Kevin Benedict
- SAP EDI Process Overview
- SAP EDI Idoc inbound process codes and their functions
- IDoc Tips - Change Pointers and Reprocessing IDocs
- Sending Inbound IDocs from a SAP Program
- Beginner’s Guide to ALE and IDocs - Part III
- Beginner’s Guide to ALE and IDocs - Part II
- Beginner’s Guide to ALE and IDocs - a step-by-step approach
- Gentran DDF Creation Utility
- Inbound IDOC Status Report for Sales Orders
- IDoc programming overview
- Outbound EDI
- Inbound EDI Configuration Guide
- About IDocs
- Changing IDoc statuses
- Distributing Master Data using SAP standard transactions
- Activating and Deactivating standard EDI workflow notifications
- Changing the EDI administrator
- Change pointers for a custom message type
- How to create a function module for an IDOC
- ALE Documentation
- ALE Interfacing Tutiorial
- IDocs, EDI and ALE
- What is the different between ALE, IDOC and BAPI?
- 850 EDI Mapping Template for CRM
- EDIGenie.COM
- SAP Facilitates Business Network Transformation to Help Businesses Compete and Thrive in a Changing Global Economy
- AFS Message, Idoc Types and segments
- What is an SAP IDoc?
- Common EDI Transactions
- AFS IDoc Process Codes
- EDI Tips
- AFS ALE Distribution of Requirements
- Understanding the components of SAP IDocs
- SAP EDI Variant Config Considerations
- FREE EDI online Exam available on ERPGenie
- SAP EDI Outbound Setup Procedure
- Inbound Setup Procedure
- IDOC INTRODUCTION & STRUCTURE
- EDI Translators described
- What is ALE?
- IDoc Inbound Reports Described
- Application Link Enabling (ALE)
- Why ALE?
- ALE Whitepaper (Kevin Wilson)
- ALE Performance Hits
- How does ALE work?
- ALE Configuration Detail
- ALE / EDI SAP Training Course
- ALE Message Handling
- ALE Converters
- An ALE Implementation Methodology
- ALE Implementation Methodology - Strategy
- ALE Implementation Methodology - Design
- ALE Implementation Methodology - Configuration
- ALE Implementation Methodology - Development
- ALE Implementation Methodology - Operations
- EDI Whitepapers
- ALE Whitepapers
- What is EDI? an EDI Definition
- SAP startrfc
- Standard Carrier Alpha Codes (SCAC)
- EDI Scheduling Agreement Tips
- EDI Mapping
- Transaction IDOC (4.6x onwards)
- Changing an IDoc Status
- IDoc Statuses
- IDoc interface
- Master Data Message Types / IDoc Types
- Logistics Message Types / IDoc Types
- HR Message Types / IDoc Types
- Accounting Message Types / IDoc Types
- Programming with IDocs in ABAP
- History of EDI
- EDI Glossary
- Other EDI related Links
- Links to EDI Specifications
- SAP R-3 EDI Subsystems
- SAP EDI Training
- SAP R-3 XML
- An EDI Implementation Methodology
- EDI Operations Phase
- EDI Development Phase
- EDI Configuration Phase
- EDI Design Stage
- Benefits of EDI
- EDI Authorizations
- EDI X12 Transaction Set Index - Detail
- X12 Transaction Set Index
- EDI Standards
- Mapping x12 to SAP
- SAP IDoc -> ANSI X12 Mapping Templates
- Sample ANSI X12
- EDI Transactions
- Message Control Configuration
- Inbound INVOIC posting configuration
- Generate IDOCs from a report
- Workflow
- Performance of SBWP (Available BAdI's)
- Workitem stuck in READY status but the workflow is COMPLETE
- When to use PI, BPM and Business (ABAP) Workflow
- Maintaining a workflow substitute for someone else
- What tables store the workflow rule's responsibilities and values?
- ASUG Workflow survey
- How to create a Business Object Event container
- Seeing the contents of the BO Event Container
- SAP and ABAP Memory described
- How to call a workflow from a background program
- TIP:What are important OSS Notes for WF?
- TIP:Which SAP courses are relevant for Workflow?
- TIP:Are Secondary Methods possible in the UWL?
- TIP:A user has to return to the UWL for each step. How can they be executed together like in the SAPGUI?
- TIP:What are the limitations of the UWL?
- TIP:What are deadlines - and why are there four of them?
- TIP:How can I control substitution programatically?
- TIP:Is there a list of SDN articles about workflow techniques available?
- TIP:How to find the correct evaluation path, create your own, or how to display reports regarding relations?
- TIP:I developed my workflows locally but want to transport them, how do I achieve this?
- TIP:Why should I not assign org units to steps in the workflow builder?
- TIP:How can I use ABAP OO Classes in Workflow?
- TIP:Why is the number/date formatting different in emails sent from workflow?
- TIP:Why does my background task remain in status STARTED/'In Process'?
- TIP:How can I maintain a rule with responsibilities in production?
- TIP:How can I execute another user's work item?
- TIP:How can I forward another user's work item?
- TIP: Why is my mail not sent?
- TIP: How do I delete workflows?
- TIP: A runaway workitem has gone to all users
- TIP: Temporarily disabling a workflow in production?
- TIP: 'No Administrator found'
- TIP: I have updated the agent assignment, but the agents still don't receive the work items
- Differences between Workflow and SAP EM
- TIP: Workflow trace file reorg
- How to use a filter in a distribution model
- Workflow Configuration Steps for Cutover
- Workflow tRFC and performance
- Make a workflow substitution for someone else (PROGRAM)
- What is Workflow / WebFlow ?
- Workflow substitution tables
- Workflow Inbox Performance Issues
- Setting up workflow to load balance on multiple app servers
- Mobile Workplace - British American Tobacco Case Study
- Working with SAP Workflow Extended Notifications?
- Error when initializing workflow environment
- Diagnosing Workflow Problems
- Upgrade considerations for workflow
- Workflow CBT Training Materials
- Performance and Workflow - Part 5
- Ad Hoc agent assignment in Workflow
- SAP
- Performance and Workflow - Part 4
- Performance and Workflow - Part 3
- Workflow Books
- Describing workflow
- Performance and Workflow - Part 2
- Automatic notification of workflow items
- Performance and Workflow - Part 1
- Display workflow log for an IDoc
- Debuging a background workflow process?
- Workflow Interview Questions
- Transporting workflow defns & agent assignments?
- PFAC for role responsibility...not working!
- How do I send text as an e-mail from workflow?
- Differences between work item & email?
- How are workflows triggered?
- What are the strengths of SAP WebFlow?
- How do I calculate the cost saved by workflow?
- How do I convince my company to use workflow?
- Examples of Workflow
- Workflow Workshop
- How to configure an SAP-provided Workflow
- Rules and Roles
- Creating link between purch. grp & person
- Useful Online Service Workflow Notes (OSS)
- Documentation issues
- Ensuring that your workflow is robust
- When to use asynchronous tasks
- Sending e-mails from the workflow
- Troubleshooting workflow not starting
- Manually assign an agent to a workflow step
- Returning worklfows attached to a business object
- Passive vs. Active Substitutions
- Sending a mail on triggering a particular event
- Cool Workflow Function Modules
- Creating workflow start transactions
- Seeing SAP EMails in the UWL
- Raising a business object event with a container
- Ways to generate a business object event
- Workflow performance tips
- Available workflow templates
- Refresh Org Environment
- Workflow reports and Tables
- Workflow transactions
- Available standard workflows
- To create a BO event using status management
- Debugging a workflow
- Debugging a background workflow process
- Activating generic business object services
- 201 Interview Questions - SAP Workflow
- Desktop Workplace (Product)
- Mobile Workplace (Product)
- SAP Business Workflow
- Basis
- Display the true average response time, CPU time, db time ...
- Tail -f implemented as an ABAP
- Finding the SAP Statistics for transactions and programs
- Incorrect SAP login logs
- Print to a USB printer from SAP
- Reorganization of Single Object
- How to Increase the Tablespace free space?
- How to activate the IMG Change Log?
- Edit, create, delete or adjust your database table
- Finding any of the SAP tables that have been changed
- List Of Important System Variables
- Access keys
- Common Basis Transactions
- trick: Approve download basket via solution manager
- Parallel printing to all the SAP device printers
- Prevent user from submitting jobs more than once
- Replacement for saplicense in 7.0 available now
- What is an SAP Transport?
- Managing changes to SAP® solutions
- Transport Manager
- Authorization groups
- Useful functions for Basis
- Create Directory on Unix server
- Status "waiting" in SP01
- Understanding table AGR_DATEU
- Archiving Application Data Document
- SAP Statistics for transactions and programs
- When your Stats file is full
- Deleting the Output Messages for Purchase, Sales Order etc
- Restore from BRBACKUP to other SAP environment
- SAP Tables for Basis
- Transport return codes
- Revelation Software Concepts Introduces Powerful New Add-on Suite with Extensions for Change Control of SAP Solutions
- What does the Job EU_REORG do?
- Work responsibility for a BASIS person
- Performance Monitoring - STUN
- Suspend/UnSuspend Released ABAP Jobs
- Useful SAP System Administration Transactions
- Monitoring in SAP Event Management
- Setting up LSMW on Mini Basis
- Rebuilding Indexes in SAP
- Common Mini-SAP Question and Answers
- Changing the SAP splash screen
- Mini SAP System Requirement and How to Get it
- Practice Basis with your Home PC
- Sending reports to your email
- BDLS taking a long time to run?
- SAP Solution Manager Solution Support Enablement Package (SEP)
- Forgot Password for user id SAP* in client 000
- Amending the System Messages
- Five Different "User Types"
- Basis CBT Training Materials
- Brief Description About SAP Basis Implementation
- Monitor and Administrate 4 SAP Systems
- Tcodes used for Daily System Monitoring
- SAP Table Extent using SAPDBA
- SAP Administrator Daily Activities
- Upgrade questions (ERP2005 on NW2004s)
- Troubleshooting SAP Performance Issues
- SAP Security log for SAP*
- Parallel printing to all the SAP device printers
- Tuning Summary In Transaction ST02
- SAP System Performance Issues
- Before going live - Basis tips
- Scheduling of system maintenance jobs
- SAP Load Balancing and Work Processes Troubleshoot
- Audit of SAP multiple logons
- Check RFC connections in the background
- The Step required to Audit at the User Level
- Describe Memory Management?
- What is a logical database?
- Triggering a job from outside SAP
- Example ABAP: Alert basis on login inactivity
- SAP Memory Management and SAP Instance
- Various Unicode conversion errors report via UCCHECK
- Easy Service Marketplace - Quicklinks to OSS
- The Unicode conversion transaction ( UCCHECK )
- Example ERP2004s / ERP2005 upgrade project task list
- Getting system time
- Basis Whitepapers
- Upgrade FAQ's
- Security Upgrade Whitepaper
- Client Copy By Using SCC8 and SCC7
- Analyze passwords across clients for SAP users
- Technical Glossary
- Lost the SAP* password
- Technical Tips
- How to control those idle sessions?
- System Tables
- System Architecture
- Who has deleted the data in table?
- See that t_code in the user menu?
- Good Basis Links
- Upgrade Technical Interview Questions
- What is short dump and what do you do with it?
- Restore from BRBACKUP to other SAP environment
- Transports released from a specified system
- Open SAP tables for direct maintenance
- Automated transports
- Logging Table History
- Changing the Logo on the Right Hand Side
- Triggering a job from outside SAP using Job Events
- Changing the SAP Logo on the top right of the SAPGui
- Advanced SM04 program
- Tip: To log a user off via an ABAP
- Show all users per Application server
- Tip: Executing an OS command
- Basis Starter Guide
- SAP Events
- Cannot activate a table in SAP
- Useful Basis Transactions
- Security
- SAP Authorization Objects Tables
- Transport User Tables between Clients
- How to create and assign an Auth Group to a table
- Live love and be- Auditing SAP Security Process
- SAP Compliance Calibrator- 50000 Foot view
- Information GRC Tool: SAP Fire Fighter 50000 foot view
- SOX Remediation Process for SAP Security Roles
- Restricting Call Transactions
- PFCG - Automatic user compare after save
- SAP Security and Authorization Concepts
- SU53 for other users
- List of useful reports on SAP users
- Overwritten user master in client refresh!!!
- SAP Security Interview Questions
- SAP R/3 Security
- Security Upgrade Whitepaper
- SAPScript / Smartforms
- Utilities
- SAP Functional
- Configuration
- SAP Special Configuration pack offer
- Configuration Packs
- SAP FICO Configuration Package
- SAP HR Configuration Guide
- SAP MM / WM Configuration Package
- SAP PM Configuration Package
- PS Configuration Guide
- SAP PP / QM Configuration Package
- SAP SD Configuration Package
- SAP CO - SAP Controlling Configuration Hints and Tips
- Message Control Configuration
- Purchase Order List Configuration
- Configuration of comms for Vendor Master
- Purchasing Configuration Tips
- Configuration to open url from IC WebClient
- AFS
- ASAP / Solution Manager
- Reporting / BW / KM
- How To Make SAP BI Successful
- Crystal Reports
- SAP BW Query User exit RSR00001
- Standard BW Scenarios
- BW Interview Questions
- FREE BW online Exam available on ERPGenie
- List of useful SAP BW transaction codes
- Responsibilities of BW Data Architect
- Jon Reed Interviews Peter Scott on NetWeaver BI
- How to do performance tuning on InfoCube?
- SAP BW Questions
- SAP BW Questions
- BW Whitepapers
- Knowledge Management
- BW Resources
- BW CBT Training CDs
- 201 Interview Questions - SAP BIW Book
- BW Performance Tuning Book
- BW Whitepapers
- FREE ABAP online Exam available on ERPGenie
- SAP Event Management
- SAP Event Management: OnStar® for Your Supply Chain
- Where is the code to kick off the FI Payment events?
- Webinar series starting on SAP Event Management
- SAP Event Management BAPI OSS Notes
- SAP Event Management Application Interface BAdIs
- Short Dump when running /SAPTRX/EM_START
- SAP Event Management Add-On technical details
- Webinar: Interested in understanding SAP Event Management
- SCN SAP Event Management forum created on SCN
- SAP EM Deployment options
- SAP EM Newsletter
- How does SAP EM work? A step by step guide
- SAP Event Management, EDI and Cloud Computing
- New book on SAP Event Management launched!!!
- What is SAP Event Management?
- Webinar: Leveraging what you already have!!! SAP Event Management
- ERPGenie Newsletter
- Displaying the Event Handler list from ECC
- Explaining the difference between Solution Manager's BPMon (Business Process Monitor) and SAP Event Management (SAP's best kept secret)
- Sending an Event to SAP Event Management on receipt of a STATUS IDoc
- What module is the best kept secret in SAP?
- Podcast: Jon Reed interviews Kevin Wilson on ERPGenie and SAP Event Management
- Example Function to send Event to SAP EM
- Implementation considerations when configuring SAP Event Management
- Comparing a parameter value
- Differences between Workflow and SAP EM
- SAP Event Management - Generic Extraction Application Interface
- Authorization to Send SAP EM messages using /SAPTRX/MI02
- SAP EM Order to Cash (OTC) process
- Supply Chain Event Management (SCEM)
- Tips for improving performance in SAP EM 4.1
- Parallelization of SAP EM queues
- SAP EM Demo
- Monitoring in SAP Event Management
- SAP EM program to list EH detail
- Condensed SAP EM Data Model
- QData and SAP Event Management
- WEBINAR: SAP Event Management - What it is and how can you reap its benefits
- SAP Event Management Related Webinars
- SAP EM Activity List
- Creating a new activity function for your SAP EM Rule Set
- Calling SAP EM BAPI to add event
- Archiving and Deletion in SAP Event Management
- SAP EM Documentation
- Installing the SAP EM Add-On for ECC6.0
- Sending Event Messages to an EH (Report)
- SAP Event Management Operation Guide
- Method ACT_EE_MODIFY return codes
- OER, SCEM and AII help
- SAP Event Management - Working with queued RFC
- Undelete an Event Handler in SAP EM
- SAP EM BTEs
- SAP Event Management At Canada Post
- SAP Event Management (PDF)
- Wi-Fi Asset Tracking with SAP EM
- SAP GTS
- FICO
- Direct Activity Allocation
- Indirect cost allocation
- Quick reference on Profit Center Group
- FI Parked Documents
- FI Transaction Codes
- Full list of FI Tables
- SAP SD Answers
- SAP SD Questions
- FI Documentation
- SAP Tables for FI/CO
- SAP Tables of Finance Tables
- Validate Customer number
- IMG Settings for SAP FI Credit Management
- What are the SAP Tax Procedures to configure?
- Configuring Intercompany Billing
- What is SAP Account Group?
- SAP Financial Accounting Terms
- FS10 - Account Display Balances
- FREE FICO online Exam available on ERPGenie
- Validate Customer number
- How To Configure The Controlling Area
- SAP CO - SAP Controlling Configuration Hints and Tips
- What are the different types of credit checks?
- Setting up Credit Limit Check
- SAP AP AR GL FA and Costing Tcodes
- Statistical Posting and Real Posting in Costing
- GR/IR Clearance Account in SAP system
- Profit reporting in SAP
- Additional Financial Statement Version
- Tables to use rather than BSEG
- To avoid transfer posting of the same vendor invoice
- Treasury Help Tutorials
- Difference Between Static and Dynamic Credit Check
- Deleting cost elements and cost centers
- Information on FI-CA
- Setting up module FI/CO without using IMG
- Understanding Lockbox
- Reporting for Asset Accounting
- Inbound INVOIC posting configuration
- Message Control Configuration
- Minimum FICO Config to get you going
- FICO Magazine
- FI Tables
- FI CBT Training CDs
- FI Quick Guide
- SAP FICO Configuration Package
- HR
- How Do You Configure Personnel Actions
- Read an info type
- Delete info type
- Read planned work schedule
- Read Data from Logical Database
- Process Infotypes
- HR Transaction Codes
- HR Tables
- Cluster tables in HR
- HR Programming Overview
- HR related links
- Program to retrieve sickpay values
- SAP HR Configuration Guide
- Retrieve Absence type text(AWART)
- Difference Between Indian & US Payroll
- Retrieve Payroll results data
- Training and Event Management Tables
- HRIS - Human Resources Information system
- Help regarding education infotype
- Authorization at wage type level
- HR Authorizations
- SAP HR Transaction Codes
- Creating a New Infotype
- What The Differences Between ABAP and HR-ABAP?
- HR and Payroll related help tutorials
- SAP HR Questions
- Logistics / MM
- Standard reports / T-Codes
- PO related transactions
- Explaining the PO confirmation control key
- Very useful SAP Logistics - Purchasing transactions with descriptions
- Managing your supply chain by exception using standard SAP
- How to cut your shipping costs while dramatically optimizing your shipping process
- Difference between Tcode MB1A, MB1B, MBIC
- What is a Stochastic Block?
- Purchasing process described with module integration highlighted
- Tables involved in Material Variant Config
- How to implement BADI to change a Purchase Order - Post-processing to ME21N
- Difference Between MR21 and MR22 Transaction
- Material Mnagement Tables
- Quick reference on Purchase Requisition
- Find table of Invoice History
- IDocs in Purchasing - An example
- SAP Tables for Material Management
- SAP Tables for Quality Management
- SAP Tables for WM
- Output and Printer Determination For PO and GR
- Customize ABAP Program to Mass run MD02
- How to exclude QI stock in MRP?
- Releases on a scheduling agreement
- Configure Goods/Invoice Receipts for PO in SAP
- Purchase Order List Configuration
- Logistics Webinars
- Searching for Sales Docs by Material
- Important Tcodes of SAP MM Screen
- How to Maintain the Material Type?
- Logistics CBT Training Material
- Explain What Are Material Types in Material Master
- Payment Terms by Material
- SAP MM Config - Create a New Plant
- Purpose of One Time Vendor / Customer
- Deletion of info record
- Warehouse Management (WM) Help Tutorials
- SAP Help - Material Management links
- MM and Purchasing Tables
- SAPShow problem - Solution
- Auto PO creation During GR Posting
- Update Source List by Material Group
- Automatic default the Purchase Order Text
- Sending P.O. By Mail To Vendor
- Configure Goods/Invoice Receipt for PO
- Purchase Order List Configuration
- SAP MRP Profile - How To Use It
- SAP MM and FI Integration
- Configuration of comms for Vendor Master
- Difference between MTS and MTO
- MM Process Flow
- MM Tips
- Purchasing Tables
- MM Tables
- Purchasing Configuration Tips
- SAP Warehouse Management (WM)
- SAP MM / WM Configuration Package
- PM
- PP
- SAP ABAP Decimal Places in Currency
- SAP Production Standard Reports
- MC44 – Inventory Turnover (2)
- MC44 – Inventory Turnover (1)
- Forecasting – Copy history
- Consumption-based planning and MRP
- Firming types in MRP
- Lot-size for continuous production and process industry
- Planned independent requirement reorganization
- What is a planned independent requirement?
- Distribution of Planned Independent Requirements in MRP
- PP Integration with FI , SD, MM and QM
- What is Discrete Manufacturing, REM and Demand Management?
- Procedure To Do Capacity Leveling
- SAP Tables for Production Planning
- SAP Tables for Project Systems
- PS Configuration Guide
- Transactions For PS Module
- Validation in PS - WBS
- How To Create a Multilevel BOM
- Validation in PS
- WBS Elements
- Hierarchical Structure of the Project definition
- Use QM module for ISO documentation
- PP Help Tutorials
- QM Help Tutorials
- Production Order Splitting
- PS / PP Tables
- SAP PP / QM Configuration Package
- SD
- I can't create a variant and share globally!
- Tables behind user status
- Recovery of SD requirements for MRP
- Credit Check Config Reports
- VKM1 - Unblock SD Documents
- Viewing the delivery and invoice due logs
- Creating SAP Pricing conditions using BAPI_PRICES_CONDITIONS
- Explain Access Sequence and Condition Records, Types and Tables
- SAP Tcodes for Retail
- How to configure common distribution channel and division?
- Sales Org, Sales Area and Company Code
- How To Configure New Division/Sales Area/Sales Office
- Sales Document Type described
- Why is the Sales Order Item price is grey?
- Procedure to create SD text types
- Read sales document flow using a function module
- BOM Delivery
- SAP Tables for Master Data
- SAP Tables for Sales and Distribution
- Sales Order Status and Doc Flow Values
- My object services icon doesn't show up
- Tcodes To Configure The SAP SD Sales Tax Determination
- Difference Between Cash Sales and Rush Order
- Jon Reed Interviews Thomas Woelfel on ERP 6.0
- Price with additional decimals
- SAP SD Pricing and Conditions
- What is mySAP SD?
- SD Billing
- sap sd Billing in Make-to-Order Production
- Difference between CR memo and subs. Dr/Crs
- Discount on payer level on billing type LR
- Collective Billing preview
- SAP SD Pricing Conditions
- Sales Order Tables
- Orders are creating and defaulting text!
- Create a Collective Billing Splitting rule
- PGI must be done on current period - VA02-
- Procedures to switched off ATP at delivery
- What Is Meant By Billing Document Type?
- Steps To Setup Collective Billing in SD
- Can Sales Order and Billing Have Different Pricing?
- Hiding condition type VPRS - OSS note 105621
- Delivery Pricing Conditions
- Pricing Release Procedures
- Change a Particular Pricing Procedure
- Control Pricing Conditions based on Order Type
- Create New Condition Types and Procedure
- Difference between Contracts & Scheduling agreement
- Configuring Availability Check
- Configuration of Pricing Procedure
- Enterprise Structure Configuration
- Multi-level Packaging in Delivery
- Order to Cash Cycle
- Automatic e-Mail Confirmation through message control
- SD Tables and their relationships
- SD Training CBTs
- SD Whitepapers
- SAP SD Configuration Package
- SM
- SAP xMII
- mySAP
- mySAP ERP
- mySAP SRM
- mySAP PLM
- mySAP SCM
- Exclude storage location from ATP
- Block storage location for MRP
- SAP Supply Chain Optimization
- Webinars - Supply Chain Optimization
- Supply Network Collaboration - SNC
- Direct Store Delivery - DSD
- Transportation Management (TM)
- Debugging adding a message to SAP EM from ECC
- EWM - Extended Warehouse Management
- Archiving and Deletion in SAP Event Management
- Technology Overview - SCM 5.0
- ICH - Inventory Collaboration Hub
- Global ATP
- mySAP SCM
- mySAP CRM
- SAP CRM 2007
- Customer Relationship Management (CRM) - General & Framework
- CRM Middleware Best Practice Installation Notes
- Certification for CRM
- CRM Training CBT Materials
- Process to Get Partner function (BP Address) related to Sales Order
- CRM tables related to a Sales Order
- Difference between EEWB and BDT
- Configuration to open url from IC WebClient
- Viewing CRM documents in ECC
- XIF (External Interface Framework)
- Sending an ORDERS IDoc to CRM
- Extending a BDoc
- CRM Middleware Described
- mySAP CRM IDoc handling
- Business Adapter Objects
- CRM Middleware BDocs
- About mySAP CRM
- MDM
- MDM FAQ
- What prompted SAP to begin development of SAP MDM?
- Why is SAP MDM part of SAP NetWeaver?
- Is SAP MDM an extension of mySAP PLM?
- Is SAP MDM an xAPP?
- How will companies actually use SAP MDM?
- Can’t you achieve all this by using today’s EAI and/or ETL applications?
- What are SAP MDM’s major benefits?
- What is SAP Master Data Management?
- Configuration
- SAP General
- ERP Tips
- SAP Tables for General Settings
- eSOA Doesn’t Have to Cost a Fortune: Shortcuts to SOA Success via NetWeaver™ BI
- Netweaver - SAP Technology Platform of the Future
- Workflow Guide to Troubleshooting & Debugging
- Integration Between Time Mngmnt & Payroll in SAP HCM
- QuickViewer and SAP Query
- Mastering Material Masters Part I - Material Types
- ERPTips - Purchasing Release Strategies Made Easy
- Tips and Tricks
- Some SAP and ABAP Short Cuts
- The case of the lost SAPLOGON.INI
- SAP Where-used list of SAP objects - run SAPRSEUB (note 28022)
- TIP: Editing any table!!!
- About the Application Server
- Common SAP German words
- SAP Tables for Enterprise structure
- Authority Check
- List SAP User Last Name and First Name
- Creating your own SAP Customized Main Menu
- Games in ABAP
- System Path and Transaction Code Mapping
- Some Strange Problems with SAP Logon
- Report command field formats
- General command field formats
- Table analysis between two systems
- Filling up an empty date field quickly
- Logging on without being authorized
- Finding docs created under GOS
- Finding T-Codes
- What is SAP?
- General SAP Tips
- Glossary
- Partners
- Scoop
- CCI tout’s fully virtualized SAP solution’s
- Rules for Success as an Independent SAP Consultant
- Bank of America chooses SAP over Oracle
- Gary Player and SAP
- Why is it so hard to determine your "SAP Net Worth"?
- Avoiding the SAP Certification Rip-Off
- Breaking into SAP - Is it Too Late?
- SAP Career Outlook
- Don't chase the dollar, chase the skills
- Forums / User Groups
- FAQ
- Whitepapers
- Publications
- Create your own E-Books!!!
- Quick Guide - SAP BW Performance Tuning
- SAP development challenge 2008
- Workflow Books
- SAP Press Books
- Reporting for Asset Accounting
- SAP NetWeaver BI Integration planning for FI
- Next Generation ABAP
- Enhancing SRM using SAP SRM (SAP Press)
- 201 Interview Questions - SAP Workflow
- Project Management, Archiving Book from SAP Press
- Recommended Books
- FI Books
- ERP Books
- EDI Books
- eCommerce Books
- BW Books
- Basis Books
- ALE Books
- ABAP Books
- List of Publications
- SAP Related Magazines
- SAP SD Configuration Package
- SAP PP / QM Configuration Package
- SAP PM Configuration Package
- SAP MM / WM Configuration Package
- ERPTips
- SAP FICO Configuration Package
- Customers
- Quality Assurance
- Implementation
- Benefits of SAP ERP
- Deployment and maintenance costs
- Brief Description About SAP Basis Implementation
- An EDI Implementation Methodology
- ALE Implementation Methodology - Operations
- ALE Implementation Methodology - Development
- ALE Implementation Methodology - Configuration
- ALE Implementation Methodology - Design
- ALE Implementation Methodology - Strategy
- An ALE Implementation Methodology
- Implementation Whitepapers
- SAP Project Management and Implementation Tips
- CASE STUDY: SAC SAP Implementation
- CASE STUDY: SAC SAP Implementation
- SAP Project Management and Implementation Tips
- ERP Tips
- ERP
- Consultant
- Services
Home 
SAP Technical ABAP Dynamic where clauses for selects
SAP Technical ABAP Dynamic where clauses for selects
Login Form
Main Menu
ERPGenie Websites
ERP Software Corner
2010
22
Oct
Dynamic where clauses for selects
Written by Renier
