1. Home
  2. Resources
  3. SAP Tables
  4. T028P - Assign Search Strings to Bank Statement Transactions

SAP Table T028P

Assign Search Strings to Bank Statement Transactions

T028P (Assign Search Strings to Bank Statement Transactions) 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 T028P to other SAP tables.

Source: T028P (Assign Search Strings to Bank Statement Transactions)

T028P table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
HBKID Short Key for a House Bank HBKID T012 CHAR 5 0
HKTID ID for account details HKTID T012K CHAR 5 0
INTAG Interpretation algorithms for use with pattern search PAMA_INTAG NUMC 3 0
999 All Interpretation Algorithms
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
040 040: Treasury: Standard first, then loan search
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
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
PANAM Search string name PAMA_PANAM TPAMA CHAR 20 0
TARGFI Target Field PAMA_TAFI CHAR 10 0
NULL Payment Notes
EBGSBER Business Area
EBPRCTR Profit Center
EBKOSTL Cost Center
EBVGINT Posting Rule
EBCHECT Check-/DME Reference-/Assignment Number
EBSPESK Fees in account currency
EBKFMOD Account modification
EBINTAG Interpretation algorithm
EBGRPNR Bundle number for grouping line items
EBINFO1 Additional information 1
EBINFO2 Additional information 2
EBFNAM1 BDC Field Name 1
EBFNAM2 BDC Field Name 2
EBFNAM3 BDC Field Name 3
EBFVAL1 BDC Field Value 1
EBFVAL2 BDC Field Value 2
EBFVAL3 BDC Field Value 3
EBFKOA1 BDC Account Type 1
EBFKOA2 BDC Account Type 2
EBFKOA3 BDC Account Type 3
EBAVKON Account Number
EBAVKOA Account Type
VGEXT External business transaction VGEXT_EB T028G CHAR 27 0
VOZPM +/- sign of the incoming amount VOZPM_EB CHAR 1 0
+ Positive value
- Negative value
ENABLED Search string active PAMA_EBLD CHAR 1 0
PARTN Business Partner PARTN_EB CHAR 55 0
PREFIX Mapping prefix PAMA_PRFX CHAR 32 0
IDFLAG Business partner identification PAMA_IDFL CHAR 1 0

T028P foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T028P BUKRS T028P BUKRS T001 Company Codes BUKRS
T028P BUKRS T028P MANDT T001 Company Codes MANDT
T028P HBKID T028P HBKID T012 House Banks HBKID
T028P HBKID T028P MANDT T012 House Banks MANDT
T028P HBKID T028P BUKRS T012 House Banks BUKRS
T028P HKTID T028P BUKRS T012K House Bank Accounts BUKRS
T028P HKTID T028P HKTID T012K House Bank Accounts HKTID
T028P HKTID T028P HBKID T012K House Bank Accounts HBKID
T028P HKTID T028P MANDT T012K House Bank Accounts MANDT
T028P MANDT T028P MANDT T000 Clients MANDT
T028P PANAM T028P MANDT TPAMA Search Strings for Pattern Matching MANDT
T028P PANAM 'EBST' TPAMA Search Strings for Pattern Matching APPLI
T028P PANAM T028P PANAM TPAMA Search Strings for Pattern Matching PANAM
T028P VGEXT T028P MANDT T028G Allocate External to Internal Transactions MANDT
T028P VGEXT * T028G Allocate External to Internal Transactions VGTYP
T028P VGEXT T028P VGEXT T028G Allocate External to Internal Transactions VGEXT
T028P VGEXT T028P VOZPM T028G Allocate External to Internal Transactions VOZPM