1. Home
  2. Resources
  3. SAP Tables
  4. FKKCL - Clearing Items for Document in Contract A/R + A/P

SAP Table FKKCL

Clearing Items for Document in Contract A/R + A/P

FKKCL (Clearing Items for Document in Contract A/R + A/P) 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 FKKCL to other SAP tables.

FKKCL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
OPBEL Number of Contract Accts Rec. & Payable Doc. OPBEL_KK CHAR 12 0
OPUPW Repetition Item in Contract Account Document OPUPW_KK NUMC 3 0
OPUPK Item number in contract account document OPUPK_KK NUMC 4 0
OPUPZ Subitem for a Partial Clearing in Document OPUPZ_KK NUMC 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
GSBER Business Area GSBER TGSB CHAR 4 0
BUPLA Business Place BUPLA J_1BBRANCH CHAR 4 0
SEGMENT Segment for Segmental Reporting SEGMT_KK FAGL_SEGM CHAR 10 0
PRCTR Profit Center PRCTR CHAR 10 0
AUGST Clearing status AUGST_KK CHAR 1 0
NULL Open Item
9 Cleared Item
GPART Business Partner Number GPART_KK BUT000 CHAR 10 0
VTREF Reference Specifications from Contract VTREF_KK CHAR 20 0
VTPOS Contract: Item Number VTPOS_KK NUMC 6 0
VTRE2 Additional Reference Information VTRE2_KK CHAR 20 0
VKONT Contract Account Number VKONT_KK FKKVK CHAR 12 0
ABWBL Number of the substitute FI-CA document ABWBL_KK CHAR 12 0
ABWTP Category of substitute document in FI-CA ABWTP_KK CHAR 1 0
R Installment Plan
S Collective Bill
P Promise to Pay
ABWKT Alternative contract account for collective bills ABWVK_KK CHAR 12 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
HVORG Main Transaction for Line Item HVORG_KK TFKHVO CHAR 4 0
TVORG Subtransaction for Document Item TVORG_KK TFKTVO CHAR 4 0
KOFIZ Account Determination ID KOFIZ_KK CHAR 2 0
SPART Division SPART_KK TSPA CHAR 2 0
HKONT General ledger account HKONT_KK SKA1 CHAR 10 0
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
MWSZKZ Supplementary Tax MWSZKZ_KK CHAR 2 0
XANZA Item is a Down Payment/Down Payment Request XANZA_KK CHAR 1 0
X Yes
NULL No
STAKZ Type of statistical item STAKZ_KK CHAR 1 0
A Down Payment Request
B Quotation
G Other statistical receivable (charges,interest)
H Cash Security Deposit Request
I Down Payment Request from Invoicing
J Payment Request from Invoicing
K Correspondence Request
R Installment Plan Item
S Collective Bill Item
P Budget Billing Plan Item
Q Expected withholding tax deduction
T Statisitcal receivable for other taxes
Z Payment Request
BLDAT Document Date in Document BLDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT_KK DATS 8 0
OPTXT Item text OPTXT_KK CHAR 50 0
WAERS Transaction Currency BLWAE_KK TCURC CUKY 5 0
FAEDN Due date for net payment FAEDN_KK DATS 8 0
FAEDS Due Date for Cash Discount FAEDS_KK DATS 8 0
VERKZ Item Can Only Be Cleared VERKZ_KK CHAR 1 0
NULL No restrictions
X Can only be cleared
STUDT Deferral to STUDT_KK DATS 8 0
SKTPZ Cash discount rate SKTPZ_KK DEC 5 3
XMANL Exclude Item from Dunning Run XMANL_KK CHAR 1 0
X Yes
NULL No
KURSF Exchange rate KURSF_KK DEC 9 5
BETRH Amount In Local Currency With +/- Signs BETRH_KK CURR 13 2
BETRW Amount in Transaction Currency with +/- Sign BETRW_KK CURR 13 2
BETR2 Amount in second parallel currency with +/- sign BETR2_KK CURR 13 2
BETR3 Amount in third parallel currency with +/- sign BETR3_KK CURR 13 2
SKFBT Amount eligible for cash discount in document currency SKFBT_KK CURR 13 2
SBETH Tax Amount in Local Currency With +/- Sign SBETH_KK CURR 13 2
SBETW Tax Amount in Transaction Currency with +/- Sign SBETW_KK CURR 13 2
SBET2 Tax amount in second parallel currency SBET2_KK CURR 13 2
SBET3 Tax amount in third parallel currency SBET3_KK CURR 13 2
MWSKO Account for posting taxes for down payments MWSKO_KK SKA1 CHAR 10 0
MWVKO Account for offsetting tax posting in down payments MWVKO_KK SKA1 CHAR 10 0
TXRUL Update Rule for Tax and Tax Clearing TXRUL_KK CHAR 1 0
NULL Tax and Tax Clearing without Trading Partner
1 Tax Clearing with Trading Partner
2 Tax and Tax Clearing with Trading Partner
SPZAH Lock Reason for Automatic Payment SPZAH_KK TFK008 CHAR 1 0
PYMET Payment Method PYMET_KK CHAR 1 0
PYBUK Company Code for Automatic Payment Transactions PYBUK_KK T001 CHAR 4 0
PERNR Personnel Number PERNR_D NUMC 8 0
GRKEY Grouping Key for Displaying Open Items GRKEY_KK CHAR 3 0
PERSL Key for Period Assignment PERSL_KK TFK001P CHAR 4 0
XAESP Printing - No Changes Possible XAESP_KK CHAR 1 0
X Yes
NULL No
AUGDT Clearing date AUGDT_KK DATS 8 0
AUGBL Clearing Document or Printed Document AUGBL_KK CHAR 12 0
AUGBD Clearing document posting date AUGBD_KK DATS 8 0
AUGRD Clearing Reason AUGRD_KK TFK001A CHAR 2 0
AUGWA Clearing currency AUGWA_KK CUKY 5 0
AUGBT Clearing amount in clearing currency AUGBT_KK CURR 13 2
AUGBS Tax amount in clearing currency AUGBS_KK CURR 13 2
AUGSK Cash Discount Granted/Surcharge Levied in Clearing Currency AUGSK_KK CURR 13 2
AUGVD Value date for clearing AUGVD_KK DATS 8 0
AUGOB Item Canceled AUGOB_KK CHAR 1 0
X Yes
NULL No
WHANG Number of repetition items WHANG_KK NUMC 3 0
WHGRP Repetition group WHGRP_KK NUMC 3 0
XEIPH Create Line Item in General Ledger XEIPH_KK CHAR 1 0
X Yes
NULL No
MAHNV Dunning Procedure MAHNV_KK TFK047A CHAR 2 0
MANSP Dunning Lock Reason MANSP_KK TFK047S CHAR 1 0
XAUGP Check Sample Record Clearing XAUGP_KK CHAR 1 0
X Yes
NULL No
ABRZU Lower Limit of Settlement Period ABRZU_KK DATS 8 0
ABRZO Upper Limit of the Billing Period ABRZO_KK DATS 8 0
FDGRP Planning Group FDGRP_KK T035 CHAR 10 0
FDLEV Planning level FDLEV_KK T036 CHAR 2 0
FDZTG Additional Days for Cash Management FDZTG_KK NUMC 2 0
FDWBT Planning amount in document currency FDWBT CURR 13 2
XTAUS Item Split XTAUS_KK CHAR 1 0
X Yes
NULL No
AUGRS Clearing restriction AUGRS_KK CHAR 1 0
0 Document is incorrect (no zero balance)
1 Down Payment from IS-U: Can Only be Cleared in Invoicing
2 Security Deposit: No Clearing Permitted
3 Difference amount cannot be cleared until next invoice
4 Donations or payment for equity funds
5 Down payment from SD: Can only be cleared against SD recevbl
6 Payable Only after Budget Billing Request
7 Collective invoice: Only payable after collective billing
8 Items cannot be processed until next regular invoice
9 Renewals Down Payment: Only Clear with IS-M-SD Receivable
A Gen. down payment: Can be cleared in next invoice
B Agency Collections: Can Only Be Paid via Agency Collections
C Broker report: Item in clarification
D Deposit: Can only be cleared with open item clearing
E Est. Posting
G Budget Billing as Down Payment on Vendor Side (Deregulation)
I Rounding Carryforward from Invoicing
P Cannot be Paid before Budget Billing Request (Deregulation)
R Items Relevant for Payment Scheme
S Cash Loss/Held Items
T Clearing Only via External Interface
U Reserved payment on account
V Clearing Only Permitted after Confirmation of Partner
W Clearing only by Account Maintenance
X Paid statistical charge
Z Clearing Only by Payment Program
NULL No restriction
F Automatic Clearing of Temporary Premium Requests (FS-CD)
Y Additional Deregulation Items
K Posting to Prepaid Account
H Provisional Posting
PYGRP Grouping field for automatic payments PYGRP_KK CHAR 10 0
PDTYP Category of Payment Specification PDTYP_KK CHAR 1 0
1 Preselected for Payment Run
2 Defined for Payment Run
3 Defined for Payment Lot
4 Biller Direct
5 Financial Customer Care
SPERZ Interest Lock Reason SPERZ_KK TFK056S CHAR 1 0
INFOZ Doubtful Item Entry/Individual Value Adjustment INFOZ_KK NUMC 3 0
000 Item is not marked as doubtful/indiv. value adjusted
901 Item is marked as doubtful/indiv. value adjusted
902 Doubtful marking/individual value adjustment reset
903 Item doubtful or has IVA in at least one valuation area
904 DE/IVA reset in at least one valuation area
TXJCD Tax Jurisdiction TXJCD TTXJ CHAR 15 0
TXDAT Decisive Date for Calculating Taxes TXDAT_KK DATS 8 0
VBUND Company ID of trading partner RASSC T880 CHAR 6 0
KONTT Account Assignment Category KONTT_KK TFK000K CHAR 2 0
KONTL Acct assnmnt string for industry-specific account assngments KONTL_KK CHAR 50 0
OPSTA Dunning indicator OPSTA_KK CHAR 3 0
BLART Document Type BLART_KK TFK003 CHAR 2 0
EMGPA Alternative Business Partner for Payments EMGPA_KK BUT000 CHAR 10 0
EMBVT Bank Details ID of Payee EMBVT_KK BUT0BK CHAR 4 0
EMADR Address number AD_ADDRNUM CHAR 10 0
IKEY Interest Key IKEY_KK TFK056A CHAR 2 0
EUROU Status of Euro Conversion EUROU_KK CHAR 1 0
1 Local currency 1 converted
2 Local currency 2 converted
3 Local currency 1 + 2 converted
4 Local currency 3 converted
5 Local currency 1 + 3 converted
6 Local currency 2 + 3 converted
7 Local currency 1 + 2 converted
NULL No conversion
A Local currency 1 converted but not complete
B Local currency 2 converted but not complete
C Local currency 1+2 converted but not complete
D Local currency 3 converted but not complete
E Local currency 1+3 converted but not complete
F Local currency 2+3 converted but not complete
G Local currency 1+2+3 converted but not complete
XRAGL Clearing posting reversed XRAGL_KK CHAR 1 0
X Yes
NULL No
XWHPO Expanded Repetition Item XWHPO_KK CHAR 1 0
X Yes
NULL No
ASTKZ Statistical Key of the Initiating Item ASTKZ_KK CHAR 1 0
A Down Payment Request
B Quotation
G Other Statistical Receivable (Charges,Interest)
H Cash Security Deposit Request
I Down Payment Request from Invoicing
J Payment Request from Invoicing
P Budget Billing Plan Item
Z Payment Request
> Item from Sample Document
ASBLG Number of Triggering Document ASBLG_KK CHAR 12 0
XBLNR Reference document number XBLNR_KK CHAR 16 0
INKPS Collection Item INKPS_KK NUMC 3 0
RNDPS Type of Rounding Item RNDPS_KK CHAR 1 0
1 Rounding balance
2 Rounding Balance from Debit Item
3 Rounding Balance from Credit Item
QSSKZ Withholding Tax Code QSSKZ T059Q CHAR 2 0
QSSEW Withholding Tax Supplement QSSEW_KK CHAR 2 0
QSPTP Line Item Category From Withholding Tax View QSPTP_KK CHAR 1 0
NULL No item with withholding tax information
A Withholding Tax Withheld by Us at Payment
E Credit memo for withholding tax that the customer withholds
U Withholding tax withheld by customer, still no credit memo
G Withholding tax withheld by customer, credit memo exists too
N W/Tax Zero Percent on Debit Side, Report on Payment
R W/Tax Zero Percent on Debit Side, Report on Invoice
S Withholding Tax Deducted by Us at Invoicing
P Withholding Tax Partially Deducted by Us at Invoicing
V Withholding Tax Deducted at Invoicing
QSSHB Tax Base Amount QSSHB_KK CURR 13 2
QBSHB Withholding Tax Amount (in Document Currency) QBSHB_KK CURR 13 2
QSZNR Certificate Number of the Withholding Tax Exemption QSZNR CHAR 10 0
XWHEX Variable Withholding Tax in DFKKOPWH XWHEX_KK CHAR 1 0
X Yes
NULL No
RFUPK Reference Item In FI-CA Document RFUPK_KK NUMC 4 0
STRKZ Tax Code for Other Taxes STRKZ_KK TFK007F CHAR 2 0
FITPR Tax type J_1AFITP_D CHAR 2 0
XPYOR Item Included in a Payment Order XPYOR_KK CHAR 1 0
X Item Is Contained in a Payment Order
Y Item Is Contained in a Direct Debit Pre-Notification
LANDL Country Supplied (for Tax Notifications) LANDL_KK T005 CHAR 3 0
INTBU Reason for Automatic Creation of Posting INTBU_KK CHAR 1 0
A Interest on Arrears with Clearing
R Charges Receivable for Returns
B Bundling of Open Items
F Follow-On Posting for Clearing Reset to 4.71
G Follow-On Posting for Clearing Reset from 4.72
D Down Payment from 4.72
Y Additional Document via FKK_CREATE_DOC_ADDITIONAL
Z Additional Item via Event 0032
I Actual Taxation
EMCRD Alternative Payment Card ID in Document EMCRD_KK CHAR 6 0
C4EYE Check Reason for Workflows Acc. to Dual Control Principle C4EYE_KK CHAR 2 0
CFOPN CFOP Code and Extension J_1BCFOP CHAR 10 0
C4EYP Editing Process To Be Confirmed C4EYP_KK CHAR 1 0
1 New Document, To Be Confirmed
2 Document To Be Reversed, To Be Confirmed
3 Document Change, To Be Confirmed
4 Installment Plan, To Be Confirmed
5 Repayment Request, To Be Confirmed
SCTAX Tax Portion in FI-CA Local Currency SCTAX_KK CURR 13 2
STTAX Tax Amount as Statistical Information in Document Currency STTAX_KK CURR 13 2
STZAL Status of Payment Processing STZAL_KK CHAR 1 0
B Boleto Created (Brazil)
ORUPZ Subitem Number before Item Split ORUPZ_KK CHAR 3 0
NEGBU Control Field for Negative Posting NEGBU_KK NUMC 1 0
0 No Negative Posting
1 Negative Posting
2 Negative Clearing
3 Negative Posting + Clearing
4 Negative Clearing Required
5 Negative Posting + Clearing Required
6 Negative Clearing Required + Posted
7 Negative Posting + Clearing Required + Posted
SUBAP Subapplication in Contract Accounts Receivable and Payable SUBAP_KK CHAR 1 0
9 Real Estate
PSWSL Update Currency for General Ledger Transaction Figures PSWSL_KK CUKY 5 0
PSWBT Amount for Updating in General Ledger PSWBT_KK CURR 13 2
PSWTX Tax Amount for Update in General Ledger PSWTX_KK CURR 13 2
PSGRP Grouping Key for Document Items PSGRP_KK CHAR 4 0
XCOLC Item Is Included in Collection Case XCOLC_KK CHAR 1 0
X Yes
NULL No
AASTA Control Field for Account Assignment Distributions AASTA_KK CHAR 1 0
NULL No Enhanced Account Assignment of Tax Items
1 No Account Assignment of Tax Items
2 Separate Distribution Data Exists for Tax Item
3 Unique Account Assignment for Tax in General Ledger
XCSHA Document Contains Assignments from Cash Flows XCSHA_KK CHAR 1 0
X Yes
NULL No
REACC Originating Account in Cash Flow Anlaysis REACC_KK CHAR 10 0
REBUK Partner Company Code for Cash Flow Analysis REBUK_KK CHAR 4 0
XUSTPD Tax on Sales/Purchases Was Calculated by Document XUSTPD_KK CHAR 1 0
X Yes
NULL No
PTITM Status of Partner Settlement Using Billable Items PTITM_KK CHAR 1 0
NULL No Third-Party Revenue Sharing by Separate Settlement
A Third-Party Revenue Sharing Is Possible, Adjustment Allowed
B Third-Party Revenue Sharing Is Possible, No Adjustment
EMMND SEPA Mandate Identifier EMMND_KK NUMC 6 0
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
PNEXD SEPA: Date of Execution of Direct Debit Pre-Notifcation PNEXD_KK DATS 8 0
PNCTR SEPA: Requirement for a Pre-Notification PNCTR_KK CHAR 1 0
1 Not to Be Pre-Notified (Set Automatically)
2 Not to Be Pre-Notified (Set Automatically)
4 Not to Be Pre-Notified (Set Manually)
A To Be Pre-Notified (Set Automatically)
B To Be Pre-Notified (Set Automatically)
D To Be Pre-Notified (Set Manually)
NULL Dependent on Payment Method
FINRE Contract Account of Final Recipient FINRE_KK CHAR 12 0
RDSTA Current Distribution Status RDSTA_KK CHAR 1 0
NULL Do Not Distribute
1 Check Distribution
2 Distributed
3 Reversal Information Provided
4 Estimated Distribution
5 Distribution Simulated
RDSTB Last Distribution Status Reported RDSTB_KK CHAR 1 0
NULL Do Not Distribute
1 Check Distribution
2 Distributed
3 Reversal Information Provided
4 Estimated Distribution
5 Distribution Simulated
FMTYP Update Method for FM - FI-CA Integration FMTYP_KK CHAR 2 0
A Invoice
B Paid Invoice
C Clearing
D Clearing of Invoice in Prior Year
E Clearing of Invoice in Next Year
F Transfer Posting
G Payment on Account
H Down Payment
I G/L Account Transfer Posting
J Clarification Worklist
K Tax Item Created Automatically
L Invoice from Legacy System
M Reversal of Invoice in Prior Year
O Paid Invoice from Prior Year
P No Update
Q Clearing of Invoice and Credit Memo
R Clearing of Invoice and Credit Memo (Document in Prior Year)
S Clearing of Invoice and Credit Memo (Document in Next Year)
T Paid Invoice (Clearing with Credit Memo)
U Paid Invoice Prior Year (Clearing with Credit Memo)
V Posting before FM Activation
ORIGFIKRS Original FM Area for FM Account Assignment ORIGFIKRS_KK CHAR 4 0
FIPEX Commitment Item FM_FIPEX CHAR 24 0
FISTL Funds Center FISTL CHAR 16 0
FONDS Fund BP_GEBER CHAR 10 0
FKBER Functional Area FKBER CHAR 16 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
BUDGETYEAR Original Year for FM Account Assignment FM_START_OF_CHAIN NUMC 4 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
AUGBW Clearing Amount in Transaction Currency (With +/- Sign) AUGBW_KK CURR 13 2
AUGBH Clearing amount in local currency with +/- sign AUGBH_KK CURR 13 2
AUGB2 Clearing Amount in Second Local Currency (With +/- Sign) AUGB2_KK CURR 13 2
AUGB3 Clearing Amount in Third Local Currency (With +/- Sign) AUGB3_KK CURR 13 2
AUGBO Clearing Amount in Open Item Currency AUGBO_KK CURR 13 2
NAUGW Net clearing amount in transaction currency NAUGW_KK CURR 13 2
NAUGH Net clearing amount in local currency NAUGH_KK CURR 13 2
NAUG2 Net clearing amount in second local currency NAUG2_KK CURR 13 2
NAUG3 Net clearing amount in third local currency NAUG3_KK CURR 13 2
NAUGO Net clearing amount in currency of the open item NAUGO_KK CURR 13 2
SKTOW Cash discount amount in transaction currency with +/- sign SKTOW_KK CURR 13 2
SKTOH Cash discount amount (+/-) in local currency SKTOH_KK CURR 13 2
SKTO2 Cash discount amount in local currency 2 with +/- sign SKTO2_KK CURR 13 2
SKTO3 Cash discount amount in local currency 3 with +/- sign SKTO3_KK CURR 13 2
SKTOO Cash discount amount (+/-) in item currency SKTOO_KK CURR 13 2
ASKTW Proportional cash discount in transaction currency ASKTW_KK CURR 13 2
ASKTH Proportional cash discount in local currency ASKTH_KK CURR 13 2
ASKT2 Proportional cash discount in local currency 2 ASKT2_KK CURR 13 2
ASKT3 Proportional cash discount in local currency 3 ASKT3_KK CURR 13 2
ASKTO Proportional cash discount amount in item currency ASKTO_KK CURR 13 2
NETTW Net amount in transaction currency with +/- sign NETTW_KK CURR 13 2
NETTH Net amount in local currency with +/- signs NETTH_KK CURR 13 2
NETT2 Net amount in second local currency with +/- sign NETT2_KK CURR 13 2
NETT3 Net amount in third local currency with +/- sign NETT3_KK CURR 13 2
NETTO Net amount (+/-) in item currency NETTO_KK CURR 13 2
AQSBW Proportional Withholding Tax Amount In Transaction Currency AQSBW_KK CURR 13 2
AQSBH Proportional Withholding Tax Amount In Local Currency AQSBH_KK CURR 13 2
AQSB2 Proportional Withholding Tax Amount In Local Currency 2 AQSB2_KK CURR 13 2
AQSB3 Proportional Withholding Tax Amount In Local Currency 3 AQSB3_KK CURR 13 2
AQSBO Proportional Withholding Tax Amount In Item Currency AQSBO_KK CURR 13 2
ORIBT Posting amount of an open item in document currency ORIBT_KK CURR 13 2
ORISB Tax amount of an open item in document currency ORISB_KK CURR 13 2
ORISK Cash disc. base of open item in doc currency ORISK_KK CURR 13 2
ORIQS Withholding Tax For Open Item In Document Currency ORIQS_KK CURR 13 2
ORIVZ Arrears Surcharge in Document Currency ORIVZ_KK CURR 13 2
BETRV Translated Value Acc. To Average Rate from Exchange Rate Tab BETRV_KK CURR 13 2
VZINS Surcharge for Late Payment VZINS_KK CURR 13 2
DSPAM Disputed Amount in Transaction Currency with +/- Sign DSPAM_KK CURR 13 2
ORIWA Document currency of open item ORIWA_KK CUKY 5 0
PYORD Payment Order PYORD_KK CHAR 10 0
AVKEY Payment Advice Note AVKEY_KK CHAR 20 0
PDKEY Number of Payment Specification PDKEY_KK NUMC 12 0
TXTU1 Explanatory Text for Line Item TXTUX_KK CHAR 30 0
TXTU2 Explanatory Text for Line Item TXTUX_KK CHAR 30 0
XAKTP Indicator: Items activated ? XAKTP CHAR 1 0
X Yes
NULL No
XAKTS Indicator: Cash discount activated ? XAKTS CHAR 1 0
X Yes
NULL No
QSPTP_VD Line Item Category From Withholding Tax View QSPTP_KK CHAR 1 0
NULL No item with withholding tax information
A Withholding Tax Withheld by Us at Payment
E Credit memo for withholding tax that the customer withholds
U Withholding tax withheld by customer, still no credit memo
G Withholding tax withheld by customer, credit memo exists too
N W/Tax Zero Percent on Debit Side, Report on Payment
R W/Tax Zero Percent on Debit Side, Report on Invoice
S Withholding Tax Deducted by Us at Invoicing
P Withholding Tax Partially Deducted by Us at Invoicing
V Withholding Tax Deducted at Invoicing
OPBEL_VD Number of Contract Accts Rec. & Payable Doc. OPBEL_KK CHAR 12 0
SKTPA Accepted cash discount rate SKTPA_KK DEC 5 3
WHANZ Number of Items for this Repetition Group WHANZ_KK NUMC 4 0
INSEL Indicator: Partial Selection of Postings INSEL NUMC 1 0
TMPSO Sort Field for Temporary Use TMPSO_KK CHAR 20 0
TABIX Row Index of Internal Tables SYTABIX INT4 10 0
XVERD Displayed Item Is Summarized XVERD_KK CHAR 1 0
X Yes
NULL No
XMARK Item selected XMARK_KK CHAR 1 0
NULL not selected
B Block beginning or block end
X Selected
XDETV Distribution amounts changed manually XDETV_KK CHAR 1 0
X Yes
NULL No
XCHNG Ssummarization line item changed XCHNG_KK CHAR 1 0
X Yes
NULL No
XCLON Clear Items Without Follow-On Posting XCLON_KK CHAR 1 0
X Yes
NULL No
NRZAS Payment Form Number NRZAS_KK CHAR 12 0
VERDP Summarization item number VERDP_KK INT4 10 0
AZVDG Document Group for Summarized Display AZVDG_KK CHAR 20 0
XMEMO Items not yet in database XMEMO_KK CHAR 1 0
X Yes
NULL No
SPPOS Posting lock key SPPOS_KK CHAR 1 0
QSSTA Withholding Tax Processing Status QSSTA_KK CHAR 1 0
NULL Withholding tax not active
1 We withhold withholding tax
2 Customer withholds withholding tax
3 Both withhold withholding tax
XQSER Additional Withholding Taxes Active XQSER_KK CHAR 1 0
X Yes
NULL No
VERTYP Clearing Category For Clearing Postings VERTYP_KK CHAR 4 0
XZVEX Payment Agreement Exists XZVEX_KK CHAR 1 0
X Yes
NULL No
NXUPZ Next Subitem to Be Created NXUPZ_KK NUMC 3 0
AGUPZ New Subitem for Partial Clearing in Document AGUPZ_KK NUMC 3 0
STCHG Status Field for Changes to Line Item STCHG_KK CHAR 1 0
A Item Changed
B Item Split
C Item Split and Changed
STRES Status Field for Change Restrictions STRES_KK CHAR 1 0
NULL Change Restrictions Not Checked Yet
0 No Change Restrictions
1 Item Split Not Permitted
2 Item Split and Change Not Permitted
CRULE Number of Change Rule (Internal Use) CRULE_KK NUMC 4 0
XBPDB Business Partner has Predecessor or Successor XBPDB_KK CHAR 1 0
X Yes
NULL No
BOLID FI-CA BOL: ID of a Business Object Layer Object BOLID_KK NUMC 10 0
BOLST FI-CA: Web UI - Status BOLST_KK CHAR 2 0
X0119 Amount Was Set Using Event 0119 X0119_KK CHAR 1 0
X Yes
NULL No

