SAP table T076A (Assign Payment Advice Notes to Posting Rules)

SAP table T076A has 6 primary key fields being MANDT,AVSRT,KOART,BUKRS,KONTO,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
AVSRT Payment Advice Type CHAR 2 0 AVSRT
01 Payment advice from lockbox
02 Payment advice from account statement
03 Payment advice from open item processing
04 Payment advice entered manually
05 Payment advice from credit memo display
06 Payment advice from customer (EDI)
07 Payment advice from reference number (DME)
08 Payment advice from correspondence
09 Payment advice from assignment via Internet
10 Zero Balance Notification (EDI)
11 Payment advice from assignment of credits/payments
12 Payment advice retrieved from a file
13 To be adjusted
KOART Payment Advice Account Type CHAR 1 0 KOART_AV
D Customer
K Vendor
S G/L Account
BUKRS Company Code CHAR 4 0 T001 BUKRS
KONTO Account Number CHAR 10 0 KTONR76A
VOZPM +/- sign of the incoming amount CHAR 1 0 VOZPM_EB
+ Positive value
- Negative value
POSFI Post Automatically CHAR 1 0 POSFI_EB
EDIFI Make Posting Automatically in EDI Too CHAR 1 0 EDIFI_EB
VGINT Posting Rule CHAR 4 0 T028D VGINT_EB
KFMOD Account modification CHAR 10 0 KFMOD_EB
INTAG Interpretation Algorithm NUMC 3 0 INTAG_EB
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
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
221 221: Ref.Doc.No. as 021 with Pymt Service Provider Reconcil.
226 226: Ref.Doc.No. as 026 with Pymt Service Provider Reconcil.
411 411: Outgoing Check: Extended Search Function for Check No.
800 800: Switzerland Reference Number for Payment Order
801 801: India Reference Number for Payment Order
802 802: Interpretation Algorithm for Czech Republic + Slovakia
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
VORGA Transaction type for determining bank terms CHAR 8 0 * VORGA_012C
XPPMT Partial Payment Flag CHAR 1 0 XPPMT_49B
POSDS Post CM&F Payment Advice CHAR 1 0 POSDS_EB
EDIDS Create CM Payment Advice Automatically in EDI CHAR 1 0 EDIDS_EB
DSART Planning type CHAR 2 0 T037 DSART
XVERD Summarize Bank Statement Items CHAR 1 0 FFDISXVERD
CURRKEY Class of the Currency Key Used CHAR 8 0 T028O CURRKEY
HKONT General Ledger Account CHAR 10 0 * HKONT76A
BUART Function (batch input, call transaction) CHAR 1 0 FEBFC_BF
Do not post
B Batch input
C CALL TRANSACTION

T076A foreign key relationships

Table Field Check Table Check Field
0 T076A BUKRS T001 Company Codes BUKRS
1 T076A DSART T037 Planning Types DSART
0 T076A MANDT T000 Clients MANDT