MySAPSource.com

Stock Tables and Stock Types

Ole — Sun, 13 Feb 2011 12:35:26 +0000

Stock Tables

Table	Description	SOBKZ
MARC	Plant Data for Material
MARD	Storage Location Data for Material
MCHB	Batch Stocks
MSSL	Total Special Stocks with Vendor	O
MSLB	Special Stocks with Vendor	O
MSKU	Special Stocks with Customer	V,W
MSSA	Total Customer Orders on Hand	E
MSKA	Sales Order Stock	E
MSSQ	Project Stock Total	Q
MSPR	Project Stock	Q
MKOL	Special Stocks from Vendor	K,M

Valuation Tables

Table	Description
MBEW	Material Valuation
EBEW	Sales Order Stock Valuation
QBEW	Project Stock Valuation
OBEW	Valuated Stock with Subcontractor (only for Japan)

Document Tables

Table	Meaning	Key fields
MKPF	Header: Material Document	Document number (MBLNR), year (MJAHR)
MSEG	Material Document – segments/ lines	Document number (MBLNR), year (MJAHR), line number (ZEILE)
BSIM	Index for material to the FI-documents	Material (MATNR), Valuation Area (BWKEY)…
CKMI1	Material ledger index, used to document changes in MBEW for each movement	KALNR, use mbew-kaln1

All Stocks

Table	Field	Meaning	Valuated in	Total in table	History table	Posted with
MARC		Plant Data for Material
MARC	UMLMC	Stock in transfer (plant to plant)	MBEW		MARCH	Transfer without PO, 303 / 305
MARC	TRAME	Stock in transit	MBEW		MARCH	Transfer with PO, 351 / 101, 641
MARC	GLGMG	Tied empties stock	MBEW		MARCH
MARC	VKUMC	Stock transfer sales value (plant to plant) for VO material	MBEW		MARCH
MARC	VKTRW	Transit value at sales price for value-only material	MBEW		MARCH
MARC	BWESB	Valuated Goods Receipt Blocked Stock	MBEW		MARCH
MARD		Storage Location Data for Material
MARD	LABST	Valuated stock with unrestricted use	MBEW		MARDH
MARD	UMLME	Stock in transfer (from one storage location to another)	MBEW		MARDH	313 / 315
MARD	INSME	Stock in quality inspection	MBEW		MARDH
MARD	EINME	Total Stock of All Restricted Batches	MBEW		MARDH
MARD	SPEME	Blocked stock	MBEW		MARDH
MARD	RETME	Blocked Stock Returns			MARDH
MARD	KLABS	Unrestricted-use consignment stock
MARD	KINSM	Consignment stock in quality inspection
MARD	KEINM	Restricted-use consignment stock
MARD	KSPEM	Blocked consignment stock
MCHB		Batch Stocks
MCHB	CLABS	Valuated stock with unrestricted use	MBEW	MARD-LABST	MCHBH
MCHB	CUMLM	Stock in transfer (from one storage location to another)	MBEW	MARD-UMLME	MCHBH
MCHB	CINSM	Stock in quality inspection	MBEW	MARD-INSME	MCHBH
MCHB	CEINM	Total Stock of All Restricted Batches	MBEW	MARD-EINME	MCHBH
MCHB	CSPEM	Blocked stock	MBEW	MARD-SPEME	MCHBH
MCHB	CRETM	Blocked Stock Returns		MARD-RETME	MCHBH
MSSL		Total Special Stocks with Vendor
MSSL	SLLB	Valuated stock with unrestricted use	MBEW**
MSSL	SLINS	Stock in quality inspection	MBEW**
MSSL	SLEIN	Total Stock of All Restricted Batches	MBEW**
MSLB		Special Stocks with Vendor
MSLB	LBLAB	Valuated stock with unrestricted use	MBEW	MSSL-SLLAB	MSLBH
MSLB	LBINS	Stock in quality inspection	MBEW	MSSL-SLINS	MSLBH
MSLB	LBEIN	Total Stock of All Restricted Batches	MBEW	MSSL-SLEIN	MSLBH
MSKU		Special Stocks with Customer
MSKU	KULAB	Valuated stock with unrestricted use	MBEW		MSKUH
MSKU	KUINS	Stock in quality inspection	MBEW		MSKUH
MSKU	KUEIN	Total Stock of All Restricted Batches	MBEW		MSKUH
MSSA		Total Customer Orders on Hand
MSSA	SALAB	Total Customer Orders on Hand	EBEW* MBEW+
MSSA	SAINS	Stock in quality inspection	EBEW* MBEW+
MSSA	SASPE	Blocked stock	EBEW* MBEW+
MSSA	SAEIN	Total Stock of All Restricted Batches	EBEW* MBEW+
MSSA	SATRA	Stock in transit	EBEW* MBEW+		MSSAH
MSKA		Sales Order Stock
MSKA	KALAB	Total Customer Orders on Hand	EBEW* MBEW+	MSSA-SALAB	MSKAH
MSKA	KAINS	Stock in quality inspection	EBEW* MBEW+	MSSA-SAINS	MSKAH
MSKA	KASPE	Blocked stock	EBEW* MBEW+	MSSA-SASPE	MSKAH
MSKA	KAEIN	Total Stock of All Restricted Batches	EBEW* MBEW+	MSSA-SAEIN	MSKAH
MSSQ		Project Stock Total
MSSQ	SQLAB	Total Customer Orders on Hand	QBEW* MBEW+
MSSQ	SQINS	Stock in quality inspection	QBEW* MBEW+
MSSQ	SQSPE	Blocked stock	QBEW* MBEW+
MSSQ	SQEIN	Total Stock of All Restricted Batches	QBEW* MBEW+
MSSQ	SQTRA	Stock in transit	QBEW* MBEW+		MSSQH
MSPR		Project Stock
MSPR	PRLAB	Total Customer Orders on Hand	QBEW* MBEW+	MSSQ-SQLAB	MSPRH
MSPR	PRINS	Stock in quality inspection	QBEW* MBEW+	MSSQ-SQINS	MSPRH
MSPR	PRSPE	Blocked stock	QBEW* MBEW+	MSSQ-SQSPE	MSPRH
MSPR	PREIN	Total Stock of All Restricted Batches	QBEW* MBEW+	MSSQ-SQEIN	MSPRH
MKOL		Special Stocks from Vendor
MKOL	SLABS	Unrestricted-use consignment stock		MARD-KLABS	MKOLH
MKOL	SINSM	Consignment stock in quality inspection		MARD-KINSM	MKOLH
MKOL	SEINM	Restricted-use consignment stock		MARD-KEINM	MKOLH
MKOL	SSPEM	Blocked consignment stock		MARD-KSPEM	MKOLH

