SAP ABAP Table OIUX6_WY_CPRDT (Tax 2.0 - Wyoming Conservation Tax PRA Detail Transactions)
Hierarchy
IS-OIL (Software Component) IS-OIL
   IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
     OIU_X6 (Package) Tax 2.0 - WY
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIUX6_WY_CPRDT   Table Relationship Diagram
Short Description Tax 2.0 - Wyoming Conservation Tax PRA Detail Transactions    
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 RUN_ID OIUX3_RUN_ID NUMC10 NUMC 10   0   Tax Reporting - Run ID  
3 .INCLUDE       0   0   Tax 2.0 - Wyoming Conservation Tax Transactions Key Fields  
4 .INCLUDE       0   0   Tax 2.0 - Wyoming Conservation 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) OIUX3_PDCD
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 OIUX6_REV_BOOK_REVADJ_ADJ_IND OIUX6_REV_BOOK_REVADJ_ADJ_IND CHAR 1   0   Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment  
18 OUT_OF_STATUTE OIUX3_OUT_OF_STATUTE YESNO CHAR 1   0   Tax Reporting - Out Of Statute Flag  
19 .INCLUDE       0   0   Tax 2.0 - Wyoming Conservation Tax Trans Non-Key Fields  
20 PROD_PURC_IND OIUX3_PRODUCER_PURCHASER_IND OIUX3_PRODUCER_PURCHASER_IND CHAR 1   0   Tax Reporting - Producer/Purchaser Indicator  
21 UNIT_VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
22 PAY_FL OIU_SEVT_PAY_FL OIU_SEVT_PAY_FL CHAR 1   0   Tax Severance Tax Calculation Payment Obligations Types  
23 RPT_FL OIU_SEVT_RPT_FL CHAR1 CHAR 1   0   State Severance Tax Reporting Indicators  
24 UOM OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
25 GROSS_VOL OIUX3_GROSS_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Gross Volume  
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 EXEMPT_VOL OIUX3_EXEMPT_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax Reporting - Exempt Volume  
29 TAX_AMT OIUX3_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax Reporting - Tax Amount  
30 TAX_REIMB OIUX3_TAX_REIMBURSEMENT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax Reporting - Tax Reimbursement  
31 WET_LESS_RES OIUX6_WET_LESS_RES_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax 2.0 - Wet Less Residue Volume (MCF)  
32 BLPS_GROSS_VOL OIUX6_WY_BLPS_GROSS_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax 2.0 - Wyoming Before Lease Plant Split Gross Volume  
33 RET_LSE_PC OIUCA_RET_LSE_PC OIU_PERCENT63 DEC 6   3   Percent Returned to Lease  
34 PLANT_PROC_VOL OIUX6_WY_PLANT_PROC_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax 2.0 - Wyoming Plant Processing Volume  
35 .INCLUDE       0   0   Tax 2.0 - Wyoming Master Data Nonkey Fields  
36 COUNTY OIUX6_WY_COUNTY OIU_SEC_GEO_LOC CHAR 3   0   Tax 2.0 - Wyoming County Identifier OIU_CM_LXSGL
37 API_WELL_NUMBER OIUX6_WY_API_WELL_NUMBER   CHAR 5   0   Tax 2.0 - Wyoming API Well Number  
38 SIDE_TRACK_NO OIUX6_WY_SIDE_TRACK_NUMBER   CHAR 2   0   Tax 2.0 - Wyoming Side Track Number  
39 RESERVOIR OIUX6_WY_RESERVOIR   CHAR 3   0   Tax 2.0 - Wyoming Reservoir  
40 RPT_GRP_NO OIUX6_WY_REPORT_GROUP_NUMBER OIUX6_WY_REPORT_GROUP_NUMBER CHAR 5   0   Tax 2.0 - Wyoming Report Group Number  
41 FIELD_NAME OIUX6_WY_FIELD_NAME   CHAR 35   0   Tax 2.0 - Wyoming Field Name  
42 LEASE_UNIT_NAME OIUX6_WY_LEASE_UNIT_NAME CHAR35 CHAR 35   0   Tax 2.0 - Wyoming Lease Unit Name / API  
43 OPERATED_FLAG OIUX6_OPERATED_FLAG YESNO CHAR 1   0   Tax 2.0 - Operated Flag  
44 TAX_DISTRICT OIUX6_WY_TAX_DISTRICT NUMC4 NUMC 4   0   Tax 2.0 - Wyoming Tax District  
45 MASTER_LEVEL OIUX3_TX_MASTER_LEVEL OIUX3_TX_MASTER_LEVEL CHAR 1   0   Tax Reporting - Texas Master Level  
46 OPERATOR_ID OIUX6_WY_OPERATOR_ID OIUX6_WY_OPERATOR_ID CHAR 4   0   Tax 2.0 - Wyoming Operator ID  
47 OPERATOR_NO OIUCM_BUS_ASSOC OIUCM_BUS_ASSOC CHAR 6   0   Business Associate OIUCM_BA_LINK
48 OPERATOR_SEQ_NO OIUCM_SEQ_NO OIUCM_SEQ_NO CHAR 2   0   Sequence Number OIUCM_BA_LINK
49 OPERATOR_NAME OIUX6_OPERATOR_NAME CHAR38 CHAR 38   0   Tax 2.0 - Operator Name  
50 PURCHASER_NO OIUCM_BUS_ASSOC OIUCM_BUS_ASSOC CHAR 6   0   Business Associate OIUCM_BA_LINK
51 PURCHASER_SEQ_NO OIUCM_SEQ_NO OIUCM_SEQ_NO CHAR 2   0   Sequence Number OIUCM_BA_LINK
52 PURCHASER_NAME OIUX6_PURCHASER_NAME CHAR38 CHAR 38   0   Tax 2.0 - Purchaser Name  
53 OGIND OIUREP_OIL_GAS_IND OIUREP_OIL_GAS_IND CHAR 1   0   Oil and Gas Indicator  
54 DOC_NO OIURV_DOCNR OIU_MP_NO CHAR 20   0   Val. document number *
55 DOC_YEAR OIU_DOC_YEAR GJAHR NUMC 4   0   Document year  
56 OPTION1     CHAR 1   0    
57 OPTION2     CHAR 1   0    
58 OPTION3 OIUX6_EXT_UPDATE OIUX6_EXT_UPDATE CHAR 1   0   Tax 2.0 - Indicator to identify external data update  
59 .INCLUDE       0   0   Creator and date/time created  
60 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
61 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 OIUX6_WY_CPRDT COUNTY OIU_CM_LXSGL SEC_GEO_LOC REF    
2 OIUX6_WY_CPRDT OPERATOR_NO OIUCM_BA_LINK BA_NO    
3 OIUX6_WY_CPRDT OPERATOR_SEQ_NO OIUCM_BA_LINK BA_SEQ    
4 OIUX6_WY_CPRDT PDCD OIUX3_PDCD PDCD KEY    
5 OIUX6_WY_CPRDT PURCHASER_NO OIUCM_BA_LINK BA_NO    
6 OIUX6_WY_CPRDT PURCHASER_SEQ_NO OIUCM_BA_LINK BA_SEQ    
7 OIUX6_WY_CPRDT TAX_CLS OIU_CM_TAXCLS TAX_CLS KEY    
8 OIUX6_WY_CPRDT UNIT_VNAME OIU_DO_JV VNAME REF    
9 OIUX6_WY_CPRDT UOM T006 MSEHI REF    
10 OIUX6_WY_CPRDT VL_TYPE_CD OIU_PR_VLTYP VL_TYPE_CD    
History
Last changed by/on SAP  20110810 
SAP Release Created in 100