SAP ABAP Table J_1I_PURREG (Structure for Purchase Register Excise Details)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ FI-LOC (Application Component) Localization
⤷ J1I2 (Package) India, Phase II
⤷ FI-LOC (Application Component) Localization
⤷ J1I2 (Package) India, Phase II
Basic Data
Table Category | INTTAB | Structure |
Structure | J_1I_PURREG | Table Relationship Diagram |
Short Description | Structure for Purchase 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 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
2 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
3 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
4 | NAME1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
5 | ORT01 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
6 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
7 | J_1IEXCD | J_1IEXCD | CHAR40 | CHAR | 40 | 0 | ECC Number | ||
8 | J_1IEXRN | J_1IEXRN | CHAR40 | CHAR | 40 | 0 | Excise Registration Number | ||
9 | J_1IEXRG | J_1IEXRG | CHAR60 | CHAR | 60 | 0 | Excise Range | ||
10 | J_1IEXDI | J_1IEXDI | CHAR60 | CHAR | 60 | 0 | Excise Division | ||
11 | J_1IEXCO | J_1IEXCO | CHAR60 | CHAR | 60 | 0 | Excise Commissionerate | ||
12 | J_1ICSTNO | J_1ICSTNO | CHAR40 | CHAR | 40 | 0 | Central Sales Tax Number | ||
13 | J_1ILSTNO | J_1ILSTNO | CHAR40 | CHAR | 40 | 0 | Local Sales Tax Number | ||
14 | J_1IPANNO | J_1IPANNO | CHAR40 | CHAR | 40 | 0 | Permanent Account Number | ||
15 | J_1ISERN | J_1ISERN | CHAR40 | CHAR | 40 | 0 | Service Tax Registration Number | ||
16 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
17 | BEDAT | EBDAT | DATUM | DATS | 8 | 0 | Purchasing Document Date | ||
18 | BSTYP | EBSTYP | EBSTYP | CHAR | 1 | 0 | Purchasing Document Category | ||
19 | BSART | ESART | BSART | CHAR | 4 | 0 | Purchasing Document Type | * | |
20 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | * | |
21 | EKGRP | BKGRP | EKGRP | CHAR | 3 | 0 | Purchasing Group | * | |
22 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
23 | INCO1 | INCO1 | INCO1 | CHAR | 3 | 0 | Incoterms (part 1) | * | |
24 | INCO2 | INCO2 | INCO2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
25 | MBLNR | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
26 | MJAHR | MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
27 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
28 | VGART | VGART | VGART | CHAR | 2 | 0 | Transaction/Event Type | * | |
29 | BLART | BLART | BLART | CHAR | 2 | 0 | Document type | * | |
30 | TRNTYP | J_1ITRNTYP | J_1ITRNTYP | CHAR | 4 | 0 | Excise Transaction Type | * | |
31 | DOCNO | J_1IDOCNO | J_1IDOCNO | NUMC | 10 | 0 | Internal Excise Document Number | * | |
32 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
33 | EXGRP | J_1IEXCGRP | J_1IEXCGRP | CHAR | 2 | 0 | Excise Group | * | |
34 | SRGRP | J_1ISERGRP | J_1ISERGRP | CHAR | 3 | 0 | Excise Document Series Group | * | |
35 | STRTYP | J_1ISTRTYP | CHAR2 | CHAR | 2 | 0 | Sub Transaction Type | ||
36 | EXNUM | J_1IEXCNUM | J_1IEXCNUM | CHAR | 10 | 0 | Official Excise Document Number | ||
37 | EXDAT | J_1IEXCDAT | J_1IEXCDAT | DATS | 8 | 0 | Excise Document Date | ||
38 | EXYEAR | J_1IEXYEAR | GJAHR | NUMC | 4 | 0 | Excise Year | ||
39 | EXCUR | J_1IEXCCUR | WAERS | CUKY | 5 | 0 | Currency | * | |
40 | EXBED | J_1IEXCBED | WERT7 | CURR | 13 | 2 | Basic Excise Duty | ||
41 | EXSED | J_1IEXCSED | WERT7 | CURR | 13 | 2 | Special Excise Duty | ||
42 | EXAED | J_1IEXCAED | WERT7 | CURR | 13 | 2 | Additional Excise Duty | ||
43 | CESS | J_1IEXCESS | WERT7 | CURR | 13 | 2 | Cess amount | ||
44 | RDOC | J_1IRDOC1 | CHAR10 | CHAR | 10 | 0 | Reference Document 1 | ||
45 | EXCCD | J_1IEXCD | CHAR40 | CHAR | 40 | 0 | ECC Number | ||
46 | EXCRN | J_1IEXRN | CHAR40 | CHAR | 40 | 0 | Excise Registration Number | ||
47 | EXCRG | J_1IEXRG | CHAR60 | CHAR | 60 | 0 | Excise Range | ||
48 | EXCDI | J_1IEXDI | CHAR60 | CHAR | 60 | 0 | Excise Division | ||
49 | EXCCO | J_1IEXCO | CHAR60 | CHAR | 60 | 0 | Excise Commissionerate | ||
50 | CSTNO | J_1ICSTNO | CHAR40 | CHAR | 40 | 0 | Central Sales Tax Number | ||
51 | LSTNO | J_1ILSTNO | CHAR40 | CHAR | 40 | 0 | Local Sales Tax Number | ||
52 | PANNO | J_1IPANNO | CHAR40 | CHAR | 40 | 0 | Permanent Account Number | ||
53 | STATUS | J_1ISTATUS | J_1ISTATUS | CHAR | 1 | 0 | Excise Document Status | ||
54 | CENSTAT | J_1ICENST | J_1ICENST | CHAR | 1 | 0 | CENVAT Utilization status | ||
55 | NCCD | J_1IEXNCCD | WERT7 | CURR | 13 | 2 | NCCD Value | ||
56 | ECS | J_1IEXECS | WERT7 | CURR | 13 | 2 | ECS Value | ||
57 | EXADDTAX1 | J_1IEXADDTAX1 | WERT7 | CURR | 13 | 2 | Additional Tax1 value | ||
58 | EXADDTAX2 | J_1IEXADDTAX2 | WERT7 | CURR | 13 | 2 | Additional Tax2 value | ||
59 | EXADDTAX3 | J_1IEXADDTAX3 | WERT7 | CURR | 13 | 2 | Additional Tax3 value | ||
60 | FOLIO | J_1ISRLNO1 | NUMC10 | NUMC | 10 | 0 | Register Entry Serial Number | ||
61 | REF_FOLIO | J_1ISRLNO1 | NUMC10 | NUMC | 10 | 0 | Register Entry Serial Number | ||
62 | EBELNR | J_1IFAWREF | AWREF | CHAR | 10 | 0 | Accounting Document | ||
63 | BELNR | RE_BELNR | BELNR | CHAR | 10 | 0 | Document Number of an Invoice Document | ||
64 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
65 | IBLART | BLART | BLART | CHAR | 2 | 0 | Document type | * | |
66 | INBUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
67 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
68 | RMWWR | RMWWR | WERT7 | CURR | 13 | 2 | Gross invoice amount in document currency | ||
69 | BEZNK | BEZNK | ANLKWERT | CURR | 13 | 2 | Unplanned delivery costs | ||
70 | WMWST1 | JWSTEV | WERTV7 | CURR | 13 | 2 | Tax Amount in Document Currency | ||
71 | MWSKZ1 | MWSKZ_MRM1 | MRM_MWSKZ | CHAR | 2 | 0 | Tax code | * | |
72 | RBSTAT | RBSTAT | RBSTAT | CHAR | 1 | 0 | Invoice document status | ||
73 | IBELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
74 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | * | |
75 | SECCO | SECCO | SECCO | CHAR | 4 | 0 | Section Code | * |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 617 |