* only if MSSA/MSSQ – KZBWS = ‘M’

+ only if MSSA/MSSQ – KZBWS = ‘A’

** if MSSL-XOBEW = ‘X’ valuated in table OBEW (only for Japan from 4.6 on)

Material Number Ranges and Formatting

Ole — Sun, 30 May 2010 08:17:16 +0000

Material Numbers in R/3

The material number in R/3 is technically defined as an eighteen byte, character field.
The logic that formats material numbers is contained in a conversion exit and is controlled by configuration tables, number range objects and standard R/3 customer
functions. This document first explains how material number ranges are defined and then details a few methods for enhancing the standard functionality. The examples in this document are from a 4.6c system.

Relevant OSS Notes

The following OSS notes may be useful in understanding this process:
72286 Lexicographical / non-lexicographical material number
78093 Display of alternative material identifiers

Material Number Range Object

R/3 uses Number Range Objects to assign numbers to almost everything within the system. For materials, the number range object used is MATERIALNR. Number range objects can be viewed and maintained using transaction SNRO.

The configuration for the number range object specifies a transaction (MMNR) for maintaining the intervals. The group section specifies that intervals will be assigned using groups. In this case, the group is the material type (MTART). Table T134 is the configuration table that defines material types. NUMKI and NUMKE are the fields in table T134 that contain the internal and external number range intervals.

Assigning Intervals to Material Types

Transaction MMNR

Transaction MMNR is used to create and assign intervals to the material types.

Each group is displayed with the material types assigned. In this case, a group corresponds to an interval.

The interval for material type FERT is displayed when the maintain button is pressed from the previous screen.

Notice that the interval range contains leading zeros. This explains why zero filled material numbers exist even though the MATNR domain is defined as a character type.

Configuration Tables

When transaction MMNR is processed, the configuration tables in the following sections are referenced/updated.

Table TNRGT Number Range Groups

Table T134 Material Type Master

Table T134 is the configuration table that contains the material type parameters. The fields listed below are the subset related to material number ranges.

Table NRIV Number Range Intervals

Table NRIV contains the actual number range intervals

Controlling the Format

Transaction OMSL Material Number Format

Transaction OMSL is used to access table TMCNV, which is the configuration table that contains control settings for formatting the material number.

Table TMCNV

Below is the SE16 view of the TMCNV table.

Material Number Domain

Conversion exits are assigned at the domain level within the data dictionary. The following screen displays the material number domain (MATNR). The standard R/3 conversion routine is specified (MATN1)

Function Group OMCV

The material number conversion exit function modules are contained in function group OMCV. For each conversion exit defined, there are two function modules. One function is for input and, the other is for output. SAP has a standard naming convention for these functions that must be followed. It consists of a prefix, the conversion routine name and a suffix as follows:
‘CONVERION_EXIT_’ + Conversion routine name + ‘_INPUT’
‘CONVERION_EXIT_’ + Conversion routine name + ‘_OUTPUT’

