Google
 

Sunday, March 29, 2009

SAP FI Enterprise structure, AP, AR, GL and Bank Configuration and transaction tcodes

SAP FI Enterprise structure, AP, AR, GL and Bank Configuration and transaction tcodes with details:

Seq

T Codes

Configure Enterprise Structure

1

OX15

Define company

2

OX02

Define Compamny code

3

OB13

Edit Chart of Accounts

4

OB62

Assign Chart of Accounts to Company Code

5

OBD4

Define Account Groups

6

OB53

Define Retained Earnings

7

OB29

Define Fiscal Year Variant

8

OB37

Assign fiscal Year Variant to Company code

9

OBBO

Define Posting Period Variant

10

OB52

Define Open close Posting Period

11

OBBP

Assign Posting Period Variant to CompanyCode

12

FBN1

Create number range for Company code

13

OB63

Default Fiscal Year

14

OB68

Default Value Date

15

OBC4

Define Field Status Variant

16

OBC5

Assign Field Status Variant to Company code

17

OBA4

Define Tolerance for Employee Groups

18

OBA4

Assign user Tolerance group

19

OB64

Maximum Exchange Rate Difference

20

OBY6

Check co. code settings in global parameters

21

OX16

Assign Company code to Company

22

FS00

Create GL Acct in COA & Co. code

23

SPRO

Automatic clearing

24

OBXZ

Assigning accts for GL clearing diff

25

OBA1

Assign GL Accts for foreign currency valuation

26

OBYP

Define Adjustment for GR/IR clearing acct

27

SPRO

Define FSV

28

OB41

Define Posting Keys

29

OBYB

Integration with OH Cost Controlling

30

OBYC

Integration with material management

31

VKOA

Integration with Sales & Distribution

32

OBBG

Assign TAXINJ to country INDIA

33

OBYZ

Defining Condition Types

34

OBA7

Defining Document Types

35

OB71

Screen Variants for Document Entry

36

OBY2

Copying General Ledger Accounts to Company Code

37

OBD2

Defining Account Groups with Screen Layout

38

SM30

Check the Table TRWPR, TRWCA, TRWCI




Seq

TCODE

Configure / Customize Accounts Payable

1

OBD3

Define Acct group with screen layout (Vendors)

2

SPRO

Enter Acct clerk identification code for vendors

3

XKN1

Create number range for vendor accts

4

OBAS

Assign number range to Vendor Acct group

5

OBR2

Delete Vendor Master Data

6

SPRO

Maintain terms of Payment

7

SPRO

Define terms of payment for instalment payment

8

OBXU

Define Accts for cash discount taken

9

OB09

Define Accts for exchange rate diff

10

OB00

Define Accts for rounding differences

11

OBXK

Define acct for bank charges (vendors)

12

SPRO

Define Payment block reason

13

OBA3

Define Tolerance (Vendors)

14

OBXL

Define acct for payment diff ( manual outgoing)

15

FBZP

Set Up All Company codes for Payment Transactions

16

SPRO -FA-AR/AP-BT - OP-AOP-PM-Set up bank determination for PT

Set up bank determination for payment transactions

17

SPRO-FA-AR/AP-BT-Out going Invoices-Maintain Terms of Payment

Maintain terms of payments

18

SPRO-FA-AR/AP-BT-Out going Invoices-Define cash dis base for outgoing Invoices

Define Cash dis base for outgoing Invoices

19

OBXI

Define acct for cash dis granted

20

OBXR

Down Payment Received from customer

21

OBYR

Down Payment Made to vendors

22

OBYR

Vendor Down Payment Request

Seq

AP Transaction t Codes

1

FK01

Creating a vendor master Record

2

FB60

Post a Vendor Invoice

3

FB03

Displaying a Document

4

FB08

Reversing a vendor Invoice

5

F-53

Manual Payment to Vendor ( Against Invoice)

6

FK10N

Displaying Vendor Account balance

7

FBL1N

Displaying and changing line items in a Vendor account

8

F110

Automatic Payment Program


Seq

TCODE

Configure / Customize Accounts Receivable

1

OBD2

Define Acct group with screen layout (Customers)

2

SPRO

Enter Acct clerk identification code for customers

3

XDN1

Create number range for customer accounts

4

OBAR

Assign number range to Customer Acct group

5

OBR2

Delete Customer Master Data

6

OBA7

Define Document Types

7

OBA3

Define Tolerance and Customers

8

FS00

Create Recon account for Customers

9

OBYR

Define Alternative Recon Account for Down Payment

Seq

TCODE

AP Transaction t Codes

1

FD01

Creating a customer master record

2

F-22/ FB70

Posting a Customer Invoice

3

FB75

Posting a credit memo with ref. to Invoice

4

FB08

Reversing a document - Individual reversal

5

F-28

Posting customer incoming payment manually

6

FD10N

Displaying customer account balances.

7

FBL5N

Displaying and changing line items in a customer account

8

F-32

Clear open items. If the balance of the items to be cleared is not 0, you can create a residual item for overpayments/underpayments

9

F.13

Carrying out Automatic Clearing. To perform the Automatic Clearing System will compare the input values of Assignment, Business Area and Trading partner fields in addition to the amount. The input field values have to be the same in the both line items to perform the Automatic clearing




Seq

T Codes

Configure Bank

1

FI12

Define House Bank

2

SPRO - FA - BA - BT - PT - EBS - Make Global settings for EBS

Make Global settings for Electronic Bank Statement

3

SPRO - FA - BA - BT - PT - MBS - Create & Assign BT

Create and Assign Business Transactions

4

