SAP ABAP Table J_1IPART2 (Excise Part II details)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J1I2 (Package) India, Phase II

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1IPART2	Table Relationship Diagram
Short Description	Excise Part II details

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EXGRP	☑	J_1IEXCGRP	J_1IEXCGRP	CHAR	2	0	Excise Group	J_1IEXGRPS
3	REGTYP	☑	J_1IREGTYP	J_1IREGTYP	CHAR	1	0	Excise Register Type
4	SYEAR	☑	J_1IYEAR	NUMC4	NUMC	4	0	Year of Register Entry
5	SERIALNO	☑	J_1ISRLNO2	NUMC10	NUMC	10	0	Serial Number
6	TRNTYP	☐	J_1ITRNTYP	J_1ITRNTYP	CHAR	4	0	Excise Transaction Type	J_1ITRAN
7	DOCNO	☐	J_1IDOCNO	J_1IDOCNO	NUMC	10	0	Internal Excise Document Number	J_1IEXCHDR
8	DOCYR	☐	J_1IDOCUYR	J_1IDOCUYR	NUMC	4	0	Year
9	REFDOC	☐	J_1IREFDOC	CHAR12	CHAR	12	0	Reference document
10	REFYEAR	☐	J_1IRYEAR1	CHAR4	CHAR	4	0	Reference year 1
11	REFITEM	☐	J_1IRITEM1	NUMC6	NUMC	6	0	Reference Item 1
12	REFIND	☐	J_1IRIND1	J_1IRIND	CHAR	1	0	Reference Document Type 1
13	ACTTYP	☐	J_1IACTTYP	CHAR4	CHAR	4	0	Activity type for external tax system
14	FAWREF	☐	J_1IFAWREF	AWREF	CHAR	10	0	Accounting Document
15	FAWTYP	☐	J_1IFAWTYP	AWTYP	CHAR	5	0	Object type of calling application (FI)	TTYP
16	FABLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
17	FAYEAR	☐	J_1IFAYEAR	NUMC4	NUMC	4	0	Financial posting year
18	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
19	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
20	EXCUR	☐	J_1IEXCCUR	WAERS	CUKY	5	0	Currency	TCURC
21	EXBED	☐	J_1IEXCBED	WERT7	CURR	13	2	Basic Excise Duty
22	EXSED	☐	J_1IEXCSED	WERT7	CURR	13	2	Special Excise Duty
23	EXAED	☐	J_1IEXCAED	WERT7	CURR	13	2	Additional Excise Duty
24	CESS	☐	J_1IEXCESS	WERT7	CURR	13	2	Cess amount
25	PART2YR	☐	J_1IYEAR	NUMC4	NUMC	4	0	Year of Register Entry
26	RG23ASER	☐	J_1I23ASER	NUMC10	NUMC	10	0	RG23A serial no.
27	RG23CSER	☐	J_1I23CSER	NUMC10	NUMC	10	0	RG23C serial no.
28	RGPLASER	☐	J_1IPLASER	NUMC10	NUMC	10	0	PLA serial no.
29	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
30	DOWNL	☐	J_1IDOWNL	XFELD	CHAR	1	0	Download indicator
31	CERTNO	☐	J_1ICERTNO	CHAR20	CHAR	20	0	Certificate number for capital goods
32	CERTDT	☐	J_1ICERTDT	CK_DATUM	DATS	8	0	Certificate Date
33	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
34	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
35	CPUDT	☐	J_1ICPUDT	DATUM	DATS	8	0	Excise Document Entry Date
36	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
37	NCCD	☐	J_1IEXNCCD	WERT7	CURR	13	2	NCCD Value
38	ECS	☐	J_1IEXECS	WERT7	CURR	13	2	ECS Value
39	EXADDTAX1	☐	J_1IEXADDTAX1	WERT7	CURR	13	2	Additional Tax1 value
40	EXADDTAX2	☐	J_1IEXADDTAX2	WERT7	CURR	13	2	Additional Tax2 value
41	EXADDTAX3	☐	J_1IEXADDTAX3	WERT7	CURR	13	2	Additional Tax3 value
42	SERTAXSERNO	☐	J_1ISERTAXNO	NUMC10	NUMC	10	0	Service Tax Serial Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1IPART2	BUKRS	T001	BUKRS
2	J_1IPART2	DOCNO	J_1IEXCHDR	DOCNO
3	J_1IPART2	EXCUR	TCURC	WAERS
4	J_1IPART2	EXGRP	J_1IEXGRPS	J_1IEXCGRP
5	J_1IPART2	FABLART	T003	BLART
6	J_1IPART2	FAWTYP	TTYP	AWTYP
7	J_1IPART2	MANDT	T000	MANDT
8	J_1IPART2	TRNTYP	J_1ITRAN	J_1ITRNTYP

History

Last changed by/on	SAP	20130529
SAP Release Created in