/PRA/RD_BK_HSTRY

Transparent Table Application Table

RD Transaction bookings history

/PRA/RD_BK_HSTRY is an SAP database table in S/4HANA. RD Transaction bookings history. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRARevnDistrBkgHist view_entity from BASIC Revenue Distribution Bookings History

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY dn_no oiu_dn_no Delivery network ID
KEY sale_dt oiu_sale_dt Sales Date
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 vbeln oiu_ct_no Contract
KEY pd_cd oiu_full_pd_cd Full Product
KEY vl_type_cd oiu_vl_type_cd Volume Type
KEY tax_cls oiu_tax_cls Tax Class
doc_no oiurv_docnr DocNr
doc_year oiu_doc_year Document year
header_no oiu_sys_no System number
guid guid GUID

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.

-- RD Transaction bookings history
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /PRA/RD_BK_HSTRY (
    MANDT,       -- Client [mandt]
    DN_NO,       -- Delivery network ID [oiu_dn_no]
    SALE_DT,     -- Sales Date [oiu_sale_dt]
    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]
    VBELN,       -- Contract [oiu_ct_no]
    PD_CD,       -- Full Product [oiu_full_pd_cd]
    VL_TYPE_CD,  -- Volume Type [oiu_vl_type_cd]
    TAX_CLS,     -- Tax Class [oiu_tax_cls]
    DOC_NO,      -- DocNr [oiurv_docnr]
    DOC_YEAR,    -- Document year [oiu_doc_year]
    HEADER_NO,   -- System number [oiu_sys_no]
    GUID,        -- GUID [guid]
    PRIMARY KEY (MANDT, DN_NO, SALE_DT, WL_NO, WC_NO, MP_NO, VNAME, DOI_NO, VBELN, PD_CD, VL_TYPE_CD, TAX_CLS)
);