No categories
Useful SAP Related SitesThis is the list of SAP related sites I normally visit when I have an unanswered question. Specially the first one (SAP SDN) is worth a visit.
www.sdn.sap.com/irj/sdn
sapbrainsonline.com
www.sapdev.co.uk
www.sap-img.com
www.erpgenie.com
www.saptechies.com
www.abapmaster.com
www.abapprogramming.net
Recent Posts
About this Site
This is the SAP Blog by Ole Vedel . I have created it as a repository of SAP related information, supporting me in my daily job. When I began my carrier as a SAP developer, I often spend hours looking for information about a specific table or BAPI providing the functionality needed. To help others avoiding wasting the same amount of time as I did, I have made this Blog public.
Basis
In the following example we select some material data from the transparent table MARA and copy the result to the ...
In the example we will show how simple it is to import an Excel spreadsheet into an internal table. For the ...
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 ...
This code sample shows how to join three database tables in a select query. The result of the query are ...
Links between VAPMA, VKDFS, VEPVG, VAKPA, VBLB, VKDFS, VBAK, VBBE, STXH, VBUK, VBEP, VBUP, VBEH, VBAP, VBKD, LIPS, VBPA, VEKP, ...
In the following example we will populate an internal table and use it as an input to a database query. Define ...
Links between MARC, MAKT, MLAN, MARA, T023, MBEW, MARM, T134
Links between EKKO, EORD, EKKN, EKET, EKPO, EINA, EINE
Links between KNVP, KNA1, KNB1, KNVV, KNB5, KNVD, KNAS, KNVS
SAP ABAP
Material Number Ranges and FormattingMaterial 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 [...]
Change Pointers
Tables related to Change PointersChange 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 [...]
SAP Transaction Codes
Material Number Ranges and FormattingMaterial 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 [...]
EDI, ALE & IDOCs
Inbound & Outbound IDoc user exitsIntroduction:
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 [...]
Basis
Background JobsBackground 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.
SAP XI/PI
XI 3.0 / PI 7.0 File Adapter: FTP Timeout HandlingSAP 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 [...]
Function Modules & BAPI's
Complete list of BAPI’sBAPI (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.
Material Movements
Post goods movements with MB_CREATE_GOODS_MOVEMENTFunctionality
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.
SAP Tables & Views
Stock Tables and Stock TypesStock 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 [...]
Featured
Copying an Internal table to the ClipboardIn 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.
Links
Useful SAP Related SitesThis is the list of SAP related sites I normally visit when I have an unanswered question. Specially the first one (SAP SDN) is worth a visit.
www.sdn.sap.com/irj/sdn
sapbrainsonline.com
www.sapdev.co.uk
www.sap-img.com
www.erpgenie.com
www.saptechies.com
www.abapmaster.com
www.abapprogramming.net
Customizing
Material Number Ranges and FormattingMaterial 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 [...]
