SAP EWM Modules | A Complete Guide on SAP EWM Modules


What is SAP EWM (Extended Warehouse Management) 

It is one of the functional modules which is used to manage warehouse inventory and supports the processing of goods movements. The SAP EWM also allows organizations to control both inbound and outbound delivery process delivery. and movements in the warehouse. The main purpose to use EWM is to manage the outbound and inbound delivery process, maintain goods receipts, solve goods issues, fulfill customer orders, and goods distributions.

*Note: the SAP EWM is quite different from warehouse management (mostly used in supply chain management) as it offers many advanced features like picking up of goods, RF frameworks, warehouse structure, and flexible enough to manage the warehouse management functions.

Become a master of SAP EWM by going through this HKR SAP EWM Online Training!

Image

Salient features of SAP EWM :

SAP EWM signifies the major key features which are considered so important in any organization; Let us explain one by one;

  • With the help of SAP EWM, users can control the various warehouse activities such as picking, posting, managing storage, and good sales document types.
  • The SAP EWM helps you to set the alert before the goods receipt transfer from EWM to the SAP ERP system along with this feature, users are also able to perform corrections, reversal, and inbound delivery split from the SAP EWM to the SAP ERP system.
  • Users can also perform deconsolidation of the handling of various units that contain product details and their storage locations.
  • Users can also determine the storage concepts like product slotting, and optimize the goods arrangements for the warehouse automatically.
  • The SAP EWM functional module allows users to perform various tasks like work packaging, and also monitor the warehouse activities which are performed by the warehouse employees.
  • The SAP EWM also helps organizations to keep track of the vehicles, and other transportation units (it consists of a yard-in check-in and yard-out checkout) activities.
  • SAP EWM also comprises storage and handling of various hazardous substances (such as SAP environmental health, and safety EHS).
  • SAP EWM allows organizations to store the labor time, and resource usage effectively( managing the resources effectively).
  • The SAP EWM cockpit allows users to perform the transportation of products to various warehouse centers.

SAP EWM modules :

Here we come to the actual topic of the post, the SAP EWM supports a lot of different functional modules. Let’s start learning them one by one;

In this blog, we are going to concentrate only on the functional modules and customer existing transactions. Each functional module is combined with the transactions to create a simple screen or to enhance the current available functional module to meet the specific customer’s requirements.

Processing TRs(transfer requirements) using the functional module :

This type of functional module allows users to create or change the transfer requirements in the warehouse management. You can make use of these types of functional modules instead of using batch input processes this improves the performance of batch input processing.

To perform this action, the following are the important functional modules available:

  • L _TR_CREATE_CHECK ->this functional module helps to perform plausibility checks.
  • L_TR_CREATE_UPDATE -> this functional module helps to database updated according to plausibility checks.
  • L_TR_CREATE -> perform plausibility checks and database updates.
  • L_TR_CANCEL -> cancel plausibility checks and database updates.

Processing TOs using the functional module :

In warehouse management, users can create, confirm, and change the transfer order using the various functional modules. Let us make a list of them;

  • Report SAPML03T -> this Report SAPML03T consists of the screens and tasks necessary to process external documents.
  • Function group LO34 -> this function group contains the essential internal data for creating and confirming the transfer orders and calls up the update program. The function modules from group L034 are for internal use and are therefore not released to customers.
  • Function group L03B -> this function group L03B contains the functional modules that you should use instead of batch input or CALL transaction using since they are considerably easier to manage.
  • L_TO_CREATE_SINGLE -> create a transfer order (TO) within a single item.
  • L_TO_CREATE_MULTIPLE -> create a transfer order with two or more items.
  • L_TO_CREATE_MOVE_SU -> create a transfer order to move a storage unit.
  • L_TO_CREATE_MOVE_LSR -> initiate a stock transfer of storage units from an external system.
  • L_TO_CREATE_TR -> create a transfer order for transfer requirements.
  • L_TO_CREATE_DN -> create a transfer order for delivery.
    L_TO_CONFIRM -> confirm a transfer order.
  • L_TO_CONFIRM_SU -> confirm a transfer order for a storage unit.
  • L_TO_CANCEL -> cancel a transfer order.
  • L_REF_CREATE -> create a transfer order using multiple processing.
  • L_TO_CREATE_2_STEP_PICKING -> create a transfer order for 2 step picking.
  • L_TO_CREATE_POSTING_CHANGE -> create transfer order for posting changes.

SAP EWM Training

  • Master Your Craft
  • Lifetime LMS & Faculty Access
  • 24/7 online expert support
  • Real-world & Project Based Learning

Delivery functional modules:

These delivery functional modules enable users to deliver the output or sales-related documentation. Let us know them one by one;

  • BAPI_OUTB_DELIVERY_CHANGE ->Logistics execution of BAPI functions.
  • BAPI_PO_CHANGE -> change purchase order.
  • BAPI_TRANSACTION_COMMIT ->execute external commit when using BA PIs.
  • BAPI_PO_CREATE1 -> Create a purchase order.
  • BAPI_GOODSMVT_CREATE ->  post goods movements with MB_CREATE_GOODS_MOVEMENT.
  • WS_DELIVERY_UPDATE -> update about the warehouse goods delivery.
  • GN_DELIVERY_CREATE -> defines the sales document basic functions.
  • L_TO_CONFIRM -> confirm transfer order.
  • BAPI_SAG_CHANGE -> change scheduling agreements.
  • BAPI_SCHEDULE_MAINTAIN -> maintenance of scheduling agreement and delivery schedule lines.
  • BAPI_SAG_GETDETAIL -> read out details from the scheduling agreement.
  • BAPI_OUTB_DELIVERY_REJECT -> rejection of delivery changes from WME.
  • GUI_UPLOAD -> Upload for the data provider.
  • BAPI _DELIVERYPROCESSING_EXEC -> Logistic delivery processing execution.
  • WS_DELIVERY_UPDATE2 ->sales documents functionalities.
  • CHANGE_DOCUMENT_READ_POSITIONS ->change document read change documents item. 
  • BAPI_CONTRACT_CREATE ->BAPI to create a purchase contract.
  • RV_DELIVERY_CREATE -> create the delivery documents.
  • L_TO_CREATE_DN -> create a transfer order for a delivery note.
  • BAPI_INB_DELIVERY_CHANGE -> inbound processing delivery change.
  • BBP_OUTB_DELIVERY_SPLIT_DEC -> BAPI for subsequent outbound-delivery split from a decentralized system.
  • BAPI_HU_PACK -> BAPI for packing an item into an HU.
  • BAPI_INCOMINGINVOICE_CHANGE -> invoice verification: change provisional invoice.
  • BAPI_OUTB_DFELIVERY _SAVEREPLICA -> BAPI function module for replication of outbound deliveries.
  • WS_REVERSE_GOODS_ISSUE -> this functional module will help you to resolve the issues related to the warehouse goods.
  • BAPI_INB_DELIVERY_SAVEREPLICA ->BAPI function module for replication of inbound deliveries.
  • IDOC_INPUT_INVOICE_FI -> EDI: Invoice receipt (Invoice).

frequently asked SAP EWM Interview Questions and Answers

HKR Trainings Logo

Subscribe to our YouTube channel to get new updates..!

A customer exits functional module for TR selection:

Below are a few major customers exits functional module that permits you to create customer-specific projects used to select the transfer requirements for the automatic creation of transfer orders.

  • MWMTOAU1 -> this task allows you to influence the section of transfer requirements for the automatic creation of the transfer orders.
  • MWMTOAU2 ->this task allows you to influence the selection of transfer requirements for the automatic creation of the multiple transfer orders using groups.

Customer exits for creating and confirming TOs:

The following functional modules define the customer-specified logics that permit you to involve in the storage bin search process, and afterward to update the customer data using creating and confirming the transfer orders.

  • MWMTO001 -> this module update the own data after creating transfer orders.
  • MWMTO002 -> this module updates its own data after confirming transfer orders.
  • MWMTO003-> customer-defined putaway strategy, this task allows you to create and implement your own putaway strategies.
  • MWMTO004 -> customer-defined picking strategy, and also allows you to create and implement your own picking strategy.
  • MWMTO005 -> TO-related underdelivery.
  • MWMTO006 -> storage bin related over delivery.
  • MWMTO007 -> palletization and storage type search for putaway.
  • MWMTO008 -> storage type search for picking. This task also allows you to create your own storage type search strategy for stock picking.
  • MWMTO009 -> prevents deletion of TO items, this task makes it possible to prevent the deletion of the transfer order items.

Creating/confirming TOs online or through update programs:

For warehouse management, the update programs for creating or confirming transfer orders can be controlled through a separate parameter. Updates for the normal transactions are carried out through the update programs. To perform this task, change the program ML03TPAR.

  • DEF_VERBU_CREATE -> this functional module helps you to create default transfer orders with the values “x” for update via the update program and “ “ for update without changing the online process.
  • DEF_VERBU_CONFIRM -> default value for the confirming transfer orders with the value “X” for update without changing the online processes.
  • COMMIT_WORK -> this functional module allows you to post data in the system without running.
  • SET UPDATE TASK LOCAL -> the system posts the data synchronization data updates with the help of this functional module.

Want to know more about Sap EWM Tutorial, visit here SAP EWM Tutorial !

SAP EWM Training

Weekday / Weekend Batches

Final words:
In this SAP EWM module blog, we have listed out major functional modules and tried to provide a description of each module. Our main aim to develop these core topics is to adhere or guide many SAP communities around the globe to enhance the skills with respect to the modules. Keep on updating yourself to recent trends or technologies to accelerate your SAP career.

Related Articles:



Source link

Leave a Reply

Subscribe to Our Newsletter

Get our latest articles delivered straight to your inbox. No spam, we promise.

Recent Reviews


Oracle Database administrator :

Before getting deep into Oracle database administrators, let us know about databases. A database usually refers to the collection of the information which will be represented in an organized and structured format. All the databases can be efficiently updated, retrieved, and analyzed based on the requirements. A notepad or Excel might not be capable of handling large volumes of data, files and users. Also, restoration of data, backup and extraction of the data is not easily possible using these applications.

To overcome these limitations, oracle has come up with an Oracle database. Oracle database is also called Oracle RDBMS or Oracle. Oracle DBA is referred to as a relational database management system whose primary focus is to store, manage and retrieve the information to ensure that the performance levels are high and efficient.

Oracle database administrator is not a single person but referred to as a group of specialists. Oracle DBA works on a grid-based architecture, and it is also one of the first-ever databases that are flexible to work with enterprise grid computing. An Oracle database administrator is responsible for administering the Oracle database server. Every database requires a database administrator to manage and administer it. As we handle large volumes of data and users, a single person cannot control the whole of the data management. Hence there will be a group of database administrators who are responsible for sharing their responsibilities and make sure tasks are accomplished.

Oracle database administrator is the one who is responsible for the organization, management, and integration of the company’s data which will be represented in large volumes. There are many different roles, responsibilities, job titles in DBA which will be varying wildly. A database administrator is involved in applying the knowledge of the database management system to define, create, maintain, backup, and secure the organizational data.

The primary responsibility of the database administrator is to ensure that authenticated users have access to the data that they need whenever they need to perform any task. A database administrator should also have the problem-solving capability and have expertise on the relevant databases and technologies where he will be able to communicate effectively with the techies and non-techies in the organization. The database administrators also work closely with the other different departments like Business Analyst and help in developing the database that supports the business needs and helps in keeping the database running smoothly and efficiently in a fast way.

If job security is one of the essential aspects for you, and this is the right time to become a database administrator. As per the surveys conducted, it is analyzed that there will be 11% of growth in the database administrator jobs by the year 2026. This leads to an increase of 7 percent on an average for all the occupations.

Responsibilities of Oracle database administrator:

A Database administrator or a DBA is responsible for managing and maintaining complex databases as organizations hold large volumes of databases. Every organization ensures to review and keep track of the commerce and the other activities, which help in analyzing the future of the organization.

In short, a database administration is one of the recording fields, which helps you develop your career effectively and efficiently.

DBA is responsible for performing some tasks that are purely related to the data. Here are some of the roles and responsibilities a database administrator would undergo.

1. Database administrator is the one who is responsible for the installation and up-gradation of the Oracle server and the respective application tools.

2. They are responsible for creating the primary database storage structures, which are called tablespaces after the designing of the application has been completed by the application developers.

3. A dba is also involved in monitoring and optimizing the performance of the database, controlling the access users to the database, ensuring that the compliance values are met within the Oracle license agreement.

4. He is also responsible for modifying the database structures whenever they need based on the information that is given by the application developers.

5. DBA is involved in creating the primary data storage structures, direct objects like table views indexes, involved in allocating the storage system and also some and analyzing and planning the future storage requirements that are required for the database.

6. A database administrator also needs to ensure that they are ready for the backup and recovery of the database information, restoring the database, maintaining the archived data on tape, enrolling the users and maintaining the system security by giving them access only to the authenticated users, etc.

7. Database administrators are also responsible for contacting the Oracle Corporation whenever they need support from the technical support teams.

                                                 Become a Oracle Primavera Expert With HKR. Join Oracle Primavera Training!

Oracle Database Administrator Certification Training

  • Master Your Craft
  • Lifetime LMS & Faculty Access
  • 24/7 online expert support
  • Real-world & Project Based Learning

Features of Oracle database:

Oracle database is referred to as a cross-platform helps in performing the various tasks, running on the various hardware across different operating systems like Linux, Windows Server, and other distributions of Linux/GNU.

  • Oracle database is also said to be an ACID compliant, ACID-compliant database that is responsible for maintaining the data integration and reliability of data.
  • Oracle database also comprises its networking stack that helps in allowing the applications from different platforms to communicate with Oracle database smoothly.
  • Oracle is the database that it is committed to many available technologies, by providing its extensible support from the late 1990s.

Oracle database also has the structural features which are briefly explained below:

1. Partitioning: Oracle database has come up with the partitioning features which is referred to as a high-performance feature that allows you to divide the last table into different small pieces, allowing you to store each small piece across other storage devices.

2. Logical data structure: Oracle uses the logical data structure where it is stored the data for interaction with the database without actually knowing that the information is stored physically.

3. Data dictionary: Data dictionary is one of the features in the Oracle database that consists of the internal tables and view which help in providing their support to administer the Oracle database more effectively and efficiently.

4. Memory caching: Oracle database uses the memory caching architecture, which helps you to scale up the last database that can help you perform at high speed.

5. Clustering: Oracle is providing high support and high availability that is helping the system to be up and running without any interaction of the services even if there is a cluster failure if one or more servers in a cluster fail.

6. Backup and recovery: To ensure the data integrity is maintained, oracle has a powerful tool called recovery Manager, which helps the DBA in performing the backups and point in time recoveries.

Oracle database architecture:

Oracle database maintenance and architecture includes three main components or categories. They are represented below:

1. Shared memory
2. System support infrastructure
3. Operating system files

Let me give a brief explanation about every component in the Oracle database architecture.

Shared memory:

Shared Memory is referred to as section of the host server memory, which is responsible for the passing the data and application code is stored executed.

Shared memory is often referred to as a Random Access Memory in the architecture of Oracle. Most of the adopters of Oracle Technology will make use of the words cal database and instance synonymously. However, there is a difference between both of them.

A database is referred to as the assortment of the files which are used to store the data and also a handful of work of files that help in the facilitation of the application access.

An instance is referred to as a segment of the shared memory which is providing its extensive support to the process, that also has the capability for applications to work with the data that is present in the database. Once shared memory is started, there are different areas of the shared memory that play a significant role in the database management activities.

The System Global Area, or SGA, comprises the data and also controls information from a single database instance.

The Program Global Area or PGA is referred to as a part of memory that is allocated to a 12c instance. The PGA memory is not shared memory like the SGA memory. The page contains the data and the control information that is specific to the server processes and is not considered as an instance as a whole.

The user Global Area or UGA is referred to as a memory that is associated with each user session.
UGA is also referred to as one of the most important components among the four main memory components available. It is not possible to get the details of each of these components.

Let me give you an overview of the shared memory components of a 12c database.

Auto memory management:

Auto memory management in a 12c database refers to the maximum amount of memory that is used which is defined. The instant is also responsible for the self-management of the size of the assortment of the SG components. The auto memory management approach is used by Oracle mostly and is also referred to as the automatically shared memory management (ASMM).

