SAP ABAP Table OIUY3_TX_RPDTM (Royalty 2.0 - TX GLO/TAMU - Report Detail - Masters)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_Y3 (Package) Royalty 2.0 - Texas GLO/TAMU
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIUY3_TX_RPDTM   Table Relationship Diagram
Short Description Royalty 2.0 - TX GLO/TAMU - 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 PROD_YEAR_MO OIUY3_TX_PROD_YEAR_MO OIU_PROD_MONTH ACCP 6   0   Royalty 2.0 - Texas GLO/TAMU - Production Year/Month YYYYMM  
4 RRC_DISTRICT_NO OIUY3_TX_GLO_DISTRICT_NO   CHAR 2   0   Royalty 2.0 - TX GLO/TAMU - District Number  
5 RRC_OIL_LEASE_NO OIUY3_TX_GLO_RRC_OIL_LEASE_NO   CHAR 5   0   Royalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number  
6 RRC_GAS_WELL_ID OIUY3_TX_GLO_RRC_GAS_WELL_ID   CHAR 6   0   Royalty 2.0 - TX GLO/TAMU - RRC Gas Well ID  
7 RRC_DRILL_PERMIT OIUY3_TX_GLO_RRC_DRILLING_PERM   CHAR 6   0   Royalty 2.0 - TX GLO/TAMU - RRC Drilling Permit  
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 - TX GLO/TAMU - Report Detail Master Non-Key  
18 SALES_DT OIU_SALE_DT DATUM DATS 8   0   Sales Date / Month  
19 .INCLUDE       0   0   Creator and date/time created  
20 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
21 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 OIUY3_TX_RPDTM BUKRS OIU_CM_COMPC BUKRS KEY    
2 OIUY3_TX_RPDTM DOI_NO OIU_DO_DI DOI_NO KEY    
3 OIUY3_TX_RPDTM MANDT T000 MANDT KEY    
4 OIUY3_TX_RPDTM MP_NO OIU_PR_MP MP_NO KEY    
5 OIUY3_TX_RPDTM VNAME OIU_DO_JV VNAME KEY    
6 OIUY3_TX_RPDTM WC_NO OIU_PR_WC WC_NO KEY    
7 OIUY3_TX_RPDTM WL_NO OIU_PR_WELL WL_NO KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in 100