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