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