SAP Tables-1

1      Customising

1.1      General settings

1.1.1        Countries

            T005                             Countries

1.1.2        Currency

            TCURC                         Currency codes

            TCURR                         Wisselkoersen

                TCURT                                  Currency name

            TCURX                         Decimal places for currencies.

1.1.3        Unit of measure

            T006                             Units of measure

1.1.4        Calendar functions

            T247                             Month names

            TFACD                         Factory calendar definition

            T015M                          Month names

            TTZZ                             Time zones

            TTZD                            Summer time rules

            TTZDF                          Summer time rules (fixed annual dates)

            TTZDV                          Summer time rules (variable dates)

            TTZDT                          Summer time rules texts

            TTZ5                             Assign Time Tones to Countries

            TTZ5S                           Assign time zones to regions

1.2      Enterprise structure

1.2.1        Definition

 FI   T880                             Company

T001                             Company code

CO   TKA01                          Controlling area

LO   T001W                          Plant / sales organisation

T499S                           Locations

TSPA                            Division

SD   TVKO                           Sales organisation / company code

       TVTW                           Distribution channel

       TVBUR                         Sales office

                TVKBT                                 Sales office text

       TVKGR                         Sales group

TVGRT                          Sales group text

T171T                           Sales district text

MM  T001L                           Storage locations

       T024E                           Purchasing organization

       T3001                           Warehouse number

       TVST                            Shipping point

       TVLA                            Loading point

       TTDS                            Transportation

1.2.2        Assignment

CO   TKA02                          Assign company code to controlling area

LO   T001K                           Assign plant (valuation area) to company code

SD   TVKO                           Sales organisation / company code

       TVKOV                         Distribution channel / sales organisation

       TVKOS                         Division to sales organization

       TVTA                            Sales aria

       TVKBZ                          Sales office to sales area

       TVBVK                         Sales group to sales office

       TVKWZ             Plants to sales organization

MM  T024E                           Purchasing organization / company code

       T024W                          Plant to Purchase organization

T001K                           Link plant ( = valuation area) / company code

TVSWZ                         Shipping point to plant

            T320                             Assignment MM Storage Location to WM Warehouse

1.3      Financial accounting

1.3.1        Company code

T004                             Chart of accounts

T077S                           Account group (g/l accounts)

T009                             Fiscal year variants

T880                             Global company data

T014                             Credit control area

1.3.2        Fi document

T010O                           Posting period variant

T010P                           Posting Period Variant Names

T001B                           Permitted Posting Periods

T003                             Document types

            T012                             House banks

1.4      Not categorized

            T007a                           Tax keys

            T134                             Material types

            T179                             Materials: Product Hierarchies

            T179T                           Materials: Product hierarchies: Texts

            TJ02T                           Status text

            TINC                             Customer incoterms

            TVFK                            Billing doc types

T390                             PM: Shop papers for print control

SAP EP Course Content

EP Administration Contents

Module 1:         Overview

Ø  Brief overview of SAP

Ø  Overview of SAP Netweaver and EP

Ø  Motivation for Portals and need for SAP EP

Module 2:         Technical Infrastructure

Ø  SAP Enterprise Portal installation

Ø  SAP NW Architecture

Ø  Portal Framework, Portal Runtime, Portal Services.

Ø  Building Blocks of SAP EP.

Ø  SAP Enterprise Portal Architecture

Module 3:         End user Perspective

Ø  Portal Login and Navigation

Ø  Portal Interface

Ø  Users, Roles and Groups.

Ø  Super Administration, User Administration, Content Administration

Ø  Portal Personalization

Module 4:         User Management

Ø  Overview and Architecture

Ø  User Management Engine.

Ø  User Management Tools

Module 5:         Portal Security

Ø  Security Concepts

Ø  Introduction to Authentication

Ø  Authorization Concepts

Ø  Single Sign On

Ø  Network Security

Module 6:         Portal Platform Content

