SAP Table TKB1A
Settlement Profile
TKB1A (Settlement Profile) 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 TKB1A to other SAP tables.
TKB1A table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
APROF
Settlement profile
|
APROF |
CHAR
|
6 | 0 | ||||||||||||||
|
PREIS
Identifier for "cost component structure"
|
ABRPREIS |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
EPUPD
"Proof of origin" - Indicator
|
ABREPUPD |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
HPROZ
Identifier for "100% validation"
|
HPROZ |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
MAXBR
Maximum number of distribution rules
|
ABRMAXBR |
NUMC
|
3 | 0 | ||||||||||||||
|
BETRA
Identifier "Settlement by amount"
|
ABRBETRA |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
MENGE
Identifier "settlement by quantity"
|
ABRMENGE |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PROZE
Identifier for "percentage-rate settlement"
|
ABRPROZE |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
AQZIF
Identifier "settlement by equivalence number"
|
ABRAQZIF |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABSCH
Default value for allocation structure
|
ABRABSCH | TKB5A |
CHAR
|
2 | 0 | |||||||||||||
|
URSCH
Proposal for Source Structure
|
ABRURSCH |
CHAR
|
2 | 0 | ||||||||||||||
|
KOVOR
Default receiver object type
|
ABRKOVOR |
CHAR
|
2 | 0 | ||||||||||||||
|
ABSAK
Settlement to G/L account
|
ABSAK |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABKST
Settlement to cost center
|
ABKST |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABAUF
Settlement to order
|
ABAUF |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABPRO
Settlement to a WBS element
|
ABPRO |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABANL
Settlement to fixed asset
|
ABANL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABMAT
Settlement to material
|
ABMAT |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABNVG
Settlement to network
|
ABNVG |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABBOB
Settlement to a profitability segment
|
ABBOB |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABPRC
Settlement to sales order
|
ABPRC |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABIMM
Settlement to real estate object
|
ABIMM |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BLART
Document type "Accounting document (FI) for CO settlement
|
ABRBLART | T003 |
CHAR
|
2 | 0 | |||||||||||||
|
RESAU
Residence time for settlement document in calendar months
|
RESAU |
NUMC
|
3 | 0 | ||||||||||||||
|
ERSCH
PA transfer structure
|
ERSCH | TKB9A |
CHAR
|
2 | 0 | |||||||||||||
|
RIFIND
Derivation Rule for Recovery Indicator in Settlement (JV)
|
JV_RIFIND |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
FM_DERIVE
Derive Fund and Functional Area as Receiver
|
PS_DERIVE |
CHAR
|
1 | 0 | ||||||||||||||
|
HBSCHL
Settlement: Credit posting key
|
ABRBSCHLHA |
CHAR
|
2 | 0 | ||||||||||||||
|
SBSCHL
Settlement: Debit posting key
|
ABRBSCHLSO |
CHAR
|
2 | 0 | ||||||||||||||
|
VARIA
Settle Variances
|
ABRVARIA |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABKTR
Settlement to cost objects
|
ABKTR |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABPRZ
Settlement to a business process
|
ABPRZ |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABAUP
Settlement to order item
|
ABAUP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABRIST
Actual cost settlement/ cost of sales
|
ABRIST |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
FM_DERIVE_FONDS
Derive Funds from Recipient
|
PS_DERIVE_FONDS |
CHAR
|
1 | 0 | ||||||||||||||
|
FM_DERIVE_FKBER
Derive Functional Area from Recipient
|
PS_DERIVE_FKBER |
CHAR
|
1 | 0 | ||||||||||||||
|
FM_DERIVE_GRANT
Derive Grant from Recipient
|
PS_DERIVE_GRANT |
CHAR
|
1 | 0 | ||||||||||||||
TKB1A foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TKB1A | ABSCH | TKB1A | MANDT |
TKB5A
Allocation structure
|
MANDT |
| TKB1A | ABSCH | TKB1A | ABSCH |
TKB5A
Allocation structure
|
ABSCH |
| TKB1A | BLART | TKB1A | MANDT |
T003
Document Types
|
MANDT |
| TKB1A | BLART | TKB1A | BLART |
T003
Document Types
|
BLART |
| TKB1A | ERSCH | TKB1A | ERSCH |
TKB9A
Assignment Structure for Settlement to Profitability Anysis
|
ERSCH |
| TKB1A | ERSCH | TKB1A | MANDT |
TKB9A
Assignment Structure for Settlement to Profitability Anysis
|
MANDT |
| TKB1A | MANDT | TKB1A | MANDT |
T000
Clients
|
MANDT |