S410BIW2 - S410BIW2 * SIS: Business Location Statistics via 'Ship-to' (

S410BIW2 * SIS: Business Location Statistics via 'Ship-to' ( information is stored in SAP table S410BIW2.
It is part of development package OI0_BW in software component IS-OIL-DS. This development package consists of objects that can be grouped under "Oil/BW Business Information Warehouse (extractors,..)".

Fields for table S410BIW2

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
SSOURStatistic(s) originXSSOURCHAR8
VRSIOVersion number in the information structureXVRSIOCHAR6*
SPMONPeriod to analyze - monthXSPMONNUMC12
SPTAGPeriod to analyze - current dateXSPTAGDATS16
SPWOCPeriod to analyze - weekXSPWOCNUMC12
SPBUPPeriod to analyze - posting periodXSPBUPNUMC12
OIPBLPBusiness location identifier (IS-Oil MRN)XOIF_PBLNRPCHAR20OIFSPBL
KUNNRShip-to PartyXKUNWECHAR20KNA1
VKORGSales OrganizationXVKORGCHAR8TVKO
VTWEGDistribution ChannelXVTWEGCHAR4TVTW
SPARTDivisionXSPARTCHAR4TSPA
MATNRMaterial NumberXMATNRCHAR80MARA
PERIVFiscal Year VariantPERIVCHAR4T009
VWDATPointer to administrative dataVWDATNUMC20
STWAEStatistics currencyWAERS_VCUKY10*
BASMEBase Unit of MeasureMEINSUNIT6*
AENETWRNet Value of Incoming OrdersMC_AENETWRCURR10
UMNETWRNet Value of Invoiced SalesMC_UMNETWRCURR10
OAUWENet Value of Open OrdersMC_OAUWECURR10
RENETWRNet Value of Incoming ReturnsMC_RENETWRCURR10
GUNETWRNet Value of Credit MemosMC_GUNETWRCURR10
AEMENGEIncoming Orders QuantityMC_AEMENGEQUAN8
UMMENGESales Volume QuantityMC_UMMENGEQUAN8
OAUMEOpen orders quantity in base unit of measureMC_OAUMEQUAN8
REMENGEQuantity of ReturnsMC_REMENGEQUAN8
GUMENGEQuantity of Credit MemosMC_GUMENGEQUAN8
ANZAUPOSNumber of Order ItemsMC_ANZAUPODEC5
ANZREPOSNo.of returns itemsMC_ANZREPODEC5
AEWAVWRCost of incoming ordersMC_AEWAVWRCURR10
UMWAVWRCost of invoiced salesMC_UMWAVWRCURR10
REWAVWRIncoming returns: costMC_REWAVWRCURR10
GUWAVWRCredit memos: costMC_GUWAVWRCURR10
AEKZWI1Incoming orders: grossMC_AEKZWI1CURR9
UMKZWI1Invoiced sales: grossMC_UMKZWI1CURR9
REKZWI1Incoming returns: grossMC_REKZWI1CURR9
GUKZWI1Credit memos: grossMC_GUKZWI1CURR9
AEKZWI2Incoming orders: net 1MC_AEKZWI2CURR9
UMKZWI2Invoiced sales: net 1MC_UMKZWI2CURR9
REKZWI2Incoming returns: net 1MC_REKZWI2CURR9
GUKZWI2Credit memos: net 1MC_GUKZWI2CURR9
AEKZWI3Incoming orders: net 2MC_AEKZWI3CURR9
UMKZWI3Invoiced sales: net 2MC_UMKZWI3CURR9
REKZWI3Incoming returns: net 2MC_REKZWI3CURR9
GUKZWI3Credit memos: net 2MC_GUKZWI3CURR9
AEKZWI4Incoming orders: freightMC_AEKZWI4CURR9
UMKZWI4Invoice freight chargesMC_UMKZWI4CURR9
REKZWI4Incoming returns: freightMC_REKZWI4CURR9
GUKZWI4Credit memos: freightMC_GUKZWI4CURR9
AEKZWI5Incoming orders: pricing subtotal 5MC_AEKZWI5CURR9
UMKZWI5Billing document: pricing subtotal 5MC_UMKZWI5CURR9
REKZWI5Incoming returns: pricing subtotal 5MC_REKZWI5CURR9
GUKZWI5Credit memos: pricing subtotal 5MC_GUKZWI5CURR9
AEKZWI6Incoming orders: pricing subtotal 6MC_AEKZWI6CURR9
UMKZWI6Billing document: pricing subtotal 6MC_UMKZWI6CURR9
REKZWI6Incoming returns: pricing subtotal 6MC_REKZWI6CURR9
GUKZWI6Credit memos: pricing subtotal 6MC_GUKZWI6CURR9
Privacy Policy