FKKCL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FKKCL AUGRD FKKCL AUGRD TFK001A Clearing Reasons AUGRD
FKKCL BLART FKKCL MANDT TFK003 Document types MANDT
FKKCL BLART FKKCL APPLK TFK003 Document types APPLK
FKKCL BLART FKKCL BLART TFK003 Document types BLART
FKKCL BUKRS FKKCL MANDT T001 Company Codes MANDT
FKKCL BUKRS FKKCL BUKRS T001 Company Codes BUKRS
FKKCL BUPLA FKKCL MANDT J_1BBRANCH Business Place MANDT
FKKCL BUPLA FKKCL BUKRS J_1BBRANCH Business Place BUKRS
FKKCL BUPLA FKKCL BUPLA J_1BBRANCH Business Place BRANCH
FKKCL EMBVT FKKCL MANDT BUT0BK BP: Bank Details MANDT
FKKCL EMBVT FKKCL EMGPA BUT0BK BP: Bank Details PARTNER
FKKCL EMBVT FKKCL EMBVT BUT0BK BP: Bank Details BKVID
FKKCL EMGPA FKKCL MANDT BUT000 BP: General data I CLIENT
FKKCL EMGPA FKKCL EMGPA BUT000 BP: General data I PARTNER
FKKCL FDGRP FKKCL MANDT T035 Planning groups MANDT
FKKCL FDGRP FKKCL FDGRP T035 Planning groups GRUPP
FKKCL FDLEV FKKCL MANDT T036 Planning levels MANDT
FKKCL FDLEV FKKCL FDLEV T036 Planning levels EBENE
FKKCL GPART FKKCL MANDT BUT000 BP: General data I CLIENT
FKKCL GPART FKKCL GPART BUT000 BP: General data I PARTNER
FKKCL GSBER FKKCL MANDT TGSB Business Areas MANDT
FKKCL GSBER FKKCL GSBER TGSB Business Areas GSBER
FKKCL HKONT T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
FKKCL HKONT FKKCL HKONT SKA1 G/L Account Master (Chart of Accounts) SAKNR
FKKCL HKONT FKKCL MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
FKKCL HVORG FKKCL MANDT TFKHVO Main transactions in contract accts receivable and payable MANDT
FKKCL HVORG FKKCL APPLK TFKHVO Main transactions in contract accts receivable and payable APPLK
FKKCL HVORG FKKCL HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
FKKCL IKEY FKKCL MANDT TFK056A Interest Key Table for FI-CA MANDT
FKKCL IKEY FKKCL IKEY TFK056A Interest Key Table for FI-CA IKEY
FKKCL KONTT FKKCL KONTT TFK000K Account Assignment Categories KONTT
FKKCL LANDL FKKCL MANDT T005 Countries MANDT
FKKCL LANDL FKKCL LANDL T005 Countries LAND1
FKKCL MAHNV FKKCL MANDT TFK047A Dunning procedure MANDT
FKKCL MAHNV FKKCL MAHNV TFK047A Dunning procedure MAHNV
FKKCL MANSP FKKCL MANSP TFK047S Dunning block reasons MANSP
FKKCL MANSP FKKCL MANDT TFK047S Dunning block reasons MANDT
FKKCL MWSKO FKKCL MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
FKKCL MWSKO T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
FKKCL MWSKO FKKCL MWSKO SKA1 G/L Account Master (Chart of Accounts) SAKNR
FKKCL MWSKZ FKKCL MWSKZ T007A Tax Keys MWSKZ
FKKCL MWSKZ FKKCL MANDT T007A Tax Keys MANDT
FKKCL MWSKZ T005 KALSM T007A Tax Keys KALSM
FKKCL MWVKO FKKCL MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
FKKCL MWVKO T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
FKKCL MWVKO FKKCL MWVKO SKA1 G/L Account Master (Chart of Accounts) SAKNR
FKKCL PERSL FKKCL MANDT TFK001P Period key MANDT
FKKCL PERSL FKKCL PERSL TFK001P Period key PERSL
FKKCL PYBUK FKKCL PYBUK T001 Company Codes BUKRS
FKKCL PYBUK FKKCL MANDT T001 Company Codes MANDT
FKKCL QSSKZ FKKCL MANDT T059Q Withholding Tax MANDT
FKKCL QSSKZ T001 LAND1 T059Q Withholding Tax LAND1
FKKCL QSSKZ FKKCL QSSKZ T059Q Withholding Tax QSSKZ
FKKCL SEGMENT FKKCL MANDT FAGL_SEGM Master Data for Segments MANDT
FKKCL SEGMENT FKKCL SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
FKKCL SPART FKKCL MANDT TSPA Organizational Unit: Sales Divisions MANDT
FKKCL SPART FKKCL SPART TSPA Organizational Unit: Sales Divisions SPART
FKKCL SPERZ FKKCL MANDT TFK056S Blocking Reasons for Interest Calculation MANDT
FKKCL SPERZ FKKCL SPERZ TFK056S Blocking Reasons for Interest Calculation SPERZ
FKKCL SPZAH FKKCL MANDT TFK008 Locking Reasons for Automatic Payment Transactions MANDT
FKKCL SPZAH FKKCL SPZAH TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
FKKCL STRKZ FKKCL STRKZ TFK007F Other Tax Codes STRKZ
FKKCL STRKZ FKKCL MANDT TFK007F Other Tax Codes MANDT
FKKCL STRKZ * TFK007F Other Tax Codes LAND
FKKCL TVORG FKKCL HVORG TFKTVO Sub-transactions in Contract Accounts Receivable and Payable HVORG
FKKCL TVORG FKKCL TVORG TFKTVO Sub-transactions in Contract Accounts Receivable and Payable TVORG
FKKCL TVORG FKKCL MANDT TFKTVO Sub-transactions in Contract Accounts Receivable and Payable MANDT
FKKCL TVORG FKKCL APPLK TFKTVO Sub-transactions in Contract Accounts Receivable and Payable APPLK
FKKCL TXJCD FKKCL MANDT TTXJ Check Table for Tax Jurisdiction MANDT
FKKCL TXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
FKKCL TXJCD FKKCL TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
FKKCL VBUND FKKCL MANDT T880 Global Company Data (for KONS Ledger) MANDT
FKKCL VBUND FKKCL VBUND T880 Global Company Data (for KONS Ledger) RCOMP
FKKCL VKONT FKKCL VKONT FKKVK Contract Account Header VKONT
FKKCL VKONT FKKCL MANDT FKKVK Contract Account Header MANDT
FKKCL WAERS FKKCL WAERS TCURC Currency Codes WAERS
FKKCL WAERS FKKCL MANDT TCURC Currency Codes MANDT