DFKKOP

Transparent Table Application Table
157 Fields 12 CDS Views

Positionen zum Kontokorrentbeleg

DFKKOP is an SAP database table in S/4HANA. Positionen zum Kontokorrentbeleg. It contains 157 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
E_CADocumentBPItemPhysical view from EXTENSION GP Belegposition Erweiterung
I_BhvrlInsgtsAccountItem view from BASIC Account Item from DFKKOP
I_CADocumentBPItem view_entity from BASIC Document Business Partner Item
SHSM_DFKKOP view from Ersatz für DFKKOP in Suchhilfe
view_o2c_fica_oi view from Open Items
view_o2c_fica_oi view union_all Open Items
view_o2c_fica_wl_crde view from CDS View Credits and Debits for Business Partner
view_o2c_fica_wl_crde view union_all CDS View Credits and Debits for Business Partner
view_o2c_fica_wlo view from CDS View Worklist for Overdue Items
view_o2c_fica_wlo view union_all CDS View Worklist for Overdue Items
view_o2c_fica_wlovd view from Business Partner List for Overdue Items
view_o2c_fica_wlovd view union_all Business Partner List for Overdue Items

Fields (157)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY opbel opbel_kk Document Number
KEY opupw opupw_kk Repetition Item
KEY opupk opupk_kk Item
KEY opupz opupz_kk Subitem
bukrs bukrs Company Code
gsber gsber Business Area
bupla bupla Business place
segment segmt_kk Segment
prctr prctr Profit Center
augst augst_kk Clearing Status
gpart gpart_kk Bus. Partner
vtref vtref_kk Contract
vtpos vtpos_kk Contract Item
vtre2 vtre2_kk Addl. Reference
vkont vkont_kk Contract Acct
abwbl abwbl_kk Sub. Doc.
abwtp abwtp_kk Doc.Cat.
abwkt abwvk_kk Coll. Bill Acct
applk applk_kk ApplicationArea
hvorg hvorg_kk Main Trans.
tvorg tvorg_kk Subtransaction
kofiz kofiz_kk Acct Determ. ID
spart spart_kk Division
hkont hkont_kk G/L Account
mwskz mwskz Tax Code
mwszkz mwszkz_kk Supplem. Tax
xanza xanza_kk Down Payment
stakz stakz_kk Statistical key
bldat bldat Document Date
budat budat Posting Date
optxt optxt_kk Text
waers blwae_kk Currency
faedn faedn_kk Net Due Date
faeds faeds_kk Disct Due Date
verkz verkz_kk Only Clearing
studt studt_kk Deferral To
sktpz sktpz_kk Discount rate
xmanl xmanl_kk Cannot Be Dunn.
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
skfbt skfbt_kk Disc. base
sbeth sbeth_kk LC Tax
sbetw sbetw_kk Tax Amount
sbet2 sbet2_kk LC 2 Tax
sbet3 sbet3_kk LC 3 tax
mwsko mwsko_kk Tax Account
mwvko mwvko_kk Offset tax acct
txrul txrul_kk Tax Update
spzah spzah_kk Pymt Lock Rsn
pymet pymet_kk Payment Method
pybuk pybuk_kk Paying Co. Code
pernr pernr_d Personnel No.
grkey grkey_kk Grouping key
persl persl_kk Period Key
xaesp xaesp_kk Change lock
augdt augdt_kk Clearing
augbl augbl_kk Clearing Doc.
augbd augbd_kk Clrg Post. Date
augrd augrd_kk Clearing Reason
augwa augwa_kk Clearing Curr.
augbt augbt_kk Clearing Amount
augbs augbs_kk Cl.Crcy Tax Amt
augsk augsk_kk Discnt/Surchrge
augvd augvd_kk Clear.Val.Date
augob augob_kk Canceled
whang whang_kk No. repetitions
whgrp whgrp_kk Repetition grp
xeiph xeiph_kk Line item
mahnv mahnv_kk Dunning Proc.
mansp mansp_kk DunnLockReason
xaugp xaugp_kk Check Clearing
abrzu abrzu_kk Billing Period
abrzo abrzo_kk Bill Period
fdgrp fdgrp_kk Planning group
fdlev fdlev_kk Planning level
fdztg fdztg_kk CM Extra Days
fdwbt fdwbt_kk Planned Amount
xtaus xtaus_kk Sub-Item
augrs augrs_kk Restriction
pygrp pygrp_kk Pymt Grouping
pdtyp pdtyp_kk Category
sperz sperz_kk Interest lock
infoz infoz_kk Doubtful item
txjcd txjcd Tax Jur.
txdat txdat_kk Tax Date
vbund rassc Trading Partner
kontt kontt_kk Acct Assgt Cat.
kontl kontl_kk Acct assignment
opsta opsta_kk Dunning indic.
blart blart_kk Document Type
emgpa emgpa_kk Partner
embvt embvt_kk Bank Details
emadr ad_addrnum Address Number
ikey ikey_kk Interest key
eurou eurou_kk Euro status
xragl xragl_kk Reverse clrg
astkz astkz_kk Trig. Stat. Key
asblg asblg_kk Trig. Document
xblnr xblnr_kk Reference
inkps inkps_kk Collection item
rndps rndps_kk Rndg item
qsskz qsskz WTax Code
qssew qssew_kk WT supplmt
qsptp qsptp_kk W/Htx item cat.
qsshb qsshb_kk Tax base amount
qbshb qbshb_kk Withholding tax
qsprz qsprz_kk Withholding Tax Pct
qsznr qsznr Exemption No.
xwhex xwhex_kk Variable WHT
rfupk rfupk_kk Reference item
strkz strkz_kk TxCde:Oth.Taxes
fitpr j_1afitp_d Tax Type
xpyor xpyor_kk Payment Order
landl landl_kk Destination C/R
intbu intbu_kk Posting Reason
intop intop_kk Gener. Charact.
emcrd emcrd_kk Card ID
c4eye c4eye_kk Check Reason
c4eyp c4eyp_kk Process
txgrp txgrp_kk Tax Group
sctax sctax_kk FI-CA Tax Portion
sttax sttax_kk Tax Portion
stzal stzal_kk Payment Status
orupz orupz_kk Prev. Subitem
negbu negbu_kk Negative Pstng
subap subap_kk Subapplication
pswsl pswsl_kk G/L Currency
pswbt pswbt_kk G/L Amount
pswtx pswtx_kk G/L Tax Amount
psgrp psgrp_kk Item Grouping
xcolc xcolc_kk Collection Case
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
ptitm ptitm_kk Revenue Sharing
emmnd emmnd_kk Mandate Ref.
palix palix_kk Collab. Liability
inttx inttx_kk TX Characteris.
herkf_kk herkf_kk Document Origin
cologrp cologrp_bp_kk Col.GroupBus.Partner
_dataaging data_temperature Data Aging
cpudt_op cpudt_op_kk Created On
cputm_op cputm_op_kk Created On
cpudt_st cpudt_st_kk Reversed On
cputm_st cputm_st_kk Reversed At
augre augre_kk Clrg Restrictn
txdat_from fot_txdat_from Tax Rate Valid-From
tax_country fot_tax_country Tax Ctry/Reg.
oriop oriop_kk Total Amount
augia augia_kk Amount
augda augda_kk

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.

