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

Possible values

MANDT

Client

MANDT

T000

CLNT

VGTYP

Transaction type

VGTYP_EB

T028V

CHAR

VGEXT

External business transaction

VGEXT_EB

CHAR

VOZPM

+/- sign of the incoming amount

VOZPM_EB

CHAR

Value	Description
+	Positive value
-	Negative value

VGINT

Posting rule

VGINT_EB

T028D

CHAR

VGSAP

SAP bank transaction

VGSAP_EB

CHAR

PFORM

Processing Type

PFORM_EB

NUMC

Value	Description
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

Value	Description
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

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