1. Home
  2. Resources
  3. SAP Tables
  4. U_12398 - Generated Table for View

SAP Table U_12398

Generated Table for View

U_12398 (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link U_12398 to other SAP tables.

Source: U_12398 (Generated Table for View)

U_12398 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KUKEY Short key (surrogate) KUKEY_EB NUMC 8 0
ESNUM Memo record number (line item number in bank statement) ESNUM_EB NUMC 5 0
EPERL Line item completed EPERL_EB CHAR 1 0
VB1OK Update 1 OK VB1OK_EB CHAR 1 0
VB2BA 2nd update processed VB2BA_EB CHAR 1 0
VB2OK 2nd update OK VB2OK_EB CHAR 1 0
PIPRE Line items were interpreted PIPRE_EB CHAR 1 0
GRPNR Bundle number for grouping line items GRPNR_EB CHAR 2 0
ESTAT Error status ESTAT_EB CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BVDAT Posting date at the bank BVDAT_EB DATS 8 0
BUDAT Posting date in the document BUDAT_EB DATS 8 0
VALUT Value date of the item to be cleared VALUT_EB DATS 8 0
BUTIM Value date time BUTIM_EB CHAR 6 0
VOZEI do not use-> now EPVOZ_EP signs (C,RC,D,RD) VOZEI_EB CHAR 2 0
KWAER Account Currency Key KWAER_EB CUKY 5 0
KWBTR Amount in account currency KWBTR_EB CURR 13 2
SPESK Fees in account currency SPESK_EB CURR 13 2
FWAER Foreign currency key (unequal to account currency) FWAER_EB TCURC CUKY 5 0
FWBTR Foreign currency amount (different from account cuurency) FWBTR_EB CURR 13 2
SPESF Fees in foreign currency (not same as account currency) SPESF_EB CURR 13 2
VORGC Business transaction code VORGC_EB CHAR 3 0
TEXTS Text key TEXTS_EB CHAR 4 0
VGEXT External business transaction VGEXT_EB CHAR 27 0
VGMAN Transaction VGMAN_EB CHAR 4 0
VGINT Posting rule VGINT_EB T028D CHAR 4 0
KFMOD Account modification KFMOD_EB CHAR 10 0
VGSAP SAP bank transaction VGSAP_EB CHAR 4 0
BUTXT Bank posting text BUTXT_EB CHAR 50 0
ANZSP Number of collective items ANZSP_EB NUMC 5 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
ZUONR Assignment Number DZUONR CHAR 18 0
PABKS Country key of partner bank PABKS_EB T005 CHAR 3 0
PABLZ Bank number of partner bank PABLZ_EB CHAR 15 0
PASWI SWIFT code of partner bank PASWI_EB CHAR 11 0
PAKTO Account number at the partner bank PAKTO_EB CHAR 18 0
PARTN Business Partner PARTN_EB CHAR 55 0
BUSAB Accounting Clerk BUSAB_EB CHAR 2 0
KOSTL Cost center KOSTL_EB CHAR 10 0
GSBER Business area GSBER_EB CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
VERTN Contract Number RANL CHAR 13 0
VERTT Contract Type RANTYP CHAR 1 0
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
PNOTA Daybook number PNOTA_EB CHAR 10 0
CHECT Check number CHECT CHAR 13 0
STAVV Financial Assets Management status STAVV_EB CHAR 2 0
TXTVV Financial Assets Management Information Field TXTVV_EB CHAR 40 0
EPVOZ Debit/credit key for line items (for bank purposes) EPVOZ_EB CHAR 1 0
INFO1 Additional information 1 INFO1_EB CHAR 30 0
INFO2 Additional information 2 INFO2_EB CHAR 30 0
AVSID Payment Advice Number AVSID CHAR 16 0
INTAG Interpretation algorithm INTAG_EB NUMC 3 0
000 000: No interpretation
001 001: Standard algorithm
011 011:Outgoing Check: Check No. Different from Pymt Doc. No.
012 012: Outgoing check: check number same as payment doc.no.
013 013: Outgoing check: check number = or <> payment doc.no.
015 015: Clearing transaction: selection using assignment
019 019: Reference no. (DME management)
020 020: Document number search
021 021: Reference document number search
022 022: Bank transfer method (Germany only) with doc.numbers
023 023 Bank transfer method (Germany only) with ref.numbers
024 024: Reserved
025 025: Invoice list
026 026: Ref.doc.no. - Search with preceding zeroes if <10
027 027: Reference number (TIT0)
028 028: Reference number using MULTICASH conversion programs
029 029: Payment order number
030 030: Brazilian search using BELNR, GJAHR, and BUZEI
031 031: Document number search (customer number from doc.line)
032 032: Look for EDI payment advice
033 033 Search for Payment Advice Notes
034 034 Finland Reference Number for Payment Order with RFFOFI_A
035 035 Search for structured payment notes -> SAP Note 555352
050 050: REAL ESTATE: First standard, then rental agrmt search
051 051: REAL ESTATE: Rental agreement search, then standard
060 060 Document Number Search for Clearing Documents
120 120 Document Number Search Without Test Read
121 121 Reference Document Number Search Without Test Read
221 221 RefDocNo. as 021 with Payment Service Provider Reconcil.
226 226 RefDocNo. as 026 with Payment Service Provider Reconcil.
901 901: Customer-Specific Interpretation Algorithm 1
902 902: Customer-Specific Interpretation Algorithm 2
903 903: Customer-Specific Interpretation Algorithm 3
904 904: Customer-Specific Interpretation Algorithm 4
905 905: Customer-Specific Interpretation Algorithm 5
906 906: Customer-Specific Interpretation Algorithm 6
907 907: Customer-Specific Interpretation Algorithm 7
908 908: Customer-Specific Interpretation Algorithm 8
909 909 Customer-Specific Interpretation Algorithm 9
NBBLN Subledger document number NBBLN_EB CHAR 10 0
AKBLN Payment on account document number AKBLN_EB CHAR 10 0
KNRZA Account number of an alternative payer KNRZA CHAR 10 0
AVKOA Payment Advice Account Type KOART_AV CHAR 1 0
D Customer
K Vendor
S G/L account
AVKON Account Number KTONR_AV CHAR 10 0
BATCH Batch number (bundle number) BATCH_EB CHAR 3 0
KURSF Exchange rate (different from local currency) KURSF_EB DEC 9 5
SGTXT Item Text SGTXT CHAR 50 0
JPDAT Date of failed bills of exchange in Japan JPDAT_EB DATS 8 0
POSAG Posting algorithm (lockbox only) POSAG_EB CHAR 3 0

U_12398 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
U_12398 FWAER U_12398 MANDT TCURC Currency Codes MANDT
U_12398 FWAER U_12398 FWAER TCURC Currency Codes WAERS
U_12398 MANDT U_12398 MANDT T000 Clients MANDT
U_12398 PABKS U_12398 MANDT T005 Countries MANDT
U_12398 PABKS U_12398 PABKS T005 Countries LAND1
U_12398 VGINT U_12398 MANDT T028D Define Internal Transactions in Electronic Banking MANDT
U_12398 VGINT U_12398 VGINT T028D Define Internal Transactions in Electronic Banking VGINT