SPRO - FA - BA - BT - PT - MBS - Define variants for MBS

Define variants for Manual Bank statement

5

SPRO - FA - BA - BT - Check Deposit - Define Posting keys & Posting rules for check deposit

Define Posting keys & Posting rules for check deposit

6

SPRO-FA-BA-BT-Check deposit-Create & Assign BT

Create & assign business transactions

7

SPRO-FA-BA-BT-Check deposit-Define variant for check deposit

Define variants for check deposit

8

FS00

Create G/L Acct for cash journal

9

OBA7

Define Doc type for cash Journal doc, use SK

10

FBCJC1

Define no. range interval for cash journal doc

11

FBCJC0

Set up cash journal

12

FBCJC2

Create, change, delete BT for cash journal


Saturday, March 21, 2009

SAP Enterprise, Accounts Payable, Accounts Receivable & Bank Configuration

SAP Enterprise Structure, Accounts Payable, Accounts Receivable & Bank tcodes & details

Enterprise Structure

Seq

T Codes

Configure Enterprise Structure

1

OX15

Define company

2

OX02

Define Compamny code

3

OB13

Edit Chart of Accounts

4

OB62

Assign Chart of Accounts to Company Code

5

OBD4

Define Account Groups

6

OB53

Define Retained Earnings

7

OB29

Define Fiscal Year Variant

8

OB37

Assign fiscal Year Variant to Company code

9

OBBO

Define Posting Period Variant

10

OB52

Define Open close Posting Period

11

OBBP

Assign Posting Period Variant to CompanyCode

12

FBN1

Create number range for Company code

13

OB63

Default Fiscal Year

14

OB68

Default Value Date

15

OBC4

Define Field Status Variant

16

OBC5

Assign Field Status Variant to Company code

17

OBA4

Define Tolerance for Employee Groups

18

OBA4

Assign user Tolerance group

19

OB64

Maximum Exchange Rate Difference

20

OBY6

Check co. code settings in global parameters

21

OX16

Assign Company code to Company

22

FS00

Create GL Acct in COA & Co. code

23

SPRO

Automatic clearing

24

OBXZ

Assigning accts for GL clearing diff

25

OBA1

Assign GL Accts for foreign currency valuation

26

OBYP

Define Adjustment for GR/IR clearing acct

27

SPRO

Define FSV

28

OB41

Define Posting Keys

29

OBYB

Integration with OH Cost Controlling

30

OBYC

Integration with material management

31

VKOA

Integration with Sales & Distribution



Accounts Payable

Seq

TCODE

Configure / Customize Accounts Payable

1

OBD3

Define Acct group with screen layout (Vendors)

2

SPRO

Enter Acct clerk identification code for vendors

3

XKN1

Create number range for vendor accts

4

OBAS

Assign number range to Vendor Acct group

5

OBR2

Delete Vendor Master Data

6

SPRO

Maintain terms of Payment

7

SPRO

Define terms of payment for instalment payment

8

OBXU

Define Accts for cash discount taken

9

OB09

Define Accts for exchange rate diff

10

OB00

Define Accts for rounding differences

11

OBXK

Define acct for bank charges (vendors)

12

SPRO

Define Payment block reason

13

OBA3

Define Tolerance (Vendors)

14

OBXL

Define acct for payment diff ( manual outgoing)

15

FBZP

Set Up All Company codes for Payment Transactions

16

SPRO -FA-AR/AP-BT - OP-AOP-PM-Set up bank determination for PT

Set up bank determination for payment transactions

17

SPRO-FA-AR/AP-BT-Out going Invoices-Maintain Terms of Payment

Maintain terms of payments

18

SPRO-FA-AR/AP-BT-Out going Invoices-Define cash dis base for outgoing Invoices

Define Cash dis base for outgoing Invoices

19

OBXI

Define acct for cash dis granted

20

OBXR

Down Payment Received from customer

21

OBYR

Down Payment Made to vendors

22

OBYR

Vendor Down Payment Request



Accounts Receivables

Seq

TCODE

Configure / Customize Accounts Receivable

1

OBD2

Define Acct group with screen layout (Customers)

2

SPRO

Enter Acct clerk identification code for customers

3

XDN1

Create number range for customer accounts

4

OBAR

Assign number range to Customer Acct group

5

OBR2

Delete Customer Master Data

6

OBA7

Define Document Types

7

OBA3

Define Tolerance and Customers

8

FS00

Create Recon account for Customers

9

OBYR

Define Alternative Recon Account for Down Payment




Bank Customization

Seq

T Codes

Configure Enterprise Structure

1

FI12

Define House Bank

2

SPRO - FA - BA - BT - PT - EBS - Make Global settings for EBS

Make Global settings for Electronic Bank Statement

3

SPRO - FA - BA - BT - PT - MBS - Create & Assign BT

Create and Assign Business Transactions

4

SPRO - FA - BA - BT - PT - MBS - Define variants for MBS

Define variants for Manual Bank statement

5

SPRO - FA - BA - BT - Check Deposit - Define Posting keys & Posting rules for check deposit

Define Posting keys & Posting rules for check deposit

6

SPRO-FA-BA-BT-Check deposit-Create & Assign BT

Create & assign business transactions

7

SPRO-FA-BA-BT-Check deposit-Define variant for check deposit

Define variants for check deposit

8

FS00

Create G/L Acct for cash journal

9

OBA7

Define Doc type for cash Journal doc, use SK

10

FBCJC1

Define no. range interval for cash journal doc

11

FBCJC0

Set up cash journal

12

FBCJC2

Create, change, delete BT for cash journal

Saturday, March 14, 2009

