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