DB_WCOCOH_I_ST

118 Fields 1 CDS Views

Generated Table for View

DB_WCOCOH_I_ST is an SAP database table in S/4HANA. Generated Table for View. It contains 118 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
WCB_CDS_DB_WCOCOH_I_ST view from CDS-View on DB-View DB_WCOCOH_I_ST

Fields (118)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY num WCB_COCO_NUM Condition Contract
KEY contract_type WCB_CONTRACT_TYPE Contract Type
KEY vend_owner WCB_VEND_OWNER Supplier
KEY cust_owner WCB_CUST_OWNER Customer
KEY reference WCB_REFERENCE Reference
KEY assignment WCB_ASSIGNMENT Assignment
KEY ext_partner WCB_EXTERNAL_PARTNER Ext. Partner
KEY created_by WCB_CREATED_BY Created By
KEY created_on WCB_CREATED_ON Created On
KEY rec_time WCB_REC_TIME Created At
KEY ekorg EKORG Purchasing Org.
KEY ekgrp EKGRP Purch. Group
KEY vkorg VKORG Sales Org.
KEY vtweg VTWEG Distr. Channel
KEY spart SPART Division
KEY zterm DZTERM Pyt Terms
KEY zbd1t DZBDET Payment in
KEY zbd1p DZBD1P CD Percentage 1
KEY zbd2t DZBD2T Days 2
KEY zbd2p DZBD2P CD Percentage 2
KEY zbd3t DZBD3T Days Net
KEY zlsch DZLSCH Pymt Meth.
KEY guid WCB_GUID ConContr. GUID
KEY deact WCB_DEACTIVATED Inactive
KEY date_from WCB_DATE_FROM Valid From
KEY date_to WCB_DATE_TO Valid To
KEY zonlo SYSTZONLO Time Zone
KEY ext_num WCB_EXTERNAL_NUMBER Ext. Identifier
KEY cc_curr WCB_CC_CURR Contract Crrncy
KEY rate WCB_WKURS Exchange Rate
KEY rate_date WCB_WWERT_D Conversion Date
KEY rate_type KURST Exch. Rate Type
KEY vkgrp VKGRP Sales Group
KEY vkbur VKBUR Sales Office
KEY access_type WCB_ACCESS_TYPE Access Type
KEY settl_matnr WB2_SETTLEMENT_MATNR Settlement Material
KEY settl_type_vend WB2_SETTLEMENT_TYPE_VENDOR Settle. Ty. Suppl.
KEY settl_cal_final WB2_SETTLEMENT_CALENDAR Final Settlement
KEY settl_cal_part WB2_SETTLEMENT_CALENDAR_PART Partial Settlement
KEY bukrs BUKRS Company Code
KEY settl_type_cust WB2_SETTLEMENT_TYPE_CUSTOMER Settle. Ty. Customer
KEY ch_name WCB_CHANGED_BY Changed By
KEY ch_date WCB_CHANGED_ON Changed On
KEY ch_time WCB_CHANGED_AT Changed At
KEY extension_cal WB2_EXTENSION_CALENDAR Extension Calendar
KEY pred_cc WCB_PRED_COCO_NUM Predecessor
KEY category WCB_CONTRACT_CATEGORY Contract Category
KEY cc_purpose WCB_CC_PURPOSE Purpose
KEY ext_ref_cat WCB_REF_CAT Ext. Reference Cat.
KEY ext_ref WCB_EXTERNAL_NUMBER2 Ext. Reference
KEY kolif KOLIF Prior Supplier
KEY settl_cal_delta WB2_SETTLEMENT_CALENDAR_DELTA Delta Settlement
KEY bvtab_group WB2_BVTAB_GROUP BusVol Table Group
KEY settl_cal_accr WB2_SETTLEMENT_CALENDAR_ACCR Delta Accruals
KEY af_group WB2_AMOUNT_FIELDS_GROUP Amount Fields Group
KEY settl_meins WB2_SETTLEMENT_MEINS Settlement Unit oM
KEY settl_gewei WB2_SETTLEMENT_GEWEI Settlement Unit oW
KEY settl_voleh WB2_SETTLEMENT_VOLEH Settlement Vol. Unit
KEY settl_punei WB2_SETTLEMENT_PUNEI Settlement Poi. Unit
KEY accruals_upd_req WB2_ACCRUALS_UPDATE_REQ Accruals Update Req
KEY settl_cal_accr_rollo WB2_SETTLEMENT_CAL_ACCR_ROLLO Accr Deferral Cal
KEY _dataaging DATA_TEMPERATURE Data Aging
KEY created_on_tstmp WCB_CREATED_ON_TIMESTAMP Creation Time Stamp
KEY ch_tstmp WCB_CHANGED_ON_TIMESTAMP Changed Time Stamp
KEY stceg WCB_STCEG VAT Reg. No.
KEY person_owner WCB_PERSON_OWNER Personnel Number
KEY afsc_group WB2_AMOUNT_FIELDS_SC_GROUP Amount Fields SC Grp
KEY tax_country WCB_TAX_COUNTRY Partner Tax Ctry/Reg
KEY process_variant WCB_PROCESS_VARIANT Process Variant
KEY ext_ref_item WCB_EXTERNAL_REF_ITEM Ext. Reference Item
KEY coco_det_rel_contr WB2_COCO_DETERM_REL_CONTRACT Relevant for Contract Determination
KEY tax_reporting_country FOT_TAX_COUNTRY Tax Ctry/Reg.
KEY settl_variant WB2_SETTLEMENT_VARIANT Settlement Variant
KEY owner_type WCB_OWNER_TYPE Partner Type
KEY process_category WCB_PROCESS_CATEGORY Process Category
KEY rebate_type WB2_REBATE_TYPE Type
KEY sdm_version WCB_SDM_VERSION_WCOCOH SDM Versioning
KEY num_basic_contract WCB_NUM_BASIC_CONTRACT Basic Contract of Contract
KEY visibility_group WLF_APP_VIS_GRP Element Behavior Group
KEY sont_abbrv_h WLF_BO_NODE_TYPE_ABBRV SAP Object Node Type Abbreviation
KEY semantic_type_h WLF_SEMANTIC_TYPE Semantic Type
KEY settl_type_person WB2_SETTLEMENT_TYPE_PERSON Settl. Ty. Worker
KEY pers_kostl WCB_PERS_KOSTL Worker Cost Center
KEY pers_kokrs WCB_PERS_KOKRS Controlling Area
KEY data_controller WCB_DATA_CONTROLLER Data Controller
KEY ext_guid WCB_EXT_GUID_CC Ext. CC GUID
KEY item_guid WCB_ITEM_GUID Item GUID
KEY eligible_cust WCB_ELIGIBLE_CUST Eligible Cust.
KEY eligible_vendor WCB_ELIGIBLE_VENDOR Eligible Suppl.
KEY list_num WCB_LIST_NUM List Number
KEY exclusion WCB_EXCLUSION Exclude Partner
KEY eligible_plant WERKS_D Plant
KEY quantity WCB_QUANTITY Quantity
KEY unit_of_measure WCB_UNIT_OF_MEASURE Unit
KEY amount WCB_AMOUNT Amount
KEY currency WCB_CURRENCY Currency
KEY material MATNR Material
KEY posnr WCB_POSNR Contract Item
KEY sont_abbrv_i WLF_BO_NODE_TYPE_ABBRV SAP Object Node Type Abbreviation
KEY semantic_type_i WLF_SEMANTIC_TYPE Semantic Type
KEY kostl KOSTL Cost Center
KEY aufnr AUFNR Order
KEY ps_psp_pnr PS_PSP_PNR WBS Element
KEY distribution_ratio WCB_DISTRIBUTION_RATIO Distribution Ratio
KEY date_from_i WCB_DATE_FROM_I Valid From
KEY date_to_i WCB_DATE_TO_I Valid To
KEY deact_i WCB_DEACTIVATED Inactive
KEY guid_i WCB_GUID ConContr. GUID
KEY reference_i WCB_REFERENCE_ELIG_PARTNER Reference
KEY mandt MANDT Client
KEY objnr CRMT_OBJECT_GUID Object GUID
KEY stat CRM_J_STATUS Status
inact CRM_J_INACT Status Inact.
chgnr CRM_J_CHGNR Change Number
ext_guid_i WCB_EXT_GUID_ITEM Ext. Elig. GUID
dataaging_i DATA_TEMPERATURE Data Aging
bukrs_i BUKRS Company Code

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DB_WCOCOH_I_ST (
    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]
    EXT_GUID,               -- Ext. CC GUID [WCB_EXT_GUID_CC]
    ITEM_GUID,              -- Item GUID [WCB_ITEM_GUID]
    ELIGIBLE_CUST,          -- Eligible Cust. [WCB_ELIGIBLE_CUST]
    ELIGIBLE_VENDOR,        -- Eligible Suppl. [WCB_ELIGIBLE_VENDOR]
    LIST_NUM,               -- List Number [WCB_LIST_NUM]
    EXCLUSION,              -- Exclude Partner [WCB_EXCLUSION]
    ELIGIBLE_PLANT,         -- Plant [WERKS_D]
    QUANTITY,               -- Quantity [WCB_QUANTITY]
    UNIT_OF_MEASURE,        -- Unit [WCB_UNIT_OF_MEASURE]
    AMOUNT,                 -- Amount [WCB_AMOUNT]
    CURRENCY,               -- Currency [WCB_CURRENCY]
    MATERIAL,               -- Material [MATNR]
    POSNR,                  -- Contract Item [WCB_POSNR]
    SONT_ABBRV_I,           -- SAP Object Node Type Abbreviation [WLF_BO_NODE_TYPE_ABBRV]
    SEMANTIC_TYPE_I,        -- Semantic Type [WLF_SEMANTIC_TYPE]
    KOSTL,                  -- Cost Center [KOSTL]
    AUFNR,                  -- Order [AUFNR]
    PS_PSP_PNR,             -- WBS Element [PS_PSP_PNR]
    DISTRIBUTION_RATIO,     -- Distribution Ratio [WCB_DISTRIBUTION_RATIO]
    DATE_FROM_I,            -- Valid From [WCB_DATE_FROM_I]
    DATE_TO_I,              -- Valid To [WCB_DATE_TO_I]
    DEACT_I,                -- Inactive [WCB_DEACTIVATED]
    GUID_I,                 -- ConContr. GUID [WCB_GUID]
    REFERENCE_I,            -- Reference [WCB_REFERENCE_ELIG_PARTNER]
    MANDT,                  -- Client [MANDT]
    OBJNR,                  -- Object GUID [CRMT_OBJECT_GUID]
    STAT,                   -- Status [CRM_J_STATUS]
    INACT,                  -- Status Inact. [CRM_J_INACT]
    CHGNR,                  -- Change Number [CRM_J_CHGNR]
    EXT_GUID_I,             -- Ext. Elig. GUID [WCB_EXT_GUID_ITEM]
    DATAAGING_I,            -- Data Aging [DATA_TEMPERATURE]
    BUKRS_I,                -- Company Code [BUKRS]
    PRIMARY KEY (CLIENT, NUM, CONTRACT_TYPE, VEND_OWNER, CUST_OWNER, REFERENCE, ASSIGNMENT, EXT_PARTNER, CREATED_BY, CREATED_ON, REC_TIME, EKORG, EKGRP, VKORG, VTWEG, SPART, ZTERM, ZBD1T, ZBD1P, ZBD2T, ZBD2P, ZBD3T, ZLSCH, GUID, DEACT, DATE_FROM, DATE_TO, ZONLO, EXT_NUM, CC_CURR, RATE, RATE_DATE, RATE_TYPE, VKGRP, VKBUR, ACCESS_TYPE, SETTL_MATNR, SETTL_TYPE_VEND, SETTL_CAL_FINAL, SETTL_CAL_PART, BUKRS, SETTL_TYPE_CUST, CH_NAME, CH_DATE, CH_TIME, EXTENSION_CAL, PRED_CC, CATEGORY, CC_PURPOSE, EXT_REF_CAT, EXT_REF, KOLIF, SETTL_CAL_DELTA, BVTAB_GROUP, SETTL_CAL_ACCR, AF_GROUP, SETTL_MEINS, SETTL_GEWEI, SETTL_VOLEH, SETTL_PUNEI, ACCRUALS_UPD_REQ, SETTL_CAL_ACCR_ROLLO, _DATAAGING, CREATED_ON_TSTMP, CH_TSTMP, STCEG, PERSON_OWNER, AFSC_GROUP, TAX_COUNTRY, PROCESS_VARIANT, EXT_REF_ITEM, COCO_DET_REL_CONTR, TAX_REPORTING_COUNTRY, SETTL_VARIANT, OWNER_TYPE, PROCESS_CATEGORY, REBATE_TYPE, SDM_VERSION, NUM_BASIC_CONTRACT, VISIBILITY_GROUP, SONT_ABBRV_H, SEMANTIC_TYPE_H, SETTL_TYPE_PERSON, PERS_KOSTL, PERS_KOKRS, DATA_CONTROLLER, EXT_GUID, ITEM_GUID, ELIGIBLE_CUST, ELIGIBLE_VENDOR, LIST_NUM, EXCLUSION, ELIGIBLE_PLANT, QUANTITY, UNIT_OF_MEASURE, AMOUNT, CURRENCY, MATERIAL, POSNR, SONT_ABBRV_I, SEMANTIC_TYPE_I, KOSTL, AUFNR, PS_PSP_PNR, DISTRIBUTION_RATIO, DATE_FROM_I, DATE_TO_I, DEACT_I, GUID_I, REFERENCE_I, MANDT, OBJNR, STAT)
);

Learn More