FICA_INV_S_COLBI_ITEM SAP (Collective Bill) Structure details

Dictionary Type: Structure
Description: Collective Bill




ABAP Code to SELECT data from FICA_INV_S_COLBI_ITEM
Related tables to FICA_INV_S_COLBI_ITEM
Access table FICA_INV_S_COLBI_ITEM




Structure field list including key, data, relationships and ABAP select examples

FICA_INV_S_COLBI_ITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Collective Bill" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FICA_INV_S_COLBI_ITEM TYPE FICA_INV_S_COLBI_ITEM.

The FICA_INV_S_COLBI_ITEM table consists of various fields, each holding specific information or linking keys about Collective Bill data available in SAP. These include MANDT (Client), OPBEL (Number of Contract Accts Rec. & Payable Doc.), OPUPW (Repetition Item in Contract Account Document), OPUPK (Item number in contract account document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP FICA_INV_S_COLBI_ITEM structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
WA_COLBI_ITEM 0
MANDTClient MANDTCLNT3MANDT
OPBELNumber of Contract Accts Rec. & Payable Doc. OPBEL_KKCHAR12ALPHAOPBEL_KK80B
OPUPWRepetition Item in Contract Account Document OPUPW_KKNUMC3OPUPW_KK
OPUPKItem number in contract account document OPUPK_KKNUMC4OPUPK_KK
OPUPZSubitem for a Partial Clearing in Document OPUPZ_KKNUMC3OPUPZ_KK
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
GSBERBusiness Area GSBERCHAR4GSBERGSB
BUPLABusiness Place BUPLACHAR4J_1BBRANCH
SEGMENTSegment for Segmental Reporting SEGMT_KKCHAR10ALPHAFB_SEGMENT
PRCTRProfit Center PRCTRCHAR10ALPHAPRCTRPRCPRCTR_EMPTY
AUGSTClearing status AUGST_KKCHAR1AUGST_KK
GPARTBusiness Partner Number GPART_KKCHAR10ALPHABU_PARTNERBPA
VTREFReference Specifications from Contract VTREF_KKCHAR20ALPHAVTREF_KKVTZ
VTPOSContract: Item Number VTPOS_KKNUMC6VTPOS_KK
VTRE2Additional Reference Information VTRE2_KKCHAR20ALPHAVTREF_KK
VKONTContract Account Number VKONT_KKCHAR12ALPHAVKONT_KKKTOFKKVKP_F4
ABWBLNumber of the substitute FI-CA document ABWBL_KKCHAR12ALPHAABWBL_KK
ABWTPCategory of substitute document in FI-CA ABWTP_KKCHAR1ABWTP_KK
ABWKTAlternative contract account for collective bills ABWVK_KKCHAR12ALPHAVKONT_KK
APPLKApplication area APPLK_KKCHAR1APPLK_KK
HVORGMain Transaction for Line Item HVORG_KKCHAR4HVORG_KK8HV
TVORGSubtransaction for Document Item TVORG_KKCHAR4TVORG_KK
KOFIZAccount Determination ID KOFIZ_KKCHAR2KOFIZ_KK
SPARTDivision SPART_KKCHAR2SPARTSPA
HKONTGeneral ledger account HKONT_KKCHAR10ALPHASAKNRSAKO
MWSKZTax on sales/purchases code MWSKZCHAR2MWSKZ
MWSZKZSupplementary Tax MWSZKZ_KKCHAR2MWSKZ
XANZAItem is a Down Payment/Down Payment Request XANZA_KKCHAR1XFELD
STAKZType of statistical item STAKZ_KKCHAR1STAKZ_KK
BLDATDocument Date in Document BLDATDATS8DATUM
BUDATPosting Date in the Document BUDAT_KKDATS8DATUM
OPTXTItem text OPTXT_KKCHAR50TEXT50
WAERSTransaction Currency BLWAE_KKCUKY5WAERSFWS
FAEDNDue date for net payment FAEDN_KKDATS8DATUM
FAEDSDue Date for Cash Discount FAEDS_KKDATS8DATUM
VERKZItem Can Only Be Cleared VERKZ_KKCHAR1VERKZ_KK
STUDTDeferral to STUDT_KKDATS8DATUM
SKTPZCash discount rate SKTPZ_KKDEC5(3) PRZ23
XMANLExclude Item from Dunning Run XMANL_KKCHAR1XFELD
KURSFExchange rate KURSF_KKDEC9(5) EXCRTKURSF
BETRHAmount In Local Currency With +/- Signs BETRH_KKCURR13(2) WRTV7
BETRWAmount in Transaction Currency with +/- Sign BETRW_KKCURR13(2) WRTV7
BETR2Amount in second parallel currency with +/- sign BETR2_KKCURR13(2) WRTV7
BETR3Amount in third parallel currency with +/- sign BETR3_KKCURR13(2) WRTV7
SKFBTAmount eligible for cash discount in document currency SKFBT_KKCURR13(2) WRTV7
SBETHTax Amount in Local Currency With +/- Sign SBETH_KKCURR13(2) WRTV7
SBETWTax Amount in Transaction Currency with +/- Sign SBETW_KKCURR13(2) WRTV7
SBET2Tax amount in second parallel currency SBET2_KKCURR13(2) WRTV7
SBET3Tax amount in third parallel currency SBET3_KKCURR13(2) WRTV7
MWSKOAccount for posting taxes for down payments MWSKO_KKCHAR10ALPHASAKNR
MWVKOAccount for offsetting tax posting in down payments MWVKO_KKCHAR10ALPHASAKNR
TXRULUpdate Rule for Tax and Tax Clearing TXRUL_KKCHAR1TXRUL_KK
SPZAHLock Reason for Automatic Payment SPZAH_KKCHAR1SPZAH_KK
PYMETPayment Method PYMET_KKCHAR1PYMET_KK
PYBUKCompany Code for Automatic Payment Transactions PYBUK_KKCHAR4BUKRS
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
GRKEYGrouping Key for Displaying Open Items GRKEY_KKCHAR3CHAR3
PERSLKey for Period Assignment PERSL_KKCHAR4PERSL_KK
XAESPPrinting - No Changes Possible XAESP_KKCHAR1XFELD
AUGDTClearing date AUGDT_KKDATS8DATUM
AUGBLClearing Document or Printed Document AUGBL_KKCHAR12ALPHAAUGBL_KK
AUGBDClearing document posting date AUGBD_KKDATS8DATUM
AUGRDClearing Reason AUGRD_KKCHAR2AUGRD_KK
AUGWAClearing currency AUGWA_KKCUKY5WAERS
AUGBTClearing amount in clearing currency AUGBT_KKCURR13(2) WRTV7
AUGBSTax amount in clearing currency AUGBS_KKCURR13(2) WRTV7
AUGSKCash Discount Granted/Surcharge Levied in Clearing Currency AUGSK_KKCURR13(2) WRTV7
AUGVDValue date for clearing AUGVD_KKDATS8DATUM
AUGOBItem Canceled AUGOB_KKCHAR1XFELD
WHANGNumber of repetition items WHANG_KKNUMC3NUM03
WHGRPRepetition group WHGRP_KKNUMC3WHGRP_KK
XEIPHCreate Line Item in General Ledger XEIPH_KKCHAR1XFELD
MAHNVDunning Procedure MAHNV_KKCHAR2MAHNV_KKFKK_MAHNV
MANSPDunning Lock Reason MANSP_KKCHAR1MANSP_KK
XAUGPCheck Sample Record Clearing XAUGP_KKCHAR1XFELD
ABRZULower Limit of Settlement Period ABRZU_KKDATS8DATUM
ABRZOUpper Limit of the Billing Period ABRZO_KKDATS8DATUM
FDGRPPlanning Group FDGRP_KKCHAR10ALPHAFDGRPFFG
FDLEVPlanning level FDLEV_KKCHAR2FDLEVFFE
FDZTGAdditional Days for Cash Management FDZTG_KKNUMC2NUM2
FDWBTPlanning amount in document currency FDWBTCURR13(2) WERTV7
XTAUSItem Split XTAUS_KKCHAR1XFELD
AUGRSClearing restriction AUGRS_KKCHAR1AUGRS_KK
PYGRPGrouping field for automatic payments PYGRP_KKCHAR10CHAR10
PDTYPCategory of Payment Specification PDTYP_KKCHAR1PDTYP_KK
SPERZInterest Lock Reason SPERZ_KKCHAR1SPERZ_KK
INFOZDoubtful Item Entry/Individual Value Adjustment INFOZ_KKNUMC3INFOZ_KK
TXJCDTax Jurisdiction TXJCDCHAR15TXJCDTXJ
TXDATDecisive Date for Calculating Taxes TXDAT_KKDATS8DATUM
VBUNDCompany ID of trading partner RASSCCHAR6ALPHARCOMPPGS
KONTTAccount Assignment Category KONTT_KKCHAR2KONTT_KK
KONTLAcct assnmnt string for industry-specific account assngments KONTL_KKCHAR50CHAR50
OPSTADunning indicator OPSTA_KKCHAR3OPSTA_KK
BLARTDocument Type BLART_KKCHAR2BLART_KK
EMGPAAlternative Business Partner for Payments EMGPA_KKCHAR10ALPHABU_PARTNERBUPA
EMBVTBank Details ID of Payee EMBVT_KKCHAR4CHAR4
EMADRAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
IKEYInterest Key IKEY_KKCHAR2IKEY_KK
EUROUStatus of Euro Conversion EUROU_KKCHAR1EUROU_KK
XRAGLClearing posting reversed XRAGL_KKCHAR1XFELD
XWHPOExpanded Repetition Item XWHPO_KKCHAR1XFELD
ASTKZStatistical Key of the Initiating Item ASTKZ_KKCHAR1ASTKZ_KK
ASBLGNumber of Triggering Document ASBLG_KKCHAR12ALPHAOPBEL_KK
XBLNRReference document number XBLNR_KKCHAR16ALPHAXBLNR_KK
INKPSCollection Item INKPS_KKNUMC3NUM03
RNDPSType of Rounding Item RNDPS_KKCHAR1RNDPS_KK
QSSKZWithholding Tax Code QSSKZCHAR2QSSKZ
QSSEWWithholding Tax Supplement QSSEW_KKCHAR2QSSEW_KK
QSPTPLine Item Category From Withholding Tax View QSPTP_KKCHAR1QSPTP_KK
QSSHBTax Base Amount QSSHB_KKCURR13(2) WRTV7
QBSHBWithholding Tax Amount (in Document Currency) QBSHB_KKCURR13(2) WRTV7
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
XWHEXVariable Withholding Tax in DFKKOPWH XWHEX_KKCHAR1XFELD
RFUPKReference Item In FI-CA Document RFUPK_KKNUMC4OPUPK_KK
STRKZTax Code for Other Taxes STRKZ_KKCHAR2STRKZ_KK
FITPRTax type J_1AFITP_DCHAR2J_1AFITP
XPYORItem Included in a Payment Order XPYOR_KKCHAR1XPYOR_KK
LANDLCountry Supplied (for Tax Notifications) LANDL_KKCHAR3LAND1
INTBUReason for Automatic Creation of Posting INTBU_KKCHAR1INTBU_KK
EMCRDAlternative Payment Card ID in Document EMCRD_KKCHAR6CHAR6
C4EYECheck Reason for Workflows Acc. to Dual Control Principle C4EYE_KKCHAR2C4EYE_KK
CFOPNCFOP Code and Extension J_1BCFOPCHAR10CFOBRJ_1BCFOP
C4EYPEditing Process To Be Confirmed C4EYP_KKCHAR1C4EYP_KK
SCTAXTax Portion in FI-CA Local Currency SCTAX_KKCURR13(2) WRTV7
STTAXTax Amount as Statistical Information in Document Currency STTAX_KKCURR13(2) WRTV7
STZALStatus of Payment Processing STZAL_KKCHAR1STZAL_KK
ORUPZSubitem Number before Item Split ORUPZ_KKCHAR3CHAR3
NEGBUControl Field for Negative Posting NEGBU_KKNUMC1NEGBU_KK
SUBAPSubapplication in Contract Accounts Receivable and Payable SUBAP_KKCHAR1SUBAP_KK8SA
PSWSLUpdate Currency for General Ledger Transaction Figures PSWSL_KKCUKY5WAERS
PSWBTAmount for Updating in General Ledger PSWBT_KKCURR13(2) WRTV7
PSWTXTax Amount for Update in General Ledger PSWTX_KKCURR13(2) WRTV7
PSGRPGrouping Key for Document Items PSGRP_KKCHAR4CHAR4
XCOLCItem Is Included in Collection Case XCOLC_KKCHAR1XFELD
AASTAControl Field for Account Assignment Distributions AASTA_KKCHAR1AASTA_KK
XCSHADocument Contains Assignments from Cash Flows XCSHA_KKCHAR1XFELD
REACCOriginating Account in Cash Flow Anlaysis REACC_KKCHAR10ALPHASAKNR
REBUKPartner Company Code for Cash Flow Analysis REBUK_KKCHAR4BUKRS
XUSTPDTax on Sales/Purchases Was Calculated by Document XUSTPD_KKCHAR1XFELD
PTITMStatus of Partner Settlement Using Billable Items PTITM_KKCHAR1PTITM_KK
EMMNDSEPA Mandate Identifier EMMND_KKNUMC6NUM06
PNNUMSEPA: Number of Direct Debit Pre-Notification PNNUM_KKCHAR16ALPHAPNNUM_KK
PNHKFSEPA: Origin of Direct Debit Pre-Notification PNHKF_KKCHAR2PNHKF_KK
PNEXDSEPA: Date of Execution of Direct Debit Pre-Notifcation PNEXD_KKDATS8DATUM
PNCTRSEPA: Requirement for a Pre-Notification PNCTR_KKCHAR1PNCTR_KK
FINREContract Account of Final Recipient FINRE_KKCHAR12ALPHAVKONT_KKFKKVKP_F4
RDSTACurrent Distribution Status RDSTA_KKCHAR1RDSTAT_KK
RDSTBLast Distribution Status Reported RDSTB_KKCHAR1RDSTAT_KK
FMTYPUpdate Method for FM - FI-CA Integration FMTYP_KKCHAR2FMTYP_KK
ORIGFIKRSOriginal FM Area for FM Account Assignment ORIGFIKRS_KKCHAR4FIKRS
FIPEXCommitment Item FM_FIPEXCHAR24FM_FIPEXFPS
FISTLFunds Center FISTLCHAR16FISTLFIS
FONDSFund BP_GEBERCHAR10BP_GEBERFIC
FKBERFunctional Area FKBERCHAR16FKBERFBE
MEASUREFunded Program FM_MEASURECHAR24FM_MEASUREFM_MEASURE
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
BUDGETYEAROriginal Year for FM Account Assignment FM_START_OF_CHAINNUMC4GJAHRGJAHR
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10FM_BUDGET_PERIODBUDPER
T_CHILD_DOCH 0

Key field Non-key field



How do I retrieve data from SAP structure FICA_INV_S_COLBI_ITEM using ABAP code?

As FICA_INV_S_COLBI_ITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FICA_INV_S_COLBI_ITEM as there is no data to select.

How to access SAP table FICA_INV_S_COLBI_ITEM

Within an ECC or HANA version of SAP you can also view further information about FICA_INV_S_COLBI_ITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!