EHFNDD_REQ_ROOT

Transparent Table Control Table (SAP+Cust)
41 Fields 3 CDS Views

Compliance Requirement Root

EHFNDD_REQ_ROOT is an SAP database table in S/4HANA. Compliance Requirement Root. It contains 41 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_CmplRqVers view from EXTENSION Extension view for Comp Req. Version
I_CmplRqVersBasic view_entity from BASIC Compliance Requirement Version Basic
I_WorkViewCmplRq view_entity from BASIC Work Perspective Compliance Requirement

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bco_id ehfnd_bco_id BCO ID
KEY bco_key ehfnd_bco_key BCO KEY
KEY db_key ehfnd_crv_uuid Compl Req UUID
title ehfnd_req_title Obsolete
issuing_org ehfnd_req_title Obsolete
iss_authority ehfnd_iss_authority Issuing Authority
type ehfnd_req_type Type
pmt_lfcyc_id ehfnd_pmt_lfcyc_id Permit Lifecycle ID
status ehfnd_req_status Status
identif_number ehfnd_req_number Permit Number
object_key ehfnd_req_uuid Compl Req.
revision_descr ehfnd_rev_ext_description Revision
valid_from ehfnd_req_effective_date Effective Date
valid_to ehfnd_req_end_date Expiration Date
atf_key /bobf/conf_key NodeID
domain ehfnd_req_domain Requirement Domain
ehsm_component ehfnd_ehsm_component Component
date_reopened ehfnd_req_date_reopened Build Date
transition_period_end_date ehfnd_crv_transition_end_date End of Transition
cr_id ehfnd_req_identifier Compliance Requirement
cr_pattern ehfnd_req_pattern Compliance Pattern
source_url ehfnd_req_source_url Source URL
content_provider_name ehfnd_req_content_provider Content Provider
copyright_text ehfnd_req_copyright_text Copyright Text
initial_provided_by_sap ehfnd_crv_provided_by_sap_ind Provided by SAP SE
external_key ehfnd_req_external_key External Key
docu_loio_id ehfnd_docu_loio_id LOIO ID
protected_language ehfnd_language_id Language
compliancerequirementedition compliancerequirementedition Edition
sds_subsqntshp_rule ehfnd_req_sds_subsqntshp_rule Subsequent Shipment
archiving_status /bofu/archiving_status_code Archiving Stat.
ehslocationuuid ehfnd_location_key_ref Location
migration_src ehfnd_req_migration_source Migr. Source
send_notification ehfnd_pmt_send_notif PMT Email NOTIF
set_for_renewal_on ehfnd_pmt_set_for_rnwl_on FOR RNWL ON DATE
object_id ehfnd_req_root_object_id Object ID
envrmtwastecode ehfnd_waste_code Waste Code
permit_type ehewa_wstrm_chnl_permit_type Permit Type
cmplrqverstopic ehfnd_crv_topic
is_created_from_doc ehfnd_crv_created_from_doc_ind

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.

-- Compliance Requirement Root
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_REQ_ROOT (
    MANDT,                         -- Client [mandt]
    BCO_ID,                        -- BCO ID [ehfnd_bco_id]
    BCO_KEY,                       -- BCO KEY [ehfnd_bco_key]
    DB_KEY,                        -- Compl Req UUID [ehfnd_crv_uuid]
    TITLE,                         -- Obsolete [ehfnd_req_title]
    ISSUING_ORG,                   -- Obsolete [ehfnd_req_title]
    ISS_AUTHORITY,                 -- Issuing Authority [ehfnd_iss_authority]
    TYPE,                          -- Type [ehfnd_req_type]
    PMT_LFCYC_ID,                  -- Permit Lifecycle ID [ehfnd_pmt_lfcyc_id]
    STATUS,                        -- Status [ehfnd_req_status]
    IDENTIF_NUMBER,                -- Permit Number [ehfnd_req_number]
    OBJECT_KEY,                    -- Compl Req. [ehfnd_req_uuid]
    REVISION_DESCR,                -- Revision [ehfnd_rev_ext_description]
    VALID_FROM,                    -- Effective Date [ehfnd_req_effective_date]
    VALID_TO,                      -- Expiration Date [ehfnd_req_end_date]
    ATF_KEY,                       -- NodeID [/bobf/conf_key]
    DOMAIN,                        -- Requirement Domain [ehfnd_req_domain]
    EHSM_COMPONENT,                -- Component [ehfnd_ehsm_component]
    DATE_REOPENED,                 -- Build Date [ehfnd_req_date_reopened]
    TRANSITION_PERIOD_END_DATE,    -- End of Transition [ehfnd_crv_transition_end_date]
    CR_ID,                         -- Compliance Requirement [ehfnd_req_identifier]
    CR_PATTERN,                    -- Compliance Pattern [ehfnd_req_pattern]
    SOURCE_URL,                    -- Source URL [ehfnd_req_source_url]
    CONTENT_PROVIDER_NAME,         -- Content Provider [ehfnd_req_content_provider]
    COPYRIGHT_TEXT,                -- Copyright Text [ehfnd_req_copyright_text]
    INITIAL_PROVIDED_BY_SAP,       -- Provided by SAP SE [ehfnd_crv_provided_by_sap_ind]
    EXTERNAL_KEY,                  -- External Key [ehfnd_req_external_key]
    DOCU_LOIO_ID,                  -- LOIO ID [ehfnd_docu_loio_id]
    PROTECTED_LANGUAGE,            -- Language [ehfnd_language_id]
    COMPLIANCEREQUIREMENTEDITION,  -- Edition [compliancerequirementedition]
    SDS_SUBSQNTSHP_RULE,           -- Subsequent Shipment [ehfnd_req_sds_subsqntshp_rule]
    ARCHIVING_STATUS,              -- Archiving Stat. [/bofu/archiving_status_code]
    EHSLOCATIONUUID,               -- Location [ehfnd_location_key_ref]
    MIGRATION_SRC,                 -- Migr. Source [ehfnd_req_migration_source]
    SEND_NOTIFICATION,             -- PMT Email NOTIF [ehfnd_pmt_send_notif]
    SET_FOR_RENEWAL_ON,            -- FOR RNWL ON DATE [ehfnd_pmt_set_for_rnwl_on]
    OBJECT_ID,                     -- Object ID [ehfnd_req_root_object_id]
    ENVRMTWASTECODE,               -- Waste Code [ehfnd_waste_code]
    PERMIT_TYPE,                   -- Permit Type [ehewa_wstrm_chnl_permit_type]
    CMPLRQVERSTOPIC,               -- ehfnd_crv_topic
    IS_CREATED_FROM_DOC,           -- ehfnd_crv_created_from_doc_ind
    PRIMARY KEY (MANDT, BCO_ID, BCO_KEY, DB_KEY)
);

Learn More