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 [...]

Read more...

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 [...]

Read more...

In the following example we select some material data from the transparent table MARA and copy the result to the clipboard.
The result is transferred to the clipboard with TABs as delimiters, which makes it possible to paste the result directly into Excel.

Read more...

In the example we will show how simple it is to import an Excel spreadsheet into an internal table.
For the reason of simplicity we have chosen to use a predefined structure with 26 fields to hold the imported spreadsheet. You could simply add more columns if needed, or better, use a dynamic internal table.

Read more...

This code sample shows how to join three database tables in a select query. The result of the query are stored in an internal table. 

Read more...

In the following example we will populate an internal table and use it as an input to a database query.

Define which material numbers we want to included in the query.
Optimize the query.
Run the query against the MARA table.
Print the result of the query (number of rows retrieved)

Read more...

When you execute an ABAP programs, all the system fields data are passed to the structure SYST.
Use transaction SE11 – Dictionary to view the structure. Structure are used for storing temporary data.
Some of the system fields can be used in your ABAP programs.
Below you will find a list of the most common used system fields.

Read more...

In this case we will read data from the two tables AFKO and MARA into the internal table it_orders.
The table AFKO holds the headers for PP orders and MARA the general material data.

Read more...