V_TFICA_DEF SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
V_TFICA_DEF is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The V_TFICA_DEF table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include VKTYP (Contract Account Category), APPLK (Application area), TEXT (Description of Contract Account Category), VKONA (Contract account number in legacy system).. 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: Not classified
SAP V_TFICA_DEF table view 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VKTYP | Contract Account Category | VKTYP_KK | CHAR | 2 | TFK002A | VKTYP_KK | KTP | ||
APPLK | Application area | APPLK_KK | CHAR | 1 | APPLK_KK | ||||
TEXT | Description of Contract Account Category | VKTYP_TXT_KK | CHAR | 50 | TEXT50 | ||||
VKONA | Contract account number in legacy system | VKONA_KK | CHAR | 20 | CHAR20 | ||||
VKBEZ | Contract account name | VKBEZ_KK | CHAR | 35 | TEXT35 | ||||
EXVKO | Reference number for business partner | EXVKO_KK | CHAR | 25 | CHAR25 | ||||
OPBUK | Company Code Group | OPBUK_KK | CHAR | 4 | TFK001G | OPBUK_KK | OPBUK | ||
STDBK | Standard Company Code | STDBK_KK | CHAR | 4 | BUKRS | ||||
ABWRE | Alternative Payer | ABWRE_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
ABWRA | Alternative Payee | ABWRA_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
ABWMA | Alternative dunning recipient | ABWMA_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
EBVTY | Bank Details ID for Incoming Payments | EBVTY_KK | CHAR | 4 | CHAR4 | ||||
ABVTY | Bank Details ID for Outgoing Payments | ABVTY_KK | CHAR | 4 | CHAR4 | ||||
EZAWE | Incoming Payment Method | EZAWE_KK | CHAR | 1 | CHAR1 | ||||
AZAWE | Outgoing Payment Methods | AZAWE_KK | CHAR | 5 | CHAR5 | ||||
VWNZA | Create Where-Used List For Line Items | VWNZA_KK | CHAR | 1 | VWNZA_KK | ||||
LOEVM | Mark Contract Account for Deletion | LOEVM_KK | CHAR | 1 | LOEVM_KK | ||||
ABWVK | Alternative contract account for collective bills | ABWVK_KK | CHAR | 12 | FKKVK | ALPHA | VKONT_KK | ||
IKEY | Interest Key | IKEY_KK | CHAR | 2 | TFK056A | IKEY_KK | |||
MAHNV | Dunning Procedure | MAHNV_KK | CHAR | 2 | TFK047A | MAHNV_KK | FKK_MAHNV | ||
MGRUP | Grouping fur Dunning Notices | MGRUP_KK | CHAR | 2 | TFK047F | MGRUP_KK | |||
FDGRP | Planning Group | FDGRP_KK | CHAR | 10 | T035 | ALPHA | FDGRP | FFG | |
FDZTG | Additional Days for Cash Management | FDZTG_KK | NUMC | 2 | NUM2 | ||||
VKPBZ | Relationship of Business Partner to Contract Account | VKPBZ_KK | CHAR | 2 | TFK002F | VKPBZ_KK | |||
VKONV | Contract account used for payment transactions | VKONV_KK | CHAR | 12 | FKKVK | ALPHA | VKONT_KK | ||
GPARV | Business Partner Acting as Payer in Payment Transactions | GPARV_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | ||
ABWRH | Alternative Invoice Recipient | ABWRH_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
TOGRU | Tolerance group for contract account | TOGRU_KK | CHAR | 4 | TFK043 | TOGRU_KK | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
COPRC | Correspondence Variant | COPRC_KK | CHAR | 4 | TFK070B | COPRC_KK | |||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | ALPHA | RCOMP | PGS | ||
CCARD_ID | Payment Card ID for Incoming Payments | CCID_IN_KK | CHAR | 6 | CHAR6 | ||||
CCARD_OUT | Payment Card ID for Outgoing Payments | CCID_OUT_KK | CHAR | 6 | CHAR6 | ||||
UEBTR | Items Transferred To Another Account | XUEBTR_KK | CHAR | 1 | XFELD | ||||
DEF_REC | Alternative Correspondence Recipient for Standard Case | DEF_CORR_PARTNER_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
DEF_REC_IND | FI-CA correspondence - activity key | DEF_CORR_ACKEY_KK | CHAR | 4 | TFK070L | CORR_ACKEY_KK | |||
QSSKZ_A | Witholding Tax Code For Outgoing Payments | QSSKZ_A_KK | CHAR | 2 | QSSKZ | ||||
QSSKZ_E | Withholding Tax Code For Incoming Payments | QSSKZ_E_KK | CHAR | 2 | QSSKZ | ||||
QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10 | CHAR10 | ||||
QSZDT | Withholding tax exemption cert. valid-until date(YYYYMMDD) | QSZDT_DI_KK | CHAR | 8 | CHAR8 | ||||
CORR_MAHNV | Correspondence Dunning Procedure | CORR_MAHNV_KK | CHAR | 2 | MAHNV_KK | ||||
FITYP | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITPV | J_1AFITP | |||
PROVINCE | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
COUNTY | County Code | COUNC | CHAR | 3 | T005E | COUNC | |||
VERTYP | Clearing Category For Clearing Postings | VERTYP_KK | CHAR | 4 | TFK111 | VERTYP_KK | |||
AUGRS_DEF | Clearing Restriction | AUGRS_DEF_KK | CHAR | 1 | AUGRS_DEF_KK | ||||
LANDL | Country Supplied (for Tax Notifications) | LANDL_KK | CHAR | 3 | T005 | LAND1 | |||
BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | J_1BBRANCH | |||
BPTAXTYPE1 | Tax Number Type 1 for Business Partner | BPTAXTYPE1 | CHAR | 4 | BPTAXTYPE | ||||
BPTAXTYPE2 | Tax Number type 2 for Business Partner | BPTAXTYPE2 | CHAR | 4 | BPTAXTYPE | ||||
INV_CATEGORY | Invoicing Category | INV_CATEGORY_KK | CHAR | 4 | TFK2604 | INV_CATEGORY_KK | |||
INVTP | Invoice Type | INVTP_PS | CHAR | 2 | INVTP_PS | FMCA_INVTP | |||
FCALID | Factory Calendar | WFCID | CHAR | 2 | WFCID | FCI |
Key field | Non-key field |
How do I retrieve data from SAP table V_TFICA_DEF using ABAP code
The following ABAP code Example will allow you to do a basic selection on V_TFICA_DEF to SELECT all data from the tableDATA: WA_V_TFICA_DEF TYPE V_TFICA_DEF.
SELECT SINGLE *
FROM V_TFICA_DEF
INTO CORRESPONDING FIELDS OF WA_V_TFICA_DEF
WHERE...
How to access SAP table V_TFICA_DEF
Within an ECC or HANA version of SAP you can also view further information about V_TFICA_DEF 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