SAP ABAP Table OIUY6_WY_RPDTM (Royalty 2.0 - WY - Lease/Unit Report Detail - Masters)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_Y6 (Package) Royalty 2.0 - WY
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIUY6_WY_RPDTM   Table Relationship Diagram
Short Description Royalty 2.0 - WY - Lease/Unit Report Detail - Masters    
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 T000
2 RUN_ID OIUX3_RUN_ID NUMC10 NUMC 10   0   Tax Reporting - Run ID  
3 SALES_MONTH OIUY6_WY_SALES_MONTH   NUMC 6   0   Royalty 2.0 - Wyoming - Sales Month (MMCCYY)  
4 STATE_LEASE_NO OIUY6_WY_STATE_LEASE_NO   CHAR 15   0   Royalty 2.0 - Wyoming - State Lease Number  
5 UNIQUE_ID OIUY6_WY_UNIQUE_IDENTIFIER   CHAR 20   0   Royalty 2.0 - Wyoming - PSA  
6 .INCLUDE       0   0   Royalty 2.0 - WY - Master Data Main Key Fields  
7 RPT_ID OIUX3_RPT_ID OIUX3_RPT_ID CHAR 10   0   Tax Reporting - Report ID OIUX3_RPT
8 WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number OIU_PR_WELL
9 WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number OIU_PR_WC
10 MP_NO OIU_MP_NO OIU_MP_NO CHAR 20   0   Measurement point number OIU_PR_MP
11 BUKRS BUKRS BUKRS CHAR 4   0   Company Code OIU_CM_COMPC
12 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
13 DOI_NO OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) OIU_DO_DI
14 EFF_FROM_DT OIU_EFF_FROM_DT DATUM DATS 8   0   Effective from date  
15 DERIVED_WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number *
16 DERIVED_WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number *
17 .INCLUDE       0   0   Royalty 2.0 - WY - Report Detail (Lease/Unit) Non-Key Fields  
18 ALLOC_PERCENT OIUY6_WY_ALLOCATION_PERCENT OIU_PERCENT98 DEC 9   8   Royalty 2.0 - Wyoming - Allocation Percent  
19 SALES_DT OIU_SALE_DT DATUM DATS 8   0   Sales Date / Month  
20 OVERRIDE_FL OIUY6_WY_OVERRIDE_OPERATED_FL OIUY6_WY_OVERRIDE_OPERATED_FL CHAR 1   0   Royalty 2.0 - WY - Override Operated Flag  
21 .INCLUDE       0   0   Creator and date/time created  
22 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
23 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 OIUY6_WY_RPDTM BUKRS OIU_CM_COMPC BUKRS KEY    
2 OIUY6_WY_RPDTM DOI_NO OIU_DO_DI DOI_NO KEY    
3 OIUY6_WY_RPDTM MANDT T000 MANDT KEY    
4 OIUY6_WY_RPDTM MP_NO OIU_PR_MP MP_NO KEY    
5 OIUY6_WY_RPDTM RPT_ID OIUX3_RPT RPT_ID KEY    
6 OIUY6_WY_RPDTM VNAME OIU_DO_JV VNAME KEY    
7 OIUY6_WY_RPDTM WC_NO OIU_PR_WC WC_NO KEY    
8 OIUY6_WY_RPDTM WL_NO OIU_PR_WELL WL_NO KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in 100