TFICA_DEF SAP (Samples for Contract Account Types) Table details
Dictionary Type: Table
Description: Samples for Contract Account Types
Description: Samples for Contract Account Types
Table field list including key, data, relationships and ABAP select examples
TFICA_DEF is a standard SAP Table which is used to store Samples for Contract Account Types data and is available within R/3 SAP systems depending on the version and release level.
The TFICA_DEF table consists of various fields, each holding specific information or linking keys about Samples for Contract Account Types data available in SAP. These include VKTYP (Contract Account Category), APPLK (Application area), VKONA (Contract account number in legacy system), VKBEZ (Contract account name).. 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TFICA_DEF table 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 | ||||
| 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 | Assigned to domain | 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 | Assigned to domain | 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 | Assigned to domain | QSSKZ | |||
| QSSKZ_E | Withholding Tax Code For Incoming Payments | QSSKZ_E_KK | CHAR | 2 | Assigned to domain | 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 | Assigned to domain | 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 | Assigned to domain | WFCID | FCI | ||
| XFIX_EZAWE | Apply Manual Setting for Incoming Payment Method | XFIX_EZAWE_PS | CHAR | 1 | BOOLE | ||||
| XFIX_AZAWE | Apply Manual Setting for Outgoing Payment Method | XFIX_AZAWE_PS | CHAR | 1 | BOOLE | ||||
| XFIX_OP_LOCK | Apply Manual Setting for Lock Reason for Outgoing Payment | XFIX_OP_LOCK_PS | CHAR | 1 | BOOLE | ||||
| XFIX_IKEY | Apply Manual Setting for Interest Key | XFIX_IKEY_PS | CHAR | 1 | BOOLE | ||||
| XFIX_TOGRU | Apply Manual Setting for Tolerance Group | XFIX_TOGRU_PS | CHAR | 1 | BOOLE | ||||
| XFIX_VERTYP | Apply Manual Setting for Clearing Category | XFIX_VERTYP_PS | CHAR | 1 | BOOLE | ||||
| XFIX_MAHNV | Apply Manual Setting for Dunning Procedure | XFIX_MAHNV_PS | CHAR | 1 | BOOLE | ||||
| XFIX_COPRC | Apply Manual Setting for Correspondence Variant | XFIX_COPRC_PS | CHAR | 1 | BOOLE | ||||
| XFIX_CORR_MAHNV | Apply Manual Setting for Correspondence Dunning Procedure | XFIX_CORR_MAHNV_PS | CHAR | 1 | BOOLE | ||||
| XNO_AUTO_UPDATE | Deactivate Automatic Update of Student Account Entirely | PIQSTUPD_NO_AUTOUPDATE | CHAR | 1 | BOOLE |
| Key field | Non-key field |
How do I retrieve data from SAP table TFICA_DEF using ABAP code
The following ABAP code Example will allow you to do a basic selection on TFICA_DEF to SELECT all data from the tableDATA: WA_TFICA_DEF TYPE TFICA_DEF.
SELECT SINGLE *
FROM TFICA_DEF
INTO CORRESPONDING FIELDS OF WA_TFICA_DEF
WHERE...
How to access SAP table TFICA_DEF
Within an ECC or HANA version of SAP you can also view further information about 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