-- Positionen zum Kontokorrentbeleg
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKOP (
    MANDT,        -- Client [mandt]
    OPBEL,        -- Document Number [opbel_kk]
    OPUPW,        -- Repetition Item [opupw_kk]
    OPUPK,        -- Item [opupk_kk]
    OPUPZ,        -- Subitem [opupz_kk]
    BUKRS,        -- Company Code [bukrs]
    GSBER,        -- Business Area [gsber]
    BUPLA,        -- Business place [bupla]
    SEGMENT,      -- Segment [segmt_kk]
    PRCTR,        -- Profit Center [prctr]
    AUGST,        -- Clearing Status [augst_kk]
    GPART,        -- Bus. Partner [gpart_kk]
    VTREF,        -- Contract [vtref_kk]
    VTPOS,        -- Contract Item [vtpos_kk]
    VTRE2,        -- Addl. Reference [vtre2_kk]
    VKONT,        -- Contract Acct [vkont_kk]
    ABWBL,        -- Sub. Doc. [abwbl_kk]
    ABWTP,        -- Doc.Cat. [abwtp_kk]
    ABWKT,        -- Coll. Bill Acct [abwvk_kk]
    APPLK,        -- ApplicationArea [applk_kk]
    HVORG,        -- Main Trans. [hvorg_kk]
    TVORG,        -- Subtransaction [tvorg_kk]
    KOFIZ,        -- Acct Determ. ID [kofiz_kk]
    SPART,        -- Division [spart_kk]
    HKONT,        -- G/L Account [hkont_kk]
    MWSKZ,        -- Tax Code [mwskz]
    MWSZKZ,       -- Supplem. Tax [mwszkz_kk]
    XANZA,        -- Down Payment [xanza_kk]
    STAKZ,        -- Statistical key [stakz_kk]
    BLDAT,        -- Document Date [bldat]
    BUDAT,        -- Posting Date [budat]
    OPTXT,        -- Text [optxt_kk]
    WAERS,        -- Currency [blwae_kk]
    FAEDN,        -- Net Due Date [faedn_kk]
    FAEDS,        -- Disct Due Date [faeds_kk]
    VERKZ,        -- Only Clearing [verkz_kk]
    STUDT,        -- Deferral To [studt_kk]
    SKTPZ,        -- Discount rate [sktpz_kk]
    XMANL,        -- Cannot Be Dunn. [xmanl_kk]
    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]
    SKFBT,        -- Disc. base [skfbt_kk]
    SBETH,        -- LC Tax [sbeth_kk]
    SBETW,        -- Tax Amount [sbetw_kk]
    SBET2,        -- LC 2 Tax [sbet2_kk]
    SBET3,        -- LC 3 tax [sbet3_kk]
    MWSKO,        -- Tax Account [mwsko_kk]
    MWVKO,        -- Offset tax acct [mwvko_kk]
    TXRUL,        -- Tax Update [txrul_kk]
    SPZAH,        -- Pymt Lock Rsn [spzah_kk]
    PYMET,        -- Payment Method [pymet_kk]
    PYBUK,        -- Paying Co. Code [pybuk_kk]
    PERNR,        -- Personnel No. [pernr_d]
    GRKEY,        -- Grouping key [grkey_kk]
    PERSL,        -- Period Key [persl_kk]
    XAESP,        -- Change lock [xaesp_kk]
    AUGDT,        -- Clearing [augdt_kk]
    AUGBL,        -- Clearing Doc. [augbl_kk]
    AUGBD,        -- Clrg Post. Date [augbd_kk]
    AUGRD,        -- Clearing Reason [augrd_kk]
    AUGWA,        -- Clearing Curr. [augwa_kk]
    AUGBT,        -- Clearing Amount [augbt_kk]
    AUGBS,        -- Cl.Crcy Tax Amt [augbs_kk]
    AUGSK,        -- Discnt/Surchrge [augsk_kk]
    AUGVD,        -- Clear.Val.Date [augvd_kk]
    AUGOB,        -- Canceled [augob_kk]
    WHANG,        -- No. repetitions [whang_kk]
    WHGRP,        -- Repetition grp [whgrp_kk]
    XEIPH,        -- Line item [xeiph_kk]
    MAHNV,        -- Dunning Proc. [mahnv_kk]
    MANSP,        -- DunnLockReason [mansp_kk]
    XAUGP,        -- Check Clearing [xaugp_kk]
    ABRZU,        -- Billing Period [abrzu_kk]
    ABRZO,        -- Bill Period [abrzo_kk]
    FDGRP,        -- Planning group [fdgrp_kk]
    FDLEV,        -- Planning level [fdlev_kk]
    FDZTG,        -- CM Extra Days [fdztg_kk]
    FDWBT,        -- Planned Amount [fdwbt_kk]
    XTAUS,        -- Sub-Item [xtaus_kk]
    AUGRS,        -- Restriction [augrs_kk]
    PYGRP,        -- Pymt Grouping [pygrp_kk]
    PDTYP,        -- Category [pdtyp_kk]
    SPERZ,        -- Interest lock [sperz_kk]
    INFOZ,        -- Doubtful item [infoz_kk]
    TXJCD,        -- Tax Jur. [txjcd]
    TXDAT,        -- Tax Date [txdat_kk]
    VBUND,        -- Trading Partner [rassc]
    KONTT,        -- Acct Assgt Cat. [kontt_kk]
    KONTL,        -- Acct assignment [kontl_kk]
    OPSTA,        -- Dunning indic. [opsta_kk]
    BLART,        -- Document Type [blart_kk]
    EMGPA,        -- Partner [emgpa_kk]
    EMBVT,        -- Bank Details [embvt_kk]
    EMADR,        -- Address Number [ad_addrnum]
    IKEY,         -- Interest key [ikey_kk]
    EUROU,        -- Euro status [eurou_kk]
    XRAGL,        -- Reverse clrg [xragl_kk]
    ASTKZ,        -- Trig. Stat. Key [astkz_kk]
    ASBLG,        -- Trig. Document [asblg_kk]
    XBLNR,        -- Reference [xblnr_kk]
    INKPS,        -- Collection item [inkps_kk]
    RNDPS,        -- Rndg item [rndps_kk]
    QSSKZ,        -- WTax Code [qsskz]
    QSSEW,        -- WT supplmt [qssew_kk]
    QSPTP,        -- W/Htx item cat. [qsptp_kk]
    QSSHB,        -- Tax base amount [qsshb_kk]
    QBSHB,        -- Withholding tax [qbshb_kk]
    QSPRZ,        -- Withholding Tax Pct [qsprz_kk]
    QSZNR,        -- Exemption No. [qsznr]
    XWHEX,        -- Variable WHT [xwhex_kk]
    RFUPK,        -- Reference item [rfupk_kk]
    STRKZ,        -- TxCde:Oth.Taxes [strkz_kk]
    FITPR,        -- Tax Type [j_1afitp_d]
    XPYOR,        -- Payment Order [xpyor_kk]
    LANDL,        -- Destination C/R [landl_kk]
    INTBU,        -- Posting Reason [intbu_kk]
    INTOP,        -- Gener. Charact. [intop_kk]
    EMCRD,        -- Card ID [emcrd_kk]
    C4EYE,        -- Check Reason [c4eye_kk]
    C4EYP,        -- Process [c4eyp_kk]
    TXGRP,        -- Tax Group [txgrp_kk]
    SCTAX,        -- FI-CA Tax Portion [sctax_kk]
    STTAX,        -- Tax Portion [sttax_kk]
    STZAL,        -- Payment Status [stzal_kk]
    ORUPZ,        -- Prev. Subitem [orupz_kk]
    NEGBU,        -- Negative Pstng [negbu_kk]
    SUBAP,        -- Subapplication [subap_kk]
    PSWSL,        -- G/L Currency [pswsl_kk]
    PSWBT,        -- G/L Amount [pswbt_kk]
    PSWTX,        -- G/L Tax Amount [pswtx_kk]
    PSGRP,        -- Item Grouping [psgrp_kk]
    XCOLC,        -- Collection Case [xcolc_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]
    PTITM,        -- Revenue Sharing [ptitm_kk]
    EMMND,        -- Mandate Ref. [emmnd_kk]
    PALIX,        -- Collab. Liability [palix_kk]
    INTTX,        -- TX Characteris. [inttx_kk]
    HERKF_KK,     -- Document Origin [herkf_kk]
    COLOGRP,      -- Col.GroupBus.Partner [cologrp_bp_kk]
    _DATAAGING,   -- Data Aging [data_temperature]
    CPUDT_OP,     -- Created On [cpudt_op_kk]
    CPUTM_OP,     -- Created On [cputm_op_kk]
    CPUDT_ST,     -- Reversed On [cpudt_st_kk]
    CPUTM_ST,     -- Reversed At [cputm_st_kk]
    AUGRE,        -- Clrg Restrictn [augre_kk]
    TXDAT_FROM,   -- Tax Rate Valid-From [fot_txdat_from]
    TAX_COUNTRY,  -- Tax Ctry/Reg. [fot_tax_country]
    ORIOP,        -- Total Amount [oriop_kk]
    AUGIA,        -- Amount [augia_kk]
    AUGDA,        -- augda_kk
    PRIMARY KEY (MANDT, OPBEL, OPUPW, OPUPK, OPUPZ)
);

Learn More