FKKINV_BW_EXTRACT00 SAP (BI Extraction Structure for FI-CA Invoicing) Structure details
Dictionary Type: Structure
Description: BI Extraction Structure for FI-CA Invoicing
Description: BI Extraction Structure for FI-CA Invoicing
ABAP Code to SELECT data from FKKINV_BW_EXTRACT00
Related tables to FKKINV_BW_EXTRACT00
Access table FKKINV_BW_EXTRACT00
Related tables to FKKINV_BW_EXTRACT00
Access table FKKINV_BW_EXTRACT00
Structure field list including key, data, relationships and ABAP select examples
FKKINV_BW_EXTRACT00 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 "BI Extraction Structure for FI-CA Invoicing" 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_FKKINV_BW_EXTRACT00 TYPE FKKINV_BW_EXTRACT00.
The FKKINV_BW_EXTRACT00 table consists of various fields, each holding specific information or linking keys about BI Extraction Structure for FI-CA Invoicing data available in SAP. These include INV_PROCESS (Invoicing Process), FIKEY (Reconciliation Key for General Ledger), BUDAT (Posting Date in the Document), PERIOD (Fiscal Year/Period).. 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 (character-type or numeric)
SAP FKKINV_BW_EXTRACT00 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 |
| APPLK | Application area | APPLK_KK | CHAR | 1 | APPLK_KK | ||||
| INV_PROCESS | Invoicing Process | INV_PROCESS_KK | CHAR | 2 | Assigned to domain | INV_PROCESS_KK | |||
| FIKEY | Reconciliation Key for General Ledger | FIKEY_KK | CHAR | 12 | Assigned to domain | FIKEY_KK | FKFI1 | ||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
| PERIOD | Fiscal Year/Period | PERIOD_KK | CHAR | 7 | JAMON_XPO | ||||
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
| XREVERSAL | Invoicing Document Is Reversal Document | XREVERSAL_KK | CHAR | 1 | XFELD | ||||
| INVDOC_CRDATE | Creation Date of Invoicing Document | INVDOC_CRDAT_KK | DATS | 8 | DATUM | ||||
| INVDOC_DOCTYPE | Document Type of Invoicing Document | INVDOC_DOCTYPE_KK | CHAR | 2 | DOCTYPE_KK | ||||
| INV_TYPE | Invoicing Type | INV_TYPE_KK | CHAR | 2 | CHAR2 | ||||
| INV_CATEGORY | Invoicing Category | INV_CATEGORY_KK | CHAR | 4 | Assigned to domain | INV_CATEGORY_KK | |||
| INVDOCNO | Number of Invoicing Document | INVDOCNO_KK | NUMC | 12 | Assigned to domain | INVDOCNO_KK | FKKINV_INVDOCNO | ||
| INVPERCAT | Category of Invoicing Period | INVPERCAT_KK | CHAR | 2 | Assigned to domain | INVPERCAT_KK | |||
| INVPERIOD | Invoicing Period | INVPERIOD_KK | DATS | 8 | DATS | ||||
| INVPERIOD_FROM | Start of Invoicing Period | INVPERIOD_FROM_KK | DATS | 8 | DATS | ||||
| SRCDOCCAT | Category of Source Document To Be Invoiced | SRCDOCCAT_KK | CHAR | 5 | SRCDOCCAT_KK | ||||
| SRCDOCNO | Number of Source Document to Be Invoiced | SRCDOCNO_KK | CHAR | 20 | ALPHA | SRCDOCNO_KK | FKKINV_SRCDOCNO | ||
| SRCDOCTYPE | Type of Source Document to Be Invoiced | SRCDOCTYPE_KK | CHAR | 3 | Assigned to domain | SRCDOCTYPE_KK | |||
| BILLDOCNO | Number of Billing Document | BILLDOCNO_KK | NUMC | 12 | Assigned to domain | BILLDOCNO_KK | FKKINV_BILLDOCNO | ||
| BILLDOCITEM | Sequential Number of Document Item | BILLDOCITEM_KK | NUMC | 8 | BILLDOCITEM_KK | ||||
| REVERSALITEM | Reversal Item | REVERSALITEM_KK | CHAR | 1 | XFELD | ||||
| REFDOCNO | Document Number in External System | REFDOCNO_KK | CHAR | 22 | REFDOCNO_KK | ||||
| LOG_SYSTEM | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| SRCPROCESS | Origin Process of Billing Document | SRCPROCESS_KK | NUMC | 4 | Assigned to domain | SRCPROCESS_KK | |||
| DATE_FROM | Start of Period of Line Item | ITEMPERIOD_FROM_KK | DATS | 8 | |||||
| DATE_TO | End of Period of Line Item | ITEMPERIOD_TO_KK | DATS | 8 | |||||
| BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
| SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
| GPART | Business Partner Number | GPART_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | |
| VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
| MDCAT | Type of Master Data for Billing and Invoicing | MDCAT_CI_KK | CHAR | 1 | MDCAT_CI_KK | ||||
| VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | ALPHA | VTREF_KK | VTZ | ||
| SUBAP | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR | 1 | SUBAP_KK | 8SA | |||
| ABWVK | Alternative contract account for collective bills | ABWVK_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | ||
| CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | Assigned to domain | ALPHA | CITY_CODE | ||
| CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | Assigned to domain | ALPHA | CITYP_CODE | ||
| STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | Assigned to domain | ALPHA | STRT_CODE | ||
| COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
| REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
| KOFIZ | Account Determination ID | KOFIZ_KK | CHAR | 2 | KOFIZ_KK | ||||
| HVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 4 | Assigned to domain | HVORG_KK | 8HV | ||
| TVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 4 | Assigned to domain | TVORG_KK | |||
| POSTREL | Posting-Relevant Line Item | POSTREL_KK | CHAR | 1 | XFELD | ||||
| WAERS | Currency Key | WAERS_KK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | ||||
| STRKZ | Tax Code for Other Taxes | STRKZ_KK | CHAR | 2 | Assigned to domain | STRKZ_KK | |||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
| STTAX | Tax Amount as Statistical Information in Document Currency | STTAX_KK | CURR | 13(2) | WRTV7 | ||||
| STAKZ | Type of statistical item | STAKZ_KK | CHAR | 1 | STAKZ_KK | ||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
| HKONT | General Ledger Account | HKONT | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
| GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
| SEGMENT | Segment for Segmental Reporting | SEGMT_KK | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
| KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
| BILLACCOUNT | Billing Account Number | BILLACCOUNT_KK | NUMC | 12 | Assigned to domain | BILLACCOUNT_KK | BILLACCOUNT_ID | ||
| BILLRATECAT | Billing Rate Category | BILLRATECAT_KK | CHAR | 10 | Assigned to domain | BILLRATECAT_KK | |||
| BILLRATE | Billing Rate | BILLRATE_KK | CHAR | 10 | Assigned to domain | BILLRATE_KK | |||
| SRCTATYPE | Source Transaction Type | SRCTATYPE_KK | CHAR | 5 | Assigned to domain | SRCTATYPE_KK | |||
| SRCTAID | Source Transaction ID | SRCTAID_KK | CHAR | 22 | ALPHA | SRCTAID_KK | |||
| BITPACKUUID | GUID of Package of Billable Items | BITPACKUUID_KK | RAW | 16 | GUID16 | ||||
| BITPACKCNO | Sequence Number of Billable Item in Package | BITPACKCNO_KK | NUMC | 8 | NUMC8 | ||||
| BITCAT | Billable Item Class | BITCAT_KK | CHAR | 4 | Assigned to domain | BITCAT_KK | FKK_BIX_BITCAT | ||
| SUBPROCESS | Subprocess of Billing | SUB_PROCESS_KK | CHAR | 4 | Assigned to domain | SUB_PROCESS_KK | |||
| BITTYPE | Type of Billable Item | BITTYPE_KK | CHAR | 4 | Assigned to domain | BITTYPE_KK | |||
| BIT_AMOUNT | Amount of Billable Item | BIT_AMOUNT_KK | CURR | 13(2) | WRTV7 | ||||
| BIT_CURR | Currency of Billable Item | BIT_CURR_KK | CUKY | 5 | Assigned to domain | WAERS | |||
| BIT_QUANTITY | Billing Quanitiy of Billable Item | BIT_QUANTITY_KK | QUAN | 31(14) | |||||
| BIT_QTY_UNIT | Unit for the Billing Quantity of Billable Items | BIT_QTY_UNIT_KK | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| UPDMOD | BW Delta Procedure: Update Mode | BWUPDMOD_KK | CHAR | 1 | BWUPDMOD_KK |
| Key field | Non-key field |
How do I retrieve data from SAP structure FKKINV_BW_EXTRACT00 using ABAP code?
As FKKINV_BW_EXTRACT00 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 FKKINV_BW_EXTRACT00 as there is no data to select.How to access SAP table FKKINV_BW_EXTRACT00
Within an ECC or HANA version of SAP you can also view further information about FKKINV_BW_EXTRACT00 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects