VFKK_INV_ACTIVE_S SAP (FI-CA (Dist. Systems) Invoicing Active for VBELN) Structure details
Description: FI-CA (Dist. Systems) Invoicing Active for VBELN
Related tables to VFKK_INV_ACTIVE_S
Access table VFKK_INV_ACTIVE_S
Structure field list including key, data, relationships and ABAP select examples
VFKK_INV_ACTIVE_S 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 "FI-CA (Dist. Systems) Invoicing Active for VBELN" 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_VFKK_INV_ACTIVE_S TYPE VFKK_INV_ACTIVE_S.
The VFKK_INV_ACTIVE_S table consists of various fields, each holding specific information or linking keys about FI-CA (Dist. Systems) Invoicing Active for VBELN data available in SAP. These include XFCIN (Transfer SD Billing Document to Invoicing in FI-CA), SUBSET (Defines subset of components for the FI/CO interface), VBRK (), MANDT (Client).. 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 VFKK_INV_ACTIVE_S 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 |
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
XFCIN | Transfer SD Billing Document to Invoicing in FI-CA | XFCIN_VFKK | CHAR | 1 | XFELD | ||||
SUBSET | Defines subset of components for the FI/CO interface | ACC_SUBSET | CHAR | 4 | ACC_SUBSET | ||||
VBRK | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
VBELN | Billing Document | VBELN_VF | CHAR | 10 | ALPHA | VBELN | VF | ||
FKART | Billing Type | FKART | CHAR | 4 | FKART | ||||
FKTYP | Billing category | FKTYP | CHAR | 1 | FKTYP | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | WAERS | FWS | |||
VKORG | Sales Organization | VKORG | CHAR | 4 | VKORG | VKO | C_VKORG | ||
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | VTWEG | VTW | C_VTWEG | ||
KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | KALSM | ||||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | VSBED | ||||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
KONDA | Price group (customer) | KONDA | CHAR | 2 | KONDA | VKA | |||
KDGRP | Customer group | KDGRP | CHAR | 2 | KDGRP | VKD | |||
BZIRK | Sales district | BZIRK | CHAR | 6 | BZIRK | BZI | |||
PLTYP | Price list type | PLTYP | CHAR | 2 | PLTYP | VPL | |||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | INCO1 | ||||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
EXPKZ | Export indicator | EXPKZ | CHAR | 1 | EXPKZ | ||||
RFBSK | Status for transfer to accounting | RFBSK | CHAR | 1 | RFBSK | ||||
MRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | XFELD | ||||
KURRF | Exchange rate for FI postings | KURRF | DEC | 9(5) | KURRF | ||||
CPKUR | ID:Exchange rate setting (no new rate determ.in bill.doc.) | CPKUR | CHAR | 1 | CPKUR | ||||
VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | ZLSCH | ||||
KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | KTGRD | ||||
LAND1 | Country of Destination | LLAND | CHAR | 3 | LAND1 | VLL | |||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
COUNC | County Code | COUNC | CHAR | 3 | COUNC | ||||
CITYC | City Code | CITYC | CHAR | 4 | CITYC | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
TAXK1 | Tax classification 1 for customer | TAXK1 | CHAR | 1 | TAXKD | ||||
TAXK2 | Tax classification 2 for customer | TAXK2 | CHAR | 1 | TAXKD | ||||
TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1 | TAXKD | ||||
TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | TAXKD | ||||
TAXK5 | Tax classification 5 for customer | TAXK5 | CHAR | 1 | TAXKD | ||||
TAXK6 | Tax classification 6 for customer | TAXK6 | CHAR | 1 | TAXKD | ||||
TAXK7 | Tax classification 7 for customer | TAXK7 | CHAR | 1 | TAXKD | ||||
TAXK8 | Tax classification 8 for customer | TAXK8 | CHAR | 1 | TAXKD | ||||
TAXK9 | Tax classification 9 for customer | TAXK9 | CHAR | 1 | TAXKD | ||||
NETWR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
ZUKRI | Combination criteria in the billing document | DZUKRI | CHAR | 40 | CHAR40 | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | ALPHA | STAFO | MCF | ||
KUNRG | Payer | KUNRG | CHAR | 10 | ALPHA | KUNNR | |||
KUNAG | Sold-to party | KUNAG | CHAR | 10 | ALPHA | KUNNR | VAG | ||
MABER | Dunning Area | MABER | CHAR | 2 | MABER | ||||
STWAE | Statistics currency | STWAE | CUKY | 5 | WAERS | ||||
EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | EXNUM | ||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
SFAKN | Cancelled billing document number | SFAKN | CHAR | 10 | ALPHA | VBELN | VF | ||
KNUMA | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | ALPHA | KNUMA | VMBO | ||
FKART_RL | Invoice list type | FKART_RL | CHAR | 4 | FKART | ||||
FKDAT_RL | Billing date for the invoice list | FKDAT_RL | DATS | 8 | DATUM | ||||
KURST | Exchange Rate Type | KURST | CHAR | 4 | KURST | KUT | |||
MSCHL | Dunning key | MSCHL | CHAR | 1 | MSCHL | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | MANSP | ||||
SPART | Division | SPART | CHAR | 2 | SPART | SPA | C_SPART | ||
KKBER | Credit control area | KKBER | CHAR | 4 | KKBER | KKB | |||
KNKLI | Customer's account number with credit limit reference | KNKLI | CHAR | 10 | ALPHA | KUNNR | |||
CMWAE | Currency key of credit control area | WAERS_CM | CUKY | 5 | WAERS | ||||
CMKUF | Credit data exchange rate at billing document rate | CMKUF | DEC | 9(5) | KURRF | ||||
HITYP_PR | Hierarchy type for pricing | HITYP_PR | CHAR | 1 | HITYP | ||||
BSTNK_VF | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | ALPHA | RCOMP | PGS | ||
FKART_AB | Accrual billing type | FKART_AB | CHAR | 4 | FKART | ||||
KAPPL | Application | KAPPL | CHAR | 2 | KAPPL | KAP | |||
LANDTX | Tax departure country | LANDTX | CHAR | 3 | LAND1 | LND | |||
STCEG_H | Origin of sales tax ID number | STCEG_H | CHAR | 1 | STCEG_H | ||||
STCEG_L | Country of Sales Tax ID Number | STCEG_L | CHAR | 3 | LAND1 | LND | |||
XBLNR | Reference Document Number | XBLNR_V1 | CHAR | 16 | XBLNR1 | ||||
ZUONR | Assignment number | ORDNR_V | CHAR | 18 | ZUONR | ||||
MWSBK | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
FKSTO | Billing document is cancelled | FKSTO | CHAR | 1 | XFELD | ||||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
RPLNR | Number of payment card plan type | RPLNR | CHAR | 10 | FPLNR | ||||
LCNUM | Financial doc. processing: Internal financial doc. number | LCNUM | CHAR | 10 | ALPHA | LCNUM | AKN | ||
J_1AFITP | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITP | ||||
KURRF_DAT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
AKWAE | Currency key for letter-of-credit procg in foreign trade | AKWAE | CUKY | 5 | WAERS | FWS | |||
AKKUR | Exchange rate for letter-of-credit procg in foreign trade | AKKUR | DEC | 9(5) | KURRF | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
NUMPG | Number of pages of invoice | J_1ANOPG | NUMC | 3 | J_1ANOPG | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | ||||
VKONT | Contract Account Number | CORR_VKONT_KK | CHAR | 12 | ALPHA | CORR_VKONT_KK | |||
FKK_DOCSTAT | Additional Status Transfer to Fin. Accounting (Res. RFBSK) | DOCSTAT_KK | CHAR | 1 | DOCSTAT_KK | ||||
NRZAS | Character Field of Length 12 | CHAR12 | CHAR | 12 | CHAR12 | ||||
SPE_BILLING_IND | EWM Billing Indicator | /SPE/DE_BILLING_IND | CHAR | 1 | /SPE/DE_BILLING_IND | ||||
VTREF | Reference Specifications from Contract | CORR_VTREF_KK | CHAR | 20 | ALPHA | CORR_VTREF_KK | |||
FK_SOURCE_SYS | Source System | FK_SOURCE_SYS | CHAR | 10 | ALPHA | LOGSYS | |||
FKTYP_CRM | Billing Category in CRM | FKTYP_CRM | CHAR | 1 | FKTYP | ||||
STGRD | Reason for Reversal | STGRD | CHAR | 2 | STGRD | FSG | |||
VBTYP_EXT | Extension of SD Document Category | TDD_VBTYP_EXT | CHAR | 4 | DOM_VBTYP_EXT | ||||
.INCLU--AP | 0 | ||||||||
DPC_REL | Flag: DPC relevant | /SAPPCE/DPC_REL | CHAR | 1 | CHAR01 | ||||
.INCLU--AP | 0 | ||||||||
AD01BASDOC | Initial document | AD01BASDOC | CHAR | 10 | ALPHA | VBELN | |||
AD01FAREG | Rule for billing | AD01FAREG | CHAR | 1 | AD01FAREG | ||||
.INCLU--AP | 0 | ||||||||
VCHRNMBR | Voucher Number | AD04VCHNR | NUMC | 8 | AD04VCHNR | ||||
.INCLU--AP | 0 | ||||||||
SWENR | Business Entity Number | HB_SWENR | CHAR | 8 | SWENR | SWENR | WEH | ||
SMENR | Number of Sales Unit | HB_SMENR | CHAR | 8 | SMENR | SMENR | MEH | ||
PHASE | Sales Phase | HB_SPHSE | CHAR | 11 | HBS_PHASE | ||||
MTLAUR | Marker for Low Income Housing | HB_MTLAUR | CHAR | 1 | HBS_MTLAUR | ||||
STAGE | Construction Stage | HB_STAGE | INT4 | 10 | INT4 | ||||
HB_CONT_REASON | Contingency data | HB_CONT | CHAR | 2 | CHAR2 | ||||
HB_EXPDATE | Expiration date | HB_EXP | DATS | 8 | DATS | ||||
HB_RESDATE | Resolution date | HB_RES | DATS | 8 | DATS | ||||
.INCLU--AP | 0 | ||||||||
J_3GKBAUL | ETM-Relevant Indicator | J_3GKBAUL | CHAR | 1 | J_3GKBAUL | ||||
J_3GKENIE | Indicator for I(nternal) or E(xternal) Posting | J_3GKENIE | CHAR | 1 | J_3GKENIE | ||||
KUNWE | Ship-to party | KUNWE | CHAR | 10 | ALPHA | KUNNR | |||
.INCLU--AP | 0 | ||||||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
PAY_TYPE | SEPA: Transaction Type | SEPA_PAY_TYPE | CHAR | 1 | SEPA_PAY_TYPE | ||||
SEPON | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | SD_SEPA_FLAG | ||||
MNDVG | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | SD_SEPA_FLAG | ||||
.INCLU--AP | 0 | ||||||||
SPPAYM | Payment Form for Special Payment Method | SPPAYM | CHAR | 2 | SPPAYM | ||||
SPPORD | Sales Order for Special Payment Method | SPPORD | CHAR | 10 | ALPHA | VBELN | |||
.INCLU--AP | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure VFKK_INV_ACTIVE_S using ABAP code?
As VFKK_INV_ACTIVE_S 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 VFKK_INV_ACTIVE_S as there is no data to select.How to access SAP table VFKK_INV_ACTIVE_S
Within an ECC or HANA version of SAP you can also view further information about VFKK_INV_ACTIVE_S 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