1. Home
  2. Resources
  3. SAP Tables
  4. DFKKOP - Items in contract account document

SAP Table DFKKOP

Items in contract account document

DFKKOP (Items in contract account document) 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 DFKKOP to other SAP tables.

DFKKOP 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 CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
BUPLA Business Place BUPLA J_1BBRANCH CHAR 4 0
SEGMENT Segment for Segmental Reporting SEGMT_KK 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 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 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 CHAR 4 0
TVORG Subtransaction for Document Item TVORG_KK CHAR 4 0
KOFIZ Account Determination ID KOFIZ_KK CHAR 2 0
SPART Division SPART_KK CHAR 2 0
HKONT General ledger account HKONT_KK CHAR 10 0
MWSKZ Tax on sales/purchases code MWSKZ 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 DATS 8 0
OPTXT Item text OPTXT_KK CHAR 50 0
WAERS Transaction Currency BLWAE_KK 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 CHAR 10 0
MWVKO Account for offsetting tax posting in down payments MWVKO_KK 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 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 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 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 DFKKOPW NUMC 3 0
XEIPH Create Line Item in General Ledger XEIPH_KK CHAR 1 0
X Yes
NULL No
MAHNV Dunning Procedure MAHNV_KK CHAR 2 0
MANSP Dunning Lock Reason MANSP_KK 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 CHAR 10 0
FDLEV Planning level FDLEV_KK 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 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 CHAR 15 0
TXDAT Decisive Date for Calculating Taxes TXDAT_KK DATS 8 0
VBUND Company ID of trading partner RASSC CHAR 6 0
KONTT Account Assignment Category KONTT_KK 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 CHAR 2 0
EMGPA Alternative Business Partner for Payments EMGPA_KK CHAR 10 0
EMBVT Bank Details ID of Payee EMBVT_KK CHAR 4 0
EMADR Address number AD_ADDRNUM CHAR 10 0
IKEY Interest Key IKEY_KK 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
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 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 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 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
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

DFKKOP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DFKKOP BUPLA DFKKOP BUPLA J_1BBRANCH Business Place BRANCH
DFKKOP BUPLA DFKKOP MANDT J_1BBRANCH Business Place MANDT
DFKKOP BUPLA DFKKOP BUKRS J_1BBRANCH Business Place BUKRS
DFKKOP PYBUK DFKKOP MANDT T001 Company Codes MANDT
DFKKOP PYBUK DFKKOP PYBUK T001 Company Codes BUKRS
DFKKOP WHGRP DFKKOP MANDT DFKKOPW Items in contract account document MANDT
DFKKOP WHGRP DFKKOP OPBEL DFKKOPW Items in contract account document OPBEL
DFKKOP WHGRP DFKKOP WHGRP DFKKOPW Items in contract account document WHGRP
DFKKOP WHGRP * DFKKOPW Items in contract account document OPUPW