OPN_J1 is an SAP table in package FBZ (Payments), used in FI (Financial Accounting), FI-AP / FI-AR (payment program). View details, fields & related tables of OPN_J1 in SAP.
- Table description : Japanese DME Foreign Payment Accounting Data (Open FI)
- Module : FI (Financial Accounting)
- Component : FI-AP / FI-AR (payment program)
- Package : FBZ

Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP OPN_J1 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| BUKRS | Company Code | BUKRS | BUKRS |
| GJAHR | Fiscal Year | GJAHR | GJAHR |
| BELNR | Accounting Document Number | BELNR_D | BELNR |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | BUZEI |
| SEQNO | Line number | LINE_NR | NUM02 |
| EXCAT_1 | Exchange Rate Category | EXCAT_EBJP | DTWSX |
| PYAMT_1 | Payment Amount in Accounting Data | PAMT_EBJP | NUM15 |
| CONNO_1 | Contract Number with House Bank | CONNO_EBJP | CHAR16 |
| ACURR_1 | Currency (SWIFT Code) | CURR_EBJP | CHAR3 |
| ACTYP_1 | Account type (1:Futsu, 2:Touza, 4:Chochiku) | ACTYP_EBJP | NUMC1 |
| ACTNO_1 | Account number at the bank | ACTNO_EBJP | NUMC10 |
| EXCAT_2 | Exchange Rate Category | EXCAT_EBJP | DTWSX |
| PYAMT_2 | Payment Amount in Accounting Data | PAMT_EBJP | NUM15 |
| CONNO_2 | Contract Number with House Bank | CONNO_EBJP | CHAR16 |
| ACURR_2 | Currency (SWIFT Code) | CURR_EBJP | CHAR3 |
| ACTYP_2 | Account type (1:Futsu, 2:Touza, 4:Chochiku) | ACTYP_EBJP | NUMC1 |
| ACTNO_2 | Account number at the bank | ACTNO_EBJP | NUMC10 |
| EXCAT_3 | Exchange Rate Category | EXCAT_EBJP | DTWSX |
| PYAMT_3 | Payment Amount in Accounting Data | PAMT_EBJP | NUM15 |
| CONNO_3 | Contract Number with House Bank | CONNO_EBJP | CHAR16 |
| ACURR_3 | Currency (SWIFT Code) | CURR_EBJP | CHAR3 |
| ACTYP_3 | Account type (1:Futsu, 2:Touza, 4:Chochiku) | ACTYP_EBJP | NUMC1 |
| ACTNO_3 | Account number at the bank | ACTNO_EBJP | NUMC10 |
| HBKID | Short key for a house bank | HBKID | HBKID |
| ACTID_1 | ID for account details | HKTID | HKTID |
| ACTID_2 | ID for account details | HKTID | HKTID |
| ACTID_3 | ID for account details | HKTID | HKTID |
| GLACT_1 | General Ledger Account | HKONT | SAKNR |
| GLACT_2 | General Ledger Account | HKONT | SAKNR |
| GLACT_3 | General Ledger Account | HKONT | SAKNR |
OPN_J1 related tables
| Table | Note |
|---|---|
| OPN_J1 | Japanese DME Foreign Payment Accounting Data (Open FI) |
| EJES_CHECK_IN | Register for Japanese Estimation Features |
| EPOWERF | Power Factor for Japanese Billing |
| IDFIAA_JP_TAX1 | Japanese Tax Report - Areas and Transaction Types |
| IDFIAA_JP_TAX2 | Japanese Tax Report - Transaction Types Intra-City Transfer |
| T058A | Japanese Stamp Tax |
| EIUV | Foreign Trade: Incompletion Log for Foreign Trade Data |
| FTULO | Foreign Trade: Work Table for UPLOAD of Foreign Trade Data |
| T617 | Foreign Trade: Proposal for Foreign Trade Header Data |
| DFKKKO | Header Data in Open Item Accounting Document |
| J_1AOIFWVL | Open item foreign currency valuation: temp. storage |
| CRMM_BUAG_BUPA | Active Open Item Accounting (FI-AR or FI-CA) for BP |
| REGUHM | Payment Data for Cross-Payment Run Payment Medium |
| REGUVM | Payment Data for Cross-Payment Run Payment Medium |
| MLDZ4 | Reporting Data for Z4 Which was not Reported by DME |
Related tcodes for OPN_J1
Transaction codes in the same SAP package (FBZ) as the OPN_J1 table.
| Tcode | Description |
|---|---|
| FBN2 | Number Range Maintenance: FI_PYORD |
| OBF5 | C FI Maint. Table T042OFI/T042OFIT |
| OBW3 | Instructions in Payment Transactions |
| FCHU | Create Reference for Check |
| OBCZ | C FI Maintain Table T021E |
| OBIA | C FI Maintain View Cluster VC_TFAG |
| OBIB | Parameter Transaction for V_TFAGM |
| OBWR | C FI Maintain Table FEDIWF1 |
| FIPAY_CUST01 | Maintenance View V_FIPAY_T042_GTS |
| FIPAY_BDGTS01 | Subsequent SPL Screening |
| S_AC0_52000065 | (empty) |
| S_AC0_52000066 | (empty) |
Latest Table Searches
Handling units sap table in SAPHow to display handling unit table in SAP
Sap handling unit zuordnung löschen table in SAP
Where to find handling unit table in SAP
Handling unit management configuration wm table in SAP
Handling unit wm table in SAP
What is sap handling unit table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP