SAP table FKKCL (Clearing Items for Document in Contract A/R + A/P)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
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
BUPLA Business Place CHAR 4 0 J_1BBRANCH BUPLA
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM SEGMT_KK
PRCTR Profit Center CHAR 10 0 PRCTR
AUGST Clearing Status CHAR 1 0 AUGST_KK
Open Item
9 Cleared Item
GPART Business Partner Number CHAR 10 0 BUT000 GPART_KK
VTREF Reference Specifications from Contract CHAR 20 0 VTREF_KK
VTPOS Contract: Item Number NUMC 6 0 VTPOS_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
ABWKT Alternative Contract Account for Collective Bills CHAR 12 0 * ABWVK_KK
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
MWSZKZ Supplementary Tax CHAR 2 0 * MWSZKZ_KK
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
XMANL Exclude Item from Dunning Run CHAR 1 0 XMANL_KK
KURSF Exchange rate DEC 9 5 KURSF_KK
BETRH Amount In Local Currency With +/- Signs CURR 13 2 BETRH_KK
BETRW Amount in Transaction Currency with +/- Sign CURR 13 2 BETRW_KK
BETR2 Amount in Second Parallel Currency with +/- Sign CURR 13 2 BETR2_KK
BETR3 Amount in Third Parallel Currency with +/- Sign CURR 13 2 BETR3_KK
SKFBT Amount Eligible for Cash Discount in Document Currency CURR 13 2 SKFBT_KK
SBETH Tax Amount in Local Currency With +/- Sign CURR 13 2 SBETH_KK
SBETW Tax Amount in Transaction Currency with +/- Sign CURR 13 2 SBETW_KK
SBET2 Tax Amount in Second Parallel Currency CURR 13 2 SBET2_KK
SBET3 Tax Amount in Third Parallel Currency CURR 13 2 SBET3_KK
MWSKO Account for posting taxes for down payments CHAR 10 0 SKA1 MWSKO_KK
MWVKO Account for offsetting tax posting in down payments CHAR 10 0 SKA1 MWVKO_KK
TXRUL Update Rule for Tax and Tax Clearing CHAR 1 0 TXRUL_KK
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 CHAR 1 0 TFK008 SPZAH_KK
PYMET Payment Method CHAR 1 0 * PYMET_KK
PYBUK Company Code for Automatic Payment Transactions CHAR 4 0 T001 PYBUK_KK
PERNR Personnel Number NUMC 8 0 PERNR_D
GRKEY Grouping Key for Displaying Open Items CHAR 3 0 GRKEY_KK
PERSL Key for Period Assignment CHAR 4 0 TFK001P PERSL_KK
XAESP Printing - No Changes Possible CHAR 1 0 XAESP_KK
AUGDT Clearing Date DATS 8 0 AUGDT_KK
AUGBL Clearing Document or Printed Document CHAR 12 0 AUGBL_KK
AUGBD Clearing Document Posting Date DATS 8 0 AUGBD_KK
AUGRD Clearing Reason CHAR 2 0 TFK001A AUGRD_KK
AUGWA Clearing Currency CUKY 5 0 * AUGWA_KK
AUGBT Clearing amount in clearing currency CURR 13 2 AUGBT_KK
AUGBS Tax Amount in Clearing Currency CURR 13 2 AUGBS_KK
AUGSK Cash Discount Granted/Surcharge Levied in Clearing Currency CURR 13 2 AUGSK_KK
AUGVD Value date for clearing DATS 8 0 AUGVD_KK
AUGOB Item Canceled CHAR 1 0 AUGOB_KK
WHANG Number of repetition items NUMC 3 0 WHANG_KK
WHGRP Repetition group NUMC 3 0 * WHGRP_KK
XEIPH Create Line Item in General Ledger CHAR 1 0 XEIPH_KK
MAHNV Dunning Procedure CHAR 2 0 TFK047A MAHNV_KK
MANSP Dunning Lock Reason CHAR 1 0 TFK047S MANSP_KK
XAUGP Check Sample Record Clearing CHAR 1 0 XAUGP_KK
ABRZU Lower Limit of Billing Period DATS 8 0 ABRZU_KK
ABRZO Upper Limit of the Billing Period DATS 8 0 ABRZO_KK
FDGRP Planning Group CHAR 10 0 T035 FDGRP_KK
FDLEV Planning level CHAR 2 0 T036 FDLEV_KK
FDZTG Additional Days for Cash Management NUMC 2 0 FDZTG_KK
FDWBT Planned Amount in Document or G/L Account Currency CURR 13 2 FDWBT_KK
XTAUS Item Split CHAR 1 0 XTAUS_KK
AUGRS Clearing restriction CHAR 1 0 AUGRS_KK
No restriction
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)
H Provisional Posting
I Rounding Carryforward from Invoicing
J Automatic Clearing of Temporary Premium Requests (FS-CD)
K Posting to Prepaid Account
L Subledger Transfer to FI-AR/AP
M Additional Clearing Restriction
N Accrual/Deferral Posting in Invoicing
O Payable Only After Confirmation by Voucher Management
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
Y Additional Deregulation Items
Z Clearing Only by Payment Program
PYGRP Grouping field for automatic payments CHAR 10 0 PYGRP_KK
PDTYP Category of Payment Specification CHAR 1 0 PDTYP_KK
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 CHAR 1 0 TFK056S SPERZ_KK
INFOZ Doubtful Item Entry/Individual Value Adjustment NUMC 3 0 INFOZ_KK
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 CHAR 15 0 TTXJ TXJCD
TXDAT Decisive Date for Calculating Taxes DATS 8 0 TXDAT_KK
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
KONTT Account Assignment Category CHAR 2 0 TFK000K KONTT_KK
KONTL Acct assnmnt string for industry-specific account assngments CHAR 50 0 KONTL_KK
OPSTA Dunning indicator CHAR 3 0 * OPSTA_KK
BLART Document Type CHAR 2 0 TFK003 BLART_KK
EMGPA Alternative Business Partner for Payments CHAR 10 0 BUT000 EMGPA_KK
EMBVT Bank Details ID of Payee CHAR 4 0 BUT0BK EMBVT_KK
EMADR Address Number CHAR 10 0 * AD_ADDRNUM
IKEY Interest Key CHAR 2 0 TFK056A IKEY_KK
EUROU Status of Euro Conversion CHAR 1 0 EUROU_KK
No conversion
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
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 CHAR 1 0 XRAGL_KK
XWHPO Expanded Repetition Item CHAR 1 0 XWHPO_KK
ASTKZ Statistical Key of the Initiating Item CHAR 1 0 ASTKZ_KK
> Item from Sample Document
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
M Co-Liability Request
P Budget Billing Plan Item
Z Payment Request
ASBLG Number of Triggering Document CHAR 12 0 * ASBLG_KK
XBLNR Reference document number CHAR 16 0 XBLNR_KK
INKPS Collection Item NUMC 3 0 INKPS_KK
RNDPS Type of Rounding Item CHAR 1 0 RNDPS_KK
1 Rounding balance
2 Rounding Balance from Debit Item
3 Rounding Balance from Credit Item
QSSKZ Withholding Tax Code CHAR 2 0 T059Q QSSKZ
QSSEW Withholding Tax Supplement CHAR 2 0 * QSSEW_KK
QSPTP Line Item Category From Withholding Tax View CHAR 1 0 QSPTP_KK
No item with withholding tax information
A Withholding Tax Withheld by Us at Payment
E Credit memo for withholding tax that the customer withholds
G Withholding tax withheld by customer, credit memo exists too
N W/Tax Zero Percent on Debit Side, Report on Payment
P Withholding Tax Partially Deducted by Us at Invoicing
R W/Tax Zero Percent on Debit Side, Report on Invoice
S Withholding Tax Deducted by Us at Invoicing
U Withholding tax withheld by customer, still no credit memo
V Withholding Tax Deducted at Invoicing
QSSHB Tax Base Amount CURR 13 2 QSSHB_KK
QBSHB Withholding Tax Amount (in Document Currency) CURR 13 2 QBSHB_KK
QSPRZ Withholding Tax Percentage NUMC 6 0 QSPRZ_KK
QSZNR Certificate Number of the Withholding Tax Exemption CHAR 10 0 QSZNR
XWHEX Variable Withholding Tax in DFKKOPWH CHAR 1 0 XWHEX_KK
RFUPK Reference Item In FI-CA Document NUMC 4 0 RFUPK_KK
STRKZ Tax Code for Other Taxes CHAR 2 0 TFK007F STRKZ_KK
FITPR Tax type CHAR 2 0 J_1AFITPV J_1AFITP_D
XPYOR Item Included in a Payment Order CHAR 1 0 XPYOR_KK
X Item Is Contained in a Payment Order
Y Item Is Contained in a Direct Debit Pre-Notification
LANDL Destination Country/Region (for Tax Reports) CHAR 3 0 T005 LANDL_KK
INTBU Reason for Automatic Creation of Posting CHAR 1 0 INTBU_KK
A Interest on Arrears with Clearing
B Bundling of Open Items
C Payment Card User Fee
D Down Payment from 4.72
F Follow-On Posting for Clearing Reset to 4.71
G Follow-On Posting for Clearing Reset from 4.72
I Actual Taxation
R Charges Receivable for Returns
S Immediate Clearing by Payment Card
V Payment of Tax Portion into Separate Bank Account (Tax Item)
W Payment of Tax Portion into Separate Bank Acct. (Base Item)
Y Additional Document via FKK_CREATE_DOC_ADDITIONAL
Z Additional Item via Event 0032
EMCRD Alternative Payment Card ID in Document CHAR 6 0 EMCRD_KK
C4EYE Check Reason for Workflows Acc. to Dual Control Principle CHAR 2 0 * C4EYE_KK
CFOPN CFOP Code and Extension CHAR 10 0 * J_1BCFOP
C4EYP Editing Process To Be Confirmed CHAR 1 0 C4EYP_KK
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
6 Installment Plan Change, to Be Confirmed
7 Write-Off Run, to Be Confirmed
TXGRP Grouping Key for Tax Items CHAR 6 0 TXGRP_KK
SCTAX Tax Portion in FI-CA Local Currency CURR 13 2 SCTAX_KK
STTAX Tax Amount as Statistical Information in Document Currency CURR 13 2 STTAX_KK
STZAL Status of Payment Processing CHAR 1 0 STZAL_KK
B Boleto Created (Brazil)
ORUPZ Subitem Number before Item Split CHAR 3 0 ORUPZ_KK
NEGBU Control Field for Negative Posting NUMC 1 0 NEGBU_KK
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 CHAR 1 0 SUBAP_KK
No Contract Reference/Primary Contract
9 Real Estate
PSWSL Update Currency for General Ledger Transaction Figures CUKY 5 0 * PSWSL_KK
PSWBT Amount for Updating in General Ledger CURR 13 2 PSWBT_KK
PSWTX Tax Amount for Update in General Ledger CURR 13 2 PSWTX_KK
PSGRP Grouping Key for Document Items CHAR 4 0 PSGRP_KK
XCOLC Item Is Included in Collection Case CHAR 1 0 XCOLC_KK
AASTA Control Field for Account Assignment Distributions CHAR 1 0 AASTA_KK
No Enhanced Account Assignment of Tax Items
1 Tax Items Are Assigned
2 Separate Distribution Data Exists for Tax Item
3 Unique Account Assignment for Tax in General Ledger
4 Tax Items Assigned by Application
XCSHA Document Contains Assignments from Cash Flows CHAR 1 0 XCSHA_KK
REACC Originating Account in Cash Flow Anlaysis CHAR 10 0 * REACC_KK
REBUK Partner Company Code for Cash Flow Analysis CHAR 4 0 * REBUK_KK
XUSTPD Tax on Sales/Purchases Was Calculated by Document CHAR 1 0 XUSTPD_KK
PTITM Status of Partner Settlement Using Billable Items CHAR 1 0 PTITM_KK
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 NUMC 6 0 EMMND_KK
PALIX Item Is Part of a Collaborative Liability CHAR 1 0 PALIX_KK
Item Is Not a Receivable with Joint and Several Liability
X Item Is a Receivable with Joint and Several Liability
CLRLOCK Clearing Lock Reason CHAR 1 0 TFK000S CLRLO_KK
PNNUM SEPA: Number of Direct Debit Pre-Notification CHAR 16 0 PNNUM_KK
PNHKF SEPA: Origin of Direct Debit Pre-Notification CHAR 2 0 PNHKF_KK
Pre-Notification Run
01 Convergent Invoicing
R1 IS-U Invoicing
PNEXD SEPA: Date of Execution of Direct Debit Pre-Notifcation DATS 8 0 PNEXD_KK
PNCTR SEPA: Requirement for a Pre-Notification CHAR 1 0 PNCTR_KK
Dependent on Payment Method
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)
FINRE Contract Account of Final Recipient CHAR 12 0 FINRE_KK
RDSTA Current Distribution Status CHAR 1 0 RDSTA_KK
RDSTB Last Distribution Status Reported CHAR 1 0 RDSTB_KK
FASTA Factoring: Current Status of Receivable CHAR 1 0 FASTA_KK
Not Sold
1 Offered for Sale
2 Sold
3 Sale Rejected
4 Offer Reversed
7 Sold, Response Not Yet Posted
8 Sale Rejected, Response Not Yet Posted
9 Not Relevant for Sale
A Intended for Buyback
B Bought Back
Z Final
PASTA Factoring: Check Status for Clearing Information CHAR 1 0 PASTA_KK
Not Relevant For Factoring
1 To Check (After Clearing / Clearing Reset)
2 Not for Checking (Open or Cleared and Notified)
3 Not for Checking (Offered Receivable)
OPUPF Subitems in Factoring NUMC 3 0 OPUPF_KK
FMTYP Update Method for FM - FI-CA Integration CHAR 2 0 FMTYP_KK
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
W Paid Invoice with Tax Portion
X Paid Invoice from Prior Year with Tax Portion
Y Paid Invoice with Tax Portion (Cleared with Credit Memo)
Z Paid Invoice from Prior Year with Tax Portion (Credit Memo)
ORIGFIKRS Original FM Area for FM Account Assignment CHAR 4 0 * ORIGFIKRS_KK
FIPEX Commitment Item CHAR 24 0 * FM_FIPEX
FISTL Funds Center CHAR 16 0 * FISTL
FONDS Fund CHAR 10 0 * BP_GEBER
FKBER Functional Area CHAR 16 0 * FKBER
MEASURE Funded Program CHAR 24 0 * FM_MEASURE
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
BUDGETYEAR Original Year for FM Account Assignment NUMC 4 0 FM_START_OF_CHAIN
BUDGET_PD Budget Period CHAR 10 0 * FM_BUDGET_PERIOD
COLOGRP Colocation Group for Business Partner CHAR 12 0 COLOGRP_BP_KK
HERKF_KK Document Origin Key CHAR 2 0 * HERKF_KK
/SAPCE/FKRU_CN Number of corrected document CHAR 12 0 /SAPCE/FKRU_CBLNR
/SAPCE/FKRU_CD Posting date of corrected document DATS 8 0 /SAPCE/FKRU_CUDAT
/SAPCE/FKRU_RN Revision Number NUMC 2 0 /SAPCE/FKRU_RNUM
/SAPCE/FKRU_AB Date from which time slice is valid DATS 8 0 ABZEITSCH
/SAPCE/FKRU_BIS Date at Which a Time Slice Expires DATS 8 0 BISZEITSCH
INTOP Internal Generation Characteristic for Document Item CHAR 1 0 INTOP_KK
Generated Before Indicator Was Introduced
1 Generated During Posting
2 Generated as a Replacement Item During Reset of Cleared Itms
CPUDT_OP Document Item Creation Date DATS 8 0 CPUDT_OP_KK
CPUTM_OP Time of Document Item Creation TIMS 6 0 CPUTM_OP_KK
CPUDT_ST Document Item Reversal Date DATS 8 0 CPUDT_ST_KK
CPUTM_ST Time of Document Item Reversal TIMS 6 0 CPUTM_ST_KK
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
AUGRE Additional Clearing Restriction CHAR 3 0 TFK004AR AUGRE_KK
INTTX Internal Tax Characteristic for Tax Handling CHAR 1 0 INTTX_KK
TXDAT_FROM Valid-From Date of the Tax Rate DATS 8 0 FOT_TXDAT_FROM
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 T005 FOT_TAX_COUNTRY
TAXC_FACTOR Factor for Conversion into Tax Country/Region Currency DEC 31 14 TAXC_FACTOR_KK
RCSTA Reconnection Status CHAR 1 0 RCSTA_KK
1 Ingoing payment posted. Reconnection to be analyzed
2 Reconnection Analyzed: Total payment above threshold
3 Reconnection analyzed: Total payment below threshold
X Item involved in a disconnection request
AWTYP_OP Reference Transaction in Business Partner Item CHAR 5 0 * AWTYP_OP_KK
AWKEY_OP Reference Key in Business Partner Item CHAR 20 0 AWKEY_OP_KK
FULPA Only Full Payment Allowed CHAR 1 0 FULPA_KK
INFPA Inform About Payment CHAR 2 0 INFPA_KK
01 Outbound Call of Web API
BCODE Branch Code CHAR 5 0 BCODE_KK
BENT1 Service Type CHAR 10 0 BENTY_KK
ISSRB ISS Tax Rate for Simples DEC 4 2 ISSR_KK
DUMMY_FKKOP_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
AUGBW Clearing Amount in Transaction Currency (With +/- Sign) CURR 13 2 AUGBW_KK
AUGBH Clearing amount in local currency with +/- sign CURR 13 2 AUGBH_KK
AUGB2 Clearing Amount in Second Local Currency (With +/- Sign) CURR 13 2 AUGB2_KK
AUGB3 Clearing Amount in Third Local Currency (With +/- Sign) CURR 13 2 AUGB3_KK
AUGBO Clearing Amount in Open Item Currency CURR 13 2 AUGBO_KK
NAUGW Net clearing amount in transaction currency CURR 13 2 NAUGW_KK
NAUGH Net clearing amount in local currency CURR 13 2 NAUGH_KK
NAUG2 Net clearing amount in second local currency CURR 13 2 NAUG2_KK
NAUG3 Net clearing amount in third local currency CURR 13 2 NAUG3_KK
NAUGO Net clearing amount in currency of the open item CURR 13 2 NAUGO_KK
SKTOW Cash discount amount in transaction currency with +/- sign CURR 13 2 SKTOW_KK
SKTOH Cash discount amount (+/-) in local currency CURR 13 2 SKTOH_KK
SKTO2 Cash discount amount in local currency 2 with +/- sign CURR 13 2 SKTO2_KK
SKTO3 Cash discount amount in local currency 3 with +/- sign CURR 13 2 SKTO3_KK
SKTOO Cash discount amount (+/-) in item currency CURR 13 2 SKTOO_KK
ASKTW Proportional Cash Discount in Transaction Currency CURR 13 2 ASKTW_KK
ASKTH Proportional cash discount in local currency CURR 13 2 ASKTH_KK
ASKT2 Proportional cash discount in local currency 2 CURR 13 2 ASKT2_KK
ASKT3 Proportional cash discount in local currency 3 CURR 13 2 ASKT3_KK
ASKTO Proportional cash discount amount in item currency CURR 13 2 ASKTO_KK
NETTW Net amount in transaction currency with +/- sign CURR 13 2 NETTW_KK
NETTH Net amount in local currency with +/- signs CURR 13 2 NETTH_KK
NETT2 Net amount in second local currency with +/- sign CURR 13 2 NETT2_KK
NETT3 Net amount in third local currency with +/- sign CURR 13 2 NETT3_KK
NETTO Net amount (+/-) in item currency CURR 13 2 NETTO_KK
AQSBW Proportional Withholding Tax Amount In Transaction Currency CURR 13 2 AQSBW_KK
AQSBH Proportional Withholding Tax Amount In Local Currency CURR 13 2 AQSBH_KK
AQSB2 Proportional Withholding Tax Amount In Local Currency 2 CURR 13 2 AQSB2_KK
AQSB3 Proportional Withholding Tax Amount In Local Currency 3 CURR 13 2 AQSB3_KK
AQSBO Proportional Withholding Tax Amount In Item Currency CURR 13 2 AQSBO_KK
ORIBT Posting amount of an open item in document currency CURR 13 2 ORIBT_KK
ORISB Tax amount of an open item in document currency CURR 13 2 ORISB_KK
ORISK Cash disc. base of open item in doc currency CURR 13 2 ORISK_KK
ORIQS Withholding Tax For Open Item In Document Currency CURR 13 2 ORIQS_KK
ORIVZ Arrears Surcharge in Document Currency CURR 13 2 ORIVZ_KK
BETRV Translated Value Acc. To Average Rate from Exchange Rate Tab CURR 13 2 BETRV_KK
VZINS Surcharge for Late Payment CURR 13 2 VZINS_KK
DSPAM Disputed Amount in Transaction Currency with +/- Sign CURR 13 2 DSPAM_KK
ORIWA Document currency of open item CUKY 5 0 ORIWA_KK
PYORD Payment Order CHAR 10 0 PYORD_KK
AVKEY Payment Advice Note CHAR 20 0 AVKEY_KK
PDKEY Number of Payment Specification NUMC 12 0 PDKEY_KK
TXTU1 Explanatory Text for Line Item CHAR 30 0 TXTUX_KK
TXTU2 Explanatory Text for Line Item CHAR 30 0 TXTUX_KK
XAKTP Indicator: Items Activated? CHAR 1 0 XAKTP
XAKTS Indicator: Cash Discount Activated? CHAR 1 0 XAKTS
QSPTP_VD Line Item Category From Withholding Tax View CHAR 1 0 QSPTP_KK
No item with withholding tax information
A Withholding Tax Withheld by Us at Payment
E Credit memo for withholding tax that the customer withholds
G Withholding tax withheld by customer, credit memo exists too
N W/Tax Zero Percent on Debit Side, Report on Payment
P Withholding Tax Partially Deducted by Us at Invoicing
R W/Tax Zero Percent on Debit Side, Report on Invoice
S Withholding Tax Deducted by Us at Invoicing
U Withholding tax withheld by customer, still no credit memo
V Withholding Tax Deducted at Invoicing
OPBEL_VD Number of a FI-CA Document CHAR 12 0 OPBEL_KK
SKTPA Accepted cash discount rate DEC 5 3 SKTPA_KK
WHANZ Number of Items for this Repetition Group NUMC 4 0 WHANZ_KK
INSEL Indicator: Item in Partial Selection NUMC 1 0 INSEL
TMPSO Sort Field for Temporary Use CHAR 20 0 TMPSO_KK
TABIX Row Index of Internal Tables INT4 10 0 SYTABIX
XVERD Displayed Item Is Summarized CHAR 1 0 XVERD_KK
XMARK Item selected CHAR 1 0 XMARK_KK
not selected
B Block beginning or block end
X Selected
XDETV Distribution amounts changed manually CHAR 1 0 XDETV_KK
XCHNG Ssummarization line item changed CHAR 1 0 XCHNG_KK
XCLON Clear Items Without Follow-On Posting CHAR 1 0 XCLON_KK
NRZAS Payment Form Number CHAR 12 0 NRZAS_KK
VERDP Summarization item number INT4 10 0 VERDP_KK
AZVDG Document Group for Summarized Display CHAR 20 0 AZVDG_KK
XMEMO Items not yet in database CHAR 1 0 XMEMO_KK
SPPOS Posting Lock Key CHAR 1 0 SPPOS_KK
QSSTA Withholding Tax Processing Status CHAR 1 0 QSSTA_KK
Withholding tax not active
1 We withhold withholding tax
2 Customer withholds withholding tax
3 Both withhold withholding tax
XQSER Additional Withholding Taxes Active CHAR 1 0 XQSER_KK
VERTYP Clearing Category For Clearing Postings CHAR 4 0 VERTYP_KK
XZVEX Payment Agreement Exists CHAR 1 0 XZVEX_KK
NXUPZ Next Subitem to Be Created NUMC 3 0 NXUPZ_KK
AGUPZ New Subitem for Partial Clearing in Document NUMC 3 0 AGUPZ_KK
STCHG Status Field for Changes to Line Item CHAR 1 0 STCHG_KK
A Item Changed
B Item Split
C Item Split and Changed
STRES Status Field for Change Restrictions CHAR 1 0 STRES_KK
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) NUMC 4 0 CRULE_KK
XBPDB Business Partner has Predecessor or Successor CHAR 1 0 XBPDB_KK
BOLID FI-CA BOL: ID of a Business Object Layer Object NUMC 10 0 BOLID_KK
BOLST FI-CA: Web UI - Status CHAR 2 0 BOLST_KK
X0119 Amount Was Set Using Event 0119 CHAR 1 0 X0119_KK
DEBT_SET_NUMBER Debt set number CHAR 12 0 DCM_DEBT_SET_NUMBER_KK