Function CONVERSION_EXIT_MATN1_INPUT

Converts the internal material number to the output format. The logic flow is as follows:

Calls customer function 001 if it exists.
Reads table TMCNV and formats the number based on the settings in the table.
Calls customer function 002 if it exists.

Function CONVERSION_EXIT_MATN1_OUTPUT

Converts the external material number to the internal format. The logic flow is as follows:

Calls customer function 901 if it exists.
Reads table TMCNV and formats the number based on the settings in the table.
Calls customer function 902 if it exists.

Custom Output Format Example 1

The following example demonstrates how to format the material number output using an edit mask.

Business Requirement

The customer wants to display the material using the format xxxx-xxx-xx.

Solution

To solve this problem, standard configuration will be used to add an edit mask to the material number.

Step 1 Define the Edit Mask via TMCNV Configuration

Using transaction OMSL, the edit mask is specified in the material number template field.

Once the configuration is complete, table TMCNV contains the edit mask. Several other fields related to the edit mask are also present. These fields are used by the standard logic in the conversion exit to apply the mask to the number.

Step 2 Test the Configuration Change

Using transaction SE16, two MARA records are displayed. The conversion exit does not execute until the record detail is displayed. The material number internal format has not changed. It is still eighteen bytes, zero filled.

Once the record detail is displayed, the conversion exit logic applies the masking logic based on the TMCNV record.

Custom Output Format Example 2

The following example demonstrates how to implement a custom material number output routine.

Business Requirement

The customer uses material numbers that are either six or seven bytes long. They always want seven bytes displayed, even if the actual number is six bytes long. For numbers that are six bytes long, they want a leading zero to display.

Solution

To solve this problem, we will add logic to zero fill six byte numbers (to seven bytes) when outputting the material number. This logic will be added to customer function 902 in the output conversion exit of the material number (CONVERSION_EXIT_MATN1_OUTPUT).
It is assumed that the reader understands the CMOD/SMOD enhancement concept.

Step 1 Identify the Standard Customer Function

The output conversion exit for material numbers contains two customer function calls.
Function 901 is called at the beginning of the logic and function 902 is called at the end, just before the exit. For this project, we will use function 902.

To navigate into the customer function, double click on the function name ‘902’.

Step 2 Create the Customer Function INCLUDE

The customer function does not contain any code, only an INCLUDE. The actual code will be added to the INCLUDE.

Double click on the include name ZXMG0U11. The system will respond with ‘Include ZXMG0U11 does not exist, Do you wish to create it’. You need to go thru the normal steps to create the INCLUDE, assign a transport request, etc.

The system will create an empty include to which we will add our logic.

Step 3 Code the Logic

The logic is added into the INCLUDE. This logic is quite simple. We check the length of the material number. If it is six bytes long, a single leading zero is added.

Step 4 Find the Standard Enhancement (SMOD)

For standard customer functions, there will be an existing enhancement. It can be found using the search tool in transaction SMOD.

The standard enhancement for material number customer functions is MGA00003.

The standard enhancement contains all four of the customer functions contained in the conversion exits. It does not matter that we aren’t using the others. Alternatively, we could create a custom enhancement that contains only the customer function we are using.

Step 5 Create a Project (CMOD)

Using transaction CMOD, create a customer specific project. Customer specific projects must begin with the letter ‘Z

Step 6 Assign the Enhancement to the Project

One or more enhancements (SMOD) can be assigned to a project. In this case, we will assign the standard material number enhancement.

Step 7 Activate the Project

On the main screen of transaction CMOD are the activate/deactivate buttons. The project must be activated from this screen.

Step 8 Test the New Logic

Below is the detail view of the record containing the six byte material number. The logic added one leading zero to the number for output.

Below is the detail view of the record containing the seven byte material number. The logic was not applied to this number.

Inbound & Outbound IDoc user exits

Ole — Sun, 25 Apr 2010 18:58:04 +0000

Introduction:

In the in- and outbound processing of IDocs it is often necessary to implement a processing which is different from SAP standard. The reasons for this are for instance:

· Adding user-defined fields with special processing logic

· Substitutions with complex logic, which can not be handled with customizing

· Special validations, which can not be handled with customozing

With user-exits it is possible to implement user-defined coding in the in- and outbound processing of IDocs. To find the user-exits in an easy way, a list was created sorted by message type, based on release 4.5. In this list you will also find some entries without message type. These are user-exits in the general ALE processing.

If you miss an known user-exit in this list, please send a mail to ‚interface.adviser@sap-ag.de‘. Additional information about the user-exits you will find with transaction CMOD under utilities -> SAP enhancements, when entering enhancement and component. With the documentation found there you can decide if the exit is appropriate for your purpose.