WCOCOH

Transparent Table Application Table
88 Fields 5 CDS Views

Condition Contract: Header

WCOCOH is an SAP database table in S/4HANA. Condition Contract: Header. It contains 88 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_ConditionContract view_entity from EXTENSION Extension View for Condition Contract
P_CndnContrText view from BASIC
R_ConditionDocument view_entity from BASIC Condition Document
view_cc_head_p view from Header Related Data of Condition Contract
WCB_CDS_WCOCOH_DPP_03 view from CDS-View on WCOCOH with Asso for DPP; Act 03

Fields (88)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY num WCB_COCO_NUM Condition Contract
contract_type WCB_CONTRACT_TYPE Contract Type
vend_owner WCB_VEND_OWNER Supplier
cust_owner WCB_CUST_OWNER Customer
reference WCB_REFERENCE Reference
assignment WCB_ASSIGNMENT Assignment
ext_partner WCB_EXTERNAL_PARTNER Ext. Partner
created_by WCB_CREATED_BY Created By
created_on WCB_CREATED_ON Created On
rec_time WCB_REC_TIME Created At
ekorg EKORG Purchasing Org.
ekgrp EKGRP Purch. Group
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
spart SPART Division
zterm DZTERM Pyt Terms
zbd1t DZBDET Payment in
zbd1p DZBD1P CD Percentage 1
zbd2t DZBD2T Days 2
zbd2p DZBD2P CD Percentage 2
zbd3t DZBD3T Days Net
zlsch DZLSCH Pymt Meth.
guid WCB_GUID ConContr. GUID
deact WCB_DEACTIVATED Inactive
date_from WCB_DATE_FROM Valid From
date_to WCB_DATE_TO Valid To
zonlo SYSTZONLO Time Zone
ext_num WCB_EXTERNAL_NUMBER Ext. Identifier
cc_curr WCB_CC_CURR Contract Crrncy
rate WCB_WKURS Exchange Rate
rate_date WCB_WWERT_D Conversion Date
rate_type KURST Exch. Rate Type
vkgrp VKGRP Sales Group
vkbur VKBUR Sales Office
access_type WCB_ACCESS_TYPE Access Type
settl_matnr WB2_SETTLEMENT_MATNR Settlement Material
settl_type_vend WB2_SETTLEMENT_TYPE_VENDOR Settle. Ty. Suppl.
settl_cal_final WB2_SETTLEMENT_CALENDAR Final Settlement
settl_cal_part WB2_SETTLEMENT_CALENDAR_PART Partial Settlement
bukrs BUKRS Company Code
settl_type_cust WB2_SETTLEMENT_TYPE_CUSTOMER Settle. Ty. Customer
ch_name WCB_CHANGED_BY Changed By
ch_date WCB_CHANGED_ON Changed On
ch_time WCB_CHANGED_AT Changed At
extension_cal WB2_EXTENSION_CALENDAR Extension Calendar
pred_cc WCB_PRED_COCO_NUM Predecessor
category WCB_CONTRACT_CATEGORY Contract Category
cc_purpose WCB_CC_PURPOSE Purpose
ext_ref_cat WCB_REF_CAT Ext. Reference Cat.
ext_ref WCB_EXTERNAL_NUMBER2 Ext. Reference
kolif KOLIF Prior Supplier
settl_cal_delta WB2_SETTLEMENT_CALENDAR_DELTA Delta Settlement
bvtab_group WB2_BVTAB_GROUP BusVol Table Group
settl_cal_accr WB2_SETTLEMENT_CALENDAR_ACCR Delta Accruals
af_group WB2_AMOUNT_FIELDS_GROUP Amount Fields Group
settl_meins WB2_SETTLEMENT_MEINS Settlement Unit oM
settl_gewei WB2_SETTLEMENT_GEWEI Settlement Unit oW
settl_voleh WB2_SETTLEMENT_VOLEH Settlement Vol. Unit
settl_punei WB2_SETTLEMENT_PUNEI Settlement Poi. Unit
accruals_upd_req WB2_ACCRUALS_UPDATE_REQ Accruals Update Req
settl_cal_accr_rollo WB2_SETTLEMENT_CAL_ACCR_ROLLO Accr Deferral Cal
_dataaging DATA_TEMPERATURE Data Aging
created_on_tstmp WCB_CREATED_ON_TIMESTAMP Creation Time Stamp
ch_tstmp WCB_CHANGED_ON_TIMESTAMP Changed Time Stamp
stceg WCB_STCEG VAT Reg. No.
person_owner WCB_PERSON_OWNER Personnel Number
afsc_group WB2_AMOUNT_FIELDS_SC_GROUP Amount Fields SC Grp
tax_country WCB_TAX_COUNTRY Partner Tax Ctry/Reg
process_variant WCB_PROCESS_VARIANT Process Variant
ext_ref_item WCB_EXTERNAL_REF_ITEM Ext. Reference Item
coco_det_rel_contr WB2_COCO_DETERM_REL_CONTRACT Relevant for Contract Determination
tax_reporting_country FOT_TAX_COUNTRY Tax Ctry/Reg.
settl_variant WB2_SETTLEMENT_VARIANT Settlement Variant
owner_type WCB_OWNER_TYPE Partner Type
process_category WCB_PROCESS_CATEGORY Process Category
rebate_type WB2_REBATE_TYPE Type
sdm_version WCB_SDM_VERSION_WCOCOH SDM Versioning
num_basic_contract WCB_NUM_BASIC_CONTRACT Basic Contract of Contract
visibility_group WLF_APP_VIS_GRP Element Behavior Group
sont_abbrv_h WLF_BO_NODE_TYPE_ABBRV SAP Object Node Type Abbreviation
semantic_type_h WLF_SEMANTIC_TYPE Semantic Type
settl_type_person WB2_SETTLEMENT_TYPE_PERSON Settl. Ty. Worker
pers_kostl WCB_PERS_KOSTL Worker Cost Center
pers_kokrs WCB_PERS_KOKRS Controlling Area
data_controller WCB_DATA_CONTROLLER Data Controller
dummy_wcocoh_incl_eew_ps CFD_DUMMY Dummy
ext_guid WCB_EXT_GUID_CC Ext. CC 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: 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,                     -- Payment in [DZBDET]
    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]
    DUMMY_WCOCOH_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    EXT_GUID,                  -- Ext. CC GUID [WCB_EXT_GUID_CC]
    PRIMARY KEY (CLIENT, NUM)
);

Learn More