SAP Tabel FKKCLIT (Fields for Display when Clearing Online)

Field Description Data Type Length Decimals Checktable Data Element
OPBEL Number of a FI-CA Document CHAR 12 0 OPBEL_KK
OPUPW Repetition Item in FI-CA Document NUMC 3 0 OPUPW_KK
OPUPK Item Number in FI-CA Document NUMC 4 0 OPUPK_KK
OPUPZ Subitem for a Partial Clearing in Document NUMC 3 0 OPUPZ_KK
BUKRS Company Code CHAR 4 0 T001 BUKRS
GSBER Business Area CHAR 4 0 TGSB GSBER
SEGMENT Segment for Segmental Reporting CHAR 10 0 SEGMT_KK
GPART Business Partner Number CHAR 10 0 BUT000 GPART_KK
PRCTR Profit Center CHAR 10 0 PRCTR
VTREF Reference Specifications from Contract CHAR 20 0 VTREF_KK
VTRE2 Additional Reference Information CHAR 20 0 VTRE2_KK
VKONT Contract Account Number CHAR 12 0 FKKVK VKONT_KK
ABWBL Number of the Substitute FI-CA Document CHAR 12 0 ABWBL_KK
ABWTP Category of Substitute Document in FI-CA CHAR 1 0 ABWTP_KK
P Promise to Pay
R Installment Plan
S Collective Bill
APPLK Application Area CHAR 1 0 APPLK_KK
* Valid for all application areas
C Convergent FI-CA
M Media Companies
P Public Administration
R Utility company
S Extended FI-CA
T Telecommunications
V Insurance company
X In-house development
HVORG Main Transaction for Line Item CHAR 4 0 TFKHVO HVORG_KK
TVORG Subtransaction for Document Item CHAR 4 0 TFKTVO TVORG_KK
KOFIZ Account Determination ID CHAR 2 0 KOFIZ_KK
SPART Division CHAR 2 0 TSPA SPART_KK
HKONT General ledger account CHAR 10 0 SKA1 HKONT_KK
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
XANZA Item is a Down Payment/Down Payment Request CHAR 1 0 XANZA_KK
STAKZ Type of statistical item CHAR 1 0 STAKZ_KK
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
M Collaborative Liability
P Budget Billing Plan Item
Q Expected withholding tax deduction
R Installment Plan Item
S Collective Bill Item
T Statisitcal receivable for other taxes
Z Payment Request
BLDAT Document Date in Document DATS 8 0 BLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT_KK
OPTXT Item text CHAR 50 0 OPTXT_KK
WAERS Transaction Currency CUKY 5 0 TCURC BLWAE_KK
FAEDN Due date for net payment DATS 8 0 FAEDN_KK
FAEDS Due Date for Cash Discount DATS 8 0 FAEDS_KK
VERKZ Item Can Only Be Cleared CHAR 1 0 VERKZ_KK
No restrictions
X Can only be cleared
STUDT Deferral to DATS 8 0 STUDT_KK
SKTPZ Cash Discount Percentage Rate DEC 5 3 SKTPZ_KK
SKFBT Amount Eligible for Cash Discount in Document Currency CURR 13 2 SKFBT_KK
SPZAH Lock Reason for Automatic Payment CHAR 1 0 TFK008 SPZAH_KK
PERNR Personnel Number NUMC 8 0 PERNR_D
GRKEY Grouping Key for Displaying Open Items CHAR 3 0 GRKEY_KK
MANSP Dunning Lock Reason CHAR 1 0 TFK047S MANSP_KK
SPERZ Interest Lock Reason CHAR 1 0 SPERZ_KK
ABRZU Lower Limit of Billing Period DATS 8 0 ABRZU_KK
ABRZO Upper Limit of the Billing Period DATS 8 0 ABRZO_KK
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
BLART Document Type CHAR 2 0 TFK003 BLART_KK
EMGPA Alternative Business Partner for Payments CHAR 10 0 BUT000 EMGPA_KK
XBLNR Reference document number CHAR 16 0 XBLNR_KK
OPORD Classification Key CHAR 35 0 OPORD_KK
QSSKZ Withholding Tax Code CHAR 2 0 T059Q QSSKZ
QSSEW Withholding Tax Supplement CHAR 2 0 QSSEW_KK
QSSHB Tax Base Amount CURR 13 2 QSSHB_KK
QBSHB Withholding Tax Amount (in Document Currency) CURR 13 2 QBSHB_KK
QSZNR Certificate Number of the Withholding Tax Exemption CHAR 10 0 QSZNR
STRKZ Tax Code for Other Taxes CHAR 2 0 STRKZ_KK
ORIWA Document currency of open item CUKY 5 0 ORIWA_KK
ORIBT Posting amount of an open item in document currency CURR 13 2 ORIBT_KK
AVKEY Payment Advice Note CHAR 20 0 AVKEY_KK
NRZAS Payment Form Number CHAR 12 0 NRZAS_KK
VERDP Summarization item number INT4 10 0 VERDP_KK
SPPOS Posting Lock Key CHAR 1 0 SPPOS_KK
TXTU1 Explanatory Text for Line Item CHAR 30 0 TXTUX_KK
TXTU2 Explanatory Text for Line Item CHAR 30 0 TXTUX_KK
XZVEX Payment Agreement Exists CHAR 1 0 XZVEX_KK
VZINS Surcharge for Late Payment CURR 13 2 VZINS_KK
SUBAP Subapplication in Contract Accounts Receivable and Payable CHAR 1 0 SUBAP_KK
No Contract Reference/Primary Contract
9 Real Estate
AUGDT Clearing Date DATS 8 0 AUGDT_KK
AUGBL Clearing Document or Printed Document CHAR 12 0 AUGBL_KK
AUGRD Clearing Reason CHAR 2 0 AUGRD_KK
PPRSN Reason for Balance Change on Prepaid Account CHAR 2 0 PPRSN_KK
01 Individual Refill, Payment Made Beforehand
02 Automatic Refill
03 Transfer from Another Prepaid Account
04 Transfer to Another Prepaid Account
05 Transfer from Contract Account
06 Transfer to Contract Account
07 Other Credit Amount
08 Debit for Charge
09 Correction/Reversal
10 Closing of Prepaid Account
11 Individual Refill, Payment After Refill
12 Refund of Credit
13 Bonus Amount with Refill
14 Adjustment After Refill Reversal
15 Reversal Posting for Failed Credit Change
16 Starting Credit (Included in Total Price)
17 Technical Correction Posting
18 Migration (Posting Not as Down Payment)
19 Migration (Posting as Down Payment)
20 Currency Change
PPACC Prepaid Account CHAR 12 0 PPACC_KK
DEBT_SET_NUMBER Debt set number CHAR 12 0 DCM_DEBT_SET_NUMBER_KK

