SAP ABAP Table OIUX7_WY_GSALES (Tax 2.0 - WYGP Sales)
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_GSALES   Table Relationship Diagram
Short Description Tax 2.0 - WYGP Sales    
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 RUN_ID OIUX3_RUN_ID NUMC10 NUMC 10   0   Tax Reporting - Run ID  
3 .INCLUDE       0   0   Tax 2.0 - WYGP Sales Key  
4 SALES_DT OIU_SALE_DT DATUM DATS 8   0   Sales Date / Month  
5 DN_NO OIU_DN_NO OIU_DN_NO CHAR 20   0   Delivery network number OIU_PR_DN
6 WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number OIU_PR_WELL
7 WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number OIU_PR_WC
8 PDCD OIU_FULL_PD_CD OIU_FULL_PD_CD CHAR 3   0   Full three char. product code (Major and Detail Products) OIUX3_PDCD
9 CT_NO OIU_CT_NO OIUCM_CONTRACT_NUMBER CHAR 10   0   Contract Number OIUCM_CONTRACT
10 OWN_NO OIU_OWN_NO LIFNR CHAR 10   0   PRA owner LFA1
11 OWN_INT_TYPE_CD OIU_PART_INT_TYPE OIU_PART_INT_TYPE CHAR 2   0   Participant Interest Type OIU_CM_PINTTY
12 OWN_ISQ_NO OIU_OWN_ISQ_NO OIU_OWN_ISQ_NO CHAR 2   0   Owner Interest Sequence Number  
13 .INCLUDE       0   0   Tax 2.0 - WYGP Sales NonKey  
14 UOM OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
15 GROSS_VOL OIUX3_GROSS_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Gross Volume  
16 CT_TYPE_CD OIU_CT_TYPE_CD OIU_CT_TYPE_CD CHAR 2   0   Contract Type OIU_CM_CTTYP
17 PAY_CD OIU_PAY_CD OIU_PAY_CD CHAR 2   0   Pay Code  
18 OGIND OIUREP_OIL_GAS_IND OIUREP_OIL_GAS_IND CHAR 1   0   Oil and Gas Indicator  
19 RPT_GRP_NO OIUX6_WY_REPORT_GROUP_NUMBER OIUX6_WY_REPORT_GROUP_NUMBER CHAR 5   0   Tax 2.0 - Wyoming Report Group Number  
20 PROD_YEAR OIUX7_PRODUCTION_YEAR   NUMC 4   0   Tax 2.0 - Production Year  
21 BA_NO OIUCM_BUS_ASSOC OIUCM_BUS_ASSOC CHAR 6   0   Business Associate  
22 BA_SEQ_NO OIUCM_SEQ_NO OIUCM_SEQ_NO CHAR 2   0   Sequence Number  
23 OPERATOR_ID OIUX6_WY_OPERATOR_ID OIUX6_WY_OPERATOR_ID CHAR 4   0   Tax 2.0 - Wyoming Operator ID  
24 TIK OIUX6_TAKE_IN_KIND YESNO CHAR 1   0   Tax 2.0 - TIK Flag  
25 .INCLUDE       0   0   Creator and date/time created  
26 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
27 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_GSALES CT_NO OIUCM_CONTRACT VBELN    
2 OIUX7_WY_GSALES CT_TYPE_CD OIU_CM_CTTYP CT_TYPE_CD    
3 OIUX7_WY_GSALES DN_NO OIU_PR_DN DN_NO    
4 OIUX7_WY_GSALES MANDT T000 MANDT KEY    
5 OIUX7_WY_GSALES OWN_INT_TYPE_CD OIU_CM_PINTTY OWN_INT_TYPE_CD    
6 OIUX7_WY_GSALES OWN_NO LFA1 LIFNR    
7 OIUX7_WY_GSALES PDCD OIUX3_PDCD PDCD    
8 OIUX7_WY_GSALES UOM T006 MSEHI    
9 OIUX7_WY_GSALES WC_NO OIU_PR_WC WC_NO    
10 OIUX7_WY_GSALES WL_NO OIU_PR_WELL WL_NO    
History
Last changed by/on SAP  20130529 
SAP Release Created in 600