As i am searching to see the data fields for reporting, i came to know that SAP EWM Data source which are important for SAP EWM Analytics. This blog post is to share the basic information of SAP EWM Data source fields that are used for BI reports. DataSource is a set of fields that provide the data for a business unit for data transfer. From a technical perspective, the DataSource is a set of logically-related fields that are provided to transfer data to SAP NetWeaver BW.

Business applications normally store operative data in the form of business documents and master data. In SAP NetWeaver BW, DataSources and their extractors make it possible to access this data. DataSources provide a flat analytical view of the data in business documents, such as Inbound delivery orders or Outbound delivery orders.

A DataSource is a set of fields that provide the data for a business unit for data transfer into the BW. From a technical perspective, the DataSource is a set of logically-related fields that are provided to transfer data into the BW in a flat structure (the extraction structure) or in multiple flat structures (for hierarchies).

There are four types of DataSource:

  • DataSource for transaction data

  • DataSource for master data

    • DataSource for attributes

    • DataSource for texts

    • DataSource for hierarchies

    The Operational Data Provider (ODP) is the link between business data stored in the structure of DataSources and the requirements arising from Operational Analytics and the replication of mass data: The Operational Data Provider defines interfaces for transaction data and master data. Once implemented, these allow access to data for reporting and analysis, and for replication to various consumers. For BW DataSources with direct access, there is a generic implementation of ODP interfaces.

    For more details of SAP EWM Anlystics BW extractors Please click here

Attributes of a Warehouse

Fields of Origin for the Extract Structure
Fields in the Extract StructureDescription of the Field in the Extract StructureTable of OriginField in the Table of Origin
LGNUMWarehouse Number/Warehouse Complex/SCWM/T300LGNUM
TZONETime Zone

This DataSource provides you with texts that define a business process for a delivery item

SAP EWM Analytics -Fields of Origin for the Extract Structure
Fields in the Extract StructureDescription of the Field in the Extract StructureTable of OriginField in the Table of Origin
LANGULanguage Key/SCWM/TBWDLVPROTLANGU
DLVPROCBusiness Process/SCWM/TBWDLVPROTDLVPROC
DESCRDescription/SCWM/TBWDLVPROTDESCR

Stock

This DataSource provides you with stock data.

