SAP ABAP Table ROIUX5_OK_OOS_WO_ALV_0100 (Tax 2.0 - Oklahoma Out Of Statute Write Off ALV Structure)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
     ⤷ OIU_X5 (Package) Tax 2.0 - Oklahoma Tax
Basic Data
Table Category INTTAB    Structure 
Structure ROIUX5_OK_OOS_WO_ALV_0100   Table Relationship Diagram
Short Description Tax 2.0 - Oklahoma Out Of Statute Write Off ALV Structure    
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 .INCLUDE       0   0   Tax 2.0 - Oklahoma Out Of Statute Transactions  
2 MANDT MANDT MANDT CLNT 3   0   Client *
3 .INCLUDE       0   0   Tax 2.0 - Oklahoma Tax Transactions Key Fields  
4 .INCLUDE       0   0   Tax 2.0 - Oklahoma Tax Reversal Key Fields  
5 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
6 SALES_DT OIU_SALE_DT DATUM DATS 8   0   Sales Date / Month  
7 PDCD OIU_FULL_PD_CD OIU_FULL_PD_CD CHAR 3   0   Full three char. product code (Major and Detail Products) *
8 WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number *
9 WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number *
10 MP_NO OIU_MP_NO OIU_MP_NO CHAR 20   0   Measurement point number *
11 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture *
12 DOI_NO OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) *
13 DN_NO OIU_DN_NO OIU_DN_NO CHAR 20   0   Delivery network number *
14 CT_NO OIU_CT_NO OIUCM_CONTRACT_NUMBER CHAR 10   0   Contract Number *
15 VL_TYPE_CD OIU_VT_CD OIU_VL_TYPE_CD CHAR 2   0   Volume type code OIU_PR_VLTYP
16 TAX_CLS OIU_TAX_CLS OIU_TAX_CLS CHAR 4   0   Tax Class OIU_CM_TAXCLS
17 REV_BOOK_ADJ_IND OIUX5_REV_BOOK_REVADJ_ADJ_IND OIUX5_REV_BOOK_REVADJ_ADJ_IND CHAR 1   0   Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment  
18 .INCLUDE       0   0   Tax 2.0 - Oklahoma Tax Transactions Non-Key Fields  
19 PROD_PURC_IND OIUX3_PRODUCER_PURCHASER_IND OIUX3_PRODUCER_PURCHASER_IND CHAR 1   0   Tax Reporting - Producer/Purchaser Indicator  
20 UNIT_VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
21 PAY_FL OIU_SEVT_PAY_FL OIU_SEVT_PAY_FL CHAR 1   0   Tax Severance Tax Calculation Payment Obligations Types  
22 RPT_FL OIU_SEVT_RPT_FL CHAR1 CHAR 1   0   State Severance Tax Reporting Indicators  
23 UOM OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
24 GROSS_VOL OIUX3_GROSS_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Gross Volume  
25 GROSS_VAL OIUX3_GROSS_VALUE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Gross Value  
26 TAX_VOL OIUX3_TAXABLE_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Taxable Volume  
27 TAX_VAL OIUX3_TAXABLE_VALUE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Taxable Value  
28 EXE_ENTTYPE1_VOL OIUX5_EXEMPT_ENTITY_TYPE_1_VOL OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax 2.0 - Exempt Entity Type 1 Volume  
29 EXE_ENTTYPE1_VAL OIUX5_EXEMPT_ENTITY_TYPE_1_VAL OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Exempt Entity Type 1 Value  
30 EXEMPT_CODE_1 OIUX5_OK_EXEMPT_CODE_1 OIUX5_OK_EXEMPT_CODE NUMC 2   0   Tax 2.0 - Oklahoma Exempt Code 1  
31 EXE_ENTTYPE2_VOL OIUX5_EXEMPT_ENTITY_TYPE_2_VOL OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax 2.0 - Exempt Entity Type 2 Volume  
32 EXE_ENTTYPE2_VAL OIUX5_EXEMPT_ENTITY_TYPE_2_VAL OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Exempt Entity Type 2 Value  
33 EXEMPT_CODE_2 OIUX5_OK_EXEMPT_CODE_2 OIUX5_OK_EXEMPT_CODE NUMC 2   0   Tax 2.0 - Oklahoma Exempt Code 2  
34 EXE_ENTTYPE3_VOL OIUX5_EXEMPT_ENTITY_TYPE_3_VOL OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax 2.0 - Exempt Entity Type 3 Volume  
35 EXE_ENTTYPE3_VAL OIUX5_EXEMPT_ENTITY_TYPE_3_VAL OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Exempt Entity Type 3 Value  
36 EXEMPT_CODE_3 OIUX5_OK_EXEMPT_CODE_3 OIUX5_OK_EXEMPT_CODE NUMC 2   0   Tax 2.0 - Oklahoma Exempt Code 3  
37 EXE_ENTTYPE4_VOL OIUX5_EXEMPT_ENTITY_TYPE_4_VOL OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax 2.0 - Exempt Entity Type 4 Volume  
38 EXE_ENTTYPE4_VAL OIUX5_EXEMPT_ENTITY_TYPE_4_VAL OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Exempt Entity Type 4 Value  
39 EXEMPT_CODE_4 OIUX5_OK_EXEMPT_CODE_4 OIUX5_OK_EXEMPT_CODE NUMC 2   0   Tax 2.0 - Oklahoma Exempt Code 4  
40 EXE_ENTTYPE5_VOL OIUX5_EXEMPT_ENTITY_TYPE_5_VOL OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax 2.0 - Exempt Entity Type 5 Volume  
41 EXE_ENTTYPE5_VAL OIUX5_EXEMPT_ENTITY_TYPE_5_VAL OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Exempt Entity Type 5 Value  
42 EXEMPT_CODE_5 OIUX5_OK_EXEMPT_CODE_5 OIUX5_OK_EXEMPT_CODE NUMC 2   0   Tax 2.0 - Oklahoma Exempt Code 5  
43 EXE_ENTTYPE6_VOL OIUX5_EXEMPT_ENTITY_TYPE_6_VOL OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax 2.0 - Exempt Entity Type 6 Volume  
44 EXE_ENTTYPE6_VAL OIUX5_EXEMPT_ENTITY_TYPE_6_VAL OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Exempt Entity Type 6 Value  
45 EXEMPT_CODE_6 OIUX5_OK_EXEMPT_CODE_6 OIUX5_OK_EXEMPT_CODE NUMC 2   0   Tax 2.0 - Oklahoma Exempt Code 6  
46 MKT_COST OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
47 MKT_COST_REIMB OIUX3_MARKETING_COST_REIMB OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost Reimbursement  
48 GP_TAX_AMT OIUX5_GROSS_PROD_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Gross Production Tax Amount  
49 PE_TAX_AMT OIUX5_PETRO_EXCISE_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Petroleum Excise Tax Amount  
50 RF_TAX_AMT OIUX5_REVOLVE_FUND_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Revolving Fund Tax Amount  
51 MP_TAX_AMT OIUX5_MARGINAL_PROD_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Marginally Producing Tax Amount  
52 KW_TAX_AMT OIUX5_KIOWA_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Kiowa Tax Amount  
53 CA_TAX_AMT OIUX5_CHEYENNE_ARAPAHO_TAX_AMT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Cheyenne/Arapaho Tax Amount  
54 XX_TAX_AMT OIUX5_XX_TAX_AMT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - XX Tax Amount  
55 TAX_REIMB OIUX3_TAX_REIMBURSEMENT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax Reporting - Tax Reimbursement  
56 GRAVITY OIUH_GRAVITY OIUH_DEC3_1 DEC 3   1   Gravity  
57 BTU OIUX5_BTU OIUH_DEC7_3 DEC 7   3   Tax 2.0 - BTU  
58 .INCLUDE       0   0   Tax 2.0 - Oklahoma Master Data Nonkey Fields  
59 PUN OIUX5_OK_PRODUCTION_UNIT_NO   CHAR 11   0   Tax 2.0 - Oklahoma Production Unit Number *
60 GAS_CODE OIUX5_OK_GAS_CODE OIUX5_OK_GAS_CODE NUMC 1   0   Tax 2.0 - Oklahoma Gas Code  
61 OIL_CLASS OIUX5_OK_OIL_CLASSIFICATION OIUX5_OK_OIL_CLASSIFICATION NUMC 1   0   Tax 2.0 - Oklahoma Oil Classification  
62 MULTI_COUNTIES OIUX5_MULTIPLE_COUNTIES YESNO CHAR 1   0   Tax 2.0 - Multiple Counties?  
63 COUNTY OIUX5_OK_COUNTY OIU_SEC_GEO_LOC CHAR 3   0   Tax 2.0 - Oklahoma County OIU_CM_LXSGL
64 NGPA_CD OIUX5_OK_NGPA_CD OIUX5_OK_NGPA_CD CHAR 3   0   Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code)  
65 MASTER_LEVEL OIUX5_MASTER_LEVEL OIUX3_TX_MASTER_LEVEL CHAR 1   0   Tax 2.0 - Master Level  
66 .INCLUDE       0   0   Tax 2.0 - Oklahoma Producer/Purchaser Number Structure  
67 OTHER_NO OIUCM_BUS_ASSOC OIUCM_BUS_ASSOC CHAR 6   0   Business Associate OIUCM_BA_LINK
68 OTHER_SEQ_NO OIUCM_SEQ_NO OIUCM_SEQ_NO CHAR 2   0   Sequence Number OIUCM_BA_LINK
69 PROD_PURCH_NO OIUX5_OK_PROD_PURCH_NUMBER   NUMC 5   0   Tax 2.0 - Oklahoma Prod/Purch Number  
70 OK_PRODUCT_CODE OIUX5_OK_PRODUCT_CODE OIUX5_OK_PRODUCT_CODE NUMC 1   0   Tax 2.0 - Oklahoma Product Code  
71 TAXPAYER_NUMBER OIUX5_OK_TAXPAYER_NUMBER   NUMC 5   0   Tax 2.0 - Oklahoma Taxpayer Number  
72 TAXPAYER_NAME OIUX3_TAXPAYER_NAME TEXT100 CHAR 100   0   Taxpayer Name  
73 FEIN_SSN OIUX3_FEIN_SSN   NUMC 9   0   Tax 2.0 - FEIN/SSN  
74 DOC_NO OIURV_DOCNR OIU_MP_NO CHAR 20   0   Val. document number *
75 DOC_YEAR OIU_DOC_YEAR GJAHR NUMC 4   0   Document year  
76 OPTION1     CHAR 1   0    
77 OPTION2     CHAR 1   0    
78 OPTION3     CHAR 1   0    
79 .INCLUDE       0   0   Creator and date/time created  
80 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
81 OIU_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
82 HIST_GP_TAX_AMT OIUX5_GROSS_PROD_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Gross Production Tax Amount  
83 HIST_PE_TAX_AMT OIUX5_PETRO_EXCISE_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Petroleum Excise Tax Amount  
84 HIST_RF_TAX_AMT OIUX5_REVOLVE_FUND_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Revolving Fund Tax Amount  
85 HIST_MP_TAX_AMT OIUX5_MARGINAL_PROD_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Marginally Producing Tax Amount  
86 DELTA_GP_TAX_AMT OIUX5_GROSS_PROD_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Gross Production Tax Amount  
87 DELTA_PE_TAX_AMT OIUX5_PETRO_EXCISE_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Petroleum Excise Tax Amount  
88 DELTA_RF_TAX_AMT OIUX5_REVOLVE_FUND_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Revolving Fund Tax Amount  
89 DELTA_MP_TAX_AMT OIUX5_MARGINAL_PROD_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - Marginally Producing Tax Amount  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ROIUX5_OK_OOS_WO_ALV_0100 COUNTY OIU_CM_LXSGL SEC_GEO_LOC REF    
2 ROIUX5_OK_OOS_WO_ALV_0100 OTHER_NO OIUCM_BA_LINK BA_NO REF    
3 ROIUX5_OK_OOS_WO_ALV_0100 OTHER_SEQ_NO OIUCM_BA_LINK BA_SEQ REF    
4 ROIUX5_OK_OOS_WO_ALV_0100 TAX_CLS OIU_CM_TAXCLS TAX_CLS KEY    
5 ROIUX5_OK_OOS_WO_ALV_0100 UNIT_VNAME OIU_DO_JV VNAME REF    
6 ROIUX5_OK_OOS_WO_ALV_0100 UOM T006 MSEHI REF    
7 ROIUX5_OK_OOS_WO_ALV_0100 VL_TYPE_CD OIU_PR_VLTYP VL_TYPE_CD KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in 100