WB2_D_SHD_ITEM

Transparent Table Application Table
45 Fields 4 CDS Views

Shadow Items

WB2_D_SHD_ITEM is an SAP database table in S/4HANA. Shadow Items. It contains 45 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ACMCancResetShadowItem view_entity from BASIC Cancellation reset in Shadow Items table
I_ACMTrdgContrShadowItem view from BASIC Trading Contract Shadow Item Details
I_PrepayShadowItemData view_entity from BASIC Trading Contract Shadow Item Data
I_ShadowItemData view from BASIC ACM Qty: Shadow Item Data

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY type WLF_SHADOW_DOC_TYPE Document Type
KEY document WLF_GENERIC_DOC_NUM DocNum
KEY item WLF_GENERIC_ITEM_NUM Item Number
KEY side WLF_PR_SIDE Side
KEY sub_item WLF_GENERIC_SUB_ITEM_NUM SubItemNumber
has_open_quan WLF_OPEN_ASSMGT_QUAN_FLAG OpenQuanFlag
item_quan WLF_GENERIC_ITEM_QUANTITY ItemQuan
item_uom WLF_GENERIC_ITEM_UOM ItemUoM
it_quan_assgmt WLF_ITEM_QUANTITY_ASSGMT QuanInAssgmtUoM
assgd_quan WLF_ASSGD_QUANTITY CumAssignedQuan
assgd_uom WLF_ASSGD_UOM Assigned UoM
numerator WB2_UMZ Qty Conv.
denominator WB2_UMN Qty Conv. Denomin.
vendor ELIFN Supplier
customer KUNAG Sold-to Party
matnr MATNR Material
batch CHARG_D Batch
future WLF_FUTURE Future
closed WLF_ITEM_CLOSED Item Closed
sh_it_guid WLF_SH_IT_GUID Shadow It 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
date_from WLF_DATE_FROM Date From
date_to WLF_DATE_TO Date To
cancel_flag WLF_CANCEL Cancel
com_cat WLF_COM_ITEM_CAT Com. Item Cat.
assgmt_tr_meth WB2_ASSGMT_TRANSFER_METHOD AssgmtTrMeth
pre_type WLF_PRE_SHADOW_DOC_TYPE Ref. Doc. Cat.
pre_document WLF_PRE_GENERIC_DOC_NUM Ref. Doc. No.
pre_item WLF_PRE_GENERIC_ITEM_NUM Ref. Item No.
pre_side WLF_PRE_SIDE Referenced Side
pre_sub_item WLF_PRE_GENERIC_SUB_ITEM_NUM Ref. Subitm No.
root_type WLF_ROOT_SHADOW_DOC_TYPE Root Doc. Cat.
root_document WLF_ROOT_GENERIC_DOC_NUM Root Doc. No.
root_item WLF_ROOT_GENERIC_ITEM_NUM Root Item No.
root_side WLF_ROOT_SIDE Root Side
root_sub_item WLF_ROOT_GENERIC_SUB_ITEM_NUM Root Subitm No.
transf_quan WLF_TRANSFERRED_QUANTITY Transferred Qty
_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.

-- Shadow Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WB2_D_SHD_ITEM (
    CLIENT,          -- Client [MANDT]
    TYPE,            -- Document Type [WLF_SHADOW_DOC_TYPE]
    DOCUMENT,        -- DocNum [WLF_GENERIC_DOC_NUM]
    ITEM,            -- Item Number [WLF_GENERIC_ITEM_NUM]
    SIDE,            -- Side [WLF_PR_SIDE]
    SUB_ITEM,        -- SubItemNumber [WLF_GENERIC_SUB_ITEM_NUM]
    HAS_OPEN_QUAN,   -- OpenQuanFlag [WLF_OPEN_ASSMGT_QUAN_FLAG]
    ITEM_QUAN,       -- ItemQuan [WLF_GENERIC_ITEM_QUANTITY]
    ITEM_UOM,        -- ItemUoM [WLF_GENERIC_ITEM_UOM]
    IT_QUAN_ASSGMT,  -- QuanInAssgmtUoM [WLF_ITEM_QUANTITY_ASSGMT]
    ASSGD_QUAN,      -- CumAssignedQuan [WLF_ASSGD_QUANTITY]
    ASSGD_UOM,       -- Assigned UoM [WLF_ASSGD_UOM]
    NUMERATOR,       -- Qty Conv. [WB2_UMZ]
    DENOMINATOR,     -- Qty Conv. Denomin. [WB2_UMN]
    VENDOR,          -- Supplier [ELIFN]
    CUSTOMER,        -- Sold-to Party [KUNAG]
    MATNR,           -- Material [MATNR]
    BATCH,           -- Batch [CHARG_D]
    FUTURE,          -- Future [WLF_FUTURE]
    CLOSED,          -- Item Closed [WLF_ITEM_CLOSED]
    SH_IT_GUID,      -- Shadow It GUID [WLF_SH_IT_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]
    DATE_FROM,       -- Date From [WLF_DATE_FROM]
    DATE_TO,         -- Date To [WLF_DATE_TO]
    CANCEL_FLAG,     -- Cancel [WLF_CANCEL]
    COM_CAT,         -- Com. Item Cat. [WLF_COM_ITEM_CAT]
    ASSGMT_TR_METH,  -- AssgmtTrMeth [WB2_ASSGMT_TRANSFER_METHOD]
    PRE_TYPE,        -- Ref. Doc. Cat. [WLF_PRE_SHADOW_DOC_TYPE]
    PRE_DOCUMENT,    -- Ref. Doc. No. [WLF_PRE_GENERIC_DOC_NUM]
    PRE_ITEM,        -- Ref. Item No. [WLF_PRE_GENERIC_ITEM_NUM]
    PRE_SIDE,        -- Referenced Side [WLF_PRE_SIDE]
    PRE_SUB_ITEM,    -- Ref. Subitm No. [WLF_PRE_GENERIC_SUB_ITEM_NUM]
    ROOT_TYPE,       -- Root Doc. Cat. [WLF_ROOT_SHADOW_DOC_TYPE]
    ROOT_DOCUMENT,   -- Root Doc. No. [WLF_ROOT_GENERIC_DOC_NUM]
    ROOT_ITEM,       -- Root Item No. [WLF_ROOT_GENERIC_ITEM_NUM]
    ROOT_SIDE,       -- Root Side [WLF_ROOT_SIDE]
    ROOT_SUB_ITEM,   -- Root Subitm No. [WLF_ROOT_GENERIC_SUB_ITEM_NUM]
    TRANSF_QUAN,     -- Transferred Qty [WLF_TRANSFERRED_QUANTITY]
    _DATAAGING,      -- Data Aging [DATA_TEMPERATURE]
    PLACE_HOLDER,    -- abap.char
    PRIMARY KEY (CLIENT, TYPE, DOCUMENT, ITEM, SIDE, SUB_ITEM)
);

Learn More