SAP Related Tables

Tables Related SAP

Vendor:-

LFA1-Vendor Master (General Section)

LFB1-Vendor Master (company Code Section)

LFM1-Vendor purchasing organization

LFM2-Vendor Master Record: Purchasing Data

LFBK-Vendor Master (Bank Details)

Material Master Tables

MARA-General Material Data

MAKT-Material Descriptions

MARC-Plant Data for Material

MKPF-material document

MVKE-Material master, sales data

MSKA-Sales order stock

MSPR-Project stock

MBEW-Material valuation

MVER-Material consumption

MKPF-material document

Customer Master Tables

KNA1-Customer master

KNB1-Customer / company

KNVV-Customer sales data

KNBK-Bank details

KNVH-Customer hierarchy

Customer – material info record

KNMT-Customer material info record

Bank data

BNKA-Master bank data

Countries

T005-Countries

Currency

TCURC-Currency codes

TCURT-Currency name

Unit Of measure

T006-Units of measure

Calender

TFACD-Factory calendar definition

Definition

T880-Company

T001-Company Code

TKA01-Controlling Area

T001W-Plant / sales organisation

T499S-Locations

TSPA-Division

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

T001L-Storage locations

T024E-Purchasing organization

T3001-Warehouse number

TVST-Shipping point

TVLA-Loading point

TTDS-Transportation

Assignment

TKA02-company code to controlling area

T001K-plant to company code

TVKO-Sales organisation / company code

TVKOV-Distribution channel / sales organisation

TVKOS-Division to sales organization

TVTA-Sales Area

TVKBZ-Sales office to sales area

TVBVK-Sales group to sales office

TVKWZ-Plants to sales organization

T024E-Purchasing organization/company code

T024W-Plant to Purchase organization

TVSWZ-Shipping point to plant

T320-MM Storage Location to WM Warehouse

Sales Order

VBAK-Header data

VBAP-Item data

Financial

T004-Chart of accounts

T077S-Account group (g/l accounts)

TVFK-Billing doc types

T134-Material types

SKA1-Accounts

SNAP-Runtime errors

HR

T554T-Attendance and Absence Texts

T501-Employee group

T750X-Vacancy

T549A-Payroll Accounting Areas

Purchasing

EKKO-Purchase document

EKPO-Purchase document (item level)

EINA-Purchase info record (main data)

EBAN-Purchase requisition

EBKN-Purchase Requisition Account Assignment

EKKN-Account assignment in purchasing

Bill Of Material

STKO-BOM - header

STOP-BOM - item

STZU-Permanent BOM data

MAST-Material to BOM link

KDST-Sales order to BOM link

Project System

PROJ-Project definition

PRHI-WBS Edges (Hierarchy Pointer)

PRPS-WBS Element Master Data

RPSCO-info database: Costs, revenues, finances

MSPR-Project stock

LSMW-Step By Step Migration of Non-SAP Data to SAP Master Data

LSMW means Legacy System Migration Workbench

The LSMW is an R/3-based tool that Helps You when transferring data from non-SAP systems or Legacy Systems (Excel or Tally or tabular data) to R/3. Let’s Discuss Customer Master Data Migration.

Create an Object for Customer within Project as LSMW_DEMO and Subproject as CUSTOMERS and object of customer is CUST_OBJ.

 

Step 1: Maintain Object attributes

Select the methods from following details.

1. Standard Batch/Direct input: For batch Input Method: refer example like Equipment, Vendor, and Customer master. For direct input: Refer material master

2. Recording: Discuss later

3. BAPI: For upload of Purchase order .

4. IDoc: For upload of Service master

Choose radio-button Standard Batch/Direct Input as shown in Below Screenshot. Enter Object ‘0050’ for Customer Master Records and default method ‘0000’ and click on Save.

Step 2. Maintain Source Structures

While making structure you can create the structure as duplicate of standard structure as per following. Like copy from data repository e.g IBIPTLOP for task list operation. Unless you are very sure, make all source structure data type as ‘C’ means CHAR. If you are copying, you need to change the data type to ‘C’ manually.

Give a name and a description to the source structure as in below screenshot.

 

Step 3. Maintain Source Fields

 Fields with same names:

In this step, you need to list what fields are present in the source structure. The easiest way is to click on ‘Table Maintenance’ icon to enter Fieldname, Type and Length for each field .

 Step 4: Maintain Structure Relations.

 Create relationship between source structures XD02S with these target structures with icon ‘Create Relationship’

 

Step 5: Maintain field mapping and conversion rules

If a field is maintained in source structure, however do not have data in the excel sheet, due to which system gives error, make the filed initial in field mapping.

Please don’t change the field mapping without understanding the implication.

Auto filed mapping helps in mapping the source field and destination fields quickly if the source structure is made as a copy of Sap standard structure ( data repository).

-- Keep your cursor on ‘TCODE’ field and click on ‘Insert Rule’ icon 

Choose radio button ‘Constant’ (Figure 23) to enter value ‘XD02’ transaction code.

