SAP ABAP Table S036_KEY (Help structure: Key of table S036)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       OIA (Package) Exg exchanges
Basic Data
Table Category INTTAB    Structure 
Structure S036_KEY   Table Relationship Diagram
Short Description Help structure: Key of table S036    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 P44V
4 SPMON RSCALMONTH RSCALMONTH NUMC 6   0   Calendar year / month  
5 SPTAG RSCALDAY DATUM DATS 8   0   Calendar day  
6 SPWOC RSCALWEEK RSCALWEEK NUMC 6   0   Calendar year / week  
7 SPBUP SPBUP MCPERIOD NUMC 6   0   Period to analyze - posting period  
8 MATREF OIA_MATREF OIA_MATREF CHAR 20   0   Material group reference for exchange balance reporting  
9 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
10 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
11 EXGPTR OIA_EXGPTR LIFNR CHAR 10   0   Exchange partner (vendor number) LFA1
12 UPENR OIA_UPENR CHAR3 CHAR 3   0   Constant to identify logical inventory adjustment  
13 EXGTYP OIA_EXGTYP OIA_EXGTYP CHAR 4   0   Exchange type TOIA2
14 EXGNUM OIA_EXGNUM OIA_EXGNUM CHAR 10   0   Exchange agreement number OIA01
15 MATINEX OIA_MATPST OIA_MATPST CHAR 1   0   Posting rules for material  
16 OIBASPROD OIA_SBMAT MATNR CHAR 18   0   Base product number MARA
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S036_KEY EXGNUM OIA01 EXGNUM KEY C CN
2 S036_KEY EXGPTR LFA1 LIFNR    
3 S036_KEY EXGTYP TOIA2 EXGTYP KEY C CN
4 S036_KEY MANDT T000 MANDT    
5 S036_KEY MATNR MARA MATNR    
6 S036_KEY OIBASPROD MARA MATNR    
7 S036_KEY VRSIO P44V VRSIO    
8 S036_KEY WERKS T001W WERKS    
History
Last changed by/on SAP  20050224 
SAP Release Created in