SAP EWM Analytics-Fields of Origin for the Extract Structure
Fields in the Extract StructureDescription of the Field in the Extract StructureTable of OriginField in the Table of Origin
GUID_PARENTParent GUID/SCWM/LOC_IW01GUID_LOC
GUID_STOCKGUID Stock Item/SCWM/STOCK_IW01, /SCWM/STOCK_IW02, /SCWM/STOCK_IW03, /SCWM/STOCK_IW04GUID_STOCK
LGNUMWarehouse Number/Warehouse Complex/SCWM/LOC_IW01LGNUM
LGTYPStorage Type/SCWM/LOC_IW01LGTYP
LGBERStorage Section/SCWM/LAGPLGBER
LGPLAStorage Bin/SCWM/LOC_IW01LGPLA
HUIDENTHandling Unit Identification/SCWM/HU_IW01HUIDENT
HUIDENT_TOPHandling Unit Identification/SCWM/HU_IW01HUIDENT
MATIDProduct/SCWM/STOCK_IW01, /SCWM/STOCK_IW02, /SCWM/STOCK_IW03, /SCWM/STOCK_IW04MATID
MATNRProduct/SAPAPO/MATKEYMATNR
CHARGBatch/SAPAPO/VERSKEYVERSION
CATStock Type/SCWM/STOCK_IW01, /SCWM/STOCK_IW02, /SCWM/STOCK_IW03, /SCWM/STOCK_IW04CAT
ENTITLEDParty Entitled to Dispose/SCWM/STOCK_IW01, /SCWM/STOCK_IW02, /SCWM/STOCK_IW03, /SCWM/STOCK_IW04ENTITLED
OWNEROwner/SCWM/STOCK_IW01, /SCWM/STOCK_IW02, /SCWM/STOCK_IW03, /SCWM/STOCK_IW04OWNER
STOCK_DOCCATType: Sales Order Stock or Project Stock/SCWM/STOCK_IW04STOCK_DOCCAT
STOCK_DOCNONumber of the Sales Order or Project for Special Stock/SCWM/STOCK_IW04STOCK_DOCNO
STOCK_DOCNO_EXTExternal Number of Sales Order/Project (Special Stock)/SCWM/ERP_PSPSTOCK_DOCNO_EXT
STOCK_ITMNOSales Order Item for Sales Order Stock/SCWM/STOCK_IW04STOCK_ITMNO
STOCK_USAGEStock Usage/SCWM/STOCK_IW01, /SCWM/STOCK_IW02, /SCWM/STOCK_IW03, /SCWM/STOCK_IW04STOCK_USAGE
STREF_DOCCATDoc. Category for Doc. Reference and Doc.-Related Stocks/SCWM/STOCK_IW03DOCCAT
WDATUGoods Receipt Date/SCWM/QUANWDATU
VFDATBest-Before Date / Shelf Life Expiration Date/SCWM/QUANVFDAT
COOCountry of Origin/SCWM/QUANCOO
IDPLATEIdentification Number of Stock/SCWM/QUANIDPLATE
QDOCCATDoc. Category for Doc. Reference and Doc.-Related Stocks/SCWM/QUANQDOCCAT
QDOCNODocument Number for Stock Reference/SCDL/DB_PROCH_I, /SCDL/DB_PROCH_ODOCNO
QITEMNOItem Number of Stock Reference/SCDL/DB_PROCI_I, /SCDL/DB_PROCI_OITEMNO
INSPTYPInspection Type/SCWM/QUANINSPTYP
INSPDOCNOQIE Entity: External IdentificationQIE_INSP_DOCINSP_DOC_NUMBER
WEIGHTLoading/Net Weight/SCWM/QUANWEIGHT
UNIT_WWeight Unit/SCWM/QUANUNIT_W
VOLUMLoading/Net Volume/SCWM/QUANVOLUM
UNIT_VVolume Unit/SCWM/QUANUNIT_V
CAPACapacity Consumption/SCWM/QUANCAPA
QUANQuantity/LIME/NQUANQUAN
MEINSBase Unit of Measure/LIME/NQUANUNIT
QUANAPacked Quantity in Alternative Unit of Measure
ALTMEAlternative Unit of Measure for Stock-keeping Unit/SCWM/QUANALTME
CWQUANActual Valuation Quantity (for UI)/LIME/NQUANQUAN
CWUNITUnit for Valuation Quantity/LIME/NQUANUNIT
VALUEProduct Value
WAERSCurrency Key/SCWM/T_VALUATE, /SCWM/T_VAL_SPLTWAERS
DSTGRPConsolidation Group/SCWM/QUANDSTGRP
PSAProduction Supply Area (PSA)/SCWM/TPSASTAGEPSA
LPTYPStorage Bin Type/SCWM/LAGPLPTYP
ST_ROLEStorage Type Role/SCWM/T331ST_ROLE
AISLEAisle in a Storage Bin/SCWM/LAGPAISLE
STACKStack in a Storage Bin/SCWM/LAGPSTACK
LVL_VLevel in a Storage Bin/SCWM/LAGPLVL_L
LETYPHandling Unit Type/SCWM/HUHDRLETYP
LETYP_TOPTop Handling Unit Type/SCWM/HUHDRLETYP
MATKLMaterial Group/SAPAPO/MATKEYMATKL
STOKEY1Hazard RatingHSMC_014STOKEY
STOKEY2Hazard RatingHSMC_014STOKEY
EXTRACT_DATEExtraction Date
EXTRACT_TIMEExtraction Time

This DataSource provides delivery items enriched with warehouse task data, such as the warehouse process type in SAP EWM Analytics

SAP EWM Analytics -Fields of Origin for the Extract Structure
Fields in the Extract StructureDescription of the Field in the Extract StructureTable of OriginField in the Table of Origin
LGNUMWarehouse Number/Warehouse Complex/SCDL/DB_PROCI_I;/SCDL/DB_PROCI_O/SCWM/WHNO
DOCIDDocument ID

/SCDL/DB_PROCI_I;/SCDL/DB_PROCI_O;/SCDL/DB_DLVH_O

DOCID
ITEMIDItem ID

/SCDL/DB_PROCI_I;/SCDL/DB_PROCI_O;/SCDL/DB_DLVI_O