-- Keep your cursor on field ‘KUNNR’ and click on ‘Assign source field’ icon

Choose radio button ‘Constant’ (Figure 23) to enter value ‘XD02’ transaction code.

-- Keep your cursor on field ‘KUNNR’ and click on ‘Assign source field’ icon
Choose source field ‘Customer’ from source structure ‘XD02S’. 

Similarly, choose source fields for Sales Organization, Distribution Channel, and Division. 

Scroll down to structure BKNVV fields and assign source fields to three fields Sales Office, Sales Group, and Customer Group 

Save and go back to main screen

Step 6: Maintain fixed values, translations, user-defined routines

You can also maintain re-usable translations and user-defined routines, which can be used across conversion tasks. In this case, that step is not required

Step 7: Specify files

During specifying file(s), file path should not be very lengthy, keep delimiter as ‘Tabulator’ and File structure as ‘Field names at start of file’ and others setting as per standard.

In this step, we define how the layout of the input file is. The input file is a [Tab] delimited with the first row as field names. It is present on my PC (local drive) as C:\XD02.txt

 

Create an Excel file with your data and save it as a Tab-delimited text file on your local drive (C:\) and name it XD02.txt.

Step 8: Assign files

Please check all unassigned source field and ensure that these are OK except all source structure joining identifies like sequence number etc.

Don’t make as source structure filled like T code and Tabname as suggested by system. Like in case of task list, Material master you can use the T codes.

Execute step ‘Assign Files’ (Figure 15) and the system automatically defaults the filename to the source structure.

Step 8: Assign files

Please check all unassigned source field and ensure that these are OK except all source structure joining identifies like sequence number etc.

Don’t make as source structure filled like T code and Tabname as suggested by system. Like in case of task list, Material master you can use the T codes.

Execute step ‘Assign Files’ and the system automatically defaults the filename to the source structure.

 

Step 9: Read data

In this step, LSMW reads the data from the source file (from your PC’s local drive). You have the option to read only selected rows and convert data values to Internal format.

 

Step 10: Display read data

This step is optional. If required, you can review the field contents for the rows of data read.

Step 11: Convert data

This is the step that actually converts the source data (in source format) to a target format. Based on the conversion rules defined, source fields are mapped to target fields.

Step 12: Display Converted data

 When you convert data, LSMW automatically converts into the appropriate structure 

Step 13: Create batch input session

 

 

 

Step 14: Run Batch Input Session

 

we have successfully migrated data and you can confirm this by checking master records (XD03).

SU01 Create New User in SAP System

1. Insert TCODE - SU01 to Transaction Code Area on top Left of the screen.
2. Click Below Button
this is called create button.

3. Fill in all the required fields as User - User ID and Alias - Description
4. Fill in all the tabs password and last name are mandatory

5. In the "logon data" tab , choose the right user type.

For end users you should choose Dialog user

5. In "roles" tab, add roles to user. Tcodes for which user have authorization or you can use Profile for default Authorization. (Studied in PFCG)

If you want to give all authorizations, in "profile" tab add sap_all and sap_new profiles. These are default Profile defined in SAP.

SOX Complience - Company should follow for better business Process

SOX Complience:

Sarbanes – Oxley Act which was introduced as legislation in 2002 after a series of corporation financial scandals in the US.

Section 404 of the act related to the implementation and effectiveness of a corporations Internal Order.

In this Act they mainly focused on Four Points:

Entity wide control: Entity wide control focus on corporate governance and steering principles. They address the tone at the top and confirm that we work as we say we do.

Processes and Controls: Contains specific task that are performed as checks and balances with in individual business processes to help ensure the integrity and accuracy of financial Information.

Segregation of Duties: Segregation of duties refers to spreading activities including system access right and authorization between different people this minimizes potential instances of conflict and further enhances the copmpanies control structure.

IT General Control: Control & Secure Information and IT equipment within Company.

SAP Defined Keywords

SAP R/3 Keywords

SAP R/3 System has inoduced many Keywords. These

Keywords are frequntly used in SAP System Even In End-user Part also.

• ALE
  (Application Link Enabling) Application Link Enabling is the tool used for
  data migration Between two System either SAP Server at different location
  or any SAP System Or Client of SAP. This tool enables integration between
  two different systems for data exchange. It Provide full integration
  between two or more SAP R/3 Systems. This tool makes SAP System as
  distributed enterprise applications.  
• Application
  server In a client-server (SAP R/2/two-tier) environment, which means GUI
  (windows as user machine) & Server for Database Processing, the
  user's machine performs the business logic as well as the user interface,
  and the server provides the database processing. In a three-tier
  environment, an application server performs the business logic, may be
  some part can be handled by the user's machine. In three-tier environment
  Application Server provides middle processing between the user's machine
  and the database system that called as Database Management System like
  Oracle etc..
• Batch
  Input In SAP System Batch Input Refers as Batch Data Communication (BDC).
  It is the tool for entring the data using user input in screens of related
  transaction in SAP. After execute, screen of this processing are not
  displayed, but can be run in background.
