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
MANDT Client MANDT T000 CLNT 3 0
APROF Settlement profile APROF CHAR 6 0
PREIS Identifier for "cost component structure" ABRPREIS CHAR 1 0
X Yes
NULL No
EPUPD "Proof of origin" - Indicator ABREPUPD CHAR 1 0
X Yes
NULL No
HPROZ Identifier for "100% validation" HPROZ CHAR 1 0
X Yes
NULL No
MAXBR Maximum number of distribution rules ABRMAXBR NUMC 3 0
BETRA Identifier "Settlement by amount" ABRBETRA CHAR 1 0
X Yes
NULL No
MENGE Identifier "settlement by quantity" ABRMENGE CHAR 1 0
X Yes
NULL No
PROZE Identifier for "percentage-rate settlement" ABRPROZE CHAR 1 0
X Yes
NULL No
AQZIF Identifier "settlement by equivalence number" ABRAQZIF CHAR 1 0
X Yes
NULL No
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
NULL Settlement Not Allowed
1 Settlement Optional
2 Settlement Required
ABKST Settlement to cost center ABKST CHAR 1 0
NULL Settlement Not Allowed
1 Settlement Optional
2 Settlement Required
ABAUF Settlement to order ABAUF CHAR 1 0
NULL Settlement Not Allowed
1 Settlement Optional
2 Settlement Required
ABPRO Settlement to a WBS element ABPRO CHAR 1 0
NULL Settlement Not Allowed
1 Settlement Optional
2 Settlement Required
ABANL Settlement to fixed asset ABANL CHAR 1 0
NULL Settlement Not Allowed
1 Settlement Optional
2 Settlement Required
ABMAT Settlement to material ABMAT CHAR 1 0
NULL Settlement Not Allowed
1 Settlement Optional
2 Settlement Required
ABNVG Settlement to network ABNVG CHAR 1 0
NULL Settlement Not Allowed
1 Settlement Optional
2 Settlement Required
ABBOB Settlement to a profitability segment ABBOB CHAR 1 0
NULL Settlement Not Allowed
1 Settlement Optional
2 Settlement Required
ABPRC Settlement to sales order ABPRC CHAR 1 0
NULL Settlement Not Allowed
1 Settlement Optional
2 Settlement Required
ABIMM Settlement to real estate object ABIMM CHAR 1 0
NULL Settlement Not Allowed
1 Settlement Optional
2 Settlement Required
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
1 Transfer from sender summary records
2 Transfer from master records for receiver objects
3 Transfer from master records for settlement cost element
4 Transfer from settlement assignment
5 Manual entry in allocation rule
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
X Yes
NULL No
ABKTR Settlement to cost objects ABKTR CHAR 1 0
NULL Settlement Not Allowed
1 Settlement Optional
2 Settlement Required
ABPRZ Settlement to a business process ABPRZ CHAR 1 0
NULL Settlement Not Allowed
1 Settlement Optional
2 Settlement Required
ABAUP Settlement to order item ABAUP CHAR 1 0
NULL Settlement Not Allowed
1 Settlement Optional
2 Settlement Required
ABRIST Actual cost settlement/ cost of sales ABRIST CHAR 1 0
NULL To Be Settled in Full
1 Can Be Settled
2 Not for Settlement
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 BLART T003 Document Types BLART
TKB1A BLART TKB1A MANDT T003 Document Types MANDT
TKB1A ERSCH TKB1A MANDT TKB9A Assignment Structure for Settlement to Profitability Anysis MANDT
TKB1A ERSCH TKB1A ERSCH TKB9A Assignment Structure for Settlement to Profitability Anysis ERSCH
TKB1A MANDT TKB1A MANDT T000 Clients MANDT