SAP table T028P (Assign Search Strings to Bank Statement Transactions)

SAP table T028P has 9 primary key fields being MANDT,BUKRS,HBKID,HKTID,INTAG,PANAM,TARGFI,VGEXT,VOZPM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
HKTID ID for Account Details CHAR 5 0 T012K HKTID
INTAG Interpretation Algorithms for Use with Pattern Search NUMC 3 0 PAMA_INTAG
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.
014 014: Outgoing Check: Check Management in FI or HR
015 015: Clearing Transaction: Selection Using Assignment
019 019: Reference Number (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 Line Item)
032 032: Search for EDI Payment Advice
033 033: Search for Payment Advice Notes
034 034: Finland Reference No. for Payment Order with RFFOFI_A
035 035: Search for Structured Payment Notes -> SAP Note 555352
036 036: Extended Search Function for Payment Advices
040 040: Treasury: Standard first, then loan search
050 050: REAL ESTATE: First Standard, Then Rental Agreemt 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
999 All Interpretation Algorithms
PANAM Search String Name CHAR 20 0 TPAMA PAMA_PANAM
TARGFI Target Field CHAR 10 0 PAMA_TAFI
Payment Notes
EBAVKOA Account Type
EBAVKON Account Number
EBCHECT Check-/DME Reference-/Assignment Number
EBFKOA1 BDC Account Type 1
EBFKOA2 BDC Account Type 2
EBFKOA3 BDC Account Type 3
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
EBGRPNR Bundle number for grouping line items
EBGSBER Business Area
EBINFO1 Additional information 1
EBINFO2 Additional information 2
EBINTAG Interpretation algorithm
EBKFMOD Account modification
EBKOSTL Cost Center
EBPRCTR Profit Center
EBSGTXT Item Text
EBSPESK Fees in account currency
EBVGINT Posting Rule
EBXBLNR External Reference
EBZUONR Assignment Number
VGEXT External Business Transaction CHAR 27 0 T028G VGEXT_EB
VOZPM +/- sign of the incoming amount CHAR 1 0 VOZPM_EB
+ Positive value
- Negative value
ENABLED Search String Active CHAR 1 0 PAMA_EBLD
PARTN Business Partner CHAR 55 0 PARTN_EB
PREFIX Mapping Prefix CHAR 32 0 PAMA_PRFX
IDFLAG Business Partner Identification CHAR 1 0 PAMA_IDFL

T028P foreign key relationships

Table Field Check Table Check Field
0 T028P BUKRS T001 Company Codes BUKRS
1 T028P HBKID T012 House Banks BUKRS
0 T028P HKTID T012K House Bank Accounts MANDT
0 T028P HKTID T012K House Bank Accounts BUKRS
0 T028P HKTID T012K House Bank Accounts HBKID
0 T028P HKTID T012K House Bank Accounts HKTID
1 T028P MANDT T000 Clients MANDT
0 T028P PANAM TPAMA Search Strings for Pattern Matching MANDT
0 T028P PANAM TPAMA Search Strings for Pattern Matching APPLI
0 T028P PANAM TPAMA Search Strings for Pattern Matching PANAM
1 T028P VGEXT T028G Allocate External to Internal Transactions MANDT