DFKKOPK

Transparent Table Application Table
110 Fields 2 CDS Views

Items in contract account document

DFKKOPK is an SAP database table in S/4HANA. Items in contract account document. It contains 110 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CADocumentGLItem view from EXTENSION GL Belegposition Erweiterung
I_CADocumentGLItem view from BASIC Document General Ledger Item

Fields (110)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY opbel OPBEL_KK Document Number
KEY opupk OPUPK_KK Item
bukrs BUKRS Company Code
hkont HKONT_KK G/L Account
gsber GSBER Business Area
bupla BUPLA Business place
segment SEGMT_KK Segment
prctr PRCTR Profit Center
kostl KOSTL Cost Center
kdauf KDAUF Sales Order
kdpos KDPOS Sales Ord. Item
kdein KDEIN SOrder schedule
ps_psp_pnr PS_PSP_PNR WBS Element
paobjnr RKEOBJNR Profit. segment
pasubnr RKESUBNR Subnumber
fdlev FDLEV_KK Planning level
valut VALUT Value date
kursf KURSF_KK Exchange Rate
betrh BETRH_KK Local Crcy Amt
betrw BETRW_KK Amount
betr2 BETR2_KK Amount in LC 2
betr3 BETR3_KK Amount in LC3
whgrp WHGRP_KK Repetition grp
strkz STRKZ_KK TxCde:Oth.Taxes
qssew QSSEW_KK WT supplmt
txgrp TXGRP_KK Tax Group
mwskz MWSKZ Tax Code
mwszkz MWSZKZ_KK Supplem. Tax
txjcd TXJCD Tax Jur.
txjco TXJCO_KK Orig.jurisdict.
txcnt TXCNT_KK Tax level
txdat TXDAT_KK Tax Date
txexk TXEXK_KK Tax exception
sbash SBASH_KK Tax base in LC
sbasw SBASW_KK Tax Base Amount
ndtax NDTAX_KK Non-Ded. Tax
ndtxh NDTXH_KK Non-Ded.Tax LC
xndtx XNDTX_KK Non-Ded. Input Tax
ktosl KTOSL_KK Autom. Posting
stprz STPRZ_KK Tax rate
kschl KSCHL Condition Type
aufnr AUFNR Order
xeiph XEIPH_KK Line item
vbund RASSC Trading Partner
kontt KONTT_KK Acct Assgt Cat.
kontl KONTL_KK Acct assignment
xintb XINTB_KK Created Int.
eurou EUROU_KK Euro status
fikey FIKEY_KK Reconcil. Key
xcopa XCOPA_KK CO-PA updated
menge MENGE_D Quantity
meins MEINS Base Unit
regio REGIO Region
counc COUNC County Code
gricd J_1AGICD_D Activity Code
gityp J_1ADTYP_D Distr. Type
intbu INTBU_KK Posting Reason
negbu NEGBU_KK Negative Pstng
pswsl PSWSL_KK G/L Currency
psgrp PSGRP_KK Item Grouping
invgr INVGR_KK Inv. Grouping
sctax SCTAX_KK FI-CA Tax Portion
sttax STTAX_KK Tax Portion
ldgrp LDGRP_KK Ledger Group
aasta AASTA_KK Distribution Status
xcsha XCSHA_KK Cash Flow
reacc REACC_KK Cash Flow Acct
rebuk REBUK_KK Cash Flow CoCd
xustpd XUSTPD_KK Tax by Document
xdexr XDEXR_KK Alt.Exch.Rate
sgrkey SGRKEY Item grouping
aperiodic APERIODIC Non-Per.Posting
vsarl_vx VSARL_VX Insurance type
lndsl LAND1 Country/Reg.
bewar RMVCT Transact. Type
bugrd BUGRD_VK Posting Reason
scitem SCITEM_SC Sched doc no.
txpos TXPOS_KK Tax Reference
coins_code COINS_REPID Coins. Key
coins_cat COINS_DOC_TYPE_PRCL Category
fmtyp FMTYP_KK FM Type
origfikrs ORIGFIKRS_KK Original FMArea
fipex FM_FIPEX Commitment Item
fistl FISTL Funds Center
fonds BP_GEBER Fund
fkber FKBER Functional Area
measure FM_MEASURE Funded Program
grant_nbr GM_GRANT_NBR Grant
budgetyear FM_START_OF_CHAIN Original Year
budget_pd FM_BUDGET_PERIOD Budget Period
kblnr KBLNR Earmarked Funds
kblpos KBLPOS Document Item
hbkid HBKID House Bank
hktid HKTID Account ID
squan SIGN_QUANTITY Qty +/- Sign
kukey KUKEY_KK Acct Statment
esnum ESNUM_EB Memo Record No.
ltype FQM_LINKTYPE Link Type
lnkid FQM_LINKID Link ID
_dataaging DATA_TEMPERATURE Data Aging
txdat_from FOT_TXDAT_FROM Tax Rate Valid-From
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
taxc_factor TAXC_FACTOR_KK Tax Factor C/R
txinf TXINF_KK Tax Info
service_doc_type FCO_SRVDOC_TYPE Service Doc. Type
service_doc_id FCO_SRVDOC_ID Service Document
service_doc_item_id FCO_SRVDOC_ITEM_ID Service Doc. Item
service_doc_trans_gl SERVICE_DOC_TRANS_GL SrvceRefActive
dummy_fkkopk_incl_eew_ps CFD_DUMMY Dummy

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.

-- Items in contract account document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKOPK (
    MANDT,                     -- Client [MANDT]
    OPBEL,                     -- Document Number [OPBEL_KK]
    OPUPK,                     -- Item [OPUPK_KK]
    BUKRS,                     -- Company Code [BUKRS]
    HKONT,                     -- G/L Account [HKONT_KK]
    GSBER,                     -- Business Area [GSBER]
    BUPLA,                     -- Business place [BUPLA]
    SEGMENT,                   -- Segment [SEGMT_KK]
    PRCTR,                     -- Profit Center [PRCTR]
    KOSTL,                     -- Cost Center [KOSTL]
    KDAUF,                     -- Sales Order [KDAUF]
    KDPOS,                     -- Sales Ord. Item [KDPOS]
    KDEIN,                     -- SOrder schedule [KDEIN]
    PS_PSP_PNR,                -- WBS Element [PS_PSP_PNR]
    PAOBJNR,                   -- Profit. segment [RKEOBJNR]
    PASUBNR,                   -- Subnumber [RKESUBNR]
    FDLEV,                     -- Planning level [FDLEV_KK]
    VALUT,                     -- Value date [VALUT]
    KURSF,                     -- Exchange Rate [KURSF_KK]
    BETRH,                     -- Local Crcy Amt [BETRH_KK]
    BETRW,                     -- Amount [BETRW_KK]
    BETR2,                     -- Amount in LC 2 [BETR2_KK]
    BETR3,                     -- Amount in LC3 [BETR3_KK]
    WHGRP,                     -- Repetition grp [WHGRP_KK]
    STRKZ,                     -- TxCde:Oth.Taxes [STRKZ_KK]
    QSSEW,                     -- WT supplmt [QSSEW_KK]
    TXGRP,                     -- Tax Group [TXGRP_KK]
    MWSKZ,                     -- Tax Code [MWSKZ]
    MWSZKZ,                    -- Supplem. Tax [MWSZKZ_KK]
    TXJCD,                     -- Tax Jur. [TXJCD]
    TXJCO,                     -- Orig.jurisdict. [TXJCO_KK]
    TXCNT,                     -- Tax level [TXCNT_KK]
    TXDAT,                     -- Tax Date [TXDAT_KK]
    TXEXK,                     -- Tax exception [TXEXK_KK]
    SBASH,                     -- Tax base in LC [SBASH_KK]
    SBASW,                     -- Tax Base Amount [SBASW_KK]
    NDTAX,                     -- Non-Ded. Tax [NDTAX_KK]
    NDTXH,                     -- Non-Ded.Tax LC [NDTXH_KK]
    XNDTX,                     -- Non-Ded. Input Tax [XNDTX_KK]
    KTOSL,                     -- Autom. Posting [KTOSL_KK]
    STPRZ,                     -- Tax rate [STPRZ_KK]
    KSCHL,                     -- Condition Type [KSCHL]
    AUFNR,                     -- Order [AUFNR]
    XEIPH,                     -- Line item [XEIPH_KK]
    VBUND,                     -- Trading Partner [RASSC]
    KONTT,                     -- Acct Assgt Cat. [KONTT_KK]
    KONTL,                     -- Acct assignment [KONTL_KK]
    XINTB,                     -- Created Int. [XINTB_KK]
    EUROU,                     -- Euro status [EUROU_KK]
    FIKEY,                     -- Reconcil. Key [FIKEY_KK]
    XCOPA,                     -- CO-PA updated [XCOPA_KK]
    MENGE,                     -- Quantity [MENGE_D]
    MEINS,                     -- Base Unit [MEINS]
    REGIO,                     -- Region [REGIO]
    COUNC,                     -- County Code [COUNC]
    GRICD,                     -- Activity Code [J_1AGICD_D]
    GITYP,                     -- Distr. Type [J_1ADTYP_D]
    INTBU,                     -- Posting Reason [INTBU_KK]
    NEGBU,                     -- Negative Pstng [NEGBU_KK]
    PSWSL,                     -- G/L Currency [PSWSL_KK]
    PSGRP,                     -- Item Grouping [PSGRP_KK]
    INVGR,                     -- Inv. Grouping [INVGR_KK]
    SCTAX,                     -- FI-CA Tax Portion [SCTAX_KK]
    STTAX,                     -- Tax Portion [STTAX_KK]
    LDGRP,                     -- Ledger Group [LDGRP_KK]
    AASTA,                     -- Distribution Status [AASTA_KK]
    XCSHA,                     -- Cash Flow [XCSHA_KK]
    REACC,                     -- Cash Flow Acct [REACC_KK]
    REBUK,                     -- Cash Flow CoCd [REBUK_KK]
    XUSTPD,                    -- Tax by Document [XUSTPD_KK]
    XDEXR,                     -- Alt.Exch.Rate [XDEXR_KK]
    SGRKEY,                    -- Item grouping [SGRKEY]
    APERIODIC,                 -- Non-Per.Posting [APERIODIC]
    VSARL_VX,                  -- Insurance type [VSARL_VX]
    LNDSL,                     -- Country/Reg. [LAND1]
    BEWAR,                     -- Transact. Type [RMVCT]
    BUGRD,                     -- Posting Reason [BUGRD_VK]
    SCITEM,                    -- Sched doc no. [SCITEM_SC]
    TXPOS,                     -- Tax Reference [TXPOS_KK]
    COINS_CODE,                -- Coins. Key [COINS_REPID]
    COINS_CAT,                 -- Category [COINS_DOC_TYPE_PRCL]
    FMTYP,                     -- FM Type [FMTYP_KK]
    ORIGFIKRS,                 -- Original FMArea [ORIGFIKRS_KK]
    FIPEX,                     -- Commitment Item [FM_FIPEX]
    FISTL,                     -- Funds Center [FISTL]
    FONDS,                     -- Fund [BP_GEBER]
    FKBER,                     -- Functional Area [FKBER]
    MEASURE,                   -- Funded Program [FM_MEASURE]
    GRANT_NBR,                 -- Grant [GM_GRANT_NBR]
    BUDGETYEAR,                -- Original Year [FM_START_OF_CHAIN]
    BUDGET_PD,                 -- Budget Period [FM_BUDGET_PERIOD]
    KBLNR,                     -- Earmarked Funds [KBLNR]
    KBLPOS,                    -- Document Item [KBLPOS]
    HBKID,                     -- House Bank [HBKID]
    HKTID,                     -- Account ID [HKTID]
    SQUAN,                     -- Qty +/- Sign [SIGN_QUANTITY]
    KUKEY,                     -- Acct Statment [KUKEY_KK]
    ESNUM,                     -- Memo Record No. [ESNUM_EB]
    LTYPE,                     -- Link Type [FQM_LINKTYPE]
    LNKID,                     -- Link ID [FQM_LINKID]
    _DATAAGING,                -- Data Aging [DATA_TEMPERATURE]
    TXDAT_FROM,                -- Tax Rate Valid-From [FOT_TXDAT_FROM]
    TAX_COUNTRY,               -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    TAXC_FACTOR,               -- Tax Factor C/R [TAXC_FACTOR_KK]
    TXINF,                     -- Tax Info [TXINF_KK]
    SERVICE_DOC_TYPE,          -- Service Doc. Type [FCO_SRVDOC_TYPE]
    SERVICE_DOC_ID,            -- Service Document [FCO_SRVDOC_ID]
    SERVICE_DOC_ITEM_ID,       -- Service Doc. Item [FCO_SRVDOC_ITEM_ID]
    SERVICE_DOC_TRANS_GL,      -- SrvceRefActive [SERVICE_DOC_TRANS_GL]
    DUMMY_FKKOPK_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, OPBEL, OPUPK)
);

Learn More