SAP ABAP Table OIUY3_TX_REVTXN (Royalty 2.0 - TX GLO - Royalty Reversals)
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_REVTXN   Table Relationship Diagram
Short Description Royalty 2.0 - TX GLO - Royalty Reversals    
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 .INCLUDE       0   0   Royalty 2.0 - TX GLO - Royalty Reversal Key Fields  
3 BUKRS BUKRS BUKRS CHAR 4   0   Company Code OIU_CM_COMPC
4 SALES_DT OIU_SALE_DT DATUM DATS 8   0   Sales Date / Month  
5 PDCD OIU_FULL_PD_CD OIU_FULL_PD_CD CHAR 3   0   Full three char. product code (Major and Detail Products) OIUX3_PDCD
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 MP_NO OIU_MP_NO OIU_MP_NO CHAR 20   0   Measurement point number OIU_PR_MP
9 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
10 DOI_NO OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) OIU_DO_DI
11 DN_NO OIU_DN_NO OIU_DN_NO CHAR 20   0   Delivery network number OIU_PR_DN
12 CT_NO OIU_CT_NO OIUCM_CONTRACT_NUMBER CHAR 10   0   Contract Number OIU_RV_CT
13 DOC_NO OIURV_DOCNR OIU_MP_NO CHAR 20   0   Val. document number *
14 DOC_YEAR OIU_DOC_YEAR GJAHR NUMC 4   0   Document year  
15 INTERFACE_FL OIUY3_TX_INTERFACE_FL OIUY3_TX_EXT_UPDATE CHAR 1   0   Royalty 2.0 - TX GLO - Interface Flag  
16 OPTION1     CHAR 1   0    
17 OPTION2     CHAR 1   0    
18 OPTION3     CHAR 1   0    
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_REVTXN BUKRS OIU_CM_COMPC BUKRS KEY    
2 OIUY3_TX_REVTXN CT_NO OIU_RV_CT CT_NO KEY    
3 OIUY3_TX_REVTXN DN_NO OIU_PR_DN DN_NO KEY    
4 OIUY3_TX_REVTXN DOI_NO OIU_DO_DI DOI_NO KEY    
5 OIUY3_TX_REVTXN MANDT T000 MANDT KEY    
6 OIUY3_TX_REVTXN MP_NO OIU_PR_MP MP_NO KEY    
7 OIUY3_TX_REVTXN PDCD OIUX3_PDCD PDCD KEY    
8 OIUY3_TX_REVTXN VNAME OIU_DO_JV VNAME KEY    
9 OIUY3_TX_REVTXN WC_NO OIU_PR_WC WC_NO KEY    
10 OIUY3_TX_REVTXN WL_NO OIU_PR_WELL WL_NO KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in 100