DFKKBIX_BIP_H_D2

Transparent Table Application Table
41 Fields 2 CDS Views

Draft table for entity R_CABILLGPLNTP

DFKKBIX_BIP_H_D2 is an SAP database table in S/4HANA. Draft table for entity R_CABILLGPLNTP. It contains 41 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CABillgPlnDraft view_entity from EXTENSION Abrechnungsplan Entwurf Erweiterung
R_CABillgPlnDraft view_entity from BASIC Billing Plan Draft

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cabillgplnnumber BILLPLANNO_KK Billing Plan
KEY draftuuid SDRAFT_UUID Draft Document ID
cabillgplncategory BIPCAT_GFN_KK Billing Plan Category
cabillgplntype BIPTYPE_KK Billing Plan Type
cabillgplnstatus BIP_STATUS_KK Status
cabillgplnstartdate BIP_VALID_FROM_KK Valid From
cabillgplnenddate BIP_VALID_TO_KK Valid To
cabillgplnlastrequestdate BIP_REQUEST_DATE_LAST_KK Last Request
cabillgplnnextrequestdate BIP_REQUEST_DATE_NEXT_KK Next Request
cabillgplndescription BIPTEXT_KK Name
cabillgplnexternalreference BIPREF_KK Ext. Reference
logicalsystem LOGSYS Logical system
caapplicationarea APPLK_KK ApplicationArea
businesspartner BU_PARTNER Bus. Partner
contractaccount VKONT_KK Contract Acct
cainvcgmasterdatatype MDCAT_CI_KK MasterData Type
cacontract VTREF_KK Contract
caprovidercontractitemuuid VTPID_KK Contr.Item ID
casubapplication SUBAP_KK Subapplication
camasteragreement MAKEY_KK Master Agrmt
cainvcgoffsettingreferencekey INV_OFFSET_REFID_KK Offsetting Ref.
cabillgplncreatedbyuser BIP_CRNAM_KK Created By
cabillgplncreationdate BIP_CRDAT_KK Created On
cabillgplncreationtime BIP_CRTIM_KK Created At
cabillgplnchangedbyuser BIP_CHNAM_KK Changed By
cabillgplnchangedate BIP_CHDAT_KK Changed On
cabillgplnchangetime BIP_CHTIM_KK Changed at
cabillgplncreationmode BIP_CRMODE_KK Creation Mode
cabillgplnnumberbllbleitm BIP_BITNUM_KK Number of Items
cabillgplncompletiondate BIP_COMPLETION_DATE_KK Completed On
cabillgplnistemplate BIP_XTEMP_KK Template
cabillgplnversion BIP_VERSION_KK Version
lastchangedatetime CHANGEDATETIME Last Changed
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes
dummy_billplan_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.

-- Draft table for entity R_CABILLGPLNTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKBIX_BIP_H_D2 (
    MANDT,                          -- Client [MANDT]
    CABILLGPLNNUMBER,               -- Billing Plan [BILLPLANNO_KK]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    CABILLGPLNCATEGORY,             -- Billing Plan Category [BIPCAT_GFN_KK]
    CABILLGPLNTYPE,                 -- Billing Plan Type [BIPTYPE_KK]
    CABILLGPLNSTATUS,               -- Status [BIP_STATUS_KK]
    CABILLGPLNSTARTDATE,            -- Valid From [BIP_VALID_FROM_KK]
    CABILLGPLNENDDATE,              -- Valid To [BIP_VALID_TO_KK]
    CABILLGPLNLASTREQUESTDATE,      -- Last Request [BIP_REQUEST_DATE_LAST_KK]
    CABILLGPLNNEXTREQUESTDATE,      -- Next Request [BIP_REQUEST_DATE_NEXT_KK]
    CABILLGPLNDESCRIPTION,          -- Name [BIPTEXT_KK]
    CABILLGPLNEXTERNALREFERENCE,    -- Ext. Reference [BIPREF_KK]
    LOGICALSYSTEM,                  -- Logical system [LOGSYS]
    CAAPPLICATIONAREA,              -- ApplicationArea [APPLK_KK]
    BUSINESSPARTNER,                -- Bus. Partner [BU_PARTNER]
    CONTRACTACCOUNT,                -- Contract Acct [VKONT_KK]
    CAINVCGMASTERDATATYPE,          -- MasterData Type [MDCAT_CI_KK]
    CACONTRACT,                     -- Contract [VTREF_KK]
    CAPROVIDERCONTRACTITEMUUID,     -- Contr.Item ID [VTPID_KK]
    CASUBAPPLICATION,               -- Subapplication [SUBAP_KK]
    CAMASTERAGREEMENT,              -- Master Agrmt [MAKEY_KK]
    CAINVCGOFFSETTINGREFERENCEKEY,  -- Offsetting Ref. [INV_OFFSET_REFID_KK]
    CABILLGPLNCREATEDBYUSER,        -- Created By [BIP_CRNAM_KK]
    CABILLGPLNCREATIONDATE,         -- Created On [BIP_CRDAT_KK]
    CABILLGPLNCREATIONTIME,         -- Created At [BIP_CRTIM_KK]
    CABILLGPLNCHANGEDBYUSER,        -- Changed By [BIP_CHNAM_KK]
    CABILLGPLNCHANGEDATE,           -- Changed On [BIP_CHDAT_KK]
    CABILLGPLNCHANGETIME,           -- Changed at [BIP_CHTIM_KK]
    CABILLGPLNCREATIONMODE,         -- Creation Mode [BIP_CRMODE_KK]
    CABILLGPLNNUMBERBLLBLEITM,      -- Number of Items [BIP_BITNUM_KK]
    CABILLGPLNCOMPLETIONDATE,       -- Completed On [BIP_COMPLETION_DATE_KK]
    CABILLGPLNISTEMPLATE,           -- Template [BIP_XTEMP_KK]
    CABILLGPLNVERSION,              -- Version [BIP_VERSION_KK]
    LASTCHANGEDATETIME,             -- Last Changed [CHANGEDATETIME]
    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_BILLPLAN_H_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, CABILLGPLNNUMBER, DRAFTUUID)
);

Learn More