WB2_D_COMSUB

Transparent Table Application Table
32 Fields 7 CDS Views

Trading Contract: commodity sub items

WB2_D_COMSUB is an SAP database table in S/4HANA. Trading Contract: commodity sub items. It contains 32 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_ACMApplDtmnAprvdContr view_entity from BASIC ACM App Determine Approved Contract
I_ACMCommodityItem view_entity from BASIC Interface for wb2dcomsub data
I_ACMTradingContractSubitem view from BASIC Trading Contract: commodity sub items
I_ACMTrdgContrCommoditySubItem view from BASIC Commodity Sub Item Data
I_PrepayTrdgContrItmQtyData view_entity inner BASIC ACM Quantity Shadow Item Data
P_ACMContractDeliveryPeriod view_entity from BASIC Contact Delivery Period
P_WBHK_COM_ITEM_ValueHelp view from BASIC

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY tkonn TKONN Trading Contract
KEY tposn TPOSN Item Number
KEY side WLF_PR_SIDE Side
KEY tposn_com WLF_TPOSN_COM Com. item num.
quantity WLF_ITEM_QUANTITY Item Quantity
unit WLF_UNIT Unit
date_from WLF_DATE_FROM Date From
date_to WLF_DATE_TO Date To
future WLF_FUTURE Future
com_guid WLF_COM_GUID commodity GUID
cr_name ERNAM Created By
cr_date ERDAT Created On
cr_time WLF_ERZEIT Created At
ch_name AENAM Changed By
ch_date AEDAT Changed On
ch_time WLF_AEZEIT Changed At
it_closed WLF_ITEM_CLOSED Item Closed
com_cat WLF_COM_ITEM_CAT Com. Item Cat.
numerator WB2_UMZ Qty Conv.
denominator WB2_UMN Qty Conv. Denomin.
assgmt_rel WLF_ASSGMT_REL Assignment Relevant
hkpstp HKPSTP Item Category
matnr MATNR Material
basis_meins MEINS Base Unit
vendor ELIFN Supplier
customer KUNAG Sold-to Party
batch CHARG_D Batch
ext_ref WLF_EXT_IDENTIFIER_COM Ext. Identifier
com_item_prop WB2_COM_ITEM_PROPERTY Property
_dataaging DATA_TEMPERATURE Data Aging
place_holder abap.char

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.

-- Trading Contract: commodity sub items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WB2_D_COMSUB (
    CLIENT,         -- Client [MANDT]
    TKONN,          -- Trading Contract [TKONN]
    TPOSN,          -- Item Number [TPOSN]
    SIDE,           -- Side [WLF_PR_SIDE]
    TPOSN_COM,      -- Com. item num. [WLF_TPOSN_COM]
    QUANTITY,       -- Item Quantity [WLF_ITEM_QUANTITY]
    UNIT,           -- Unit [WLF_UNIT]
    DATE_FROM,      -- Date From [WLF_DATE_FROM]
    DATE_TO,        -- Date To [WLF_DATE_TO]
    FUTURE,         -- Future [WLF_FUTURE]
    COM_GUID,       -- commodity GUID [WLF_COM_GUID]
    CR_NAME,        -- Created By [ERNAM]
    CR_DATE,        -- Created On [ERDAT]
    CR_TIME,        -- Created At [WLF_ERZEIT]
    CH_NAME,        -- Changed By [AENAM]
    CH_DATE,        -- Changed On [AEDAT]
    CH_TIME,        -- Changed At [WLF_AEZEIT]
    IT_CLOSED,      -- Item Closed [WLF_ITEM_CLOSED]
    COM_CAT,        -- Com. Item Cat. [WLF_COM_ITEM_CAT]
    NUMERATOR,      -- Qty Conv. [WB2_UMZ]
    DENOMINATOR,    -- Qty Conv. Denomin. [WB2_UMN]
    ASSGMT_REL,     -- Assignment Relevant [WLF_ASSGMT_REL]
    HKPSTP,         -- Item Category [HKPSTP]
    MATNR,          -- Material [MATNR]
    BASIS_MEINS,    -- Base Unit [MEINS]
    VENDOR,         -- Supplier [ELIFN]
    CUSTOMER,       -- Sold-to Party [KUNAG]
    BATCH,          -- Batch [CHARG_D]
    EXT_REF,        -- Ext. Identifier [WLF_EXT_IDENTIFIER_COM]
    COM_ITEM_PROP,  -- Property [WB2_COM_ITEM_PROPERTY]
    _DATAAGING,     -- Data Aging [DATA_TEMPERATURE]
    PLACE_HOLDER,   -- abap.char
    PRIMARY KEY (CLIENT, TKONN, TPOSN, SIDE, TPOSN_COM)
);

Learn More