SAP ABAP Table J_1I_SALREG (Structure for Sales Register Excise Details)
Hierarchy
☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J1I2 (Package) India, Phase II
Basic Data
Table Category INTTAB    Structure 
Structure J_1I_SALREG   Table Relationship Diagram
Short Description Structure for Sales Register Excise Details    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 BURKS_VF BUKRS_VF BUKRS CHAR 4   0   Company code to be billed *
2 VKORG VKORG VKORG CHAR 4   0   Sales Organization *
3 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel *
4 SPART SPART SPART CHAR 2   0   Division *
5 KUNNR KUNAG KUNNR CHAR 10   0   Sold-to party *
6 VBELN VBELN_VA VBELN CHAR 10   0   Sales Document *
7 AUDAT AUDAT DATUM DATS 8   0   Document Date (Date Received/Sent)  
8 BSTNK BSTNK BSTNK CHAR 20   0   Customer purchase order number  
9 NETWR_SO NETWR_AK WERTV8 CURR 15   2   Net Value of the Sales Order in Document Currency  
10 WAERK WAERK WAERS CUKY 5   0   SD document currency *
11 VBTYP VBTYP VBTYP CHAR 1   0   SD document category  
12 AUART AUART AUART CHAR 4   0   Sales Document Type *
13 VBELN_VL VBELN_VL VBELN CHAR 10   0   Delivery *
14 KUNNR_DEL KUNWE KUNNR CHAR 10   0   Ship-to party *
15 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
16 ERDAT_DEL ERDAT DATUM DATS 8   0   Date on which the record was created  
17 VSTEL VSTEL VSTEL CHAR 4   0   Shipping Point/Receiving Point *
18 LFART LFART LFART CHAR 4   0   Delivery Type *
19 LFDAT LFDAT_V DATUM DATS 8   0   Delivery Date  
20 BTGEW GSGEW MENG15 QUAN 15   3   Total Weight  
21 NTGEW NTGEW_15 MENG15 QUAN 15   3   Net weight  
22 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit *
23 ERDAT_BIL ERDAT DATUM DATS 8   0   Date on which the record was created  
24 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place *
25 VBELN_VF VBELN_VF VBELN CHAR 10   0   Billing document *
26 FKART FKART FKART CHAR 4   0   Billing Type *
27 FKTYP FKTYP FKTYP CHAR 1   0   Billing Category  
28 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
29 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
30 FKDAT FKDAT DATUM DATS 8   0   Billing date for billing index and printout  
31 MWSBK MWSBP WERTV7 CURR 13   2   Tax amount in document currency  
32 NETWR NETWR WERTV8 CURR 15   2   Net Value in Document Currency  
33 ZLSCH SCHZW_BSEG ZLSCH CHAR 1   0   Payment Method *
34 EXGRP J_1IEXCGRP J_1IEXCGRP CHAR 2   0   Excise Group *
35 TRNTYP J_1ITRNTYP J_1ITRNTYP CHAR 4   0   Excise Transaction Type *
36 DOCYR J_1IDOCUYR J_1IDOCUYR NUMC 4   0   Year  
37 DOCNO J_1IDOCNO J_1IDOCNO NUMC 10   0   Internal Excise Document Number *
38 STRTYP J_1ISTRTYP CHAR2 CHAR 2   0   Sub Transaction Type  
39 EXCUR J_1IEXCCUR WAERS CUKY 5   0   Currency *
40 EXCCD J_1IEXCD CHAR40 CHAR 40   0   ECC Number  
41 EXCRN J_1IEXRN CHAR40 CHAR 40   0   Excise Registration Number  
42 EXNUM J_1IEXCNUM J_1IEXCNUM CHAR 10   0   Official Excise Document Number  
43 EXDAT J_1IEXCDAT J_1IEXCDAT DATS 8   0   Excise Document Date  
44 EXBED J_1IEXCBED WERT7 CURR 13   2   Basic Excise Duty  
45 EXSED J_1IEXCSED WERT7 CURR 13   2   Special Excise Duty  
46 EXAED J_1IEXCAED WERT7 CURR 13   2   Additional Excise Duty  
47 CESS J_1IEXCESS WERT7 CURR 13   2   Cess amount  
48 NCCD J_1IEXNCCD WERT7 CURR 13   2   NCCD Value  
49 ECS J_1IEXECS WERT7 CURR 13   2   ECS Value  
50 EXADDTAX1 J_1IEXADDTAX1 WERT7 CURR 13   2   Additional Tax1 value  
51 EXADDTAX2 J_1IEXADDTAX2 WERT7 CURR 13   2   Additional Tax2 value  
52 EXADDTAX3 J_1IEXADDTAX3 WERT7 CURR 13   2   Additional Tax3 value  
53 EXPIND J_1IINDEXP J_1IINDEXP CHAR 1   0   Export Type  
54 CSTNO J_1ICSTNO CHAR40 CHAR 40   0   Central Sales Tax Number  
55 LSTNO J_1ILSTNO CHAR40 CHAR 40   0   Local Sales Tax Number  
56 PANNO J_1IPANNO CHAR40 CHAR 40   0   Permanent Account Number  
57 STATUS J_1ISTATUS J_1ISTATUS CHAR 1   0   Excise Document Status  
58 USNAM J_1IUSNAM CHAR12 CHAR 12   0   Created By  
59 CPUDT J_1ICPUDT DATUM DATS 8   0   Excise Document Entry Date  
60 DEPEXNUM J_1IEXCNUM J_1IEXCNUM CHAR 10   0   Official Excise Document Number  
61 DEPEXYEAR J_1IEXYEAR GJAHR NUMC 4   0   Excise Year  
62 LIFNR J_1ILIFNR J_1ILIFNR CHAR 10   0   Vendor  
63 SHIPFROM LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
64 EXBAS J_1IEXCBAS WERT7 CURR 13   2   Excise Duty Base Amount  
65 USNAM_D J_1IUSNAM CHAR12 CHAR 12   0   Created By  
66 CPUDT_D J_1ICPUDT DATUM DATS 8   0   Excise Document Entry Date  
67 EXGRP_D J_1IEXCGRP J_1IEXCGRP CHAR 2   0   Excise Group *
68 EXBED_D J_1IEXCBED WERT7 CURR 13   2   Basic Excise Duty  
69 EXSED_D J_1IEXCSED WERT7 CURR 13   2   Special Excise Duty  
70 EXAED_D J_1IEXCAED WERT7 CURR 13   2   Additional Excise Duty  
71 CESS_D J_1IEXCESS WERT7 CURR 13   2   Cess amount  
72 NCCD_D J_1IEXNCCD WERT7 CURR 13   2   NCCD Value  
73 ECS_D J_1IEXECS WERT7 CURR 13   2   ECS Value  
74 EXADDTAX1_D J_1IEXADDTAX1 WERT7 CURR 13   2   Additional Tax1 value  
75 EXADDTAX2_D J_1IEXADDTAX2 WERT7 CURR 13   2   Additional Tax2 value  
76 EXADDTAX3_D J_1IEXADDTAX3 WERT7 CURR 13   2   Additional Tax3 value  
History
Last changed by/on SAP  20130529 
SAP Release Created in 617