SAP Tcodes in for Enterprise structure configuration

SAP Tcodes for basic FI configuration in the required order

Seq

T Codes

ENTERPRISE STURCTURE

1

OX15

Define company

2

OX02

Define Company code

3

OB13

Edit Chart of Accounts

4

OB62

Assign Chart of Accounts to Company Code

5

OBD4

Define Account Groups

6

OB53

Define Retained Earnings

7

OB29

Define Fiscal Year Variant

8

OB37

Assign fiscal Year Variant to Company code

9

OBBO

Define Posting Period Variant

10

OB52

Define Open close Posting Period

11

OBBP

Assign Posting Period Variant to Company Code

12

FBN1

Create number range for Company code

13

OB63

Default Fiscal Year

14

OB68

Default Value Date

15

OBC4

Define Field Status Variant

16

OBC5

Assign Field Status Variant to Company code

17

OBA4

Define Tolerance for Employee Groups

18

OBA4

Assign user Tolerance group

19

OB64

Maximum Exchange Rate Difference

20

OBY6

Check co. code settings in global parameters

21

OX16

Assign Company code to Company

22

FS00

Create GL Acct in COA & Co. code

23

SPRO

Automatic clearing

24

OBXZ

Assigning accts for GL clearing diff

25

OBA1

Assign GL Accts for foreign currency valuation

26

OBYP

Define Adjustment for GR/IR clearing acct

27

SPRO

Define FSV

28

OB41

Define Posting Keys

29

OBYB

Integration with OH Cost Controlling

30

OBYC

Integration with material management

31

VKOA

Integration with Sales & Distribution


Sunday, March 08, 2009

SAP Financial Accounting Configuration

Financial Accounting Configuration

Financial Accounting Global Settings

Maintaining Fiscal Year Variant

Use

Fiscal year contains the number of Periods that are followed in the Accounting year of the Company and to prepare the Balance Sheet and Profit and Loss account for reporting.

Procedure

Define Fiscal Year is having the following steps:

  • Maintain Fiscal Year Variant
  • Assign Company Code to a Fiscal Year Variant

The following is the IMG path to maintain this activity

Transaction Code

SPRO or OB29



Assigning Company Code to a Fiscal Year Variant

Use

Fiscal year contains the number of Periods that are followed in the Accounting year of the Company and to prepare the Balance Sheet and Profit and Loss account for reporting. The Fiscal year variant need to be assigned to the Company Code

Procedure

  1. The following is the IMG path to maintain this activity

Transaction Code

SPRO or OB37

  1. On the Change View "Assign Company Code -> Fiscal Year Variant": Overview screen, make the following entries:

Field name

Description

R/O/C

User action and values

Note

CoCd

Company Code Key

R

BP01

Defaulted

Company Name

Name of the Company Code

R

India Best Practices Ltd

Defaulted

Fiscal Year Variant

Fiscal Year Variant

R

V3

Select the Fiscal year variant V3

Description

Description of Fiscal year Variant

R

Apr.- March, 4 special periods

Defaulted from Fiscal Year Variant V3



Defining Variants for Open Posting Periods

Use

By using the posting period variant, the posting to the periods and General Ledger Accounts can be controlled by opening or closing the periods.

Procedure

Posting Period variant is having the following steps:

  • Define Variants for Posting Periods
  • Open Close Posting Periods
  • Assign Variants to Company Code


  1. The following is the IMG path to maintain this activity

Transaction Code

SPRO or OBBO

  1. On the Define Variants for Open Posting Periods screen, make the following entries.

Field name

Description

R/O/C

User action and values

Note

Variant

Variant Key

R

BP01

Enter the input value

Name

Name of the Variant

R

India Best Practices-PP. Variant

Enter the input value

  1. To save the entries use save icon or press Ctrl+S.

Results

You have maintained the Posting Period Variant BP01



Opening and Closing Posting Periods

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OB52

  1. On the Open and Close Posting
    Periods screen, make the following entries.

Var.

A

Fr.A/c

To

A/c

Fr

Per1

Year

To

Per2

Year

Fr.

Per2

year

To

Per2

year

Au Gr.

BP01

+

1

2003

12

2010

13

2003

16

2003

BP01

A

zzzzzzzzzz

1

2003

12

2010

13

2003

16

2003

BP01

D

zzzzzzzzzz

1

2003

12

2010

13

2003

16

2003

BP01

K

zzzzzzzzzz

1

2003

12

2010

13

2003

16

2003

BP01

M

zzzzzzzzzz

1

2003

12

2010

13

2003

16

2003

BP01

S

zzzzzzzzzz

1

2003

12

2010

13

2003

16

2003

  1. To save the entries use save icon or press Ctrl+S.

Results

You have maintained the allowable posting periods for the Variant - BP01





Assigning Variants to Company Code

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OBBP

  1. On the Assign Variants to Company Code screen, make the following entries.

Field name

Description

R/O/C

User action and values

Note

CoCd

Company Code Key

R

BP01

Variant

Posting Period Key

R

BP01

  1. To save the entries use save icon or press Ctrl+S.

Results

You have assigned the Posting Period Variant BP01 to the Company Code BP01.


Defining Document Number

Use

The document number is the key the SAP R/3 system to access the accounting document posted in the system.

The document number is unique per Company Code and Fiscal Year. When entering an accounting document, via Document Type system will assign the Document number.

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or FBN1

  1. On the Numbers Ranges for Accounting Documents screen, enter the Company Code BP01 and select the Change Intervals push button.
  2. On the Maintain Number Range Intervals screen, make the following entries by selecting Insert Interval pushbutton or press Shift+F1. Insert the row one after another row.

