DFKKINVBILL_H

Transparent Table Application Table
56 Fields 3 CDS Views

Billing Document Header

DFKKINVBILL_H is an SAP database table in S/4HANA. Billing Document Header. It contains 56 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_CABillgDocHeader view_entity from EXTENSION Abrechnungsbelegkopf Erweiterung
I_CABillgDocHeader view_entity from BASIC Abrechnungsbelegkopf
SHSM_DFKKINVBILL_H view_entity from nach Belegkopfdaten

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY billdocno BILLDOCNO_KK Billing Doc.
refdocno REFDOCNO_KK Ext. Doc. No.
log_system LOGSYS Logical system
applk APPLK_KK ApplicationArea
srcprocess SRCPROCESS_KK Origin
srcdoctype SRCDOCTYPE_INVBI_KK Source Doc.Type
techdoctype TECHDOCTYPE_KK Tech. Doc. Type
doctype DOCTYPE_KK Document Type
targprocess TARGPROCESS_KK Target Process
gpart GPART_CI_KK Bus. Partner
vkont VKONT_CI_KK Contract Acct
mdcat MDCAT_CI_KK MasterData Type
gpart_inv GPART_INV_KK Alt. Partner
vkont_inv VKONT_INV_KK Alt.Ctr.Acct
date_from BILL_PERIOD_FROM_KK Start Doc. Per.
date_to BILL_PERIOD_TO_KK End Doc. Period
bill_basedate BILL_BASEDATE_KK Baseline Date
simulated SIMULATED_KK Simulation Doc.
bill_curr BILL_CURR_KK Currency
inv_curr INV_CURR_KK Target Currency
tax_det_type TAX_DET_TYPE_KK Tax Calculation
tax_date_type TAX_DATE_TYPE_KK Tax Date
inv_category INV_CATEGORY_KK Invoicing Cat.
separate_inv SEPARATE_INV_KK Inv. Unit Cntrl
invoice_first INVOICE_FIRST_KK Invoice From
revreason BILL_REVREASON_KK Reversal Reason
reversaldoc REVERSALBILLDOC_KK Reversal Doc. No.
reverseddoc REVERSEDBILLDOC_KK Rev. Doc. For
adjustmentdoc ADJUSTMENTBILLDOC_KK Adjustment Doc.
adjusteddoc ADJUSTEDBILLDOC_KK Adjusted Document
corrcat CORRCAT_KK Inv.Corr.Cat.
trigdeleted TRIGDELETED_KK Inv.Req.Deleted
xinfbill XINFBILL_KK Info in Invoice
xbillac XBILLAC_KK Acc/DefPosting
invlock INVLOCK_KK Invoicing Lock
invstatus INVSTATUS_KK Invoicg Status
invdocno INVDOCNO_KK Invoic. Doc.
invcrdate INVDOC_CRDAT_KK Invoiced On
add_group ADD_GROUP_KK Add. Item Grpg
xinvbill_x XINVBILL_X_KK Obj.Ref. Exist
recnum BILLDOC_RECNUM_KK Number of Items
bit_number BIT_NUMBER_KK Number of Items
keypp KEYPP_KK Subarea
crname CRNAM Created By
crdate BILLCRDATE_KK Billed On
crtime BILLCRTIM_KK Billed At
billrunno BILLRUNNO_KK No. of Bill.Run
bill_process BILL_PROCESS_KK Billing Process
bill_type BILL_TYPE_KK Billing Type
prepaid_incl PREPAID_INCL_KK Prepaid
pprefill_incl PPREFILL_INCL_KK Prepaid Refill
revrec_incl REVREC_INCL_KK Rev Deferral
altmd_orig_incl ALTMD_ORIG_INCL_KK OriglMasterData
ptsrl PTSRL_KK Settlement Rule
dummy_invbill_h_incl_eew_ps CFD_DUMMY Dummy

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.

