SAP table TCCAA (Payment cards: Clearing account/external functions)
SAP table TCCAA has 3 primary key fields being MANDT,KTOPL,HKONT_V.
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 | |
| KTOPL | Chart of Accounts | CHAR | 4 | 0 | T004 | KTOPL | |
| HKONT_V | Payment Cards: Receivables Account | CHAR | 10 | 0 | SKA1 | HKONT_V | |
| HKONT_N | Payment Cards: Clearing Account | CHAR | 10 | 0 | SKA1 | HKONT_N | |
| FNSET | Payment Cards: Settlement Function | CHAR | 30 | 0 | TFDIR | FNSET | |
| RFCSET | Logical destination (specified in function call) | CHAR | 32 | 0 | RFCDES | RFCDEST | |
| FNAUT | Payment cards: Authorization function | CHAR | 30 | 0 | TFDIR | FNAUT | |
| RFCAUT | Logical destination (specified in function call) | CHAR | 32 | 0 | RFCDES | RFCDEST | |
| MERCH | Payment cards: Merchant ID at the clearing house | CHAR | 15 | 0 | TCCM | MERCH | |
| FNAUT_SETINIT | Payment Cards: Function for Initialization SET Authorization | CHAR | 30 | 0 | TFDIR | FNAUT_SETINIT | |
| FNAUT_SETINFO | Payment Cards: Function for Result of Authorization (SET) | CHAR | 30 | 0 | TFDIR | FNAUT_SETINFO | |
| FNSETRESP | Payment Cards: Settlement Answer Function | CHAR | 30 | 0 | TFDIR | FNSETRESP |
TCCAA foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TCCAA | FNAUT | TFDIR | Function Module | FUNCNAME |
| 1 TCCAA | FNAUT_SETINFO | TFDIR | Function Module | FUNCNAME |
| 0 TCCAA | FNAUT_SETINIT | TFDIR | Function Module | FUNCNAME |
| 1 TCCAA | FNSET | TFDIR | Function Module | FUNCNAME |
| 0 TCCAA | FNSETRESP | TFDIR | Function Module | FUNCNAME |
| 1 TCCAA | HKONT_N | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 TCCAA | HKONT_N | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 TCCAA | HKONT_N | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 TCCAA | HKONT_V | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 TCCAA | HKONT_V | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 TCCAA | HKONT_V | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 TCCAA | KTOPL | T004 | Directory of Charts of Accounts | MANDT |
| 0 TCCAA | MERCH | TCCM | Payment cards: Merchant ID | MANDT |