SAP ABAP Table OIUX7_WY_GSALHST (Tax 2.0 - WYGP Sales History)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
     ⤷ OIU_X7 (Package) Tax 2.0 - WYGP
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIUX7_WY_GSALHST   Table Relationship Diagram
Short Description Tax 2.0 - WYGP Sales History    
Delivery and Maintenance
Pool/cluster      
Delivery Class L   Table for storing temporary data, delivered empty 
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 .INCLUDE       0   0   Tax 2.0 - WYGP Sales Key  
3 SALES_DT OIU_SALE_DT DATUM DATS 8   0   Sales Date / Month  
4 DN_NO OIU_DN_NO OIU_DN_NO CHAR 20   0   Delivery network number OIU_PR_DN
5 WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number OIU_PR_WELL
6 WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number OIU_PR_WC
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 CT_NO OIU_CT_NO OIUCM_CONTRACT_NUMBER CHAR 10   0   Contract Number OIUCM_CONTRACT
9 OWN_NO OIU_OWN_NO LIFNR CHAR 10   0   PRA owner LFA1
10 OWN_INT_TYPE_CD OIU_PART_INT_TYPE OIU_PART_INT_TYPE CHAR 2   0   Participant Interest Type OIU_CM_PINTTY
11 OWN_ISQ_NO OIU_OWN_ISQ_NO OIU_OWN_ISQ_NO CHAR 2   0   Owner Interest Sequence Number  
12 .INCLUDE       0   0   Tax 2.0 - WYGP Sales NonKey  
13 UOM OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
14 GROSS_VOL OIUX3_GROSS_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Gross Volume  
15 CT_TYPE_CD OIU_CT_TYPE_CD OIU_CT_TYPE_CD CHAR 2   0   Contract Type OIU_CM_CTTYP
16 PAY_CD OIU_PAY_CD OIU_PAY_CD CHAR 2   0   Pay Code  
17 OGIND OIUREP_OIL_GAS_IND OIUREP_OIL_GAS_IND CHAR 1   0   Oil and Gas Indicator  
18 RPT_GRP_NO OIUX6_WY_REPORT_GROUP_NUMBER OIUX6_WY_REPORT_GROUP_NUMBER CHAR 5   0   Tax 2.0 - Wyoming Report Group Number  
19 PROD_YEAR OIUX7_PRODUCTION_YEAR   NUMC 4   0   Tax 2.0 - Production Year  
20 BA_NO OIUCM_BUS_ASSOC OIUCM_BUS_ASSOC CHAR 6   0   Business Associate  
21 BA_SEQ_NO OIUCM_SEQ_NO OIUCM_SEQ_NO CHAR 2   0   Sequence Number  
22 OPERATOR_ID OIUX6_WY_OPERATOR_ID OIUX6_WY_OPERATOR_ID CHAR 4   0   Tax 2.0 - Wyoming Operator ID  
23 TIK OIUX6_TAKE_IN_KIND YESNO CHAR 1   0   Tax 2.0 - TIK Flag  
24 .INCLUDE       0   0   Creator and date/time created  
25 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
26 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 OIUX7_WY_GSALHST CT_NO OIUCM_CONTRACT VBELN    
2 OIUX7_WY_GSALHST CT_TYPE_CD OIU_CM_CTTYP CT_TYPE_CD    
3 OIUX7_WY_GSALHST DN_NO OIU_PR_DN DN_NO    
4 OIUX7_WY_GSALHST MANDT T000 MANDT KEY    
5 OIUX7_WY_GSALHST OWN_INT_TYPE_CD OIU_CM_PINTTY OWN_INT_TYPE_CD    
6 OIUX7_WY_GSALHST OWN_NO LFA1 LIFNR    
7 OIUX7_WY_GSALHST PDCD OIUX3_PDCD PDCD    
8 OIUX7_WY_GSALHST UOM T006 MSEHI    
9 OIUX7_WY_GSALHST WC_NO OIU_PR_WC WC_NO    
10 OIUX7_WY_GSALHST WL_NO OIU_PR_WELL WL_NO    
History
Last changed by/on SAP  20130529 
SAP Release Created in 600