-- Billing Document Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKINVBILL_H (
    MANDT,                        -- Client [MANDT]
    BILLDOCNO,                    -- Billing Doc. [BILLDOCNO_KK]
    REFDOCNO,                     -- Ext. Doc. No. [REFDOCNO_KK]
    LOG_SYSTEM,                   -- Logical system [LOGSYS]
    APPLK,                        -- ApplicationArea [APPLK_KK]
    SRCPROCESS,                   -- Origin [SRCPROCESS_KK]
    SRCDOCTYPE,                   -- Source Doc.Type [SRCDOCTYPE_INVBI_KK]
    TECHDOCTYPE,                  -- Tech. Doc. Type [TECHDOCTYPE_KK]
    DOCTYPE,                      -- Document Type [DOCTYPE_KK]
    TARGPROCESS,                  -- Target Process [TARGPROCESS_KK]
    GPART,                        -- Bus. Partner [GPART_CI_KK]
    VKONT,                        -- Contract Acct [VKONT_CI_KK]
    MDCAT,                        -- MasterData Type [MDCAT_CI_KK]
    GPART_INV,                    -- Alt. Partner [GPART_INV_KK]
    VKONT_INV,                    -- Alt.Ctr.Acct [VKONT_INV_KK]
    DATE_FROM,                    -- Start Doc. Per. [BILL_PERIOD_FROM_KK]
    DATE_TO,                      -- End Doc. Period [BILL_PERIOD_TO_KK]
    BILL_BASEDATE,                -- Baseline Date [BILL_BASEDATE_KK]
    SIMULATED,                    -- Simulation Doc. [SIMULATED_KK]
    BILL_CURR,                    -- Currency [BILL_CURR_KK]
    INV_CURR,                     -- Target Currency [INV_CURR_KK]
    TAX_DET_TYPE,                 -- Tax Calculation [TAX_DET_TYPE_KK]
    TAX_DATE_TYPE,                -- Tax Date [TAX_DATE_TYPE_KK]
    INV_CATEGORY,                 -- Invoicing Cat. [INV_CATEGORY_KK]
    SEPARATE_INV,                 -- Inv. Unit Cntrl [SEPARATE_INV_KK]
    INVOICE_FIRST,                -- Invoice From [INVOICE_FIRST_KK]
    REVREASON,                    -- Reversal Reason [BILL_REVREASON_KK]
    REVERSALDOC,                  -- Reversal Doc. No. [REVERSALBILLDOC_KK]
    REVERSEDDOC,                  -- Rev. Doc. For [REVERSEDBILLDOC_KK]
    ADJUSTMENTDOC,                -- Adjustment Doc. [ADJUSTMENTBILLDOC_KK]
    ADJUSTEDDOC,                  -- Adjusted Document [ADJUSTEDBILLDOC_KK]
    CORRCAT,                      -- Inv.Corr.Cat. [CORRCAT_KK]
    TRIGDELETED,                  -- Inv.Req.Deleted [TRIGDELETED_KK]
    XINFBILL,                     -- Info in Invoice [XINFBILL_KK]
    XBILLAC,                      -- Acc/DefPosting [XBILLAC_KK]
    INVLOCK,                      -- Invoicing Lock [INVLOCK_KK]
    INVSTATUS,                    -- Invoicg Status [INVSTATUS_KK]
    INVDOCNO,                     -- Invoic. Doc. [INVDOCNO_KK]
    INVCRDATE,                    -- Invoiced On [INVDOC_CRDAT_KK]
    ADD_GROUP,                    -- Add. Item Grpg [ADD_GROUP_KK]
    XINVBILL_X,                   -- Obj.Ref. Exist [XINVBILL_X_KK]
    RECNUM,                       -- Number of Items [BILLDOC_RECNUM_KK]
    BIT_NUMBER,                   -- Number of Items [BIT_NUMBER_KK]
    KEYPP,                        -- Subarea [KEYPP_KK]
    CRNAME,                       -- Created By [CRNAM]
    CRDATE,                       -- Billed On [BILLCRDATE_KK]
    CRTIME,                       -- Billed At [BILLCRTIM_KK]
    BILLRUNNO,                    -- No. of Bill.Run [BILLRUNNO_KK]
    BILL_PROCESS,                 -- Billing Process [BILL_PROCESS_KK]
    BILL_TYPE,                    -- Billing Type [BILL_TYPE_KK]
    PREPAID_INCL,                 -- Prepaid [PREPAID_INCL_KK]
    PPREFILL_INCL,                -- Prepaid Refill [PPREFILL_INCL_KK]
    REVREC_INCL,                  -- Rev Deferral [REVREC_INCL_KK]
    ALTMD_ORIG_INCL,              -- OriglMasterData [ALTMD_ORIG_INCL_KK]
    PTSRL,                        -- Settlement Rule [PTSRL_KK]
    DUMMY_INVBILL_H_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, BILLDOCNO)
);

Learn More