OIUGR_RPDT - Gen Rep - Report Detail Transaction
Gen Rep - Report Detail Transaction information is stored in SAP table OIUGR_RPDT.
It is part of development package OIU_GR in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Generic Royalty SLA".
It is part of development package OIU_GR in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Generic Royalty SLA".
Fields for table OIUGR_RPDT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| RUN_ID | Proc 2.0 - Run ID | X | OIUE2_RUN_ID | NUMC | 20 | OIUE2_RUN_HDR |
| RPDT_GUID | 16-byte UID in 32 chars (hexadecimal) | X | SYSUUID_C32 | CHAR | 64 | |
| .INCLUDE | ROIUGR_RPDT_KEY | ROIUGR_RPDT_KEY | 0 | |||
| SALES_DT | Sales Date / Month | OIU_SALE_DT | DATS | 16 | ||
| ENTITY_ID | Gen Rep - Agency Entity ID | OIUGR_ENTITY_ID | CHAR | 40 | ||
| PRODUCT_CODE | Gen Rep - Agency Product Code | OIUGR_PRODUCT_CODE | CHAR | 10 | OIUGR_PDC | |
| REV_BOOK_ADJ_IND | Reversal/Booking/Adjustment | OIUX3_REVERSE_BOOKING_ADJ_IND | CHAR | 2 | ||
| .INCLUDE | ROIUGR_RPDT_NONKEY | ROIUGR_RPDT_NONKEY | 0 | |||
| ENTITY_LINK_GUID | 16-byte UID in 32 chars (hexadecimal) | SYSUUID_C32 | CHAR | 64 | ||
| WAERS | Currency Key | WAERS | CUKY | 10 | TCURC | |
| VOL_UOM | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| ENERGY_UOM | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| HEAT_VAL_UOM | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| PRES_UOM | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| HEAT_VAL | Heating value | OIU_HEAT_VAL | QUAN | 7 | ||
| PS_BASE_QY | Pressure Base | OIU_PS_BASE | QUAN | 7 | ||
| GRAVITY | Gen Rep - Oil/gas density at standard/base conditions | OIUGR_GRAVITY | FLTP | 8 | ||
| .INCLUDE | ROIUGR_RPDT_NONKEY_NUMERIC | ROIUGR_RPDT_NONKEY_NUMERIC | 0 | |||
| .INCLUDE | ROIUGR_ROYTXN_NONKEY_NUMERIC | ROIUGR_ROYTXN_NONKEY_NUMERIC | 0 | |||
| GROSS_VOL | Total Gross Volume | /PRA/GROSS_VOL | QUAN | 7 | ||
| GROSS_ENERGY | Gross Energy | /PRA/GROSS_ENERGY | QUAN | 7 | ||
| GROSS_PVR | Gross PVR | /PRA/GROSS_PVR | QUAN | 7 | ||
| GROSS_PTR | Gross PTR | /PRA/GROSS_PTR | QUAN | 7 | ||
| NET_VOL | Owner Net Volume | /PRA/NET_VOL | QUAN | 7 | ||
| OWNER_ENERGY | Owner Energy | /PRA/OWNER_ENERGY | QUAN | 7 | ||
| OWN_PVR | Owner PVR | /PRA/OWN_PVR | QUAN | 7 | ||
| OWN_PTR | Owner PTR | /PRA/OWN_PTR | QUAN | 7 | ||
| GROSS_VAL | Gross value | /PRA/GROSS_VAL | CURR | 7 | ||
| NET_VAL | Owner Net Value | /PRA/NET_VAL | CURR | 7 | ||
| OWNER_GROSS_VAL | Owner Gross Value | /PRA/OWN_GROSS_VAL | CURR | 7 | ||
| .INCLUDE | ROIUGR_ROYTXN_NONKEY_CALC | ROIUGR_ROYTXN_NONKEY_CALC | 0 | |||
| TOT_GROSS_MKT_AM | Gen Rep - Total Gross Marketing | OIUGR_TOTAL_GROSS_MKT_AM | CURR | 8 | ||
| TOT_GROSS_RMB_AM | Gen Rep - Total Gross Marketing Reimbursement | OIUGR_TOTAL_GROSS_RMB_AM | CURR | 8 | ||
| TOT_GROSS_TAX_AM | Gen Rep - Total Gross Tax | OIUGR_TOTAL_GROSS_TAX_AM | CURR | 8 | ||
| TOT_GROSS_TX_RMB | Gen Rep - Total Gross Tax Reimbursement | OIUGR_TOTAL_GROSS_TX_RMB | CURR | 8 | ||
| TOT_OWNER_MKT_AM | Gen Rep - Total Owner Marketing | OIUGR_TOTAL_OWNER_MKT_AM | CURR | 8 | ||
| TOT_OWNER_RMB_AM | Gen Rep - Total Owner Marketing Reimbursement | OIUGR_TOTAL_OWNER_RMB_AM | CURR | 8 | ||
| TOT_OWNER_TAX_AM | Gen Rep - Total Owner Tax | OIUGR_TOTAL_OWNER_TAX_AM | CURR | 8 | ||
| TOT_OWNER_TX_RMB | Gen Rep - Total Owner Tax Reimbursement | OIUGR_TOTAL_OWNER_TX_RMB | CURR | 8 | ||
| TOT_OTHER_DED_AM | Gen Rep - Total Other Deduct | OIUGR_TOTAL_OTHER_DED_AM | CURR | 8 | ||
| .INCLUDE | /PRA/LAST_CHANGED | /PRA/LAST_CHANGED | 0 | |||
| CHANGE_USER | Last Changed By | OIUX3_LAST_CHANGED_USER | CHAR | 24 | ||
| CHANGE_TIMESTAMP | Last Changed Timestamp | /PRA/LAST_CHANGED_TZNTSTMPS | DEC | 8 |