cancel
Showing results for 
Search instead for 
Did you mean: 

cin

Former Member
0 Kudos

can any one provide me links to cin notes.......

regards

venu mg

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Got the Notes

Former Member
0 Kudos

***CIN CONFUGURATION***

1.1 Maintain Excise Registration

SAPSPRO Basic settingIndia  tax on Goods Movements Logistics general Ref. IMG Maintain Excise Registrations

APPLICABLE

1.2 Maintain Company Code Settings

tax on Goods Logistics general  SAP Ref. IMG SPRO Maintain Company Code Basic setting India Movements Settings

APPLICABLE

1.3 Maintain Plant Settings

SAP Ref.SPRO  Basic setting India  tax on Goods Movements Logistics general IMG Maintain Plant Settings

APPLICABLE

1.4 Maintain Excise Groups

SPRO BasicIndia  tax on Goods Movements Logistics general  SAP Ref. IMG  Maintain Excise Groupssetting

APPLICABLE

1.5 Maintain Series Groups

India  tax on Goods Movements Logistics general  SAP Ref. IMG SPRO Maintain Series GroupsBasic setting

APPLICABLE

1.6 Maintain Excise Duty Indicators

tax on Goods Logistics general  SAP Ref. IMG SPRO Maintain Excise Duty Basic setting India Movements Indicators

APPLICABLE

1.7 Maintain Sub transaction Type with Text

India  tax on Goods Movements Logistics general  SAP Ref. IMG SPRO Maintain Sub transaction Type with TextBasic setting

APPLICABLE

1.8 Determination of Excise Duty

tax Logistics general  SAP Ref. IMG SPRO Select Tax Calculation Determination of Excise DutyIndia on Goods Movements Procedure

APPLICABLE

1.9 Maintain Excise Defaults

SAP Ref.SPRO Determination of ExciseIndia  tax on Goods Movements Logistics general IMG Maintain Excise DefaultsDuty

APPLICABLE

1.10 Condition-Based Excise Determination

tax on Goods Logistics general  SAP Ref. IMG SPRO Define Tax Code for Condition-Based Excise DeterminationIndia Movements Purchasing Documents

APPLICABLE

1.11 Condition-Based Excise Determination

tax on Goods Logistics general  SAP Ref. IMG SPRO Assign Tax Code to Condition-Based Excise DeterminationIndia Movements Company Codes

APPLICABLE

1.12 Classify Condition Types

SAPSPRO Condition-BasedIndia  tax on Goods Movements Logistics general Ref. IMG Classify Condition TypesExcise Determination

APPLICABLE

1.13 Maintain Chapter IDs

tax on Goods Logistics general  SAP Ref. IMG SPRO Maintain Chapter ids Master dataIndia Movements

APPLICABLE

1.14 Assign Users to Material Master Screen Sequence for Excise Duty

SPRO  Master dataIndia  tax on Goods Movements Logistics general SAP Ref. IMG Assign Users to Material Master Screen Sequence for Excise Duty

APPLICABLE

1.15 Specify Excise Accounts per Excise Transaction

tax on Goods Logistics general  SAP Ref. IMG SPRO Specify Excise Accounts per Excise Account determinationIndia Movements Transaction

APPLICABLE

1.16 Specify G/L Accounts per Excise Transaction

tax on Goods Logistics general  SAP Ref. IMG SPRO Specify G/L Accounts per Excise Account determinationIndia Movements Transaction

APPLICABLE

1.17 Incoming Excise Invoices

SAPSPRO BusinessIndia  tax on Goods Movements Logistics general Ref. IMG Incoming Excise InvoicesTransactions

APPLICABLE

1.18 Define Processing Modes Per Transaction

 Logistics general  SAP Ref. IMG SPRO Define Processing Modes Business TransactionsIndia tax on Goods Movements Per Transaction

APPLICABLE

1.19 Define Reference Documents Per Transaction

tax on Goods Logistics general  SAP Ref. IMG SPRO Define Reference Documents Per Business TransactionsIndia Movements Transaction

APPLICABLE

1.20 Maintain Rejection Codes

SAPSPRO BusinessIndia  tax on Goods Movements Logistics general Ref. IMG Maintain Rejection CodesTransactions

APPLICABLE

1.21 Specify Which Movement Types Involve Excise Invoices

Logistics SAP Ref. IMG SPRO Specify Which Business TransactionsIndia  tax on Goods Movementsgeneral Movement Types Involve Excise Invoices

APPLICABLE

1.22 Outgoing Excise Invoices

tax on Goods Logistics general  SAP Ref. IMG SPRO Assign Outgoing Excise Invoices  Business TransactionsIndia Movements Billing Types to Delivery Types

APPLICABLE

1.23 Maintain Default Excise Groups and Series Groups

 Logistics general  SAP Ref. IMG SPRO  Outgoing Excise Invoices  Business TransactionsIndia tax on Goods Movements Maintain Default Excise Groups and Series Groups

APPLICABLE

1.24 Subcontracting Attributes

tax on Logistics general  SAP Ref. IMG SPRO Subcontracting Subcontracting Business TransactionsIndia Goods Movements Attributes

APPLICABLE

1.25 Maintain Movement Type Groups

SPRO BusinessIndia  tax on Goods Movements Logistics general SAP Ref. IMG Subcontracting SubcontractingTransactions Attributes

APPLICABLE

1.26 Utilization Determination

SAPSPRO BusinessIndia  tax on Goods Movements Logistics general Ref. IMG Utilization UtilizationTransactions Determination

APPLICABLE

1.27 Specify SAP script Forms

SPRO BusinessIndia  tax on Goods Movements Logistics general SAP Ref. IMG Specify SAP script Excise RegistersTransactions Forms

APPLICABLE

1.28 Number Ranges

 SAP Ref. IMG SPRO Number ToolsIndia  tax on Goods MovementsLogistics general Ranges

APPLICABLE

1.29 Message Control

 SAP Ref. IMG SPRO Message ToolsIndia  tax on Goods MovementsLogistics general Control

APPLICABLE

J1I2

Prepare a sales tax register

J1I3

Create outgoing excise invoices in batches

J1I5

Update the RG 1 and Part I registers

J1IEX

Incoming Excise Invoices (central transaction)

J1IEX_C

Capture an incoming excise invoice (excise clerk)

J1IEX_P

Post an incoming excise invoice (excise supervisor)

J1IF01

Create a subcontracting challan

J1IF11

Change a subcontracting challan

J1IF12

Display a subcontracting challan

J1IF13

Complete, reverse, or recredit a subcontracting challan

J1IFQ

Reconcile quantities for subcontracting challan

J1IFR

List subcontracting challan

J1IH

Make a CENVAT adjustment posting

J1IIN

Create an outgoing excise invoice

J1IJ

Assign excise invoices to a delivery for sales from depots

J1INJV

Adjust withholding tax Item

J1INREP

Reprint a withholding tax certificate for a vendor

J1IQ

Year-End Income Tax Depreciation Report

J1IR

Download register data

J1IS

Process an excise invoice (outgoing) for other movements

J1IU

Process exemption forms

J1IW

Verify and post an incoming excise invoice

J1IX

Create an incoming excise invoice (without reference to purchase order)

J2I8

Transfer excise duty to CENVAT account

J2IU

Remit excise duty fortnightly

J2I9

Monthly CENVAT return

J1IG

Excise invoice entry at depot

J1IGA

Create additional excise entry at depot

J2I5

Extract data for excise registers

J2I6

Print excise registers

**************************************************************************************************************************************************

Basically CIN is divided in to two types:

1. TAXINJ - Is a Routine Based that is used in the condition types. it will work on the logic what ever is there in the Routine.

2. TAXINN: - Is a condition Record based. Means we have to create condition records for each and every condition type that you are going to use in the Pricing Procedure.

Since Version 4.7 this TAXINN came into picture and start using this.

And one of the important point is since 4.6 c CIN comes a separate package. But after introduction of 4.7 Version, CIN is coming the SAP Package itself and even in the Customer Master Record also we will find the CIN Icon.

Also see this link

http://help.sap.com/saphelp_47x200/helpdata/en/5a/d34a9f544811d1895e0000e8323c4f/frameset.htm

CIN Setting:

Check Calculation Procedure

In this activity, you can check and, if necessary, change existing procedures for tax calculation.

Standard settings

Calculation procedures containing the necessary specifications for the calculation and posting of taxes on sales/purchases have already been defined in the standard SAP system for certain countries. Every calculation procedure groups several tax types together into a condition type (for example, output tax or input tax) in the calculation procedure, and determines calculation rules for it.

