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

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ FKKB (Package) Contract A/R & A/P: Central Objects

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIDFKKOP	Table Relationship Diagram
Short Description	BAPI: Business Partner Items for Open Item Account Document

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DOC_NO	☑	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	*
2	REP_ITEM	☑	OPUPW_KK	OPUPW_KK	NUMC	3	0	Repetition Item in Contract Account Document
3	ITEM	☑	OPUPK_KK	OPUPK_KK	NUMC	4	0	Item number in contract account document
4	SUB_ITEM	☑	OPUPZ_KK	OPUPZ_KK	NUMC	3	0	Subitem for a Partial Clearing in Document
5	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
7	STATUS	☐	AUGST_KK	AUGST_KK	CHAR	1	0	Clearing status
8	BUSPARTNER	☐	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
9	CONTRACT	☐	VTREF_KK	VTREF_KK	CHAR	20	0	Reference Specifications from Contract
10	CONTRACT2	☐	VTRE2_KK	VTREF_KK	CHAR	20	0	Additional Reference Information
11	CONT_ACCT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	FKKVK
12	SUB_DOC	☐	ABWBL_KK	ABWBL_KK	CHAR	12	0	Number of the substitute FI-CA document
13	DOC_CAT	☐	ABWTP_KK	ABWTP_KK	CHAR	1	0	Category of substitute document in FI-CA
14	APPL_AREA	☐	APPLK_KK	APPLK_KK	CHAR	1	0	Application area
15	MAIN_TRANS	☐	HVORG_KK	HVORG_KK	CHAR	4	0	Main Transaction for Line Item	TFKHVO
16	SUB_TRANS	☐	TVORG_KK	TVORG_KK	CHAR	4	0	Subtransaction for Document Item	TFKTVO
17	ACTDETERID	☐	KOFIZ_KK	KOFIZ_KK	CHAR	2	0	Account Determination ID
18	DIVISION	☐	SPART_KK	SPART	CHAR	2	0	Division	TSPA
19	G_L_ACCT	☐	HKONT_KK	SAKNR	CHAR	10	0	General ledger account	SKA1
20	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
21	DOWN_PMNT	☐	XANZA_KK	XFELD	CHAR	1	0	Item is a Down Payment/Down Payment Request
22	STAT_KEY	☐	STAKZ_KK	STAKZ_KK	CHAR	1	0	Type of statistical item
23	DOC_DATE	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
24	POST_DATE	☐	BUDAT_KK	DATUM	DATS	8	0	Posting Date in the Document
25	TEXT	☐	OPTXT_KK	TEXT50	CHAR	50	0	Item text
26	NET_DATE	☐	FAEDN_KK	DATUM	DATS	8	0	Due date for net payment
27	DISC_DUE	☐	FAEDS_KK	DATUM	DATS	8	0	Due Date for Cash Discount
28	ONLY_OFF	☐	VERKZ_KK	VERKZ_KK	CHAR	1	0	Item Can Only Be Cleared
29	DEFERRAL	☐	STUDT_KK	DATUM	DATS	8	0	Deferral to
30	DISC_RATE	☐	SKTPZ_KK	PRZ23	DEC	5	3	Cash discount rate
31	NO_DUNNING	☐	XMANL_KK	XFELD	CHAR	1	0	Exclude Item from Dunning Run
32	TRAN_RATE	☐	KURSF_KK	KURSF	DEC	9	5	Exchange rate
33	CURRENCY	☐	BLWAE_KK	WAERS	CUKY	5	0	Transaction Currency	TCURC
34	CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
35	AMOUNT_LOC_CURR	☐	BP_BETRH_KK	BAPICURR	DEC	23	4	Amount in Local Currency with +/- Signs
36	AMOUNT	☐	BP_BETRW_KK	BAPICURR	DEC	23	4	Amount in Transaction Currency with +/- Sign
37	AMOUNT_PAR2_CURR	☐	BP_BETR2_KK	BAPICURR	DEC	23	4	Amount in second parallel currency with +/- sign
38	AMOUNT_PAR3_CURR	☐	BP_BETR3_KK	BAPICURR	DEC	23	4	Amount in third parallel currency with +/- sign
39	DISCOUNT_BASE	☐	BP_SKFBT_KK	BAPICURR	DEC	23	4	Amount eligible for cash discount in document currency
40	TAX_AMOUNT_LOC_CURR	☐	BP_SBETH_KK	BAPICURR	DEC	23	4	Tax Amount in Local Currency with +/- Sign
41	TAX_AMOUNT	☐	BP_SBETW_KK	BAPICURR	DEC	23	4	Tax amount in transaction currency with +/- sign
42	TAX_AMOUNT_PAR2_CURR	☐	BP_SBET2_KK	BAPICURR	DEC	23	4	Tax amount in second parallel currency
43	TAX_AMOUNT_PAR3_CURR	☐	BP_SBET3_KK	BAPICURR	DEC	23	4	Tax amount in third parallel currency
44	TAX_ACCT	☐	MWSKO_KK	SAKNR	CHAR	10	0	Account for posting taxes for down payments	SKA1
45	OFFSET_TAX	☐	MWVKO_KK	SAKNR	CHAR	10	0	Account for offsetting tax posting in down payments	SKA1
46	PMNT_BLOCK	☐	SPZAH_KK	SPZAH_KK	CHAR	1	0	Lock Reason for Automatic Payment	TFK008
47	PMNT_METH	☐	PYMET_KK	PYMET_KK	CHAR	1	0	Payment Method	TFK042Z
48	PERSON_NO	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
49	GROUPING	☐	GRKEY_KK	CHAR3	CHAR	3	0	Grouping Key for Displaying Open Items
50	PERIOD_KEY	☐	PERSL_KK	PERSL_KK	CHAR	4	0	Key for Period Assignment	TFK001P
51	CHG_BLOCK	☐	XAESP_KK	XFELD	CHAR	1	0	Printing - No Changes Possible
52	CLEARDATE	☐	AUGDT_KK	DATUM	DATS	8	0	Clearing date
53	CLEARDOCNO	☐	AUGBL_KK	AUGBL_KK	CHAR	12	0	Clearing Document or Printed Document
54	CL_POSTDTE	☐	AUGBD_KK	DATUM	DATS	8	0	Clearing document posting date
55	CLEAR_REAS	☐	AUGRD_KK	AUGRD_KK	CHAR	2	0	Clearing Reason	TFK001A
56	CLRG_CURR	☐	AUGWA_KK	WAERS	CUKY	5	0	Clearing currency	TCURC
57	CLRG_CURR_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
58	AMOUNT_CLEAR	☐	BP_AUGBT_KK	BAPICURR	DEC	23	4	Clearing amount in clearing currency
59	TAX_AMOUNT_CLEAR	☐	BP_AUGBS_KK	BAPICURR	DEC	23	4	Tax Amount in Clearing Currency
60	VAL_DATE	☐	AUGVD_KK	DATUM	DATS	8	0	Value date for clearing
61	CANCELED	☐	AUGOB_KK	XFELD	CHAR	1	0	Item Canceled
62	NO_REPS	☐	WHANG_KK	NUM03	NUMC	3	0	Number of repetition items
63	REPET_GRP	☐	WHGRP_KK	WHGRP_KK	NUMC	3	0	Repetition group	*
64	LINE_ITEM	☐	XEIPH_KK	XFELD	CHAR	1	0	Create Line Item in General Ledger
65	DUNN_PROC	☐	MAHNV_KK	MAHNV_KK	CHAR	2	0	Dunning Procedure	TFK047A
66	DUNN_BLOCK	☐	MANSP_KK	MANSP_KK	CHAR	1	0	Dunning Lock Reason	TFK047S
67	CHECK_CLNG	☐	XAUGP_KK	XFELD	CHAR	1	0	Check Sample Record Clearing
68	CALC_PERLO	☐	ABRZU_KK	DATUM	DATS	8	0	Lower Limit of Settlement Period
69	CALC_PERHI	☐	ABRZO_KK	DATUM	DATS	8	0	Upper Limit of the Billing Period
70	PLAN_GRP	☐	FDGRP_KK	FDGRP	CHAR	10	0	Planning Group	T035
71	PLAN_LEVEL	☐	FDLEV_KK	FDLEV	CHAR	2	0	Planning level	T036
72	CM_EX_DAYS	☐	FDZTG_KK	NUM2	NUMC	2	0	Additional Days for Cash Management
73	AMOUNT_PLANNED	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
74	PART_CLRG	☐	XTAUS_KK	XFELD	CHAR	1	0	Item Split
75	RESTRICT	☐	AUGRS_KK	AUGRS_KK	CHAR	1	0	Clearing restriction
76	PAYMNT_GRP	☐	PYGRP_KK	CHAR10	CHAR	10	0	Grouping field for automatic payments
77	INT_BLOCK	☐	SPERZ_KK	SPERZ_KK	CHAR	1	0	Interest Lock Reason	TFK056S
78	INT_INFO	☐	INFOZ_KK	INFOZ_KK	NUMC	3	0	Doubtful Item Entry/Individual Value Adjustment
79	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
80	TAX_DATE	☐	TXDAT_KK	DATUM	DATS	8	0	Decisive Date for Calculating Taxes
81	TRADE_ID	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
82	ACCTASSCAT	☐	KONTT_KK	KONTT_KK	CHAR	2	0	Account Assignment Category	TFK000K
83	ACCT_ASSGT	☐	KONTL_KK	CHAR50	CHAR	50	0	Acct assnmnt string for industry-specific account assngments
84	DUN_INDIC	☐	OPSTA_KK	OPSTA_KK	CHAR	3	0	Dunning indicator
85	DOC_TYPE	☐	BLART_KK	BLART_KK	CHAR	2	0	Document Type	TFK003
86	PARTNER	☐	EMGPA_KK	BU_PARTNER	CHAR	10	0	Alternative business partner for payments	BUT000
87	BK_DETAILS	☐	EMBVT_KK	CHAR4	CHAR	4	0	Bank Details ID of Payee
88	ADDR_NO	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
89	INT_KEY	☐	IKEY_KK	IKEY_KK	CHAR	2	0	Interest Key	TFK056A
90	EURO_STAT	☐	EUROU_KK	EUROU_KK	CHAR	1	0	Status of Euro Conversion
91	REVERSECLG	☐	XRAGL_KK	XFELD	CHAR	1	0	Clearing posting reversed
92	XREPETPOS	☐	XWHPO_KK	XFELD	CHAR	1	0	Expanded Repetition Item
93	STAT_KEY_SRC	☐	ASTKZ_KK	ASTKZ_KK	CHAR	1	0	Statistical Key of the Initiating Item
94	REF_DOC_NO	☐	XBLNR_KK	XBLNR_KK	CHAR	16	0	Reference document number
95	COLLECTION_POS	☐	INKPS_KK	NUM03	NUMC	3	0	Collection Item
96	REFERENCE_ITEM	☐	RFUPK_KK	OPUPK_KK	NUMC	4	0	Reference Item In FI-CA Document
97	OTHER_TAX_CODE	☐	STRKZ_KK	STRKZ_KK	CHAR	2	0	Tax Code for Other Taxes	*
98	TAX_CATEGORY	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	*
99	CRD_DETAILS	☐	EMCRD_KK	CHAR6	CHAR	6	0	Alternative Payment Card ID in Document
100	FM_CATEGORY	☐	FMTYP_KK	FMTYP_KK	CHAR	2	0	Update Method for FM - FI-CA Integration
101	FM_ORIG_AREA	☐	ORIGFIKRS_KK	FIKRS	CHAR	4	0	Original FM Area for FM Account Assignment	*
102	CMMT_ITEM	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
103	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
104	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
105	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
106	W_TAX_CODE	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
107	W_TAX_SUPPL	☐	QSSEW_KK	QSSEW_KK	CHAR	2	0	Withholding Tax Supplement	*
108	W_TAX_LICAT	☐	QSPTP_KK	QSPTP_KK	CHAR	1	0	Line Item Category From Withholding Tax View
109	W_TAX_BASE	☐	BP_QSSHB_KK	BAPICURR	DEC	23	4	Tax Base Amount
110	W_TAX_AMOUNT	☐	BP_QBSHB_KK	BAPICURR	DEC	23	4	Withholding Tax Amount in Document Currency
111	EXEMPT_NO	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
112	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
113	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
114	FISC_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
115	CLASS_KEY	☐	OPORD_KK	CHAR35	CHAR	35	0	Classification Key
116	SUB_APPLICATION	☐	SUBAP_KK	SUBAP_KK	CHAR	1	0	Subapplication in Contract Accounts Receivable and Payable
117	AMOUNT_GL	☐	BP_PSWBT_KK	BAPICURR	DEC	23	4	Amount for Updating in General Ledger
118	TAX_AMOUNT_GL	☐	BP_PSWTX_KK	BAPICURR	DEC	23	4	Tax Amount for Update in General Ledger
119	CURRENCY_GL	☐	PSWSL_KK	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	*
120	CURRENCY_GL_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
121	FINAL_RECIPIENT	☐	FINRE_KK	VKONT_KK	CHAR	12	0	Contract Account of Final Recipient	*
122	SENDER_ID	☐	SENDR_KK	SENDR_KK	CHAR	3	0	Sender ID of Systems Connected to FI-CA
123	REFERENCE_POSITION	☐	REFKY_KK	CHAR35	CHAR	35	0	Reference Item for External Billing System
124	SEGMENT	☐	SEGMT_KK	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
125	STAT_TAX_AMOUNT	☐	BP_STTAX_KK	BAPICURR	DEC	23	4	Tax Amount as Statistical Information in Document Currency
126	EXTERNAL_SYSTEM	☐	REFSY_KK	REFSY_KK	CHAR	3	0	ID of External System
127	PORTION_TAX_AMOUNT_LOC	☐	BP_SCTAX_KK	BAPICURR	DEC	23	4	Tax Portion in FI-CA Local Currency
128	SEPA_MANDATE_ID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIDFKKOP	ACCTASSCAT	TFK000K	KONTT		1	CN
2	BAPIDFKKOP	BUSPARTNER	BUT000	PARTNER		1	N
3	BAPIDFKKOP	BUS_AREA	TGSB	GSBER		1	CN
4	BAPIDFKKOP	CLEAR_REAS	TFK001A	AUGRD		1	CN
5	BAPIDFKKOP	CLRG_CURR	TCURC	WAERS
6	BAPIDFKKOP	COMP_CODE	T001	BUKRS
7	BAPIDFKKOP	CONT_ACCT	FKKVK	VKONT		1	N
8	BAPIDFKKOP	CURRENCY	TCURC	WAERS		1	N
9	BAPIDFKKOP	DIVISION	TSPA	SPART		1	CN
10	BAPIDFKKOP	DOC_TYPE	TFK003	BLART		1	N
11	BAPIDFKKOP	DUNN_BLOCK	TFK047S	MANSP		1	CN
12	BAPIDFKKOP	DUNN_PROC	TFK047A	MAHNV
13	BAPIDFKKOP	G_L_ACCT	SKA1	SAKNR		1	CN
14	BAPIDFKKOP	INT_BLOCK	TFK056S	SPERZ		1	CN
15	BAPIDFKKOP	INT_KEY	TFK056A	IKEY		1	1
16	BAPIDFKKOP	MAIN_TRANS	TFKHVO	HVORG		1	CN
17	BAPIDFKKOP	OFFSET_TAX	SKA1	SAKNR		1	CN
18	BAPIDFKKOP	PARTNER	BUT000	PARTNER		1	CN
19	BAPIDFKKOP	PERIOD_KEY	TFK001P	PERSL		1	CN
20	BAPIDFKKOP	PLAN_GRP	T035	GRUPP		1	CN
21	BAPIDFKKOP	PLAN_LEVEL	T036	EBENE		1	CN
22	BAPIDFKKOP	PMNT_BLOCK	TFK008	ZAHLS		1	CN
23	BAPIDFKKOP	PMNT_METH	TFK042Z	ZLSCH
24	BAPIDFKKOP	SUB_TRANS	TFKTVO	TVORG		1	CN
25	BAPIDFKKOP	TAXJURCODE	TTXJ	TXJCD		1	CN
26	BAPIDFKKOP	TAX_ACCT	SKA1	SAKNR		1	CN
27	BAPIDFKKOP	TAX_CODE	T007A	MWSKZ		1	CN
28	BAPIDFKKOP	TRADE_ID	T880	RCOMP		1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in	471