TKB1A SAP (Settlement Profile) Table details

Dictionary Type: Table
Description: Settlement Profile




ABAP Code to SELECT data from TKB1A
Related tables to TKB1A
Access table TKB1A




Table field list including key, data, relationships and ABAP select examples

TKB1A is a standard SAP Table which is used to store Settlement Profile data and is available within R/3 SAP systems depending on the version and release level.

The TKB1A table consists of various fields, each holding specific information or linking keys about Settlement Profile data available in SAP. These include APROF (Settlement profile), PREIS (Identifier for 'cost component structure'), EPUPD ('Proof of origin' - Indicator), HPROZ (Identifier for '100% validation').. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

Text table = TKB1B


SAP TKB1A table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
APROFSettlement profile APROFCHAR6ALPHAAPROF
PREISIdentifier for 'cost component structure' ABRPREISCHAR1XFELD
EPUPD'Proof of origin' - Indicator ABREPUPDCHAR1XFELD
HPROZIdentifier for '100% validation' HPROZCHAR1XFELD
MAXBRMaximum number of distribution rules ABRMAXBRNUMC3NUMC3
BETRAIdentifier 'Settlement by amount' ABRBETRACHAR1XFELD
MENGEIdentifier 'settlement by quantity' ABRMENGECHAR1XFELD
PROZEIdentifier for 'percentage-rate settlement' ABRPROZECHAR1XFELD
AQZIFIdentifier 'settlement by equivalence number' ABRAQZIFCHAR1XFELD
ABSCHDefault value for allocation structure ABRABSCHCHAR2TKB5AABSCH
URSCHProposal for Source Structure ABRURSCHCHAR2ALPHAURSCH
KOVORDefault receiver object type ABRKOVORCHAR2OBARTJ_OBART_LD
ABSAKSettlement to G/L account ABSAKCHAR1ABREMPKZ
ABKSTSettlement to cost center ABKSTCHAR1ABREMPKZ
ABAUFSettlement to order ABAUFCHAR1ABREMPKZ
ABPROSettlement to a WBS element ABPROCHAR1ABREMPKZ
ABANLSettlement to fixed asset ABANLCHAR1ABREMPKZ
ABMATSettlement to material ABMATCHAR1ABREMPKZ
ABNVGSettlement to network ABNVGCHAR1ABREMPKZ
ABBOBSettlement to a profitability segment ABBOBCHAR1ABREMPKZ
ABPRCSettlement to sales order ABPRCCHAR1ABREMPKZ
ABIMMSettlement to real estate object ABIMMCHAR1ABREMPKZ
BLARTDocument type 'Accounting document (FI) for CO settlement ABRBLARTCHAR2T003BLART
RESAUResidence time for settlement document in calendar months RESAUNUMC3NUMC3
ERSCHPA transfer structure ERSCHCHAR2TKB9AALPHAERSCH
RIFINDDerivation Rule for Recovery Indicator in Settlement (JV) JV_RIFINDCHAR1JV_RIFIND
FM_DERIVEDerive Fund and Functional Area as Receiver PS_DERIVECHAR1CHAR1
HBSCHLSettlement: Credit posting key ABRBSCHLHACHAR2Assigned to domainBSCHL
SBSCHLSettlement: Debit posting key ABRBSCHLSOCHAR2Assigned to domainBSCHL
VARIASettle Variances ABRVARIACHAR1XFELD
ABKTRSettlement to cost objects ABKTRCHAR1ABREMPKZ
ABPRZSettlement to a business process ABPRZCHAR1ABREMPKZ
ABAUPSettlement to order item ABAUPCHAR1ABREMPKZ
ABRISTActual cost settlement/ cost of sales ABRISTCHAR1ABRIST
FM_DERIVE_FONDSDerive Funds from Recipient PS_DERIVE_FONDSCHAR1CHAR1
FM_DERIVE_FKBERDerive Functional Area from Recipient PS_DERIVE_FKBERCHAR1CHAR1
FM_DERIVE_GRANTDerive Grant from Recipient PS_DERIVE_GRANTCHAR1CHAR1

Key field Non-key field



How do I retrieve data from SAP table TKB1A using ABAP code

The following ABAP code Example will allow you to do a basic selection on TKB1A to SELECT all data from the table
DATA: WA_TKB1A TYPE TKB1A.

SELECT SINGLE *
FROM TKB1A
INTO CORRESPONDING FIELDS OF WA_TKB1A
WHERE...

How to access SAP table TKB1A

Within an ECC or HANA version of SAP you can also view further information about TKB1A and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!