No

Year

From No.

To No.

External

00

2003

100000

999999

01

2003

100000000

199999999

02

2003

200000000

299999999

03

2003

300000000

399999999

X

04

2003

400000000

499999999

05

2003

500000000

599999999

12

2003

1200000000

1299999999

13

2003

1300000000

1399999999

14

2003

1400000000

1499999999

15

2003

1500000000

1599999999

16

2003

1600000000

1699999999

17

2003

1700000000

1799999999

18

2003

1800000000

1899999999

19

2003

1900000000

1999999999

20

2003

2000000000

2099999999

47

2003

4700000000

4799999999

48

2003

4800000000

4899999999

49

2003

4900000000

4999999999

50

2003

5000000000

5099999999

51

2003

5100000000

5199999999

X1

2003

9100000000

9199999999

X2

2003

9200000000

9299999999

JV

2003

1000000

1099999

CR

2003

1100000

1199999

CP

2003

1200000

1299999

B0

2003

1300000

1399999

B1

2003

1400000

1499999

B2

2003

1500000

1599999

B3

2003

1600000

1699999


Document number ranges are to be maintained as year dependent enters the Fiscal Year, '2003'.

Fiscal year 2004 (i.e.1st April 2004 to 31st March 2005) year dependent document number range will be maintained as follows:

No

Year

From No.

To No.

External

01

2004

100000000

199999999

02

2004

200000000

299999999

  1. To save the entries use Save on the Maintain Number Range Intervals screen or Ctrl+S,



Defining Document Types

Use

Document types differentiate business transactions and control document filing. Document numbers are chosen from this number range key specified in Document Type. Number range Key contains the Number Series. Document Type also controls the accounting area that can be posted by using the Document Type.

Prerequisites

If any change to the Document Number series that need to be defined in the Define Document Number activity.

Procedure

  • To see the list of document types in system, choose one of the following navigation options:

Transaction Code

SPRO or OBA7



Defining Maximum Exchange Rate Difference per Company Code

Use

In this activity you can define the maximum difference between exchange rates for postings in foreign currency transactions.

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OB64

IMG Menu

Financial Accounting ® Financial Accounting global settings ® Document ® Document Header ® Maximum Exchange rate difference ® Define Maximum Exchange Rate Difference Per Company Code

  1. On the Change View "Maximum Difference Between Exchange Rates": Overview screen, make the following entries.

Field name

Description

R/O/C

User action and values

Note

CoCd

Company Code Key

R

BP01

Company Name

Name of the Company

R

India Best Practices Ltd

City

City of Company

R

Bangalore

Max. Exch. rate Dev.

Maximum Exchange Rate Deviation

O

10%

Input the Value as 10%. If the deviation is more than 10% system will give the warning message


  1. To save the entries use save icon or press Ctrl+S.


Maintaining Field Status Variants

Use

In this activity you can define variants and field status groups. Group several field status groups together in one field status variant. The field status group determines which fields are ready for input, which are required entry fields, and which are hidden during document entry. Fields status group will be assigned to General Ledger Account Master Record while creating the GL Account.

Procedure

Maintain Field Status Variant is having the following steps

  • Define Field Status Variant
  • Add Field Status Groups under the Field Status Variant


  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OBC4

IMG Menu

Financial Accounting ® Financial Accounting global settings ® Document ® Line items ® Controls ® Maintain field status variants

  1. On the Change View Field Status Variants: Overview screen, select the 0001 – Field Status for 0001 and use the copy icon to copy the field Status Variant to BP01 and change the description as Field status for BP01.
  2. Select Copy all option on the pop screen to copy all the Field Status groups also to the variant BP01.
  3. The following Field Status Groups has been displayed by the system in the Change View "Field Status Groups:" Overview screen
  4. To save the entries use save icon or press Ctrl+S.



Assigning Company Code to Field Status Variant

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OBC5

  1. On the Assign Company Code to Field Status Variant screen, make the following entries.

Field name

Description

R/O/C

User action and values

Note

CoCd

Company Code Key

R

BP01

Defaulted

Company Name

Name of the Company Code

R

India Best Practices Ltd

Defaulted

City

R

Bangalore

Defaulted

Fld stat. var.

Field Status Variant Key

O

BP01

Assign the Field Status Variant which is maintained


Screen Variants for Document Entry

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OB71

  1. On the Screen Variants for Document Entry screen, make the following entries.

Field name

Description

R/O/C

User action and values

Note

CoCd

Company Code Key

R

IERP

Screen Variant

Screen Variant key defined in the system

O

2

For countries where withholding tax is applicable, to display withholding tax details screen at the time of transaction



Defining Tolerance Groups for Employees

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OBA4

IMG Menu

Financial Accounting ® Financial Accounting global settings ® Document ® Line items ® Define Tolerance Groups for Employees

  1. On the Change view "FI Tolerance Groups for Users": Overview screen, select New Entries push button.
  2. On the New Entries: Details of Added Entries screen, make the following entries

Field name

Description

R/O/C

User action and values

Note

Group

O

Keep blank. No value to be entered

Company code

R

BP01 - India Best Practices Ltd

Currency

O

INR

Defaulted from Company Code

Amount per document

O

9,999,999,999.00

Amount per open item account item

O

9,999,999,999.00

Cash discount per line item

O

5.000%

Amount

O

Revenue: 5.00

Expense: 5.00

Percent

O

Revenue: 2.0%

Expense: 2.0%

  1. To save the entry use Save icon or press Ctrl+S.



Enabling Fiscal Year Default

Use

