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

FieldDescriptionData ElementCheck TableData TypeLength
CLIENTClientMANDTT000CLNT3
TYPEDocument CategoryWLF_SHADOW_DOC_TYPECHAR2
DOCUMENTDocument NumberWLF_GENERIC_DOC_NUMCHAR32
ITEMitem numberWLF_GENERIC_ITEM_NUMNUMC10
SIDESideWLF_PR_SIDECHAR2
SUB_ITEMSubitem NumberWLF_GENERIC_SUB_ITEM_NUMNUMC6
HAS_OPEN_QUANExistence of an Open Quantity for AssignmentWLF_OPEN_ASSMGT_QUAN_FLAGCHAR1
ITEM_QUANItem QuantityWLF_GENERIC_ITEM_QUANTITYD34R34
ITEM_UOMUoM of Item QuantityWLF_GENERIC_ITEM_UOMT006UNIT3
IT_QUAN_ASSGMTItem Quantity in the UoM of an AssignmentWLF_ITEM_QUANTITY_ASSGMTD34R34
ASSGD_QUANCumulative Assigned QuantityWLF_ASSGD_QUANTITYD34R34
ASSGD_UOMUoM of the Assigned QuantityWLF_ASSGD_UOMT006UNIT3
NUMERATORNumerator Conversion FactorWB2_UMZDEC5
DENOMINATORDenominator Conversion FactorWB2_UMNDEC5
VENDORVendor's account numberELIFNLFA1CHAR10
CUSTOMERSold-To PartyKUNAGKNA1CHAR10
MATNRMaterial NumberMATNRMARACHAR40
BATCHBatch NumberCHARG_DMCH1CHAR10
FUTUREFutureWLF_FUTURECHAR20
CLOSEDItem ClosedWLF_ITEM_CLOSEDCHAR1
SH_IT_GUIDGUID of a shadow itemWLF_SH_IT_GUIDRAW16
CR_NAMEName of Person who Created the ObjectERNAMCHAR12
CR_DATEDate on which the record was createdERDATDATS8
CR_TIMETime at Which Record Was AddedWLF_ERZEITTIMS6
CH_NAMEName of person who changed objectAENAMCHAR12
CH_DATEDate of Last ChangeAEDATDATS8
CH_TIMETime of ChangeWLF_AEZEITTIMS6
DATE_FROMDate FromWLF_DATE_FROMDATS8
DATE_TODate ToWLF_DATE_TODATS8
CANCEL_FLAGCancelWLF_CANCELCHAR1
COM_CATCommodity Item CategoryWLF_COM_ITEM_CATCHAR4
ASSGMT_TR_METHMethod how assignments are transferredWB2_ASSGMT_TRANSFER_METHODCHAR1
PRE_TYPEReference Document CategoryWLF_PRE_SHADOW_DOC_TYPECHAR2
PRE_DOCUMENTReference Document NumberWLF_PRE_GENERIC_DOC_NUMCHAR32
PRE_ITEMReference Item NumberWLF_PRE_GENERIC_ITEM_NUMNUMC10
PRE_SIDELogistical Side of Referenced ObjectWLF_PRE_SIDECHAR2
PRE_SUB_ITEMReferenced Subitem NumberWLF_PRE_GENERIC_SUB_ITEM_NUMNUMC6
ROOT_TYPEDocument Category of Root DocumentWLF_ROOT_SHADOW_DOC_TYPECHAR2
ROOT_DOCUMENTRoot Document NumberWLF_ROOT_GENERIC_DOC_NUMCHAR32
ROOT_ITEMRoot Item NumberWLF_ROOT_GENERIC_ITEM_NUMNUMC10
ROOT_SIDELogistical Side of Root ObjectWLF_ROOT_SIDECHAR2
ROOT_SUB_ITEMRoot Subitem NumberWLF_ROOT_GENERIC_SUB_ITEM_NUMNUMC6
TRANSF_QUANTransferred Quantity of an ItemWLF_TRANSFERRED_QUANTITYD34R34
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS8

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 NameFieldCardinalityCheck Table
WB2_D_SHD_ITEMASSGD_UOM:T006
WB2_D_SHD_ITEMBATCH:MCH1
WB2_D_SHD_ITEMCLIENT:T000
WB2_D_SHD_ITEMCUSTOMER:KNA1
WB2_D_SHD_ITEMITEM_UOM:T006
WB2_D_SHD_ITEMMATNR:MARA
WB2_D_SHD_ITEMVENDOR:LFA1

Other References