WB2_D_SETTL_CAL

Transparent Table Application Table
17 Fields 2 CDS Views

Condition Contract: Settlement Calendar

WB2_D_SETTL_CAL is an SAP database table in S/4HANA. Condition Contract: Settlement Calendar. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_CndnDocSettlmtCal view_entity from BASIC Settlmt Calendar of Condition Document
view_settl_cal_p view from Settlement Calendar

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY num WCB_COCO_NUM Condition Contract
KEY settl_date WB2_SETTLEMENT_DATE Settlement Date
KEY settl_date_seq_id WB2_SETTLEMENT_DATE_SEQ_ID Settlement Date ID
settl_date_type WB2_SETTLEMENT_DATE_TYPE Settlement Date Type
guid WB2_SETTL_CAL_GUID Settl. Calendar GUID
ref_settl_date WB2_REF_SETTLEMENT_DATE Reference Date
ref_settl_date_seq_id WB2_REF_SETTLEMENT_DATE_SEQ_ID Ref Settl Date ID
settl_exec_date WB2_SETTLEMENT_EXECUTION_DATE Execution Date
busvol_date_from WB2_BUSVOL_DATE_FROM BusVol Date From
busvol_date_to WB2_BUSVOL_DATE_TO BusVol Date To
settl_date_usage WB2_SETTL_DATE_USAGE Settl. Date Usage
valdt WB2_VALDT_SETTL_CAL Fixed Value Date
_dataaging DATA_TEMPERATURE Data Aging
sont_abbrv_c WLF_BO_NODE_TYPE_ABBRV SAP Object Node Type Abbreviation
semantic_type_c WLF_SEMANTIC_TYPE Semantic Type
ext_guid WCB_EXT_GUID_CAL Ext. Cal. GUID

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.

-- Condition Contract: Settlement Calendar
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WB2_D_SETTL_CAL (
    MANDT,                  -- Client [MANDT]
    NUM,                    -- Condition Contract [WCB_COCO_NUM]
    SETTL_DATE,             -- Settlement Date [WB2_SETTLEMENT_DATE]
    SETTL_DATE_SEQ_ID,      -- Settlement Date ID [WB2_SETTLEMENT_DATE_SEQ_ID]
    SETTL_DATE_TYPE,        -- Settlement Date Type [WB2_SETTLEMENT_DATE_TYPE]
    GUID,                   -- Settl. Calendar GUID [WB2_SETTL_CAL_GUID]
    REF_SETTL_DATE,         -- Reference Date [WB2_REF_SETTLEMENT_DATE]
    REF_SETTL_DATE_SEQ_ID,  -- Ref Settl Date ID [WB2_REF_SETTLEMENT_DATE_SEQ_ID]
    SETTL_EXEC_DATE,        -- Execution Date [WB2_SETTLEMENT_EXECUTION_DATE]
    BUSVOL_DATE_FROM,       -- BusVol Date From [WB2_BUSVOL_DATE_FROM]
    BUSVOL_DATE_TO,         -- BusVol Date To [WB2_BUSVOL_DATE_TO]
    SETTL_DATE_USAGE,       -- Settl. Date Usage [WB2_SETTL_DATE_USAGE]
    VALDT,                  -- Fixed Value Date [WB2_VALDT_SETTL_CAL]
    _DATAAGING,             -- Data Aging [DATA_TEMPERATURE]
    SONT_ABBRV_C,           -- SAP Object Node Type Abbreviation [WLF_BO_NODE_TYPE_ABBRV]
    SEMANTIC_TYPE_C,        -- Semantic Type [WLF_SEMANTIC_TYPE]
    EXT_GUID,               -- Ext. Cal. GUID [WCB_EXT_GUID_CAL]
    PRIMARY KEY (MANDT, NUM, SETTL_DATE, SETTL_DATE_SEQ_ID)
);

Learn More