The calculation procedure determines for which amount the individual condition types are to be calculated. This can be the base amount (total of the expense items and the revenue items) or a subtotal. The entry in column FrmLvl, determines for which amount tax is calculated.

Note

In this activity, the condition types for the check and the possible change provided in the standard system are also displayed. Here, for example, the condition calculation rule, or for which base amount the tax is calculated is determined (= condition type).

Recommendation

If possible, do not change the condition types and calculation procedures provided in the standard system. Only check the standard condition types and calculation procedures regarding whether you can use them for your requirements. If necessary, make changes.

Activities

If you cannot use the standard settings, change the condition types and calculation procedures delivered to meet your requirements.

Procedure (pricing, output control, acct. det., costing,...)

Specifies the conditions that are allowed for a document and defines the sequence in which they are used.

Example

Procedures are used, for example, in the following applications:

u2022 Pricing in sales and distribution

u2022 Applying overhead in Product Costing (costing sheets) and for CO internal orders

u2022 Calculating accrued costs in Profitability Analysis

u2022 Output control (printed confirmations, EDI messages, electronic mail)

u2022 Account determination

u2022 Calculating taxes on sales/purchases

u2022 Calculating accruals in Cost Center Accounting

u2022 Pricing for resource planning

Definition: condition type

Controlling (CO)

A distinction, in overhead calculation, is made between:

u2022 Base condition types, which determine the object for which the overhead is to be calculated

u2022 Overhead condition types, which define the percentage overhead to be applied

In resource planning, a condition type determines the types of resource prices that are stored in the SAP System. These can be absolute or percentage values, for example.

Real Estate Management (RE)

An exact definition of a condition that specifies the amount paid for a specific service.

Condition types include:

u2022 Basic rent

u2022 Advance payment for operating costs

u2022 Pest control

Sales and Distribution (SD)

A characteristic of a condition.

For example, in pricing, different condition types are used to distinguish between a discount that refers to a net price and a discount that refers to a gross price.

Treasury (TR)

A characteristic of a condition used to classify financial transactions.

Typical examples of condition types are interest, dividends, or full repayment upon maturity. The various parameters specified for the individual condition types determine how the flows are calculated in the cash flow.

Return ->

Definition: condition_type

Condition type

The condition type is used for different functions. In pricing, for example, the condition type lets you differentiate between different kinds of discount; in output determination, between different output types such as order confirmation or delivery note; in batch determination, between different strategy types.

Access sequence

With the access sequence you define

u2022 the condition tables used to access the condition records

u2022 the sequence of the condition tables

u2022 which field contents are the criteria for reading the tables

Assign Country to Calculation Procedure

In this activity, you enter the key for the calculation procedure which determines the conditions which are allowed per document and which defines the sequence of the conditions in the document for each country.

Requirements

Each calculation procedure which you enter must contain the necessary specifications for calculating and posting the taxes on sales/purchases. For more information on this, read the chapter "Create calculation procedure".

Activities

1. Assign a procedure for tax calculation to every country with which your company has business dealings.

2. Make sure that the corresponding data for calculating taxes is stored for each calculation procedure which you enter here.

Check and Change Settings for Tax Processing

In this activity you make the necessary specifications for posting taxes. In doing this you specify under a process key the following indicators:

u2022 Tax type

Output tax, input tax, additional taxes, or "not tax-relevant" can be specified as the tax type.

u2022 Nondeductibility of tax amounts

For this, tax amounts are marked as not deductible.

u2022 Posting indicator

Here you specify whether the tax amount is posted separately or distributed to expense or revenue items.

u2022 Tax not relevant to cash discount (Not discount relevant)

This indicator is set only for Canada. If you select it, the system does not take into account the corresponding tax amount when determining the tax base.

Standard settings

Process keys with the most important characteristics for tax amounts have already been set in the standard SAP system.

Recommendation

Do not change the standard settings. Check whether you can use these process keys for your company, making changes only if necessary.

Activities

If you cannot use the standard settings, use new process keys and enter them in your calculation procedure. Do not change the standard SAP process keys.

Note

You must make enhancements to the standard settings if you want to specify a new account key in the "Create calculation procedure" activity. You must create and maintain this key beforehand in the "Settings for tax processing" activity.

Internal processing key

The internal processing keys are used by the system to determine accounts or posting keys for line items which are created automatically.

The processing keys are defined in the system and cannot be changed by the user.

Definition: posting key

Financial Accounting (FI)

A two-digit numerical key that determines the way line items are posted.

This key determines several factors including the:

u2022 Account type

u2022 Type of posting (debit or credit)

u2022 Layout of entry screens

Return ->

Definition: posting_key

Maintain Excise Registrations

Use

In this IMG activity, you maintain the data relating to your excise registrations.

Activities

Enter each of your excise registrations, specifying a four-character code for each.

Definition: excise registration

Financial Accounting (FI)

An entity in India that is entitled by law to produce any goods liable to excise.

Each entity is assigned its own excise registration number.

Every factory that manufactures excisable goods is required to register separately, so that a business with seven factories requires seven registrations.

Return ->

Definition: excise registration

Maintain Company Code Settings

Use

In this IMG activity, you maintain the data relating to your company codes.

Maintain Plant Settings

Use

In this IMG activity, you maintain excise information relating to your plants.

Maintain Excise Groups

Use

In this IMG activity, you define your excise groups. For each excise group, you can also control how various excise invoice transactions will work.

Definition: excise group

Financial Accounting (FI)

A unit within an excise registration, in India, which keeps its own set of excise records.

Whereas the excise registration reports to the excise authorities, the excise group is a purely internal organizational unit. Each excise group keeps records of all transactions that have to be reported to the excise authorities. When the time comes to present these records to the authorities, the excise registration compiles the information from all of its excise groups.

Return ->

Definition: excise group

Maintain Series Groups

Use

In this IMG activity, you define the different excise series groups within your company. Series groups allow you to maintain multiple number ranges for the outgoing excise documents.

Based on excise regulations and exemptions from the authorities you can maintain multiple number series for outgoing documents. But each of these series has to be declared to the excise authorities.

Activities

u2022 Define excise series groups based on type of outgoing document

u2022 Assign series group to excise registration ID

u2022 If no financial postings are required for an Excise invoice in this seris group then you tick the 'No utilization' indicator.

u2022 If the CENVAT has to be paid immediately and you need not wait for the Fort nightly payment then mark the 'Immediate Utilization' indicator.

Example

You could define two series groups, group 001 for excise invoices, and group 002 for 57 F4 documents.

Maintain Excise Duty Indicators

Use

In this IMG activity, you maintain the excise duty indicators.

Maintain Postal Addresses

Use

In this IMG activity, you maintain the addresses of various customs and excise organizations that your company deals with.

You use these addresses in the ARE Documents functions. When you create an ARE-1 or ARE-3, you enter the address of the excise department and the customs department involved in the export process. The system then prints their names and addresses on the AREs.

You can then define a default local excise department for each excise group and a default customs department for each series group.

Definition: ARE-1 document

Logistics - General (LO)

A form, in India, that companies have to fill out when they remove excisable goods from their manufacturing plants for export.

The form exempts them from paying excise duty when they remove the goods from their premises.

Return ->

Definition: ARE-1 document

Definition: ARE-3 document

Logistics - General (LO)

A form, in India, that allows companies to sell otherwise excisable goods from their premises without paying basic excise duty. The buyer of the goods must be in possession of a deemed export license.

The ARE-3 states what goods are being removed and which deemed excise license covers it.

Return ->

Definition: ARE-3 document

Maintain Subtransaction Type with Text

Sub Transaction Type

Sub transaction type is used for multiple purposes

Subcontracting:

It determines the subcontracting attributes and determines the accounts for the posting while doing a sub contracting transaction.

Excise removals

Sub transaction type is also used for determining the accounts while doing excise removals.

With in CIN the account determination is based on the transaction type. So normally you can have a single set of accounts for Excise utilization. In case you need alternate account determination for handling various scenarios you can define sub transaction types. The sub transaction types and corresponding account assignments needs to be maintained in CIN customization

Select Tax Calculation Procedure

Use

In this IMG activity, you specify which tax procedure you want to use for determining excise duties and sales taxes on input materials in India.

u2022 If you use condition-based excise determination, use a copy of the tax procedure TAXINN.

u2022 If you use formula-based excise determination, use a copy of the tax procedure TAXINJ.

This tax procedure also supports condition-based excise determination, so that you can work with both concurrently.