ITEMID
COMPLTSLBStart Date/Time/SCDL/DB_PROCI_I;/SCDL/DB_PROCI_OCHGTST
AAREAActivity Area/SCWM/ORDIM_CAAREA
LGTYPStorage Type/SCWM/ORDIM_CVLTYP/NLTYP
PRCESStorage Process/SCWM/ORDIM_CPRCES
PROCSExternal Storage Process Step/SCWM/ORDIM_CPROCS
PROCTYWarehouse Process Type/SCWM/ORDIM_CPROCTY
WHS_TZONETime Zone of Warehouse/SCMB/TOENTITYTZONE

 

Warehouse Tasks

This DataSource provides you with confirmed warehouse tasks. It does not provide you with warehouse documents of goods movements or posting changes for SAP EWM Analytics

Fields of Origin for the Extract Structure
Fields in the Extract StructureDescription of the Field in the Extract StructureTable of OriginField in the Table of Origin
MANDTClient/SCWM/ORDIM_CMANDT
LGNUMWarehouse Number/Warehouse Complex/SCWM/ORDIM_CLGNUM
TANUMWarehouse Task/SCWM/ORDIM_CTANUM
TAPOSWarehouse Task Item/SCWM/ORDIM_CTAPOS
FLGHUTOHandling Unit Warehouse Task/SCWM/ORDIM_CFLGHUTO
PROCTYWarehouse Process Type/SCWM/ORDIM_CPROCTY
TRARTWarehouse Process Category/SCWM/ORDIM_CTRART
PRCESStorage Process/SCWM/ORDIM_CPRCES
PROCSExternal Storage Process Step/SCWM/ORDIM_CPROCS
TOSTATWarehouse Task Status/SCWM/ORDIM_CTOSTAT
CREATED_BYCreated By/SCWM/ORDIM_CCREATED_BY
CREATED_ATCreated at/SCWM/ORDIM_CCREATED_AT
CREATED_DATECreated On
CREATED_TIMECreated At
REASONReason for Movements in the Warehouse/SCWM/ORDIM_CREASON
PRIORITYPriority/SCWM/ORDIM_CPRIORITY
MATNRProduct/SCWM/ORDIM_CMATNR
CHARGBatch Number/SCWM/ORDIM_CCHARG
CATStock Type/SCWM/ORDIM_CCAT
STOCK_DOCCATType Sales Order Stock or Project Stock/SCWM/ORDIM_CSTOCK_DOCCAT
STOCK_DOCNONumber of the Sales Order or Project for Special Stock/SCWM/ORDIM_CSTOCK_DOCNO
STOCK_ITMNOSales Order Item for Sales Order Stock/SCWM/ORDIM_CSTOCK_ITMNO
DOCCATDoc. Category for Doc. Reference and Doc.-Related Stocks/SCWM/ORDIM_CDOCCAT
STOCK_USAGEStock Usage/SCWM/ORDIM_CSTOCK_USAGE
OWNEROwner/SCWM/ORDIM_COWNER
ENTITLEDParty Entitled to Dispose/SCWM/ORDIM_CENTITLED
MEINSBase unit of measure/SCWM/ORDIM_CMEINS
ALTMEAlternative Unit of Measure for Stockkeeping Unit/SCWM/ORDIM_CALTME
VSOLMTarget Quantity in Base Unit of Measure/SCWM/ORDIM_CVSOLM
VSOLATarget Quantity in Alternative Unit of Measure/SCWM/ORDIM_CVSOLA
KQUANRetention Quantity/SCWM/ORDIM_CKQUAN
LETYPHandling Unit Type/SCWM/ORDIM_CLETYP
WEIGHTLoading/Net Weight/SCWM/ORDIM_CWEIGHT
UNIT_WWeight Unit/SCWM/ORDIM_CUNIT_W
VOLUMLoading/Net Volume/SCWM/ORDIM_CVOLUM
UNIT_VVolume Unit/SCWM/ORDIM_CUNIT_V
CAPACapacity Consumption/SCWM/ORDIM_CCAPA
VFDAT_TSShelf Life Expiration Date or Best-Before Date
VFDATShelf Life Expiration Date/SCWM/ORDIM_CVFDAT
WDATUDate of Goods Receipt/SCWM/ORDIM_CWDATU
WDATU_DATEDate of Goods Receipt
WDATU_TIMEGoods Receipt Time
COOCountry of Origin/SCWM/ORDIM_CCOO
HAZMATHazardous Substance/SCWM/ORDIM_CHAZMAT
INSPTYPInspection Type/SCWM/ORDIM_CINSPTYP
INSPDOCNOQIE Entity: External Identification/SCWM/ORDIM_CINSPDOCNO
IDPLATEIdentification Number of Stock/SCWM/ORDIM_CIDPLATE
VLTYPSource Storage Type/SCWM/ORDIM_CVLTYP
VLBERSource Storage Section/SCWM/ORDIM_CVLBER
VLPLASource Storage Bin/SCWM/ORDIM_CVLPLA
VPTYPSource Bin Type/SCWM/LAGPLPTYP
SRSRCResource (Means of Transportation or User)/SCWM/ORDIM_CSRSRC
STU_NUMSource Transportation Unit (Internal)/SCWM/ORDIM_CSTU_NUM
VLENRSource Handling Unit/SCWM/ORDIM_CVLENR
NLTYPDestination Storage Type/SCWM/ORDIM_CNLTYP
NLBERDestination Storage Section/SCWM/ORDIM_CNLBER
NLPLADestination Storage Bin/SCWM/ORDIM_CNLPLA
NPTYPDestination Bin Type/SCWM/LAGPLPTYP
DRSRCResource (Means of Transportation or User)/SCWM/ORDIM_CDRSRC
DTU_NUMDestination Transportation Unit (Internal)/SCWM/ORDIM_CDTU_NUM
NLENRDestination Handling Unit/SCWM/ORDIM_CNLENR
KZSUBIndicator: Pass on Warehouse Task to Subsystem/SCWM/ORDIM_CKZSUB
SOLPOPlanned Proc. Time in Warehouse Task/SCWM/ORDIM_CSOLPO
ZEIEITime Unit for Processing Time Determination/SCWM/ORDIM_CZEIEI
VASIndicator: WT with Reference to a VAS/SCWM/ORDIM_CVAS
RDOCCATDoc. Category for Doc. Reference and Doc.-Related Stocks/SCWM/ORDIM_CRDOCCAT
RDOCNODocument Number of Document Reference/SCWM/ORDIM_CRDOCNO
RITMNODocument Item of Document Reference/SCWM/ORDIM_CRITMNO
WAVEWave/SCWM/ORDIM_CWAVE
WAVE_ITEMWave Item/SCWM/ORDIM_CWAVE_ITEM
QDOCCATDoc. Category for Doc. Reference and Doc.-Related Stocks/SCWM/ORDIM_CQDOCCAT
QDOCNODocument Number for Stock Reference/SCWM/ORDIM_CQDOCNO
QITMNOItem Number of Stock Reference/SCWM/ORDIM_CQITMNO
QIDPLATEIdentification Number of Stock/SCWM/ORDIM_CQIDPLATE
CONFIRMED_BYConfirmed by/SCWM/ORDIM_CCONFIRMED_BY
CONFIRMED_ATTime of Confirmation/SCWM/ORDIM_CCONFIRMED_AT
CONFIRMED_DATEConfirmation Date
CONFIRMED_TIMEConfirmation Time
EXCCODEException Code/SCWM/ORDIM_CEXCCODE
BUSCONBusiness Context/SCWM/ORDIM_CBUSCON
EXEC_STEPExecution Step in Business Context/SCWM/ORDIM_CEXEC_STEP
STARTED_ATStart Time/SCWM/ORDIM_CSTARTED_AT
STARTED_DATEStart Date
STARTED_TIMEStart Time
NISTMActual Quantity in Base Unit of Measure/SCWM/ORDIM_CNISTM
NISTAActual Quantity in Alternative Unit of Measure/SCWM/ORDIM_CNISTA
PLACE_INVInventory on Putaway Performed/SCWM/ORDIM_CPLACE_INV
LOWCHK_INVLow Stock Check Executed/SCWM/ORDIM_CLOWCHK_INV
HUENTIndicator: Handling unit will be withdrawn completely/SCWM/ORDIM_CHUENT
SLGNUM_VIEWWarehouse Number View for Global Stocks/SCWM/ORDIM_CSLGNUM_VIEW
DLGNUM_VIEWWarehouse Number View for Global Stocks/SCWM/ORDIM_CDLGNUM_VIEW
DMENGQuantity of Difference Posting in Stock Keeping Unit/SCWM/ORDIM_CDMENG
DMENADifference quantity in alternate unit of measure/SCWM/ORDIM_CDMENA
WHOWarehouse Order Number/SCWM/ORDIM_CWHO
AAREAActivity Area/SCWM/ORDIM_CAAREA
QUEUEQueue/SCWM/ORDIM_CQUEUE
ROCANCELIndicator: Cancel Data Record
CWQUANValuation Quantity/SCWM/ORDIM_CCWQUAN
CWQUAN_DIFFValuation Quantity/SCWM/ORDIM_CCWQUAN_DIFF
CWUNITUnit for Valuation Quantity/SCWM/ORDIM_CCWUNIT
PROCESSStorage Process Step
COUNTERIndex of Internal Tables/SCWM/ORDIM_CCOUNTER
VLPLA_MAINSource Storage Bin
NLPLA_MAINDestination Storage Bin
PROCESSORProcessor/SCWM/ORDIM_CPROCESSOR
FULL_PALLETIndicator for Full Pallet Withdrawal
MATKLMaterial Group/SAPAPO/MATKEYMATKL
VST_ROLESource Storage Type Role/SCWM/T331ST_ROLE
NST_ROLETarget Storage Type Role/SCWM/T331ST_ROLE

Warehouse Order

his DataSource provides you with confirmed and canceled warehouse orders for SAP EWM Analytics

SAP EWM Analytics-Fields of Origin for the Extract Structure
Fields in the Extract StructureDescription of the Field in the Extract StructureTable of OriginField in the Table of Origin
MANDTClient/SCWM/WHOMANDT
LGNUMWarehouse Number/Warehouse Complex/SCWM/WHOLGNUM
WHOWarehouse Order Number/SCWM/WHOWHO
WCRWarehouse Order Creation Rule/SCWM/WHOWCR
TYPECategory of Warehouse Order Creation Rule/SCWM/WHOTYPE
HDR_PROCTYDocument Header Warehouse Process Type/SCWM/WHOHDR_PROCTY
WAVEWave/SCWM/WHOWAVE
STATUSWarehouse Order Status/SCWM/WHOSTATUS
AREAWHOActivity Area/SCWM/WHOAREAWHO
CREATED_ATCreated at/SCWM/WHOCREATED_AT
CREATED_DATECreated On
CREATED_TIMECreated At
CREATED_BYCreated By/SCWM/WHOCREATED_BY
QUEUEQueue/SCWM/WHOQUEUE
STARTED_ATStart Time/SCWM/WHOSTARTED_AT
STARTED_DATEStart Date
STARTED_TIMEStart Time
CONFIRMED_ATTime of Confirmation/SCWM/WHOCONFIRMED_AT
CONFIRMED_DATEConfirmation Date
CONFIRMED_TIMEConfirmation Time
CONFIRMED_BYConfirmed by/SCWM/WHOCONFIRMED_BY
PROCESSORProcessor/SCWM/WHOPROCESSOR
RSRCResource (Means of Transportation or User)/SCWM/WHORSRC
MAN_ASSIGNManual Assignment of Processor/SCWM/WHOMAN_ASSIGN
FLGINVWO Contains Physical Inventory Document/SCWM/WHOFLGINV
FLGSPLITWarehouse Order Was Split/SCWM/WHOFLGSPLIT
LSDLatest Starting Date (LSD)/SCWM/WHOLSD
PLANDURAPlanned Execution Time of Warehouse Order/SCWM/WHOPLANDURA
CHANGED_ATTime of Change/SCWM/WHOCHANGED_AT
CHANGED_DATEChanged On
CHANGED_TIMEChanged At
CHANGED_BYChanged By/SCWM/WHOCHANGED_BY
UNIT_TWarehouse Order: Time Unit/SCWM/WHOUNIT_T
FLGTOWarehouse Order Contains Warehouse Task/SCWM/WHOFLGTO
HAZMATHazardous Substance Relevant for Storage/SCWM/WHOHAZMAT
WHOIDUnique Identification of the Warehouse Order/SCWM/WHOWHOID
ROCANCELIndicator: Cancel Data Record
ACT_TYPEActivity/SCWM/T333ACT_TYPE
RSRC_TYPEResource Type/SCWM/RSRCRSRC_TYPE