Manual memory management:

In manual memory management, the administrator is responsible for specifying the fixed size of the components that will make up the SGA. The size of each component is specified in the system parameter file.

System support processes:

System support processes are initiated automatically once the Oracle instance is started. Each process has its importance and performance in the management of the application interaction with the data available.

Below are the set of background processes that support the database.

1. Ckpt: The checkpoint process will help in synchronizing the control file in the data file headers with the available checkpoint information. Apart from this, it also signals the database to write a process that it is time for it to perform the activities that need to be completed.

2. Dbwo: The database writer process is involved in copying the contents of the database offers in the memory to the appropriate database files as per the requirements.

3. Lreg: The listener registration process is responsible for registering the instance information for the Oracle net listener process. If there is an instance where the listener process is not running during the startup, then Lreg tries to attempt to contact it from time to time basis and pass relevant information.

4. Mmon: The manageability monitor process is responsible for establishing the association with the fact that are related to the auto is an automated workload repository.

5. Pmon: The manageability monitor light process also plays an important role in the active session history module. The active session history samples the database activity every second, all the rate of that is trapped can be used for tracking performance issues.

6. Reco: The process monitor is considered as a gatekeeper of the Other server processes, responsible for monitoring all the background processes. It is also involved in performing the recovery activities when the situations come up like the processes end abruptly. It is also responsible for performing resource cleanup activities when required online sessions.

7. smon: The system monitor process is responsible for handling the instance cleanup tasks like a recovery at the startup time if any inconsistencies would cause instance failure.

Operating system files: Operating system files are referred to the suit of fewer than 10 files which have their own individual roles as a database runs.

Below is a list of the operating system files and have their own prominence.

1. Control file: The control file is responsible for managing the metadata of the running instance. There should be at least a minimum of to control files.

2. System parameter: System parameter file includes a list of the parameters and the values that have to be used when the instance is started.

3. Password file: Password file plays an important role in determining who is allowed to initiate the connections to the database in order to perform certain activities and ensure security.

4. System tablespace: If system tablespace is referred to as the heart of a 12c database that comprises the data dictionary as well as the host tombstone information that is relevant to the database activities.

5. Undo tablespace: Undo tablespace is referred to as a player in the Oracle’s read consistent model that contains information required to roll back non committed changes to the data.

6. Temp tablespace: The temp tablespace is referred to as a work area that is used for the Intermediate result sets assembling during the query processing and also to support the sort activities.

7. Online redo: Online redo is referred to as a transaction log that comprises the record or the copy of all the activities that have been happening in the 12c database.

8. Tools tablespace: The tools tablespace is referred to as the user-defined tablespace that is used to house non-system related data.

Become a Oracle Performance Tuning Expert With HKR. Join Oracle Performance Tuning Training !

others, oracle-dba-tutorial-description-0, others, oracle-dba-tutorial-description-1

Subscribe to our YouTube channel to get new updates..!

Terminologies used in Oracle DBA:

You need to understand the basic terminologies that are used in Oracle DBA. We have collected some of the basic terms that are most commonly used in Oracle DBA in this tutorial, as explained below:

Instance: An instance is referred to as the background process and the memory structure that is specifically used to retrieve data from the database.

Process: Process is often referred to as the task or a job that needs to be performed. Oracle comprises two different types of processes. They are Oracle processes and user processes. The operating system commands are not required to be used to interact with the database.

Buffer cache: The buffer cache is referred to as the SGA component that is responsible for storing the data being customized or query and acts as a buffer. The buffer cache is responsible for storing the most recently or frequently used data in the memory to improve the performance. The user processes that are connected to the database will have or share access to it.

Shared pool: Shared pool is responsible for capturing information that is required to be shared with the users. Shared pools include SQL statements, stored procedures, etc. that can be used for reusability and fast access.

Large pool: Large pool is the options area that often provides or offers in memory allocation for extensive processes. It includes oracle backup and recovery operations.

Redo log buffer: The redo log buffer is used to maintain the changes that are made in the database. The redo log files can be overwritten and will run in a circular motion. The redo log helps in recovering the instance whenever there is a failure that occurs. The redo log buffer helps in improving the performance and functionality of the database system.

