OPN_J1 - Japanese DME Foreign Payment Accounting Data (Open FI)

Japanese DME Foreign Payment Accounting Data (Open FI) information is stored in SAP table OPN_J1.
It is part of development package FBZ in software component FI-AP-AP-B. This development package consists of objects that can be grouped under "Payments".

Fields for table OPN_J1

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT3*
BUKRSCompany CodeXBUKRSCHAR4*
GJAHRFiscal YearXGJAHRNUMC4
BELNRDocument Number of an Accounting DocumentXBELNR_DCHAR10
BUZEINumber of Line Item Within Accounting DocumentXBUZEINUMC3
SEQNOLine numberLINE_NRNUMC2
EXCAT_1Exchange Rate CategoryEXCAT_EBJPNUMC2*
PYAMT_1Payment Amount in Accounting DataPAMT_EBJPNUMC15
CONNO_1Contract Number with House BankCONNO_EBJPCHAR16
ACURR_1Currency (SWIFT Code)CURR_EBJPCHAR3
ACTYP_1Account Type (1:Futsu, 2:Touza, 4:Chochiku)ACTYP_EBJPNUMC1
ACTNO_1Account Number at the BankACTNO_EBJPNUMC10
EXCAT_2Exchange Rate CategoryEXCAT_EBJPNUMC2*
PYAMT_2Payment Amount in Accounting DataPAMT_EBJPNUMC15
CONNO_2Contract Number with House BankCONNO_EBJPCHAR16
ACURR_2Currency (SWIFT Code)CURR_EBJPCHAR3
ACTYP_2Account Type (1:Futsu, 2:Touza, 4:Chochiku)ACTYP_EBJPNUMC1
ACTNO_2Account Number at the BankACTNO_EBJPNUMC10
EXCAT_3Exchange Rate CategoryEXCAT_EBJPNUMC2*
PYAMT_3Payment Amount in Accounting DataPAMT_EBJPNUMC15
CONNO_3Contract Number with House BankCONNO_EBJPCHAR16
ACURR_3Currency (SWIFT Code)CURR_EBJPCHAR3
ACTYP_3Account Type (1:Futsu, 2:Touza, 4:Chochiku)ACTYP_EBJPNUMC1
ACTNO_3Account Number at the BankACTNO_EBJPNUMC10
HBKIDShort Key for a House BankHBKIDCHAR5*
ACTID_1ID for Account DetailsHKTIDCHAR5*
ACTID_2ID for Account DetailsHKTIDCHAR5*
ACTID_3ID for Account DetailsHKTIDCHAR5*
GLACT_1General Ledger AccountHKONTCHAR10*
GLACT_2General Ledger AccountHKONTCHAR10*
GLACT_3General Ledger AccountHKONTCHAR10*
Privacy Policy