▶ SAP EWM Tables | 17 Most Important tables [2023]


SAP EWM Tables – Table of Content

Introduction to SAP EWM :

SAP EWM is a crucial functional module that is pivotal in helping organizations manage their inventories and streamline the movement of goods within their warehouse operations. This advanced software solution offers a complete suite of functions. It includes handling inbound and outbound delivery processes, (GR) receipt of goods, order success, and efficient goods distribution.

SAP EWM Tables:

SAP EWM tables deal with the storage for key warehouse management and stock control data. The EWM tables play a vital role in ensuring the smooth functioning of warehouse activities. Here, we will delve into the various categories of SAP EWM tables and provide brief descriptions for each:

1) Stock

  • /SCWM/AQUA: Describes available quantity.
  • /SCWM/QUAN: Defines quant attributes.
  • /LIME/NQUAN: Details LIME quantity attributes.
  • /SCWM/STOCK_IW01: Manages stock key material (WME).
  • /SCWM/STOCK_IW02: Manages stock key material with batch (WME).
  • /SCWM/STOCK_IW03: Manages stock key material with batch and reference documents (WME).
  • /SCWM/STOCK_IW04: Manages stock key material with sales order and project (WME).

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

SAP EWM Training

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

2) Warehouse Task

  • /SCWM/ORDIM_C: Defines confirmed warehouse tasks.
  • /SCWM/ORDIM_CS: Specifies serial numbers for confirmed warehouse task items.
  • /SCWM/ORDIM_E: Specifies exception codes for warehouse tasks.
  • /SCWM/ORDIM_H: Manages warehouse task movements for handling unit (HU) items.
  • /SCWM/ORDIM_HS: Handles serial numbers for HU item movements.
  • /SCWM/ORDIM_L: Logs warehouse task information.
  • /SCWM/ORDIM_LS: Logs serial numbers for warehouse task entries.
  • /SCWM/ORDIM_O: Open warehouse tasks.
  • SCWM/ORDIM_OS: It handles serial number items for available warehouse tasks.
  •  

3) Transportation Unit

  • /SCWM/TU_DLV: Describes the assignment of deliveries and HUs to transportation units.
  • /SCWM/TU_DOOR: Assigns transport units to doors.
  • /SCWM/TUNIT: Defines transportation units.
  • /SCWM/TU_SR_ACT: Specifies S and R activities of transportation units.
  • /SCWM/TU_STATUS: Manages the status of transportation unit activities.
  • /SCWM/TU_VEH: Assigns transport units to vehicles.
  • /SCWM/DOOR_SRACT: Defines S & R activities of doors.
  •  

4) Wave

  • /SCWM/WAVEHDR: Manages wave header data.
  • /SCWM/WAVEITM: Contains wave item data.
  •  

5) Outbound Delivery

  • /SCDL/DB_DLVH_O: Handles outbound delivery header data.
  • /SCDL/DB_DLVI_O: Manages outbound delivery item details.
  • /SCDL/DB_PROCH_O: Oversees outbound delivery order header.
  • /SCDL/DB_PROCI_O: Manages outbound delivery order items.
  •  

6) Inbound Delivery

  • /SCDL/DB_PROCH_I: Manages inbound delivery header information.
  • /SCDL/DB_PROCI_I: Details inbound delivery item information.

Interested in learning python Join HKR Python certification training! 

 

7) References

  • /SCDL/DB_REFDOC: Determines reference information.
  • /SCDL/DB_REQH: Defines header information for inbound delivery notifications or outbound delivery requests.
  • /SCDL/DB_REQI: Manages item information for inbound delivery notifications or outbound delivery requests.
  •  

8) Handling Units (HUs)

  • /SCWM/HUHDR: Oversees handling unit header information.
  • /SCWM/GMHUIDENT: Manages additional handling units for goods movement logs.
  • /SCWM/HUSSTAT: Specifies individual status for each handling unit.
  • /SCWM/HUREF: Manages handling unit references.
  • /SCWM/HUSTOBJ: Details information about handling unit status objects.
  • /SCWM/GMHUSTAT: Tracks HU status from goods movement logs.
  • /SCWM/GMHUITM: Manages handling unit items.
  • /SCWM/GMHUHDR: Maintains handling unit header data in goods movement logs.
  •  

9) Storage Bins

  • /SCWM/LAGP: Provides storage bin details.
  • /SCWM/LAGPS: Offers comprehensive information on available storage bins for various execution areas and activities.
  •  

10) Master Data

  • /SAPAPO/MATKEY: Defines product details.
  • /SAPAPO/MATMAP: Manages mapping table details for products.
  • /SAPAPO/MATEXEC: This table contains product execution data.
  • /SAPAPO/MATTXT: It provides material descriptions.
  • /SAPAPO/MATLWHST: This table states the location-specific product information by storage types.
  • /SAPAPO/MATLWH: It specifies location product information for warehouse locations.
  •  

11) Physical Inventory Documents

  • /LIME/PI_DCTYTXT: It describes physical inventory procedure details.
  • /LIME/PI_DOCTYPE: It defines document types for physical inventory and internal settings.
  • /LIME/PI_DOC_IT: It manages physical inventory document items.
  • /LIME/PI_DOC_SER: This table tracks serial numbers for physical inventory document items.
  • /LIME/PI_DOC_TB: This table contains quantities for physical inventory document items.
  • /LIME/PI_IT_BIZ: Specifies business key objects for physical inventory documents.
  • /LIME/PI_LOGHEAD: It logs header data of physical inventory log entries.
  • /LIME/PI_LOGHIST: Maintains a history table for physical inventory log entries.
  • /LIME/PI_LOGITEM: This table logs item data of a physical inventory document.
  • /LIME/PI_PAR_BIZ: It manages parent objects for physical inventory document business keys.
  •  

12) Route

  • /SCMB/ROUTE: Provides route information.
  • /SCMB/ROUTET: Contains route table information.
  • /SCMB/TOENTITYT: Specifies text information about supply chain units.
  • /SCDL/TSRVLVLT: It specifies the details of shipping condition text information.
  • /SCMB/ROUTE_SC: Manages shipping conditions for routes.
  • /SCMB/ROUTE_RT: Defines request types for routes.
  • /SCMB/STOP: Offers information about route stop logs.
  • /SCMB/ZONE: Contains transportation zone details.
  • /SCMB/ZONE_D: Provides details on transportation unavailability zones.
  • /SCMB/TOENTITY: Manages the details of the supply chain unit header.
  •  

13) Location

  • /SCWM/LOC_IW01: this table specifies location table numbers and storage bin details.
  • /SCWM/LOC_IW02: This table offers details on warehouse resources.
  • /SCWM/LOC_IW03:- Provides location table warehouse views.
  • /SCWM/LOC_IW04:- Contains location table transport details.

frequently asked SAP EWM Interview Questions and Answers

HKR Trainings Logo

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

14) APO Location

  • /SAPAPO/LOC:- Describes location details.
  • /SAPAPO/LOCMAP:- Manages mapping tables for locations.
  • /SAPAPO/LOCT: Offers short text descriptions for sites/locations.
  • /SAPAPO/LOCVER:- Maintains version-dependent location data.
  •  

15) RF (Radio Frequency)

  • /SCWM/TTRNS_CAT:- It specifies logical transactions.
  • /SCWM/TSTEP_CAT:- It manages steps of logical transactions.
  • /SCWM/TPRDV_CAT:- This table specifies presentation devices.
  • /SCWM/TPRES_CAT:- This table defines presentation profiles.
  •  

16) Communications 

  • TRFCQIN:- Describes TRFC queue details for inbound delivery processes.
  • EDIDC:- Contains control record details.
  •  

17) Business Partner (BP)

  • ADRC:- Provides business address server details.
  • SCDL/DB_BPLOC:- Manages partner location searches for delivery information.
  • BUT000:- Contains general data for BP.
  • BUT020:- Specifies BP address details.

[Related Article : Dell Boomi Tutorial]

SAP EWM Training

Weekday / Weekend Batches

Final Thoughts:

This detailed overview of SAP EWM tables offers valuable insights into the critical components of warehouse management and inventory control. By exploring these tables, readers can gain a more profound knowledge of the functional modules and capabilities of SAP EWM. It also equips them to excel in real-time projects with expert guidance.

 

