HRRP_ATTR_DIR_N
Hierarchy Directroy Attribute (New Design)
HRRP_ATTR_DIR_N is an SAP database table in S/4HANA. Hierarchy Directroy Attribute (New Design). It contains 9 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_HierRtmeRprstnAddlAttrib | view | from | BASIC | Hierarchy Directory Attribute |
| R_HierRtmeRprstnAddlAttrib | view | from | BASIC | Hierarchy Directory Attribute |
Fields (9)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | hrytyp | hrytype | Hierarchy Type | |||
| KEY | hryid | hryid_40 | Hierarchy ID | |||
| KEY | hryvalto | datbi | Valid To | |||
| KEY | hryattrname | hryattrname | Attribute Name | |||
| KEY | hryattrvalue | hryattrvalue | Attribute Value | |||
| hryattrhvalue | hryattrhvalue | Attribute High Value | ||||
| hryid_42 | hryid | Hierarchy ID | ||||
| node_timedep | node_timedep |
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.
-- Hierarchy Directroy Attribute (New Design)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRRP_ATTR_DIR_N (
MANDT, -- Client [mandt]
HRYTYP, -- Hierarchy Type [hrytype]
HRYID, -- Hierarchy ID [hryid_40]
HRYVALTO, -- Valid To [datbi]
HRYATTRNAME, -- Attribute Name [hryattrname]
HRYATTRVALUE, -- Attribute Value [hryattrvalue]
HRYATTRHVALUE, -- Attribute High Value [hryattrhvalue]
HRYID_42, -- Hierarchy ID [hryid]
NODE_TIMEDEP, -- node_timedep
PRIMARY KEY (MANDT, HRYTYP, HRYID, HRYVALTO, HRYATTRNAME, HRYATTRVALUE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA