EHFNDV_PER_ROOT

39 Fields 1 CDS Views

Generated Table for View

EHFNDV_PER_ROOT is an SAP database table in S/4HANA. Generated Table for View. It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EHSCmplRqPermit view from BASIC CmplRq Permit

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cmplrqversid EHFND_BCO_ID BCO ID
KEY cmplrqverscentralid EHFND_BCO_KEY BCO KEY
KEY cmplrqversuuid EHFND_CRV_UUID Compl Req UUID
creationdatetime /BOBF/DATETIME_CR Created On/At
createdbyuser /BOBF/USER_ID_CR Created By
lastchangedatetime /BOBF/DATETIME_CH Changed On/At
lastchangedbyuser /BOBF/USER_ID_CH Changed By
compliancerequirement EHFND_REQ_IDENTIFIER Compliance Requirement
cmplrqversmaintstatus EHFND_REQ_STATUS Status
cmplrqtype EHFND_REQ_TYPE Type
ehscmplrqpermitlifecycle EHFND_PMT_LFCYC_ID Permit Lifecycle ID
cmplrqpattern EHFND_REQ_PATTERN Compliance Pattern
issuingorganization EHFND_REQ_TITLE Obsolete
ehslocationuuid EHFND_LOCATION_KEY_REF Location
contentprovider EHFND_REQ_CONTENT_PROVIDER Content Provider
cmplrqversbuilddate EHFND_REQ_DATE_REOPENED Build Date
cmplrqversvalidtodate EHFND_REQ_END_DATE Expiration Date
cmplrqapplicationcomponent EHFND_EHSM_COMPONENT Component
cmplrqsourceurl EHFND_REQ_SOURCE_URL Source URL
transitionperiodenddate EHFND_CRV_TRANSITION_END_DATE End of Transition
cmplrqisinitiallyprvddbysap EHFND_CRV_PROVIDED_BY_SAP_IND Provided by SAP SE
external_key EHFND_REQ_EXTERNAL_KEY External Key
cmplrqversdocumentationobject EHFND_DOCU_LOIO_ID LOIO ID
cmplrqverspermitnumber EHFND_REQ_NUMBER Permit Number
cmplrqdomain EHFND_REQ_DOMAIN Requirement Domain
effectivedate EHFND_REQ_EFFECTIVE_DATE Effective Date
cmplrquuid EHFND_REQ_UUID Compl Req.
ehscmplrqpmtnotifissent EHFND_PMT_SEND_NOTIF PMT Email NOTIF
ehscmplrqpmtsetforrnwlondate EHFND_PMT_SET_FOR_RNWL_ON FOR RNWL ON DATE
title EHFND_REQ_TITLE Obsolete
businesspartner EHFND_ISS_AUTHORITY Issuing Authority
copyright_text EHFND_REQ_COPYRIGHT_TEXT Copyright Text
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.
cmplrqverschangelog EHFND_REV_EXT_DESCRIPTION Revision
cmplrqpermittype EHEWA_WSTRM_CHNL_PERMIT_TYPE Permit Type

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDV_PER_ROOT (
    MANDT,                          -- Client [MANDT]
    CMPLRQVERSID,                   -- BCO ID [EHFND_BCO_ID]
    CMPLRQVERSCENTRALID,            -- BCO KEY [EHFND_BCO_KEY]
    CMPLRQVERSUUID,                 -- Compl Req UUID [EHFND_CRV_UUID]
    CREATIONDATETIME,               -- Created On/At [/BOBF/DATETIME_CR]
    CREATEDBYUSER,                  -- Created By [/BOBF/USER_ID_CR]
    LASTCHANGEDATETIME,             -- Changed On/At [/BOBF/DATETIME_CH]
    LASTCHANGEDBYUSER,              -- Changed By [/BOBF/USER_ID_CH]
    COMPLIANCEREQUIREMENT,          -- Compliance Requirement [EHFND_REQ_IDENTIFIER]
    CMPLRQVERSMAINTSTATUS,          -- Status [EHFND_REQ_STATUS]
    CMPLRQTYPE,                     -- Type [EHFND_REQ_TYPE]
    EHSCMPLRQPERMITLIFECYCLE,       -- Permit Lifecycle ID [EHFND_PMT_LFCYC_ID]
    CMPLRQPATTERN,                  -- Compliance Pattern [EHFND_REQ_PATTERN]
    ISSUINGORGANIZATION,            -- Obsolete [EHFND_REQ_TITLE]
    EHSLOCATIONUUID,                -- Location [EHFND_LOCATION_KEY_REF]
    CONTENTPROVIDER,                -- Content Provider [EHFND_REQ_CONTENT_PROVIDER]
    CMPLRQVERSBUILDDATE,            -- Build Date [EHFND_REQ_DATE_REOPENED]
    CMPLRQVERSVALIDTODATE,          -- Expiration Date [EHFND_REQ_END_DATE]
    CMPLRQAPPLICATIONCOMPONENT,     -- Component [EHFND_EHSM_COMPONENT]
    CMPLRQSOURCEURL,                -- Source URL [EHFND_REQ_SOURCE_URL]
    TRANSITIONPERIODENDDATE,        -- End of Transition [EHFND_CRV_TRANSITION_END_DATE]
    CMPLRQISINITIALLYPRVDDBYSAP,    -- Provided by SAP SE [EHFND_CRV_PROVIDED_BY_SAP_IND]
    EXTERNAL_KEY,                   -- External Key [EHFND_REQ_EXTERNAL_KEY]
    CMPLRQVERSDOCUMENTATIONOBJECT,  -- LOIO ID [EHFND_DOCU_LOIO_ID]
    CMPLRQVERSPERMITNUMBER,         -- Permit Number [EHFND_REQ_NUMBER]
    CMPLRQDOMAIN,                   -- Requirement Domain [EHFND_REQ_DOMAIN]
    EFFECTIVEDATE,                  -- Effective Date [EHFND_REQ_EFFECTIVE_DATE]
    CMPLRQUUID,                     -- Compl Req. [EHFND_REQ_UUID]
    EHSCMPLRQPMTNOTIFISSENT,        -- PMT Email NOTIF [EHFND_PMT_SEND_NOTIF]
    EHSCMPLRQPMTSETFORRNWLONDATE,   -- FOR RNWL ON DATE [EHFND_PMT_SET_FOR_RNWL_ON]
    TITLE,                          -- Obsolete [EHFND_REQ_TITLE]
    BUSINESSPARTNER,                -- Issuing Authority [EHFND_ISS_AUTHORITY]
    COPYRIGHT_TEXT,                 -- Copyright Text [EHFND_REQ_COPYRIGHT_TEXT]
    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]
    CMPLRQVERSCHANGELOG,            -- Revision [EHFND_REV_EXT_DESCRIPTION]
    CMPLRQPERMITTYPE,               -- Permit Type [EHEWA_WSTRM_CHNL_PERMIT_TYPE]
    PRIMARY KEY (MANDT, CMPLRQVERSID, CMPLRQVERSCENTRALID, CMPLRQVERSUUID)
);

Learn More