SAP ABAP Table OIUVL_STTR (State Tax Rates)
Hierarchy
IS-OIL (Software Component) IS-OIL
   IS-OIL-PRA-REV-VAL (Application Component) Valuation
     OIU_RVVA (Package) PRA Valuation (Revenue)
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIUVL_STTR   Table Relationship Diagram
Short Description State Tax Rates    
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 *
2 PRI_GEO_LOC OIU_PRI_GEO_LOC OIU_PRI_GEO_LOC CHAR 2   0   Primary geographical location (PRI geo. loc.) OIU_CM_LXPGL
3 LAND1 OIU_COUNTRY LAND1 CHAR 3   0   Country T005
4 SEVT_TAX_TY OIU_SEVT_TAX_TY OIU_SEVT_TAX_TY CHAR 2   0   Severance Tax Type OIU_CM_SEVTGRP
5 MAJPD_CD OIU_MAJPD_CD OIU_MAJPD_CD CHAR 1   0   Major product code  
6 EFF_FROM_DT OIU_EFF_FROM_DT DATUM DATS 8   0   Effective from date  
7 TAX_CLASS OIU_TAX_CLS OIU_TAX_CLS CHAR 4   0   Tax Class OIU_CM_TAXCLS
8 SCHOOL_DIST_CD OIU_SCHOOL_DIST_CD OIU_SCHOOL_DIST_CD CHAR 3   0   School district code OIU_CM_SCHDCD
9 SEC_GEO_LOC OIU_SEC_GEO_LOC OIU_SEC_GEO_LOC CHAR 3   0   Secondary geographic location OIU_CM_LXSGL
10 EFF_TO_DT OIU_EFF_TO_DT DATUM DATS 8   0   Effective To Date  
11 VOL_RATE OIUVL_VOL_RATE OIU_PERCENT76 DEC 7   6   Volume Rate  
12 VOL_RATE_MIN OIUVL_VOL_RATE_MIN OIU_PERCENT76 DEC 7   6   Volume Rate Minimum  
13 VOL_RATE_MAX OIUVL_VOL_RATE_MAX OIU_PERCENT76 DEC 7   6   Volume Rate Maximum  
14 VAL_RATE OIUVL_VAL_RATE OIU_PERCENT76 DEC 7   6   Valuation Rate  
15 VAL_RATE_MIN OIUVL_VAL_RATE_MIN OIU_PERCENT76 DEC 7   6   Valuation Rate Minimum  
16 VAL_RATE_MAX OIUVL_VAL_RATE_MAX OIU_PERCENT76 DEC 7   6   Valuation Rate Maximum  
17 MSEHI OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
18 PRC_LIM_AM OIUVL_PRC_LIM_AM WERT7 CURR 13   2   Price Limit  
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)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIUVL_STTR LAND1 T005 LAND1 KEY 1 CN
2 OIUVL_STTR PRI_GEO_LOC OIU_CM_LXPGL PRI_GEO_LOC KEY 1 CN
3 OIUVL_STTR SCHOOL_DIST_CD OIU_CM_SCHDCD SCHOOL_DIST_CD 1 CN
4 OIUVL_STTR SEC_GEO_LOC OIU_CM_LXSGL SEC_GEO_LOC 1 CN
5 OIUVL_STTR SEVT_TAX_TY OIU_CM_SEVTGRP SEVT_TAX_TY 1 CN
6 OIUVL_STTR TAX_CLASS OIU_CM_TAXCLS TAX_CLS 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in