SAP ABAP Table FICA_INV_S_COLBI_ITEM (Collective Bill)
Hierarchy
FI-CA (Software Component) FI-CA
   FI-CA-INV (Application Component) Invoicing to Contract Accounts Receivable and Payable
     FKKINV (Package) Invoicing in Contract Accounts Receivable and Payable
Basic Data
Table Category INTTAB    Structure 
Structure FICA_INV_S_COLBI_ITEM   Table Relationship Diagram
Short Description Collective Bill    
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 WA_COLBI_ITEM FKKOP   STRU 0   0    
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  
8 GSBER GSBER GSBER CHAR 4   0   Business Area  
9 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place  
10 SEGMENT SEGMT_KK FB_SEGMENT CHAR 10   0   Segment for Segmental Reporting  
11 AUGST AUGST_KK AUGST_KK CHAR 1   0   Clearing status  
12 GPART GPART_KK BU_PARTNER CHAR 10   0   Business Partner Number  
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  
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  
21 TVORG TVORG_KK TVORG_KK CHAR 4   0   Subtransaction for Document Item  
22 KOFIZ KOFIZ_KK KOFIZ_KK CHAR 2   0   Account Determination ID  
23 SPART SPART_KK SPART CHAR 2   0   Division  
24 HKONT HKONT_KK SAKNR CHAR 10   0   General ledger account  
25 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code  
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  
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  
50 MWVKO MWVKO_KK SAKNR CHAR 10   0   Account for offsetting tax posting in down payments  
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  
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  
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  
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  
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  
73 MANSP MANSP_KK MANSP_KK CHAR 1   0   Dunning Lock Reason  
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  
78 FDLEV FDLEV_KK FDLEV CHAR 2   0   Planning level  
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  
86 INFOZ INFOZ_KK INFOZ_KK NUMC 3   0   Doubtful Item Entry/Individual Value Adjustment  
87 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction  
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  
90 KONTT KONTT_KK KONTT_KK CHAR 2   0   Account Assignment Category  
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  
94 EMGPA EMGPA_KK BU_PARTNER CHAR 10   0   Alternative business partner for payments  
95 EMBVT EMBVT_KK CHAR4 CHAR 4   0   Bank Details ID of Payee  
96 EMADR AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number  
97 IKEY IKEY_KK IKEY_KK CHAR 2   0   Interest Key  
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  
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  
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)  
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 T_CHILD_DOCH FICA_INV_T_CHILD_DOCH   TTYP 0   0    
History
Last changed by/on SAP  20141109 
SAP Release Created in 600