FKKCLIT foreign key relationships

Table Field Check Table Check Field
0 FKKCLIT BUKRS T001 Company Codes BUKRS
1 FKKCLIT EMGPA BUT000 BP: General data I PARTNER
0 FKKCLIT GPART BUT000 BP: General data I PARTNER
1 FKKCLIT GSBER TGSB Business Areas MANDT
1 FKKCLIT GSBER TGSB Business Areas GSBER
0 FKKCLIT HKONT SKA1 G/L Account Master (Chart of Accounts) MANDT
0 FKKCLIT HKONT SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 FKKCLIT HKONT SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 FKKCLIT HVORG TFKHVO Main transactions in contract accts receivable and payable MANDT
1 FKKCLIT HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
0 FKKCLIT MWSKZ T007A Tax Keys KALSM
0 FKKCLIT MWSKZ T007A Tax Keys MWSKZ
1 FKKCLIT QSSKZ T059Q Withholding Tax MANDT
1 FKKCLIT QSSKZ T059Q Withholding Tax LAND1
1 FKKCLIT QSSKZ T059Q Withholding Tax QSSKZ
0 FKKCLIT SPART TSPA Organizational Unit: Sales Divisions MANDT
0 FKKCLIT SPART TSPA Organizational Unit: Sales Divisions SPART
1 FKKCLIT SPZAH TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
0 FKKCLIT TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable HVORG
0 FKKCLIT TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable TVORG
1 FKKCLIT VBUND T880 Global Company Data (for KONS Ledger) MANDT
1 FKKCLIT VBUND T880 Global Company Data (for KONS Ledger) RCOMP
0 FKKCLIT VKONT FKKVK Contract Account Header VKONT
1 FKKCLIT WAERS TCURC Currency Codes MANDT
1 FKKCLIT WAERS TCURC Currency Codes WAERS