SAP ABAP Table S138 (Variants: SIS & planning)

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	S138	Table Relationship Diagram
Short Description	Variants: SIS & planning

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	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
9	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
10	SPART	☑	SPART	SPART	CHAR	2	0	Division	TVTA
11	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
12	KUNNR	☑	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
13	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
14	CLINT	☑	CHKEYGRP	VTINT	NUMC	10	0	Characteristics combination
15	LNPOS	☑	CHCOMBKEY	NUM05	NUMC	5	0	Combination value key
16	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
17	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
18	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
19	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
20	AEMENGE	☐	MC_AEMENGE	MENGV15_3	QUAN	15	3	Incoming orders quantity
21	AENETWR	☐	MC_AENETWR	WERTV10	CURR	19	2	Net value of incoming orders
22	AEKZWI1	☐	MC_AEKZWI1	WERTV9	CURR	17	2	Incoming orders: gross
23	AEKZWI2	☐	MC_AEKZWI2	WERTV9	CURR	17	2	Incoming orders: net 1
24	AEKZWI3	☐	MC_AEKZWI3	WERTV9	CURR	17	2	Incoming orders: net 2
25	AEKZWI4	☐	MC_AEKZWI4	WERTV9	CURR	17	2	Incoming orders: freight
26	AEKZWI5	☐	MC_AEKZWI5	WERTV9	CURR	17	2	Incoming orders: pricing subtotal 5
27	AEKZWI6	☐	MC_AEKZWI6	WERTV9	CURR	17	2	Incoming orders: pricing subtotal 6
28	AEMENGB	☐	AEMENGB	MENGV15_3	QUAN	15	3	Qty. incoming orders based on confirm. date of sched. line
29	OEIMEB	☐	OEIMEB	MENGV15_3	QUAN	15	3	Open order qty. based on confirmation date of sched. line
30	OEIMEW	☐	OEIMEW	MENGV15_3	QUAN	15	3	Open order qty. based on desired del. date of sched. line
31	OEIWEB	☐	OEIWEB	WERTV10	CURR	19	2	Open order value based on confirmation date of sched. line
32	OEIWEW	☐	OEIWEW	WERTV10	CURR	19	2	Open order value based on desired del. date of sched. line
33	LGMNG	☐	MC_LGMNG	MENGV15_3	QUAN	15	3	Delivery quantity in base unit of measure
34	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	S138	BASME	T006	MSEHI
2	S138	KUNNR	KNA1	KUNNR	KEY
3	S138	MANDT	T000	MANDT	KEY
4	S138	MATNR	MARA	MATNR	KEY
5	S138	SPART	TVTA	SPART	KEY
6	S138	STWAE	TCURC	WAERS
7	S138	VKORG	TVKO	VKORG	KEY
8	S138	VTWEG	TVKOV	VTWEG	KEY
9	S138	WERKS	T001W	WERKS	KEY

History

Last changed by/on	SAP	20050411
SAP Release Created in