In this activity you can define that the fiscal year is proposed during document display and for document change functions. The system uses the year which was last used by the user in the work session.

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OB63

IMG Menu

Financial Accounting ® Financial Accounting global settings ® Document ® Default Values for Document Processing ® Enable Fiscal Year Default

  1. On the Change View "Default Fiscal year": Overview screen, enter the following values:

Field name

Description

R/O/C

User action and values

Note

Company Code

Company Code Key

R

BP01

Defaulted

Propose Fiscal Year

Propose Fiscal Year

O

Activate the Check Box

Select the check box to propose the Fiscal Year during the document processing

  1. To save the entries use save icon or press Ctrl+S.



Default Value Date

Use

In this activity you define, when entering line items, you may need to enter a value date. In this activity you can determine, per company code, whether the CPU date is defaulted as the value date. If you activate, system will propose the CPU date as Value Date during the document entry.

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OB68

IMG Menu

Financial Accounting ® Financial Accounting global settings ® Document ® Default Values for Document Processing ® Default Value Date


  1. On the Change View "Default Fiscal year": Overview screen, enter the following values:

Field name

Description

R/O/C

User action and values

Note

Company Code

Company Code Key

R

BP01

Defaulted

Company Code Name

Name of the Company Code

R

India Best Practices Ltd

City

Name of the City

R

Bangalore

Propose Value Date

Propose Value Date

R

Activate the Check Box

Select the check box to propose the Value Date during the document entry

  1. To save the entries use save icon or press Ctrl+S.





Entering Global Parameters

Use

The purpose of this activity is to maintain the global parameters for TAN and PAN number of the Company Code BP01 as allotted by the statutory authorities.

TDS No and PAN No. are assigned in the Additional Details.

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OBY6

IMG Menu

Financial Accounting
®
Financial Accounting Global Settings
®
Company Code
®
Enter Global Parameters

  1. Select the BP01 Company code row on 'Change View"Company Code Global Data": Overview' screen select details Icon to enter the Global Parameters.
  2. On the Change View "Company Code Global Data": Details ,
  3. On the Maintenance of Additional Data for Company Code BP01 screen
    make the following entries.

Field name

Description

R/O/C

User action and values

Note

TDS No

Income Tax TAN number

O

-

Company's TAN to be maintained

PAN No

Income Tax Permanent Account Number

O

.

Company's PAN number to be maintained

GIR No

Income Tax GIR Number

O

  1. Press green arrow (back button) to leave the screen.
  2. Use Save

    to save the entry


General Ledger Accounting

Editing Chart of Account List

Use

Chart of Account is an index of General Ledger Accounts Master. The Accounts required to be posted in the Company Code need to be maintained in the Chart of Account. CAIN - Chart of accounts – India is being defined in Standard SAP R/3 system. Same being used for the Company BP01.

Procedure

  1. Check for the following parameters for the Chart of Accounts CAIN.

Transaction Code

SPRO or OB13

IMG Menu

Financial Accounting ® General Ledger Accounting ® G/L Accounts ® Master Records ® Preparations ® Edit Chart of Account List

  1. On the Change View "List of All Chart of Accounts": Overview screen select the CAIN press the Details icon or Ctrl+Shift+F2 and check for the following details and if required make necessary modification to the values:

Field name

Description

R/O/C

User action and values

Note

Chart of Accts

Chart of Account ID

R

CAIN

Description

Chart of Account Description

R

Chart of accounts - India

Maintain Language

Chart of Account maintenance language

R

EN – English

Check for the Maintenance Language and change if required to English

Length of GL account number

No of Digits of GL Account Code

R

8

Check for the No. of Digits for the GL Accounts length, if required change to 8

Controlling Integration

Creation of Cost Element

R

Manual Creation of Cost Elements

Group Chart of Accts

Assignment of Group Chart of Account

O

Status-Blocked

Blocking for creation of new GL Accounts

O

Unchecked

  1. To save the change, if any, use Save icon or press Ctrl+S.



Assigning Company Code to Chart of Accounts

Procedure

  1. To carry out the activity
    choose one of the following navigation options:

Transaction Code

SPRO or OB62

IMG Menu

Financial Accounting ® General Ledger Accounting ® G/L accounts ® Master Records ® Preparation ® Assign company code to chart of accounts

  1. On the "Change view "Assign Company Code -> Chart of Accounts": Overview screen, make the following entries.

Field name

Description

R/O/C

User action and values

Note

Company Code

Company Code

R

BP01

Display

Company name

Company Code Description

O

India Best Practices Ltd

Display

City

City

O

Bangalore

Display

Chrt/Accts

Chart of Accounts

O

CAIN

Input the Value

Cty Ch/ Act

Country specific Chart of Accounts

O

Leave Blank

  1. To save input entry use Save icon or use Ctrl + S.



Defining Account Group

Use

When creating a G/L account, you must specify an account group. The account group determines:

  • the interval in which the account number must be
  • which fields are required and optional entries when creating and changing master records
  • which fields are suppressed when creating and changing master data.

Prerequisites

The Accounts Groups are Chart of Account dependent. The chart of accounts must be specified in the Chart of Account List.

Procedure

For the Company Code BP01, Chart of Account CAIN – Chart of Account for India, is being used, which is already defined in the standard SAP R/3 System.

Hence these steps no need to carry out.

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OBD4

IMG Menu

Financial Accounting ® General Ledger Accounting ® G/L accounts ® Master Records ® Preparations ® Define account group

  1. The following entries maintained for Chat of Account CAIN on 'Change View"G/L Accounts Groups": Overview' screen.

Chart of Account

Account Group

Name

From Account

