JBRPHBAUMS

Transparent Table Application Table
24 Fields 1 CDS Views

Storage of Portfolio Hierarchy

JBRPHBAUMS is an SAP database table in S/4HANA. Storage of Portfolio Hierarchy. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PortfolioHierarchyNode view from COMPOSITE

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sichtid JBRSICHTID View
KEY phid JBRPHID Portfolio Hierarchy
KEY pknoten JBRPKNOTEN PH Node
bpid JBRBPID Base Portfolio
type SEU_TYPE Type
name SEU_NAME Name
tlevel SEU_LEVEL Level
link SEU_LINK Link ID
compressr SEU_COMPR Compression ID
leaf SEU_LEAF Page
tlock SEU_LOCK Lock
parent SEU_ID ID
child SEU_ID ID
nextr SEU_ID ID
indx_in SYTABIX Table Row
intrv_flag FLAG Indicator
add_flag FLAG Indicator
fienm FIELDNAME Field Name
auspg RKE_LOW_L Lower Limit
nflag FTI_NFLAG Control flag to read text hierarchy node
domnm DOMNAME Domain
rolnm ROLLNAME Data Element
parent_dim SEU_ID ID

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.

-- Storage of Portfolio Hierarchy
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JBRPHBAUMS (
    MANDT,       -- Client [MANDT]
    SICHTID,     -- View [JBRSICHTID]
    PHID,        -- Portfolio Hierarchy [JBRPHID]
    PKNOTEN,     -- PH Node [JBRPKNOTEN]
    BPID,        -- Base Portfolio [JBRBPID]
    TYPE,        -- Type [SEU_TYPE]
    NAME,        -- Name [SEU_NAME]
    TLEVEL,      -- Level [SEU_LEVEL]
    LINK,        -- Link ID [SEU_LINK]
    COMPRESSR,   -- Compression ID [SEU_COMPR]
    LEAF,        -- Page [SEU_LEAF]
    TLOCK,       -- Lock [SEU_LOCK]
    PARENT,      -- ID [SEU_ID]
    CHILD,       -- ID [SEU_ID]
    NEXTR,       -- ID [SEU_ID]
    INDX_IN,     -- Table Row [SYTABIX]
    INTRV_FLAG,  -- Indicator [FLAG]
    ADD_FLAG,    -- Indicator [FLAG]
    FIENM,       -- Field Name [FIELDNAME]
    AUSPG,       -- Lower Limit [RKE_LOW_L]
    NFLAG,       -- Control flag to read text hierarchy node [FTI_NFLAG]
    DOMNM,       -- Domain [DOMNAME]
    ROLNM,       -- Data Element [ROLLNAME]
    PARENT_DIM,  -- ID [SEU_ID]
    PRIMARY KEY (MANDT, SICHTID, PHID, PKNOTEN)
);

Learn More