Transportation Units

This DataSource provides you with transportation unit data.

Fields of Origin for the Extract Structure
Fields in the Extract StructureDescription of the Field in the Extract StructureTable of OriginField in the Table of Origin
TU_NUMInternal Number of Transportation Unit/SCWM/TUNITTU_NUM
TU_SR_ACT_NUMShipping and Receiving Activity Number: Transportation Unit/SCWM/TU_SR_ACTTU_SR_ACT_NUM
TU_NUM_EXTTransportation Unit/SCWM/TUNITTU_NUM_EXT
MTRMeans of Transport/SCWM/TUNITMTR
TSPCarrier/SCWM/TU_SR_ACTTSP_CURR
SCACPartner: Standard Carrier Alpha Code/SCWM/TU_SR_ACTSCAC_CURR
LIC_PLATE_COUNTRYCountry of Registration Number/SCWM/TUNITLIC_PLATE_CNTRY
LIC_PLATELicense Plate Number for Transportation Unit/SCWM/TUNITLIC_PLATE
ACT_DIRDirection/SCWM/TU_SR_ACTACT_DIR
ROUTERoute Name (Identification)/SCWM/TU_SR_ACTROUTE_CURR
ROUTE_DEPDeparture Time Stamp for Route/SCWM/TU_SR_ACTROUTE_DEP
LOAD_WEIGHTLoading Weight of Transportation Unit/SCWM/TU_SR_ACTLOAD_WEIGHT
LOAD_WEIGHT_UOMWeight Unit/SCWM/TU_SR_ACTLOAD_WEIGHT_UOM
LOAD_VOLUMELoading Volume of Transportation Unit/SCWM/TU_SR_ACTLOAD_VOLUME
LOAD_VOLUME_UOMVolume Unit/SCWM/TU_SR_ACTLOAD_VOLUME_UOM
TU_WEIGHTWeighed Total Weight of Transportation Unit/SCWM/HUHDRT_WEIGHT
TU_WEIGHT_UOMWeight Unit/SCWM/HUHDRUNIT_TW
TU_VOLUMECalculated Total Volume of Transportation Unit/SCWM/HUHDRT_VOLUME
TU_VOL_UOMVolume Unit/SCWM/HUHDRUNIT_TV
START_PLAN_TSTFRStart Time Stamp for Planned Start of S&R Activity/SCWM/TU_SR_ACTSTART_PLAN_TSTFR
START_PLAN_TSTTOEnd Time Stamp for Planned Start of S& R Activity/SCWM/TU_SR_ACTSTART_PLAN_TSTTO
END_PLAN_TSTFRStart Time Stamp for Planned End of S&R Activity/SCWM/TU_SR_ACTEND_PLAN_TSTFR
END_PLAN_TSTTOEnd Time Stamp for Planned End of S&R Activity/SCWM/TU_SR_ACTEND_PLAN_TSTTO
START_ACTUALTime Stamp for Actual Start of S&R Activity/SCWM/TU_SR_ACTSTART_ACTUAL
END_ACTUALTime Stamp for Actual End of S&R Activity/SCMB/DE_SR_ACT_END_ACTUALEND_ACTUAL
YARD_LGNUMWarehouse Number for Yard/SCWM/TU_SR_ACTYARD
LGNUMWarehouse Number/SCWM/TU_DLVLGNUM
DOORSource Warehouse Door/SCWM/TU_DOORDOOR
FRD_NUMFreight Document Number/SCWM/TU_SR_ACTFRD_NUM
TRANSPL_TYPETransportation Planning Type/SCWM/TU_SR_ACTTRANSPL_TYPE
LOGSYSReceiving Logical System/SCWM/TU_SR_ACTLOGSYS
WHS_TZONETime Zone of Warehouse/SCMB/TOENTITYTZONE
VEH_NUMInternal Vehicle Number/SCWM/TU_VEHVEH_NUM
VEH_NUM_EXTVehicle/SCWM/VEHICLEVEH_NUM_EXT
COUNT_HUNumber of Assigned HUs
COUNT_DLVHNumber of Assigned Deliveries
COUNT_DLVINumber of Assigned Delivery Items
DURATION_IN_MINTime in Yard in Minutes

