SAP Table BAPIDFKKOP

BAPI: Business Partner Items for Open Item Account Document

BAPIDFKKOP (BAPI: Business Partner Items for Open Item 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 BAPIDFKKOP to other SAP tables.

BAPIDFKKOP table fields

Field Data element Checktable Datatype Length Decimals
DOC_NO Number of Contract Accts Rec. & Payable Doc. OPBEL_KK CHAR 12 0
REP_ITEM Repetition Item in Contract Account Document OPUPW_KK NUMC 3 0
ITEM Item number in contract account document OPUPK_KK NUMC 4 0
SUB_ITEM Subitem for a Partial Clearing in Document OPUPZ_KK NUMC 3 0
COMP_CODE Company Code BUKRS T001 CHAR 4 0
BUS_AREA Business Area GSBER TGSB CHAR 4 0
STATUS Clearing status AUGST_KK CHAR 1 0
NULL Open Item
9 Cleared Item
BUSPARTNER Business Partner Number GPART_KK BUT000 CHAR 10 0
CONTRACT Reference Specifications from Contract VTREF_KK CHAR 20 0
CONTRACT2 Additional Reference Information VTRE2_KK CHAR 20 0
CONT_ACCT Contract Account Number VKONT_KK FKKVK CHAR 12 0
SUB_DOC Number of the substitute FI-CA document ABWBL_KK CHAR 12 0
DOC_CAT Category of substitute document in FI-CA ABWTP_KK CHAR 1 0
R Installment Plan
S Collective Bill
P Promise to Pay
APPL_AREA 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
MAIN_TRANS Main Transaction for Line Item HVORG_KK TFKHVO CHAR 4 0
SUB_TRANS Subtransaction for Document Item TVORG_KK TFKTVO CHAR 4 0
ACTDETERID Account Determination ID KOFIZ_KK CHAR 2 0
DIVISION Division SPART_KK TSPA CHAR 2 0
G_L_ACCT General ledger account HKONT_KK SKA1 CHAR 10 0
TAX_CODE Tax on sales/purchases code MWSKZ T007A CHAR 2 0
DOWN_PMNT Item is a Down Payment/Down Payment Request XANZA_KK CHAR 1 0
X Yes
NULL No
STAT_KEY 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
DOC_DATE Document Date in Document BLDAT DATS 8 0
POST_DATE Posting Date in the Document BUDAT_KK DATS 8 0
TEXT Item text OPTXT_KK CHAR 50 0
NET_DATE Due date for net payment FAEDN_KK DATS 8 0
DISC_DUE Due Date for Cash Discount FAEDS_KK DATS 8 0
ONLY_OFF Item Can Only Be Cleared VERKZ_KK CHAR 1 0
NULL No restrictions
X Can only be cleared
DEFERRAL Deferral to STUDT_KK DATS 8 0
DISC_RATE Cash discount rate SKTPZ_KK DEC 5 3
NO_DUNNING Exclude Item from Dunning Run XMANL_KK CHAR 1 0
X Yes
NULL No
TRAN_RATE Exchange rate KURSF_KK DEC 9 5
CURRENCY Transaction Currency BLWAE_KK TCURC CUKY 5 0
CURRENCY_ISO ISO currency code ISOCD CHAR 3 0
AMOUNT_LOC_CURR Amount in Local Currency with +/- Signs BP_BETRH_KK DEC 23 4
AMOUNT Amount in Transaction Currency with +/- Sign BP_BETRW_KK DEC 23 4
AMOUNT_PAR2_CURR Amount in second parallel currency with +/- sign BP_BETR2_KK DEC 23 4
AMOUNT_PAR3_CURR Amount in third parallel currency with +/- sign BP_BETR3_KK DEC 23 4
DISCOUNT_BASE Amount eligible for cash discount in document currency BP_SKFBT_KK DEC 23 4
TAX_AMOUNT_LOC_CURR Tax Amount in Local Currency with +/- Sign BP_SBETH_KK DEC 23 4
TAX_AMOUNT Tax amount in transaction currency with +/- sign BP_SBETW_KK DEC 23 4
TAX_AMOUNT_PAR2_CURR Tax amount in second parallel currency BP_SBET2_KK DEC 23 4
TAX_AMOUNT_PAR3_CURR Tax amount in third parallel currency BP_SBET3_KK DEC 23 4
TAX_ACCT Account for posting taxes for down payments MWSKO_KK SKA1 CHAR 10 0
OFFSET_TAX Account for offsetting tax posting in down payments MWVKO_KK SKA1 CHAR 10 0
PMNT_BLOCK Lock Reason for Automatic Payment SPZAH_KK TFK008 CHAR 1 0
PMNT_METH Payment Method PYMET_KK TFK042Z CHAR 1 0
PERSON_NO Personnel Number PERNR_D NUMC 8 0
GROUPING Grouping Key for Displaying Open Items GRKEY_KK CHAR 3 0
PERIOD_KEY Key for Period Assignment PERSL_KK TFK001P CHAR 4 0
CHG_BLOCK Printing - No Changes Possible XAESP_KK CHAR 1 0
X Yes
NULL No
CLEARDATE Clearing date AUGDT_KK DATS 8 0
CLEARDOCNO Clearing Document or Printed Document AUGBL_KK CHAR 12 0
CL_POSTDTE Clearing document posting date AUGBD_KK DATS 8 0
CLEAR_REAS Clearing Reason AUGRD_KK TFK001A CHAR 2 0
CLRG_CURR Clearing currency AUGWA_KK TCURC CUKY 5 0
CLRG_CURR_ISO ISO currency code ISOCD CHAR 3 0
AMOUNT_CLEAR Clearing amount in clearing currency BP_AUGBT_KK DEC 23 4
TAX_AMOUNT_CLEAR Tax Amount in Clearing Currency BP_AUGBS_KK DEC 23 4
VAL_DATE Value date for clearing AUGVD_KK DATS 8 0
CANCELED Item Canceled AUGOB_KK CHAR 1 0
X Yes
NULL No
NO_REPS Number of repetition items WHANG_KK NUMC 3 0
REPET_GRP Repetition group WHGRP_KK NUMC 3 0
LINE_ITEM Create Line Item in General Ledger XEIPH_KK CHAR 1 0
X Yes
NULL No
DUNN_PROC Dunning Procedure MAHNV_KK TFK047A CHAR 2 0
DUNN_BLOCK Dunning Lock Reason MANSP_KK TFK047S CHAR 1 0
CHECK_CLNG Check Sample Record Clearing XAUGP_KK CHAR 1 0
X Yes
NULL No
CALC_PERLO Lower Limit of Settlement Period ABRZU_KK DATS 8 0
CALC_PERHI Upper Limit of the Billing Period ABRZO_KK DATS 8 0
PLAN_GRP Planning Group FDGRP_KK T035 CHAR 10 0
PLAN_LEVEL Planning level FDLEV_KK T036 CHAR 2 0
CM_EX_DAYS Additional Days for Cash Management FDZTG_KK NUMC 2 0
AMOUNT_PLANNED Currency amount in BAPI interfaces BAPICURR_D DEC 23 4
PART_CLRG Item Split XTAUS_KK CHAR 1 0
X Yes
NULL No
RESTRICT 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
PAYMNT_GRP Grouping field for automatic payments PYGRP_KK CHAR 10 0
INT_BLOCK Interest Lock Reason SPERZ_KK TFK056S CHAR 1 0
INT_INFO 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
TAXJURCODE Tax Jurisdiction TXJCD TTXJ CHAR 15 0
TAX_DATE Decisive Date for Calculating Taxes TXDAT_KK DATS 8 0
TRADE_ID Company ID of trading partner RASSC T880 CHAR 6 0
ACCTASSCAT Account Assignment Category KONTT_KK TFK000K CHAR 2 0
ACCT_ASSGT Acct assnmnt string for industry-specific account assngments KONTL_KK CHAR 50 0
DUN_INDIC Dunning indicator OPSTA_KK CHAR 3 0
DOC_TYPE Document Type BLART_KK TFK003 CHAR 2 0
PARTNER Alternative Business Partner for Payments EMGPA_KK BUT000 CHAR 10 0
BK_DETAILS Bank Details ID of Payee EMBVT_KK CHAR 4 0
ADDR_NO Address number AD_ADDRNUM CHAR 10 0
INT_KEY Interest Key IKEY_KK TFK056A CHAR 2 0
EURO_STAT 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
REVERSECLG Clearing posting reversed XRAGL_KK CHAR 1 0
X Yes
NULL No
XREPETPOS Expanded Repetition Item XWHPO_KK CHAR 1 0
X Yes
NULL No
STAT_KEY_SRC 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
REF_DOC_NO Reference document number XBLNR_KK CHAR 16 0
COLLECTION_POS Collection Item INKPS_KK NUMC 3 0
REFERENCE_ITEM Reference Item In FI-CA Document RFUPK_KK NUMC 4 0
OTHER_TAX_CODE Tax Code for Other Taxes STRKZ_KK CHAR 2 0
TAX_CATEGORY Tax type J_1AFITP_D CHAR 2 0
CRD_DETAILS Alternative Payment Card ID in Document EMCRD_KK CHAR 6 0
FM_CATEGORY 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
FM_ORIG_AREA Original FM Area for FM Account Assignment ORIGFIKRS_KK CHAR 4 0
CMMT_ITEM Commitment Item FM_FIPEX CHAR 24 0
FUNDS_CTR Funds Center FISTL CHAR 16 0
FUND Fund BP_GEBER CHAR 10 0
FUNC_AREA Functional Area FKBER CHAR 16 0
W_TAX_CODE Withholding Tax Code QSSKZ CHAR 2 0
W_TAX_SUPPL Withholding Tax Supplement QSSEW_KK CHAR 2 0
W_TAX_LICAT 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
W_TAX_BASE Tax Base Amount BP_QSSHB_KK DEC 23 4
W_TAX_AMOUNT Withholding Tax Amount in Document Currency BP_QBSHB_KK DEC 23 4
EXEMPT_NO Certificate Number of the Withholding Tax Exemption QSZNR CHAR 10 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
FISC_YEAR Fiscal Year GJAHR NUMC 4 0
CLASS_KEY Classification Key OPORD_KK CHAR 35 0
SUB_APPLICATION Subapplication in Contract Accounts Receivable and Payable SUBAP_KK CHAR 1 0
9 Real Estate
AMOUNT_GL Amount for Updating in General Ledger BP_PSWBT_KK DEC 23 4
TAX_AMOUNT_GL Tax Amount for Update in General Ledger BP_PSWTX_KK DEC 23 4
CURRENCY_GL Update Currency for General Ledger Transaction Figures PSWSL_KK CUKY 5 0
CURRENCY_GL_ISO ISO currency code ISOCD CHAR 3 0
FINAL_RECIPIENT Contract Account of Final Recipient FINRE_KK CHAR 12 0
SENDER_ID Sender ID of Systems Connected to FI-CA SENDR_KK CHAR 3 0
REFERENCE_POSITION Reference Item for External Billing System REFKY_KK CHAR 35 0
SEGMENT Segment for Segmental Reporting SEGMT_KK CHAR 10 0
STAT_TAX_AMOUNT Tax Amount as Statistical Information in Document Currency BP_STTAX_KK DEC 23 4
EXTERNAL_SYSTEM ID of External System REFSY_KK CHAR 3 0
PORTION_TAX_AMOUNT_LOC Tax Portion in FI-CA Local Currency BP_SCTAX_KK DEC 23 4
PROFIT_CTR Profit Center PRCTR CHAR 10 0
BUDGET_PERIOD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
CONT_POSN Numerical Character Field of Length 6 NUM6 NUMC 6 0
CONTRACT_POS Contract: Item Number VTPOS_KK NUMC 6 0
SEPA_MANDATE_ID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0

BAPIDFKKOP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPIDFKKOP ACCTASSCAT BAPIDFKKOP ACCTASSCAT TFK000K Account Assignment Categories KONTT
BAPIDFKKOP BUSPARTNER SY MANDT BUT000 BP: General data I CLIENT
BAPIDFKKOP BUSPARTNER BAPIDFKKOP BUSPARTNER BUT000 BP: General data I PARTNER
BAPIDFKKOP BUS_AREA SY MANDT TGSB Business Areas MANDT
BAPIDFKKOP BUS_AREA BAPIDFKKOP BUS_AREA TGSB Business Areas GSBER
BAPIDFKKOP CLEAR_REAS BAPIDFKKOP CLEAR_REAS TFK001A Clearing Reasons AUGRD
BAPIDFKKOP CLRG_CURR BAPIDFKKOP CLRG_CURR TCURC Currency Codes WAERS
BAPIDFKKOP CLRG_CURR SY MANDT TCURC Currency Codes MANDT
BAPIDFKKOP COMP_CODE BAPIDFKKOP COMP_CODE T001 Company Codes BUKRS
BAPIDFKKOP COMP_CODE SY MANDT T001 Company Codes MANDT
BAPIDFKKOP CONT_ACCT SY MANDT FKKVK Contract Account Header MANDT
BAPIDFKKOP CONT_ACCT BAPIDFKKOP CONT_ACCT FKKVK Contract Account Header VKONT
BAPIDFKKOP CURRENCY SY MANDT TCURC Currency Codes MANDT
BAPIDFKKOP CURRENCY BAPIDFKKOP CURRENCY TCURC Currency Codes WAERS
BAPIDFKKOP DIVISION SY MANDT TSPA Organizational Unit: Sales Divisions MANDT
BAPIDFKKOP DIVISION BAPIDFKKOP DIVISION TSPA Organizational Unit: Sales Divisions SPART
BAPIDFKKOP DOC_TYPE SY MANDT TFK003 Document types MANDT
BAPIDFKKOP DOC_TYPE BAPIDFKKOP APPL_AREA TFK003 Document types APPLK
BAPIDFKKOP DOC_TYPE BAPIDFKKOP DOC_TYPE TFK003 Document types BLART
BAPIDFKKOP DUNN_BLOCK SY MANDT TFK047S Dunning block reasons MANDT
BAPIDFKKOP DUNN_BLOCK BAPIDFKKOP DUNN_BLOCK TFK047S Dunning block reasons MANSP
BAPIDFKKOP DUNN_PROC BAPIDFKKOP DUNN_PROC TFK047A Dunning procedure MAHNV
BAPIDFKKOP DUNN_PROC SY MANDT TFK047A Dunning procedure MANDT
BAPIDFKKOP G_L_ACCT SY MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
BAPIDFKKOP G_L_ACCT T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
BAPIDFKKOP G_L_ACCT BAPIDFKKOP G_L_ACCT SKA1 G/L Account Master (Chart of Accounts) SAKNR
BAPIDFKKOP INT_BLOCK SYST MANDT TFK056S Blocking Reasons for Interest Calculation MANDT
BAPIDFKKOP INT_BLOCK BAPIDFKKOP INT_BLOCK TFK056S Blocking Reasons for Interest Calculation SPERZ
BAPIDFKKOP INT_KEY SY MANDT TFK056A Interest Key Table for FI-CA MANDT
BAPIDFKKOP INT_KEY BAPIDFKKOP INT_KEY TFK056A Interest Key Table for FI-CA IKEY
BAPIDFKKOP MAIN_TRANS SY MANDT TFKHVO Main transactions in contract accts receivable and payable MANDT
BAPIDFKKOP MAIN_TRANS BAPIDFKKOP APPL_AREA TFKHVO Main transactions in contract accts receivable and payable APPLK
BAPIDFKKOP MAIN_TRANS BAPIDFKKOP MAIN_TRANS TFKHVO Main transactions in contract accts receivable and payable HVORG
BAPIDFKKOP OFFSET_TAX BAPIDFKKOP OFFSET_TAX SKA1 G/L Account Master (Chart of Accounts) SAKNR
BAPIDFKKOP OFFSET_TAX SY MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
BAPIDFKKOP OFFSET_TAX T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
BAPIDFKKOP PARTNER SY MANDT BUT000 BP: General data I CLIENT
BAPIDFKKOP PARTNER BAPIDFKKOP PARTNER BUT000 BP: General data I PARTNER
BAPIDFKKOP PERIOD_KEY SY MANDT TFK001P Period key MANDT
BAPIDFKKOP PERIOD_KEY BAPIDFKKOP PERIOD_KEY TFK001P Period key PERSL
BAPIDFKKOP PLAN_GRP SY MANDT T035 Planning groups MANDT
BAPIDFKKOP PLAN_GRP BAPIDFKKOP PLAN_GRP T035 Planning groups GRUPP
BAPIDFKKOP PLAN_LEVEL SY MANDT T036 Planning levels MANDT
BAPIDFKKOP PLAN_LEVEL BAPIDFKKOP PLAN_LEVEL T036 Planning levels EBENE
BAPIDFKKOP PMNT_BLOCK BAPIDFKKOP PMNT_BLOCK TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
BAPIDFKKOP PMNT_BLOCK SY MANDT TFK008 Locking Reasons for Automatic Payment Transactions MANDT
BAPIDFKKOP PMNT_METH SY MANDT TFK042Z Payment Program: Additional Specifications for Payt Methods MANDT
BAPIDFKKOP PMNT_METH T001 LAND1 TFK042Z Payment Program: Additional Specifications for Payt Methods LAND1
BAPIDFKKOP PMNT_METH BAPIDFKKOP PMNT_METH TFK042Z Payment Program: Additional Specifications for Payt Methods ZLSCH
BAPIDFKKOP SUB_TRANS BAPIDFKKOP APPL_AREA TFKTVO Sub-transactions in Contract Accounts Receivable and Payable APPLK
BAPIDFKKOP SUB_TRANS BAPIDFKKOP MAIN_TRANS TFKTVO Sub-transactions in Contract Accounts Receivable and Payable HVORG
BAPIDFKKOP SUB_TRANS BAPIDFKKOP SUB_TRANS TFKTVO Sub-transactions in Contract Accounts Receivable and Payable TVORG
BAPIDFKKOP SUB_TRANS SY MANDT TFKTVO Sub-transactions in Contract Accounts Receivable and Payable MANDT
BAPIDFKKOP TAXJURCODE SY MANDT TTXJ Check Table for Tax Jurisdiction MANDT
BAPIDFKKOP TAXJURCODE T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
BAPIDFKKOP TAXJURCODE BAPIDFKKOP TAXJURCODE TTXJ Check Table for Tax Jurisdiction TXJCD
BAPIDFKKOP TAX_ACCT SY MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
BAPIDFKKOP TAX_ACCT T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
BAPIDFKKOP TAX_ACCT BAPIDFKKOP TAX_ACCT SKA1 G/L Account Master (Chart of Accounts) SAKNR
BAPIDFKKOP TAX_CODE SY MANDT T007A Tax Keys MANDT
BAPIDFKKOP TAX_CODE T005 KALSM T007A Tax Keys KALSM
BAPIDFKKOP TAX_CODE BAPIDFKKOP TAX_CODE T007A Tax Keys MWSKZ
BAPIDFKKOP TRADE_ID SY MANDT T880 Global Company Data (for KONS Ledger) MANDT
BAPIDFKKOP TRADE_ID BAPIDFKKOP TRADE_ID T880 Global Company Data (for KONS Ledger) RCOMP