SAP

About SAP
http://sdn.sap.com

SPDD / SPAU
http://help.sap.com/saphelp_nw04/helpdata/en/83/7a18ecde6e11d195460000e82de14a/content.htm

SAP Notes

ABAP Programming Reference
http://abapprogramming.blogspot.com/2007/07/lesson-36-program-interface.html

  1. ERP Upgrade and Unicode Conversion for ABAPers

Presentation and links provide insight into conversion.
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/media/uuid/10f86c6c-5f9e-2a10-0c95-ea04acb55051

  1. Loading the SAP Note

http://help.sap.com/saphelp_nw04/helpdata/en/7c/04f33925f12d20e10000000a114084/content.htm

SAP Best Practices for IAS and IFRS
(International Accounting Standards & International Financial Reporting Standards)
http://help.sap.com/bp_iasifrsv1470/html/index_EN_DE.htm

To change the default client
login/system_client = your_default_client

Get the Download Manager
http://service.sap.com/download-basket
Click the button Get the download manager.
Follow the Instructions.

SAPTutor 2.1 and Vista Compatibility
SAP Notes: 1071313 (Expected Q1/Q2 of 2008)
Currently we are working on the development of this compatiabality. The release of the same is estimated between Q1 and Q2 of 2008.
This note would be kept updated on any changes in this regard
(Checked on 30 May 2008; No changes on this note yet.)
SAP Notes: 888226 (for Patches for SAP Tutor 2.1)
(Checked the notes again on 21 Jun 2008; The notes could not be found.)

In one of the forums, somebody suggested to do this and confirmed by others that it is working on Vista.
Windows Explorer —> folder c:\PlayerIE right click on file iTutorplayer.EXE —> Properties —> compatibility tab —> select compatibility mode = Windows XP SP2, save and play your tutors.

Reference
http://www.allinterview.com/showqa/MM/page5.html
http://www.allinterview.com/showqa/SAP/page64.html
https://www.sdn.sap.com/irj/sdn/message?messageID=3182735

Webcasts
http://www12.sap.com/community/events/events_listing.epx

MM Tables

Sr. Table Name Description
1 A501
1 AUSP Material - Special
2 EBAN Link PR - PO
2 EBEW SO Stock valuation
3 EBKN Pur Req.
4 EINA PIF
5 EINE PIF
6 EKAB Contract
7 EKBE Purchasing Document
8 EKET PO Delivery
9 EKKN Link SO - PO
10 EKKO PO head
11 EKPO PO line
12 IKPF Phy Inventory
13 ISEG Phy Inventory
14 LFA1 Acc Vendor/Creditor
15 LFB1 Acc Vendor/Creditor
16 MAKT Material Description
17 MARA Master
18 MARC Matl MRP…
19 MARD Stock
35 MARM Alt UOM
20 MAST No data
21 MBEW Matl - Acc related - MAP
22 MKPF Stock related
23 MOFF
24 MSEG Stock related
24 MSKA SO Stock related
24 MSSAH SO Stock transit batch
25 MVER
26 MVKE MM Sales Org Tab
27 NRIV
28 RESB
29 RKPF
30 T023 Matl Groups
31 T024
32 T156 Mvt Types
32 T156T Mvt Types Text
33 T157H
34 T161T
36 T179 Prod Hier

SD Tables

Sr. Table Name Description
1 CDHDR Changes Header
1 CDPOS Changes Detail
1 KLPA
2 KNA1 customer
3 KNB1 customer
4 KNB4
5 KNB5
6 KNBK
7 KNKA
8 KNKK
9 KNOP
10 KNOV
11 KNVD
12 KNVI
13 KNVP
14 KNVS
15 KNVV
16 LIDP
17 LIKP
18 LIPS ?delivery
18 MSKAH SO Stock Batch No.
19 VBAK SO
20 VBAP SO
21 VBBE Sch Agreement VA33
22 VBEH N/A
23 VBEP
24 VBEP
25 VBFA delivery qty…
26 VBKD line; exrate; pricing date;
27 VBLB
28 VBLK
29 VBPA Partner
30 VBRK
31 VBRP Status of SO
32 VBUK
33 VBUP Status?
34 VEKP
35 VEPO
36 VEPVG
36 PA0002 Sales staff

FI Tables

Sr. Table Name Description
1 BVOR x
2 BSAD Cleared AR
3 BSID Open AR
4 BSIS Open GL
5 BSAS Cleared GL
6 BSAK Cleared AP
7 BSIK Open AP
8 BSIP
9 PAYR
10 BKPF
11 BSEG
12 BSET GST

CO Tables

Sr. Table Name Description
1 CE1xxxx COPA details
2 CE2xxxx
3 GLPCA Actual
4 GLPCP Planning

http://www.sap-img.com/financial/important-tables-in-sap-fi.htm

Mini SAP License extension Procedure

Ref:
http://zieglers.wordpress.com/2006/10/27/licensing-procedure-for-the-mini-sap-system/

Request at http://www.sap.com/minisap
User ID: BCUSER
System: MBS SAP R/3 4.6D

Hardware code:
c:\mbs\saplicense -get

MBS is not running, during the installation of license.

P.S. If, somehow you get an error saying as follows:

* SAPLICENSE (Release 46D) ERROR *
ERROR: Can not set DbSl trace function
DETAILS: DbSlControl(DBSL_CMD_IMP_FUNS_SET) failed with return code 20
RC-INFO: error loading dynamic db-library - check environment for:
dbms_type = <db-type> (e.g. ora)
DIR_LIBRARY = <path to db-dll> (e.g. /usr/sap/SID/SYS/exe/run)

all you need to do is to execute,

dbenv.cmd

and then execute saplicense -install.
system ID = MBS
Installation Number = DEMOSYSTEM

ABAP Objects (Keller)
http://www.booksites.net/download/abap_objects/download.htm

DB2
http://www.databasejournal.com/features/db2/article.php/3732726

SAP Tutorials
Upgrade
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/media/uuid/504f6de3-2cbd-2a10-ce87-86e0c5b5c573

http://www.saptutorials.com/

SD Book On line
http://www.scribd.com/doc/431288/SD-Glynn-Williams?ga_related_doc=1

Reference
How to find bapi
http://www.sap-img.com/abap/how-to-find-bapi-for-particular-transaction-in-sap.htm

BAPI step by step
http://www.sap-img.com/abap/bapi-step-by-step-guidance.htm

ABAP - BASIS Example
http://www.sap-basis-abap.com/sapabap.htm

SQL
… WHERE cityto IN ('BERLIN', 'NEW YORK', 'LONDON').

… WHERE cityto LIKE '%town'. (for one char use _ instead of %).

SELECT-OPTIONS:
s_carrid FOR wa_sflight-carrid NO INTERVALS NO-EXTENSION.

… WHERE carrid IN s_carrid.

FORM getdata.
SELECT matnr matkl meins
FROM mara
INTO TABLE itab2
for all entries in itab
WHERE mara~matnr = itab-matnr.

Internal Tables

READ TABLE itab INDEX idx {INTO wa | ASSIGNING <fs>}.

READ TABLE itab WITH TABLE KEY comp1=f1 … compn =fn
{INTO wa|ASSIGNING <fs>}.

DELETE TABLE itab INDEX idx.
DELETE TABLE itab FROM key.
(Ref: p180 of HorstKeller book)

MODIFY itab FROM line INDEX idx.
MODIFY itab FROM line. (This will search the table with the key from line and change it.)
MODIFY itab FROM line TRANSPORTING comp1 … compn WHERE logical_expression.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License