/PRA/AKR_OOSHST

Transparent Table Application Table
73 Fields 1 CDS Views

Roy 2.0 AK - Out of Statute Roy Transactions History

/PRA/AKR_OOSHST is an SAP database table in S/4HANA. Roy 2.0 AK - Out of Statute Roy Transactions History. It contains 73 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRA_US_AKRyRptOOStueHistory view_entity from BASIC PRA AK RyRpt OOS Ry Trans Hist

Fields (73)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY sales_dt OIU_SALE_DT Sales Date
KEY pdcd OIU_FULL_PD_CD Full Product
KEY wl_no OIU_WL_NO Well
KEY wc_no OIU_WC_NO Well Completion
KEY mp_no OIU_MP_NO Measurement Pt
KEY vname JV_NAME Joint venture
KEY doi_no OIU_DOI_NO Venture/DOI
KEY dn_no OIU_DN_NO Delivery network ID
KEY ct_no OIU_CT_NO Contract
KEY vl_type_cd OIU_VT_CD Volume Type
KEY own_no OIU_OWN_NO Owner
KEY own_int_type_cd OIU_PART_INT_TYPE Interest Type
KEY own_isq_no OIU_OWN_ISQ_NO Own. ISQ
KEY kostl KOSTL Cost Center
rev_book_adj_ind OIUY3_REV_BOOK_REVADJ_ADJ_IND RvBkRvAjAj
unit_vname JV_NAME Joint venture
operated_fl OIU_OPERATOR_FL Operated
orig_mp_no OIU_ORIG_MP_NO Originating MP
acct_no SAKNR G/L Account
ps_base_qy OIU_PS_BASE Pressure Base
grv_qy OIUXC_GRAVITY Gravity
pay_cd OIU_PAY_CD Pay Code
own_int_decm_qy OIUY3_TX_OWNER_NRI Owner NRI
own_bal_decm_qy /PRA/DISB_DECM Disb Decimal
pri_geo_loc OIU_PRI_GEO_LOC Primary geo.loc
counc COUNC County Code
enty_cd OIU_ENTY_CD Entity Type
waers WAERS Currency
vol_uom /PRA/VOL_UOM Volume Unit
energy_uom /PRA/ENERGY_UOM Energy Unit
heat_val_uom /PRA/HEATING_UOM Heating UoM
pres_uom OIU_MEAS_U UoM
btu_qy /PRA/BTU_QUANTITY BTU quantity
prd_days OIU_DAYS_PROD Days produced
disb_decimal /PRA/DISB_DECM Disb Decimal
nri_decimal OIU_NRI_PC NRI
doc_no OIURV_DOCNR DocNr
doc_year OIU_DOC_YEAR Document year
gross_vol /PRA/GROSS_VOL Gross Volume
gross_energy /PRA/GROSS_ENERGY Gross Energy
gross_pvr /PRA/GROSS_PVR Gross PVR
gross_ptr /PRA/GROSS_PTR Gross PTR
net_vol /PRA/NET_VOL Owner Volume
owner_energy /PRA/OWNER_ENERGY Owner Energy
own_pvr /PRA/OWN_PVR Owner PVR
own_ptr /PRA/OWN_PTR Owner PTR
gross_val /PRA/GROSS_VAL Gross Value
owner_gross_val /PRA/OWN_GROSS_VAL Owner Gross Val.
net_val /PRA/NET_VAL Own Net Val
net_transp_am OIUX3_MARKETING_COST Marketing Cost
net_oth_mk_am OIUX3_MARKETING_COST Marketing Cost
ded_rmb_am /PRA/NET_MKT_REIM_AM Net Mktg Reimb
tax_am OIUH_TAX_AMOUNT Tax amount
tax_rmb_am OIUH_TAX_REIMBURSEMENT_AMT Tax Reimb Amt
option1 CHAR1 Single-Character Flag
option2 CHAR1 Single-Character Flag
option3 CHAR1 Single-Character Flag
interface_fl FLAG Indicator
reference_run_id OIUX3_RUN_ID Run ID
prof_link_guid /PRA/RP_PROF_LINK_GUID Link GUID
master_level OIUX3_TX_MASTER_LEVEL Master Level
product_cd /PRA/AKR_PRODUCT_CD Product Code
report_cd /PRA/AKR_REPORT_CD Report Code
ac_unit_cd /PRA/AKR_AC_UNIT_CD Accounting Unit Code
ac_unit_nm /PRA/AKR_AC_UNIT_NM Accounting Unit Name
royalty_decimal OIUY3_TX_ROYALTY_DECIMAL Royalty Decimal
os_decimal /PRA/AKR_OS_DECIMAL Out Substantial Dec
gd_only_ct FLAG Indicator
allocation_factor /PRA/AKR_ALLOCATION_FACTOR Allocation Factor
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp

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.

