DFKKINVDOC_H_D

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKINVDOC_H_D (
    MANDT,                           -- Client [MANDT]
    CAINVOICINGDOCUMENT,             -- Invoic. Doc. [INVDOCNO_KK]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    CAAPPLICATIONAREA,               -- ApplicationArea [APPLK_KK]
    CAINVCGPROCESS,                  -- Invoicing Proc. [INV_PROCESS_KK]
    CAINVCGTYPE,                     -- Invoicing Type [INV_TYPE_KK]
    CAINVCGCATEGORY,                 -- Invoicing Cat. [INV_CATEGORY_KK]
    CAINVCGTECHNICALDOCUMENTTYPE,    -- Technical Document Type [TECHDOCTYPE_GFN_KK]
    CAINVCGTARGETPROCESS,            -- Target Process [TARGPROCESS_KK]
    BUSINESSPARTNER,                 -- Bus. Partner [BU_PARTNER]
    CONTRACTACCOUNT,                 -- Contract Acct [VKONT_KK]
    CAINVCGMASTERDATATYPE,           -- MasterData Type [MDCAT_CI_KK]
    ALTVCONTRACTACCTFORCOLLVBILLS,   -- Coll. Bill Acct [ABWVK_KK]
    CASUBSTITUTEDOCUMENTNUMBER,      -- Sub. Doc. [ABWBL_KK]
    CREATEDBYUSER,                   -- Created By [CRNAM]
    CAINVCGCREATIONDATE,             -- Invoiced On [INVDOC_CRDAT_KK]
    CAINVCGCREATIONTIME,             -- Invoiced At [INVDOC_CRTIM_KK]
    CAINVCGDOCCREATIONMODE,          -- CreatnMode [INV_CRMODE_KK]
    CAINVCGNMBROFINVOICINGDOCITEMS,  -- Number of Items [INVDOC_RECNUM_KK]
    CABLLBLEITMNUMBER,               -- Number of Billable Items [BIT_NUMBER_GFN_KK]
    CAINVCGDOCINTERNALNUMBER,        -- Invoicg Run No. [INVRUNNO_KK]
    CARECONCILIATIONKEY,             -- Reconcil. Key [FIKEY_KK]
    CAPOSTINGDATE,                   -- Posting Date [BUDAT_KK]
    DOCUMENTDATE,                    -- Document Date [BLDAT]
    CANETDUEDATE,                    -- Net Due Date [FAEDN_KK]
    CACASHDISCOUNTDUEDATE,           -- Disct Due Date [FAEDS_KK]
    CACASHDISCOUNTRATE,              -- Discount rate [SKTPZ_KK]
    TRANSACTIONCURRENCY,             -- Currency [BLWAE_KK]
    CAAMOUNTINTRANSACTIONCURRENCY,   -- Amount [BETRW_KK]
    CAINVCGISDOCUMENTPOSTED,         -- Document Posted [INV_POSTED_KK]
    CAINVCGISDOCUMENTSIMULATED,      -- Doc. Simulated [INV_SIMULATED_KK]
    CAINVCGISDOCUMENTPRELIMINARY,    -- Preliminary Invoice [INV_PRELIMINARY_GFN_KK]
    CAINVCGPRELIMINARYCATEGORY,      -- Prelim Invoice Category [PRLINV_CAT_GFN_KK]
    CAPRELIMINVCGDOCVALUE,           -- Counter PrlmInv [PRLINV_CNT_KK]
    CAPRELIMINARYINVCGDOCSTATUS,     -- Prelim Invoice Status [PRLINV_STATUS_GFN_KK]
    CAINVCGDOCUMENTREVERSALREASON,   -- Reversal Reason [REVREASON_KK]
    CAINVCGREVERSALDOCUMENT,         -- Reversal Doc. [INV_REVERSALDOC_KK]
    CAINVCGREVERSEDDOCUMENT,         -- Reversal For [INV_REVERSEDDOC_GFN_KK]
    CAINVCGCORRECTIONCATEGORY,       -- Invcg Correction Category [CORRCAT_GFN_KK]
    CAINVCGDOCUMENTPRINTDATE,        -- Print Date [PRINTDAT_KK]
    CAINVCGDOCISLOCKEDFORPRINTING,   -- Printing Lock [PRINTLOCK_KK]
    CAPAYMENTMETHOD,                 -- Payment Method [PYMET_KK]
    CAPAYMENTFORMNUMBER,             -- Payment Form [NRZAS_KK]
    CAPAYMENTCOMPANYCODECOUNTRY,     -- Country/Reg. [LAND1]
    CAINVCGDOCFORMID,                -- Form ID [FORM_ID_KK]
    APPLICATIONFORM,                 -- Forms [FORMNAME_KK]
    FORMIDFORATTACHEDPAYMENTMEDIUM,  -- Form ID [FIDZT]
    CAINVCGDOCUMENTTYPE,             -- Document Type [DOCTYPE_KK]
    CAKEYIDENTIFICATION,             -- Key ID [EXKID_KK]
    CAOFFICIALDOCUMENTNUMBER,        -- Offic. Doc. No. [EXBEL_NO_CONV_KK]
    CAPARTNERSETTLEMENTRULE,         -- Settlement Rule [PTSRL_KK]
    COMPANYCODE,                     -- Company Code [BUKRS]
    BUSINESSPLACE,                   -- Business place [BUPLA]
    CACONTRACT,                      -- Contract [VTREF_KK]
    CASUBAPPLICATION,                -- Subapplication [SUBAP_KK]
    CAINVCGBASEDATE,                 -- Baseline Date [INVOICE_BASEDATE_KK]
    CAINVCGDOCPERIODCATEGORY,        -- Period Category [INVPERCAT_KK]
    CAINVCGDOCPERIODDATE,            -- Invoicing Per. [INVPERIOD_KK]
    CAINVCGDOCPERIODSTARTDATE,       -- Inv. Period Frm [INVPERIOD_FROM_KK]
    CADUNNINGCOUNTER,                -- Dunning counter [MAZAE_KK]
    CAINVCGDOCHASCHARGEORDISCITEMS,  -- Charge/Discount Exists [CHGDOC_EX_GFN_KK]
    CAINVCGDOCHASCONTROLDOC,         -- Clrfctn Case Control Doc [INV_CFCSIMULATED_GFN_KK]
    CAINVCGBOLLOTAXPOSTSTATUS,       -- Bollo Posted [INV_BOLLOTAX_KK]
    CAINVCGDOCISPARTOFLIST,          -- Inv. Subdoc. [XSUBINV_KK]
    CAINVCGDOCHASOBJECTRELATION,     -- ObjRel. Exist [XINVDOC_X_KK]
    CAINVCGDOCHASSEPAPRENOTIF,       -- Pre-Notif. [INV_SEPA_PRENOT_KK]
    CAINVCGDOCEXTERNAL,              -- External Invoicing Doc [EXT_INVDOCNO_GFN_KK]
    CAINVCGADJUSTMENTDOCUMENT,       -- Adjustment Doc. [ADJUSTMENTINVDOC_KK]
    CAINVCGADJUSTEDDOCUMENT,         -- DocToBeAdjusted [ADJUSTEDINVDOC_KK]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_INVDOC_H_INCL_EEW_PS,      -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, CAINVOICINGDOCUMENT, DRAFTUUID)
);