SAP ABAP Table J_1IPART1 (Excise part I detials)
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_1IPART1   Table Relationship Diagram
Short Description Excise part I detials    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
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_1ISRLNO1 NUMC10 NUMC 10   0   Register Entry Serial Number  
6 MBLNR MBLNR BELNR CHAR 10   0   Number of Material Document  
7 MJAHR MJAHR GJAHR NUMC 4   0   Year of material document  
8 ZEILE MBLPO MBLPO NUMC 4   0   Item in material document  
9 BWART BWART BWART CHAR 3   0   Movement type (inventory management) T156
10 RISIND J_1IRISIND J_1IRISIND CHAR 1   0   Goods Movement Direction  
11 RCPTISSRSN J_2IRIINDI J_2IRIINDI CHAR 3   0   Rcpt/Issu classification codes  
12 TRNTYP J_1ITRNTYP J_1ITRNTYP CHAR 4   0   Excise Transaction Type J_1ITRAN
13 DOCNO J_1IDOCNO J_1IDOCNO NUMC 10   0   Internal Excise Document Number J_1IEXCHDR
14 DOCYR J_1IDOCUYR J_1IDOCUYR NUMC 4   0   Year  
15 ACTTYP J_1IACTTYP CHAR4 CHAR 4   0   Activity type for external tax system  
16 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
17 MAKTX MAKTX TEXT40 CHAR 40   0   Material description  
18 MENGE J_1IEXMENGE MENG13 QUAN 13   3   Excise Invoice Quantity  
19 MEINS J_1IMEINS MEINS UNIT 3   0   Unit of Measure T006
20 DOWNL J_1IDOWNL XFELD CHAR 1   0   Download indicator  
21 DECLRD J_1IDECLRD CHAR1 CHAR 1   0   Item declared for Excise  
22 STATUS J_1IRGSTAT J_1IRGSTAT CHAR 1   0   Register Entry Status  
23 USNAM USNAM XUBNAME CHAR 12   0   User name *
24 CPUDT J_1ICPUDT DATUM DATS 8   0   Excise Document Entry Date  
25 CPUTM CPUTM UZEIT TIMS 6   0   Time of data entry  
26 AENAM J_1IUSNAMC CHAR12 CHAR 12   0   Changed by the user  
27 AEDAT J_1IAEDAT J_1IAEDAT DATS 8   0   Changed on date  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 J_1IPART1 BWART T156 BWART    
2 J_1IPART1 DOCNO J_1IEXCHDR DOCNO    
3 J_1IPART1 EXGRP J_1IEXGRPS J_1IEXCGRP    
4 J_1IPART1 MANDT T000 MANDT    
5 J_1IPART1 MATNR MARA MATNR    
6 J_1IPART1 MEINS T006 MSEHI    
7 J_1IPART1 TRNTYP J_1ITRAN J_1ITRNTYP    
History
Last changed by/on SAP  20110901 
SAP Release Created in