DFKKOPK_D

Transparent Table Application Table
90 Fields 1 CDS Views

Draft table for entity R_CADOCUMENTGLITEMTP

DFKKOPK_D is an SAP database table in S/4HANA. Draft table for entity R_CADOCUMENTGLITEMTP. It contains 90 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CADocumentGLItemDraft view_entity from BASIC Document General Ledger Item - Draft

Fields (90)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY cadocumentnumber opbel_kk Document Number
KEY caglitemnumber opupk_kk Item
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
companycode bukrs Company Code
businessarea gsber Business Area
businessplace bupla Business place
segment segmt_kk Segment
profitcenter prctr Profit Center
partnercompany rassc Trading Partner
glaccount hkont_kk G/L Account
wbselementinternalid ps_s4_pspnr WBS Internal ID
valuedate valut Value date
caexchangerate fis_absolute_exchangerate Absolute Exchange Rate
exchrateisindirectquotation fis_indirect_quotation Exchange Rate Is Indirect Quotation
transactioncurrency blwae_kk Currency
currency waers Currency
additionalcurrency1 waers Currency
additionalcurrency2 waers Currency
caamountinlocalcurrency betrh_kk Local Crcy Amt
caamountintransactioncurrency betrw_kk Amount
caamountinsecondcurrency betr2_kk Amount in LC 2
caamountinthirdcurrency betr3_kk Amount in LC3
caaccountassignmentcategory kontt_kk Acct Assgt Cat.
caaccountassignment kontl_kk Acct assignment
costcenter kostl Cost Center
salesorder kdauf Sales Order
salesorderitem kdpos Sales Ord. Item
careconciliationkey fikey_kk Reconcil. Key
cainternalpostingreasoncode intbu_kk Posting Reason
canegativepostingcontrolcode negbu_kk Negative Pstng
caglpostingcurrency pswsl_kk G/L Currency
ledgergroup ldgrp_kk Ledger Group
profitabilitysegment_2 rkeobjnr Profit. segment
profitabilitysegmentchanges rkesubnr Subnumber
planninglevel fdlev_kk Planning level
carepetitiongroup whgrp_kk Repetition grp
catransactionkeyaccountdetn ktosl_kk Autom. Posting
conditiontype kschl Condition Type
caisseparatelineitemingl xeiph_kk Line item
quantityinbaseunit menge_d Quantity
baseunit meins Base Unit
cagroupingkeydocumentitems psgrp_kk Item Grouping
taxcode mwskz Tax Code
casupplementarytaxcode mwszkz_kk Supplem. Tax
cawithholdingtaxsupplement qssew_kk WT supplmt
caothertaxcode strkz_kk TxCde:Oth.Taxes
cagroupingcodefortaxitems txgrp_kk Tax Group
taxjurisdiction txjcd Tax Jur.
caenteredtaxjurisdictioncode txjco_kk Orig.jurisdict.
cataxjurisdictionlevelcounter txcnt_kk Tax level
cataxexceptionid txexk_kk Tax exception
cataxdate txdat_kk Tax Date
cataxbaseamountinlocalcurrency sbash_kk Tax base in LC
cataxbaseamount sbasw_kk Tax Base Amount
canondeductibletxamtindoccrcy ndtax_kk Non-Ded. Tax
canondeductibletxamtinloclcrcy ndtxh_kk Non-Ded.Tax LC
cacontainsnondeductibleinpttax xndtx_kk Non-Ded. Input Tax
cataxrate stprz_kk Tax rate
grossincometaxactivitycode j_1agicd_d Activity Code
employmenttaxdistributiontype j_1adtyp_d Distr. Type
cataxportioninlocalcurrency sctax_kk FI-CA Tax Portion
cataxportionintranscurrency sttax_kk Tax Portion
cataxiscalculatedexternally xustpd_kk Tax by Document
caaltvexchangeratesetcode xdexr_kk Alt.Exch.Rate
taxcountry fot_tax_country Tax Ctry/Reg.
transtotaxcntrycrcycnvrsnfctr taxc_factor_kk Tax Factor C/R
caiscashflowitem xcsha_kk Cash Flow
cacashflowaccount reacc_kk Cash Flow Acct
cacashflowcompanycode rebuk_kk Cash Flow CoCd
housebank hbkid House Bank
housebankaccount hktid Account ID
quantitysigncode sign_quantity Qty +/- Sign
bankstatementshortid kukey_kk Acct Statment
bankstatementitem esnum_eb Memo Record No.
cashmanagementlinktype fqm_linktype Link Type
cashmanagementlink fqm_linkid Link ID
caitmiscreatedbypostginterface xintb_kk Created Int.
castatusofeuroconversion eurou_kk Euro status
caprofitanalysisupdtisdirect xcopa_kk CO-PA updated
cainvcggroupingkey invgr_kk Inv. Grouping
cactrlfieldforacctassgmtdistr aasta_kk Distribution Status
caupdatemethodforfundsmgmt fmtyp_kk FM Type
originalfinancialmgmtarea origfikrs_kk Original FMArea
origlyearforfinmgmtacctassgmt fm_start_of_chain Original Year
earmarkedfundsdocument kblnr Earmarked Funds
chartofaccounts ktopl Chart of Accts
country land1 Country/Reg.
taxcalculationprocedure kalsm_d Procedure

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.

