WB2_D_SHD_ITEM SAP (Shadow Items) Table details

Dictionary Type: Table
Description: Shadow Items




ABAP Code to SELECT data from WB2_D_SHD_ITEM
Related tables to WB2_D_SHD_ITEM
Access table WB2_D_SHD_ITEM




Table field list including key, data, relationships and ABAP select examples

WB2_D_SHD_ITEM is a standard SAP Table which is used to store Shadow Items data and is available within R/3 SAP systems depending on the version and release level.

The WB2_D_SHD_ITEM table consists of various fields, each holding specific information or linking keys about Shadow Items data available in SAP. These include TYPE (Document Category), DOCUMENT (Document Number), ITEM (item number), SIDE (Side).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP WB2_D_SHD_ITEM table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3T000MANDT
TYPEDocument Category WLF_SHADOW_DOC_TYPECHAR2WLF_SHADOW_DOC_TYPE
DOCUMENTDocument Number WLF_GENERIC_DOC_NUMCHAR32WLF_GENERIC_DOC_NUM
ITEMitem number WLF_GENERIC_ITEM_NUMNUMC10WLF_GENERIC_ITEM_NUM
SIDESide WLF_PR_SIDECHAR2WLF_PR_SIDE
SUB_ITEMSubitem Number WLF_GENERIC_SUB_ITEM_NUMNUMC6WLF_GENERIC_ITEM_NUM_SUB
HAS_OPEN_QUANExistence of an Open Quantity for Assignment WLF_OPEN_ASSMGT_QUAN_FLAGCHAR1WLF_OPEN_ASSMGT_QUAN_FLAG
ITEM_QUANItem Quantity WLF_GENERIC_ITEM_QUANTITYD34R34WLF_QUANTITY
ITEM_UOMUoM of Item Quantity WLF_GENERIC_ITEM_UOMUNIT3T006CUNITMEINS
IT_QUAN_ASSGMTItem Quantity in the UoM of an Assignment WLF_ITEM_QUANTITY_ASSGMTD34R34WLF_QUANTITY
ASSGD_QUANCumulative Assigned Quantity WLF_ASSGD_QUANTITYD34R34WLF_QUANTITY
ASSGD_UOMUoM of the Assigned Quantity WLF_ASSGD_UOMUNIT3T006CUNITMEINS
NUMERATORNumerator: Conversion Factor WB2_UMZDEC5WB2_UMZ
DENOMINATORDenominator: Conversion Factor WB2_UMNDEC5WB2_UMN
VENDORVendor Account Number ELIFNCHAR10LFA1ALPHALIFNRLIFKRED_C
CUSTOMERSold-to party KUNAGCHAR10KNA1ALPHAKUNNRVAG
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
BATCHBatch Number CHARG_DCHAR10MCH1CHARGCHA
FUTUREFuture WLF_FUTURECHAR20WLF_FUTURE
CLOSEDItem Closed WLF_ITEM_CLOSEDCHAR1WLF_ITEM_CLOSED
SH_IT_GUIDGUID of a shadow item WLF_SH_IT_GUIDRAW16WLF_GUID
CR_NAMEName of Person who Created the Object ERNAMCHAR12USNAM
CR_DATEDate on Which Record Was Created ERDATDATS8DATUM
CR_TIMETime, at Which Record Was Added ERZEITTIMS6UHRZT
CH_NAMEName of Person Who Changed Object AENAMCHAR12USNAM
CH_DATEChanged On AEDATDATS8DATUM
CH_TIMETime of Change AEZEITTIMS6UHRZT
DATE_FROMDate From WLF_DATE_FROMDATS8DATUM
DATE_TODate To WLF_DATE_TODATS8DATUM
CANCEL_FLAGCancel WLF_CANCELCHAR1WLF_CANCEL
COM_CATCommodity Item Category WLF_COM_ITEM_CATCHAR4WLF_COM_ITEM_CAT
ASSGMT_TR_METHMethod how assignments are transferred WB2_ASSGMT_TRANSFER_METHODCHAR1WB2_ASSGMT_TRANSFER_METHOD
PRE_TYPEReference Document Category WLF_PRE_SHADOW_DOC_TYPECHAR2WLF_SHADOW_DOC_TYPE
PRE_DOCUMENTReference Document Number WLF_PRE_GENERIC_DOC_NUMCHAR32WLF_GENERIC_DOC_NUM
PRE_ITEMReference Item Number WLF_PRE_GENERIC_ITEM_NUMNUMC10WLF_GENERIC_ITEM_NUM
PRE_SIDELogistical Side of Referenced Object WLF_PRE_SIDECHAR2WLF_PR_SIDE
PRE_SUB_ITEMReferenced Subitem Number WLF_PRE_GENERIC_SUB_ITEM_NUMNUMC6WLF_GENERIC_ITEM_NUM_SUB
ROOT_TYPEDocument Category of Root Document WLF_ROOT_SHADOW_DOC_TYPECHAR2WLF_SHADOW_DOC_TYPE
ROOT_DOCUMENTRoot Document Number WLF_ROOT_GENERIC_DOC_NUMCHAR32WLF_GENERIC_DOC_NUM
ROOT_ITEMRoot Item Number WLF_ROOT_GENERIC_ITEM_NUMNUMC10WLF_GENERIC_ITEM_NUM
ROOT_SIDELogistical Side of Root Object WLF_ROOT_SIDECHAR2WLF_PR_SIDE
ROOT_SUB_ITEMRoot Subitem Number WLF_ROOT_GENERIC_SUB_ITEM_NUMNUMC6WLF_GENERIC_ITEM_NUM_SUB
TRANSF_QUANTransferred Quantity of an Item WLF_TRANSFERRED_QUANTITYD34R34WLF_QUANTITY
PLACE_HOLDER not used0

Key field Non-key field



How do I retrieve data from SAP table WB2_D_SHD_ITEM using ABAP code

The following ABAP code Example will allow you to do a basic selection on WB2_D_SHD_ITEM to SELECT all data from the table
DATA: WA_WB2_D_SHD_ITEM TYPE WB2_D_SHD_ITEM.

SELECT SINGLE *
FROM WB2_D_SHD_ITEM
INTO CORRESPONDING FIELDS OF WA_WB2_D_SHD_ITEM
WHERE...

How to access SAP table WB2_D_SHD_ITEM

Within an ECC or HANA version of SAP you can also view further information about WB2_D_SHD_ITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!