SAP ABAP Table S160 (Perishables)

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	S160	Table Relationship Diagram
Short Description	Perishables

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	EKGRP	☑	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
9	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	BTRKZ	☑	VLFKZ	VLFKZ	CHAR	1	0	Plant category
11	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
12	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
13	SATNR	☑	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
14	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
15	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
16	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
17	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
18	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
19	BVLMNG	☐	MCW_BVLMNG	MENGV15_3	QUAN	15	3	Order volume quantity Retail
20	BVLGEO	☐	MCW_BVLGEO	WERTV10	CURR	19	2	Order volume at cost
21	BVLGVO	☐	MCW_BVLGVO	WERTV10	CURR	19	2	Order volume at retail
22	BVLGVP	☐	MCW_BVLGVP	WERTV10	CURR	19	2	Order volume at retail with tax
23	WESMNG	☐	MCW_WESMNG	MENGV15_3	QUAN	15	3	Goods receipt (vendor) quantity in BUn
24	WESGEO	☐	MCW_WESGEO	WERTV10	CURR	19	2	Goods receipt (vendor) at cost
25	WESGVO	☐	MCW_WESGVO	WERTV10	CURR	19	2	Goods receipt (vendor) at retail
26	WESGVP	☐	MCW_WESGVP	WERTV10	CURR	19	2	Goods receipt (vendor) at retail with tax
27	RTEMNG	☐	MCW_RTEMNG	MENGV15_3	QUAN	15	3	Returns to vendor quantity in base unit of measure
28	RTEGEO	☐	MCW_RTEGEO	WERTV10	CURR	19	2	Returns to vendor at cost
29	RTEGVO	☐	MCW_RTEGVO	WERTV10	CURR	19	2	Returns to vendor at retail
30	RTEGVP	☐	MCW_RTEGVP	WERTV10	CURR	19	2	Returns to vendor at retail with tax
31	ULVMNG	☐	MCW_ULVMNG	MENGV15_3	QUAN	15	3	Stock transport order quantity
32	ULVGEO	☐	MCW_ULVGEO	WERTV10	CURR	19	2	Stock transport order at cost
33	ULVGVO	☐	MCW_ULVGVO	WERTV10	CURR	19	2	Stock transport order at retail
34	ULVGVP	☐	MCW_ULVGVP	WERTV10	CURR	19	2	Stock transport order at retail with tax
35	UAVMNG	☐	MCW_UAVMNG	MENGV15_3	QUAN	15	3	Stock transport order 2 (supplying site view), quantity
36	UAVGEO	☐	MCW_UAVGEO	WERTV10	CURR	19	2	Stock transport order 2 (supplying site view) at cost
37	UAVGVO	☐	MCW_UAVGVO	WERTV10	CURR	19	2	Stock transport order 2 (supplying site view) at retail
38	UAVGVP	☐	MCW_UAVGVP	WERTV10	CURR	19	2	Stock transport order 2 (supplying site view) at retail w/T
39	KMAMNG	☐	MCW_KMAMNG	MENGV15_3	QUAN	15	3	Goods issue (distribution center) quantity in BUn
40	KMAGEO	☐	MCW_KMAGEO	WERTV10	CURR	19	2	Goods issue (DC) at cost
41	KMAGVO	☐	MCW_KMAGVO	WERTV10	CURR	19	2	Goods issue (DC) at retail
42	KMAGVP	☐	MCW_KMAGVP	WERTV10	CURR	19	2	Goods issue (dist. center) at retail with tax
43	KMEMNG	☐	MCW_KMEMNG	MENGV15_3	QUAN	15	3	Goods receipt (distribution center) quantity in BUn
44	KMEGEO	☐	MCW_KMEGEO	WERTV10	CURR	19	2	Goods receipt (DC) at cost
45	KMEGVO	☐	MCW_KMEGVO	WERTV10	CURR	19	2	Goods receipt (DC) at retail
46	KMEGVP	☐	MCW_KMEGVP	WERTV10	CURR	19	2	Goods receipt (dist. center) at retail with tax
47	ULAMNG	☐	MCW_ULAMNG	MENGV15_3	QUAN	15	3	Goods clearing: issues quantity in BUn
48	ULAGEO	☐	MCW_ULAGEO	WERTV10	CURR	19	2	Goods clearing: issues at cost
49	ULAGVO	☐	MCW_ULAGVO	WERTV10	CURR	19	2	Goods clearing: issues at retail
50	ULAGVP	☐	MCW_ULAGVP	WERTV10	CURR	19	2	Goods clearing: issues at retail with tax
51	ULEMNG	☐	MCW_ULEMNG	MENGV15_3	QUAN	15	3	Goods clearing: receipts quantity in BUn
52	ULEGEO	☐	MCW_ULEGEO	WERTV10	CURR	19	2	Goods clearing: receipts at cost
53	ULEGVO	☐	MCW_ULEGVO	WERTV10	CURR	19	2	Goods clearing: receipts at retail
54	ULEGVP	☐	MCW_ULEGVP	WERTV10	CURR	19	2	Goods clearing: receipts at retail with tax
55	BKSMMG	☐	MCW_BKSMMG	MENGV15_3	QUAN	15	3	Stock adjustment miscellaneous minus (quantity)
56	BKSMEO	☐	MCW_BKSMEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous minus (cost)
57	BKSMVO	☐	MCW_BKSMVO	WERTV10	CURR	19	2	Stock adjustment miscellaneous minus (retail)
58	BKSMVP	☐	MCW_BKSMVP	WERTV10	CURR	19	2	Stock adjustment miscellaneous minus (retail with tax)
59	UMSMNG	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
60	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
61	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
62	UMSGVP	☐	MCW_UMSGVP	WERTV10	CURR	19	2	Sales at retail with tax
63	PRSNLS	☐	MCW_PRSNLS	WERTV10	CURR	19	2	Sales deviation during sales
64	KAVMNG	☐	MCW_KAVMNG	MENGV15_3	QUAN	15	3	Sales order volume quantity
65	KAVGEO	☐	MCW_KAVGEO	WERTV10	CURR	19	2	Sales order volume at cost
66	KAVGVO	☐	MCW_KAVGVO	WERTV10	CURR	19	2	Sales order volume at retail
67	KAVGVP	☐	MCW_KAVGVP	WERTV10	CURR	19	2	Sales order volume at retail with tax
68	LIFMNG	☐	MCW_LIFMNG	MENGV15_3	QUAN	15	3	Deliveries to customers, quantity
69	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
70	MERK1	☐	MCW_MERK1	ATWRT	CHAR	30	0	Characteristic 1
71	MERK2	☐	MCW_MERK2	ATWRT	CHAR	30	0	Characteristic 2
72	MERK3	☐	MCW_MERK3	ATWRT	CHAR	30	0	Characteristic 3
73	ATINM1	☐	MCW_ATINM1	ATINN	NUMC	10	0	Internal characteristic number, characteristic 1	*
74	ATINM2	☐	MCW_ATINM2	ATINN	NUMC	10	0	Internal characteristic number, characteristic 2	*
75	ATINM3	☐	MCW_ATINM3	ATINN	NUMC	10	0	Internal characteristic number, characteristic 3	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S160	ABTNR	TSAB	ABTNR
2	S160	BASME	T006	MSEHI
3	S160	EKGRP	T024	EKGRP
4	S160	HWAER	TCURC	WAERS
5	S160	LIFNR	LFA1	LIFNR
6	S160	MANDT	T000	MANDT
7	S160	MATKL	T023	MATKL
8	S160	MATNR	MARA	MATNR
9	S160	SATNR	MARA	MATNR
10	S160	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in