To Account

CAIN

AS

Fixed assets accounts

99999999

CAIN

CASH

Liquid funds accounts

99999999

CAIN

GL

General G/L accounts

99999999

CAIN

MAT

Materials management accounts

99999999

CAIN

PL

Income statement accounts

99999999

CAIN

RECN

Recon. account ready for input

99999999



Defining Retained Earnings Account

Use

You assign a retained earnings account to each P&L account by specifying a P&L statement account type in the chart of accounts area.

At the end of a fiscal year, the system carries forward the balance of the P&L account to the retained earnings account. Retained Earnings Account is specific to the Chart of Account.

Prerequisites

Retained Earnings Account is specific to the Chart of Account. The chart of accounts must be specified in the Chart of Account List.

Procedure

For the Company Code BP01, Chart of Account CAIN – Chart of Account for India, is being used, which is already defined in the standard SAP R/3 System.

Hence these steps no need to carry out.

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OB53

IMG Menu

Financial Accounting ® General Ledger Accounting ® G/L accounts ® Master Records ® Preparations ® Define Retained Earnings Account

  1. The following entries maintained for Chat of Account CAIN on 'Maintain FI Configuration: Automatic Posting – Accounts' screen.

Field name

Description

R/O/C

User action and values

Note

Chart of Accounts

Chart of Accounts

C

CAIN

Enter Chart of Account CAIN

Transaction

Transaction

C

BIL

Defaulted and in display

P & L statement Account Type

Symbol to identification of P & L statement Account Type

R

X

Will be assigned to all Expenses and Revenue GL Accounts

Account

General Ledger Account

R

900000

System will carry forward the Profit or Loss to next financial year via this account



Copying General Ledger Accounts to Company Code

Use

All the General Ledger Accounts will be copied from source Company Code to Target Company Code.

Prerequisites

No G/L accounts may exist in the target company code.

Procedure

  1. To carry out the activity
    choose one of the following navigation options:

Transaction Code

SPRO or OBY2

IMG Menu

Financial Accounting ® General Ledger Accounting ® G/L accounts ® Master Records ® GL Accounts Creation and Processing ® Alternative Methods
®
Copy GL Accounts
®
Copy Company Code

  1. On the "Copy Company Code: G/L Accounts" screen, make the following entries.

Field name

Description

R/O/C

User action and values

Note

Company Code

Target Company Code

R

BP01

Input BP01

Copy from Company name

Source Company Code

O

IN01

Input IN01

Test Run

O

Check in the Test run by activating the Check box.

  1. Check the activity in the Test Run by activating the check box and Execute icon or press F8.
  2. See the result on the "Copy Company Code: G/L Accounts" screen, the list of General Ledger accounts to be copied from Reference Company Code IN01.
  3. Use Back arrow or press F3 to leave the screen and to go to the previous screen Copy Company Code: G/L Accounts initial screen.
  4. Remove the test run check box and Execute the activity or press F8.
  5. System will give you information message "You are making a Production run"
  6. Press enter to proceed with activity.




Defining Accounts for Exchange Rate Differences

Use

The purpose of this activity is to post automatically the realized exchange rate differences when clearing the open items.

In clearing open items, the system posts any realized gains or losses (realized exchange rate differences).

Prerequisites

Define necessary GL Accounts, Reconciliation accounts and Exchange Gain and Loss accounts to assign. The assignment is specific to Chart of Account CAIN.

Procedure

The assignment is specific to Chart of Account CAIN. The necessary Account assignment has been made in Standard SAP R/3 system.


  1. To see the account assignment, choose one of the following navigation options:

Transaction Code

SPRO or OB09

IMG Menu

Financial Accounting ® General Ledger Accounting ® Business transactions ® Open item clearing ® Define accounts for exchange rate differences

  1. For the following Accounts Exchange Gain or Loss Account assignment has been made for the Chart of Account CAIN on the "Change View "Acct Determination for OI Exch. Rate Differences": Overview, screen:

GL Account

Currency

Currency Type

13110000

13111000

13112000

24430000

24431000

24432000

24433000

  1. For each GL Account the following account has been made in the "Change View "Acct Determination for OI Exch. Rate Differences": Detail screen

Nature of Assignment

Activity

GL Account

Exchange Rate Difference Realized

Loss

58240000

Exchange Rate Difference Realized

Gain

44020000

Valuation

Value Loss1

58241000

Valuation

Value Gain 1

44401000

Valuation

Balance Sheet Adj. 1

30091000

Translation

Loss

58242000

Translation

Bal. Sheet adj. Loss

30091000

Translation

Gain

44402000

Translation

Bal. Sheet adj.gain

30091000



Tolerances for Groups of G/L Accounts

Use

For General Ledger account clearing, Tolerance Groups Defines the limits within which differences are accepted and automatically posted to predefined accounts.

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OBA4

IMG Menu

Financial Accounting ® General Ledger Accounting ® Business Transactions ® Open Item Clearing ® Clearing Differences ® Define Tolerance Groups for G/L Accounts

  1. On the Tolerances for Groups of G/L Accounts screen, make the following entries.

Field name

Description

R/O/C

User action and values

Note

Company Code

Company Code

R

BP01

Tol. Group

Tolerance Group

O

Debit

Debit Amount

O

1

Difference Rs.1/- can be allowed

Credit

Credit Amount

O

1

Difference Rs.1/- can be allowed

PerD

% of Debit

O

1%

1% difference can be allowed

PerC

% of Credit

O

1%

1% difference can be allowed

O

  1. To save the entry use Save icon or press Ctrl+S.



House Banks

Defining House Bank

