DFKKINVBILL_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 for billing document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKINVBILL_H_D (
    MANDT,                          -- Client [MANDT]
    CABILLGDOCUMENT,                -- Billing Doc. [BILLDOCNO_KK]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    BUSINESSPARTNER,                -- Bus. Partner [GPART_CI_KK]
    CONTRACTACCOUNT,                -- Contract Acct [VKONT_CI_KK]
    CABILLGTYPE,                    -- Billing Type [BILL_TYPE_KK]
    CABILLGDOCPERIODSTARTDATE,      -- Period Start Date [BILL_PERIOD_FROM_GFN_KK]
    CABILLGDOCPERIODENDDATE,        -- Period End Date [BILL_PERIOD_TO_GFN_KK]
    CABILLGDOCUMENTREVERSALREASON,  -- Reversal Reason [BILL_REVREASON_KK]
    CABILLGISDOCUMENTSIMULATED,     -- Simulation Doc. [SIMULATED_KK]
    CABILLGDOCUMENTEXTERNAL,        -- External Document Number [REFDOCNO_GFN_KK]
    LOGICALSYSTEM,                  -- Logical system [LOGSYS]
    CAAPPLICATIONAREA,              -- ApplicationArea [APPLK_KK]
    CABILLGDOCORIGINPROCESS,        -- Origin [SRCPROCESS_KK]
    CAINVCGSOURCEDOCUMENTTYPE,      -- Source Doc.Type [SRCDOCTYPE_INVBI_KK]
    CAINVCGTECHNICALDOCUMENTTYPE,   -- Technical Document Type [TECHDOCTYPE_GFN_KK]
    CAINVCGDOCUMENTTYPE,            -- Document Type [DOCTYPE_KK]
    CAINVCGTARGETPROCESS,           -- Target Process [TARGPROCESS_KK]
    CAINVCGMASTERDATATYPE,          -- MasterData Type [MDCAT_CI_KK]
    CAINVCGALTVBUSINESSPARTNER,     -- Altv Business Partner [GPART_INV_GFN_KK]
    CAINVCGALTVCONTRACTACCOUNT,     -- Altv Contract Account [VKONT_INV_GFN_KK]
    CABILLGBASEDATE,                -- Baseline Date [BILL_BASEDATE_KK]
    CABILLGCURRENCY,                -- Currency [BILL_CURR_KK]
    CAINVCGCURRENCY,                -- Invoicing Target Currency [INV_CURR_GFN_KK]
    CATAXDETNTYPE,                  -- Tax Calculation [TAX_DET_TYPE_KK]
    CATAXDATETYPE,                  -- Tax Date [TAX_DATE_TYPE_KK]
    CAINVCGCATEGORY,                -- Invoicing Cat. [INV_CATEGORY_KK]
    CAINVCGCONTROLOFINVOICINGUNIT,  -- Invoicing Unit Control [SEPARATE_INV_BITPACK_GFN_KK]
    CAINVCGFIRSTDATE,               -- Invoice From [INVOICE_FIRST_KK]
    CABILLGREVERSALDOCUMENT,        -- Reversal Document [REVERSALBILLDOC_GFN_KK]
    CABILLGREVERSEDDOCUMENT,        -- Reversal For [REVERSEDBILLDOC_GFN_KK]
    CABILLGADJUSTMENTDOCUMENT,      -- Adjustment Document [ADJUSTMENTBILLDOC_GFN_KK]
    CABILLGADJUSTEDDOCUMENT,        -- Adjusted Document [ADJUSTEDBILLDOC_KK]
    CAINVCGCORRECTIONCATEGORY,      -- Invcg Correction Category [CORRCAT_GFN_KK]
    CAINVCGISORDERDELETED,          -- Invoicing Order Deleted [TRIGDELETED_GFN_KK]
    CABILLGHASADDITIONALINVOICE,    -- Info in Invoice [XINFBILL_KK]
    CAINVCGISACCRUALPOSTINGRLVT,    -- Accrual/Deferral Posting [XBILLAC_GFN_KK]
    CABILLGLOCKEDFORINVOICING,      -- Invoicing Lock [INVLOCK_KK]
    CABILLGGRPGOFADDITIONALITEMS,   -- Additional Item Grouping [ADD_GROUP_GFN_KK]
    CABILLGDOCHASREFOBJECTS,        -- Object References Exist [XINVBILL_X_GFN_KK]
    CABILLGDOCUMENTNUMBEROFITEMS,   -- Number of Items [BILLDOC_RECNUM_KK]
    CABLLBLEITMNUMBER,              -- Number of Billable Items [BIT_NUMBER_GFN_KK]
    CREATEDBYUSER,                  -- Created By [CRNAM]
    CABILLGDOCCREATIONDATE,         -- Billed On [BILLCRDATE_KK]
    CABILLGDOCCREATIONTIME,         -- Billed At [BILLCRTIM_KK]
    CABILLGDOCINTERNALNUMBER,       -- Billing Run Number [BILLRUNNO_GFN_KK]
    CABILLGPROCESS,                 -- Billing Process [BILL_PROCESS_KK]
    CABILLGDOCHASPREPAIDITEMS,      -- Prepaid [PREPAID_INCL_KK]
    CABILLGDOCHASREFILLITEMS,       -- Prepaid Refill [PPREFILL_INCL_KK]
    CABILLGDOCHASREVNRECGNITEMS,    -- Rev Deferral [REVREC_INCL_KK]
    CAPARTNERSETTLEMENTRULE,        -- Settlement Rule [PTSRL_KK]
    CABILLGDOCUMENTINVCGSTATUS,     -- Invoicg Status [INVSTATUS_KK]
    CAINVOICINGDOCUMENT,            -- Invoic. Doc. [INVDOCNO_KK]
    CAINVCGCREATIONDATE,            -- Invoiced On [INVDOC_CRDAT_KK]
    CASUBAREAFORPARALLELIZATION,    -- Subarea [KEYPP_KK]
    CAALTVMDORIGINALISINCLUDED,     -- OriglMasterData [ALTMD_ORIG_INCL_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_INVBILL_H_INCL_EEW_PS,    -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, CABILLGDOCUMENT, DRAFTUUID)
);