SAP ABAP Table S087 (Material/add-on)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S087	Table Relationship Diagram
Short Description	Material/add-on

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	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	BTRKZ	☑	VLFKZ	VLFKZ	CHAR	1	0	Plant category
10	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
11	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
12	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
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	RTEMNG	☐	MCW_RTEMNG	MENGV15_3	QUAN	15	3	Returns to vendor quantity in base unit of measure
18	RTEGEO	☐	MCW_RTEGEO	WERTV10	CURR	19	2	Returns to vendor at cost
19	RTEGVO	☐	MCW_RTEGVO	WERTV10	CURR	19	2	Returns to vendor at retail
20	RTEGVP	☐	MCW_RTEGVP	WERTV10	CURR	19	2	Returns to vendor at retail with tax
21	RTEANZ	☐	MCW_RTEANZ	MCZAEHLINT	INT4	10	0	Returns to vendor, no. of transactions
22	ULEMNG	☐	MCW_ULEMNG	MENGV15_3	QUAN	15	3	Goods clearing: receipts quantity in BUn
23	ULEGEO	☐	MCW_ULEGEO	WERTV10	CURR	19	2	Goods clearing: receipts at cost
24	ULEGVO	☐	MCW_ULEGVO	WERTV10	CURR	19	2	Goods clearing: receipts at retail
25	ULEGVP	☐	MCW_ULEGVP	WERTV10	CURR	19	2	Goods clearing: receipts at retail with tax
26	ULEANZ	☐	MCW_ULEANZ	MCZAEHLINT	INT4	10	0	Goods clearing: receipts, no. of transactions
27	ULAMNG	☐	MCW_ULAMNG	MENGV15_3	QUAN	15	3	Goods clearing: issues quantity in BUn
28	ULAGEO	☐	MCW_ULAGEO	WERTV10	CURR	19	2	Goods clearing: issues at cost
29	ULAGVO	☐	MCW_ULAGVO	WERTV10	CURR	19	2	Goods clearing: issues at retail
30	ULAGVP	☐	MCW_ULAGVP	WERTV10	CURR	19	2	Goods clearing: issues at retail with tax
31	ULAANZ	☐	MCW_ULAANZ	MCZAEHLINT	INT4	10	0	Goods clearing: issues, no. of transactions
32	AUEMNG	☐	MCW_AUEMNG	MENGV15_3	QUAN	15	3	Material transfer: receipts quantity BUn
33	AUEGEO	☐	MCW_AUEGEO	WERTV10	CURR	19	2	Material transfer: receipts at cost
34	AUEGVO	☐	MCW_AUEGVO	WERTV10	CURR	19	2	Material transfer: receipts at retail
35	AUEGVP	☐	MCW_AUEGVP	WERTV10	CURR	19	2	Material transfer: receipts at retail with tax
36	AUEANZ	☐	MCW_AUEANZ	MCZAEHLINT	INT4	10	0	Material transfer: receipts, no. transactions
37	AUAMNG	☐	MCW_AUAMNG	MENGV15_3	QUAN	15	3	Material transfer: issues quantity BUn
38	AUAGEO	☐	MCW_AUAGEO	WERTV10	CURR	19	2	Material transfer: issues at cost
39	AUAGVO	☐	MCW_AUAGVO	WERTV10	CURR	19	2	Material transfer: issues at retail
40	AUAGVP	☐	MCW_AUAGVP	WERTV10	CURR	19	2	Material transfer: issues at retail with tax
41	AUAANZ	☐	MCW_AUAANZ	MCZAEHLINT	INT4	10	0	Material transfer: issues, no. of transactions
42	BKIPMG	☐	MCW_BKIPMG	MENGV15_3	QUAN	15	3	Stock adjustment inventory difference plus (quantity)
43	BKIPEO	☐	MCW_BKIPEO	WERTV10	CURR	19	2	Stock adjustment inventory difference plus (cost)
44	BKIPVO	☐	MCW_BKIPVO	WERTV10	CURR	19	2	Stock adjustment inventory difference plus (retail)
45	BKIPVP	☐	MCW_BKIPVP	WERTV10	CURR	19	2	Stock adjustment inventory difference plus (at retail w/tax)
46	BKIPAZ	☐	MCW_BKIPAZ	MCZAEHLINT	INT4	10	0	Stock adjustment inv. difference plus (no. of transactions)
47	BKIMMG	☐	MCW_BKIMMG	MENGV15_3	QUAN	15	3	Stock adjustment inventory difference minus (quantity)
48	BKIMEO	☐	MCW_BKIMEO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (cost)
49	BKIMVO	☐	MCW_BKIMVO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail)
50	BKIMVP	☐	MCW_BKIMVP	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail w/tax)
51	BKIMAZ	☐	MCW_BKIMAZ	MCZAEHLINT	INT4	10	0	Stock adjustment inv. difference minus (no. of transactions)
52	BKSPMG	☐	MCW_BKSPMG	MENGV15_3	QUAN	15	3	Stock adjustment miscellaneous plus (quantity)
53	BKSPEO	☐	MCW_BKSPEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous plus (cost)
54	BKSPVO	☐	MCW_BKSPVO	WERTV10	CURR	19	2	Stock adjustment miscellaneous plus (retail)
55	BKSPVP	☐	MCW_BKSPVP	WERTV10	CURR	19	2	Stock adjustment miscellaneous plus (retail with tax)
56	BKSPAZ	☐	MCW_BKSPAZ	MCZAEHLINT	INT4	10	0	Stock adjustment miscellaneous plus (no. of transactions)
57	BKSMMG	☐	MCW_BKSMMG	MENGV15_3	QUAN	15	3	Stock adjustment miscellaneous minus (quantity)
58	BKSMEO	☐	MCW_BKSMEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous minus (cost)
59	BKSMVO	☐	MCW_BKSMVO	WERTV10	CURR	19	2	Stock adjustment miscellaneous minus (retail)
60	BKSMVP	☐	MCW_BKSMVP	WERTV10	CURR	19	2	Stock adjustment miscellaneous minus (retail with tax)
61	BKSMAZ	☐	MCW_BKSMAZ	MCZAEHLINT	INT4	10	0	Stock adjustment miscellaneous minus (no. of transactions)
62	UBPEPM	☐	MCW_UBPEPM	MENGV15_3	QUAN	15	3	Revaluation at cost, plus, quantity
63	UBPGEO	☐	MCW_UBPGEO	WERTV10	CURR	19	2	Revaluation at cost, plus
64	UBPEAZ	☐	MCW_UBPEAZ	MCZAEHLINT	INT4	10	0	Revaluation at cost plus, no. of transactions
65	UBMEPM	☐	MCW_UBMEPM	MENGV15_3	QUAN	15	3	Revaluation at cost minus, quantity
66	UBMGEO	☐	MCW_UBMGEO	WERTV10	CURR	19	2	Revaluation at cost, minus
67	UBMEAZ	☐	MCW_UBMEAZ	MCZAEHLINT	INT4	10	0	Revaluation at cost minus, no. of transactions

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S087	BASME	T006	MSEHI
2	S087	HWAER	TCURC	WAERS
3	S087	LIFNR	LFA1	LIFNR
4	S087	MANDT	T000	MANDT
5	S087	MATKL	T023	MATKL
6	S087	MATNR	MARA	MATNR
7	S087	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in