J_1ILOCHDR SAP (EXIM : Letter of Credit Header) Table details
Dictionary Type: Table
Description: EXIM : Letter of Credit Header
Description: EXIM : Letter of Credit Header
Table field list including key, data, relationships and ABAP select examples
J_1ILOCHDR is a standard SAP Table which is used to store EXIM : Letter of Credit Header data and is available within R/3 SAP systems depending on the version and release level.
The J_1ILOCHDR table consists of various fields, each holding specific information or linking keys about EXIM : Letter of Credit Header data available in SAP. These include LCNUM (Letter of Credit Number), LCVER (Letter of Credit Version), LCTYP (Letter of Credit Processing Type), LCDOCTYP (Letter of Credit Document Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP J_1ILOCHDR table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| LCNUM | Letter of Credit Number | J1I_LCNUM | CHAR | 10 | ALPHA | J1I_LCNUM | |||
| LCVER | Letter of Credit Version | J_1ILCVER | NUMC | 3 | NUMC3 | ||||
| LCTYP | Letter of Credit Processing Type | J1I_LCTYP | CHAR | 1 | J1I_LCTYP | ||||
| LCDOCTYP | Letter of Credit Document Type | J1I_LCDOCTYP | CHAR | 1 | J1I_LCDOCTYP | ||||
| LCSTAT | Letter of Credit Status | J1I_LCSTAT | CHAR | 1 | J_1I_EXIMSTATUS | J_1I_APP_STAT | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
| SHIP_FROM | Shipping From | J1I_SHIP_FROM | CHAR | 4 | T001W | WERKS | |||
| SHIP_TO | Shipping To | J1I_SHIP_TO | CHAR | 4 | T001W | WERKS | |||
| LAND_ORIGIN | Country of Origin | J1I_ORIGIN_LAND | CHAR | 3 | T005 | LAND1 | |||
| LAND_DEST | Destination Country | J1I_DEST_LAND | CHAR | 3 | T005 | LAND1 | |||
| LCAMT | Letter of Credit Amount | J1I_LCAMT | CURR | 13(2) | WERT7 | ||||
| LCBLK_AMT | Blocked Amount | J1I_LCBLKAMT | CURR | 13(2) | WERT7 | ||||
| LCUTL_AMT | Utilized Amount | J1I_LCUTLAMT | CURR | 13(2) | WERT7 | ||||
| LCCUR | Currency | J_1IEXCCUR | CUKY | 5 | TCURC | WAERS | |||
| KKURS | Condition exchange rate for conversion to local currency | KKURS | DEC | 9(5) | KKURS | ||||
| BAANR | Financial document processing: External financial doc. no. | BAANR | CHAR | 40 | BAANR | ||||
| EUPRZ | Financial document processing: Allowed overdraft percentage | EUPRZ | DEC | 5(2) | PRZ32 | ||||
| DATAI | Financial document processing: Opening date | DATAI | DATS | 8 | DATUM | ||||
| DATXA | Financial document processing: Validity end date | DATXA | DATS | 8 | DATUM | ||||
| DATAY | Financial document processing: Latest shipping date | DATAY | DATS | 8 | DATUM | ||||
| DATAH | Financial doc. processing: Date when docs presented to bank | DATAH | DATS | 8 | DATUM | ||||
| DATAA | Financial document processing: Request date | DATAA | DATS | 8 | DATUM | ||||
| DATAJ | Financial document processing: Date of receipt | DATAJ | DATS | 8 | DATUM | ||||
| ANYTG | Number of Days for Document Submission | J_1IANYTG | NUMC | 3 | NUM03 | ||||
| LCGUID | Application GUID | J_1I_EXIM_APPGUID | CHAR | 22 | SYSUUID_22 | ||||
| ACTVER | Active Version | J_1IACTVER | CHAR | 1 | FLAG | ||||
| DOCSET_CHNG | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
| CREA_DATE_TIME | Created Time | J_1I_CRTD_AT | CHAR | 14 | TIMESTAMP | ||||
| CREA_UNAME | Created by | J_1I_CRTD_BY | CHAR | 12 | UNAME | ||||
| LCHG_DATE_TIME | Changed Time | J_1I_CHNGD_AT | CHAR | 14 | TIMESTAMP | ||||
| LCHG_UNAME | Changed By | J_1I_CHNGD_BY | CHAR | 12 | UNAME |
| Key field | Non-key field |
How do I retrieve data from SAP table J_1ILOCHDR using ABAP code
The following ABAP code Example will allow you to do a basic selection on J_1ILOCHDR to SELECT all data from the tableDATA: WA_J_1ILOCHDR TYPE J_1ILOCHDR.
SELECT SINGLE *
FROM J_1ILOCHDR
INTO CORRESPONDING FIELDS OF WA_J_1ILOCHDR
WHERE...
How to access SAP table J_1ILOCHDR
Within an ECC or HANA version of SAP you can also view further information about J_1ILOCHDR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects