SAP ABAP Table S279BIW1 (S279BIW1 * BW Transfer: Inventory Management)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-LIS-DC (Application Component) Data Collection
     ⤷ MCBW (Package) Logistics Extractors for SAP BW, Release-Independent

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S279BIW1	Table Relationship Diagram
Short Description	S279BIW1 * BW Transfer: Inventory Management

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	BWBELN	☑	MCBW_BELN	VBELN	CHAR	10	0	BW: Document Number	VBUK
9	BWBLPOS	☑	MCBW_BLPOS	POSNR	NUMC	6	0	BW: Document Item Number	VBUP
10	BWBJAHR	☑	MCBW_BJAHR	GJAHR	NUMC	4	0	BW: Document Year
11	BSTTYP	☑	BSTTYP	BSTTYP	CHAR	1	0	Stock categories in the Logistics Information System
12	BWVORG	☑	MCBW_VORG	NUM3	NUMC	3	0	BW: Transaction Key SAP BW
13	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
14	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
15	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
16	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
17	BWMNG	☐	MCBW_MNG	MENGV15_3	QUAN	15	3	BW: Quantity in Base Unit of Measure
18	BWGEO	☐	MCBW_GEO	WERTV10	CURR	19	2	BW: Cost Value in Local Currency
19	BWGVO	☐	MCBW_GVO	WERTV10	CURR	19	2	BW: Retail Value in Local Currency
20	BWGVP	☐	MCBW_GVP	WERTV10	CURR	19	2	BW: Retail Value with Tax in Local Currency
21	BWANZ	☐	MCBW_ANZ	MCZAEHLINT	INT4	10	0	BW: Number of Transactions
22	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
23	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
24	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
25	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
26	GRUND	☐	MB_GRUND	NUMC4	NUMC	4	0	Reason for goods movment
27	BSTAUS	☐	MCBW_BAUS	MCBW_BAUS	CHAR	1	0	BW: Stock Characteristic Value
28	BWBREL	☐	MCBW_BREL	MCBW_BREL	CHAR	1	0	BW: Stock Relevance
29	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
30	PKUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
31	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
32	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
33	BWAPPLNM	☐	RSAPPLNM	RSAPPLNM	CHAR	30	0	Application Component
34	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
35	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
36	UMWRK	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W
37	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
38	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
39	PS_POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S279BIW1	AKTNR	WAKH	AKTNR
2	S279BIW1	BASME	T006	MSEHI
3	S279BIW1	BWART	T156	BWART
4	S279BIW1	BWBELN	VBUK	VBELN
5	S279BIW1	BWBLPOS	VBUP	POSNR
6	S279BIW1	BWTAR	T149D	BWTAR
7	S279BIW1	CHARG	MCHA	CHARG
8	S279BIW1	HWAER	TCURC	WAERS
9	S279BIW1	KDAUF	VBUK	VBELN
10	S279BIW1	LGORT	T001L	LGORT
11	S279BIW1	LIFNR	LFA1	LIFNR
12	S279BIW1	MANDT	T000	MANDT
13	S279BIW1	MATNR	MARA	MATNR
14	S279BIW1	PKUNAG	KNA1	KUNNR
15	S279BIW1	UMWRK	T001W	WERKS
16	S279BIW1	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in