/PRA/FP_PRDT - ONRR-2014 - PRA Details
ONRR-2014 - PRA Details information is stored in SAP table /PRA/FP_PRDT.
It is part of development package /PRA/ONRR_2014 in software component IS-OIL-PRA. This development package consists of objects that can be grouped under "ONRR-2014".
It is part of development package /PRA/ONRR_2014 in software component IS-OIL-PRA. This development package consists of objects that can be grouped under "ONRR-2014".
Fields for table /PRA/FP_PRDT
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 |
| .INCLUDE | /PRA/S_FP_PRDT_KEY | X | /PRA/S_FP_PRDT_KEY | 0 | ||
| .INCLUDE | /PRA/S_FP_PAY_SUM_KEY | X | /PRA/S_FP_PAY_SUM_KEY | 0 | ||
| SALE_DT | Sales Date / Month | X | OIU_SALE_DT | DATS | 16 | |
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | OIU_CM_COMPC |
| VNAME | Joint venture | X | JV_NAME | CHAR | 12 | OIU_DO_JV |
| DOI_NO | Division of interest (DOI) | X | OIU_DOI_NO | CHAR | 10 | OIU_DO_DI |
| WL_NO | Well ID number | X | OIU_WL_NO | CHAR | 30 | OIU_PR_WELL |
| WC_NO | Well Completion Number | X | OIU_WC_NO | CHAR | 10 | OIU_PR_WC |
| VBELN | Contract Number | X | OIU_CT_NO | CHAR | 20 | OIUCM_CONTRACT |
| VL_TYPE_CD | Volume Type Code | X | OIU_VL_TYPE_CD | CHAR | 4 | OIU_PR_VLTYP |
| PD_CD | Full three char. product code (Major and Detail Products) | X | OIU_FULL_PD_CD | CHAR | 6 | OIUX3_PDCD |
| OWN_NO | PRA owner | X | OIU_OWN_NO | CHAR | 20 | LFA1 |
| SAKNR | G/L Account Number | X | SAKNR | CHAR | 20 | SKB1 |
| KOSTL | Cost Center | X | KOSTL | CHAR | 20 | CSKS |
| PRDT_LINE_TYPE | ONRR-2014 - PRA Detail Line Type | X | /PRA/FP_PRDT_LINE_TYPE | CHAR | 2 | |
| .INCLUDE | /PRA/S_FP_PRDT_NONKEY | /PRA/S_FP_PRDT_NONKEY | 0 | |||
| GUID | 16-byte UID in 32 chars (hexadecimal) | SYSUUID_C32 | CHAR | 64 | ||
| AC_IND | Proc 2.0 - Amended/Current Indicator | OIUE2_AC_IND | CHAR | 2 | ||
| RPDT_AC_IND | Proc 2.0 - Amended/Current Indicator | OIUE2_AC_IND | CHAR | 2 | ||
| .INCLUDE | /PRA/S_FP_PAY_SUM_NONKEY | /PRA/S_FP_PAY_SUM_NONKEY | 0 | |||
| PPA_RSN_CD | Prior Period Adjustment Reason Code | OIU_PPA_RSN_CD | CHAR | 4 | OIU_CM_PPARSN | |
| VOL_UOM | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| ENERGY_UOM | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| WAERS | Currency Key | WAERS | CUKY | 10 | TCURC | |
| DN_NO | Delivery network number | OIU_DN_NO | CHAR | 40 | ||
| .INCLUDE | /PRA/S_FP_PAY_SUM_NONKEY_NUM | /PRA/S_FP_PAY_SUM_NONKEY_NUM | 0 | |||
| NET_VAL | Owner Net Value | /PRA/NET_VAL | CURR | 7 | ||
| NET_VOL | Owner Net Volume | /PRA/NET_VOL | QUAN | 7 | ||
| OWNER_GROSS_VAL | Owner Gross Value | /PRA/OWN_GROSS_VAL | CURR | 7 | ||
| OWNER_ENERGY | Owner Energy | /PRA/OWNER_ENERGY | QUAN | 7 | ||
| GROSS_VAL | Gross value | /PRA/GROSS_VAL | CURR | 7 | ||
| GROSS_VOL | Total Gross Volume | /PRA/GROSS_VOL | QUAN | 7 | ||
| GROSS_ENERGY | Gross Energy | /PRA/GROSS_ENERGY | QUAN | 7 | ||
| RAW_NET_VOL | ONRR-2014 - Raw Net Vol | /PRA/FP_RAW_NET_VOL | QUAN | 7 | ||
| RAW_GROSS_VOL | ONRR-2014 - Raw Gross Vol | /PRA/FP_RAW_GROSS_VOL | QUAN | 7 | ||
| .INCLUDE | /PRA/S_FP_PRDT_NONKEY_DERIVED | /PRA/S_FP_PRDT_NONKEY_DERIVED | 0 | |||
| OOS_FL | Out of Statute | OIUX3_OUT_OF_STATUTE | CHAR | 2 | ||
| MASTER_LEVEL | ONRR-2014 - Master Level | /PRA/FP_MASTER_LEVEL | CHAR | 2 | ||
| .INCLUDE | /PRA/S_FP_MASTER_SUBKEY | /PRA/S_FP_MASTER_SUBKEY | 0 | |||
| LEASE_NO | ONRR-2014 - Lease Number | /PRA/FP_LEASE_NO | CHAR | 22 | /PRA/FP_LEASE | |
| AGREEMENT_NO | ONRR-2014 - Agreement Number | /PRA/FP_AGREEMENT_NO | CHAR | 22 | /PRA/FP_AGREE | |
| .INCLUDE | /PRA/S_FP_MASTER_SUBNONKEY | /PRA/S_FP_MASTER_SUBNONKEY | 0 | |||
| .INCLUDE | /PRA/S_FP_MASTER_HEADERNONKEY | /PRA/S_FP_MASTER_HEADERNONKEY | 0 | |||
| PAYOR_CD | ONRR-2014 - Payor Code | /PRA/FP_PAYOR_CODE | NUMC | 10 | /PRA/C_FP_PAYOR | |
| COMP_ROYALTY_FL | ONRR-2014 - Compensatory Royalty Flag | /PRA/FP_COMPENSATORY_ROYALTY | CHAR | 2 | ||
| SECTION_6_LSE_FL | ONRR-2014 - Section 6 Lease Flag | /PRA/FP_SECTION_6_LEASE | CHAR | 2 | ||
| ROY_RELIEF_SH_FL | ONRR-2014 - Royalty Relief - Shallow Flag | /PRA/FP_ROYALTY_RELIEF_SHALLOW | CHAR | 2 | ||
| ROY_RELIEF_DP_FL | ONRR-2014 - Royalty Relief - Deep Flag | /PRA/FP_ROYALTY_RELIEF_DEEP | CHAR | 2 | ||
| REPORT_API_WL_FL | ONRR-2014 - Report API Well Flag | /PRA/FP_REPORT_API_WELL_FL | CHAR | 2 | ||
| ALLOC_PERCENT | ONRR-2014 - Allocation Percent | /PRA/FP_ALLOCATION_PERCENT | DEC | 5 | ||
| OVR_ROYALTY_RATE | ONRR-2014 - Override Royalty Rate | /PRA/FP_OVERRIDE_ROYALTY_RATE | DEC | 5 | ||
| .INCLUDE | /PRA/S_FP_LEASE_SUBNONKEY | /PRA/S_FP_LEASE_SUBNONKEY | 0 | |||
| LESSOR_CD | ONRR-2014 - Lessor Code | /PRA/FP_LESSOR_CODE | CHAR | 2 | ||
| TRIBAL_ALLOTTEE | ONRR-2014 - Tribal / Allottee Indicator | /PRA/FP_TRIBAL_ALLOTTEE_IND | CHAR | 2 | ||
| DISTRIBUTEE_CD | ONRR-2014 - Distributee Code | /PRA/FP_DISTRIBUTEE_CODE | NUMC | 6 | /PRA/C_FP_DIS_CD | |
| ON_OFF_SHORE_IND | ONRR-2014 - On-Shore/Off-Shore Indicator | /PRA/FP_ON_OFF_SHORE_INDICATOR | CHAR | 2 | ||
| LEASE_TERM | ONRR-2014 - Lease Term | /PRA/FP_LEASE_TERM | CHAR | 2 | ||
| SLIDING_SCALE_FL | ONRR-2014 - Sliding Scale Flag | /PRA/FP_SLIDING_SCALE_FLAG | CHAR | 2 | ||
| ROYALTY_RATE | ONRR-2014 - Lease Royalty Rate | /PRA/FP_LEASE_ROYALTY_RATE | DEC | 5 | ||
| OIL_ROYALTY_RATE | ONRR-2014 - Lease Oil Royalty Rate | /PRA/FP_LEASE_OIL_ROYALTY_RATE | DEC | 5 | ||
| GAS_ROYALTY_RATE | ONRR-2014 - Lease Gas Royalty Rate | /PRA/FP_LEASE_GAS_ROYALTY_RATE | DEC | 5 | ||
| CIRI_LEASE_NO | ONRR-2014 - CIRI Lease Number | /PRA/FP_CIRI_LEASE_NO | CHAR | 22 | ||
| INDEX_ZONE | ONRR-2014 - Index Zone | /PRA/FP_INDEX_ZONE | CHAR | 6 | /PRA/C_FP_IND | |
| LEASE_NAME | ONRR-2014 - Lease Name | /PRA/FP_LEASE_NAME | CHAR | 40 | ||
| SECT6_FL | Section 6 | /PRA/FP_SECT6_FL | CHAR | 2 | ||
| TRANS37_FL | Transaction 37 | /PRA/FP_TRANS37_FL | CHAR | 2 | ||
| TRANS38_FL | Transaction 38 | /PRA/FP_TRANS38_FL | CHAR | 2 | ||
| ADA_FL | Alt. Dual Accounting | /PRA/FP_ADA_FL | CHAR | 2 | ||
| .INCLUDE | /PRA/S_FP_CTXRF_NONKEY | /PRA/S_FP_CTXRF_NONKEY | 0 | |||
| SALES_TYPE_CD | ONRR-2014 - Sales Type Code | /PRA/FP_SALES_TYPE_CODE | CHAR | 8 | OIUREP_SALESTY | |
| OWNED | Owned | /PRA/FP_OWNED | CHAR | 2 | ||
| NON_OWNED | Non-Owned | /PRA/FP_NON_OWNED | CHAR | 2 | ||
| API_WELL_NO | ONRR-2014 - API Well Number | /PRA/FP_API_WELL_NUMBER | CHAR | 30 | ||
| PRODUCT_CD | ONRR-2014 - Product Code | /PRA/FP_PRODUCT_CODE | CHAR | 4 | ||
| TRANSACTION_CD | ONRR-2014 - Transaction Code | /PRA/FP_TRANSACTION_CODE | CHAR | 4 | ||
| ROY_RATE | ONRR-2014 - Royalty Rate | /PRA/FP_ROYALTY_RATE | CHAR | 20 | ||
| PAY_METHOD_CD | ONRR-2014 - Payment Method Code | /PRA/FP_PAYMENT_METHOD_CODE | CHAR | 2 | ||
| STATUS | ONRR-2014 - Status | /PRA/FP_STATUS | CHAR | 2 | ||
| .INCLUDE | /PRA/S_FP_RPDT_OVERRIDE | /PRA/S_FP_RPDT_OVERRIDE | 0 | |||
| OVR_TRANS_CD | ONRR-2014 - Override Transaction Code | /PRA/FP_OVR_TRANSACTION_CODE | CHAR | 4 | ||
| OVR_ADJ_CD | ONRR-2014 - Override Adjustment Code | /PRA/FP_OVR_ADJUSTMENT_CODE | NUMC | 4 | ||
| OVR_PRICE | ONRR-2014 - Override Price | /PRA/FP_OVR_PRICE | DEC | 5 | ||
| OVR_HEAT_VAL | ONRR-2014 - Override Heating Value | /PRA/FP_OVR_HEAT_VAL | QUAN | 7 | ||
| OVR_REJECT_FL | ONRR-2014 - Override Reject Flag | /PRA/FP_OVERRIDE_REJECT_FL | CHAR | 2 | ||
| OVR_PAD_NO | ONRR-2014 - Override Payor Assigned Document Number | /PRA/FP_OVERRIDE_PAD_NO | CHAR | 16 | ||
| TRANS_DEDUCT_ADJ | ONRR-2014 - Transportation Allowance Deduction Adjustment | /PRA/FP_TRANS_DEDUCT_ADJ | CURR | 7 | ||
| PROC_DEDUCT_ADJ | ONRR-2014 - Processing Allowance Deduction Adjustment | /PRA/FP_PROC_DEDUCT_ADJ | CURR | 7 | ||
| ROYALTY_DUE_ADJ | ONRR-2014 - Royalty Due Adjustment | /PRA/FP_ROYALTY_DUE_ADJ | CURR | 7 | ||
| ROY_DUE_ADJ_JRN | ONRR-2014 - Journalized Royalty Due Adjustment | /PRA/FP_ROY_DUE_ADJ_JRN | CURR | 7 | ||
| RY_DUE_ADJ_PS_FL | ONRR-2014: Persist Royalty Due Adjustment | /PRA/FP_ROY_DUE_ADJ_PS_FL | CHAR | 2 | ||
| RECALCULATE_FL | ONRR-2014: Recalculate Sales Vol/Val | /PRA/FP_RECALC_SALES_VOL_VAL | CHAR | 2 | ||
| .INCLUDE | /PRA/S_FP_PRDT_NONKEY_RPDT_NUM | /PRA/S_FP_PRDT_NONKEY_RPDT_NUM | 0 | |||
| TRANSPORTATION | ONRR-2014 - Transportation Allowance Deduction | /PRA/FP_TRANSPORTATION_DEDUCT | CURR | 7 | ||
| PROCESSING | ONRR-2014 - Processing Allowance Deduction | /PRA/FP_PROCESSING_DEDUCT | CURR | 7 | ||
| TAX | ONRR-2014 - Tax | /PRA/FP_TAX | CURR | 7 | ||
| TAX_REIMBURSE | ONRR-2014 - Tax Reimbursement | /PRA/FP_TAX_REIMBURSEMENT | CURR | 7 | ||
| MKT_REIMBURSE | ONRR-2014 - Marketing Reimbursement | /PRA/FP_MKT_REIMBURSEMENT | CURR | 7 | ||
| .INCLUDE | OIU_CREATION | OIU_CREATION | 0 | |||
| OIU_CRUSER | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
| OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 8 | ||
| ALT_CT_NO | ONRR MPP: Pricing Contract Number | OIU_PRIC_CT_NO | CHAR | 20 |