SAP table BAPIDFKKOP (BAPI: Business Partner Items for Open Item Account Document)

SAP table BAPIDFKKOP has 4 primary key fields being DOC_NO,REP_ITEM,ITEM,SUB_ITEM.

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

BAPIDFKKOP foreign key relationships

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