EHFNDV_REQ_ROOT

34 Fields 2 CDS Views

Generated Table for View

EHFNDV_REQ_ROOT is an SAP database table in S/4HANA. Generated Table for View. It contains 34 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CmplRqVers view from BASIC Compliance Requirement Version View
I_CmplRqVersBasic view from BASIC Compliance Requirement Version Basic

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY sapclient MANDT Client
KEY cmplrqvers EHFND_BCO_ID BCO ID
KEY bcokey 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
cmplrqtitle EHFND_REQ_TITLE Obsolete
ehslocationuuid EHFND_LOCATION_KEY_REF Location
issuingorganization EHFND_REQ_TITLE Obsolete
cmplrqtype EHFND_REQ_TYPE Type
ehscmplrqpermitlifecycle EHFND_PMT_LFCYC_ID Permit Lifecycle ID
cmplrqversmaintstatus EHFND_REQ_STATUS Status
cmplrqverspermitnumber EHFND_REQ_NUMBER Permit Number
cmplrquuid EHFND_REQ_UUID Compl Req.
cmplrqverschangelog EHFND_REV_EXT_DESCRIPTION Revision
validfrom EHFND_REQ_EFFECTIVE_DATE Effective Date
validto EHFND_REQ_END_DATE Expiration Date
cmplrqdomain EHFND_REQ_DOMAIN Requirement Domain
cmplrqapplicationcomponent EHFND_EHSM_COMPONENT Component
cmplrqversbuilddate EHFND_REQ_DATE_REOPENED Build Date
compliancerequirement EHFND_REQ_IDENTIFIER Compliance Requirement
transitionperiodenddate EHFND_CRV_TRANSITION_END_DATE End of Transition
cmplrqpattern EHFND_REQ_PATTERN Compliance Pattern
cmplrqsourceurl EHFND_REQ_SOURCE_URL Source URL
contentprovider EHFND_REQ_CONTENT_PROVIDER Content Provider
cmplrqverscopyrighttxt EHFND_REQ_COPYRIGHT_TEXT Copyright Text
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
sftydatashtsubsqntshptrule EHFND_REQ_SDS_SUBSQNTSHP_RULE Subsequent Shipment
cmplrqmigrationsrc EHFND_REQ_MIGRATION_SOURCE Migr. Source
permit_type 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_REQ_ROOT (
    SAPCLIENT,                      -- Client [MANDT]
    CMPLRQVERS,                     -- BCO ID [EHFND_BCO_ID]
    BCOKEY,                         -- 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]
    CMPLRQTITLE,                    -- Obsolete [EHFND_REQ_TITLE]
    EHSLOCATIONUUID,                -- Location [EHFND_LOCATION_KEY_REF]
    ISSUINGORGANIZATION,            -- Obsolete [EHFND_REQ_TITLE]
    CMPLRQTYPE,                     -- Type [EHFND_REQ_TYPE]
    EHSCMPLRQPERMITLIFECYCLE,       -- Permit Lifecycle ID [EHFND_PMT_LFCYC_ID]
    CMPLRQVERSMAINTSTATUS,          -- Status [EHFND_REQ_STATUS]
    CMPLRQVERSPERMITNUMBER,         -- Permit Number [EHFND_REQ_NUMBER]
    CMPLRQUUID,                     -- Compl Req. [EHFND_REQ_UUID]
    CMPLRQVERSCHANGELOG,            -- Revision [EHFND_REV_EXT_DESCRIPTION]
    VALIDFROM,                      -- Effective Date [EHFND_REQ_EFFECTIVE_DATE]
    VALIDTO,                        -- Expiration Date [EHFND_REQ_END_DATE]
    CMPLRQDOMAIN,                   -- Requirement Domain [EHFND_REQ_DOMAIN]
    CMPLRQAPPLICATIONCOMPONENT,     -- Component [EHFND_EHSM_COMPONENT]
    CMPLRQVERSBUILDDATE,            -- Build Date [EHFND_REQ_DATE_REOPENED]
    COMPLIANCEREQUIREMENT,          -- Compliance Requirement [EHFND_REQ_IDENTIFIER]
    TRANSITIONPERIODENDDATE,        -- End of Transition [EHFND_CRV_TRANSITION_END_DATE]
    CMPLRQPATTERN,                  -- Compliance Pattern [EHFND_REQ_PATTERN]
    CMPLRQSOURCEURL,                -- Source URL [EHFND_REQ_SOURCE_URL]
    CONTENTPROVIDER,                -- Content Provider [EHFND_REQ_CONTENT_PROVIDER]
    CMPLRQVERSCOPYRIGHTTXT,         -- Copyright Text [EHFND_REQ_COPYRIGHT_TEXT]
    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]
    SFTYDATASHTSUBSQNTSHPTRULE,     -- Subsequent Shipment [EHFND_REQ_SDS_SUBSQNTSHP_RULE]
    CMPLRQMIGRATIONSRC,             -- Migr. Source [EHFND_REQ_MIGRATION_SOURCE]
    PERMIT_TYPE,                    -- Permit Type [EHEWA_WSTRM_CHNL_PERMIT_TYPE]
    PRIMARY KEY (SAPCLIENT, CMPLRQVERS, BCOKEY, CMPLRQVERSUUID)
);

Learn More