SAP ABAP Table OIUY3_TX_ROYHST (Royalty 2.0 - TX GLO - Royalty Transaction History)
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
⤷ 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_ROYHST | Table Relationship Diagram |
Short Description | Royalty 2.0 - TX GLO - Royalty Transaction History |
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 Transactions Key Fields | |||||
3 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO - Royalty Reversal Key Fields | |||||
4 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | OIU_CM_COMPC | |
5 | SALES_DT | OIU_SALE_DT | DATUM | DATS | 8 | 0 | Sales Date / Month | ||
6 | PDCD | OIU_FULL_PD_CD | OIU_FULL_PD_CD | CHAR | 3 | 0 | Full three char. product code (Major and Detail Products) | OIUX3_PDCD | |
7 | WL_NO | OIU_WL_NO | OIU_WL_NO | CHAR | 15 | 0 | Well ID number | OIU_PR_WELL | |
8 | WC_NO | OIU_WC_NO | OIU_WC_NO | CHAR | 5 | 0 | Well Completion Number | OIU_PR_WC | |
9 | MP_NO | OIU_MP_NO | OIU_MP_NO | CHAR | 20 | 0 | Measurement point number | OIU_PR_MP | |
10 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | OIU_DO_JV | |
11 | DOI_NO | OIU_DOI_NO | OIU_DOI_NO | CHAR | 5 | 0 | Division of interest (DOI) | OIU_DO_DI | |
12 | DN_NO | OIU_DN_NO | OIU_DN_NO | CHAR | 20 | 0 | Delivery network number | OIU_PR_DN | |
13 | CT_NO | OIU_CT_NO | OIUCM_CONTRACT_NUMBER | CHAR | 10 | 0 | Contract Number | OIU_RV_CT | |
14 | VL_TYPE_CD | OIU_VT_CD | OIU_VL_TYPE_CD | CHAR | 2 | 0 | Volume type code | OIU_PR_VLTYP | |
15 | OWNER_IDENTIFIER | OIUYC_OWNER_IDENTIFIER | CHAR | 22 | 0 | Royalty 2.0 - Owner Identifier | |||
16 | REV_BOOK_ADJ_IND | OIUY3_REV_BOOK_REVADJ_ADJ_IND | OIUY3_REV_BOOK_REVADJ_ADJ_IND | CHAR | 1 | 0 | Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs | ||
17 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Fields | |||||
18 | UNIT_VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | * | |
19 | ACCT_NO | OIUH_ACCTID | CHAR10 | CHAR | 10 | 0 | Account ID | ||
20 | CHV_RPT_CD | RKOSTL | KOSTL | CHAR | 10 | 0 | Template cost center | * | |
21 | UOM | OIU_MEAS_U | MEINS | UNIT | 3 | 0 | Measurement unit | T006 | |
22 | PS_BASE_QY | OIUH_PRESSURE_BASE | OIUH_DEC6_3 | DEC | 6 | 3 | Pressure Base Quantity | ||
23 | GRV_QY | OIUH_GRAVITY | OIUH_DEC3_1 | DEC | 3 | 1 | Gravity | ||
24 | PAY_CD | OIUH_PAY_CODE | CHAR2 | CHAR | 2 | 0 | Pay Code | ||
25 | OWN_INT_DECM_QY | OIUY3_TX_OWNER_NRI | OIU_PERCENT98 | DEC | 9 | 8 | Royalty 2.0 - TX GLO - Owner NRI | ||
26 | OWN_BAL_DECM_QY | OIUH_OWNER_DISBUR_DECIMAL | OIUH_DEC9_8 | DEC | 9 | 8 | Owner Disbursement (Balance) Decimal | ||
27 | PU_NO | OIUH_PURCHASER | CHAR6 | CHAR | 6 | 0 | Purchaser ID | ||
28 | PU_SEQ_NO | OIUH_PURCHASER_SEQUENCE_NUMBER | CHAR2 | CHAR | 2 | 0 | Purchaser Sequence Number | ||
29 | AFFILIATED_SALE | OIUY3_TX_AFFILIATED_SALE_IND | YESNO | CHAR | 1 | 0 | Royalty 2.0 - TX GLO - Affiliated Sale Indicator | ||
30 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Vol/Val | |||||
31 | GR_QY | OIUX3_GROSS_VOLUME | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Gross Volume | ||
32 | GR_AM | OIUX3_GROSS_VALUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Gross Value | ||
33 | TXN_VAL_AM | OIUY3_TX_OWNER_GROSS_VALUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Royalty 2.0 - TX GLO - Owner Gross Value | ||
34 | TRANS_AM | OIUX3_TRANS_AMT | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | JE Transaction Amount | ||
35 | TRANS_QY | OIUH_TRANS_QUANTITY | OIUH_DEC11_2 | DEC | 11 | 2 | JE Transaction Quantity | ||
36 | MMBTU_OVL_AM | OIUH_OWNER_MMBTU | OIUH_DEC11_2 | DEC | 11 | 2 | Owner MMBTU | ||
37 | PLT_VL_GRED_AM | OIUH_GROSS_PLANT_VOLUME_RED_AM | OIUH_DEC11_2 | DEC | 11 | 2 | Gross Plant Volume Reduction amount | ||
38 | PLT_VL_ORED_AM | OIUH_OWNER_PLANT_VOLUME_RED_AM | OIUH_DEC11_2 | DEC | 11 | 2 | Owner Plant Volume Reduction amount | ||
39 | DED_RMB_AM | OIUH_DED_REIMB_AMOUNT | OIUH_CURR11_2 | CURR | 11 | 2 | Deduction/Reimbursement Amount | ||
40 | NET_TRANSP_AM | OIUX3_MARKETING_COST | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Marketing Cost | ||
41 | NET_OTH_MK_AM | OIUX3_MARKETING_COST | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Marketing Cost | ||
42 | TAX_RMB_AM | OIUH_TAX_REIMBURSEMENT_AMT | OIUH_CURR11_2 | CURR | 11 | 2 | Tax Reimbursement Amount | ||
43 | BTU_QY | OIUH_BTU_QUANTITY | OIUH_DEC7_3 | DEC | 7 | 3 | BTU Quantity | ||
44 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Validate | |||||
45 | ORIGINAL_REPORT | OIUY3_TX_ORIGINAL_REPORT | OIUY3_TX_ORIGINAL_REPORT | CHAR | 1 | 0 | Royalty 2.0 - TX GLOTAMU - Original Report | ||
46 | GAS_DISP_CODE | OIUY3_TX_GLO_ROY_GAS_DISP_CODE | OIUY3_TX_GLO_ROY_GAS_DISP_CODE | NUMC | 2 | 0 | Royalty 2.0 - TX GLO/TAMU - Royalty Gas Disposition Code | ||
47 | MASTER_LEVEL | OIUY3_TX_MASTER_LEVEL | CHAR | 1 | 0 | Royalty 2.0 - TX GLO - Master Level | |||
48 | RRC_LEVEL | OIUY3_TX_RRC_LEVEL | CHAR | 1 | 0 | Royalty 2.0 - TX GLO - RRC Master Level | |||
49 | PURCHASER_ID | OIUY3_TX_PURCHASER_ID | NUMC | 11 | 0 | Royalty 2.0 - Texas GLO/TAMU - Purchaser ID | |||
50 | OPERATOR_ID | OIUY3_TX_OPERATOR_ID | OIUY3_TX_ID | CHAR | 10 | 0 | Royalty 2.0 - TX GLO - Operator ID | ||
51 | .INCLUDE | 0 | 0 | Royalty 2,.0 - TX GLO/TAMU - Master Sub Key | |||||
52 | GLO_LEASE | OIUY3_TX_GLO_LEASE | OIUY3_TX_GLO_LEASE | NUMC | 6 | 0 | Royalty 2.0 - TX GLO/TAMU Lease | OIUY3_TX_LEASE | |
53 | GLO_UNIT_NO | OIUY3_TX_GLO_UNIT_NO | CHAR | 4 | 0 | Royalty 2.0 - Texas GLO/TAMU - Unit Number | OIUY3_TX_UNIT | ||
54 | ROYALTY_DECIMAL | OIUY3_TX_ROYALTY_DECIMAL | OIU_PERCENT98 | DEC | 9 | 8 | Royalty 2.0 - Texas GLO - Royalty Decimal | ||
55 | UNIT_VNAME_FLAG | OIUY3_TX_UNIT_VNAME | YESNO | CHAR | 1 | 0 | Roy 2.0 - Texas GLO/TAMU - Unit Venture | ||
56 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO/TAMU - Master Non-Key Fields | |||||
57 | ALLOC_PERCENT | OIUY3_TX_ALLOCATION_PERCENT | OIU_PERCENT98 | DEC | 9 | 8 | Royalty 2.0 - TX GLO/TAMU - Allocation Percent | ||
58 | TRACT_PART_FACT | OIUY3_TX_TRACT_PART_FACTOR | OIU_PERCENT98 | DEC | 9 | 8 | Royalty 2.0 - Texas GLO - Tract Participation Factor | ||
59 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Master Non-Key Fields | |||||
60 | RRC_DISTRICT_NO | OIUY3_TX_GLO_DISTRICT_NO | CHAR | 2 | 0 | Royalty 2.0 - TX GLO/TAMU - District Number | |||
61 | RRC_OIL_LEASE_NO | OIUY3_TX_GLO_RRC_OIL_LEASE_NO | CHAR | 5 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number | |||
62 | RRC_GAS_WELL_ID | OIUY3_TX_GLO_RRC_GAS_WELL_ID | CHAR | 6 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Gas Well ID | |||
63 | RRC_DRILL_PERMIT | OIUY3_TX_GLO_RRC_DRILLING_PERM | CHAR | 6 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Drilling Permit | |||
64 | RRC_FIELD_NAME | OIUY3_TX_GLO_RRC_FIELD_NAME | CHAR | 32 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Field Name | |||
65 | RRC_LEASE_NAME | OIUY3_TX_GLO_RRC_LEASE_NAME | CHAR | 32 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Lease Name | |||
66 | PROP_ALIAS_NAME | OIUY3_TX_GLO_PROP_ALIAS_NAME | CHAR | 32 | 0 | Royalty 2.0 - TX GLO/TAMU - Property Alias Name | |||
67 | OPERATOR_NO | OIUY3_OPERATOR_NUMBER | OIUCM_BUS_ASSOC | CHAR | 6 | 0 | Royalty 2.0 - TX GLO/TAMU - Operator Number | OIUH_CM_BA | |
68 | OPERATOR_SEQ_NO | OIUY3_OPERATOR_SEQUENCE_NUMBER | OIUCM_SEQ_NO | CHAR | 2 | 0 | Royalty 2.0 - TX GLO - Operator Sequence Number | ||
69 | PAY_REPORT_FLAG | OIUY3_TX_PAY_REPORT_FLAG | OIUY3_TX_PAY_REPORT_FLAG | CHAR | 1 | 0 | Royalty 2.0 - TX GLO/TAMU - Pay/Report Flag | ||
70 | DOC_NO | OIURV_DOCNR | OIU_MP_NO | CHAR | 20 | 0 | Val. document number | * | |
71 | DOC_YEAR | OIU_DOC_YEAR | GJAHR | NUMC | 4 | 0 | Document year | ||
72 | INTERFACE_FL | OIUY3_TX_INTERFACE_FL | OIUY3_TX_EXT_UPDATE | CHAR | 1 | 0 | Royalty 2.0 - TX GLO - Interface Flag | ||
73 | OPTION1 | CHAR | 1 | 0 | |||||
74 | OPTION2 | CHAR | 1 | 0 | |||||
75 | OPTION3 | CHAR | 1 | 0 | |||||
76 | REFERENCE_RUN_ID | OIUX3_RUN_ID | NUMC10 | NUMC | 10 | 0 | Tax Reporting - Run ID | ||
77 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
78 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
79 | 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_ROYHST | BUKRS | OIU_CM_COMPC | BUKRS | KEY | ||
2 | OIUY3_TX_ROYHST | CT_NO | OIU_RV_CT | CT_NO | KEY | ||
3 | OIUY3_TX_ROYHST | DN_NO | OIU_PR_DN | DN_NO | KEY | ||
4 | OIUY3_TX_ROYHST | DOI_NO | OIU_DO_DI | DOI_NO | KEY | ||
5 | OIUY3_TX_ROYHST | GLO_LEASE | OIUY3_TX_LEASE | GLO_LEASE | |||
6 | OIUY3_TX_ROYHST | GLO_UNIT_NO | OIUY3_TX_UNIT | GLO_UNIT_NO | KEY | ||
7 | OIUY3_TX_ROYHST | MANDT | T000 | MANDT | KEY | ||
8 | OIUY3_TX_ROYHST | MP_NO | OIU_PR_MP | MP_NO | KEY | ||
9 | OIUY3_TX_ROYHST | OPERATOR_NO | OIUH_CM_BA | BA_BA_NO | |||
10 | OIUY3_TX_ROYHST | PDCD | OIUX3_PDCD | PDCD | KEY | ||
11 | OIUY3_TX_ROYHST | UOM | T006 | MSEHI | REF | ||
12 | OIUY3_TX_ROYHST | VL_TYPE_CD | OIU_PR_VLTYP | VL_TYPE_CD | KEY | ||
13 | OIUY3_TX_ROYHST | VNAME | OIU_DO_JV | VNAME | KEY | ||
14 | OIUY3_TX_ROYHST | WC_NO | OIU_PR_WC | WC_NO | KEY | ||
15 | OIUY3_TX_ROYHST | WL_NO | OIU_PR_WELL | WL_NO | KEY |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 100 |