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 [...]
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 [...]
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.
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.
SAP Note Number: 849089
Symptom
You have configured an SAP XI 3.0 / PI 7.0 J2EE File Adapter communication channel with the Transport Protocol set to “File Transfer Protocol (FTP)”. You are experiencing sporadic conectivity problems to the FTP server on the transport or network layer, which result in stalled TCP/IP connections and cause the FTP channel [...]
Functionality
You can use this method to create a material document for a goods movement. You can only create one material document each time you call up the method.
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.
Background jobs are scheduled using the transaction SM36 or SM36WIZ.
In the transaction SM37 you can modify already created jobs. You will also be able to check if the job is running without errors.
The Process code links the IDoc Logical Message and Basic Types to the function module that will process it. These can be viewed in WE64
You can also find inbound process codes for given message types in the table TMSG2.
Below you will find a short description of the standard movement types. The reversal movement type is the movement type + 1 (reversal of 101 = 102).
- a step-by-step approach
January 19th, 2008 Riyaz
This article will help you understand the basics of ALE and IDocs via a simple do-it-yourself example. We will create a custom IDoc in one SAP system and then post some business data through it to another SAP system. Business data will be picked up from custom data dictionary [...]
How to perform external DBLook-ups from XI utilizing J2EE JDBC Connector Service (pdf)
How to Re-Process failed XI Messages Automatically – by Naveen Pandrangi (PDF)
You can jump to any screen in the SAP system by entering a SAP transaction code into the command field on the standard toolbar. A transaction code is usually a four-character code that guides you directly to the screen for the task we want to perform.
Change pointers are R/3 objects that mark changes to SAP master data. The table BDCP is the primary change pointer data table while BDCPS contains the status (processed or unprocessed) of the change pointer record.
CD objects record the changes occurring to master data at a field level. These changes are stored in tables CDHDR and [...]
BAPI (Business Application Programming Interface) is a set of interfaces to object-oriented programming methods that enable a programmer to integrate third-party software into the proprietary R/3 product from SAP. For specific business tasks such as uploading transactional data, BAPIs are implemented and stored in the R/3 system as remote function call (RFC) modules.
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.
