1. Home
  2. Resources
  3. SAP Tables
  4. FKKL1 - Account Balance: Work Fields

SAP Table FKKL1

Account Balance: Work Fields

FKKL1 (Account Balance: Work Fields) 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 FKKL1 to other SAP tables.

Source: FKKL1 (Account Balance: Work Fields)

FKKL1 table fields

Field Data element Checktable Datatype Length Decimals
ABWTP Category of substitute document in FI-CA ABWTP_KK CHAR 1 0
R Installment Plan
S Collective Bill
P Promise to Pay
ACOD1 Function to be activated in account balance display FCODE_KK CHAR 4 0
ANDPA Also Select Postings for Other Partners ANDPA_KK CHAR 1 0
X Yes
NULL No
ANWND Application ANWN2_KK CHAR 5 0
DOP Business partner item detail screen
DOPK General ledger item detail screen
INIT Initial screen account balance
DBRP Broker report item detail screen
OP Selection Screen for Open Items
BROK Selection Screen for Broker Account Balance
CHKM Manually Issued Checks
DRG Selection of Items Paid by Third Parties
ICDR Insurance Collection Disbursement Request
ICDRI Insurance Collection Disbursement Request Item
INITC Customer-Specific Selection Screen Account Balance
RIBAL Reinsurance-Specific Selection Screen Account Balance
FPE2M Selection Screen for Mass Change of Documents
LNUMM Fast Entry: Control Entry Number LNUMM_021F NUMC 2 0
APPLK Application area APPLK_KK CHAR 1 0
* Valid for all application areas
M Media Companies
P Public Administration
R Utility company
T Telecommunications
V Insurance company
X In-house development
S Extended FI-CA
AWAER Display currency (for EURO) AWAER_KK CUKY 5 0
BALA_ROLE Role in Account Balance BALA_ROLE_KK TFK021_ROLES CHAR 4 0
BROKR Broker BROKR_KK CHAR 10 0
BUDAT Posting Date in the Document BUDAT_KK DATS 8 0
BUKRS Company Code BUKRS T001 CHAR 4 0
CCABW Chronology in Alternative Display Currency CCABW_KK CHAR 1 0
X Yes
NULL No
CCCUR Currency Key WAERS TCURC CUKY 5 0
CCSTD Chronology in Transaction Currency CCSTD_KK CHAR 1 0
X Yes
NULL No
FITAB Account Balance: Initial Screen For List FITAB_KK CHAR 1 0
1 Receivables
2 Down payments
3 Totals
4 Payment list
5 Chronology
GPART Business Partner Number GPART_KK BUT000 CHAR 10 0
LSTYP List Type for Account Balance Display LSTYP_KK TFK021L CHAR 10 0
NDTXT Text (20 Characters) TEXT20 CHAR 20 0
OPORD Classification Key OPORD_KK CHAR 35 0
PNORM Installment Plans: Select Installment Plan Items PNORM_KK CHAR 1 0
X Yes
NULL No
PRATP Installment Plans: Select Original Items PRATP_KK CHAR 1 0
X Yes
NULL No
PSAMM Read Original Items for Collective Bills PSAMM_KK CHAR 1 0
X Yes
NULL No
RATPL Installment Plan RATPL_KK CHAR 12 0
SAMMR Collective Bill SAMMR_KK CHAR 12 0
SANLI Output Down Payment List SANLI_KK CHAR 1 0
X Yes
NULL No
SNDSP Checkbox XFELD CHAR 1 0
X Yes
NULL No
SNOLI Output standard list SNOLI_KK CHAR 1 0
X Yes
NULL No
SRVAR Sort Variant SRVAR_KK TFK021SV CHAR 3 0
STAK Display all statistical items? STAKZ_ALL CHAR 1 0
X Yes
NULL No
STAKNO Choose Non-Statistical Items STAKZ_NO CHAR 1 0
X Yes
NULL No
STAKA Display down payment requests STAKZ_A CHAR 1 0
X Yes
NULL No
STAKB Display Quotation Items STAKZ_B CHAR 1 0
X Yes
NULL No
STAKG Display statistical outstanding charges? STAKZ_G CHAR 1 0
X Yes
NULL No
STAKH Display cash security deposit requests STAKZ_H CHAR 1 0
X Yes
NULL No
STAKI Display Down Payment Requests from Invoicing STAKZ_I CHAR 1 0
X Yes
NULL No
STAKJ Display Payment Requests from Invoicing STAKZ_J CHAR 1 0
X Yes
NULL No
STAKP Display Budget Billing Plan Items STAKZ_P CHAR 1 0
X Yes
NULL No
STAKR Display Installment Plan Items STAKZ_R CHAR 1 0
X Yes
NULL No
STAKS Display Collective Bill Items STAKZ_S CHAR 1 0
X Yes
NULL No
STAKZ Display Payment Request STAKZ_Z CHAR 1 0
X Yes
NULL No
SUBAP Subapplication in Contract Accounts Receivable and Payable SUBAP_KK CHAR 1 0
9 Real Estate
SZAHL no longer used SZAHL_KK CHAR 1 0
X Yes
NULL No
SZALI Account Balance: Display / Hide Payment List SZALI_KK CHAR 1 0
A Hide
E Full display
K Compressed display
SZCLR Checkbox XFELD CHAR 1 0
X Yes
NULL No
SUMME Total in account balance SUMME_KK CURR 13 2
TXT20 Account balance: Modified list type TXT20_KK CHAR 20 0
USSEL Use User-Specific Selection USSEL_KK CHAR 1 0
X Yes
NULL No
VKONT Contract Account Number VKONT_KK FKKVK CHAR 12 0
VTREF Reference Specifications from Contract VTREF_KK CHAR 20 0
VAROP Line Layout/Variant VARNR_ZKK TFK021Z CHAR 3 0
SVVAR Balance Variant (Key) SVVAR_KK TFKBA_VAR CHAR 6 0
SGVAR Balances Group (Key) SGVAR_KK CHAR 3 0
XSPBU Display of Balances per Business Partner XSPBU_KK CHAR 1 0
X Yes
NULL No
XSPCA Display of Balances per Contract Account XSPCA_KK CHAR 1 0
X Yes
NULL No
XSPCO Display of Balances per Contract XSPCO_KK CHAR 1 0
X Yes
NULL No
XAWOP Choose Open Items XAWOP_KK CHAR 1 0
X Yes
NULL No
XAWAP Select Cleared Items XAWAP_KK CHAR 1 0
X Yes
NULL No
XBLNR Reference document number XBLNR_KK CHAR 16 0
XRECH Account balance: Display postings XRECH_KK CHAR 1 0
X Yes
NULL No
XSTAT *no longer used* XSTAT_KK CHAR 1 0
X Yes
NULL No
XZAHL Account balance: Simulated clearing postings XZAHL_KK CHAR 1 0
X Yes
NULL No
XSUMM * No Longer Used * XSUMM_KK CHAR 1 0
X Yes
NULL No
XARCH Including Archived Items XARCH_FPL9 CHAR 1 0
X Yes
NULL No
ARCDT Date of Entry from Which to Read from Archive ARCDT_KK DATS 8 0
XDBBQ Only Due or (Partially) Paid Budget Billing XDBBQ_KK CHAR 1 0
X Yes
NULL No
XGRID Display Data in ALV Grid Control XGRID_KK CHAR 1 0
X Yes
NULL No
XFAKT Display Billing Documents Summarized XFAKT_KK CHAR 1 0
X Yes
NULL No
PPKEY Identification of Promise to Pay PPKEY_KK CHAR 12 0
PP2PS Select Items for Promise to Pay PP2PS_KK CHAR 1 0
X Yes
NULL No
CMGRP Collection Management: Master Data Group CMGRP_CM_KK CHAR 2 0
XBPCL Display All Items for Predecessor/Successor XBPCL_KK CHAR 1 0
X Yes
NULL No
XPPDI Display of Prepaid Postings in Account Balance XPPDI_KK CHAR 1 0
NULL Do Not Display Prepaid Postings
1 Display Prepaid Postings
2 Display Only Prepaid Postings
PPSEL Display Provisional Postings PPSEL_KK CHAR 1 0
NULL Do Not Display
1 Display
2 Display These Only
XSPRO Display Commissions XSPRO_KK CHAR 1 0
NULL Do Not Display Commissions
1 Display Commissions Also
2 Display Commissions Only
LSCAT List Category LSCAT_KK CHAR 10 0
LSLAB Char 15 CHAR15 CHAR 15 0
XALTBROK Additional Selection: Broker XALTBROK_KK CHAR 1 0
X Yes
NULL No
PNNUM SEPA: Number of Direct Debit Pre-Notification PNNUM_KK CHAR 16 0
PNHKF SEPA: Origin of Direct Debit Pre-Notification PNHKF_KK CHAR 2 0
NULL Pre-Notification Run
01 Convergent Invoicing
R1 IS-U Invoicing
OPALL Account Balance: Select All Open Items OPALL_KK CHAR 1 0
X Yes
NULL No
OPALLN Account Balance: Select All Open Items Due in N Days OPALLN_KK CHAR 1 0
X Yes
NULL No
OPTOL Number of Days for Selection of Open Items OPTOL_KK NUMC 3 0
RPALL Account Balance: Select All Open Installment Plan Items RPALL_KK CHAR 1 0
X Yes
NULL No
RPALLN Account Bal.: All Open Installment Plan Items Due in N Days RPALLN_KK CHAR 1 0
X Yes
NULL No
RPTOL Number of Days for Selection of Open Installment Plan Items RPTOL_KK NUMC 3 0
APALL Account Balance: Select All Open Budget Billing Items APALL_KK CHAR 1 0
X Yes
NULL No
APALLN Only Due or (Partially) Paid Budget Billing APALLN_KK CHAR 1 0
X Yes
NULL No
APTOL Number of Days for Selection of Open Budget Billing Items APTOL_KK NUMC 3 0
CLALL Account Balance: Select All Cleared Items CLALL_KK CHAR 1 0
X Yes
NULL No
CLALLN Select Items Cleared in Last N Days CLALLN_KK CHAR 1 0
X Yes
NULL No
CLTOL Number of Days for Selection of Cleared Items CLTOL_KK NUMC 3 0
XALLF Account Balance: Select All Fields XALLF_KK CHAR 1 0
X Yes
NULL No
XSADV Account Balance: Select Payment Advice Note Data XSADV_KK CHAR 1 0
X Yes
NULL No
XSDIS Account Balance: Select Disputes XSDIS_KK CHAR 1 0
X Yes
NULL No
XSHDR Account Balance: Select Header Data XSHDR_KK CHAR 1 0
X Yes
NULL No
XSDUN Account Balance: Select Dunning Data XSDUN_KK CHAR 1 0
X Yes
NULL No
XSORL Account Balance: Select Object Relations XSORL_KK CHAR 1 0
X Yes
NULL No
XSREF Account Balance: Select Returns Data XSREF_KK CHAR 1 0
X Yes
NULL No
XSAGR Account Balance: Select Payment Agreements XSAGR_KK CHAR 1 0
X Yes
NULL No
XSTAP Account Balance: Determine Payment Status of Item XSTAP_KK CHAR 1 0
X Yes
NULL No
XSIND Account Balance: Select Payment Specifications XSIND_KK CHAR 1 0
X Yes
NULL No

