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 [...]
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 [...]
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.
Links between MARA, CRHD, MCH1, INOB, AUSP, CABN, CAWNT, CAWN, CABNT
Keyword: Characteristics
Often we would like to know which transparent tables a SAP transaction is using. With the transaction ST05 this is easy to achieve.
Follow the steps below to learn how to find all those tables in an easy way.
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.
Links between VAPMA, VKDFS, VEPVG, VAKPA, VBLB, VKDFS, VBAK, VBBE, STXH, VBUK, VBEP, VBUP, VBEH, VBAP, VBKD, LIPS, VBPA, VEKP, VEPO, VBLK, LIKP, VTFA, VTTP, VTTK, VBFA, VBRP, VBUP, VBUK, VBSS, VBSK, KONV, VBSK, VBRK, NAST, VKDFS, VRKPA, VRPMA
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)
List of standard SAP R/3 Info Structures.
Links between EKKO, EORD, EKKN, EKET, EKPO, EINA, EINE
Links between KNVP, KNA1, KNB1, KNVV, KNB5, KNVD, KNAS, KNVS
Links between LFM1, LFA1, LFB1, LFM2, LFBK, LFB5
Links between BSIP, PAYR, BVOR, BSIK, BKPF, BSET, BSEC, BSIS, BSAD, BSEG, BSID, BSAS, BSAK
The SAP Project System optimizes the business processes from project planning through to carrying out the project and enables a project progress analysis. You can plan, carry out and control projects in a target-orientated and a business fashion.
In the following table you will find SAP Project Systems related tables.
If you are a developer writing ABAP programs using the Joint Venture (JV) tables, the following tables could be usefull.
Within the SAP Production and Revenue Accounting Solution, the Energy Integration Architecture connects third-party systems, such as ownership and field data capture systems, so they can synchronize and exchange data with the SAP Production and Revenue Accounting component. Within SAP Production and Revenue Accounting, measured oil and gas volumes are allocated to individual wells and [...]
SAP R/3 has a highly integrated Production Planning System. The PP module is divided into two Sub-modules, ‘PP-PI’ and ‘Production General’. PP-PI sub-module is designed for process industries.
The Production Planning module of SAP takes care of Master data needed like Bill Of Materials, Routings and Work Centers and stores it in one separate component.
The SAP HR module enables companies to effectively manage information about the people in their organization. It is integrated with other SAP modules and external systems. From the Organization Management perspective, companies can model a business hierarchy, the relationships of employees to various business units and the reporting structure among employees. The Personnel Administration (PA) [...]
SAP Warehouse Management allows you to manage your material flow, using advanced putaway and picking strategies. In the standard system, these strategies for putaway include random putaway (next empty bin), bulk storage, fixed bin, or addition to stock. The picking strategies include standard strategies first-in first-out (FIFO), last-in first-out (LIFO), picking by shelf life expiration [...]
SAP SD stands for Sales and Distribution and this is the module which is used to manage customer-focused activities, from selling to delivery. The SD module is highly integrated with the other modules in SAP.
The Quality Management module (QM) is part of the integrated R/3 System. With the functions of the Quality Management (QM) module, you can implement the most important elements of a QM system, as specified in ISO 9000.
The SAP FI Module has the capability of meeting all the accounting and financial needs of an organization. It is within this module that Financial Managers as well as other Managers within your business can review the financial position of the company in real time as compared to legacy systems which often times require overnight [...]
SAP MM stands for Materials Management and this is part of SAP Logistics which helps you manage end-to-end procurement and logistics business processes, from requisitioning to payment
If you are interested in tables from other areas of SAP, we have chosen to divide the tables into the following groups. Please click on the group description to [...]
IDoc or Intermediate Document is a standard SAP document exchange format. IDocs allow different application systems to be linked via a message-based interface. The IDoc interface consists of the definition of a data structure (where the data structure is the IDoc) and a processing logic for this data structure.
A collection of the most relevant User andRole tables in SAP
If you are interested in tables from other areas of SAP, we have chosen to divide the tables into the following groups. Please click on the group description to view each groups tables.
Tables related to the setup and monitoring of the SAP system.
If you are interested in tables from other areas of SAP, we have chosen to divide the tables into the following groups. Please click on the group description to view each groups tables.
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.
