SAP ABAP Table FKKOP_FKKCOLL (Business Partner Item Plus Collection Item)
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 FKKOP_FKKCOLL   Table Relationship Diagram
Short Description Business Partner Item Plus Collection Item    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 .INCLUDE       0   0   Business Partner Items in Contract Account Document  
2 MANDT MANDT MANDT CLNT 3   0   Client *
3 OPBEL OPBEL_KK OPBEL_KK CHAR 12   0   Number of Contract Accts Rec. & Payable Doc. *
4 OPUPW OPUPW_KK OPUPW_KK NUMC 3   0   Repetition Item in Contract Account Document  
5 OPUPK OPUPK_KK OPUPK_KK NUMC 4   0   Item number in contract account document  
6 OPUPZ OPUPZ_KK OPUPZ_KK NUMC 3   0   Subitem for a Partial Clearing in Document  
7 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
8 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
9 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place J_1BBRANCH
10 SEGMENT SEGMT_KK FB_SEGMENT CHAR 10   0   Segment for Segmental Reporting FAGL_SEGM
11 AUGST AUGST_KK AUGST_KK CHAR 1   0   Clearing status  
12 GPART GPART_KK BU_PARTNER CHAR 10   0   Business Partner Number BUT000
13 VTREF VTREF_KK VTREF_KK CHAR 20   0   Reference Specifications from Contract  
14 VTRE2 VTRE2_KK VTREF_KK CHAR 20   0   Additional Reference Information  
15 VKONT VKONT_KK VKONT_KK CHAR 12   0   Contract Account Number FKKVK
16 ABWBL ABWBL_KK ABWBL_KK CHAR 12   0   Number of the substitute FI-CA document  
17 ABWTP ABWTP_KK ABWTP_KK CHAR 1   0   Category of substitute document in FI-CA  
18 ABWKT ABWVK_KK VKONT_KK CHAR 12   0   Alternative contract account for collective bills *
19 APPLK APPLK_KK APPLK_KK CHAR 1   0   Application area  
20 HVORG HVORG_KK HVORG_KK CHAR 4   0   Main Transaction for Line Item TFKHVO
21 TVORG TVORG_KK TVORG_KK CHAR 4   0   Subtransaction for Document Item TFKTVO
22 KOFIZ KOFIZ_KK KOFIZ_KK CHAR 2   0   Account Determination ID  
23 SPART SPART_KK SPART CHAR 2   0   Division TSPA
24 HKONT HKONT_KK SAKNR CHAR 10   0   General ledger account SKA1
25 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code T007A
26 MWSZKZ MWSZKZ_KK MWSKZ CHAR 2   0   Supplementary Tax *
27 XANZA XANZA_KK XFELD CHAR 1   0   Item is a Down Payment/Down Payment Request  
28 STAKZ STAKZ_KK STAKZ_KK CHAR 1   0   Type of statistical item  
29 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
30 BUDAT BUDAT_KK DATUM DATS 8   0   Posting Date in the Document  
31 OPTXT OPTXT_KK TEXT50 CHAR 50   0   Item text  
32 WAERS BLWAE_KK WAERS CUKY 5   0   Transaction Currency TCURC
33 FAEDN FAEDN_KK DATUM DATS 8   0   Due date for net payment  
34 FAEDS FAEDS_KK DATUM DATS 8   0   Due Date for Cash Discount  
35 VERKZ VERKZ_KK VERKZ_KK CHAR 1   0   Item Can Only Be Cleared  
36 STUDT STUDT_KK DATUM DATS 8   0   Deferral to  
37 SKTPZ SKTPZ_KK PRZ23 DEC 5   3   Cash discount rate  
38 XMANL XMANL_KK XFELD CHAR 1   0   Exclude Item from Dunning Run  
39 KURSF KURSF_KK KURSF DEC 9   5   Exchange rate  
40 BETRH BETRH_KK WRTV7 CURR 13   2   Amount In Local Currency With +/- Signs  
41 BETRW BETRW_KK WRTV7 CURR 13   2   Amount in Transaction Currency with +/- Sign  
42 BETR2 BETR2_KK WRTV7 CURR 13   2   Amount in second parallel currency with +/- sign  
43 BETR3 BETR3_KK WRTV7 CURR 13   2   Amount in third parallel currency with +/- sign  
44 SKFBT SKFBT_KK WRTV7 CURR 13   2   Amount eligible for cash discount in document currency  
45 SBETH SBETH_KK WRTV7 CURR 13   2   Tax Amount in Local Currency With +/- Sign  
46 SBETW SBETW_KK WRTV7 CURR 13   2   Tax Amount in Transaction Currency with +/- Sign  
47 SBET2 SBET2_KK WRTV7 CURR 13   2   Tax amount in second parallel currency  
48 SBET3 SBET3_KK WRTV7 CURR 13   2   Tax amount in third parallel currency  
49 MWSKO MWSKO_KK SAKNR CHAR 10   0   Account for posting taxes for down payments SKA1
50 MWVKO MWVKO_KK SAKNR CHAR 10   0   Account for offsetting tax posting in down payments SKA1
51 TXRUL TXRUL_KK TXRUL_KK CHAR 1   0   Update Rule for Tax and Tax Clearing  
52 SPZAH SPZAH_KK SPZAH_KK CHAR 1   0   Lock Reason for Automatic Payment TFK008
53 PYMET PYMET_KK PYMET_KK CHAR 1   0   Payment Method *
54 PYBUK PYBUK_KK BUKRS CHAR 4   0   Company Code for Automatic Payment Transactions T001
55 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
56 GRKEY GRKEY_KK CHAR3 CHAR 3   0   Grouping Key for Displaying Open Items  
57 PERSL PERSL_KK PERSL_KK CHAR 4   0   Key for Period Assignment TFK001P
58 XAESP XAESP_KK XFELD CHAR 1   0   Printing - No Changes Possible  
59 AUGDT AUGDT_KK DATUM DATS 8   0   Clearing date  
60 AUGBL AUGBL_KK AUGBL_KK CHAR 12   0   Clearing Document or Printed Document  
61 AUGBD AUGBD_KK DATUM DATS 8   0   Clearing document posting date  
62 AUGRD AUGRD_KK AUGRD_KK CHAR 2   0   Clearing Reason TFK001A
63 AUGWA AUGWA_KK WAERS CUKY 5   0   Clearing currency *
64 AUGBT AUGBT_KK WRTV7 CURR 13   2   Clearing amount in clearing currency  
65 AUGBS AUGBS_KK WRTV7 CURR 13   2   Tax amount in clearing currency  
66 AUGSK AUGSK_KK WRTV7 CURR 13   2   Cash Discount Granted/Surcharge Levied in Clearing Currency  
67 AUGVD AUGVD_KK DATUM DATS 8   0   Value date for clearing  
68 AUGOB AUGOB_KK XFELD CHAR 1   0   Item Canceled  
69 WHANG WHANG_KK NUM03 NUMC 3   0   Number of repetition items  
70 WHGRP WHGRP_KK WHGRP_KK NUMC 3   0   Repetition group *
71 XEIPH XEIPH_KK XFELD CHAR 1   0   Create Line Item in General Ledger  
72 MAHNV MAHNV_KK MAHNV_KK CHAR 2   0   Dunning Procedure TFK047A
73 MANSP MANSP_KK MANSP_KK CHAR 1   0   Dunning Lock Reason TFK047S
74 XAUGP XAUGP_KK XFELD CHAR 1   0   Check Sample Record Clearing  
75 ABRZU ABRZU_KK DATUM DATS 8   0   Lower Limit of Settlement Period  
76 ABRZO ABRZO_KK DATUM DATS 8   0   Upper Limit of the Billing Period  
77 FDGRP FDGRP_KK FDGRP CHAR 10   0   Planning Group T035
78 FDLEV FDLEV_KK FDLEV CHAR 2   0   Planning level T036
79 FDZTG FDZTG_KK NUM2 NUMC 2   0   Additional Days for Cash Management  
80 FDWBT FDWBT WERTV7 CURR 13   2   Planned Amount in Document or G/L Account Currency  
81 XTAUS XTAUS_KK XFELD CHAR 1   0   Item Split  
82 AUGRS AUGRS_KK AUGRS_KK CHAR 1   0   Clearing restriction  
83 PYGRP PYGRP_KK CHAR10 CHAR 10   0   Grouping field for automatic payments  
84 PDTYP PDTYP_KK PDTYP_KK CHAR 1   0   Category of Payment Specification  
85 SPERZ SPERZ_KK SPERZ_KK CHAR 1   0   Interest Lock Reason TFK056S
86 INFOZ INFOZ_KK INFOZ_KK NUMC 3   0   Doubtful Item Entry/Individual Value Adjustment  
87 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
88 TXDAT TXDAT_KK DATUM DATS 8   0   Decisive Date for Calculating Taxes  
89 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner T880
90 KONTT KONTT_KK KONTT_KK CHAR 2   0   Account Assignment Category TFK000K
91 KONTL KONTL_KK CHAR50 CHAR 50   0   Acct assnmnt string for industry-specific account assngments  
92 OPSTA OPSTA_KK OPSTA_KK CHAR 3   0   Dunning indicator  
93 BLART BLART_KK BLART_KK CHAR 2   0   Document Type TFK003
94 EMGPA EMGPA_KK BU_PARTNER CHAR 10   0   Alternative business partner for payments BUT000
95 EMBVT EMBVT_KK CHAR4 CHAR 4   0   Bank Details ID of Payee BUT0BK
96 EMADR AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
97 IKEY IKEY_KK IKEY_KK CHAR 2   0   Interest Key TFK056A
98 EUROU EUROU_KK EUROU_KK CHAR 1   0   Status of Euro Conversion  
99 XRAGL XRAGL_KK XFELD CHAR 1   0   Clearing posting reversed  
100 XWHPO XWHPO_KK XFELD CHAR 1   0   Expanded Repetition Item  
101 ASTKZ ASTKZ_KK ASTKZ_KK CHAR 1   0   Statistical Key of the Initiating Item  
102 ASBLG ASBLG_KK OPBEL_KK CHAR 12   0   Number of Triggering Document *
103 XBLNR XBLNR_KK XBLNR_KK CHAR 16   0   Reference document number  
104 INKPS INKPS_KK NUM03 NUMC 3   0   Collection Item  
105 RNDPS RNDPS_KK RNDPS_KK CHAR 1   0   Type of Rounding Item  
106 QSSKZ QSSKZ QSSKZ CHAR 2   0   Withholding Tax Code T059Q
107 QSSEW QSSEW_KK QSSEW_KK CHAR 2   0   Withholding Tax Supplement *
108 QSPTP QSPTP_KK QSPTP_KK CHAR 1   0   Line Item Category From Withholding Tax View  
109 QSSHB QSSHB_KK WRTV7 CURR 13   2   Tax Base Amount  
110 QBSHB QBSHB_KK WRTV7 CURR 13   2   Withholding Tax Amount (in Document Currency)  
111 QSZNR QSZNR CHAR10 CHAR 10   0   Certificate Number of the Withholding Tax Exemption  
112 RFUPK RFUPK_KK OPUPK_KK NUMC 4   0   Reference Item In FI-CA Document  
113 STRKZ STRKZ_KK STRKZ_KK CHAR 2   0   Tax Code for Other Taxes TFK007F
114 FITPR J_1AFITP_D J_1AFITP CHAR 2   0   Tax type *
115 XPYOR XPYOR_KK XPYOR_KK CHAR 1   0   Item Included in a Payment Order  
116 LANDL LANDL_KK LAND1 CHAR 3   0   Country Supplied (for Tax Notifications) T005
117 INTBU INTBU_KK INTBU_KK CHAR 1   0   Reason for Automatic Creation of Posting  
118 EMCRD EMCRD_KK CHAR6 CHAR 6   0   Alternative Payment Card ID in Document  
119 C4EYE C4EYE_KK C4EYE_KK CHAR 2   0   Check Reason for Workflows Acc. to Dual Control Principle *
120 CFOPN J_1BCFOP J_1BCFOP CHAR 10   0   CFOP code and extension *
121 C4EYP C4EYP_KK C4EYP_KK CHAR 1   0   Editing Process To Be Confirmed  
122 SCTAX SCTAX_KK WRTV7 CURR 13   2   Tax Portion in FI-CA Local Currency  
123 STTAX STTAX_KK WRTV7 CURR 13   2   Tax Amount as Statistical Information in Document Currency  
124 STZAL STZAL_KK STZAL_KK CHAR 1   0   Status of Payment Processing  
125 ORUPZ ORUPZ_KK CHAR3 CHAR 3   0   Subitem Number before Item Split  
126 NEGBU NEGBU_KK NEGBU_KK NUMC 1   0   Control Field for Negative Posting  
127 SUBAP SUBAP_KK SUBAP_KK CHAR 1   0   Subapplication in Contract Accounts Receivable and Payable  
128 PSWSL PSWSL_KK WAERS CUKY 5   0   Update Currency for General Ledger Transaction Figures *
129 PSWBT PSWBT_KK WRTV7 CURR 13   2   Amount for Updating in General Ledger  
130 PSWTX PSWTX_KK WRTV7 CURR 13   2   Tax Amount for Update in General Ledger  
131 PSGRP PSGRP_KK CHAR4 CHAR 4   0   Grouping Key for Document Items  
132 EMMND EMMND_KK NUM06 NUMC 6   0   SEPA Mandate Identification  
133 .INCLUDE       0   0   Direct Debit Pre-Notification in Document Item  
134 PNNUM PNNUM_KK PNNUM_KK CHAR 16   0   SEPA: Number of Direct Debit Pre-Notification  
135 PNHKF PNHKF_KK PNHKF_KK CHAR 2   0   SEPA: Origin of Direct Debit Pre-Notification  
136 PNEXD PNEXD_KK DATUM DATS 8   0   SEPA: Date of Execution of Direct Debit Pre-Notifcation  
137 PNCTR PNCTR_KK PNCTR_KK CHAR 1   0   SEPA: Requirement for a Pre-Notification  
138 .INCLUDE       0   0   Structure for Revenue Distribution  
139 FINRE FINRE_KK VKONT_KK CHAR 12   0   Contract Account of Final Recipient *
140 RDSTA RDSTA_KK RDSTAT_KK CHAR 1   0   Current Distribution Status  
141 RDSTB RDSTB_KK RDSTAT_KK CHAR 1   0   Last Distribution Status Reported  
142 .INCLUDE       0   0   FM Account Assignments for FI-CA Including Type  
143 FMTYP FMTYP_KK FMTYP_KK CHAR 2   0   Update Method for FM - FI-CA Integration  
144 .INCLUDE       0   0   Funds Management Account Assignments for FI-CA  
145 ORIGFIKRS ORIGFIKRS_KK FIKRS CHAR 4   0   Original FM Area for FM Account Assignment *
146 FIPEX FM_FIPEX FM_FIPEX CHAR 24   0   Commitment item *
147 FISTL FISTL FISTL CHAR 16   0   Funds Center *
148 FONDS BP_GEBER BP_GEBER CHAR 10   0   Fund *
149 FKBER FKBER FKBER CHAR 16   0   Functional Area *
150 MEASURE FM_MEASURE FM_MEASURE CHAR 24   0   Funded Program *
151 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
152 BUDGETYEAR FM_START_OF_CHAIN GJAHR NUMC 4   0   Original Year for FM Account Assignment  
153 BUDGET_PD FM_BUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Budget Period *
154 .INCLUDE       0   0   Include: OI for Utility Companies: IS-U  
155 .INCLUDE       0   0   Include OI for Insurance  
156 .INCLUDE       0   0   IS-T: Include open items for telecommunications companies  
157 .INCLUDE       0   0   Public Sector: Fields for Business Partner Items  
158 .INCLUDE       0   0    
159 .INCLUDE       0   0   Include OI for IS-Media  
160 .INCLUDE       0   0   FI-CA Extended: Include OI  
161 BETRZ BETRZ_KK WRTV7 CURR 13   2   Payment amount in transaction currency  
162 NINKB NINKB_KK WRTV7 CURR 13   2   Uncollectable Amount  
163 INTBT INTST_KK WRTV7 CURR 13   2   Interest Receivable from Collection Agency  
164 CHARB CHGST_KK WRTV7 CURR 13   2   Charge Receivable from External Collections Agency  
165 INKGP INKGP_KK BU_PARTNER CHAR 10   0   Collection Agency *
166 TEXTGP TEXT1GP_KK TEXT132 CHAR 132   0   Text for business partner  
167 AGDAT AGDAT_KK DATUM DATS 8   0   Date For Submission of Receivable To Collection Agency  
168 AGGRD AGGRD_KK AGGRD_KK CHAR 2   0   Reason For Submitting An Item To Collection Agency  
169 AGSTA AGSTA_KK AGSTA_KK CHAR 2   0   Status of Item Submitted to Collection Agency  
170 XBLNRC XBLNR_KK XBLNR_KK CHAR 16   0   Reference document number  
171 XSOLD XSOLD_KK XFELD CHAR 1   0   Item Sold to Collection Agency  
172 NRZAS NRZAS_KK NRZAS_KK CHAR 12   0   Payment Form Number  
173 RUDAT RUDAT_KK DATUM DATS 8   0   Recall Date of Receivable from External Collection Agency  
174 CICON CICON_KK CHAR80 CHAR 80   0   Collection Agency Status Display  
175 .INCLUDE       0   0    
176 .INCLUDE       0   0    
177 .INCLUDE       0   0    
178 .INCLUDE       0   0    
179 .INCLUDE       0   0    
180 .INCLUDE       0   0    
181 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 FKKOP_FKKCOLL AUGRD TFK001A AUGRD 1 CN
2 FKKOP_FKKCOLL BLART TFK003 BLART 1 N
3 FKKOP_FKKCOLL BUKRS T001 BUKRS    
4 FKKOP_FKKCOLL BUPLA J_1BBRANCH BRANCH    
5 FKKOP_FKKCOLL EMBVT BUT0BK BKVID    
6 FKKOP_FKKCOLL EMGPA BUT000 PARTNER 1 CN
7 FKKOP_FKKCOLL FDGRP T035 GRUPP 1 CN
8 FKKOP_FKKCOLL FDLEV T036 EBENE 1 CN
9 FKKOP_FKKCOLL GPART BUT000 PARTNER 1 N
10 FKKOP_FKKCOLL GSBER TGSB GSBER 1 CN
11 FKKOP_FKKCOLL HKONT SKA1 SAKNR 1 CN
12 FKKOP_FKKCOLL HVORG TFKHVO HVORG 1 CN
13 FKKOP_FKKCOLL IKEY TFK056A IKEY 1 1
14 FKKOP_FKKCOLL KONTT TFK000K KONTT 1 CN
15 FKKOP_FKKCOLL LANDL T005 LAND1    
16 FKKOP_FKKCOLL MAHNV TFK047A MAHNV    
17 FKKOP_FKKCOLL MANSP TFK047S MANSP 1 CN
18 FKKOP_FKKCOLL MWSKO SKA1 SAKNR 1 CN
19 FKKOP_FKKCOLL MWSKZ T007A MWSKZ 1 CN
20 FKKOP_FKKCOLL MWVKO SKA1 SAKNR 1 CN
21 FKKOP_FKKCOLL PERSL TFK001P PERSL 1 CN
22 FKKOP_FKKCOLL PYBUK T001 BUKRS    
23 FKKOP_FKKCOLL QSSKZ T059Q QSSKZ    
24 FKKOP_FKKCOLL SEGMENT FAGL_SEGM SEGMENT    
25 FKKOP_FKKCOLL SPART TSPA SPART 1 CN
26 FKKOP_FKKCOLL SPERZ TFK056S SPERZ 1 CN
27 FKKOP_FKKCOLL SPZAH TFK008 ZAHLS 1 CN
28 FKKOP_FKKCOLL STRKZ TFK007F STRKZ    
29 FKKOP_FKKCOLL TVORG TFKTVO TVORG 1 CN
30 FKKOP_FKKCOLL TXJCD TTXJ TXJCD 1 CN
31 FKKOP_FKKCOLL VBUND T880 RCOMP 1 CN
32 FKKOP_FKKCOLL VKONT FKKVK VKONT 1 N
33 FKKOP_FKKCOLL WAERS TCURC WAERS 1 N
History
Last changed by/on SAP  20131127 
SAP Release Created in