SAP ABAP Table S081 (Purchasing: Stock)
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 S081   Table Relationship Diagram
Short Description Purchasing: Stock    
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 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
3 EKSGB EKSGB EKSGB CHAR 4   0   Purchasing area T026
4 EKGRP EKGRP EKGRP CHAR 3   0   Purchasing group T024
5 LIFNR ELIFN LIFNR CHAR 10   0   Vendor's account number LFA1
6 BTRKZ VLFKZ VLFKZ CHAR 1   0   Plant category  
7 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
8 WGRU2 MCW_WGRU2 KLASSE CHAR 18   0   Material group hierarchy 2  
9 WGRU1 MCW_WGRU1 KLASSE CHAR 18   0   Material group hierarchy 1  
10 MATKL MATKL MATKL CHAR 9   0   Material Group T023
11 VRSIO VRSIO VRSIO CHAR 3   0   Version number in the information structure *
12 SPMON SPMON MCPERIOD NUMC 6   0   Period to analyze - month  
13 SPTAG SPTAG DATUM DATS 8   0   Period to analyze - current date  
14 SPWOC SPWOC MCPERIOD NUMC 6   0   Period to analyze - week  
15 SPBUP SPBUP MCPERIOD NUMC 6   0   Period to analyze - posting period  
16 SSOUR SSOUR SSOUR CHAR 4   0   Statistic(s) origin  
17 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
18 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
19 BASME MEINS MEINS UNIT 3   0   Base Unit of Measure T006
20 HWAER HWAER WAERS CUKY 5   0   Local Currency TCURC
21 BSTMNG MCW_BSTMNG MENGV15_3 QUAN 15   3   Stock quantity in base unit of measure  
22 BSTGEO MCW_BSTGEO WERTV10 CURR 19   2   Stock at cost  
23 BSTGVO MCW_BSTGVO WERTV10 CURR 19   2   Stock at retail  
24 BSTGVP MCW_BSTGVP WERTV10 CURR 19   2   Stock at retail with tax  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S081 BASME T006 MSEHI    
2 S081 EKGRP T024 EKGRP    
3 S081 EKORG T024E EKORG    
4 S081 EKSGB T026 EKSGB    
5 S081 HWAER TCURC WAERS    
6 S081 LIFNR LFA1 LIFNR    
7 S081 MANDT T000 MANDT    
8 S081 MATKL T023 MATKL    
9 S081 WERKS T001W WERKS    
History
Last changed by/on SAP  20050411 
SAP Release Created in