Other 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


SCCM Tutorial – Table of Content

What is SCCM and how it works?

System Center Configuration Manager (SCCM) is a product from Microsoft for systems management connected over the corporate network.It’s a software management suite that allows us to manage Windows, macOS (OS X), Linux, or UNIX systems.It can also manage mobile operating systems such as Windows Phone,Symbian,iOS, and Android. It provides features like patch management, remote control, operating system deployment, network protection, and many more.

SCCM manages both application installations and software updates. It provides distributed deployment on remote systems connected through the corporate network. We can configure a few target machines through the management console. It even keeps track of the network’s inventory.

Start learning Microsoft SCCM online course from hkrtrainings to make a bright career in the world of SCCM!

SCCM version history

The SCCM was originally released with the name ‘Systems Management Server 1.0’ in 1994.It targeted management of MS-DOS, Windows for Workgroups, Macintosh, LAN Manager, etc. It has evolved drastically over the years incorporating many features. Let’s see some of the significant releases.

The ‘Systems Management Server 1.2’ was released in 1996, which includes remote-control, SNMP, inventory, and network monitoring capabilities.  Microsoft introduced software-distribution capabilities in ‘Systems Management Server 2003’ in 2003.

The ‘System Center Configuration Manager 1602’ released in 2016 includes conditional access for PCs, Office 365, management of mobiles, and Windows 10. In the same year, they improved integration with the Windows Store to support online and offline licensed apps.The latest stable version of SCCM was released on April 1st, 2020. The name of this version is ‘Endpoint Configuration Manager 2002’.

SCCM Architectural components

Let’s look at the architectural components of SCCM 2012 R2. The core role of SCCM is a site. The SCCM 2012 architecture consists of three different site types.

  • A single stand-alone primary site with no secondary sites
  • A primary site with one or more secondary sites
  • A central administration site at the top level with one or more primary sites. The primary sites, in turn, can have one or more secondary sites.

Central Administration Site (CAS)

When an organization has to maintain more than 100,000 clients, then we should go for CAS. We can set up primary sites for a set of clients. The primary sites in CAS hierarchy are treated as child sites. They have limited roles and no clients assigned. The CAS should be configured with a SQL server to store the hierarchical data. The entire SCCM can support a maximum of 400,000 clients.

SCCM Training

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

Primary Site

Primary sites manage clients through connected networks. A primary site can support up to 250 secondary sites, 100,000 clients, and 10 management points. If an organization has to manage less than 100,000 clients, then a single stand-alone primary site would suit best.

Secondary Site

To service clients in remote locations, we can use secondary sites. A secondary site can be installed from the Configuration Manager console. When a secondary site is installed, a management point and a distribution point are automatically deployed. A secondary site requires either a SQL Server Express or a full instance of SQL Server.

Frequently asked SCCM Interview Questions and Answers !!

Features of SCCM

Below are the primary management features of the Configuration Manager.

Co-management

We can attach existing Configuration Manager deployment to the Microsoft 365 cloud using co-management. We can manage Windows 10 devices by both Configuration Manager and Microsoft Intune. 

Desktop Analytics

It is a cloud-based service that can integrate with the Configuration Manager. We can combine data from our organization with the data collected from millions of devices and provide insights. 

Cloud-attached management

We can use cloud management gateway, cloud-based distribution points, etc. to manage internet-based clients.

Real-time management

We can use CMPivot to query online devices for deeper insights. We can also deploy Windows PowerShell scripts to clients.

Application management

We can create, manage, deploy, and monitor applications on different devices. We can also integrate with the Microsoft Store to deliver cloud-based apps.

OS deployment

We can deploy OS images on specified target machines. The image deployment might use PXE, multicast, or bootable media.

Software updates

We can monitor and deploy software updates within an organization. 

Company resource access

Users from remote locations can access data and applications. It includes Wi-Fi, VPN, email, and certificate profiles.

Compliance settings

We can assess, track, and remediate the configuration compliance of client devices. We can also configure compliance settings to only a few specified target devices.

Endpoint Protection

It provides security, antimalware, and Windows Firewall management for all the systems connected in your organization. 

Inventory

We can monitor assets like hardware devices and software that belong to an organization.

Related Article: SCCM Certification

others, sccm-tutorial-description-0, others, sccm-tutorial-description-1

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

On-premises mobile device management

This supports managing Windows 10 Enterprise and Windows 10 mobile devices.

Power management

We can monitor the power consumption of client computers. We can configure the power plans of the systems in an organization.

Remote control

We can remotely deploy client computers from the Configuration Manager console.

Reporting

It offers advanced reporting capabilities. It provides a lot of default reports too.

Software metering

We monitor the software usage data from the clients. We can determine if the software is being used or not.

Prerequisites for SCCM installation

The following are the prerequisites that we need to set up before going through with the installation of the SCCM.

  • Create system management container
  • Assign site server computer permissions on the container
  • Extend active directory schema
  • .Net Framework 
  • Remote differential compression
  • Windows assessment and deployment kit

We can install a prerequisite checker (Prereqchk tool) and verify if all the components are configured or not. Open a command prompt as an administrator. Go to ‘.\SMSSETUP\BIN\X64’ location and the below command. Prereqchk.exe /AdminUI

The pre checker will run and check for all the required components. If all the components are found, we will get a result that says ‘All required prerequisite tests have completed’ with a status of success. Now you are good to go ahead with the SCCM installation.

SCCM Training

Weekday / Weekend Batches

Installation of SCCM

Download the SCCM ISO from the https://www.microsoft.com/Licensing/servicecenter/default.aspx page. Run the ‘Splash.hta’ file and select the ‘Install’ option. The initial screen will show the steps necessary to install SCCM. Click on ‘Next’, and you will get a ‘Getting Started’ screen. Select the ‘Install a Configuration Manager Primary Site’ checkbox and click on ‘Next’. 

Enter the product key and click on ‘Next’. Accept all the Microsoft Software License Terms, the Product License Terms, and click on ‘Next’. You will get a ‘Prerequisite Downloads’ screen. Specify the location for the prerequisite file download, and click on ‘Next’. On the Server, and Client Language Selection screens, select ‘English’ as the language, and click on ‘Next’.  

Enter the site code, site name, and specify the installation folder on the ‘Site and Installation Settings’ screen. Select the ‘Install the primary site as a stand-alone site’ option on the ‘Primary Site Installation’ screen. Enter the SQL server name, database name, and click on ‘Next’. On the next screen, enter the path to the SQL Server data file, path to the SQL Server log file, and click on ‘Next’.

Click on ‘Next’ on the SMS Provider Settings screen. Select the ‘Configure the communication method on each site system role’ option on the ‘Client Computer Communication Settings’ screen, and click on ‘Next’. Select the ‘Install a Management Point’, ‘Install a Distribution Point’ checkboxes, and click on ‘Next’. Click ‘Next’ on the ‘Usage Data’ screen. Click ‘Next’ on the next screen too. 

You will get a summary of all the options that you have selected.Click on ‘Next’ to proceed. On the next screen, you can see the prerequisite checks. Click on ‘Begin Install’ to start the installation. Once the installation is complete, click on ‘Close’.

Related Article: SCCM Client Installation

Comparison between SCCM and WSUS

Both the SCCM and WSUS are patching solutions developed by Microsoft, but they have some differences. 

  • Both SCCM and WSUS are on-premise solutions.
  • Organizations of any size can use WSUS. Organizations of large size will use SCCM.
  • WSUS offers some patching automation with no up-front costs. SCCM is a paid patch system. 
  • WSUS does not offer reporting and network visibility. 
  • WSUS does not handle patching third-party applications.SCCM provides more support for third-party application patching.

Conclusion

Systems Center Configuration Manager (SCCM) is a perfect solution for managing a large number of systems with various operating systems. SCCM has been used by many organizations. The learning curve for SCCM is complex, but once you get started with it, it will be easier to work with SCCM. The SCCM helps in standardizing all your systems in your domain. Even if your system is connected to your network with a live connection, or with a VPN, or through a remote connection, you can configure it easily with SCCM.

Related articles:

1.Sccm Deployment

2.Difference between SCCM and WSUS

3.Sccm overview

4.Altiris Training

5. SCCM Latest Version



Source link