fields (22)
| field | type | length | key | description |
|---|---|---|---|---|
KUESSION | char | 20 | pk | bank statement key (internal) |
MANDT | clnt | 3 | pk | client |
AESSION_DAT | dats | 8 | statement date | |
AESSION_NUM | char | 15 | statement number | |
AZESSION | char | 4 | external transaction code | |
BELNR | char | 10 | accounting document number (generated) | |
BUDAT | dats | 8 | posting date | |
BUKRS | char | 4 | company code | |
GJAHR | numc | 4 | fiscal year of posting document | |
HBKID | char | 5 | house bank short key | |
HKONT | char | 10 | gl account for posting | |
HKTID | char | 5 | account id at house bank | |
KUNNR | char | 10 | customer account number | |
KWBTR | curr | 15 | amount in bank statement currency | |
LIFNR | char | 10 | vendor account number | |
PESSION_TXT | char | 60 | posting text / payment reference | |
SESSION_SOL | char | 1 | debit/credit indicator (s=debit, h=credit) | |
SGTXT | char | 50 | item text | |
VESSION | dats | 8 | value date | |
WAESSION | cuky | 5 | currency key | |
XESSION_AUTO | char | 1 | auto-posting indicator | |
XMATCH | char | 1 | reconciliation status (matched) |
relationships (8)
master lookup
reference to master data
configuration
reference to config tables