Inbound delivery items

This DataSource provides you with completed inbound delivery items.

SAP EWM Analytics-Fields of Origin for the Extract Structure
Fields in the Extract StructureDescription of the Field in the Extract StructureTable of OriginField in the Table of Origin
DOCIDDocument ID/SCDL/DB_PROCH_IDOCID
ITEMIDItem ID/SCDL/DB_PROCI_IITEMID
DOCNODocument Number/SCDL/DB_PROCH_IDOCNO
ITEMNOItem Number/SCDL/DB_PROCI_IITEMNO
ITEMCATItem Category/SCDL/DB_PROCI_IITEMCAT
ITEMTYPEItem Type/SCDL/DB_PROCI_IITEMTYPE
DOCTYPEDocument Type/SCDL/DB_PROCH_IDOCTYPE
LGNUMWarehouse Number/Warehouse Complex/SCDL/DB_PROCI_I/SCWM/WHNO
INCO1Incoterms (Part 1)/SCDL/DB_PROCH_IINCO1
INCO2Incoterms (Part 2)/SCDL/DB_PROCH_IINCO2
PRODUCTIDProduct ID/SCDL/DB_PROCI_IPRODUCTID
PRODUCTNOProduct/SCDL/DB_PROCI_IPRODUCTNO
GROSWWeight of Delivery/SCDL/DB_ADDMEASQTY
GWUOMUnit of Measure/SCDL/DB_ADDMEASUOM
GROSVVolume of Delivery/SCDL/DB_ADDMEASQTY
GVUOMUnit of Measure/SCDL/DB_ADDMEASUOM
ITEM_QTYQuantity/SCDL/DB_ADDMEASQTY
ITEM_QTY_UOMUnit of Measure/SCDL/DB_ADDMEASUOM
BATCHNOBatch Number/SCDL/DB_PROCI_IBATCHNO
ENTITLEDParty Entitled to Dispose/SCDL/DB_PROCI_IENTITLED
STOCK_USAGEStock Usage/SCDL/DB_PROCI_ISTOCK_USAGE
OWNEROwner/SCDL/DB_PROCI_ISTOCK_OWNER
CARRIERNOCarrier/SCDL/DB_BPLOCPARTYNO
TRANS_MODETransportation Mode/SCDL/DB_TRANSTRANS_MODE
MTRMeans of Transport/SCDL/DB_TRANSTRANSMEANS_TYPE
REFDOCNO_EROReference Document Number/SCDL/DB_REFDOCREFDOCNO
REFITEMNO_EROReference Item Number/SCDL/DB_REFDOCREFITEMNO
COOCountry of Origin/SCDL/DB_PROCI_IOCOUNTRY
VFDATBest-Before Date/Shelf Life Expiration Date/SCDL/DB_PROCI_IBESTBEFORE_DATE/SHELFEXPIR_DATE
PSAProduction Supply Area (PSA)/SCDL/DB_PROCI_I/SCWM/PSA
VALUEProduct Value
WAERSCurrency Key/SCWM/T_VALUATE //SCWM/T_VAL_SPLTWAERS
COMPL_TSCompletion Date/Time/SCDL/DB_STATUSTSTFR
ZERO_QTY_DLVIDelivery Item with Zero Quantity/SCDL/DB_PROCI_IQTY
DLV_PROC_INDDelivery Item Business Process for BW reporting
NOT_RELEVANTDelivery Item Relevance Flag
SERVICE_LEVELShipping Condition/SCDL/DB_PROCI_ISERVICE_LEVEL
WHS_TZONETime Zone of Warehouse/SCMB/TOENTITYTZONE
GR_TSGoods Receipt Date/Time/SCDL/DB_DATETSTFR
PL_DLV_TSPlanned Delivery Date/Time/SCDL/DB_DATETSTFR
SHIP_FR_NOShip-From/SCDL/DB_BPLOCPARTYNO
PROD_DATProduction Date/SCDL/DB_PROCI_IPRODUCTION_DATE
Q_RELQ-Relevance
STOCK_TYPEStock Type/SCDL/DB_PROCI_ISTOCK_CATEGORY

