SAP Tables & Views

Stock Tables and Stock Types

Feb 13th, 2011 | By Ole | Category: SAP Tables & Views

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

Read more...



Material Number Ranges and Formatting

May 30th, 2010 | By Ole | Category: Customizing, SAP ABAP, SAP Tables & Views, SAP Transaction Codes

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



Importing an Excel Sheet into an Internal Table

Nov 11th, 2009 | By Ole | Category: Featured, SAP ABAP, SAP Tables & Views

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



SAP Table Relations – MM – Classifications

Oct 31st, 2009 | By Ole | Category: Featured, SAP Tables & Views

 
 

Links between MARA, CRHD, MCH1, INOB, AUSP, CABN, CAWNT, CAWN, CABNT
Keyword: Characteristics

 
 
 
 
 

Read more...



Using ST05 to trace which tables a transaction is using

Oct 25th, 2009 | By Ole | Category: Featured, SAP Tables & Views, SAP Transaction Codes

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.

Read more...



Run a database query in ABAP with a join on 3 tables

Oct 24th, 2009 | By Ole | Category: Featured, SAP ABAP, SAP Tables & Views

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



SAP Table Relations – SD – Sales and Distribution

Oct 24th, 2009 | By Ole | Category: Featured, SAP Tables & Views

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

 
 
 
 
 

Read more...



Using an internal table in a ABAP query

Oct 24th, 2009 | By Ole | Category: Featured, SAP ABAP, SAP Tables & Views

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



SAP Table Relations – MM – Master Data

Oct 24th, 2009 | By Ole | Category: Featured, SAP Tables & Views

Links between MARC, MAKT, MLAN, MARA, T023, MBEW, MARM, T134

 

 

Read more...



SAP Info Structures (Tables)

Oct 24th, 2009 | By Ole | Category: SAP Tables & Views

List of standard SAP R/3 Info Structures. 

Read more...



SAP Table Relations – Goods Receipt

Oct 24th, 2009 | By Ole | Category: SAP Tables & Views

Links between EKBE, MKPF, MVER, MSEG, S011, S013, S031

 
 
 
 
 

Read more...



SAP Table Relations – Purchase Orders

Oct 24th, 2009 | By Ole | Category: Featured, SAP Tables & Views

Links between EKKO, EORD, EKKN, EKET, EKPO, EINA, EINE

Read more...



SAP Table Relations – Customer Master Data

Oct 24th, 2009 | By Ole | Category: Featured, SAP Tables & Views

Links between KNVP, KNA1, KNB1, KNVV, KNB5, KNVD, KNAS, KNVS

Read more...



SAP Table Relations – Vendor Master Data

Oct 24th, 2009 | By Ole | Category: Featured, SAP Tables & Views

Links between LFM1, LFA1, LFB1, LFM2, LFBK, LFB5

Read more...



SAP Table Relations – FI-CO Tables

Oct 24th, 2009 | By Ole | Category: Featured, SAP Tables & Views

Links between BSIP, PAYR, BVOR, BSIK, BKPF, BSET, BSEC, BSIS, BSAD, BSEG, BSID, BSAS, BSAK

Read more...



SAP Tables – Project Systems

Oct 18th, 2009 | By Ole | Category: SAP Tables & Views

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.

Read more...



SAP Tables – Joint Venture

Oct 18th, 2009 | By Ole | Category: SAP Tables & Views

If you are a developer writing ABAP programs using the Joint Venture (JV) tables, the following tables could be usefull.

Read more...



SAP Tables – Production Revenue Accounting

Oct 18th, 2009 | By Ole | Category: SAP Tables & Views

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

Read more...



SAP Tables – Production Planning

Oct 18th, 2009 | By Ole | Category: Featured, SAP Tables & Views

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.

Read more...



SAP Tables – Human Resources

Oct 18th, 2009 | By Ole | Category: Featured, SAP Tables & Views

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

Read more...



SAP Tables – Warehouse Management

Oct 18th, 2009 | By Ole | Category: SAP Tables & Views

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

Read more...



SAP Tables – Sales and Distribution

Oct 18th, 2009 | By Ole | Category: SAP Tables & Views

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.

Read more...



SAP Tables – Quality Management

Oct 18th, 2009 | By Ole | Category: SAP Tables & Views

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.  

Read more...



SAP Tables – Financial Accounting & Controlling

Oct 18th, 2009 | By Ole | Category: SAP Tables & Views

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

Read more...



SAP Tables – Material Management

Oct 18th, 2009 | By Ole | Category: Featured, SAP Tables & Views

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

Read more...



SAP Tables – EDI-ALE Related

Oct 18th, 2009 | By Ole | Category: SAP Tables & Views

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.

Read more...



SAP Tables – User & Role Administration

Oct 18th, 2009 | By Ole | Category: SAP Tables & Views

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.

Read more...



SAP Tables – Basis related tables & General tables

Oct 18th, 2009 | By Ole | Category: SAP Tables & Views

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.

Read more...



How to load data from two SAP tables into an internal table

Sep 27th, 2009 | By Ole | Category: Featured, SAP ABAP, SAP Tables & Views

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