FKKCL foreign key relationships

Table Field Check Table Check Field
0 FKKCL AUGRD TFK001A Clearing Reasons AUGRD
1 FKKCL AUGRE TFK004AR Additional Clearing Restrictions AUGRE
0 FKKCL BUKRS T001 Company Codes BUKRS
1 FKKCL BUPLA J_1BBRANCH Business Place BUKRS
1 FKKCL BUPLA J_1BBRANCH Business Place BRANCH
1 FKKCL BUPLA J_1BBRANCH Business Place BUPLA_TYPE
0 FKKCL CLRLOCK TFK000S Posting Locks SPPOS
1 FKKCL EMBVT BUT0BK BP: Bank Details PARTNER
1 FKKCL EMBVT BUT0BK BP: Bank Details BKVID
0 FKKCL EMGPA BUT000 BP: General data I PARTNER
1 FKKCL FDGRP T035 Planning groups GRUPP
0 FKKCL FDLEV T036 Planning levels EBENE
1 FKKCL FITPR J_1AFITPV Tax Type: Possible Entries MANDT
1 FKKCL FITPR J_1AFITPV Tax Type: Possible Entries J_1AFITP
0 FKKCL GPART BUT000 BP: General data I PARTNER
1 FKKCL GSBER TGSB Business Areas MANDT
1 FKKCL GSBER TGSB Business Areas GSBER
0 FKKCL HKONT SKA1 G/L Account Master (Chart of Accounts) MANDT
0 FKKCL HKONT SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 FKKCL HKONT SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 FKKCL HVORG TFKHVO Main transactions in contract accts receivable and payable MANDT
1 FKKCL HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
0 FKKCL IKEY TFK056A Interest Key Table for FI-CA IKEY
1 FKKCL LANDL T005 Countries MANDT
1 FKKCL LANDL T005 Countries LAND1
0 FKKCL MAHNV TFK047A Dunning procedure MAHNV
1 FKKCL MWSKO SKA1 G/L Account Master (Chart of Accounts) MANDT
1 FKKCL MWSKO SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 FKKCL MWSKO SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 FKKCL MWSKZ T007A Tax Keys KALSM
0 FKKCL MWSKZ T007A Tax Keys MWSKZ
1 FKKCL MWVKO SKA1 G/L Account Master (Chart of Accounts) MANDT
1 FKKCL MWVKO SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 FKKCL MWVKO SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 FKKCL PERSL TFK001P Period key MANDT
0 FKKCL PERSL TFK001P Period key PERSL
1 FKKCL PYBUK T001 Company Codes BUKRS
0 FKKCL QSSKZ T059Q Withholding Tax MANDT
0 FKKCL QSSKZ T059Q Withholding Tax LAND1
0 FKKCL QSSKZ T059Q Withholding Tax QSSKZ
1 FKKCL SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
0 FKKCL SPART TSPA Organizational Unit: Sales Divisions MANDT
0 FKKCL SPART TSPA Organizational Unit: Sales Divisions SPART
1 FKKCL SPERZ TFK056S Blocking Reasons for Interest Calculation MANDT
1 FKKCL SPERZ TFK056S Blocking Reasons for Interest Calculation SPERZ
0 FKKCL SPZAH TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
1 FKKCL STRKZ TFK007F Other Tax Codes LAND
0 FKKCL TAX_COUNTRY T005 Countries MANDT
0 FKKCL TAX_COUNTRY T005 Countries LAND1
1 FKKCL TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable HVORG
1 FKKCL TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable TVORG
0 FKKCL TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 FKKCL TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
1 FKKCL VBUND T880 Global Company Data (for KONS Ledger) MANDT
1 FKKCL VBUND T880 Global Company Data (for KONS Ledger) RCOMP
0 FKKCL VKONT FKKVK Contract Account Header VKONT
1 FKKCL WAERS TCURC Currency Codes MANDT
1 FKKCL WAERS TCURC Currency Codes WAERS