SAP ABAP Table S137 (Variants: Basis 2)

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	S137	Table Relationship Diagram
Short Description	Variants: Basis 2

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	VBELN	☑	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
9	POSNR	☑	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
10	CUOBJ	☑	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
11	CLINT	☑	CHKEYGRP	VTINT	NUMC	10	0	Characteristics combination
12	LNPOS	☑	CHCOMBKEY	NUM05	NUMC	5	0	Combination value key
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	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
17	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
18	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
19	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
20	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
21	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
22	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
23	AEMENGE	☐	MC_AEMENGE	MENGV15_3	QUAN	15	3	Incoming orders quantity
24	AENETWR	☐	MC_AENETWR	WERTV10	CURR	19	2	Net value of incoming orders
25	AEKZWI1	☐	MC_AEKZWI1	WERTV9	CURR	17	2	Incoming orders: gross
26	AEKZWI2	☐	MC_AEKZWI2	WERTV9	CURR	17	2	Incoming orders: net 1
27	AEKZWI3	☐	MC_AEKZWI3	WERTV9	CURR	17	2	Incoming orders: net 2
28	AEKZWI4	☐	MC_AEKZWI4	WERTV9	CURR	17	2	Incoming orders: freight
29	AEKZWI5	☐	MC_AEKZWI5	WERTV9	CURR	17	2	Incoming orders: pricing subtotal 5
30	AEKZWI6	☐	MC_AEKZWI6	WERTV9	CURR	17	2	Incoming orders: pricing subtotal 6
31	AEMENGB	☐	AEMENGB	MENGV15_3	QUAN	15	3	Qty. incoming orders based on confirm. date of sched. line
32	OEIMEB	☐	OEIMEB	MENGV15_3	QUAN	15	3	Open order qty. based on confirmation date of sched. line
33	OEIMEW	☐	OEIMEW	MENGV15_3	QUAN	15	3	Open order qty. based on desired del. date of sched. line
34	OEIWEB	☐	OEIWEB	WERTV10	CURR	19	2	Open order value based on confirmation date of sched. line
35	OEIWEW	☐	OEIWEW	WERTV10	CURR	19	2	Open order value based on desired del. date of sched. line
36	LGMNG	☐	MC_LGMNG	MENGV15_3	QUAN	15	3	Delivery quantity in base unit of measure
37	UMNETWR	☐	MC_UMNETWR	WERTV10	CURR	19	2	Net value of invoiced sales

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S137	BASME	T006	MSEHI
2	S137	KUNNR	KNA1	KUNNR
3	S137	MANDT	T000	MANDT	KEY
4	S137	MATNR	MARA	MATNR
5	S137	POSNR	VBUP	POSNR	KEY
6	S137	SPART	TSPA	SPART
7	S137	STWAE	TCURC	WAERS
8	S137	VBELN	VBUK	VBELN	KEY
9	S137	VKORG	TVKO	VKORG
10	S137	VTWEG	TVKOV	VTWEG
11	S137	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in