-- Draft table for entity R_CADOCUMENTGLITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKOPK_D (
    MANDT,                           -- Client [mandt]
    CADOCUMENTNUMBER,                -- Document Number [opbel_kk]
    CAGLITEMNUMBER,                  -- Item [opupk_kk]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    COMPANYCODE,                     -- Company Code [bukrs]
    BUSINESSAREA,                    -- Business Area [gsber]
    BUSINESSPLACE,                   -- Business place [bupla]
    SEGMENT,                         -- Segment [segmt_kk]
    PROFITCENTER,                    -- Profit Center [prctr]
    PARTNERCOMPANY,                  -- Trading Partner [rassc]
    GLACCOUNT,                       -- G/L Account [hkont_kk]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [ps_s4_pspnr]
    VALUEDATE,                       -- Value date [valut]
    CAEXCHANGERATE,                  -- Absolute Exchange Rate [fis_absolute_exchangerate]
    EXCHRATEISINDIRECTQUOTATION,     -- Exchange Rate Is Indirect Quotation [fis_indirect_quotation]
    TRANSACTIONCURRENCY,             -- Currency [blwae_kk]
    CURRENCY,                        -- Currency [waers]
    ADDITIONALCURRENCY1,             -- Currency [waers]
    ADDITIONALCURRENCY2,             -- Currency [waers]
    CAAMOUNTINLOCALCURRENCY,         -- Local Crcy Amt [betrh_kk]
    CAAMOUNTINTRANSACTIONCURRENCY,   -- Amount [betrw_kk]
    CAAMOUNTINSECONDCURRENCY,        -- Amount in LC 2 [betr2_kk]
    CAAMOUNTINTHIRDCURRENCY,         -- Amount in LC3 [betr3_kk]
    CAACCOUNTASSIGNMENTCATEGORY,     -- Acct Assgt Cat. [kontt_kk]
    CAACCOUNTASSIGNMENT,             -- Acct assignment [kontl_kk]
    COSTCENTER,                      -- Cost Center [kostl]
    SALESORDER,                      -- Sales Order [kdauf]
    SALESORDERITEM,                  -- Sales Ord. Item [kdpos]
    CARECONCILIATIONKEY,             -- Reconcil. Key [fikey_kk]
    CAINTERNALPOSTINGREASONCODE,     -- Posting Reason [intbu_kk]
    CANEGATIVEPOSTINGCONTROLCODE,    -- Negative Pstng [negbu_kk]
    CAGLPOSTINGCURRENCY,             -- G/L Currency [pswsl_kk]
    LEDGERGROUP,                     -- Ledger Group [ldgrp_kk]
    PROFITABILITYSEGMENT_2,          -- Profit. segment [rkeobjnr]
    PROFITABILITYSEGMENTCHANGES,     -- Subnumber [rkesubnr]
    PLANNINGLEVEL,                   -- Planning level [fdlev_kk]
    CAREPETITIONGROUP,               -- Repetition grp [whgrp_kk]
    CATRANSACTIONKEYACCOUNTDETN,     -- Autom. Posting [ktosl_kk]
    CONDITIONTYPE,                   -- Condition Type [kschl]
    CAISSEPARATELINEITEMINGL,        -- Line item [xeiph_kk]
    QUANTITYINBASEUNIT,              -- Quantity [menge_d]
    BASEUNIT,                        -- Base Unit [meins]
    CAGROUPINGKEYDOCUMENTITEMS,      -- Item Grouping [psgrp_kk]
    TAXCODE,                         -- Tax Code [mwskz]
    CASUPPLEMENTARYTAXCODE,          -- Supplem. Tax [mwszkz_kk]
    CAWITHHOLDINGTAXSUPPLEMENT,      -- WT supplmt [qssew_kk]
    CAOTHERTAXCODE,                  -- TxCde:Oth.Taxes [strkz_kk]
    CAGROUPINGCODEFORTAXITEMS,       -- Tax Group [txgrp_kk]
    TAXJURISDICTION,                 -- Tax Jur. [txjcd]
    CAENTEREDTAXJURISDICTIONCODE,    -- Orig.jurisdict. [txjco_kk]
    CATAXJURISDICTIONLEVELCOUNTER,   -- Tax level [txcnt_kk]
    CATAXEXCEPTIONID,                -- Tax exception [txexk_kk]
    CATAXDATE,                       -- Tax Date [txdat_kk]
    CATAXBASEAMOUNTINLOCALCURRENCY,  -- Tax base in LC [sbash_kk]
    CATAXBASEAMOUNT,                 -- Tax Base Amount [sbasw_kk]
    CANONDEDUCTIBLETXAMTINDOCCRCY,   -- Non-Ded. Tax [ndtax_kk]
    CANONDEDUCTIBLETXAMTINLOCLCRCY,  -- Non-Ded.Tax LC [ndtxh_kk]
    CACONTAINSNONDEDUCTIBLEINPTTAX,  -- Non-Ded. Input Tax [xndtx_kk]
    CATAXRATE,                       -- Tax rate [stprz_kk]
    GROSSINCOMETAXACTIVITYCODE,      -- Activity Code [j_1agicd_d]
    EMPLOYMENTTAXDISTRIBUTIONTYPE,   -- Distr. Type [j_1adtyp_d]
    CATAXPORTIONINLOCALCURRENCY,     -- FI-CA Tax Portion [sctax_kk]
    CATAXPORTIONINTRANSCURRENCY,     -- Tax Portion [sttax_kk]
    CATAXISCALCULATEDEXTERNALLY,     -- Tax by Document [xustpd_kk]
    CAALTVEXCHANGERATESETCODE,       -- Alt.Exch.Rate [xdexr_kk]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [fot_tax_country]
    TRANSTOTAXCNTRYCRCYCNVRSNFCTR,   -- Tax Factor C/R [taxc_factor_kk]
    CAISCASHFLOWITEM,                -- Cash Flow [xcsha_kk]
    CACASHFLOWACCOUNT,               -- Cash Flow Acct [reacc_kk]
    CACASHFLOWCOMPANYCODE,           -- Cash Flow CoCd [rebuk_kk]
    HOUSEBANK,                       -- House Bank [hbkid]
    HOUSEBANKACCOUNT,                -- Account ID [hktid]
    QUANTITYSIGNCODE,                -- Qty +/- Sign [sign_quantity]
    BANKSTATEMENTSHORTID,            -- Acct Statment [kukey_kk]
    BANKSTATEMENTITEM,               -- Memo Record No. [esnum_eb]
    CASHMANAGEMENTLINKTYPE,          -- Link Type [fqm_linktype]
    CASHMANAGEMENTLINK,              -- Link ID [fqm_linkid]
    CAITMISCREATEDBYPOSTGINTERFACE,  -- Created Int. [xintb_kk]
    CASTATUSOFEUROCONVERSION,        -- Euro status [eurou_kk]
    CAPROFITANALYSISUPDTISDIRECT,    -- CO-PA updated [xcopa_kk]
    CAINVCGGROUPINGKEY,              -- Inv. Grouping [invgr_kk]
    CACTRLFIELDFORACCTASSGMTDISTR,   -- Distribution Status [aasta_kk]
    CAUPDATEMETHODFORFUNDSMGMT,      -- FM Type [fmtyp_kk]
    ORIGINALFINANCIALMGMTAREA,       -- Original FMArea [origfikrs_kk]
    ORIGLYEARFORFINMGMTACCTASSGMT,   -- Original Year [fm_start_of_chain]
    EARMARKEDFUNDSDOCUMENT,          -- Earmarked Funds [kblnr]
    CHARTOFACCOUNTS,                 -- Chart of Accts [ktopl]
    COUNTRY,                         -- Country/Reg. [land1]
    TAXCALCULATIONPROCEDURE,         -- Procedure [kalsm_d]
    PRIMARY KEY (MANDT, CADOCUMENTNUMBER, CAGLITEMNUMBER, DRAFTUUID)
);

Learn More