DFKKKO_D

Transparent Table Application Table
49 Fields 1 CDS Views

Draft table for entity R_CADocumentTP

DFKKKO_D is an SAP database table in S/4HANA. Draft table for entity R_CADocumentTP. It contains 49 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CADocumentDraft view_entity from BASIC Contract Accounting Document - Draft

Fields (49)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY cadocumentnumber opbel_kk Document Number
KEY draftuuid sdraft_uuid Draft Document ID
careconciliationkey fikey_kk Reconcil. Key
caapplicationarea applk_kk ApplicationArea
cadocumenttype blart_kk Document Type
cadocumentorigincode herkf_kk Document Origin
createdbyuser ernam Created By
creationdate cpudt Entered On
creationtime cputm Entered at
transactioncurrency blwae_kk Currency
documentdate bldat Document Date
capostingdate budat_kk Posting Date
exchangeratedate wwert_d Translatn Date
careferencedocument xblnr_kk Reference
careturnreason rlgrd_kk Return Reason
capostingreason bugrd_kk Posting Reason
caseparatedociscreatedingl xeibh_kk Single Document
referencedocumenttype awtyp Ref. procedure
originalreferencedocument awkey Reference Key
careverseddocumentnumber stbel_kk Rev. Doc. For
cadocumentclass bltyp_kk Document Class
caclearinginformation aginf_kk Clearing Info
cataxcompanycode stbuk_kk Tax comp. code
careversaldocumentnumber storb_kk Revers.document
cadocumentsupplements appdx_kk Doc supps
logicalsystem awsys Logical System
cadocumentversion versn_kk Version
caworkflowcheckreason c4eye_kk Check Reason
caworkflowcheckprocess c4eyp_kk Process
cadocumenttransactionclass tatyp_kk Transact.type
cadocumenttypeforgltransfer hbbla_kk Tfr Doc. Type
cadoccontainscashflowitems xcsha_kk Cash Flow
castoragelocationoftaxsuplmnt utloc_ut_kk Storage Location
cataxcodewasexchanged xtxch_kk New Tax Code
taxreportingdate vatdate_kk Tax Report Date
taxfulfillmentdate vatdate2_kk Tax Settlement Date
carequestedperiodforgltransfer wnper_kk Special Period
isindividualposting xsing_kk Indiv. Posting
cadocumentisaged xdaag_kk Data Aging
lastchangedate aedat Changed On
lastchangetime aetim_kk Time
cainvcgrefpostingdoctype cadoctype_kk Ref. Doc. Type
cainvoicingdocument invdocno_kk Invoic. Doc.
ca1stcountryspecificreference fkk_glo_ref1_hd Reference
cafirstcountryspecificdate fkk_glo_dat1_hd Date
caclassificationkey opord_kk Classif. Key
creationdatetime vdm_creationdatetime Created On
lastchangedatetime vdm_lastchangedon Last Changed On

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_CADocumentTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKKO_D (
    MANDT,                           -- Client [mandt]
    CADOCUMENTNUMBER,                -- Document Number [opbel_kk]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    CARECONCILIATIONKEY,             -- Reconcil. Key [fikey_kk]
    CAAPPLICATIONAREA,               -- ApplicationArea [applk_kk]
    CADOCUMENTTYPE,                  -- Document Type [blart_kk]
    CADOCUMENTORIGINCODE,            -- Document Origin [herkf_kk]
    CREATEDBYUSER,                   -- Created By [ernam]
    CREATIONDATE,                    -- Entered On [cpudt]
    CREATIONTIME,                    -- Entered at [cputm]
    TRANSACTIONCURRENCY,             -- Currency [blwae_kk]
    DOCUMENTDATE,                    -- Document Date [bldat]
    CAPOSTINGDATE,                   -- Posting Date [budat_kk]
    EXCHANGERATEDATE,                -- Translatn Date [wwert_d]
    CAREFERENCEDOCUMENT,             -- Reference [xblnr_kk]
    CARETURNREASON,                  -- Return Reason [rlgrd_kk]
    CAPOSTINGREASON,                 -- Posting Reason [bugrd_kk]
    CASEPARATEDOCISCREATEDINGL,      -- Single Document [xeibh_kk]
    REFERENCEDOCUMENTTYPE,           -- Ref. procedure [awtyp]
    ORIGINALREFERENCEDOCUMENT,       -- Reference Key [awkey]
    CAREVERSEDDOCUMENTNUMBER,        -- Rev. Doc. For [stbel_kk]
    CADOCUMENTCLASS,                 -- Document Class [bltyp_kk]
    CACLEARINGINFORMATION,           -- Clearing Info [aginf_kk]
    CATAXCOMPANYCODE,                -- Tax comp. code [stbuk_kk]
    CAREVERSALDOCUMENTNUMBER,        -- Revers.document [storb_kk]
    CADOCUMENTSUPPLEMENTS,           -- Doc supps [appdx_kk]
    LOGICALSYSTEM,                   -- Logical System [awsys]
    CADOCUMENTVERSION,               -- Version [versn_kk]
    CAWORKFLOWCHECKREASON,           -- Check Reason [c4eye_kk]
    CAWORKFLOWCHECKPROCESS,          -- Process [c4eyp_kk]
    CADOCUMENTTRANSACTIONCLASS,      -- Transact.type [tatyp_kk]
    CADOCUMENTTYPEFORGLTRANSFER,     -- Tfr Doc. Type [hbbla_kk]
    CADOCCONTAINSCASHFLOWITEMS,      -- Cash Flow [xcsha_kk]
    CASTORAGELOCATIONOFTAXSUPLMNT,   -- Storage Location [utloc_ut_kk]
    CATAXCODEWASEXCHANGED,           -- New Tax Code [xtxch_kk]
    TAXREPORTINGDATE,                -- Tax Report Date [vatdate_kk]
    TAXFULFILLMENTDATE,              -- Tax Settlement Date [vatdate2_kk]
    CAREQUESTEDPERIODFORGLTRANSFER,  -- Special Period [wnper_kk]
    ISINDIVIDUALPOSTING,             -- Indiv. Posting [xsing_kk]
    CADOCUMENTISAGED,                -- Data Aging [xdaag_kk]
    LASTCHANGEDATE,                  -- Changed On [aedat]
    LASTCHANGETIME,                  -- Time [aetim_kk]
    CAINVCGREFPOSTINGDOCTYPE,        -- Ref. Doc. Type [cadoctype_kk]
    CAINVOICINGDOCUMENT,             -- Invoic. Doc. [invdocno_kk]
    CA1STCOUNTRYSPECIFICREFERENCE,   -- Reference [fkk_glo_ref1_hd]
    CAFIRSTCOUNTRYSPECIFICDATE,      -- Date [fkk_glo_dat1_hd]
    CACLASSIFICATIONKEY,             -- Classif. Key [opord_kk]
    CREATIONDATETIME,                -- Created On [vdm_creationdatetime]
    LASTCHANGEDATETIME,              -- Last Changed On [vdm_lastchangedon]
    PRIMARY KEY (MANDT, CADOCUMENTNUMBER, DRAFTUUID)
);

Learn More