Ø  Content Object Model

Ø  Portal Content

Ø  Portal Content Catalog

Ø  Portal Content Studio

Ø  Object relations: Delta Links and copies

Ø  Working with iViews and Pages

Ø  Working with Worksets and Roles

Ø  Delegated Content Administration

Ø  Introduction to business packages

Ø  Design Changes and Branding

Module 7:         Connectors

Ø  Portal Landscape

Ø  SAP Java Connector

Ø  Configuring of Java connector (JCO)

Ø  Integrating SAP systems

Module 8:         Knowledge Management & Collaboration

Ø  Understanding Knowledge Management

Ø  Content Management (CM)

Ø  Search and Classification (TREX)

Ø  Collaboration & Unification Overview

Ø  Collaboration Rooms (CR)

Ø  Real Time collaboration

EP Development Contents

Module 10:       SAP Java development environment

Ø  Sap Net Weaver developer studio

Ø  SAP Component Model

Module 11:       Web dynpro Introduction

Ø  Introduction to Web Dynpro Architecture

Ø  Web dynpro Tools

Ø  MVC-the roots of Web dynpro

Ø  Life cycle of web dynpro

Module 12:       The context structure at Design time

Ø  Types of nodes

Ø  The structure of context

Ø  Context mapping

Ø  Internal mapping

Ø  External mapping

Module 13:       The context structure at runtime

Ø  The typed context API

Ø  The Generic Context API

Module 14:       Introduction of UI elements

Ø  Putting data on Screen: Context binding

Ø  Controlling the behavior of UI Elements using the context binding

Ø  Using basic composite UI Element

Module 15:       Generic UI Services

Ø  Types of value help

Ø  Defining static Simple type containing value set

Ø  Simple value selector

Ø  Populating DDK UI Element

Ø  Extended value selector: Value help for using larger value sets.

Ø  Dynamic type modification: Modifying the value attribute’s data type programmatically

Module 16:       Dynamic UI generation

Ø  Introduction

Ø  Modification of the context & UI elements at runtime

Ø  The use of dynamic actions

Module 17:       The Adaptive RFC Layer

Ø  Remote invocation of ABAP functionality

Ø  The creation and management of Adaptive RFC model objects

Ø  The management use of adaptive RFC Model Objects.

Module 18:       Overview of Interactive Forms

Ø  Prerequisites

Ø  Introduction to Interactive forms

Module 19:       Overview of NWDI (Net weaver development infrastructure)

Module 20:       ESS/MSS

Module 21:        Web Page Composer Overview

SAP basis Course Content

BASIS Course content

1) SAP WebAs Architecture (ABAP +JAVA)

2) SAP Installation,configurations and Pre-requisites consider before proceeding for installation(On windows and Unix flavours)

3) Overview on supporting tools (Tools for starting installations and managing j2ee tools on Unix flavours)

4) System Refresh/system copy for Dual Stack systems,Single stack system

(ABAP+JAVA System,ABAP System)

5) Support Package Application- ABAP and Java

6) Kernel Upgrade on Windows and unix flavours

7) SAP J2EE Administration - visual adminstration,configtool admin,logviewer,J2ee

files structure,default traces checking,JSPM,SDM.

8) SLD Configuration & administration

9) Web services activation

10) SAP Solution Manager - Def system in landscape,creating and assigning logical components,EWA,Maintain optimizer (MOPZ),generation of Solution manager keys for Installations

11) Database administartion:-Oracle architecture,directory structure,BRTOOLS

administarton,Backups etc…

12) SAP Security - Users, Roles & profile Management , authorization administration

13) SAP Client Administration

14) SAP Performance Monitoring and tuning

15) SAP Transport Management

16) RFC Admin/Maintainance

17) SAP OSS(SMP) - Notes, Message Creation, license keys, developer key, S/W

Downloads,PAM,opening connections etc…

18) Commands on Unix flavours related for SAP Operations at OS level.