SAP Table FKKVKP_BW_2

BW: Extraction Structure for Contract Account Items

FKKVKP_BW_2 (BW: Extraction Structure for Contract Account Items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FKKVKP_BW_2 to other SAP tables.

FKKVKP_BW_2 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
VKONT Contract Account Number VKONT_KK CHAR 12 0
GPART Business Partner Number GPART_KK CHAR 10 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDATP Changed On AEDAT DATS 8 0
AENAMP Name of Person Who Changed Object AENAM CHAR 12 0
FDZTG Additional Days for Cash Management FDZTG_KK NUMC 2 0
STOPD Processing lock until STOPD_KK DATS 8 0
QSZDT Validity Date for Withholding Tax Exemption Certificate QSZDT DATS 8 0
GUID Business Agreement GUID BUAG_GUID RAW 16 0
DDLAM Direct Debit Limit DDLAM_KK CURR 13 2
DDLCU Currency of Direct Debit Limit DDLCU_KK CUKY 5 0
DDLNM Number of Months for Calculation of Direct Debit Limit DDLNM_KK NUMC 2 0
INV_CYCLE_START Start Date of Billing Cycle in Contract Account CYCLE_STARTDATE_KK DATS 8 0
INV_CHGDISC_X Int: Charges and Discounts Exist for BP-CrtAcct Relations CHGDISC_X_KK CHAR 1 0
X Yes
NULL No
BPL_XPOCL Business Partner Lock for Postings/Clearing BPL_XPOCL_KK CHAR 1 0
NULL No Lock
1 Posting Lock Only
2 Clearing Lock Only
3 Posting and Clearing Lock
BPL_FDATE Lock valid from FDATE_KK DATS 8 0
BPL_TDATE Lock valid to TDATE_KK DATS 8 0
EXVKO Reference number for business partner EXVKO_KK CHAR 25 0
OPBUK Company Code Group OPBUK_KK TFK001G CHAR 4 0
STDBK Standard Company Code STDBK_KK CHAR 4 0
ABWRE Alternative Payer ABWRE_KK BUT000 CHAR 10 0
ABWRA Alternative Payee ABWRA_KK BUT000 CHAR 10 0
ABWMA Alternative dunning recipient ABWMA_KK BUT000 CHAR 10 0
EBVTY Bank Details ID for Incoming Payments EBVTY_KK CHAR 4 0
ABVTY Bank Details ID for Outgoing Payments ABVTY_KK CHAR 4 0
EZAWE Incoming Payment Method EZAWE_KK CHAR 1 0
EZASP Lock Reason for Incoming Payments EZASP_OLD_KK TFK008 CHAR 1 0
AZAWE Outgoing Payment Methods AZAWE_KK CHAR 5 0
AZASP Lock Reason for Outgoing Payments AZASP_OLD_KK TFK008 CHAR 1 0
EIGBV Own Bank Details EIGBV_KK CHAR 25 0
VWNZA Create Where-Used List For Line Items VWNZA_KK CHAR 1 0
NULL no listing of line items
X line items listed
LOEVM Mark Contract Account for Deletion LOEVM_KK CHAR 1 0
ABWVK Alternative contract account for collective bills ABWVK_KK FKKVK CHAR 12 0
IKEY Interest Key IKEY_KK TFK056A CHAR 2 0
MAHNV Dunning Procedure MAHNV_KK TFK047A CHAR 2 0
MANSP Dunning Lock Reason MANSP_OLD_KK TFK047S CHAR 1 0
MGRUP Grouping fur Dunning Notices MGRUP_KK TFK047F CHAR 2 0
FDGRP Planning Group FDGRP_KK T035 CHAR 10 0
VKPBZ Relationship of Business Partner to Contract Account VKPBZ_KK TFK002F CHAR 2 0
ADRNB Address number AD_ADDRNUM CHAR 10 0
VKONV Contract account used for payment transactions VKONV_KK FKKVK CHAR 12 0
GPARV Business Partner Acting as Payer in Payment Transactions GPARV_KK BUT000 CHAR 10 0
ADRRE Address Number for Alternative Payer ADRRE_KK CHAR 10 0
ADRRA Address Number for Alternative Payee ADRRA_KK CHAR 10 0
ADRMA Address number for alternative dunning notice recipient ADRMA_KK CHAR 10 0
ABWRH Alternative Invoice Recipient ABWRH_KK BUT000 CHAR 10 0
ADRRH Address number for alternative bill recipient ADRRH_KK CHAR 10 0
ADRJDC Address Number for Jurisdiction Code Address ADRJDC_KK CHAR 10 0
BEGRU Authorization Group BEGRU CHAR 4 0
TOGRU Tolerance group for contract account TOGRU_KK TFK043 CHAR 4 0
STOPG Reason for Processing Lock STOPG_KK TFK001S CHAR 1 0
TXJCD Jurisdiction for Tax Calculation - Tax Jurisdiction Code TXJCD_NOCD_KK CHAR 15 0
COPRC Correspondence Variant COPRC_KK TFK070B CHAR 4 0
VBUND Company ID of trading partner RASSC CHAR 6 0
CCARD_ID Payment Card ID for Incoming Payments CCID_IN_KK CHAR 6 0
CCARD_OUT Payment Card ID for Outgoing Payments CCID_OUT_KK CHAR 6 0
UEBTR Items Transferred To Another Account XUEBTR_KK CHAR 1 0
X Yes
NULL No
DEF_REC Alternative Correspondence Recipient for Standard Case DEF_CORR_PARTNER_KK BUT000 CHAR 10 0
DEF_REC_IND FI-CA correspondence - activity key DEF_CORR_ACKEY_KK TFK070L CHAR 4 0
QSSKZ_A Witholding Tax Code For Outgoing Payments QSSKZ_A_KK CHAR 2 0
QSSKZ_E Withholding Tax Code For Incoming Payments QSSKZ_E_KK CHAR 2 0
QSZNR Certificate Number of the Withholding Tax Exemption QSZNR CHAR 10 0
CORR_MAHNV Correspondence Dunning Procedure CORR_MAHNV_KK CHAR 2 0
FITYP Tax type J_1AFITP_D J_1AFITPV CHAR 2 0
PROVINCE Region (State, Province, County) REGIO T005S CHAR 3 0
COUNTY County Code COUNC T005E CHAR 3 0
VERTYP Clearing Category For Clearing Postings VERTYP_KK TFK111 CHAR 4 0
AUGRS_DEF Clearing Restriction AUGRS_DEF_KK CHAR 1 0
D Deposit: Can only be cleared with open item clearing
LANDL Country Supplied (for Tax Notifications) LANDL_KK T005 CHAR 3 0
BUPLA Business Place BUPLA J_1BBRANCH CHAR 4 0
BPTAXTYPE1 Tax Number Type 1 for Business Partner BPTAXTYPE1 CHAR 4 0
BPTAXTYPE2 Tax Number type 2 for Business Partner BPTAXTYPE2 CHAR 4 0
PERSR Clerk Responsible PERSR_KK BUT000 CHAR 10 0
INV_CATEGORY Invoicing Category INV_CATEGORY_KK TFK2604 CHAR 4 0
DDLXG Rolling Calculation of Direct Debit Limit DDLXG_KK CHAR 1 0
X Yes
NULL No
CMGRP Collection Management: Master Data Group CMGRP_CM_KK CHAR 2 0
STRAT Collection Strategy STRAT_CM_KK CHAR 2 0
CPERS Collections Contact Person CPERS_CM_KK CHAR 10 0
BPCL_SUCC Duplicate Processing: Predecessor/Successor Business Partner BPCL_SUCC_KK CHAR 1 0
1 Predecessor
2 Successor
3 Predecessor and Successor
NULL No Relationship Exists
INV_SCHEDULE Selection Characteristic for Scheduling INV_SCHEDULE_KK TFK2606 CHAR 4 0
INV_CYCLE Billing Cycle CYCLE_KK TFK2607 CHAR 4 0
INV_CYCLE_RULE Field Is Not Used - CHAR4 CYCLE_RULE_KK CHAR 4 0
INV_CYCLE_DAY Day of Period End CYCLE_DAY_KK CHAR 2 0
INV_CYCLE_MONTH Field Is Not Used - CHAR2 NOT_USED_CHAR2_KK CHAR 2 0
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
UPDMOD BW Delta Process: Record Mode RODMUPDMOD CHAR 1 0
NULL After-Image
X Before-Image
A Add
D Delete (Key Only)
N New Image
R Reverse-Image
Y Update Image (Value from Update)

FKKVKP_BW_2 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FKKVKP_BW_2 ABWMA FKKVKP_BW_2 ABWMA BUT000 BP: General data I PARTNER
FKKVKP_BW_2 ABWMA SYST MANDT BUT000 BP: General data I CLIENT
FKKVKP_BW_2 ABWRA SYST MANDT BUT000 BP: General data I CLIENT
FKKVKP_BW_2 ABWRA FKKVKP_BW_2 ABWRA BUT000 BP: General data I PARTNER
FKKVKP_BW_2 ABWRE SYST MANDT BUT000 BP: General data I CLIENT
FKKVKP_BW_2 ABWRE FKKVKP_BW_2 ABWRE BUT000 BP: General data I PARTNER
FKKVKP_BW_2 ABWRH SY MANDT BUT000 BP: General data I CLIENT
FKKVKP_BW_2 ABWRH FKKVKP_BW_2 ABWRH BUT000 BP: General data I PARTNER
FKKVKP_BW_2 ABWVK SY MANDT FKKVK Contract Account Header MANDT
FKKVKP_BW_2 ABWVK FKKVKP_BW_2 ABWVK FKKVK Contract Account Header VKONT
FKKVKP_BW_2 AZASP SYST MANDT TFK008 Locking Reasons for Automatic Payment Transactions MANDT
FKKVKP_BW_2 AZASP FKKVKP_BW_2 AZASP TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
FKKVKP_BW_2 BUPLA FKKVKP_BW_2 BUPLA J_1BBRANCH Business Place BRANCH
FKKVKP_BW_2 BUPLA SYST MANDT J_1BBRANCH Business Place MANDT
FKKVKP_BW_2 BUPLA FKKVKP_BW_2 STDBK J_1BBRANCH Business Place BUKRS
FKKVKP_BW_2 COPRC SY MANDT TFK070B Correspondence Procedure MANDT
FKKVKP_BW_2 COPRC FKKVKP_BW_2 COPRC TFK070B Correspondence Procedure COPRC
FKKVKP_BW_2 COUNTY FKKVKP_BW_2 COUNTY T005E County COUNC
FKKVKP_BW_2 COUNTY SY MANDT T005E County MANDT
FKKVKP_BW_2 COUNTY * T005E County LAND1
FKKVKP_BW_2 COUNTY FKKVKP_BW_2 PROVINCE T005E County REGIO
FKKVKP_BW_2 DEF_REC SYST MANDT BUT000 BP: General data I CLIENT
FKKVKP_BW_2 DEF_REC FKKVKP_BW_2 DEF_REC BUT000 BP: General data I PARTNER
FKKVKP_BW_2 DEF_REC_IND SY MANDT TFK070L Correspondence - Correspondence Activities MANDT
FKKVKP_BW_2 DEF_REC_IND FKKVKP_BW_2 DEF_REC_IND TFK070L Correspondence - Correspondence Activities CORR_ACKEY
FKKVKP_BW_2 EZASP SYST MANDT TFK008 Locking Reasons for Automatic Payment Transactions MANDT
FKKVKP_BW_2 EZASP FKKVKP_BW_2 EZASP TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
FKKVKP_BW_2 FDGRP FKKVKP_BW_2 FDGRP T035 Planning groups GRUPP
FKKVKP_BW_2 FDGRP SY MANDT T035 Planning groups MANDT
FKKVKP_BW_2 FITYP SY MANDT J_1AFITPV Tax Type: Possible Entries MANDT
FKKVKP_BW_2 FITYP FKKVKP_BW_2 FITYP J_1AFITPV Tax Type: Possible Entries J_1AFITP
FKKVKP_BW_2 GPARV SYST MANDT BUT000 BP: General data I CLIENT
FKKVKP_BW_2 GPARV FKKVKP_BW_2 GPARV BUT000 BP: General data I PARTNER
FKKVKP_BW_2 IKEY SY MANDT TFK056A Interest Key Table for FI-CA MANDT
FKKVKP_BW_2 IKEY FKKVKP_BW_2 IKEY TFK056A Interest Key Table for FI-CA IKEY
FKKVKP_BW_2 INV_CATEGORY SYST MANDT TFK2604 Invoicing Categories MANDT
FKKVKP_BW_2 INV_CATEGORY FKKVKP_BW_2 INV_CATEGORY TFK2604 Invoicing Categories INV_CATEGORY
FKKVKP_BW_2 INV_CYCLE FKKVKP_BW_2 INV_CYCLE TFK2607 Billing Cycles CYCLE
FKKVKP_BW_2 INV_CYCLE SYST MANDT TFK2607 Billing Cycles MANDT
FKKVKP_BW_2 INV_SCHEDULE SYST MANDT TFK2606 Scheduling MANDT
FKKVKP_BW_2 INV_SCHEDULE FKKVKP_BW_2 INV_SCHEDULE TFK2606 Scheduling INV_SCHEDULE
FKKVKP_BW_2 LANDL SYST MANDT T005 Countries MANDT
FKKVKP_BW_2 LANDL FKKVKP_BW_2 LANDL T005 Countries LAND1
FKKVKP_BW_2 MAHNV SY MANDT TFK047A Dunning procedure MANDT
FKKVKP_BW_2 MAHNV FKKVKP_BW_2 MAHNV TFK047A Dunning procedure MAHNV
FKKVKP_BW_2 MANSP SY MANDT TFK047S Dunning block reasons MANDT
FKKVKP_BW_2 MANSP FKKVKP_BW_2 MANSP TFK047S Dunning block reasons MANSP
FKKVKP_BW_2 MGRUP FKKVKP_BW_2 MGRUP TFK047F Dunning grouping MGRUP
FKKVKP_BW_2 MGRUP SY MANDT TFK047F Dunning grouping MANDT
FKKVKP_BW_2 OPBUK SYST MANDT TFK001G Company Code Groups MANDT
FKKVKP_BW_2 OPBUK FKKVKP_BW_2 OPBUK TFK001G Company Code Groups OPBUK
FKKVKP_BW_2 PERSR SYST MANDT BUT000 BP: General data I CLIENT
FKKVKP_BW_2 PERSR FKKVKP_BW_2 PERSR BUT000 BP: General data I PARTNER
FKKVKP_BW_2 PROVINCE SY MANDT T005S Taxes: Region (Province) Key MANDT
FKKVKP_BW_2 PROVINCE * T005S Taxes: Region (Province) Key LAND1
FKKVKP_BW_2 PROVINCE FKKVKP_BW_2 PROVINCE T005S Taxes: Region (Province) Key BLAND
FKKVKP_BW_2 STOPG SY MANDT TFK001S Reasons for Processing Lock MANDT
FKKVKP_BW_2 STOPG FKKVKP_BW_2 STOPG TFK001S Reasons for Processing Lock STOPG
FKKVKP_BW_2 TOGRU SY MANDT TFK043 Tolerances for Payment Differences, Payment Notices MANDT
FKKVKP_BW_2 TOGRU FKKVKP_BW_2 TOGRU TFK043 Tolerances for Payment Differences, Payment Notices TOGRU
FKKVKP_BW_2 VERTYP SY MANDT TFK111 Clearing: Clearing Categories MANDT
FKKVKP_BW_2 VERTYP FKKVKP_BW_2 VERTYP TFK111 Clearing: Clearing Categories VERTYP
FKKVKP_BW_2 VKONV FKKVKP_BW_2 VKONV FKKVK Contract Account Header VKONT
FKKVKP_BW_2 VKONV SYST MANDT FKKVK Contract Account Header MANDT
FKKVKP_BW_2 VKPBZ SY MANDT TFK002F Partner Account Relationships MANDT
FKKVKP_BW_2 VKPBZ FKKVKP_BW_2 VKPBZ TFK002F Partner Account Relationships VKPBZ