/PRA/FP_PRDT

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- ONRR-2014 - PRA Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /PRA/FP_PRDT (
    MANDT,             -- Client [MANDT]
    RUN_ID,            -- Run ID [OIUE2_RUN_ID]
    SALE_DT,           -- Sales Date [OIU_SALE_DT]
    BUKRS,             -- Company Code [BUKRS]
    VNAME,             -- Joint venture [JV_NAME]
    DOI_NO,            -- Venture/DOI [OIU_DOI_NO]
    WL_NO,             -- Well [OIU_WL_NO]
    WC_NO,             -- Well Completion [OIU_WC_NO]
    VBELN,             -- Contract [OIU_CT_NO]
    VL_TYPE_CD,        -- Volume Type [OIU_VL_TYPE_CD]
    PD_CD,             -- Full Product [OIU_FULL_PD_CD]
    OWN_NO,            -- Owner [OIU_OWN_NO]
    SAKNR,             -- G/L Account [SAKNR]
    KOSTL,             -- Cost Center [KOSTL]
    PRDT_LINE_TYPE,    -- Line Type [/PRA/FP_PRDT_LINE_TYPE]
    GUID,              -- UUID [SYSUUID_C32]
    AC_IND,            -- Amended/Current [OIUE2_AC_IND]
    RPDT_AC_IND,       -- Amended/Current [OIUE2_AC_IND]
    PPA_RSN_CD,        -- PPA Reason [OIU_PPA_RSN_CD]
    VOL_UOM,           -- Base Unit [MEINS]
    ENERGY_UOM,        -- Base Unit [MEINS]
    WAERS,             -- Currency [WAERS]
    DN_NO,             -- Delivery network ID [OIU_DN_NO]
    NET_VAL,           -- Own Net Val [/PRA/NET_VAL]
    NET_VOL,           -- Owner Volume [/PRA/NET_VOL]
    OWNER_GROSS_VAL,   -- Owner Gross Val. [/PRA/OWN_GROSS_VAL]
    OWNER_ENERGY,      -- Owner Energy [/PRA/OWNER_ENERGY]
    GROSS_VAL,         -- Gross Value [/PRA/GROSS_VAL]
    GROSS_VOL,         -- Gross Volume [/PRA/GROSS_VOL]
    GROSS_ENERGY,      -- Gross Energy [/PRA/GROSS_ENERGY]
    RAW_NET_VOL,       -- Raw Net Vol [/PRA/FP_RAW_NET_VOL]
    RAW_GROSS_VOL,     -- Raw Gross Vol [/PRA/FP_RAW_GROSS_VOL]
    OOS_FL,            -- Out of Statute [OIUX3_OUT_OF_STATUTE]
    MASTER_LEVEL,      -- Master Level [/PRA/FP_MASTER_LEVEL]
    LEASE_NO,          -- Lease No [/PRA/FP_LEASE_NO]
    AGREEMENT_NO,      -- Agreement No [/PRA/FP_AGREEMENT_NO]
    PAYOR_CD,          -- Payor Code [/PRA/FP_PAYOR_CODE]
    COMP_ROYALTY_FL,   -- Comp Royalty [/PRA/FP_COMPENSATORY_ROYALTY]
    SECTION_6_LSE_FL,  -- Section 6 Lease [/PRA/FP_SECTION_6_LEASE]
    ROY_RELIEF_SH_FL,  -- RoyRelf Shallow [/PRA/FP_ROYALTY_RELIEF_SHALLOW]
    ROY_RELIEF_DP_FL,  -- Roy Relief Deep [/PRA/FP_ROYALTY_RELIEF_DEEP]
    REPORT_API_WL_FL,  -- Report API Well [/PRA/FP_REPORT_API_WELL_FL]
    ALLOC_PERCENT,     -- Allocation % [/PRA/FP_ALLOCATION_PERCENT]
    OVR_ROYALTY_RATE,  -- Override Roy Rt [/PRA/FP_OVERRIDE_ROYALTY_RATE]
    LESSOR_CD,         -- Lessor Code [/PRA/FP_LESSOR_CODE]
    TRIBAL_ALLOTTEE,   -- Tribal/Allottee [/PRA/FP_TRIBAL_ALLOTTEE_IND]
    DISTRIBUTEE_CD,    -- Distributee Cd [/PRA/FP_DISTRIBUTEE_CODE]
    ON_OFF_SHORE_IND,  -- On/Off Shore [/PRA/FP_ON_OFF_SHORE_INDICATOR]
    LEASE_TERM,        -- Lease Term [/PRA/FP_LEASE_TERM]
    SLIDING_SCALE_FL,  -- Sliding Scale [/PRA/FP_SLIDING_SCALE_FLAG]
    ROYALTY_RATE,      -- Lease Roy Rate [/PRA/FP_LEASE_ROYALTY_RATE]
    OIL_ROYALTY_RATE,  -- Oil Roy Rate [/PRA/FP_LEASE_OIL_ROYALTY_RATE]
    GAS_ROYALTY_RATE,  -- Gas Roy Rate [/PRA/FP_LEASE_GAS_ROYALTY_RATE]
    CIRI_LEASE_NO,     -- CIRI Lease No [/PRA/FP_CIRI_LEASE_NO]
    INDEX_ZONE,        -- Index Zone [/PRA/FP_INDEX_ZONE]
    LEASE_NAME,        -- Lease Name [/PRA/FP_LEASE_NAME]
    SECT6_FL,          -- Section 6 [/PRA/FP_SECT6_FL]
    TRANS37_FL,        -- Transaction 37 [/PRA/FP_TRANS37_FL]
    TRANS38_FL,        -- Transaction 38 [/PRA/FP_TRANS38_FL]
    ADA_FL,            -- Alt. Dual Acc. [/PRA/FP_ADA_FL]
    SALES_TYPE_CD,     -- Sales Type Code [/PRA/FP_SALES_TYPE_CODE]
    OWNED,             -- Owned [/PRA/FP_OWNED]
    NON_OWNED,         -- Non-Owned [/PRA/FP_NON_OWNED]
    API_WELL_NO,       -- API Well Number [/PRA/FP_API_WELL_NUMBER]
    PRODUCT_CD,        -- ONRR Product Cd [/PRA/FP_PRODUCT_CODE]
    TRANSACTION_CD,    -- Transaction Cd [/PRA/FP_TRANSACTION_CODE]
    ROY_RATE,          -- Lease Roy Rate [/PRA/FP_ROYALTY_RATE]
    PAY_METHOD_CD,     -- Payment Method [/PRA/FP_PAYMENT_METHOD_CODE]
    STATUS,            -- Status [/PRA/FP_STATUS]
    OVR_TRANS_CD,      -- Ovr Trans Cd [/PRA/FP_OVR_TRANSACTION_CODE]
    OVR_ADJ_CD,        -- Ovr Adjust Code [/PRA/FP_OVR_ADJUSTMENT_CODE]
    OVR_PRICE,         -- Override Price [/PRA/FP_OVR_PRICE]
    OVR_HEAT_VAL,      -- Ovr Heating Val [/PRA/FP_OVR_HEAT_VAL]
    OVR_REJECT_FL,     -- Override Reject [/PRA/FP_OVERRIDE_REJECT_FL]
    OVR_PAD_NO,        -- Override PAD No [/PRA/FP_OVERRIDE_PAD_NO]
    TRANS_DEDUCT_ADJ,  -- Transport Adj [/PRA/FP_TRANS_DEDUCT_ADJ]
    PROC_DEDUCT_ADJ,   -- Processing Adj [/PRA/FP_PROC_DEDUCT_ADJ]
    ROYALTY_DUE_ADJ,   -- Royalty Due Adj [/PRA/FP_ROYALTY_DUE_ADJ]
    ROY_DUE_ADJ_JRN,   -- Roy Due Adj Jrn [/PRA/FP_ROY_DUE_ADJ_JRN]
    RY_DUE_ADJ_PS_FL,  -- PersistRyDueAdj [/PRA/FP_ROY_DUE_ADJ_PS_FL]
    RECALCULATE_FL,    -- Recalc SalVo/Va [/PRA/FP_RECALC_SALES_VOL_VAL]
    TRANSPORTATION,    -- Transport Ded [/PRA/FP_TRANSPORTATION_DEDUCT]
    PROCESSING,        -- Processing Ded [/PRA/FP_PROCESSING_DEDUCT]
    TAX,               -- Tax [/PRA/FP_TAX]
    TAX_REIMBURSE,     -- Tax Reimburse [/PRA/FP_TAX_REIMBURSEMENT]
    MKT_REIMBURSE,     -- Mkt Reimburse [/PRA/FP_MKT_REIMBURSEMENT]
    OIU_CRUSER,        -- Created By [ERNAM]
    OIU_TIMESTAMP,     -- Time Stamp [TZNTSTMPS]
    ALT_CT_NO,         -- Pricing Ct [OIU_PRIC_CT_NO]
    PRIMARY KEY (MANDT, RUN_ID, SALE_DT, BUKRS, VNAME, DOI_NO, WL_NO, WC_NO, VBELN, VL_TYPE_CD, PD_CD, OWN_NO, SAKNR, KOSTL, PRDT_LINE_TYPE)
);