WCOCOH

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: Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WCOCOH (
    CLIENT,                 -- Client [mandt]
    NUM,                    -- Condition Contract [wcb_coco_num]
    CONTRACT_TYPE,          -- Contract Type [wcb_contract_type]
    VEND_OWNER,             -- Supplier [wcb_vend_owner]
    CUST_OWNER,             -- Customer [wcb_cust_owner]
    REFERENCE,              -- Reference [wcb_reference]
    ASSIGNMENT,             -- Assignment [wcb_assignment]
    EXT_PARTNER,            -- Ext. Partner [wcb_external_partner]
    CREATED_BY,             -- Created By [wcb_created_by]
    CREATED_ON,             -- Created On [wcb_created_on]
    REC_TIME,               -- Created At [wcb_rec_time]
    EKORG,                  -- Purchasing Org. [ekorg]
    EKGRP,                  -- Purch. Group [ekgrp]
    VKORG,                  -- Sales Org. [vkorg]
    VTWEG,                  -- Distr. Channel [vtweg]
    SPART,                  -- Division [spart]
    ZTERM,                  -- Pyt Terms [dzterm]
    ZBD1T,                  -- Days 1 [dzbd1t]
    ZBD1P,                  -- CD Percentage 1 [dzbd1p]
    ZBD2T,                  -- Days 2 [dzbd2t]
    ZBD2P,                  -- CD Percentage 2 [dzbd2p]
    ZBD3T,                  -- Days Net [dzbd3t]
    ZLSCH,                  -- Pymt Meth. [dzlsch]
    GUID,                   -- ConContr. GUID [wcb_guid]
    DEACT,                  -- Inactive [wcb_deactivated]
    DATE_FROM,              -- Valid From [wcb_date_from]
    DATE_TO,                -- Valid To [wcb_date_to]
    ZONLO,                  -- Time Zone [systzonlo]
    EXT_NUM,                -- Ext. Identifier [wcb_external_number]
    CC_CURR,                -- Contract Crrncy [wcb_cc_curr]
    RATE,                   -- Exchange Rate [wcb_wkurs]
    RATE_DATE,              -- Conversion Date [wcb_wwert_d]
    RATE_TYPE,              -- Exch. Rate Type [kurst]
    VKGRP,                  -- Sales Group [vkgrp]
    VKBUR,                  -- Sales Office [vkbur]
    ACCESS_TYPE,            -- Access Type [wcb_access_type]
    SETTL_MATNR,            -- Settlement Material [wb2_settlement_matnr]
    SETTL_TYPE_VEND,        -- Settle. Ty. Suppl. [wb2_settlement_type_vendor]
    SETTL_CAL_FINAL,        -- Final Settlement [wb2_settlement_calendar]
    SETTL_CAL_PART,         -- Partial Settlement [wb2_settlement_calendar_part]
    BUKRS,                  -- Company Code [bukrs]
    SETTL_TYPE_CUST,        -- Settle. Ty. Customer [wb2_settlement_type_customer]
    CH_NAME,                -- Changed By [wcb_changed_by]
    CH_DATE,                -- Changed On [wcb_changed_on]
    CH_TIME,                -- Changed At [wcb_changed_at]
    EXTENSION_CAL,          -- Extension Calendar [wb2_extension_calendar]
    PRED_CC,                -- Predecessor [wcb_pred_coco_num]
    CATEGORY,               -- Contract Category [wcb_contract_category]
    CC_PURPOSE,             -- Purpose [wcb_cc_purpose]
    EXT_REF_CAT,            -- Ext. Reference Cat. [wcb_ref_cat]
    EXT_REF,                -- Ext. Reference [wcb_external_number2]
    KOLIF,                  -- Prior Supplier [kolif]
    SETTL_CAL_DELTA,        -- Delta Settlement [wb2_settlement_calendar_delta]
    BVTAB_GROUP,            -- BusVol Table Group [wb2_bvtab_group]
    SETTL_CAL_ACCR,         -- Delta Accruals [wb2_settlement_calendar_accr]
    AF_GROUP,               -- Amount Fields Group [wb2_amount_fields_group]
    SETTL_MEINS,            -- Settlement Unit oM [wb2_settlement_meins]
    SETTL_GEWEI,            -- Settlement Unit oW [wb2_settlement_gewei]
    SETTL_VOLEH,            -- Settlement Vol. Unit [wb2_settlement_voleh]
    SETTL_PUNEI,            -- Settlement Poi. Unit [wb2_settlement_punei]
    ACCRUALS_UPD_REQ,       -- Accruals Update Req [wb2_accruals_update_req]
    SETTL_CAL_ACCR_ROLLO,   -- Accr Deferral Cal [wb2_settlement_cal_accr_rollo]
    _DATAAGING,             -- Data Aging [data_temperature]
    CREATED_ON_TSTMP,       -- Creation Time Stamp [wcb_created_on_timestamp]
    CH_TSTMP,               -- Changed Time Stamp [wcb_changed_on_timestamp]
    STCEG,                  -- VAT Reg. No. [wcb_stceg]
    PERSON_OWNER,           -- Personnel Number [wcb_person_owner]
    AFSC_GROUP,             -- Amount Fields SC Grp [wb2_amount_fields_sc_group]
    TAX_COUNTRY,            -- Partner Tax Ctry/Reg [wcb_tax_country]
    PROCESS_VARIANT,        -- Process Variant [wcb_process_variant]
    EXT_REF_ITEM,           -- Ext. Reference Item [wcb_external_ref_item]
    COCO_DET_REL_CONTR,     -- Relevant for Contract Determination [wb2_coco_determ_rel_contract]
    TAX_REPORTING_COUNTRY,  -- Tax Ctry/Reg. [fot_tax_country]
    SETTL_VARIANT,          -- Settlement Variant [wb2_settlement_variant]
    OWNER_TYPE,             -- Partner Type [wcb_owner_type]
    PROCESS_CATEGORY,       -- Process Category [wcb_process_category]
    REBATE_TYPE,            -- Type [wb2_rebate_type]
    SDM_VERSION,            -- SDM Versioning [wcb_sdm_version_wcocoh]
    NUM_BASIC_CONTRACT,     -- Basic Contract of Contract [wcb_num_basic_contract]
    VISIBILITY_GROUP,       -- Element Behavior Group [wlf_app_vis_grp]
    SONT_ABBRV_H,           -- SAP Object Node Type Abbreviation [wlf_bo_node_type_abbrv]
    SEMANTIC_TYPE_H,        -- Semantic Type [wlf_semantic_type]
    SETTL_TYPE_PERSON,      -- Settl. Ty. Worker [wb2_settlement_type_person]
    PERS_KOSTL,             -- Worker Cost Center [wcb_pers_kostl]
    PERS_KOKRS,             -- Controlling Area [wcb_pers_kokrs]
    DATA_CONTROLLER,        -- Data Controller [wcb_data_controller]
    SETTLMT_CALC_METHOD,    -- wb2_settlmt_calc_method
    PRIMARY KEY (CLIENT, NUM)
);