Locks: Locks are used for controlling the simultaneous access to different data resources.

Database objects in Oracle:

1. Tables: Tables are referred to as common objects that are considered as an integral part of the database. Once the table creation is completed, and the data should be stored by following some of the basic rules like data types, values etc. The table includes all the important rules, and it is easy to access and also compatible to be modified with simple SQL commands.

2. Views: Whenever the database administrator would like to limit the access to the data, a view should come into the picture. There are different types of views of data that can be defined based on the company and user requirements.

Let us take an example where you would like to share the Limited amount of information with the other organization, and then you need to master the rest of the information with proper SQL commands.

Views are introduced to ensure the security aspect is maintained.

3. Synonyms: Synonyms here referred to the process of allowing the users referring to the different objects that are stored somewhere else in the same or different database. These objects are also called handy objects which can be used with the alternative names in the table, and you can also set a pointer to the real table.

Synonyms are referred to as a main memory management technique which some of the objects can be reused and it helps in the Optimization of the overall storage space for the database objects. The database programmers mostly use this concept, and it is used since decades which would increase the throughput of the application code.

4. Stored objects: Store objects are those objects that help in promoting the encapsulation of the code which can be Run either implicitly or explicitly to perform the predetermined task. The most important aspect that needs to be focused on is the usability of the Stored objects which can be reused again and again whenever there is some action that needs to be done. Stored objects help in maintaining consistent performance and also secure the processing together. This object can be divided into functions, procedures, packages which are used to declare the variables, constants, and cursors for exceptional handling.

Benefits of Oracle database:

Oracle has come up with a set of advantages that would help in improving the performance and efficiency, also involved in meeting the client requirements efficiently. Let us have a quick review of the benefits of Oracle database and its help to the Oracle database administrators.

1. Performance: Oracle has come up with the principles and methodologies that are helping in achieving higher performance than any other databases. In Oracle, we can implement the performance tuning in the database, leading to faster retrieval of the data and also altering the data, further leading to the improvement in the query execution time.

2. Editions: Different editions are offered by Oracle. Oracle provides benefits to the users to purchase the edition as per their application requirements and the client requirements. The additions can be updating seamlessly if there is a change in the requirements in the future. The express edition is absolutely free, and you can use it if you want to give a trial and work on the Oracle database to get some hands-on experience on Oracle.

3. Clusters: Oracle uses the real application clusters which help in improving the high data availability systems. The database that contains the real application clusters will have many benefits over the traditional database servers like load balancing, flexibility to increase the processing capacity, scaling up the database over multiple instances, and data redundancy and availability.

4. Multiple databases: Multiple databases involve the management of multiple database instances on a single server. Oracle uses instance casing method to manage the CPU allocations on a server that is running the database instances.

5. Failure recovery: Oracle includes a recovery manager, which is one of the essential features in the Oracle database. The recovery manager has the capability to recover and restore the database files during the outages and downtimes.Users are also allowed to use the user-managed recovery which is supported by Oracle.

6.PL/SQL: Database also provides extensible support to PL for performing procedural programming.

Drawbacks of Oracle database:

There are some set of disadvantages or limitations in the Oracle database. They are explained below:

1. Management of the structure: The management of the structure in Oracle tends to be complex sometimes and seems to be difficult to manage for performing some activities. It is highly recommended to use the basic version and configured with minimal customization.

2. Incompatibility and complexity: Oracle processes some incompatibility and complexity, which is considered as a limitation in terms of time, character and data Syntax sensitivity.

3. Price: Most of the time, there is no price for a specific budget for Oracle licence. Any changes over time, it depends on the change of a policy, updates, patches by the organization.

Oracle Database Administrator Certification Training

Weekday / Weekend Batches

Conclusion:

Oracle database is one of the most commonly used databases in the organization.There is a high need for the database administrators who are involved in implementing and performing the database operations efficiently by meeting the offline customer requirements.Most of the organizations are looking forward to individuals who have the expertise to be a database administrator. Oracle database administrator is one of the prominent roles in the database management field,which is a rewarding field in the current times.Hence,I recommend you to go through this tutorial, also get trained and certified in Oracle to attain a prosperous career in the near coming future.

Related Article:

Oracle Apps DBA Training



Source link