JBRPH

Transparent Table Customizing Table
22 Fields 1 CDS Views

Portfolio hierarchy

JBRPH is an SAP database table in S/4HANA. Portfolio hierarchy. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RiskAnalyzerPortfolioHier view from BASIC Risk Analyzer Portfolio Hierarchy

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY sichtid jbrsichtid View
KEY phid jbrphid Portfolio Hierarchy
autgr tv_autgr Authorization Group
upuser tb_upuser Changed By
dupdat tb_dupdat Changed On
tuptim tb_tuptim Time Changed
tuptst jbruptst Changed On
trkorr trkorr Request/Task
cruser tb_cruser Entered By
dcrdat tb_crdat Entry Date
tcrtim tb_tcrtim Entry Time
dgedat jbrgedat Generated On
tgetim jbrgetim Generation time
tgetst jbrgetst Gen.Time Stamp
notactiv ph_notactive PH is inactive
archived ph_archived Archived
status_icon ph_icon Status of PH
ph_filter afwch_phflid PH Filter
testmodus afwch_status Test Mode
updfotyp afwch_fo_type Updating FO Type
valarea tpm_val_area Valuation Area

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.

-- Portfolio hierarchy
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JBRPH (
    MANDT,        -- Client [mandt]
    SICHTID,      -- View [jbrsichtid]
    PHID,         -- Portfolio Hierarchy [jbrphid]
    AUTGR,        -- Authorization Group [tv_autgr]
    UPUSER,       -- Changed By [tb_upuser]
    DUPDAT,       -- Changed On [tb_dupdat]
    TUPTIM,       -- Time Changed [tb_tuptim]
    TUPTST,       -- Changed On [jbruptst]
    TRKORR,       -- Request/Task [trkorr]
    CRUSER,       -- Entered By [tb_cruser]
    DCRDAT,       -- Entry Date [tb_crdat]
    TCRTIM,       -- Entry Time [tb_tcrtim]
    DGEDAT,       -- Generated On [jbrgedat]
    TGETIM,       -- Generation time [jbrgetim]
    TGETST,       -- Gen.Time Stamp [jbrgetst]
    NOTACTIV,     -- PH is inactive [ph_notactive]
    ARCHIVED,     -- Archived [ph_archived]
    STATUS_ICON,  -- Status of PH [ph_icon]
    PH_FILTER,    -- PH Filter [afwch_phflid]
    TESTMODUS,    -- Test Mode [afwch_status]
    UPDFOTYP,     -- Updating FO Type [afwch_fo_type]
    VALAREA,      -- Valuation Area [tpm_val_area]
    PRIMARY KEY (MANDT, SICHTID, PHID)
);

Learn More