FKKL1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FKKL1 BALA_ROLE SYST MANDT TFK021_ROLES Account Balance Roles MANDT
FKKL1 BALA_ROLE FKKL1 APPLK TFK021_ROLES Account Balance Roles APPLK
FKKL1 BALA_ROLE FKKL1 BALA_ROLE TFK021_ROLES Account Balance Roles BALA_ROLE
FKKL1 BUKRS SYST MANDT T001 Company Codes MANDT
FKKL1 BUKRS FKKL1 BUKRS T001 Company Codes BUKRS
FKKL1 CCCUR SYST MANDT TCURC Currency Codes MANDT
FKKL1 CCCUR FKKL1 CCCUR TCURC Currency Codes WAERS
FKKL1 GPART FKKL1 GPART BUT000 BP: General data I PARTNER
FKKL1 GPART SYST MANDT BUT000 BP: General data I CLIENT
FKKL1 LSTYP SYST MANDT TFK021L Account balance: List types MANDT
FKKL1 LSTYP FKKL1 LSTYP TFK021L Account balance: List types LSTYP
FKKL1 SRVAR SYST MANDT TFK021SV Sort Variants MANDT
FKKL1 SRVAR 'SAPLFKL9' TFK021SV Sort Variants IDENT
FKKL1 SRVAR FKKL1 SRVAR TFK021SV Sort Variants SRVAR
FKKL1 SVVAR FKKL1 SVVAR TFKBA_VAR Balance Variant SVVAR
FKKL1 SVVAR SYST MANDT TFKBA_VAR Balance Variant MANDT
FKKL1 VAROP 'M' TFK021Z Line layout variants: Header data LSTCL
FKKL1 VAROP FKKL1 VAROP TFK021Z Line layout variants: Header data VARNR
FKKL1 VAROP SYST MANDT TFK021Z Line layout variants: Header data MANDT
FKKL1 VKONT SYST MANDT FKKVK Contract Account Header MANDT
FKKL1 VKONT FKKL1 VKONT FKKVK Contract Account Header VKONT