Outbound delivery items:

This DataSource provides you with completed outbound delivery items.

Fields of Origin for the Extract Structure
Fields in the Extract StructureDescription of the Field in the Extract StructureTable of OriginField in the Table of Origin
DOCIDDocument ID/SCDL/DB_DLVH_ODOCID
ITEMIDItem ID/SCDL/DB_DLVI_OITEMID
DOCNODocument Number/SCDL/DB_DLVH_ODOCNO
ITEMNOItem Number/SCDL/DB_DLVI_OITEMNO
ITEMCATItem Category/SCDL/DB_DLVI_OITEMCAT
ITEMTYPEItem Type/SCDL/DB_DLVI_OITEMTYPE
DOCTYPEDocument Type/SCDL/DB_DLVH_ODOCTYPE
LGNUMWarehouse Number/Warehouse Complex/SCDL/DB_PROCI_O/SCWM/WHNO
INCO1Incoterms (Part 1)/SCDL/DB_DLVH_OINCO1
INCO2Incoterms (Part 2)/SCDL/DB_DLVH_OINCO2
PRODUCTIDProduct ID/SCDL/DB_PROCI_OPRODUCTID
PRODUCTNOProduct/SCDL/DB_PROCI_OPRODUCTNO
GROSWWeight of Delivery/SCDL/DB_ADDMEASQTY
GWUOMUnit of Measure/SCDL/DB_ADDMEASUOM
GROSVVolume of Delivery/SCDL/DB_ADDMEASQTY
GVUOMUnit of Measure/SCDL/DB_ADDMEASUOM
ITEM_QTYQuantity/SCDL/DB_ADDMEASQTY
ITEM_QTY_UOMUnit of Measure/SCDL/DB_ADDMEASUOM
BATCHNOBatch Number/SCDL/DB_PROCI_OBATCHNO
ENTITLEDParty Entitled to Dispose/SCDL/DB_PROCI_OENTITLED
STOCK_USAGEStock Usage/SCDL/DB_PROCI_OSTOCK_USAGE
OWNEROwner/SCDL/DB_PROCI_OSTOCK_OWNER
CARRIERNOCarrier/SCDL/DB_BPLOCPARTYNO
TRANS_MODETransportation Mode/SCDL/DB_TRANSTRANS_MODE
MTRMeans of Transport/SCDL/DB_TRANSTRANSMEANS_TYPE
REFDOCNO_EROReference Document Number/SCDL/DB_REFDOCREFDOCNO
REFITEMNO_EROReference Item Number/SCDL/DB_REFDOCREFITEMNO
COOCountry of Origin/SCDL/DB_PROCI_OOCOUNTRY
VFDATBest-Before Date/Shelf Life Expiration Date/SCDL/DB_PROCI_OBESTBEFORE_DATE/SHELFEXPIR_DATE
PSAProduction Supply Area (PSA)/SCDL/DB_PROCI_O/SCWM/PSA
VALUEProduct Value
WAERSCurrency Key/SCWM/T_VALUATE//SCWM/T_VAL_SPLTWAERS
COMPL_TSCompletion Date/Time/SCDL/DB_STATUSTSTFR
ZERO_QTY_DLVIDelivery Item with Zero Quantity/SCDL/DB_PROCI_OQTY
DLV_PROC_INDDelivery Item Business Process for BW Reporting
NOT_RELEVANTDelivery Item Relevance Flag
SERVICE_LEVELShipping Condition/SCDL/DB_PROCI_OSERVICE_LEVEL
WHS_TZONETime Zone of Warehouse/SCMB/TOENTITYTZONE
GI_TSGoods Issue Date/Time/SCDL/DB_DATETSTTO
SHIP_TO_NOShip-To/SCDL/DB_BPLOCPARTYNO
ROUTE_IDRoute Name (Identification)/SCDL/DB_TRANSROUTE_ID
PRIORITYDelivery Priority/SCDL/DB_PROCI_OPRIORITY
EXPRT_RELExport Relevancy (Only Integration)/SCDL/DB_TRANS/SCWM/GTS_CODE
DELAY_IN_MINDelay of Outbound Delivery Item in Minutes
POD_RELRelevant for Proof of Delivery/SCDL/DB_PROCI_O/SCWM/POD_REL

for more information on SAP EWM Analytics  SAP EWM data source please click here