SAP table FKKVKP (Contract Account Partner-Specific)

SAP table FKKVKP has 3 primary key fields being MANDT,VKONT,GPART.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VKONT Contract Account Number CHAR 12 0 FKKVK VKONT_KK
GPART Business Partner Number CHAR 10 0 BUT000 GPART_KK
VKBEZ Contract account name CHAR 35 0 VKBEZ_KK
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDATP Last Changed On DATS 8 0 AEDAT
AENAMP Name of Person Who Changed Object CHAR 12 0 AENAM
FDZTG Additional Days for Cash Management NUMC 2 0 FDZTG_KK
STOPD Processing lock until DATS 8 0 STOPD_KK
QSZDT Validity Date for Withholding Tax Exemption Certificate DATS 8 0 QSZDT
GUID Business Agreement GUID RAW 16 0 BUAG_GUID
DDLAM Direct Debit Limit CURR 13 2 DDLAM_KK
DDLCU Currency of Direct Debit Limit CUKY 5 0 TCURC DDLCU_KK
DDLNM Number of Months for Calculation of Direct Debit Limit NUMC 2 0 DDLNM_KK
INV_CYCLE_START Start Date of First Billing Period DATS 8 0 CYCLE_STARTDATE_KK
INV_CHGDISC_X Int: Charges and Discounts Exist for BP-CrtAcct Relations CHAR 1 0 CHGDISC_X_KK
BPL_XPOCL Business Partner Lock for Postings/Clearing CHAR 1 0 BPL_XPOCL_KK
No Lock
1 Posting Lock Only
2 Clearing Lock Only
3 Posting and Clearing Lock
BPL_XADDL Business Partner Lock for Dunning / Payment CHAR 1 0 BPL_XADDL_KK
No Lock
1 Dunning Lock
2 Incoming Payment Lock
3 Outgoing Payment Lock
A Dunning Lock / Incoming Payment Lock / Outgoing Payment Lock
B Dunnning Lock / Outgoing Payment Lock
C Dunning Lock / Outgoing Payment Lock
D Incoming Payment Lock / Outgoing Payment Lock
BPL_FDATE Lock valid from DATS 8 0 FDATE_KK
BPL_TDATE Lock valid to DATS 8 0 TDATE_KK
INV_CURR Target Currency of Invoicing CUKY 5 0 TCURC INV_CURR_KK
EXVKO Reference number for business partner CHAR 25 0 EXVKO_KK
OPBUK Company Code Group CHAR 4 0 TFK001G OPBUK_KK
STDBK Standard Company Code CHAR 4 0 * STDBK_KK
ABWRE Alternative Payer CHAR 10 0 BUT000 ABWRE_KK
ABWRA Alternative Payee CHAR 10 0 BUT000 ABWRA_KK
ABWMA Alternative Dunning Recipient CHAR 10 0 BUT000 ABWMA_KK
EBVTY Bank Details ID for Incoming Payments CHAR 4 0 EBVTY_KK
ABVTY Bank Details ID for Outgoing Payments CHAR 4 0 ABVTY_KK
EZAWE Incoming Payment Method CHAR 1 0 EZAWE_KK
EZASP Lock Reason for Incoming Payments CHAR 1 0 TFK008 EZASP_OLD_KK
AZAWE Outgoing Payment Methods CHAR 5 0 AZAWE_KK
AZASP Lock Reason for Outgoing Payments CHAR 1 0 TFK008 AZASP_OLD_KK
EIGBV Own Bank Details CHAR 25 0 * EIGBV_KK
VWNZA Create Where-Used List For Line Items CHAR 1 0 VWNZA_KK
no listing of line items
X line items listed
LOEVM Mark Contract Account for Deletion CHAR 1 0 LOEVM_KK
ABWVK Alternative Contract Account for Collective Bills CHAR 12 0 FKKVK ABWVK_KK
IKEY Interest Key CHAR 2 0 TFK056A IKEY_KK
MAHNV Dunning Procedure CHAR 2 0 TFK047A MAHNV_KK
MANSP Dunning Lock Reason CHAR 1 0 TFK047S MANSP_OLD_KK
MGRUP Grouping fur Dunning Notices CHAR 2 0 TFK047F MGRUP_KK
FDGRP Planning Group CHAR 10 0 T035 FDGRP_KK
VKPBZ Relationship of Business Partner to Contract Account CHAR 2 0 TFK002F VKPBZ_KK
ADRNB Address Number CHAR 10 0 * AD_ADDRNUM
VKONV Contract account used for payment transactions CHAR 12 0 FKKVK VKONV_KK
GPARV BP Acting as Payer/Payee in Payment Transactions CHAR 10 0 BUT000 GPARV_KK
ADRRE Address Number for Alternative Payer CHAR 10 0 * ADRRE_KK
ADRRA Address Number for Alternative Payee CHAR 10 0 * ADRRA_KK
ADRMA Address number for alternative dunning notice recipient CHAR 10 0 * ADRMA_KK
ABWRH Alternative Invoice Recipient CHAR 10 0 BUT000 ABWRH_KK
ADRRH Address number for alternative bill recipient CHAR 10 0 * ADRRH_KK
ADRJDC Address Number for Jurisdiction Code Address CHAR 10 0 * ADRJDC_KK
BEGRU Authorization Group CHAR 4 0 TFK_BEGRU BEGRU
TOGRU Tolerance group for contract account CHAR 4 0 TFK043 TOGRU_KK
STOPG Reason for Processing Lock CHAR 1 0 TFK001S STOPG_KK
TXJCD Jurisdiction for Tax Calculation - Tax Jurisdiction Code CHAR 15 0 * TXJCD_NOCD_KK
COPRC Correspondence Variant CHAR 4 0 TFK070B COPRC_KK
VBUND Company ID of Trading Partner CHAR 6 0 * RASSC
CCARD_ID Payment Card ID for Incoming Payments CHAR 6 0 CCID_IN_KK
CCARD_OUT Payment Card ID for Outgoing Payments CHAR 6 0 CCID_OUT_KK
UEBTR Items Transferred To Another Account CHAR 1 0 XUEBTR_KK
DEF_REC Alternative Correspondence Recipient for Standard Case CHAR 10 0 BUT000 DEF_CORR_PARTNER_KK
DEF_REC_IND FI-CA correspondence - activity key CHAR 4 0 TFK070L DEF_CORR_ACKEY_KK
DEF_REC_ADRNR Standard Address No. of Alternative Correspondence Recipient CHAR 10 0 * ADRNR_CORR_DEF_KK
QSSKZ_A Witholding Tax Code For Outgoing Payments CHAR 2 0 T059Q QSSKZ_A_KK
QSSKZ_E Withholding Tax Code For Incoming Payments CHAR 2 0 T059Q QSSKZ_E_KK
QSZNR Certificate Number of the Withholding Tax Exemption CHAR 10 0 QSZNR
CORR_MAHNV Correspondence Dunning Procedure CHAR 2 0 * CORR_MAHNV_KK
FITYP Tax type CHAR 2 0 J_1AFITPV J_1AFITP_D
PROVINCE Region (State, Province, County) CHAR 3 0 T005S REGIO
COUNTY County Code CHAR 3 0 T005E COUNC
VERTYP Clearing Category For Clearing Postings CHAR 4 0 TFK111 VERTYP_KK
AUGRS_DEF Clearing Restriction CHAR 1 0 AUGRS_DEF_KK
D Deposit: Can only be cleared with open item clearing
LANDL Destination Country/Region (for Tax Reports) CHAR 3 0 T005 LANDL_KK
BUPLA Business Place CHAR 4 0 J_1BBRANCH BUPLA
BPTAXTYPE1 Tax Number Type 1 for Business Partner CHAR 4 0 BPTAXTYPE1
BPTAXTYPE2 Tax Number type 2 for Business Partner CHAR 4 0 BPTAXTYPE2
PERSR Clerk Responsible CHAR 10 0 BUT000 PERSR_KK
INV_CATEGORY Invoicing Category CHAR 4 0 TFK2604 INV_CATEGORY_KK
DDLXG Rolling Calculation of Direct Debit Limit CHAR 1 0 DDLXG_KK
CMGRP Collection Management: Master Data Group CHAR 2 0 TFK041B CMGRP_CM_KK
STRAT Collection Strategy CHAR 2 0 TFK047X STRAT_CM_KK
CPERS Collections Contact Person CHAR 10 0 BUT000 CPERS_CM_KK
BPCL_SUCC Duplicate Processing: Predecessor/Successor Business Partner CHAR 1 0 BPCL_SUCC_KK
No Relationship Exists
1 Predecessor
2 Successor
3 Predecessor and Successor
INV_SCHEDULE Selection Characteristic for Scheduling CHAR 4 0 TFK2606 INV_SCHEDULE_KK
INV_CYCLE Billing Cycle CHAR 4 0 TFK2607 CYCLE_KK
INV_CYCLE_RULE Field Is Not Used - CHAR4 CHAR 4 0 CYCLE_RULE_KK
INV_CYCLE_DAY Day of Period End CHAR 2 0 CYCLE_DAY_KK
Defaulted Using Billing Cycle
01 1st Day of Month
02 2nd Day of Month
03 3rd Day of Month
04 4th Day of Month
05 5th Day of Month
06 6th Day of Month
07 7th Day of Month
08 8th Day of Month
09 9th Day of Month
10 10th Day of Month
11 11th Day of Month
12 12th Day of Month
13 13th Day of Month
14 14th Day of Month
15 15th Day of Month
16 16th Day of Month
17 17th Day of Month
18 18th Day of Month
19 19th Day of Month
20 20th Day of Month
21 21st Day of Month
22 22nd Day of Month
23 23rd Day of Month
24 24th Day of Month
25 25th Day of Month
26 26th Day of Month
27 27th Day of Month
28 28th Day of Month
29 29th Day of Month
30 30th Day of Month
31 31st Day of Month
W1 Monday
W2 Tuesday
W3 Wednesday
W4 Thursday
W5 Friday
W6 Saturday
W7 Sunday
INV_CYCLE_MONTH Field Is Not Used - CHAR2 CHAR 2 0 NOT_USED_CHAR2_KK
MNDID Unique Reference to Mandate for each Payee CHAR 35 0 SEPA_MNDID
INV_FORM_DET_KEY Determination Characteristic for Alternative Invoice Form CHAR 4 0 TFK2681 FORM_DET_KEY_KK
GPART_INV Business Partner for Posting of the Invoice CHAR 10 0 BUT000 INVGP_KK
VKONT_INV Contract Account of Invoice Recipient CHAR 12 0 FKKVK INVVK_KK
GPART_INVLIST Recipient of Invoicing List CHAR 10 0 BUT000 INVLR_KK
VKONT_INVLIST Contract Account of Recipient of Invoicing List CHAR 12 0 FKKVK INVLK_KK
MAKEY Identification of Master Agreement CHAR 10 0 MAKEY_KK
PTSRL Partner Settlement Rule CHAR 4 0 TFKPS_RULE PTSRL_KK
TRSLA Subledger Transfer: Application ID CHAR 5 0 TRSLA_KK
FI Financial Accounting (FI-AR/FI-AP)
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 T005 FOT_TAX_COUNTRY
ZAHLKOND Payment Condition CHAR 4 0 TE052 KONDZAHL
KOFIZ_SD Account determination ID for contract accounts CHAR 2 0 TE097A E_KOFIZ_SD
GSBER Business Area CHAR 4 0 TGSB GSBER
IPA_CODE eDocumant Italy - IPA Code CHAR 6 0 EDOC_IPACODE_IT
IPA_BEGDA IPA Start Date DATS 8 0 EDOC_BEGDA_IT
IPA_CODE_LONG eDocument Italy : IPA_CODE Long for B2B CHAR 7 0 EDOC_IPACODE_LONG_IT_ISU
/SAPCE/FKRU_FIS Financing Source NUMC 1 0 /SAPCE/FKRU_FIS /SAPCE/FKRU_FI_SOURCE
/SAPCE/FKRU_FTD Federal Treasury Department CHAR 50 0 /SAPCE/FKRU_FED_TR_DEP
/SAPCE/FKRU_FTDA Account Number in Federal Treasury Department CHAR 20 0 /SAPCE/FKRU_FED_TR_DEP_ACC
/SAPCE/FKRU_CTT Contract Type NUMC 2 0 /SAPCE/FKRU_CTT /SAPCE/FKRU_CONTR_TYPE
BCODE Branch Code CHAR 5 0 BCODE_KK
DUMMY_FKKVKP_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY

