SAP ABAP Table OIUREP_SALESTYPE (MMS-2014 - Sales Type)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_REP (Package) Production, Tax & Royalty Reporting
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIUREP_SALESTYPE   Table Relationship Diagram
Short Description MMS-2014 - Sales Type    
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 .INCLUDE       0   0   Production: MMS-2014 - Sales Type Key Fields  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 LEASE_RECORD_NO OIUREP_MMS_2014_LEASE_REC_NO   NUMC 20   0   Production: MMS-2014 - Lease Record Number  
4 SALES_TYPE_CD OIUREP_MMS_2014_SALES_TYPE_CD OIUREP_MMS_2014_SALES_TYPE_CD CHAR 4   0   Production: MMS-2014 - Sales Type Code OIUREP_SALESTY
5 MATNR MATNR MATNR CHAR 18   0   Material Number OIUREP_PRDCDXREF
6 MMS_PRODUCT_CD OIUREP_MMS_PRODUCT_CODE OIUREP_MMS_PRODUCT_CODE CHAR 2   0   Production: MMS Product Code *
7 CT_NO OIU_CT_NO OIUCM_CONTRACT_NUMBER CHAR 10   0   Contract Number OIUCM_CONTRACT
8 EFF_FROM_DT OIU_EFF_FROM_DT DATUM DATS 8   0   Effective from date  
9 .INCLUDE       0   0   Production: MMS-2014 - Sales Type Non Key Fields  
10 EFF_TO_DT OIU_EFF_TO_DT DATUM DATS 8   0   Effective To Date  
11 TRNSP_ALLW_FAC OIUREP_MMS_2014_TRNSP_ALLW_FAC   CURR 15   8   MMS-2014 - Transportation Allowance Factor  
12 TRNSP_ALLW_CUR OIUREP_MMS_2014_TRNSP_ALLW_CUR WAERS CUKY 5   0   MMS-2014 - Transportation Allowance Currency TCURC
13 MFRING_UOM_AMT OIUREP_MMS_2014_MFRING_UOM_AMT OIUCM_CURRENCY_15_DECIMAL_2 CURR 15   2   Production: MMS-2014 - Manufacturing UOM Amount  
14 MFRING_UOM_CUR OIUREP_MMS_2014_MFRING_UOM_CUR WAERS CUKY 5   0   Production: MMS-2014 - Manufacturing UOM Currency TCURC
15 MFRER_UOM_PC OIUREP_MMS_2014_MFRER_UM_PC   DEC 9   8   MMS-2014 - Manufacturer UOM Percent  
16 ROYAL_IN_KIND_FL OIUREP_MMS_2014_ROY_IN_KIND_FL YESNO CHAR 1   0   Production: MMS-2014 - Royalty In Kind Flag  
17 SA_TYPE_ALLOC_PC OIUREP_MMS_2014_SA_TP_ALLOC_PC   DEC 9   8   Production: MMS-2014 - Sales Type Allocation Percentage  
18 TXN_OVERRIDE OIUREP_MMS_2014_TRANS_CD OIUREP_MMS_2014_TRANS_CD CHAR 2   0   Production: MMS-2014 - Transaction Code  
19 .INCLUDE       0   0   Creator and date/time created  
20 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
21 OIU_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
22 .INCLUDE       0   0   Change Username & Timestamp  
23 CHANGE_USER AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
24 CHANGE_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIUREP_SALESTYPE CT_NO OIUCM_CONTRACT VBELN    
2 OIUREP_SALESTYPE MANDT T000 MANDT    
3 OIUREP_SALESTYPE MATNR OIUREP_PRDCDXREF MATNR    
4 OIUREP_SALESTYPE MFRING_UOM_CUR TCURC WAERS    
5 OIUREP_SALESTYPE SALES_TYPE_CD OIUREP_SALESTY SALES_TYPE_CD    
6 OIUREP_SALESTYPE TRNSP_ALLW_CUR TCURC WAERS    
History
Last changed by/on SAP  20050411 
SAP Release Created in 46C