SAP Table OPN_J1
Japanese DME Foreign Payment Accounting Data (Open FI)
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table OPN_J1 (Japanese DME Foreign Payment Accounting Data (Open FI)) is a standard table in SAP ERP. It belongs to the package FBZ.
Technical Information
| Table | OPN_J1 |
| Short Text | Japanese DME Foreign Payment Accounting Data (Open FI) |
| Package | FBZ |
| Table Type | Transparent Table |
Fields for Table OPN_J1
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
| BUKRS | ✔ | Company Code | BUKRS | CHAR | 4 | * |
| GJAHR | ✔ | Fiscal Year | GJAHR | NUMC | 4 | |
| BELNR | ✔ | Accounting Document Number | BELNR_D | CHAR | 10 | |
| BUZEI | ✔ | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | |
| SEQNO | Line number | LINE_NR | NUMC | 2 | ||
| EXCAT_1 | Exchange Rate Category | EXCAT_EBJP | NUMC | 2 | * | |
| PYAMT_1 | Payment Amount in Accounting Data | PAMT_EBJP | NUMC | 15 | ||
| CONNO_1 | Contract Number with House Bank | CONNO_EBJP | CHAR | 16 | ||
| ACURR_1 | Currency (SWIFT Code) | CURR_EBJP | CHAR | 3 | ||
| ACTYP_1 | Account type (1:Futsu, 2:Touza, 4:Chochiku) | ACTYP_EBJP | NUMC | 1 | ||
| ACTNO_1 | Account number at the bank | ACTNO_EBJP | NUMC | 10 | ||
| EXCAT_2 | Exchange Rate Category | EXCAT_EBJP | NUMC | 2 | * | |
| PYAMT_2 | Payment Amount in Accounting Data | PAMT_EBJP | NUMC | 15 | ||
| CONNO_2 | Contract Number with House Bank | CONNO_EBJP | CHAR | 16 | ||
| ACURR_2 | Currency (SWIFT Code) | CURR_EBJP | CHAR | 3 | ||
| ACTYP_2 | Account type (1:Futsu, 2:Touza, 4:Chochiku) | ACTYP_EBJP | NUMC | 1 | ||
| ACTNO_2 | Account number at the bank | ACTNO_EBJP | NUMC | 10 | ||
| EXCAT_3 | Exchange Rate Category | EXCAT_EBJP | NUMC | 2 | * | |
| PYAMT_3 | Payment Amount in Accounting Data | PAMT_EBJP | NUMC | 15 | ||
| CONNO_3 | Contract Number with House Bank | CONNO_EBJP | CHAR | 16 | ||
| ACURR_3 | Currency (SWIFT Code) | CURR_EBJP | CHAR | 3 | ||
| ACTYP_3 | Account type (1:Futsu, 2:Touza, 4:Chochiku) | ACTYP_EBJP | NUMC | 1 | ||
| ACTNO_3 | Account number at the bank | ACTNO_EBJP | NUMC | 10 | ||
| HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | * | |
| ACTID_1 | ID for account details | HKTID | CHAR | 5 | * | |
| ACTID_2 | ID for account details | HKTID | CHAR | 5 | * | |
| ACTID_3 | ID for account details | HKTID | CHAR | 5 | * | |
| GLACT_1 | General Ledger Account | HKONT | CHAR | 10 | * | |
| GLACT_2 | General Ledger Account | HKONT | CHAR | 10 | * | |
| GLACT_3 | General Ledger Account | HKONT | CHAR | 10 | * |