About SAP
http://sdn.sap.com
SPDD / SPAU
http://help.sap.com/saphelp_nw04/helpdata/en/83/7a18ecde6e11d195460000e82de14a/content.htm
ABAP Programming Reference
http://abapprogramming.blogspot.com/2007/07/lesson-36-program-interface.html
- 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
- 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
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.