We strongly recommend that new customers use condition-based excise determination. Note that once you have started using a tax procedure, you cannot switch to another one, otherwise you will not be able to display old documents.

Definition: condition-based excise determination

Logistics - General (LO

A method that the system uses of determining excise duty in India.

This method requires you to create condition records for each combination of vendor or customer and material (and possibly other conditions).

When you create a purchasing document, the system calls the tax procedure assigned to India. The tax procedure finds all of the condition records that you have created for that combination of vendor and material.

When you create a sales document, the excise duties and sales taxes are determined by the pricing procedure (not the tax procedure).

Return ->

Definition: condition-based excise determination

Definition: formula-based excise determination

Logistics - General (LO)

A method that the system uses of determining excise duty in India.

This method was used in the Country Version India Add-On and requires you to maintain additional data in the Excise Rate Maintenance transaction, J1ID.

When you create a purchasing document, the system calls the tax procedure assigned to India. Each of the excise duties in the tax procedure has its own condition types, and each condition type is assigned to a formula. This formula instructs the system to calculate the excise duty using the data that you have maintained in the Excise Rate Maintenance transaction.

When you create a sales document, the system determines the excise duties and sales taxes using the pricing procedure (not the tax procedure).

Return ->

Definition: formula-based excise determination

Maintain Excise Defaults

Use

In this IMG activity, you define which tax procedure and pricing condition types are used in calculating excise taxes using formula-based excise determination.

Activities

If you use condition-based excise determination, fill out the CVD cond. field and leave all the others blank.

If you use formula-based excise determination, fill out all of the fields as follows:

u2022 Enter the tax procedure and the pricing conditions that are relevant for excise tax processing.

u2022 Specify the purchasing and sales conditions types used for basic excise duty, additional excise duty, special excise duty, and cess.

u2022 Specify the conditions in the sales order that are used for excise rates.

u2022 Specify the countervailing duty condition type used for import purchase orders.

See also

SAP Library -> Logistics -> Country Versions -> Asia-Pacific -> India -> Materials Management (MM) -> Condition-Based Excise Determination and -> Formula-Based Excise Determination.

Definition: basic excise duty

Financial Accounting (FI)

The main type of excise duty in India.

It is levied on a wide range of products, for example, foodstuffs, metals, jewellery, leather goods, and machinery.

Return ->

Definition: basic excise duty

Definition: additional excise duty

Financial Accounting (FI)

A form of excise duty, in India, levied on a select range of products, for the most part, textiles.

Return ->

Definition: additional excise duty

Definition: special excise duty

Financial Accounting (FI)

A form of excise duty in India on a limited number of goods, mostly luxury goods, including pan masala, sparkling waters, furs, and yachts.

Return ->

Definition: special excise duty

Definition: cess

Financial Accounting (FI)

In India, a tax on the manufacture of certain products, mostly foodstuffs.

Return ->

Definition: cess

Definition: countervailing duty

Financial Accounting (FI)

A form of excise duty imposed on imports that are subsidized by the country in which they were manufactured.

Countervailing duty (also known as CVD) is intended to make the imports more expensive, thereby redressing any competitive advantage they might have over goods produced locally.

Return ->

Definition: countervailing duty

Define Tax Code for Purchasing Documents

Use

In this IMG activity, you define a tax code for the purposes of calculating excise duty when you enter purchasing documents.

Only carry out this activity if you use condition-based excise determination.

Activities

Create a new tax code, and set the tax code type to V (input tax). Do not make any other settings for it.

See also

SAP Library -> Logistics -> Country Versions -> Asia-Pacific -> India -> Materials Management (MM) -> Condition-Based Excise Deter

Sales Tax Code

The tax code represents a tax category which must be taken into consideration when making a tax return to the tax authorities.

Tax codes are unique per country. The tax rate calculation rules and further features are stored in a table for each tax code.

Procedure

For tax-exempt or non-taxable transactions, you should use tax codes with a 0 percentage rate if the corresponding transactions are to be displayed in the tax returns.

Note

You must define new tax codes if tax rates are changed by the state. The old codes with the old tax rates must remain in the system until no more open items which use this tax code exist.

Definition: tax code

Financial Accounting (FI)

A two-digit code that represents the specifications used for calculating and displaying tax.

Examples of the specifications defined under the tax code are:

u2022 Tax rate

u2022 Type of tax (input tax or output tax)

u2022 Calculation method (percentage included or percentage separate)

Return ->

Definition: tax_code

Definition: tax rate

Financial Accounting (FI)

The percentage rate used to calculate the tax amount.

Return ->

Definition: tax_rate

Assign Tax Code to Company Codes

Use

In this IMG activity, assign the tax code for purchasing documents to the company codes where it will be used.

Only carry out this activity if you use condition-based excise determination.

See also

SAP Library -> Logistics -> Country Versions -> Asia-Pacific -> India -> Materials Management (MM) -> Condition-Based Excise Determination

Classify Condition Types

Use

In this IMG activity, you specify which condition types you use for which sort of tax. Note that this only applies to condition types that you use with the new excise determination method.

The system uses this information when you create a document from another one. For example, when you enter an incoming excise invoice from a purchase order, or when you create an outgoing excise invoice from a sales order, the system determines the various excise duties in the excise invoice using the information that you have entered here.

In addition, when you create a purchasing document, the system only uses the condition types that you enter here.

u2022 For taxes on purchases, use the condition types contained in the tax procedure.

u2022 For taxes on sales, use the condition types contained in the pricing procedures.

Standard settings

The standard system comes with sample settings for the tax calculation procedures and pricing procedures.

Use these settings as a basis for your own.

Maintain Chapter IDs

Use

In this IMG activity, you maintain the chapter IDs and the corresponding descriptions as per the schedules published by the Central Board of Excise and Customs.

Definition: chapter ID

Logistics - General (LO)

The number given to a material in the schedules of materials published by the government of India.

The schedule lists all materials involved in manufacturing, input materials and output materials alike. It shows how much excise duty is levied on each material.

Each material in the schedule is assigned its own identification code, called "chapter ID."

Example

The schedule contains an entry for ceramic roofing tiles, which are liable to basic excise duty at 16%. The chapter ID associated with these tiles is 6903.10.

Return ->

Definition: chapter ID

Assign Users to Material Master Screen Sequence for Excise D

Use

In this IMG activity, you customize the material master data so that it shows the information relating to excise duty.

Standard settings

Country Version India comes with a screen sequence (IN) that shows the excise duty fields. You have to assign it to each of your users.

Activities

1. Double-click User Screen Reference.

2. Assign all users who need to see the excise duty information to the screen reference IN.

Example

Name Screen Reference

MISHRA IN

Screen Sequence Number

Alphanumeric key identifying the screen sequence. The screen sequence defines the sequence of information units in the material master dialog. A screen sequence is made up of data screens. For information on the screen sequences defined in the standard R/3 system, see the IMG documentation Configuring the Material Master.

Note

When creating a screen sequence, use an alphanumeric key beginning with the letter Y or Z (customer name range). This key cannot subsequently be changed.

Dependencies

You can assign screen sequences to users in the IMG activity Assign Screen Sequences to Users/Material Types/Transactions/Industry Sectors.

Screen reference depending on the user

Grouping of users that determines what screens are displayed in accordance with the user master record when you maintain material master records. It also determines the order in which the screens appear.

Definition: user master record

User and Authorization Management (BC-SEC-USR)

Record that contains important master data for a user in the SAP System.

The user master record contains the assignment of one or more roles to the user. This is how a user menu and the corresponding authorizations for the activities contained in the user menu are assigned to the user. Only users who have a user master record can log on to the system.

Return ->

Definition: user_master_record

Define Form Types

Use

In this IMG activity, you define which form types you want to record in the system. You can only use form tracking for the form types that you enter here.

Example

u2022 Form type: CT3

u2022 Form description: Concessional tax form

u2022 Status: Receive

Define G/L Accounts for Taxes

Use

In this IMG activity, you specify which G/L accounts you will use to record which taxes.

Requirements

You have set up G/L accounts for each of the processing keys listed below.

Activities

Assign an account to each of the following posting keys. The accounts for VS1, VS2, and VS3 are used as clearing accounts during excise invoice verification.

u2022 VS1 (basic excise duty)

u2022 VS2 (additional excise duty)

u2022 VS3 (special excise duty)

u2022 VS5 (sales tax setoff)

u2022 MWS (central sales tax)

u2022 MW3 (local sales tax)

u2022 ESA (service tax)

u2022 ESE (service tax expense)

Specify Excise Accounts per Excise Transaction

Use

In this IMG activity, you specify which excise accounts (for excise duty and CENVAT) are to be posted to for the various transaction types. Enter all the accounts that are affected by each transaction type.

If you use sub transaction types, enter the accounts for each sub transaction type as well.

Activities

Transaction type UTLZ is used for determining accounts only while posting excise JVs and also if the payment of excise duty has to be done fortnightly.

The fortnightly CENVAT payment utility picks up the credit side accounts from the transaction types of GRPO, EWPO, and TR6C for determining the CENVAT and PLA accounts. There is no separate transaction type for fortnightly payment.

Example

Excise TT DC ind Account name

GRPO CR CENVAT clearing account

GRPO CR RG 23 BED account

GRPO DR CENVAT on hold account

Specify G/L Accounts per Excise Transaction

Use

In this IMG activity, you assign the excise and CENVAT accounts to G/L accounts.

When you come to execute the various transactions, the system determines which G/L accounts to post to by looking at the:

u2022 Excise group

u2022 Company code

u2022 Chart of accounts

Furthermore, if you want separate account determination settings within an excise group, you can also use sub transaction types.

Requirements

You have already:

u2022 Defined the G/L accounts

u2022 Defined the excise groups

u2022 Maintained the transaction accounts

Activities

For each excise group, assign the excise and CENVAT accounts to G/L accounts. For most businesses, one set of accounts will suffice for all transactions.

Note

You need not remit the CENVAT to the excise department immediately, so maintain the credit account for transaction type DLFC as an excise duty interim account. This will be set off when you remit the duty.

Define Processing Modes per Transaction

Use

in this IMG activity; you specify which processing modes the user can use in the various Incoming Excise Invoice transactions.

This way, you can tailor the transaction to what your users have to do.

Standard settings

the system comes with three standard transactions relating to the Incoming Excise Invoices function (those that are included in the role SAP_CIN). The processing modes available in these transactions are as follows:

u2022 J1IEX_C

This transaction is for excise clerks: users of this transaction can only capture and display excise invoices.

u2022 J1IEX_P

This transaction is for excise supervisors: they can change, display, cancel, and post excise invoices.

u2022 J1IEX

In this transaction, users can capture and post excise invoices, as well as displaying, changing, and canceling them.

Activities

If the standard settings meet your requirements, do not do anything.

Otherwise, you can adjust the standard settings or you can create your own transactions. To do so:

1. In Maintain Transaction, create a new transaction by making a copy of one of the standard transactions. Give the new transaction a transaction code of your choice.

2. In this activity, enter data as follows:

o Code: The transaction code that you have just created.

o Proc. mode: Specify what the users of the transaction will do with the excise invoices.

o Active: Select this indicator to activate the setting.

Example

you might want to create a transaction that only allows users to display excise invoices.

Define Reference Documents Per Transaction

Use

In this IMG activity, you specify for each combination of transaction and processing mode which reference documents you want the users to be able to use.

Activities

if the standard settings meet your requirements, you do not have to do anything.

Otherwise, add the entries that you need to the table: For each transaction, make one entry per combination of processing mode and reference document. Activate each entry for it to work.

Definition: excise invoice reference document

Logistics - General (LO)

A document, in India, that you refer to when you enter an incoming excise invoice.

If you have already posted the goods receipt, you can use the goods receipt document as the reference document. Otherwise, you can use the purchase order (or another purchasing document, such as a be a contract or a scheduling agreement).

Example

In the SAP System, you create a purchase order for 100 bags of sand and send the order to your vendor. Two weeks later, the vendor delivers the sand, accompanied by an excise invoice.

When you enter the excise invoice in the system, you specify the number of the original purchase order: this is the reference document.

Return ->

Definition: excise invoice reference document

Maintain Rejection Codes

Use

in this IMG activity, you define the rejection codes that are used in the Incoming Excise Invoices transaction.

Activities

For each rejection code enter a code and a description. You can also specify whether the excise duty in the invoice is to be posted to the CENVAT on hold account, instead of the CENVAT clearing account.

Specify Which Movement Types Involve Excise Invoices Use

in this IMG activity; you specify which movement types relating to goods receipts involve excise invoices.

The system uses this information during the goods receipt procedure. When you post a goods receipt using one of the movement types that you have specified here, the system prompts you to enter the excise invoice number.

Note

this option cannot be used for processing goods receipts without purchase orders.

Maintain Default Excise Groups and Series Groups

Use

in this IMG activity; you specify which excise group and series group you want to appear in these fields by default. You can make separate settings for different combinations of sales organization, distribution channel, division, and shipping point.

Activities

this activity is optional, unless you want the system to automatically create outgoing excise invoices when you create a customer invoice.

In this case, you must also make the appropriate setting in Customizing for Excise Duty, by choosing Basic Subcontracting Attributes

Use

The subcontracting attributes help determine conditions for a combination of an excise group, a transaction type, and a sub transaction type.

The conditions such as the number of excise items per subcontracting challan, if the nonexciseable materials have to be filtered or not when the subcontracting challan is created, the movement type groups for issues and receipts and the hierarchy of determining the excise base value are mentioned here.

Requirements

Before you continue with this activity, work through the following activities:

u2022 Materials Management -> Inventory Management and Physical Inventory -> Goods Issue / Transfer Postings -> Define Screen Layout.

For the movement type 541, maintain the field Purchase Order as an optional entry or as a required entry.

u2022 Materials Management -> Inventory Management and Physical Inventory -> Output Determination ->Maintain Output Types.

Maintain the output type. On the Default Values tab, maintain the dispatch time and the transmission medium. Maintain the print parameter on the Print tab. This output type has to be maintained in this activity here.

u2022 Materials Management -> Inventory Management and Physical Inventory -> Output Determination ->Assign Forms and Programs.

Maintain the Program, FORM routine, and the form for the output type.

u2022 Materials Management -> Inventory Management and Physical Inventory -> Output Determination ->Printer Determination -> Printer Determination by Plant / Storage Location.

Enter the output device that you use.

Settings -> Maintain Excise Groups, and selecting Create EI (Create Excise Invoice Automatically).

Maintain Movement Type Groups

Use

In this IMG activity, you group movement types together to form movement type groups.

Definition: movement type

Inventory Management (MM-IM)

A classification key indicating the type of material movement (for example, goods receipt, goods issue, physical stock transfer).

The movement type enables the system to find predefined posting rules determining how the accounts of the financial accounting system (stock and consumption accounts) are to be posted and how the stock fields in the material master record are to be updated.

Return ->

Definition: movement type

Utilization Determination

Use

In this IMG activity, you specify which CENVAT accounts are to be debited by the Fortnight Utilization of CENVAT report: When the report calculates how much excise duty you must remit, it automatically proposes which CENVAT accounts the duty should be debited to. Here, you specify those defaults.

You can either:

u2022 Debit all the excise duty to one account

u2022 Debit the excise duty to more than one account, in which case you specify which percentage is to be debited to each account

Example

If you want 50% of basic excise duty (BED) to be debited to the RG 23A account and the remaining 50% to the RG 23C account, you would make the following settings:

Acct name BED perc.

RG 23A BED account 50

RG 23C BED account 50

Alternatively, to debit all of the BED to the RG 23A account, and then RG 23C account, if there is not enough in the RG 23A account, you would make the following settings:

Acct name BED perc. +

RG 23A BED account X

RG 23C BED account X

when you come to run the report, the system takes the RG 23A account because it is the first one you have entered. If this account does not cover the BED, the system takes the RG 23C account instead.

Maintain Minimum Balances for Excise Accounts

Use

In this IMG activity, you can maintain minimum balances in your excise accounts. When the balance in these accounts during utilization falls below this level, the system automatically utilizes funds in the PLA account.

Activities

maintain the minimum balance amount for the excise accounts. If you have more than one excise group, you can maintain different minimum balances.

Specify SAP script Forms

Use

In this IMG activity, for each of your company codes, you specify which SAP script forms the system prints the excise registers with.

Standard settings

Country Version India includes a number of sample SAP script forms and printing programs, which you can use as follows:

Reg. name Lay. no. Form Tcode/Prog

RG 23A Part I 1 J_2IRG23A_PART1 J_2IRAP1

RG 23C Part I 1 J_2IRG23C_PART1 J_2IRCP1

RG 23A Part II 1 J_2IRG23A_PART2 J_2IRAP2

RG 23C Part II 1 J_2IRG23C_PART2 J_2IRCP2

PLA 1 J_2I_PLA J_2IPLA

RG 23 D 1 J_2I_RG23D J_2IRG23

RG 1 1 J_2I_RG1 J_2IRRG1

RT 12 1 J_2I_RT12_ABSTRA J_2IRT12

RT 12 1 J_2I_RT12_ABSTRA J_2IRT12

RT 12 1 J_2I_RT12_3 J_2IRT12

The layout description can be left blank or an appropriate description maybe filled in. You may not change the register name. You can have your own layouts and maintain the name here. If the output device and number of copies are maintained it is automatically picked up for printing.

Number Ranges

You can maintain the number ranges for all CIN Number range objects using this transaction

Activities

Please maintain the number ranges for the following objects The no nr has to be '01' for all

1. J_1iintnum

At an Excise group

1. j_1irg23a1

2. j_1irg23a2

3. j_1iRG1

4. j_1irg23c1

5. j_1irg23c2

6. j_1ipla2

7. j_1iintpr2

8. j_1irg23d

9. j_1irg1_t (material level)

10. j_1iconpla (if Consolidated PLA is used)

At Series group

1. j_1iexcloc

2. j_1iexcexp

3. j_1idepinv

4. j_1i57Fc (57F Challan)

regards,

indranil

Former Member
0 Kudos

Dear Indranil

Really helpful & appreciate u for the post

Regards

Deepu Pillai

Former Member
0 Kudos

Hi

CIN:

IMG > Logistics - General > Tax on Goods Movement > India > Basic Settings >

Maintain Excise Registrations

Use

In this IMG activity, you maintain the data relating to your excise registrations.

Activities

enter each of your excise registrations, specifying a four-character code for each

Excise Registration IDs

In this activity, you maintain excise registration IDs. You create one ID for each of your business's excise registrations.

Activities

For each excise registration in your business create a registration ID, and state:

u2022 Which taxes the registration covers (additional excise duty, special excise duty, and cess)

Fields for any taxes that are not covered will be hidden in transactions involving excise duty.

u2022 The maximum number of items to be printed on each excise invoice

u2022 Whether you are allowed partial CENVAT credits

Maintain Registration ID NUMBER, Excise code number, excise registration number

Excise Registration Number

A number assigned to each premises or location that has registered as a manufacturer with the excise authorities.

Every entity with an excise registration number is required to keep its own excise books.

ECC Number

Specifies the organization's ECC number.

Excise Registration Number

A number assigned to each premises or location that has registered as a manufacturer with the excise authorities.

Every entity with an excise registration number is required to keep its own excise books.

Excise range: Specifies the excise range in whose area the excise registration is located.

Excise Division

Specifies the excise division in whose area the excise registration is located.

Excise Collectorate

The code of the excise collectorate in whose area the excise registration is located.

Indicator for confirming AED usage

Additional Excise duty Percentage. These are leviable under the additional duties of excise act. These duties are in addition to basic excise duty and special excise duty.

Example

Additional Excise duty is leviable in case of textile products, tobacco and sugar.

Similarly for SED CESS

Number of Items in Excise Invoice

Shows the maximum number of line items that the authorities allow per excise invoice.

Dependencies

This information is used when you create an excise invoice in Sales and Distribution (SD) for factory sales and for other movements.

This information is used to split the transfer postings' items into multiple subcontracting challans.

Excise register set description

Description of the excise registers set.

Partial CENVAT Credit

Indicates that the excise registration ID is allowed to credit only a portion of its input excise duty to its CENVAT account.

Dependencies

When you post a goods receipt, the system splits the input excise duty on the material into its deductible and nondeductible amounts. It posts the deductible duty to the appropriate CENVAT account, and adds the nondeductible duty to the material value.

This information is also shown when you post the vendor's excise invoice.

Maintain Company Code Settings

Use

In this IMG activity, you maintain the data relating to your company codes.

Document Type for CENVAT Postings

It controls, which document type the system uses when making CENVAT postings in Financial Accounting (FI). Here ED is document type for cenvat posting.

Indicator for providing debit account overwriting

Debit Account Overwrite Indicator. X - Indicates debit accounts can be overwritten. Use In excise journal voucher transaction. It provides the flexibility to the user to enter the debit account of his choice depending on the nature of transaction.

Automatic balance Indicator

Excise year start month

The calendar month marking the beginning of the excise year

Use

this start month represents the month for the start of the excise invoice number range. The month 04 is entered here indicating April of the calendar year as the start month for excise invoices. Any change by the Excise authorities regarding start month should be taken care of by an entry in this field and initialization.

Excise invoice selection procedure

Excise invoice selection type. To indicate the method opted by the company for selecting the excise invoice. It can be either earliest or latest invoices that were received.

Number of excise invoices to be selected

indicates the number of excise invoices that needs to be selected in the excise invoice selection.

Days to be considered for excise invoice selection

Number of days from document date for excise invoice selection.

Example

If the value of this field is 20 and today is 28-03-97. The excise

invoice selection will show the related invoices only for the

period 08-03-97 to 28-03-97.

Document type for TDS FI posting

Financial accounting document type for TDS posting.

Document type for FI posting on Utilization

Financial accounting document type for TDS posting.

Indicator for item level excise duty round off

This indicator is to be used for deciding whether Item level excise duty amount rounding off is required during procurement cycle. If marked 'X' then the excise duty amount will be rounded off to the nearest rupee at the Purchase order level. This will not round off the CENVAT credit to be taken. If the duty amount is less than one rupee then no rounding is done

Rounding off of Excise duty for outgoing excise invoice

You can round off the Excise amount to be paid during an outgoing Excise invoice by marking this indicator as 'X'. The rounding is done at the item level for each item where the amount is greater than 1 Rupee.

Immediate Credit on Capital Goods

Instructs the system, when you verify a goods receipt for capital goods, to immediately post half of the input excise duty to the appropriate CENVAT accounts.

The rest is posted the CENVAT on hold account, for use in the following year.

CVD Clearing Account

Specifies which G/L account the system credits when you take a CENVAT credit on countervailing duty in the Incoming Excise Invoices transaction.

Exchange rate type

Key representing a type of exchange rate in the system.

Use

You enter the exchange rate type to store different exchange rates.

Example

You can use the exchange rate type to define a buying rate, selling rate, or average rate for translating foreign currency amounts. You can use the average rate for the currency translation, and the bank buying and selling rates for valuation of foreign currency amounts.

Exchange rate type to be used for Export excise duty converts

When you are creating an Excise invoice for export sales then the exchange rate for duty calculation will be picked up using this Exchange rate type.

Maintain Plant Settings

Use

In this IMG activity, you maintain excise information relating to your plants.

Plant Settings

In this activity, you maintain excise information relating to your plants.

Activities

For each plant:

u2022 Specify whether it is a manufacturing site or a depot.

u2022 Assign it an excise registration ID.

You can assign the same ID to more than one plant, if required.

Depot

indicates that the plant in question is a depot.

Dependencies

Depots are required to prepare register RG 23D, and follow different procedures for goods receipt and invoice generation.

Number of goods receipt per excise invoice.

Multiple GR for one excise invoice, Single credit

Multiple GR for one excise invoice, multiple credits

Maintain Excise Groups

Use

In this IMG activity, you define your excise groups. For each excise group, you can also control how various excise invoice transactions will work.

Excise Groups

In this activity, you define excise groups. An excise group allows you to maintain a separate set of excise registers and excise accounts. The RG 23A, RG 23C and PLA serial numbers are created for an excise group.

Recommendation

Under normal circumstances, excise authorities require every business to maintain only one set of excise registers and one set of accounts. But through exemption from the authorities, multiple books can be maintained.

If your company has only one set of excise registers, then you need to maintain only one excise group.

Activities

1. Create one excise group for each set of registers that you need to keep.

1. Assign the excise groups to plants.

2. Maintain whether this Excise group is for a depot or not.

3. If you receive only one consignment for an Excise challan then you can leave GR's per EI as blank. If you receive multiple GR's for a given Excise challan and would like to avail multiple credit mark the GRs per EI as 'Multiple GR's for one excise invoice, multiple credit'. Alternatively if you want to avail the credit only after all the goods receipts have been made mark it as ' Multiple GR for one excise invoice, single credit'.

4. If you want to automatically create Excise invoice during Sales cycle at the time of billing the tick the indicator 'Create EI'

5. During depot sales if you do not want to do RG23D selection and posting separately and would like to complete RG23D selection in one step mark the indicator 'RG23D Auto post'. This will post the selected records into RG23D automatically. You cannot cancel the selection later.

6. If the indicator 'Default GR qty' is marked system will default the Excise challan quantity on to the Goods receipt if the Excise invoice number is given in the pop-up.

7. If the indicator 'Folio no creates' is marked system will generate Folio numbers for RG23D during receipt of excise invoice into depot.

8. 'Automatic posting' when ticked will post the Excise invoice other movements automatically along with creation in single step.

9. 'Create Part1 for Block Stock' when marked will create a Part1 during the receipt of material into Blocked stock.

10. 'Create Part1 for STO' when marked will create a Part1 during the receipt of material through inter plant transfers.

11. 'Create Part1 for consumption stock' when marked will create a Part1 during the receipt of material into consumption stock.

Excise Group

Governs which set of excise registers a business transaction will be included in.

Following is the relation between excise group, plant and registration.

Dependencies

In define excise groups in Customizing.

Then, in transactions involving excise duty, for example, when you post a vendor's excise invoice, you specify which excise group you are using. This information tells the system which G/L accounts to post the excise to.

At the end of the period, when you come to prepare your excise registers, you create different sets for each excise group.

Indicates that the plant in question is a depot.

Dependencies

Depots are required to prepare register RG 23D, and follow different procedures for goods receipt and invoice generation.

GR Per Excise Invoice

Multiple GR for one excise invoice , Multiple credit

Multiple GR for one excise invoice , Single Credit

Create Excise Invoice Automatically

Instructs the system to automatically create a Sales and Distribution (SD) excise invoice immediately you create a commercial invoice or a pro forma invoice.

The excise invoice is created in the background.

Dependencies

If you want to make use of this function, you must also define the default plant, excise group, and series groups in Customizing for Sales and Distribution (SD), by choosing Excise Group - Series Group Determination.

RG23D Sales Creation and posting option

RG23D Automatic Option if selected will create Depot excise invoice by posting the selection of excise invoices in single step.

If this is not selected then you need to separately do RG23D selection followed by PGI and then RG23D verification and posting.

If you need automatic posting of RG23D selection then the Post Goods Issue should have been completed before running RG23D selection.

Default excise qty in GR

If this indicator is ticked then while doing Goods Receipt using 'MB01' system will default the excise invoice quantity on to the Goods receipt document.

Folio number for depo

Posting

If this indicator is marked then while creating Excise invoice for other movements system automatically does the Verify and Post. You need not separately Post the excise invoice

Also we can set indicator for creation of part 1 for:

Blocked stock

Stock transport order

Consignment stock

Maintain Series Groups

Use

In this IMG activity, you define the different excise series groups within your company. Series groups allow you to maintain multiple number ranges for the outgoing excise documents.

Based on excise regulations and exemptions from the authorities you can maintain multiple number series for outgoing documents. But each of these series has to be declared to the excise authorities.

Activities

u2022 Define excise series groups based on type of outgoing document

u2022 Assign series group to excise registration ID

u2022 If no financial postings are required for an Excise invoice in this seris group then you tick the 'No utilization' indicator.

u2022 If the CENVAT has to be paid immediately and you need not wait for the Fort nightly payment then mark the 'Immediate Utilization' indicator.

Example

You could define two series groups, group 001 for excise invoices, and group 002 for 57 F4 documents.

No account postings for CENVAT in sales cycle

No utilization Flag

If you do not need any CENVAT utilization for an excise invoice but would like to just generate an excise invoice then you need to mark this indicator.

IF the flag is checked then system will create an Excise invoice in the given Series group but there will not be any account postings or Part2 postings.

Immediate Utilization of CENVAT

Specifies that when you create an excise invoice, the system immediately pays the amount from CENVAT and creates the Part II entry. Such invoices will not be listed for fortnightly utilization.

If you have both fortnightly and immediate utilization for the same excise group, the account determination within CIN IMG should point to the ED interim account.

Account determination for immediate payment will be done exactly the same as being done for fortnightly utilization program.

Maintain Excise Duty Indicators

Use

In this IMG activity; you maintain the excise duty indicators.

IMG > Logistics - General > Tax On Goods Movement > India > Basic Settings > Determination of Excise Duty >

Select Tax Calculation Procedure

Use

In this IMG activity, you specify which tax procedure you want to use for determining excise duties and sales taxes on input materials in India.

u2022 If you use condition-based excise determination, use a copy of the tax procedure TAXINN.

u2022 If you use formula-based excise determination, use a copy of the tax procedure TAXINJ.

This tax procedure also supports condition-based excise determination, so that you can work with both concurrently.

We strongly recommend that new customers use condition-based excise determination. Note that once you have started using a tax procedure, you cannot switch to another one, otherwise you will not be able to display old documents.

Maintain Excise Defaults

Use

In this IMG activity, you define which tax procedure and pricing condition types are used in calculating excise taxes using formula-based excise determination.

Activities

If you use condition-based excise determination, fill out the CVD cond. field and leave all the others blank.

If you use formula-based excise determination, fill out all of the fields as follows:

u2022 Enter the tax procedure and the pricing conditions that are relevant for excise tax processing.

u2022 Specify the purchasing and sales conditions types used for basic excise duty, additional excise duty, special excise duty, and cess.

u2022 Specify the conditions in the sales order that are used for excise rates.

u2022 Specify the countervailing duty condition type used for import purchase orders.

See also

SAP Library -> Logistics -> Country Versions -> Asia-Pacific -> India -> Materials Management (MM) -> Condition-Based Excise Determination and -> Formula-Based Excise Determination.

IMG > Logistics - General > Tax On Goods Movement > India > Basic Settings > Determination of Excise Duty >

Condition-Based Excise Determination

Use

When you enter a purchasing document, for example, a purchase order, the R/3 System automatically calculates the applicable excise duties using the condition technique.

Features

The standard system comes with two tax calculation procedures. TAXINN is only supports condition-based excise determination, whereas TAXINJ supports condition-based excise determination and formula-based excise determination. Both tax procedures contain condition types that cover all of the excise duties and sales taxes applicable.

Since the exact rates of excise duty can vary on a large number of factors, such as which vendor you purchase a material from, or which chapter ID the vendor stocks the material under, you create condition records for every sort of excise duty.

When you come to enter a purchasing document, the system applies the excise duty at the rates you have entered in the condition records.

Activities

Customizing

IndiaMake for Logistics u2013 General, by choosing Taxes on Goodsthe settings in Customizing Basic Excise Duties Using Condition Technique and u2026Movements Account Settings Determination.

These activities include one activity where you define a tax code for condition-based excise determination.

Master Data

Create condition records for all excise duties that apply, and enter the tax code for condition-based excise determination in each.

Day-to-Day Activities

When you enter a purchase order or other purchasing document, enter the tax code for condition-based excise determination in each line item. The system then calculates the excise duties using the condition records you have created.

When the ordered materials arrive, you post the goods receipt and the excise invoice. The system posts the excise duty to the appropriate accounts for deductible input taxes when you enter the excise invoice.

Creating Condition Records for Excise Duty

1. In the command field, enter FV11 and choose .

2. Enter the condition type that you want to create a condition record for and choose .

The Key Combination dialog box appears.

3. Select the combination of objects that you want to create the condition record for.

On the dialog box, Control Code means "chapter ID."

So, for example, to create a condition record for a tax that applies to a combination of country, plant, and chapter ID, select Country/Plant/Control Code.

4. Choose.

5. Enter data as required.

In the Tax Code field, enter the dummy tax code that you have defined.

6. Save the condition record.

Formula-Based Excise Determination

Use

When you execute a business transaction involving materials that are subject to excise duty, the system automatically calculates the duty for you.

Prerequisites

In order for the system to be able to determine which rate of excise duty to apply, you must have maintained all the data on the Maintenance screen, which you can MasterExcise Rate access from the SAP Easy Access screen by choosing Indirect Taxes Excise Rate Maintenance.Data

You maintain the following types of data:

u2022 Plant master data

You assign each of your plants an excise duty indicator. You can use the same indicator for all the plants with the same excise status from a legal point of view, such as all those that are in an exempt zone.

See also the information about manufacturers that are only entitled to deduct a certain portion of the duty (see Partial CENVAT Credit).

u2022 Vendor master data

For each of your vendors with the same excise status from a legal perspective, you define an excise duty indicator. You must also specify the vendor type u2013 for example, whether the vendor is a manufacturer, a depot, or a first-stage dealer. You must also stipulate if the vendor qualifies as a small-scale industry.

For each permutation of plant indicator and vendor indicator, you then create a final excise duty indicator.

u2022 Customer master data

similarly, you assign the same excise duty indicator to each of your customers that share the same legal excise status.

Again, for each permutation of plant indicator and customer indicator, you then create a final excise duty indicator.

u2022 Material master data

each material is assigned a chapter ID.

u2022 Excise tax rate

For every chapter ID and final excise duty indicator, you maintain the rate of excise duty.

If your business only qualifies for partial CENVAT credit, you must customize your system accordingly.

Activities

Let us consider an example to illustrate how the system determines which rate of excise duty to apply to a material. Assume you are posting a sale of ball bearings to a customer. The system automatically determines the rate of excise duty as follows:

1. Looks up the customer master data to see what status you have assigned the customer.

Let's assume you've assigned the customer status 3.

2. Looks up the plant master data to see what status you have assigned the plant.

Similarly, your plant has status 2.

3. The system looks up the table under Excise Indicator for Plant and Customer to see what the final excise duty indictor is for customer status 3 and plant status 2: It is 7.

4. The system determines the chapter ID of the ball bearing for the plant.

Letu2019s assume the chapter ID at plant for the ball bearings is 1000.01.

5. Finally, the system looks up the table under Excise Tax Rate to see what rate of duty applies to chapter ID 1000.01 under status 7.

Define Tax Code for Purchasing Documents

Use: In this IMG activity, you define a tax code for the purposes of calculating excise duty when you enter purchasing documents.

Only carry out this activity if you use condition-based excise determination.

Activities: Create a new tax code, and set the tax code type to V (input tax). Do not make any other settings for it.

Assign Tax Code to Company Codes

Use

In this IMG activity, assign the tax code for purchasing documents to the company codes where it will be used.

Only carry out this activity if you use condition-based excise determination.

Classify Condition Types

Use

In this IMG activity, you specify which condition types you use for which sort of tax. Note that this only applies to condition types that you use with the new excise determination method.

The system uses this information when you create a document from another one. For example, when you enter an incoming excise invoice from a purchase order, or when you create an outgoing excise invoice from a sales order, the system determines the various excise duties in the excise invoice using the information that you have entered here.

In addition, when you create a purchasing document, the system only uses the condition types that you enter here.

u2022 For taxes on purchases, use the condition types contained in the tax procedure.

u2022 For taxes on sales, use the condition types contained in the pricing procedures.

Standard settings

The standard system comes with sample settings for the tax calculation procedures and pricing procedures.

Use these settings as a basis for your own.

IMG > Logistics - General > Tax on Goods Movement > India > Account Determination

Define G/L Accounts for Taxes

Use

In this IMG activity, you specify which G/L accounts you will use to record which taxes.

Requirements

you have set up G/L accounts for each of the processing keys listed below.

Activities

Assign an account to each of the following posting keys. The accounts for VS1, VS2, and VS3 are used as clearing accounts during excise invoice verification.

u2022 VS1 (basic excise duty)

u2022 VS2 (additional excise duty)

u2022 VS3 (special excise duty)

u2022 VS5 (sales tax setoff)

u2022 MWS (central sales tax)

u2022 MW3 (local sales tax)

u2022 ESA (service tax)

u2022 ESE (service tax expense)

Specify Excise Accounts per Excise Transaction

Use

In this IMG activity, you specify which excise accounts (for excise duty and CENVAT) are to be posted to for the various transaction types. Enter all the accounts that are affected by each transaction type.

If you use sub transaction types, enter the accounts for each sub transaction type as well.

Activities

Transaction type UTLZ is used for determining accounts only while posting excise JVs and also if the payment of excise duty has to be done fortnightly.

The fortnightly CENVAT payment utility picks up the credit side accounts from the transaction types of GRPO, EWPO, and TR6C for determining the CENVAT and PLA accounts. There is no separate transaction type for fortnightly payment.

Example

Excise TT DC ind Account name

GRPO CR CENVAT clearing account

GRPO CR RG 23 BED account

GRPO DR CENVAT on hld account

Specify G/L Accounts per Excise Transaction

Use

In this IMG activity, you assign the excise and CENVAT accounts to G/L accounts.

When you come to execute the various transactions, the system determines which G/L accounts to post to by looking at the:

u2022 Excise group

u2022 Company code

u2022 Chart of accounts

Furthermore, if you want separate account determination settings within an excise group, you can also use sub transaction types.

Requirements

You have already:

u2022 Defined the G/L accounts

u2022 Defined the excise groups

u2022 Maintained the transaction accounts

Activities

For each excise group, assign the excise and CENVAT accounts to G/L accounts. For most businesses, one set of accounts will suffice for all transactions.

Note

You need not remit the CENVAT to the excise department immediately, so maintain the credit account for transaction type DLFC as an excise duty interim account. This will be set off when you remit the duty.

Config setting needed to be done in order to get the Excise Details Screen in Material Master.

Even though this functionality is available in enterprise version, a small config step has to be made in Screen Sequences for Material Master.

Following document helps you to do this configuration.

Logistics General 1. Go to IMG Define Structure ofData ScreenMaterial Master Configuring the Material master Screen Sequence.for each

2. Select your screen sequence. Usually it would be 21. Select the same and click on Data Screen in the left frame.

3. Once the data screens are exhibited, select data screen no. 15, ie. SSq. 21and Scrn 15, which is u201CForeign Trade: Import Datau201D. Select the same and click on Subscreens in the left frame.

4. Go to the last sub screen i.e. 21-15-6 - SAPLMGD1- 0001 and select the same. Click on tab view subscreen and ensure that the subscreen is blank.

5. Now in the last sub screen i.e. no.6 you delete SAPLMGD1 u2013 0001 and instead add SAPLJ1I_MATERIAL_MASTER and in the screen no. 2205.

6. Save the setting.

7. Create a Material Master and check whether in Screen Foreign Trade u2013 Import, Excise related subscreen appears.

Transaction

Action

J1I2

Prepare a sales tax register

J1I3

Create outgoing excise invoices in batches

J1I5

Update the RG 1 and Part I registers

J1IEX

Incoming Excise Invoices (central transaction)

J1IEX_C

Capture an incoming excise invoice (excise clerk)

J1IEX_P

Post an incoming excise invoice (excise supervisor)

J1IF01

Create a subcontracting challan

J1IF11

Change a subcontracting challan

J1IF12

Display a subcontracting challan

J1IF13

Complete, reverse, or recredit a subcontracting challan

J1IFQ

Reconcile quantities for subcontracting challans

J1IFR

List subcontracting challans

J1IH

Make a CENVAT adjustment posting

J1IIN

Create an outgoing excise invoice

J1IJ

Assign excise invoices to a delivery for sales from depots

J1INJV

Adjust withholding tax Item

J1INREP

Reprint a withholding tax certificate for a vendor

J1IQ

Year-End Income Tax Depreciation Report

J1IR

Download register data

J1IS

Process an excise invoice (outgoing) for other movements

J1IU

Process exemption forms

J1IW

Verify and post an incoming excise invoice

J1IX

Create an incoming excise invoice (without reference to purchase order)

J2I8

Transfer excise duty to CENVAT account

J2IU

Remit excise duty fortnightly

J2I9

Monthly CENVAT return

J1IG

Excise invoice entry at depot

J1IGA

Create additional excise entry at depot

J2I5

Extract data for excise registers

J2I6

Print excise registers

SAP CIN tables start with J_1I* . You can go to se11 or se16 and give J_1I* against field table name and press F4. Then you will get all the CIN related tables.

I am just giving some of the tables.

J_1IADDEXC Additional Excise rate table

J_1IADDRES Excise Related Address Management

J_1IADDRESS Excise Related Address Management

J_1IARE_ATTRB Excise Bonding: Attributes

J_1IASSVAL Assessable value table for excise calculat

J_1IBILDET Billing Type Determination - India

J_1IBOND Excise Bonding: Bonds/UT-/Running Bond mas

J_1IBOSDEFAULT Default Blling Type for Export

J_1ICALOC Allocation of materials to assets

J_1ICERTIF TDS certificate information

J_1ICHIDTX Text Table for Chapter ID

J_1ICHPTER Chapter ID Master

J_1ICOMP Additional company data

J_1ICONDTAX Tax Codes for Excise Duties Using Conditio

J_1ICUS_BILL_TYP Assign Customer Category to Bill Type

J_1IDCLSDET Document class Determination - India

J_1IEICOCU Excise indicator determination for company

J_1IEICOVE Excise indicator determination for company

J_1IEWTCALID Calendar for Payment Due date-EWT India

J_1IEWTCALID_N Calendar for Payment Due date-EWT India: S

J_1IEWTCHLN Table for Internal and external Challan no

J_1IEWTDOCKEY Document Types for Extended Withholding Ta

J_1IEWTDTCHLN Document Type for Remittance Challan - Cla

J_1IEWTDTPRV Document Types for TDS Provisions -EWT In

J_1IEWTDUEDATE Tax Due Dates

J_1IEWTECESS Education Cess Codes

J_1IEWTHKONT Table for for TDS provisions Accounts / L

J_1IEWTJV Document Types for Journal Vouchers

J_1IEWTNO No range for certificate Printing-EWT Indi

J_1IEWTNUM INTERNAL NO RANGE FOR CHALLANS- EWT INDIA

J_1IEWTNUMGR Number Groups For Internal Challan Numbers

J_1IEWTNUMGR_1 Number Groups For Internal Challan Numbers

J_1IEWTNUMGR_N Number Groups For Internal Challan Numbers

J_1IEWTPROV Table for TDS provisions

J_1IEWTPROVISACC Maintain entries for accts to be considere

J_1IEWTSURC Surcharge Tax Codes

J_1IEWT_CERT SAPscript Forms/section indicators for E

J_1IEWT_CERTIF Certificate Issued Details-EWT India

J_1IEWT_CERTIF_N Certificate Issued Details-EWT India:SECCO

J_1IEWT_CERTNO Number Ranges for Withholding Tax Certific

J_1IEWT_CERT_N SAPscript Forms/section indicators for EWT

J_1IEWT_COMP Surcharge Calculation Methods

J_1IEWT_CUST Customer certificates ,Challan customizin

J_1IEWT_CUSTV View for Document type for Challan Update-

J_1IEWT_ECESS1 Education Cess Rates

J_1IEWT_ECFLAG Separate Tax code for Ecess

J_1IEWT_HC Health check for migration to EWT status.

J_1IEWT_MAPEXM Assign Exemption Reasons to Withholding Ta

J_1IEWT_MAPEXMPT Table for Vendor type/exemption indicators

J_1IEWT_MIGRATE Map Classic tax code to EWT Tax type - Tax

J_1IEWT_SURC Maintain Surcharge Calculation Methods

J_1IEWT_SURC1 Surcharge Rates

J_1IEWT_VENTYP Assign Types of Company to Withholding Tax

J_1IEXCACC Excise Account Assignment table

J_1IEXCDEF Tax default informations

J_1IEXCDEFN Default Condition Types

J_1IEXCDEP Excise information of vendor at detail lev

J_1IEXCDTL Excise invoice line item details

J_1IEXCHDR Excise invoice header detail

J_1IEXCREF Delivery document to excise invoice refren

J_1IEXCTAX Tax calc. - Excise tax rates

J_1IEXESTA Excise indicator determination for co / cu

J_1IEXGRPS Excise Groups

J_1IEXMPTCODE VAT Exempted Tax code

J_1IEXSRDET Excise / Series group determination

J_1IEX_CUST_ACT Define Processing Modes Per Transaction

J_1IEX_CUST_FLDS J1IEX: Incoming Invoices field selections

J_1IEX_CUST_REF Define Reference Documents Per Transaction

J_1IFRDTOT Transaction Table for Forms Tracking-Non S

J_1IFRDTPO tranasction Table for Forms Tracking for P

J_1IFRDTSO Transaction table for Forms Tracking for S

J_1IFRMTYP Form Types

J_1IGRXREF Goods Receipt to Excise Invoice Coss Refer

J_1IGRXSUB GR reference to subcontracting challans

J_1IINDCUS Company Code Settings

J_1IITMDTL Item Details - for Capital goods and subco

J_1IKONV Excise recalculated conditions

J_1ILICDTL Excise Bonding: License detail

J_1ILICHDR Excise Bonding: License Header

J_1ILICTYPE Excise Bonding: License type master

J_1IMATEXP Exceptional materials excise rates

J_1IMESG Message Control

J_1IMINBAL Minimum account balances

J_1IMOCOMP Company and Plant - Excise Additional Data

J_1IMOCUST Customer Master Excise Additional Data

J_1IMOCUSTEWT Maintain PAN no for Customers -EWT India

J_1IMODDET Modvat Determination Table (Input Material

J_1IMOVEND Vendor Master Excise Additional Data

J_1IMOVENDEWT Maintain PAN no for Certificates-EWT India

J_1IMTCHID Combination of Material Number and Chapter

J_1IMVMT Movement types versus register relevance

J_1IMVTGRP Movement type Group for Subcontrcting

J_1INEWJCODE VAT Transition Dummy Jurisdiction Code

J_1INEXCGRP excise group for no range

J_1IPART1 Excise part I detials

J_1IPART2 Excise Part II details

J_1IQEXCISE Quantity based AED, NCCD and SED

J_1IREGSET Excise Registrations

J_1IREJMAS Rejection Codes

J_1IRG1 Excise RG1 details

J_1IRG1RNG Group table for RG1 - Number Range Object

J_1IRG23D RG23D register for the depot

J_1IRGSUM RG23 Summary of receipts and issues

J_1IRSNCODEM Exemption Reason Code; e-Filing India Loca

J_1ISERVC Service tax details

J_1ISRGRPS Excise Document Series

J_1ISSIRAT ssi concessional rates

J_1ISTAPPL Tax applicability

J_1ISTATECD State Codes; e-Filing, Localization India

J_1ISTATECDM State Code Mapping; e-Filing India Locali

J_1ISTATECDT State Code Texts; e-Filing India Localiza

J_1ISTRATE Sales tax set off percentages

J_1ISUBATT Subcontracting Scenario Attributes

J_1ISUBBYP Subcontracting Scrap/ Byproduct

J_1ISUBTYP Subtransaction type text

J_1IT030K India Tax account determination ( T030K +

J_1IT030K_V India Tax Account Determination

J_1IT059A Indicator to mention tax exemption

J_1ITAXDEP Depreciation computation as per Income Ta

J_1ITAXIND Excise Tax Indicator

J_1ITCJCMAP Tax code and Jurisdiction code mapping

J_1ITCJCUPDATE Updatation table for open documents

J_1ITDS Classic TDS - reference table

J_1ITDSDUE TDS Payment due date customization

J_1ITDSSEC TDS Sections

J_1ITDSTXC TDS - Withholding taxcode and section rel

J_1ITRAN Transaction code

J_1ITRNACC Transaction code vs accounts

J_1IUTILIZE Utilization Determination

J_1IV2ARE_ATTRB Make Settings for ARE-1 Procedure

J_1IVARE_ATTRB Make Settings for ARE-3 Procedure

J_1IVATDATE Maintain Valid from date of VAT legislatio

J_1IVATDATE_V Maintain Valid from date of VAT legislatio

J_1IVATINVOICE Billing type determination for VAT

J_1IVATREGIO States Under VAT regime

J_1IVCHID View of Chapter ID and text

J_1IVEXGRP Help view for Excise groups

J_1IVEXGRPS Excise Group Maintenance

J_1IVFRMTY Help view for Form type

J_1IVFRTYP Maintenance view for Form Types

J_1IVREGID Help View for the register id

J_1IVSRGRP Help view for serial group

J_1IVT001 Document types for TDS JV

J_1IVTDSDU Payment due date in TDS

J_1IVTRAN Help view for the transaction type

J_1IVTTXID Text maintenance

J_1IVTTXOB Text object maintenance

J_1IVTXNOR Excise tax rates - normal

J_1IVTXRAT Tax rate maintenance

J_1IVTXSPL Excise tax rates

J_1IV_INVC Help view for Vendor Excise invoice

J_1IWRKCUS Plant Settings

J_1I_BCKEXCSUS Customizing table for background capture o

J_1I_CUST_CERT Data table for clearing doc on customer ta

J_1I_EWT_RETURN Annual returns - Documemnt View

J_1I_INBDELV INBOUND DELIVERY DETAILS FROM sus

J_1I_SECCODE Section Codes for Extended Withholding Tax

Anand K

Former Member
0 Kudos

Hi,

Please refer below mention links,

[http://www.sap-img.com/sap-sd/sap-sd-cin-configuration.htm]

[http://sap.ittoolbox.com/groups/technical-functional/sap-log-sd/cin-configuration-640328]

[http://sap.ittoolbox.com/groups/technical-functional/sap-log-mm/cin-configuration-1406942]

[http://www.geekinterview.com/question_details/47073]

Regards,

Mahesh Wagh

former_member581212
Active Contributor
0 Kudos

hi,

Check the links:

Hope it helps..

Regards

Priyanka.P