• CATT
  (Computer Aided Test Tool) CATT Refers as Computer Aided Test Tool is used
  for creating automated test cases in SAP System. It is also used for
  upload or changing in master data of any SAP Module. This is used without
  user interaction.
• CCMS
  (Computer Center Management System) CCMS Stands for Computer Center
  Management System, is used for Monitoring, Controlling, & Configure
  the SAP System. This is also used for analyzing and distributes client
  workloads.
• Central
  System Central System is used to run both application and database on one
  computer.
• Client
  A client is the first field of data in tables that are not system-related.
  It is a grouping of data within one DBMS. In SAP System 800 is the default
  client for providing default database.
• Client/Server
  System Client Server System is also refered as Client Server Model is a
  distributed application that partitions tasks & work between
  Server(Provider of data) & Client(requester).
• Communication
  Server Communication Server is to establish connection between local
  system to server system. It can be either a router, a bridge or a gateway.
  

• Company code
  Company Code is the smallest organizational unit
  for which we can create a complete set of accounts which can be used for
  external accounting. Using this company code we can also create Balance
  sheet and profit and loss Accounts separately.
• CSP
  This is called as Complementary Software Program
  to their clients .
• Dispatcher
  The system R/3 Control Agent that manage all the
  resources present or new for the system.
• Ethernet
  Ethernet in nothing other that a Local Area
  Network using bus topology. The transmission speed is 10 MBPS.
• FDDI(Fiber Distributed Data Interchange)
  FDDI is the Local Network using ring Topology and light wave conductors.
  FDDI has transmission speed is 100 MBPS.
• Firewall
  Firewall is used for restricting access own network through public network.
  
• FTP(File Transfer Protocol)
  FTP is used for transferring file from one
  system to another using TCP.IP Protocol.
• GUI (Graphic User Interface)
  GUI is also called Graphical User Interface, it is used as front end for
  SAP environment.
• IDES(International Demonstration and Education System)
  IDES is the collection of application data for various business scenarios
  that can be run in the SAP System.
• IMG(Implementation Management Guide)
  It is a hierarchical structure that reflects the
  R/3 component hierarchy and contains every configuration activity.
• Instance
  It means application server and each one has its
  own set of work processes.
• IDoc(Intermediate Document)
  An IDoc is a data container for data exchange
  between SAP systems or between an SAP system and an external system.
  
• ITS(Internet Transaction Server)
  It links the R/3 application server with one or
  more Web servers, thus enabling the R/3 to communicate with the Internet.
  
• Number range
  A range of numbers that are laid down per file
  for the assignment of document numbers. It can be internal (carried out
  automatically by the system) or external (carried out manually by the
  user).
• OLE
  It is a technique introduced by Microsoft to
  incorporate objects of one application into another.
• OSS (Online Service System)
  SAP's Online Service System offers fast and
  effective help for R/3 System problems. It is also the basic element of
  communications between customers, partners, and SAP.
• RFC
  A way to implement communication between
  application programs via Abap/4 function call.
• Semaphores
  When a work process locks a resource, it sets a
  semaphore. Another work process that also wants to access it must then
  wait.
• SysID
  A set of three letters or number that identify a
  system. Some sets are not allowed because they are used by SAP. They are
  informed when the system is installed.
• Work process
  Work processes perform the bulk of the
  processing carried out by SAP systems. They perform dialog steps in user
  transactions and carry out updates, lock management, printing services,
  and so on.
• Workbench
  The ABAP/4 Workbench, a graphical programming
  environment, is used to create application programs. The programming tools
  are accessed using buttons, dialogs and windows.
• Workflow
  It consists of time and logical sequence of work
  items, which are processed by human agents or mechanical processing units.
• 
  

  Master Data: Data which seldom changes. data which will

  remain permanent and is less likely to change.

  Transaction Table: Data which frequently changes.

  
  

SAP Modules in Latest Version

Hi All,

Now we can discuss about different modules present in SAP System ECC 6.0 Version.
Currently we have 26 Modules as per my knowledge in SAP System. But mainly Company Uses few of the Modules Like FI, CO, MM, SD Etc.
Lets check Different Modules:

1.    SAP Basis 

2.   ABAP/4 Programming

3.    SAP Financial Accounting 

4.    SAP Controlling 

5.    SAP Enterprise Controlling 

6.    SAP Treasury 

7.    SAP Investment Management 

8.    SAP Human Resource 

9.    SAP Sales and Distribution 

10.   SAP Logistics Information System 

11.   SAP Materials Management 

12.   SAP Plant Maintenance 

13.   SAP Production Planning

14.   SAP Quality Management 

15.   SAP Business Warehousing 

16.   SAP Customer Service 

17.   SAP SMB 

18.   SAP Cross Application Components 

19.   SAP Project Systems

20.   SAP Supplier Relationship Management 

21.   SAP SEM

 22.  SAP Customer Relationship Management 

23.   SAP Product Life Cycle Management 

24.   SAP Supply Chain Management

25.   SAP Netweaver

 26.  SAP Industry Solutions