SAP table J_1IEWTCHLN (Table for Internal and external Challan nos-EWT India.)
SAP table J_1IEWTCHLN has 6 primary key fields being MANDT,BUKRS,BELNR,GJAHR,J_1IINTCHLN,J_1IINTCHDT.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| BELNR | Document Number of an Accounting Document | CHAR | 10 | 0 | BELNR_D | ||
| GJAHR | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| J_1IINTCHLN | Challan Number | CHAR | 12 | 0 | J_1IINTCHLN | ||
| J_1IINTCHDT | Challan Date | DATS | 8 | 0 | J_1IINTCHDT | ||
| J_1IEXTCHLN | Challan Numbers- External | CHAR | 12 | 0 | J_1IEXTCHLN | ||
| J_1IEXTCHDT | Challan Date - External | DATS | 8 | 0 | J_1IEXTCHDT | ||
| BANKL | Short Key for a House Bank | CHAR | 5 | 0 | T012 | HBKID | |
| AUGDT | Clearing Date | DATS | 8 | 0 | AUGDT | ||
| AUGCP | Clearing Entry Date | DATS | 8 | 0 | AUGCP | ||
| AUGBL | Document Number of the Clearing Document | CHAR | 10 | 0 | AUGBL | ||
| BSRCODE | BSR Code for Online Challan Payment | NUMC | 7 | 0 | FIWTIN_BSRCODE | ||
| FIWTIN_FORM_TYPE | Form Type | CHAR | 4 | 0 | FIWTIN_FORM_TYPE |
J_1IEWTCHLN foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 J_1IEWTCHLN | BANKL | T012 | House Banks | BUKRS |
| 1 J_1IEWTCHLN | BUKRS | T001 | Company Codes | BUKRS |
| 0 J_1IEWTCHLN | MANDT | T000 | Clients | MANDT |