-- Roy 2.0 AK - Out of Statute Roy Transactions History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /PRA/AKR_OOSHST (
    MANDT,              -- Client [MANDT]
    BUKRS,              -- Company Code [BUKRS]
    SALES_DT,           -- Sales Date [OIU_SALE_DT]
    PDCD,               -- Full Product [OIU_FULL_PD_CD]
    WL_NO,              -- Well [OIU_WL_NO]
    WC_NO,              -- Well Completion [OIU_WC_NO]
    MP_NO,              -- Measurement Pt [OIU_MP_NO]
    VNAME,              -- Joint venture [JV_NAME]
    DOI_NO,             -- Venture/DOI [OIU_DOI_NO]
    DN_NO,              -- Delivery network ID [OIU_DN_NO]
    CT_NO,              -- Contract [OIU_CT_NO]
    VL_TYPE_CD,         -- Volume Type [OIU_VT_CD]
    OWN_NO,             -- Owner [OIU_OWN_NO]
    OWN_INT_TYPE_CD,    -- Interest Type [OIU_PART_INT_TYPE]
    OWN_ISQ_NO,         -- Own. ISQ [OIU_OWN_ISQ_NO]
    KOSTL,              -- Cost Center [KOSTL]
    REV_BOOK_ADJ_IND,   -- RvBkRvAjAj [OIUY3_REV_BOOK_REVADJ_ADJ_IND]
    UNIT_VNAME,         -- Joint venture [JV_NAME]
    OPERATED_FL,        -- Operated [OIU_OPERATOR_FL]
    ORIG_MP_NO,         -- Originating MP [OIU_ORIG_MP_NO]
    ACCT_NO,            -- G/L Account [SAKNR]
    PS_BASE_QY,         -- Pressure Base [OIU_PS_BASE]
    GRV_QY,             -- Gravity [OIUXC_GRAVITY]
    PAY_CD,             -- Pay Code [OIU_PAY_CD]
    OWN_INT_DECM_QY,    -- Owner NRI [OIUY3_TX_OWNER_NRI]
    OWN_BAL_DECM_QY,    -- Disb Decimal [/PRA/DISB_DECM]
    PRI_GEO_LOC,        -- Primary geo.loc [OIU_PRI_GEO_LOC]
    COUNC,              -- County Code [COUNC]
    ENTY_CD,            -- Entity Type [OIU_ENTY_CD]
    WAERS,              -- Currency [WAERS]
    VOL_UOM,            -- Volume Unit [/PRA/VOL_UOM]
    ENERGY_UOM,         -- Energy Unit [/PRA/ENERGY_UOM]
    HEAT_VAL_UOM,       -- Heating UoM [/PRA/HEATING_UOM]
    PRES_UOM,           -- UoM [OIU_MEAS_U]
    BTU_QY,             -- BTU quantity [/PRA/BTU_QUANTITY]
    PRD_DAYS,           -- Days produced [OIU_DAYS_PROD]
    DISB_DECIMAL,       -- Disb Decimal [/PRA/DISB_DECM]
    NRI_DECIMAL,        -- NRI [OIU_NRI_PC]
    DOC_NO,             -- DocNr [OIURV_DOCNR]
    DOC_YEAR,           -- Document year [OIU_DOC_YEAR]
    GROSS_VOL,          -- Gross Volume [/PRA/GROSS_VOL]
    GROSS_ENERGY,       -- Gross Energy [/PRA/GROSS_ENERGY]
    GROSS_PVR,          -- Gross PVR [/PRA/GROSS_PVR]
    GROSS_PTR,          -- Gross PTR [/PRA/GROSS_PTR]
    NET_VOL,            -- Owner Volume [/PRA/NET_VOL]
    OWNER_ENERGY,       -- Owner Energy [/PRA/OWNER_ENERGY]
    OWN_PVR,            -- Owner PVR [/PRA/OWN_PVR]
    OWN_PTR,            -- Owner PTR [/PRA/OWN_PTR]
    GROSS_VAL,          -- Gross Value [/PRA/GROSS_VAL]
    OWNER_GROSS_VAL,    -- Owner Gross Val. [/PRA/OWN_GROSS_VAL]
    NET_VAL,            -- Own Net Val [/PRA/NET_VAL]
    NET_TRANSP_AM,      -- Marketing Cost [OIUX3_MARKETING_COST]
    NET_OTH_MK_AM,      -- Marketing Cost [OIUX3_MARKETING_COST]
    DED_RMB_AM,         -- Net Mktg Reimb [/PRA/NET_MKT_REIM_AM]
    TAX_AM,             -- Tax amount [OIUH_TAX_AMOUNT]
    TAX_RMB_AM,         -- Tax Reimb Amt [OIUH_TAX_REIMBURSEMENT_AMT]
    OPTION1,            -- Single-Character Flag [CHAR1]
    OPTION2,            -- Single-Character Flag [CHAR1]
    OPTION3,            -- Single-Character Flag [CHAR1]
    INTERFACE_FL,       -- Indicator [FLAG]
    REFERENCE_RUN_ID,   -- Run ID [OIUX3_RUN_ID]
    PROF_LINK_GUID,     -- Link GUID [/PRA/RP_PROF_LINK_GUID]
    MASTER_LEVEL,       -- Master Level [OIUX3_TX_MASTER_LEVEL]
    PRODUCT_CD,         -- Product Code [/PRA/AKR_PRODUCT_CD]
    REPORT_CD,          -- Report Code [/PRA/AKR_REPORT_CD]
    AC_UNIT_CD,         -- Accounting Unit Code [/PRA/AKR_AC_UNIT_CD]
    AC_UNIT_NM,         -- Accounting Unit Name [/PRA/AKR_AC_UNIT_NM]
    ROYALTY_DECIMAL,    -- Royalty Decimal [OIUY3_TX_ROYALTY_DECIMAL]
    OS_DECIMAL,         -- Out Substantial Dec [/PRA/AKR_OS_DECIMAL]
    GD_ONLY_CT,         -- Indicator [FLAG]
    ALLOCATION_FACTOR,  -- Allocation Factor [/PRA/AKR_ALLOCATION_FACTOR]
    OIU_CRUSER,         -- Created By [ERNAM]
    OIU_TIMESTAMP,      -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, BUKRS, SALES_DT, PDCD, WL_NO, WC_NO, MP_NO, VNAME, DOI_NO, DN_NO, CT_NO, VL_TYPE_CD, OWN_NO, OWN_INT_TYPE_CD, OWN_ISQ_NO, KOSTL)
);

Learn More