FKKVK
Contract Account Header
FKKVK is an SAP database table in S/4HANA. Contract Account Header. It contains 26 fields. 10 CDS views read from this table.
CDS Views using this table (10)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| CRMS4_IU_C_CONBP | view | inner | Connection object by business partner | |
| CRMS4_IU_C_CONVAR | view_entity | left_outer | Connection Object by Various Fields | |
| CRMS4_IU_C_CONVAR_DEVPOD | view_entity | left_outer | Con. Object by Various Fields (Dev, PoD) | |
| CRMS4_IU_C_PODBP | view | inner | Point of Delivery by Business Partner | |
| CRMS4_IU_C_PODCA | view | inner | Point of Delivery by Contract Account | |
| E_ContractAccountHeader | view | from | EXTENSION | Vertragskonto Kopf Erweiterung |
| I_BhvrlInsgtsCAHeader | view_entity | from | BASIC | Contract Account Header Data |
| I_ContractAccountHeader | view | from | BASIC | Contract Account |
| SHSM_I_EDISCDOCISUACCountVH | view | left_outer | CDS SH for Disc. Doc. with Ref. Obj. Cont Acct VH | |
| SHSM_M_EVEXA | view | inner | Contracts by Old Contract Number Search Help |
Fields (26)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | vkont | VKONT_KK | Contract Acct | |||
| erdat | ERDAT | Created On | ||||
| ertim | ERTIM_KK | Time | ||||
| ernam | ERNAM | Created By | ||||
| loevm | LOEVM_KK | Deletion Flag | ||||
| aedat | AEDAT | Changed On | ||||
| aetim | AETIM2_KK | Changed At | ||||
| aenam | AENAM | Changed By | ||||
| applk | APPLK_KK | ApplicationArea | ||||
| vktyp | VKTYP_KK | Cont. Acct Cat. | ||||
| vkona | VKONA_KK | CAcctLegacySys | ||||
| ktosi | KTOSI_VK | Account View | ||||
| kontf | KONTF_VK | Acct Management | ||||
| kkakb | KKAKB_VK | Acct Statmt - Agent | ||||
| kkasb | KKASB_VK | Stmnt to Clerk | ||||
| kzksm | KZKSM_VK | Bal. Not. Ind. | ||||
| gpnsb | GPNSB_VK | Clerk Part. No. | ||||
| gpnkb | GPNKB_VK | AcctAgntPartNo. | ||||
| kfzih | KFZIH_VK | Crdt Int. | ||||
| kfzis | KFZIS_VK | Debit Interest | ||||
| uvvar | UVVAR_VK | Clearing Var. | ||||
| kzdep | KZDEP_VK | Ind. Cover Chk | ||||
| pernr | PERNR_D | Personnel No. | ||||
| waers | BLWAE_KK | Currency | ||||
| vkbez | VKBEZ_KK | Cont. acct name |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Contract Account Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FKKVK (
MANDT, -- Client [MANDT]
VKONT, -- Contract Acct [VKONT_KK]
ERDAT, -- Created On [ERDAT]
ERTIM, -- Time [ERTIM_KK]
ERNAM, -- Created By [ERNAM]
LOEVM, -- Deletion Flag [LOEVM_KK]
AEDAT, -- Changed On [AEDAT]
AETIM, -- Changed At [AETIM2_KK]
AENAM, -- Changed By [AENAM]
APPLK, -- ApplicationArea [APPLK_KK]
VKTYP, -- Cont. Acct Cat. [VKTYP_KK]
VKONA, -- CAcctLegacySys [VKONA_KK]
KTOSI, -- Account View [KTOSI_VK]
KONTF, -- Acct Management [KONTF_VK]
KKAKB, -- Acct Statmt - Agent [KKAKB_VK]
KKASB, -- Stmnt to Clerk [KKASB_VK]
KZKSM, -- Bal. Not. Ind. [KZKSM_VK]
GPNSB, -- Clerk Part. No. [GPNSB_VK]
GPNKB, -- AcctAgntPartNo. [GPNKB_VK]
KFZIH, -- Crdt Int. [KFZIH_VK]
KFZIS, -- Debit Interest [KFZIS_VK]
UVVAR, -- Clearing Var. [UVVAR_VK]
KZDEP, -- Ind. Cover Chk [KZDEP_VK]
PERNR, -- Personnel No. [PERNR_D]
WAERS, -- Currency [BLWAE_KK]
VKBEZ, -- Cont. acct name [VKBEZ_KK]
PRIMARY KEY (MANDT, VKONT)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA