SAP WB2_D_SHD_ITEM Shadow Items Table
Overview
WB2_D_SHD_ITEM is a standard SAP S/4HANA table that stores Shadow Items data. There are total 44 fields in the WB2_D_SHD_ITEM table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WB2_D_SHD_ITEM belongs to Global Trade (LO-GT) module and is located in the package Assignment management (WB2_ASSGMT).
In addition, following links provide an overview of foreign key relationships, if any, that link WB2_D_SHD_ITEM to other SAP tables and standard CDS views available based on WB2_D_SHD_ITEM table in S/4HANA 2020.
Techincal Settings of WB2_D_SHD_ITEM
Below are technical details of the table WB2_D_SHD_ITEM
- Buffering not allowed
- No buffering
- Storage type is Not Defined
List of WB2_D_SHD_ITEM Fields
The following table gives you an overview of the fields available in WB2_D_SHD_ITEM
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 |
| TYPE | Document Category | WLF_SHADOW_DOC_TYPE | CHAR | 2 | |
| DOCUMENT | Document Number | WLF_GENERIC_DOC_NUM | CHAR | 32 | |
| ITEM | item number | WLF_GENERIC_ITEM_NUM | NUMC | 10 | |
| SIDE | Side | WLF_PR_SIDE | CHAR | 2 | |
| SUB_ITEM | Subitem Number | WLF_GENERIC_SUB_ITEM_NUM | NUMC | 6 | |
| HAS_OPEN_QUAN | Existence of an Open Quantity for Assignment | WLF_OPEN_ASSMGT_QUAN_FLAG | CHAR | 1 | |
| ITEM_QUAN | Item Quantity | WLF_GENERIC_ITEM_QUANTITY | D34R | 34 | |
| ITEM_UOM | UoM of Item Quantity | WLF_GENERIC_ITEM_UOM | T006 | UNIT | 3 |
| IT_QUAN_ASSGMT | Item Quantity in the UoM of an Assignment | WLF_ITEM_QUANTITY_ASSGMT | D34R | 34 | |
| ASSGD_QUAN | Cumulative Assigned Quantity | WLF_ASSGD_QUANTITY | D34R | 34 | |
| ASSGD_UOM | UoM of the Assigned Quantity | WLF_ASSGD_UOM | T006 | UNIT | 3 |
| NUMERATOR | Numerator Conversion Factor | WB2_UMZ | DEC | 5 | |
| DENOMINATOR | Denominator Conversion Factor | WB2_UMN | DEC | 5 | |
| VENDOR | Vendor's account number | ELIFN | LFA1 | CHAR | 10 |
| CUSTOMER | Sold-To Party | KUNAG | KNA1 | CHAR | 10 |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| BATCH | Batch Number | CHARG_D | MCH1 | CHAR | 10 |
| FUTURE | Future | WLF_FUTURE | CHAR | 20 | |
| CLOSED | Item Closed | WLF_ITEM_CLOSED | CHAR | 1 | |
| SH_IT_GUID | GUID of a shadow item | WLF_SH_IT_GUID | RAW | 16 | |
| CR_NAME | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| CR_DATE | Date on which the record was created | ERDAT | DATS | 8 | |
| CR_TIME | Time at Which Record Was Added | WLF_ERZEIT | TIMS | 6 | |
| CH_NAME | Name of person who changed object | AENAM | CHAR | 12 | |
| CH_DATE | Date of Last Change | AEDAT | DATS | 8 | |
| CH_TIME | Time of Change | WLF_AEZEIT | TIMS | 6 | |
| DATE_FROM | Date From | WLF_DATE_FROM | DATS | 8 | |
| DATE_TO | Date To | WLF_DATE_TO | DATS | 8 | |
| CANCEL_FLAG | Cancel | WLF_CANCEL | CHAR | 1 | |
| COM_CAT | Commodity Item Category | WLF_COM_ITEM_CAT | CHAR | 4 | |
| ASSGMT_TR_METH | Method how assignments are transferred | WB2_ASSGMT_TRANSFER_METHOD | CHAR | 1 | |
| PRE_TYPE | Reference Document Category | WLF_PRE_SHADOW_DOC_TYPE | CHAR | 2 | |
| PRE_DOCUMENT | Reference Document Number | WLF_PRE_GENERIC_DOC_NUM | CHAR | 32 | |
| PRE_ITEM | Reference Item Number | WLF_PRE_GENERIC_ITEM_NUM | NUMC | 10 | |
| PRE_SIDE | Logistical Side of Referenced Object | WLF_PRE_SIDE | CHAR | 2 | |
| PRE_SUB_ITEM | Referenced Subitem Number | WLF_PRE_GENERIC_SUB_ITEM_NUM | NUMC | 6 | |
| ROOT_TYPE | Document Category of Root Document | WLF_ROOT_SHADOW_DOC_TYPE | CHAR | 2 | |
| ROOT_DOCUMENT | Root Document Number | WLF_ROOT_GENERIC_DOC_NUM | CHAR | 32 | |
| ROOT_ITEM | Root Item Number | WLF_ROOT_GENERIC_ITEM_NUM | NUMC | 10 | |
| ROOT_SIDE | Logistical Side of Root Object | WLF_ROOT_SIDE | CHAR | 2 | |
| ROOT_SUB_ITEM | Root Subitem Number | WLF_ROOT_GENERIC_SUB_ITEM_NUM | NUMC | 6 | |
| TRANSF_QUAN | Transferred Quantity of an Item | WLF_TRANSFERRED_QUANTITY | D34R | 34 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WB2_D_SHD_ITEM
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WB2_D_SHD_ITEM | ASSGD_UOM | : | T006 |
| WB2_D_SHD_ITEM | BATCH | : | MCH1 |
| WB2_D_SHD_ITEM | CLIENT | : | T000 |
| WB2_D_SHD_ITEM | CUSTOMER | : | KNA1 |
| WB2_D_SHD_ITEM | ITEM_UOM | : | T006 |
| WB2_D_SHD_ITEM | MATNR | : | MARA |
| WB2_D_SHD_ITEM | VENDOR | : | LFA1 |