Use

Each Bank is represented by House Bank ID in the SAP system and every account at a house bank by an account ID.

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or FI12

IMG Menu

Financial Accounting ® Bank Accounting ® Bank Accounts ® Define House Banks

  1. Enter company code BP01.
  2. On the Change View "House Banks": Details screen, select the New Entries push button and enter the following entries

Field name

Description

R/O/C

values

Note

House Bank

House Bank

R

SBI

Assumed SBI As house Bank

Bank Country

Bank Country

O

IN

Country of House Bank India

Bank Key

House Bank Key

O

SBI

Uniquely identified for each House Bank

  1. Select the Create button on New Entries: Details of Added Entries' screen for house bank SBI as entered in the previous step and enter the following values:

Field name

Description

R/O/C

User action and values

Note

Bank Name

House Bank Name

R

State Bank of India

Name of the House Bank – SBI

Region

Region of House Bank

O

10

Select the Region of the bank based on the address

Street

Street of House Bank

O

M G Road

Enter the Street name of the bank

City

City of the House Bank

O

Bangalore

Enter the City of the House bank

Bank Branch

Bank Branch

O

MG Road Branch

Enter the Bank Branch

  1. To save the entry use the Save icon or use Ctrl+S.
  2. Use Green arrow or press F3 and you are in Change View "House Banks": Overview screen
  3. Select the House bank ID and double click on the Bank Accounts
  4. To enter the Bank Accounts use New Entries push button Change View "Bank Accounts": Overview screen and maintain the following values:

Field name

Description

R/O/C

User action and values

Note

Company Code

Company Code

R

BP01

House Bank

House Bank

O

CITI

Account ID

Account ID in the House Bank

O

CITI

Description

Account Description

O

CITI Bank Current Account

Bank Account Number

Account number at Bank Branch

O

045

Currency

Account Currency

O

INR

GL Account

GL account for the Bank Account

O

Assign the GL Account to post the Bank account entries

Discount Account

GL to post Discount

O

Assign the Discount Account to post the Discounts

  1. To save the entry use the Save icon or use Ctrl+S.
  2. To maintain the additional House Banks and House Bank Accounts repeat the above step no 3 to step no.9 (Example House Bank ID - CITI and House Bank Account ID – CITI).



Financial Accounting AR/AP – Customer Accounts

Defining Account Groups with Screen Layout (Customers)

Use

When creating a Customer account, an account group must be specified. The account group determine.

  • The interval for the customer account numbers
  • Whether the number is assigned internally by the system or externally by the user (type of number assignment)
  • Whether it is a one-time account
  • Which fields are ready for input or must be filled when creating and changing master records (field status)

The fields are grouped as General Data, Company Code Data and Sales Data.

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OBD2

IMG Menu

Financial Accounting ® Account Receivable and Accounts Payable ® Customer Accounts ® Master Records ® Preparations for creating customer master records ® Define account groups with screen layout

  1. On the Define Account Groups with Screen Layout screen, make the following entries.

Field name

Description

R/O/C

User action and values

Note

Account group

R

0009

Name

O

Sold-to party- IN

One-time account

O

Un-checked

Output determ.proc.

O

Blank

  1. To select the field status, select the General data and press Edit Field Status push button on the "Maintain Field Status Group: Overview" screen.
  2. System will display fields groups under General Data on the Maintain Field Status Group: Overview screen.

    Address

    Communication

    Control

    Marketing

    Payment Transactions

    Unloading points

    Contract Person

    Foreign Trade


    Under Company Code data the following Groups are displayed

    Account Management

    Payment Transactions

    Correspondence

    Insurance

    Withholding tax data, w/h Tax2


    Under Sales data the following Groups are displayed

    Sales

    Shipping

    Billing

    Partner usage

    Documents

  3. The following field options has been changed from Default (optional) in the Maintain Field Status Group: screen each group wise:

Data

Group

Field

Changed Status

Note

General Data

Address

Name 1/ Last name

Req. Entry

Search Term

Req. Entry

Postal Code City

Req. Entry

Transportation Zone

Req. Entry

Communication

Tele box

Suppress

Data line

Suppress

Control

Reference account group (OTA)

Suppress

CFOP category

Suppress

Brazilian taxes: ICMS,IPI,S.T.

Suppress

Marketing

Hierarchy Assignment

Suppress

Payment Transactions

DME details

Suppress

Company Code Data

Account Management

Reconciliation Account

Req. Entry

Preference indicator

Suppress

Release Group

Suppress

Gross Income Tax

Suppress

Payment Transactions

Terms of payment

Req. Entry

Credit memo terms of payment

Suppress

Diff. payer in document

Suppress

Sales Data

Sales

Pricing procedure

Req. Entry

Currency

Req. Entry

Shipping

Shipping condits/POD relevance

Req. Entry

Rail specifications

Suppress

Billing

Taxes and licenses

Req. Entry

  1. To save the entries use Save icon or use Ctrl+S.



Assigning Number Ranges to Customer Account Groups

Use

The number key number series (Internal or external assignment), which will be assigned to the Customer Account Groups. While creating the Customer Master Record, you will be using the Account Group. System automatically recognizes the number series linked to the account group.

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OBAR

IMG Menu

Financial Accounting ® Account Receivable and Accounts Payable ® Customer Accounts ® Master Records ® Preparations for creating customer master records ® Assign Number Ranges to Customer Account Groups

  1. On the Change View "Assign Customer Acct Groups -> Number Range": Overview screen, make the following entries.

Field name

Description

R/O/C

User action and values

Note

Group

Account Group

R

0009

Defaulted

Name

