RE:[sap-log-mm] Tax Related Tables
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by SHRADHAMISHRA on Feb 24 at 12:47 AM |  Mark as helpful |
Hi Satya,
I will go thro d tables..
Thanx 4 d reply..
Regards,
Shradha
---------------Original Message---------------
From: murty_tsn
Sent: Tuesday, February 23, 2010 2:50 AM
Subject: Tax Related Tables
> Hi Shradha,<br/>?<br/>BSET table is correct table<br/>?<br/>The following are Excise tables, go through these tables and get ur data<br/>?<br/> <br/>SE16-- Click F4 (Function key)<br/>a window appear--Click on the information system<br/>then another screen apeears.<br/>IN that in the Standard selections tab...in the package feild enter the Below value<br/>J1I* <br/>and click OK.<br/>it gives the complete list of Excise tables<br/><br/>Hi You can get several details related to MM,CIN,WM <br/>All CIN tables start with J_1I and J_2I. There are 129 tables.<br/>J_1IEXCHDR (Header data of excise doc.)<br/>J_1IEXCDTL (Line item data of excise doc.)<br/>J_2IRULES (Table for maintenance of excise rules )<br/>J_1IADDEXC Additional Excise rate table <br/>J_1IADDRES Excise Related Address Management <br/>J_1IADDRESS Excise Related Address Management <br/>J_1IARE_ATTRB Excise Bonding: Attributes <br/>J_1IASSVAL Assessable value table for excise calculat <br/>J_1IBILDET Billing Type Determination - India <br/>J_1IBOND Excise Bonding: Bonds/UT-/Running Bond mas <br/>J_1IBOSDEFAULT Default Blling Type for Export <br/>J_1ICALOC Allocation of materials to assets <br/>J_1ICERTIF TDS certificate information <br/>J_1ICHIDTX Text Table for Chapter ID <br/>J_1ICHPTER Chapter ID Master <br/>J_1ICOMP Additional company data <br/>J_1ICONDTAX Tax Codes for Excise Duties Using Conditio <br/>J_1ICUS_BILL_TYP Assign Customer Category to Bill Type <br/>J_1IDCLSDET Document class Determination - India <br/>J_1IEICOCU Excise indicator determination for company <br/>J_1IEICOVE Excise indicator determination for company <br/>J_1IEWTCALID Calendar for Payment Due date-EWT India <br/>J_1IEWTCALID_N Calendar for Payment Due date-EWT India: S <br/>J_1IEWTCHLN Table for Internal and external Challan no <br/>J_1IEWTDOCKEY Document Types for Extended Withholding Ta <br/>J_1IEWTDTCHLN Document Type for Remittance Challan - Cla <br/>J_1IEWTDTPRV Document Types for TDS Provisions -EWT In <br/>J_1IEWTDUEDATE Tax Due Dates <br/>J_1IEWTECESS Education Cess Codes <br/>J_1IEWTHKONT Table for for TDS provisions Accounts / L <br/>J_1IEWTJV Document Types for Journal Vouchers <br/>J_1IEWTNO No range for certificate Printing-EWT Indi <br/>J_1IEWTNUM INTERNAL NO RANGE FOR CHALLANS- EWT INDIA <br/>J_1IEWTNUMGR Number Groups For Internal Challan Numbers <br/>J_1IEWTNUMGR_1 Number Groups For Internal Challan Numbers <br/>J_1IEWTNUMGR_N Number Groups For Internal Challan Numbers <br/>J_1IEWTPROV Table for TDS provisions <br/>J_1IEWTPROVISACC Maintain entries for accts to be considere <br/>J_1IEWTSURC Surcharge Tax Codes <br/>J_1IEWT_CERT SAPscript Forms/section indicators for E <br/>J_1IEWT_CERTIF Certificate Issued Details-EWT India <br/>J_1IEWT_CERTIF_N Certificate Issued Details-EWT India:SECCO <br/>J_1IEWT_CERTNO Number Ranges for Withholding Tax Certific <br/>J_1IEWT_CERT_N SAPscript Forms/section indicators for EWT <br/>J_1IEWT_COMP Surcharge Calculation Methods <br/>J_1IEWT_CUST Customer certificates ,Challan customizin <br/>J_1IEWT_CUSTV View for Document type for Challan Update- <br/>J_1IEWT_ECESS1 Education Cess Rates <br/>J_1IEWT_ECFLAG Separate Tax code for Ecess <br/>J_1IEWT_HC Health check for migration to EWT status. <br/>J_1IEWT_MAPEXM Assign Exemption Reasons to Withholding Ta <br/>J_1IEWT_MAPEXMPT Table for Vendor type/exemption indicators <br/>J_1IEWT_MIGRATE Map Classic tax code to EWT Tax type - Tax <br/>J_1IEWT_SURC Maintain Surcharge Calculation Methods <br/>J_1IEWT_SURC1 Surcharge Rates <br/>J_1IEWT_VENTYP Assign Types of Company to Withholding Tax <br/>J_1IEXCACC Excise Account Assignment table <br/>J_1IEXCDEF Tax default informations <br/>J_1IEXCDEFN Default Condition Types <br/>J_1IEXCDEP Excise information of vendor at detail lev <br/>J_1IEXCDTL Excise invoice line item details <br/>J_1IEXCHDR Excise invoice header detail <br/>J_1IEXCREF Delivery document to excise invoice refren <br/>J_1IEXCTAX Tax calc. - Excise tax rates <br/>J_1IEXESTA Excise indicator determination for co / cu <br/>J_1IEXGRPS Excise Groups <br/>J_1IEXMPTCODE VAT Exempted Tax code <br/>J_1IEXSRDET Excise / Series group determination <br/>J_1IEX_CUST_ACT Define Processing Modes Per Transaction <br/>J_1IEX_CUST_FLDS J1IEX: Incoming Invoices field selections <br/>J_1IEX_CUST_REF Define Reference Documents Per Transaction <br/>J_1IFRDTOT Transaction Table for Forms Tracking-Non S <br/>J_1IFRDTPO tranasction Table for Forms Tracking for P <br/>J_1IFRDTSO Transaction table for Forms Tracking for S <br/>J_1IFRMTYP Form Types <br/>J_1IGRXREF Goods Receipt to Excise Invoice Coss Refer <br/>J_1IGRXSUB GR reference to subcontracting challans <br/>J_1IINDCUS Company Code Settings <br/>J_1IITMDTL Item Details - for Capital goods and subco <br/>J_1IKONV Excise recalculated conditions <br/>J_1ILICDTL Excise Bonding: License detail <br/>J_1ILICHDR Excise Bonding: License Header <br/>J_1ILICTYPE Excise Bonding: License type master <br/>J_1IMATEXP Exceptional materials excise rates <br/>J_1IMESG Message Control <br/>J_1IMINBAL Minimum account balances <br/>J_1IMOCOMP Company and Plant - Excise Additional Data <br/>J_1IMOCUST Customer Master Excise Additional Data <br/>J_1IMOCUSTEWT Maintain PAN no for Customers -EWT India <br/>J_1IMODDET Modvat Determination Table (Input Material <br/>J_1IMOVEND Vendor Master Excise Additional Data <br/>J_1IMOVENDEWT Maintain PAN no for Certificates-EWT India <br/>J_1IMTCHID Combination of Material Number and Chapter <br/>J_1IMVMT Movement types versus register relevance <br/>J_1IMVTGRP Movement type Group for Subcontrcting <br/>J_1INEWJCODE VAT Transition Dummy Jurisdiction Code <br/>J_1INEXCGRP excise group for no range <br/>J_1IPART1 Excise part I detials <br/>J_1IPART2 Excise Part II details <br/>J_1IQEXCISE Quantity based AED, NCCD and SED <br/>J_1IREGSET Excise Registrations J_1IREJMAS Rejection Codes <br/>J_1IRG1 Excise RG1 details <br/>J_1IRG1RNG Group table for RG1 - Number Range Object <br/>J_1IRG23D RG23D register for the depot <br/>J_1IRGSUM RG23 Summary of receipts and issues <br/>J_1IRSNCODEM Exemption Reason Code; e-Filing India Loca <br/>J_1ISERVC Service tax details J_1ISRGRPS Excise Document Series <br/>J_1ISSIRAT s si concessional rates J_1ISTAPPL Tax applicability <br/>J_1ISTATECD State Codes; e-Filing, Localization India <br/>J_1ISTATECDM State Code Mapping; e-Filing India Locali <br/>J_1ISTATECDT State Code Texts; e-Filing India Localiza <br/>J_1ISTRATE Sales tax set off percentages <br/>J_1ISUBATT Subcontracting Scenario Attributes <br/>J_1ISUBBYP Subcontracting Scrap/ Byproduct <br/>J_1ISUBTYP Subtransaction type text <br/>J_1IT030K India Tax account determination ( <br/>T030K + J_1IT030K_V India Tax Account Determination <br/>J_1IT059A Indicator to mention tax exemption <br/>_1ITAXDEP Depreciation computation as per Income Ta <br/>J_1ITAXIND Excise Tax Indicator <br/>J_1ITCJCMAP Tax code and Jurisdiction code mapping <br/>J_1ITCJCUPDATE Updatation table for open documents <br/>J_1ITDS Classic TDS - reference table <br/>J_1ITDSDUE TDS Payment due date customization <br/>J_1ITDSSEC TDS Sections <br/>J_1ITDSTXC TDS - Withholding taxcode and section rel <br/>J_1ITRAN Transaction code <br/>J_1ITRNACC Transaction code vs accounts <br/>J_1IUTILIZE Utilization Determination <br/>J_1IV2ARE_ATTRB Make Settings for ARE-1 Procedure <br/>J_1IVARE_ATTRB Make Settings for ARE-3 Procedure <br/>J_1IVATDATE Maintain Valid from date of VAT legislatio <br/>J_1IVATDATE_V Maintain Valid from date of VAT legislatio <br/>J_1IVATINVOICE Billing type determination for VAT <br/>J_1IVATREGIO States Under VAT regime <br/>J_1IVCHID View of Chapter ID and text <br/>J_1IVEXGRP Help view for Excise groups <br/>J_1IVEXGRPS Excise Group Maintenance <br/>J_1IVFRMTY Help view for Form type <br/>J_1IVFRTYP Maintenance view for Form Types <br/>J_1IVREGID Help View for the register id <br/>J_1IVSRGRP Help view for serial group <br/>J_1IVT001 Document types for TDS <br/>JV J_1IVTDSDU Payment due date in TDS <br/>J_1IVTRAN Help view for the transaction type <br/>J_1IVTTXID Text maintenance <br/>J_1IVTTXOB Text object maintenance <br/>J_1IVTXNOR Excise tax rates - normal <br/>J_1IVTXRAT Tax rate maintenance <br/>J_1IVTXSPL Excise tax rates <br/>J_1IV_INVC Help view for Vendor Excise invoice <br/>J_1IWRKCUS Plant Settings <br/>J_1I_BCKEXCSUS Customizing table for background capture o <br/>J_1I_CUST_CERT Data table for clearing doc on customer ta <br/>J_1I_EWT_RETURN Annual returns - Documemnt View <br/>J_1I_INBDELV INBOUND DELIVERY DETAILS FROM sus <br/>J_1I_SECCODE Section Codes for Extended Withholding Tax Shobana<br/>J_2IACCBAL Opening/Closing a/c balance table<br/>J_2IEXDATE Register Extraction Dates<br/>J_2IEXTRCT Data Extract table for Excise Registers<br/>J_2ILAYCTR Table for all the layouts of excise rep<br/>J_2IREGBAL Opening/Closing balance table for Raw &<br/>J_2IRG1BAL Opening/Closing balance table for RG1<br/>J_2IRULES Maintainenace of Rule/section<br/>J_2IUTZDAT Utilization dates<br/>?<br/>?<br/>Regards<br/>SATYA<br/>email@removed
__.____._ I will go thro d tables..
Thanx 4 d reply..
Regards,
Shradha
---------------Original Message---------------
From: murty_tsn
Sent: Tuesday, February 23, 2010 2:50 AM
Subject: Tax Related Tables
> Hi Shradha,<br/>?<br/>BSET table is correct table<br/>?<br/>The following are Excise tables, go through these tables and get ur data<br/>?<br/> <br/>SE16-- Click F4 (Function key)<br/>a window appear--Click on the information system<br/>then another screen apeears.<br/>IN that in the Standard selections tab...in the package feild enter the Below value<br/>J1I* <br/>and click OK.<br/>it gives the complete list of Excise tables<br/><br/>Hi You can get several details related to MM,CIN,WM <br/>All CIN tables start with J_1I and J_2I. There are 129 tables.<br/>J_1IEXCHDR (Header data of excise doc.)<br/>J_1IEXCDTL (Line item data of excise doc.)<br/>J_2IRULES (Table for maintenance of excise rules )<br/>J_1IADDEXC Additional Excise rate table <br/>J_1IADDRES Excise Related Address Management <br/>J_1IADDRESS Excise Related Address Management <br/>J_1IARE_ATTRB Excise Bonding: Attributes <br/>J_1IASSVAL Assessable value table for excise calculat <br/>J_1IBILDET Billing Type Determination - India <br/>J_1IBOND Excise Bonding: Bonds/UT-/Running Bond mas <br/>J_1IBOSDEFAULT Default Blling Type for Export <br/>J_1ICALOC Allocation of materials to assets <br/>J_1ICERTIF TDS certificate information <br/>J_1ICHIDTX Text Table for Chapter ID <br/>J_1ICHPTER Chapter ID Master <br/>J_1ICOMP Additional company data <br/>J_1ICONDTAX Tax Codes for Excise Duties Using Conditio <br/>J_1ICUS_BILL_TYP Assign Customer Category to Bill Type <br/>J_1IDCLSDET Document class Determination - India <br/>J_1IEICOCU Excise indicator determination for company <br/>J_1IEICOVE Excise indicator determination for company <br/>J_1IEWTCALID Calendar for Payment Due date-EWT India <br/>J_1IEWTCALID_N Calendar for Payment Due date-EWT India: S <br/>J_1IEWTCHLN Table for Internal and external Challan no <br/>J_1IEWTDOCKEY Document Types for Extended Withholding Ta <br/>J_1IEWTDTCHLN Document Type for Remittance Challan - Cla <br/>J_1IEWTDTPRV Document Types for TDS Provisions -EWT In <br/>J_1IEWTDUEDATE Tax Due Dates <br/>J_1IEWTECESS Education Cess Codes <br/>J_1IEWTHKONT Table for for TDS provisions Accounts / L <br/>J_1IEWTJV Document Types for Journal Vouchers <br/>J_1IEWTNO No range for certificate Printing-EWT Indi <br/>J_1IEWTNUM INTERNAL NO RANGE FOR CHALLANS- EWT INDIA <br/>J_1IEWTNUMGR Number Groups For Internal Challan Numbers <br/>J_1IEWTNUMGR_1 Number Groups For Internal Challan Numbers <br/>J_1IEWTNUMGR_N Number Groups For Internal Challan Numbers <br/>J_1IEWTPROV Table for TDS provisions <br/>J_1IEWTPROVISACC Maintain entries for accts to be considere <br/>J_1IEWTSURC Surcharge Tax Codes <br/>J_1IEWT_CERT SAPscript Forms/section indicators for E <br/>J_1IEWT_CERTIF Certificate Issued Details-EWT India <br/>J_1IEWT_CERTIF_N Certificate Issued Details-EWT India:SECCO <br/>J_1IEWT_CERTNO Number Ranges for Withholding Tax Certific <br/>J_1IEWT_CERT_N SAPscript Forms/section indicators for EWT <br/>J_1IEWT_COMP Surcharge Calculation Methods <br/>J_1IEWT_CUST Customer certificates ,Challan customizin <br/>J_1IEWT_CUSTV View for Document type for Challan Update- <br/>J_1IEWT_ECESS1 Education Cess Rates <br/>J_1IEWT_ECFLAG Separate Tax code for Ecess <br/>J_1IEWT_HC Health check for migration to EWT status. <br/>J_1IEWT_MAPEXM Assign Exemption Reasons to Withholding Ta <br/>J_1IEWT_MAPEXMPT Table for Vendor type/exemption indicators <br/>J_1IEWT_MIGRATE Map Classic tax code to EWT Tax type - Tax <br/>J_1IEWT_SURC Maintain Surcharge Calculation Methods <br/>J_1IEWT_SURC1 Surcharge Rates <br/>J_1IEWT_VENTYP Assign Types of Company to Withholding Tax <br/>J_1IEXCACC Excise Account Assignment table <br/>J_1IEXCDEF Tax default informations <br/>J_1IEXCDEFN Default Condition Types <br/>J_1IEXCDEP Excise information of vendor at detail lev <br/>J_1IEXCDTL Excise invoice line item details <br/>J_1IEXCHDR Excise invoice header detail <br/>J_1IEXCREF Delivery document to excise invoice refren <br/>J_1IEXCTAX Tax calc. - Excise tax rates <br/>J_1IEXESTA Excise indicator determination for co / cu <br/>J_1IEXGRPS Excise Groups <br/>J_1IEXMPTCODE VAT Exempted Tax code <br/>J_1IEXSRDET Excise / Series group determination <br/>J_1IEX_CUST_ACT Define Processing Modes Per Transaction <br/>J_1IEX_CUST_FLDS J1IEX: Incoming Invoices field selections <br/>J_1IEX_CUST_REF Define Reference Documents Per Transaction <br/>J_1IFRDTOT Transaction Table for Forms Tracking-Non S <br/>J_1IFRDTPO tranasction Table for Forms Tracking for P <br/>J_1IFRDTSO Transaction table for Forms Tracking for S <br/>J_1IFRMTYP Form Types <br/>J_1IGRXREF Goods Receipt to Excise Invoice Coss Refer <br/>J_1IGRXSUB GR reference to subcontracting challans <br/>J_1IINDCUS Company Code Settings <br/>J_1IITMDTL Item Details - for Capital goods and subco <br/>J_1IKONV Excise recalculated conditions <br/>J_1ILICDTL Excise Bonding: License detail <br/>J_1ILICHDR Excise Bonding: License Header <br/>J_1ILICTYPE Excise Bonding: License type master <br/>J_1IMATEXP Exceptional materials excise rates <br/>J_1IMESG Message Control <br/>J_1IMINBAL Minimum account balances <br/>J_1IMOCOMP Company and Plant - Excise Additional Data <br/>J_1IMOCUST Customer Master Excise Additional Data <br/>J_1IMOCUSTEWT Maintain PAN no for Customers -EWT India <br/>J_1IMODDET Modvat Determination Table (Input Material <br/>J_1IMOVEND Vendor Master Excise Additional Data <br/>J_1IMOVENDEWT Maintain PAN no for Certificates-EWT India <br/>J_1IMTCHID Combination of Material Number and Chapter <br/>J_1IMVMT Movement types versus register relevance <br/>J_1IMVTGRP Movement type Group for Subcontrcting <br/>J_1INEWJCODE VAT Transition Dummy Jurisdiction Code <br/>J_1INEXCGRP excise group for no range <br/>J_1IPART1 Excise part I detials <br/>J_1IPART2 Excise Part II details <br/>J_1IQEXCISE Quantity based AED, NCCD and SED <br/>J_1IREGSET Excise Registrations J_1IREJMAS Rejection Codes <br/>J_1IRG1 Excise RG1 details <br/>J_1IRG1RNG Group table for RG1 - Number Range Object <br/>J_1IRG23D RG23D register for the depot <br/>J_1IRGSUM RG23 Summary of receipts and issues <br/>J_1IRSNCODEM Exemption Reason Code; e-Filing India Loca <br/>J_1ISERVC Service tax details J_1ISRGRPS Excise Document Series <br/>J_1ISSIRAT s si concessional rates J_1ISTAPPL Tax applicability <br/>J_1ISTATECD State Codes; e-Filing, Localization India <br/>J_1ISTATECDM State Code Mapping; e-Filing India Locali <br/>J_1ISTATECDT State Code Texts; e-Filing India Localiza <br/>J_1ISTRATE Sales tax set off percentages <br/>J_1ISUBATT Subcontracting Scenario Attributes <br/>J_1ISUBBYP Subcontracting Scrap/ Byproduct <br/>J_1ISUBTYP Subtransaction type text <br/>J_1IT030K India Tax account determination ( <br/>T030K + J_1IT030K_V India Tax Account Determination <br/>J_1IT059A Indicator to mention tax exemption <br/>_1ITAXDEP Depreciation computation as per Income Ta <br/>J_1ITAXIND Excise Tax Indicator <br/>J_1ITCJCMAP Tax code and Jurisdiction code mapping <br/>J_1ITCJCUPDATE Updatation table for open documents <br/>J_1ITDS Classic TDS - reference table <br/>J_1ITDSDUE TDS Payment due date customization <br/>J_1ITDSSEC TDS Sections <br/>J_1ITDSTXC TDS - Withholding taxcode and section rel <br/>J_1ITRAN Transaction code <br/>J_1ITRNACC Transaction code vs accounts <br/>J_1IUTILIZE Utilization Determination <br/>J_1IV2ARE_ATTRB Make Settings for ARE-1 Procedure <br/>J_1IVARE_ATTRB Make Settings for ARE-3 Procedure <br/>J_1IVATDATE Maintain Valid from date of VAT legislatio <br/>J_1IVATDATE_V Maintain Valid from date of VAT legislatio <br/>J_1IVATINVOICE Billing type determination for VAT <br/>J_1IVATREGIO States Under VAT regime <br/>J_1IVCHID View of Chapter ID and text <br/>J_1IVEXGRP Help view for Excise groups <br/>J_1IVEXGRPS Excise Group Maintenance <br/>J_1IVFRMTY Help view for Form type <br/>J_1IVFRTYP Maintenance view for Form Types <br/>J_1IVREGID Help View for the register id <br/>J_1IVSRGRP Help view for serial group <br/>J_1IVT001 Document types for TDS <br/>JV J_1IVTDSDU Payment due date in TDS <br/>J_1IVTRAN Help view for the transaction type <br/>J_1IVTTXID Text maintenance <br/>J_1IVTTXOB Text object maintenance <br/>J_1IVTXNOR Excise tax rates - normal <br/>J_1IVTXRAT Tax rate maintenance <br/>J_1IVTXSPL Excise tax rates <br/>J_1IV_INVC Help view for Vendor Excise invoice <br/>J_1IWRKCUS Plant Settings <br/>J_1I_BCKEXCSUS Customizing table for background capture o <br/>J_1I_CUST_CERT Data table for clearing doc on customer ta <br/>J_1I_EWT_RETURN Annual returns - Documemnt View <br/>J_1I_INBDELV INBOUND DELIVERY DETAILS FROM sus <br/>J_1I_SECCODE Section Codes for Extended Withholding Tax Shobana<br/>J_2IACCBAL Opening/Closing a/c balance table<br/>J_2IEXDATE Register Extraction Dates<br/>J_2IEXTRCT Data Extract table for Excise Registers<br/>J_2ILAYCTR Table for all the layouts of excise rep<br/>J_2IREGBAL Opening/Closing balance table for Raw &<br/>J_2IRG1BAL Opening/Closing balance table for RG1<br/>J_2IRULES Maintainenace of Rule/section<br/>J_2IUTZDAT Utilization dates<br/>?<br/>?<br/>Regards<br/>SATYA<br/>email@removed
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
