FKKVKP SAP (Contract Account Partner-Specific) Table details
Dictionary Type: Table
Description: Contract Account Partner-Specific
Description: Contract Account Partner-Specific
Table field list including key, data, relationships and ABAP select examples
FKKVKP is a standard SAP Table which is used to store Contract Account Partner-Specific data and is available within R/3 SAP systems depending on the version and release level.
The FKKVKP table consists of various fields, each holding specific information or linking keys about Contract Account Partner-Specific data available in SAP. These include VKONT (Contract Account Number), GPART (Business Partner Number), VKBEZ (Contract account name), ERDAT (Date on Which Record Was Created).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FKKVKP 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 | |||
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | FKKVK | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
GPART | Business Partner Number | GPART_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | |
VKBEZ | Contract account name | VKBEZ_KK | CHAR | 35 | TEXT35 | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDATP | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAMP | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
FDZTG | Additional Days for Cash Management | FDZTG_KK | NUMC | 2 | NUM2 | ||||
STOPD | Processing lock until | STOPD_KK | DATS | 8 | STOPD_KK | ||||
QSZDT | Validity Date for Withholding Tax Exemption Certificate | QSZDT | DATS | 8 | DATUM | ||||
GUID | Business Agreement GUID | BUAG_GUID | RAW | 16 | SYSUUID | ||||
DDLAM | Direct Debit Limit | DDLAM_KK | CURR | 13(2) | WRTV7 | ||||
DDLCU | Currency of Direct Debit Limit | DDLCU_KK | CUKY | 5 | TCURC | WAERS | |||
DDLNM | Number of Months for Calculation of Direct Debit Limit | DDLNM_KK | NUMC | 2 | NUM02 | ||||
INV_CYCLE_START | Start Date of Billing Cycle in Contract Account | CYCLE_STARTDATE_KK | DATS | 8 | DATS | ||||
INV_CHGDISC_X | Int: Charges and Discounts Exist for BP-CrtAcct Relations | CHGDISC_X_KK | CHAR | 1 | XFELD | ||||
BPL_XPOCL | Business Partner Lock for Postings/Clearing | BPL_XPOCL_KK | CHAR | 1 | BPL_XPOCL_KK | ||||
BPL_FDATE | Lock valid from | FDATE_KK | DATS | 8 | DATUM | ||||
BPL_TDATE | Lock valid to | TDATE_KK | DATS | 8 | DATUM | ||||
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 | ||||
EZASP | Lock Reason for Incoming Payments | EZASP_OLD_KK | CHAR | 1 | TFK008 | SPZAH_KK | |||
AZAWE | Outgoing Payment Methods | AZAWE_KK | CHAR | 5 | CHAR5 | ||||
AZASP | Lock Reason for Outgoing Payments | AZASP_OLD_KK | CHAR | 1 | TFK008 | SPZAH_KK | |||
EIGBV | Own Bank Details | EIGBV_KK | CHAR | 25 | Assigned to domain | EIGBV_KK | |||
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 | ||
MANSP | Dunning Lock Reason | MANSP_OLD_KK | CHAR | 1 | TFK047S | MANSP_KK | |||
MGRUP | Grouping fur Dunning Notices | MGRUP_KK | CHAR | 2 | TFK047F | MGRUP_KK | |||
FDGRP | Planning Group | FDGRP_KK | CHAR | 10 | T035 | ALPHA | FDGRP | FFG | |
VKPBZ | Relationship of Business Partner to Contract Account | VKPBZ_KK | CHAR | 2 | TFK002F | VKPBZ_KK | |||
ADRNB | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
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 | ||
ADRRE | Address Number for Alternative Payer | ADRRE_KK | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
ADRRA | Address Number for Alternative Payee | ADRRA_KK | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
ADRMA | Address number for alternative dunning notice recipient | ADRMA_KK | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
ABWRH | Alternative Invoice Recipient | ABWRH_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
ADRRH | Address number for alternative bill recipient | ADRRH_KK | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
ADRJDC | Address Number for Jurisdiction Code Address | ADRJDC_KK | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
TOGRU | Tolerance group for contract account | TOGRU_KK | CHAR | 4 | TFK043 | TOGRU_KK | |||
STOPG | Reason for Processing Lock | STOPG_KK | CHAR | 1 | TFK001S | STOPG_KK | |||
TXJCD | Jurisdiction for Tax Calculation - Tax Jurisdiction Code | TXJCD_NOCD_KK | CHAR | 15 | Assigned to domain | 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 | ||||
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 | ||||
PERSR | Clerk Responsible | PERSR_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
INV_CATEGORY | Invoicing Category | INV_CATEGORY_KK | CHAR | 4 | TFK2604 | INV_CATEGORY_KK | |||
DDLXG | Rolling Calculation of Direct Debit Limit | DDLXG_KK | CHAR | 1 | XFELD | ||||
CMGRP | Collection Management: Master Data Group | CMGRP_CM_KK | CHAR | 2 | Assigned to domain | CMGRP_CM_KK | |||
STRAT | Collection Strategy | STRAT_CM_KK | CHAR | 2 | Assigned to domain | STRAT_CM_KK | |||
CPERS | Collections Contact Person | CPERS_CM_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | |
BPCL_SUCC | Duplicate Processing: Predecessor/Successor Business Partner | BPCL_SUCC_KK | CHAR | 1 | BPCL_SUCC_KK | ||||
INV_SCHEDULE | Selection Characteristic for Scheduling | INV_SCHEDULE_KK | CHAR | 4 | TFK2606 | INV_SCHEDULE_KK | |||
INV_CYCLE | Billing Cycle | CYCLE_KK | CHAR | 4 | TFK2607 | CYCLE_KK | |||
INV_CYCLE_RULE | Field Is Not Used - CHAR4 | CYCLE_RULE_KK | CHAR | 4 | |||||
INV_CYCLE_DAY | Day of Period End | CYCLE_DAY_KK | CHAR | 2 | CYCLE_DAY_KK | ||||
INV_CYCLE_MONTH | Field Is Not Used - CHAR2 | NOT_USED_CHAR2_KK | CHAR | 2 | |||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 |
Key field | Non-key field |
How do I retrieve data from SAP table FKKVKP using ABAP code
The following ABAP code Example will allow you to do a basic selection on FKKVKP to SELECT all data from the tableDATA: WA_FKKVKP TYPE FKKVKP.
SELECT SINGLE *
FROM FKKVKP
INTO CORRESPONDING FIELDS OF WA_FKKVKP
WHERE...
How to access SAP table FKKVKP
Within an ECC or HANA version of SAP you can also view further information about FKKVKP 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