EHFNDD_REQ_ROOT - Compliance Requirement Root

Compliance Requirement Root information is stored in SAP table EHFNDD_REQ_ROOT.
It is part of development package EHFND_BO_COMPLIANCE_REQ in software component EHS-SUS-CI. This development package consists of objects that can be grouped under "Business Objects for Compliance Requirements".

Fields for table EHFNDD_REQ_ROOT

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
BCO_IDBCO IDXEHFND_BCO_IDCHAR80
BCO_KEYBCO KEYXEHFND_BCO_KEYCHAR64
DB_KEYCompliance Requirement UUIDXEHFND_CRV_UUIDRAW16
.INCLUDE/BOBF/S_ADMIN0
DATETIME_CRDate/Time of Item Creation/BOBF/DATETIME_CRDEC8
USER_ID_CRObject Created By/BOBF/USER_ID_CRCHAR24
DATETIME_CHDate/Time of Item Change/BOBF/DATETIME_CHDEC8
USER_ID_CHObject Changed By/BOBF/USER_ID_CHCHAR24
TITLEObsolete - moved to language dependent tableEHFND_REQ_TITLECHAR160
ISSUING_ORGObsolete - moved to language dependent tableEHFND_REQ_TITLECHAR160
ISS_AUTHORITYIssuing AuthorityEHFND_ISS_AUTHORITYCHAR20
TYPECompliance Requirement TypeEHFND_REQ_TYPECHAR4
PMT_LFCYC_IDPermit Lifecycle IDEHFND_PMT_LFCYC_IDCHAR4
STATUSMaintenance StatusEHFND_REQ_STATUSCHAR4
IDENTIF_NUMBERPermit NumberEHFND_REQ_NUMBERCHAR160
OBJECT_KEYCompliance RequirementEHFND_REQ_UUIDRAW16
REVISION_DESCRRevision DescriptionEHFND_REV_EXT_DESCRIPTIONCHAR160
VALID_FROMEffective DateEHFND_REQ_EFFECTIVE_DATEDATS16
VALID_TOExpiration DateEHFND_REQ_END_DATEDATS16
ATF_KEYNodeID/BOBF/CONF_KEYRAW16
DOMAINCompliance Requirement DomainEHFND_REQ_DOMAINCHAR42EHFNDC_REQ_DOM
EHSM_COMPONENTComponent of EHS/PS&SEHFND_EHSM_COMPONENTCHAR10
DATE_REOPENEDCompliance Requirement Build DateEHFND_REQ_DATE_REOPENEDDEC8
TRANSITION_PERIOD_END_DATEEnd of Transition of a Compliance RequirementEHFND_CRV_TRANSITION_END_DATEDATS16
CR_IDCompliance RequirementEHFND_REQ_IDENTIFIERCHAR60
CR_PATTERNCompliance PatternEHFND_REQ_PATTERNCHAR60
SOURCE_URLSource URL for Compliance RequirementEHFND_REQ_SOURCE_URLCHAR510
CONTENT_PROVIDER_NAMEContent ProviderEHFND_REQ_CONTENT_PROVIDERCHAR60
COPYRIGHT_TEXTCompliance Requirement Copyright TextEHFND_REQ_COPYRIGHT_TEXTCHAR600
INITIAL_PROVIDED_BY_SAPIndicator for Only Initial Provisioning by SAP SEEHFND_CRV_PROVIDED_BY_SAP_INDCHAR2
EXTERNAL_KEYCompliance Requirement External KeyEHFND_REQ_EXTERNAL_KEYCHAR510
DOCU_LOIO_IDLOIO ID of DocumentationEHFND_DOCU_LOIO_IDRAW16
PROTECTED_LANGUAGELanguageEHFND_LANGUAGE_IDLANG2
COMPLIANCEREQUIREMENTEDITIONCompliance Requirement EditionCOMPLIANCEREQUIREMENTEDITIONCHAR42
SDS_SUBSQNTSHP_RULESubsequent ShipmentEHFND_REQ_SDS_SUBSQNTSHP_RULECHAR4
ARCHIVING_STATUSArchiving Status/BOFU/ARCHIVING_STATUS_CODECHAR4
EHSLOCATIONUUIDLocationEHFND_LOCATION_KEY_REFRAW16
MIGRATION_SRCMigration SourceEHFND_REQ_MIGRATION_SOURCECHAR120
SEND_NOTIFICATIONIndicator for Permit Email NotificationEHFND_PMT_SEND_NOTIFCHAR2
SET_FOR_RENEWAL_ONSet for renewal on dateEHFND_PMT_SET_FOR_RNWL_ONDATS16
OBJECT_IDCompliance Requirement Object IDEHFND_REQ_ROOT_OBJECT_IDCHAR40
.INCLUDEINCL_EEW_EHFND_REQ_ROOT_D0
EEW_REQ_ROOT_DDummy function in length 1DUMMYCHAR2
Privacy Policy