Description of Account Group

O

Sold-to-party-IN

Defaulted

Number range

Number Range Key

O

XX

'XX' is the key is having the Alphanumeric External number assignment

  1. To save the entry use Save icon or use Ctrl+S.




Financial Accounting AR/AP – Vendor Accounts

Defining Account Groups with Screen Layout (Vendors)

Use

When creating a vendor account, an account group must be specified. The account group determine

  • The interval for the account numbers
  • Whether the number is assigned internally by the system or externally by the user (type of number assignment)
  • Whether it is a one-time account
  • Which fields are ready for input or must be filled when creating and changing master records (field status)

The fields are grouped as General Data, Company Code Data and Purchasing Data.

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OBD3

IMG Menu

Financial Accounting ® Account Receivable and Accounts Payable ® Vendor Accounts ® Master Records ® Preparations for creating vendor master records ® Define account groups with screen layout (Vendors)

  1. On the Change View "Vendor Account Groups": Overview screen, select the New Entries push button and make the following entries.

Field name

Description

R/O/C

User action and values

Note

Account Group

Name Key of Account Group

R

BP01

Name

Description of Account Group

O

Vendor for BP01-(External No.)

One Time Account

Is the Account group relevant for One time Vendors

O

Unchecked

  1. To select the field status, select the General data and press Edit Field Status push button on the "Maintain Field Status Group: Overview" screen.
  2. System will display fields groups under General Data on the Maintain Field Status Group: Overview screen.

    Address

    Communication Data

    Control

    Payment Transactions

    Contract Person

  3. Under Company Code data the following Groups are displayed

    Account Management

    Payment Transactions

    Correspondence

    Withholding tax data, w/h Tax2

  4. Under Purchasing data the following Groups are displayed

    Purchasing data

    Partner usage

    Add. Purchasing data

  5. The following field options has been changed from Default (optional) in the Maintain Field Status Group: screen each group wise:

Data

Group

Field

Changed Status

Note

General Data

Address

Name 1

Req. Entry

Search Term

Req. Entry

Postal Code City

Req. Entry

Communication

Tele box

Suppress

Data line

Suppress

Language

Req. Entry

Company Code Data

Account Management

Reconciliation Account

Req. Entry

Sort Key

Req. Entry

Preference indicator

Suppress

Gross Income Tax

Suppress

Payment Transactions

Terms of payment

Req. Entry

Credit memo terms of payment

Suppress

Alternative payee in document

Suppress

Correspondence

Bank Statement

Suppress

Purchasing

Purchasing data

Purchase order currency

Req. Entry

Vendor schema group

Req. Entry

Pricing hierarchy

Suppress

  1. To save the entry use Save icon or use Ctrl+S


Assigning Number Ranges to Vendor Account Groups

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OBAS

IMG Menu

Financial Accounting ® Account Receivable and Accounts Payable ® Vendor Accounts ® Master Records ® Preparations for creating vendor master records ® Assign number ranges to vendor account groups

  1. On the Change View Assign Number Ranges to Vendor Account Groups -> screen, make the following entries

Field name

Description

R/O/C

User action and values

Note

Group

Group Key name

R

BP01

Name

Description of the Account Group

O

Vendor for BP01-(External No.)

Number Range

Number Range Key

O

XX

XX is number range key defined in the Standard SAP R/3 system for External number assignment

  1. To save the entry use Save icon or use Ctrl+S

    Financial Accounting AR/AP – Business Transactions

    Defining Tolerances (Vendor)

Use

The purpose of this activity is to define tolerances, which are used for dealing with differences in payment and residual items, which can occur during payment settlement.

Procedure

  1. To carry out the activity, choose one of the following navigation options:

Transaction Code

SPRO or OBA3

IMG Menu

Financial Accounting ® Account Receivable and Accounts Payable ® Business Transactions ® Outgoing Payments ® Manual outgoing Payments ® Define Tolerances (Vendors)

  1. On the Change View "Customer / Vendor Tolerances": Overview screen, select the New Entries:

Field name

Description

R/O/C

User action and values

Note

Company code

R

BP01

Currency

O

INR

Default from the Company Code

Tolerance group

O

Keep Blank

Specifications for clearing procedures

Grace days due date

O

Blank

Cash discount terms displayed

O

Blank


Permitted payment differences

Amount

Percent

Adjust discount by

Gain

999.0

10.0 %

2%

Loss

5.00

0.5 %

2%


Field name

Description

R/O/C

User action and values

Note

Specifications for posting residual items from payment differences

Payment term from invoice

O

Blank

Fixed payment term

O

Blank

Only grant partial cash disc

O

Checked

Dunning key

O

Blank



Tolerances for payment advice

Amount

Percent

Outst.receiv.from


Outst.payable from

  1. To save the entries use save icon or use Ctrl+S.




Summary Table


Activity

Explanation

TC

Data

Maintaining Fiscal Year Variant

Fiscal year contains the number of Periods that are followed in the Accounting year of the Company and to prepare the Balance Sheet and Profit and Loss account for reporting. For the Company Code AUM, Fiscal Year, V3 – April - March, 4 special periods is being used, which is already defined in the standard SAP R/3 System

OB29

Assigning Company Code to a Fiscal Year Variant

Assigning Company Code to a Fiscal Year Variant

OB37

Assign Fiscal year variant V3 to Company code IERP

Define Variants for Open Posting Periods

By using the posting period variant, the posting to the periods and General Ledger Accounts can be controlled by opening or closing the periods

OBBO

Variant : IERP
Name : India Best Practices

Opening and Closing Posting Periods

Opening and Closing Posting Periods