FKKVKP foreign key relationships

Table Field Check Table Check Field
0 FKKVKP ABWMA BUT000 BP: General data I PARTNER
1 FKKVKP ABWRA BUT000 BP: General data I PARTNER
0 FKKVKP ABWRE BUT000 BP: General data I PARTNER
1 FKKVKP ABWRH BUT000 BP: General data I PARTNER
0 FKKVKP ABWVK FKKVK Contract Account Header VKONT
1 FKKVKP AZASP TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
0 FKKVKP BEGRU TFK_BEGRU FI-CA: Authorization Groups CLIENT
0 FKKVKP BEGRU TFK_BEGRU FI-CA: Authorization Groups BGOBJ
0 FKKVKP BEGRU TFK_BEGRU FI-CA: Authorization Groups BEGRU
1 FKKVKP BUPLA J_1BBRANCH Business Place BUKRS
1 FKKVKP BUPLA J_1BBRANCH Business Place BRANCH
1 FKKVKP BUPLA J_1BBRANCH Business Place BUPLA_TYPE
0 FKKVKP CMGRP TFK041B Master Data Groups MANDT
0 FKKVKP CMGRP TFK041B Master Data Groups CMGRP
1 FKKVKP COPRC TFK070B Correspondence Procedure MANDT
1 FKKVKP COPRC TFK070B Correspondence Procedure COPRC
0 FKKVKP COUNTY T005E County MANDT
0 FKKVKP COUNTY T005E County LAND1
0 FKKVKP COUNTY T005E County REGIO
0 FKKVKP COUNTY T005E County COUNC
1 FKKVKP CPERS BUT000 BP: General data I PARTNER
0 FKKVKP DDLCU TCURC Currency Codes MANDT
0 FKKVKP DDLCU TCURC Currency Codes WAERS
1 FKKVKP DEF_REC BUT000 BP: General data I PARTNER
0 FKKVKP DEF_REC_IND TFK070L Correspondence - Correspondence Activities MANDT
0 FKKVKP DEF_REC_IND TFK070L Correspondence - Correspondence Activities CORR_ACKEY
1 FKKVKP EZASP TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
0 FKKVKP FDGRP T035 Planning groups GRUPP
1 FKKVKP FITYP J_1AFITPV Tax Type: Possible Entries MANDT
1 FKKVKP FITYP J_1AFITPV Tax Type: Possible Entries J_1AFITP
0 FKKVKP GPART BUT000 BP: General data I PARTNER
1 FKKVKP GPART_INV BUT000 BP: General data I PARTNER
0 FKKVKP GPART_INVLIST BUT000 BP: General data I PARTNER
1 FKKVKP GPARV BUT000 BP: General data I PARTNER
0 FKKVKP GSBER TGSB Business Areas MANDT
0 FKKVKP GSBER TGSB Business Areas GSBER
1 FKKVKP IKEY TFK056A Interest Key Table for FI-CA IKEY
0 FKKVKP INV_CATEGORY TFK2604 Invoicing Categories MANDT
0 FKKVKP INV_CATEGORY TFK2604 Invoicing Categories INV_CATEGORY
1 FKKVKP INV_CURR TCURC Currency Codes MANDT
1 FKKVKP INV_CURR TCURC Currency Codes WAERS
0 FKKVKP INV_CYCLE TFK2607 Billing Cycles CYCLE
1 FKKVKP INV_FORM_DET_KEY TFK2681 Key for Determining Alternative Billing Form FORM_DET_KEY
0 FKKVKP INV_SCHEDULE TFK2606 Scheduling MANDT
0 FKKVKP INV_SCHEDULE TFK2606 Scheduling INV_SCHEDULE
1 FKKVKP KOFIZ_SD TE097A Account Determ. IDs MANDT
1 FKKVKP KOFIZ_SD TE097A Account Determ. IDs KOFIZ
0 FKKVKP LANDL T005 Countries MANDT
0 FKKVKP LANDL T005 Countries LAND1
1 FKKVKP MAHNV TFK047A Dunning procedure MAHNV
0 FKKVKP MANDT T000 Clients MANDT
1 FKKVKP MGRUP TFK047F Dunning grouping MANDT
1 FKKVKP MGRUP TFK047F Dunning grouping MGRUP
0 FKKVKP OPBUK TFK001G Company Code Groups MANDT
0 FKKVKP OPBUK TFK001G Company Code Groups OPBUK
1 FKKVKP PERSR BUT000 BP: General data I PARTNER
0 FKKVKP PROVINCE T005S Taxes: Region (Province) Key LAND1
1 FKKVKP PTSRL TFKPS_RULE Partner Settlement Rule MANDT
1 FKKVKP PTSRL TFKPS_RULE Partner Settlement Rule PTSRL
0 FKKVKP QSSKZ_A T059Q Withholding Tax MANDT
0 FKKVKP QSSKZ_A T059Q Withholding Tax LAND1
0 FKKVKP QSSKZ_A T059Q Withholding Tax QSSKZ
1 FKKVKP QSSKZ_E T059Q Withholding Tax MANDT
1 FKKVKP QSSKZ_E T059Q Withholding Tax LAND1
1 FKKVKP QSSKZ_E T059Q Withholding Tax QSSKZ
0 FKKVKP STOPG TFK001S Reasons for Processing Lock MANDT
1 FKKVKP TAX_COUNTRY T005 Countries MANDT
1 FKKVKP TAX_COUNTRY T005 Countries LAND1
0 FKKVKP TOGRU TFK043 Tolerances for Payment Differences, Payment Notices MANDT
0 FKKVKP TOGRU TFK043 Tolerances for Payment Differences, Payment Notices TOGRU
1 FKKVKP VERTYP TFK111 Clearing: Clearing Categories MANDT
1 FKKVKP VERTYP TFK111 Clearing: Clearing Categories VERTYP
0 FKKVKP VKONT FKKVK Contract Account Header VKONT
1 FKKVKP VKONT_INV FKKVK Contract Account Header VKONT
0 FKKVKP VKONT_INVLIST FKKVK Contract Account Header VKONT
1 FKKVKP VKONV FKKVK Contract Account Header VKONT
0 FKKVKP VKPBZ TFK002F Partner Account Relationships MANDT
0 FKKVKP VKPBZ TFK002F Partner Account Relationships VKPBZ
1 FKKVKP ZAHLKOND TE052 Terms of Payment MANDT
1 FKKVKP ZAHLKOND TE052 Terms of Payment ZAHLKOND