1. Home
  2. Resources
  3. SAP Tables
  4. T028G - Allocate External to Internal Transactions

SAP Table T028G

Allocate External to Internal Transactions

T028G (Allocate External to Internal 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 T028G to other SAP tables.

T028G table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VGTYP Transaction type VGTYP_EB T028V CHAR 8 0
VGEXT External business transaction VGEXT_EB CHAR 27 0
VOZPM +/- sign of the incoming amount VOZPM_EB CHAR 1 0
+ Positive value
- Negative value
VGINT Posting rule VGINT_EB T028D CHAR 4 0
VGSAP SAP bank transaction VGSAP_EB CHAR 4 0
PFORM Processing Type PFORM_EB NUMC 2 0
00 Dummy entry - not assignable
01 Clearing with check
02 Closing Balance
03 Opening Balance
04 Clearing with allocation no.
05 Bank transfer BACS/ bk collection BACS/ customer cash inflow
06 Bank charges / interest / dividends
07 Total cash outflow per file
08 Total cash inflow per file
09 Refused transfer/ bank collection
11 Brazil: Enter document with Brazilian data
12 Clearing the payment advice completes posting
20 BAI: Total Balance
21 BAI: Early Balance
22 BAI: Later Balance
23 BAI: Adjustment Balance
24 BAI: Other Balance
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
DADET Planning type, transaction DSART_DET CHAR 2 0

T028G foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T028G MANDT T028G MANDT T000 Clients MANDT
T028G VGINT T028G MANDT T028D Define Internal Transactions in Electronic Banking MANDT
T028G VGINT T028G VGINT T028D Define Internal Transactions in Electronic Banking VGINT
T028G VGTYP T028G MANDT T028V Transaction Types MANDT
T028G VGTYP T028G VGTYP T028V Transaction Types VGTYP