EHSDSW_CRR_HAS

Transparent Table Application Table
48 Fields 1 CDS Views

Draft table Handling and Storage

EHSDSW_CRR_HAS is an SAP database table in S/4HANA. Draft table Handling and Storage. It contains 48 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmplRqRsltHndlgStorageDrft view_entity from BASIC Handling and Storage root draft

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cmplrqrsltuuid EHFND_CRR_UUID Compliance Assessment UUID
activecmplrqrsltuuid EHFND_CRR_UUID Compliance Assessment UUID
cmplrqversuuid EHFND_CRV_UUID Compl Req UUID
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
substanceuuid EHFND_SUB_UUID Substance
chmlsuplrmatluuid EHFND_CSM_UUID Supplier Raw Material
compliancerequirement EHFND_REQ_IDENTIFIER Compliance Requirement
creationdatetime EHFND_BO_CREA_DATE_TIME Created On
createdbyuser EHFND_BO_CREA_UNAME Created By
lastchangedatetime EHFND_BO_LCHG_DATE_TIME Last Changed On
lastchangedbyuser EHFND_BO_LCHG_UNAME Last Changed By
cmplrqrsltprocessingstatus CMPLRQRSLTPROCESSINGSTATUS Processing Status
cmplrqrsltprocessor EHFND_CRR_PROCESSING_USER_BP Processor
releasedbyuser EHFND_CRR_RELEASED_BY_USER_BP Released By
releasedbyusername VDM_USERDESCRIPTION Description
validitystartdatetime EHFND_VALID_FROM_TSTMP Valid From
validityenddatetime EHFND_VALID_TO_TSTMP Valid To
cmplrqrsltreldcmplncsts EHFND_CRR_RELSTAT Released Compliance Status
cmplrqrsltcalculatedstatus EHFND_CRR_CALC_STAT Calculated Compliance Status
cmplrqrsltmanualstatus EHFND_CRR_MAN_STAT_ND Manually Set Compliance Status
cmplrqrsltstatusremark EHFND_CRR_STAT_REMARK Remarks
chmlcompositiontype EHFND_CCI_CCMPS_TYPE Legal Area
materialissold EHFND_CCI_IS_SOLD Is Sold
materialistransported EHFND_CCI_IS_TRANSPORTED Is Transported
materialissourced EHFND_CCI_IS_SOURCED Is Purchased
materialisproduced EHFND_CCI_IS_PRODUCED Is Produced
cmplrqversname EHFND_CRR_CRV_NAME Compliance Requirement Name
cmplrqpatternname EHFND_REQ_PATTERN_NAME_SHORT Pattern Name
cmplrqpattern abap.char
cmplrqpatterndocumentationlink EHFND_REQ_SOURCE_URL Source URL
cmplrqversdocumentationlink EHFND_REQ_SOURCE_URL Source URL
cmplrqregulationofficialname EHFND_CRV_REGULATION_OFF_NAME Official Name
cmplrqregulationversionname EHFND_CRV_REGULATION_VERS_NAME Version Name
cmplrqdescription EHFND_REQ_DESC Description
cmplrqsourceurl EHFND_REQ_SOURCE_URL Source URL
countryname EHFND_COUNTRIES_DESC_ENH Countries/Regions
cmplrqapplicationcomponent EHFND_SOLUTION_AREA Solution Area
chmlcmplncinternalname EHFND_CCI_INTERNAL_NAME Internal Name
chmlcmplncinfotype EHFND_CCI_TYPE Type of Chemical Compliance Information
chmlcmplncprodisresearched EHFND_CCI_IS_RESEARCHED R&D Sample
specification EHFND_INTERNAL_NR_NC Internal Number
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft table Handling and Storage
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHSDSW_CRR_HAS (
    MANDT,                           -- Client [MANDT]
    CMPLRQRSLTUUID,                  -- Compliance Assessment UUID [EHFND_CRR_UUID]
    ACTIVECMPLRQRSLTUUID,            -- Compliance Assessment UUID [EHFND_CRR_UUID]
    CMPLRQVERSUUID,                  -- Compl Req UUID [EHFND_CRV_UUID]
    CHMLCMPLNCINFOUUID,              -- Chemical Compliance Information [EHFND_CCI_UUID]
    SUBSTANCEUUID,                   -- Substance [EHFND_SUB_UUID]
    CHMLSUPLRMATLUUID,               -- Supplier Raw Material [EHFND_CSM_UUID]
    COMPLIANCEREQUIREMENT,           -- Compliance Requirement [EHFND_REQ_IDENTIFIER]
    CREATIONDATETIME,                -- Created On [EHFND_BO_CREA_DATE_TIME]
    CREATEDBYUSER,                   -- Created By [EHFND_BO_CREA_UNAME]
    LASTCHANGEDATETIME,              -- Last Changed On [EHFND_BO_LCHG_DATE_TIME]
    LASTCHANGEDBYUSER,               -- Last Changed By [EHFND_BO_LCHG_UNAME]
    CMPLRQRSLTPROCESSINGSTATUS,      -- Processing Status [CMPLRQRSLTPROCESSINGSTATUS]
    CMPLRQRSLTPROCESSOR,             -- Processor [EHFND_CRR_PROCESSING_USER_BP]
    RELEASEDBYUSER,                  -- Released By [EHFND_CRR_RELEASED_BY_USER_BP]
    RELEASEDBYUSERNAME,              -- Description [VDM_USERDESCRIPTION]
    VALIDITYSTARTDATETIME,           -- Valid From [EHFND_VALID_FROM_TSTMP]
    VALIDITYENDDATETIME,             -- Valid To [EHFND_VALID_TO_TSTMP]
    CMPLRQRSLTRELDCMPLNCSTS,         -- Released Compliance Status [EHFND_CRR_RELSTAT]
    CMPLRQRSLTCALCULATEDSTATUS,      -- Calculated Compliance Status [EHFND_CRR_CALC_STAT]
    CMPLRQRSLTMANUALSTATUS,          -- Manually Set Compliance Status [EHFND_CRR_MAN_STAT_ND]
    CMPLRQRSLTSTATUSREMARK,          -- Remarks [EHFND_CRR_STAT_REMARK]
    CHMLCOMPOSITIONTYPE,             -- Legal Area [EHFND_CCI_CCMPS_TYPE]
    MATERIALISSOLD,                  -- Is Sold [EHFND_CCI_IS_SOLD]
    MATERIALISTRANSPORTED,           -- Is Transported [EHFND_CCI_IS_TRANSPORTED]
    MATERIALISSOURCED,               -- Is Purchased [EHFND_CCI_IS_SOURCED]
    MATERIALISPRODUCED,              -- Is Produced [EHFND_CCI_IS_PRODUCED]
    CMPLRQVERSNAME,                  -- Compliance Requirement Name [EHFND_CRR_CRV_NAME]
    CMPLRQPATTERNNAME,               -- Pattern Name [EHFND_REQ_PATTERN_NAME_SHORT]
    CMPLRQPATTERN,                   -- abap.char
    CMPLRQPATTERNDOCUMENTATIONLINK,  -- Source URL [EHFND_REQ_SOURCE_URL]
    CMPLRQVERSDOCUMENTATIONLINK,     -- Source URL [EHFND_REQ_SOURCE_URL]
    CMPLRQREGULATIONOFFICIALNAME,    -- Official Name [EHFND_CRV_REGULATION_OFF_NAME]
    CMPLRQREGULATIONVERSIONNAME,     -- Version Name [EHFND_CRV_REGULATION_VERS_NAME]
    CMPLRQDESCRIPTION,               -- Description [EHFND_REQ_DESC]
    CMPLRQSOURCEURL,                 -- Source URL [EHFND_REQ_SOURCE_URL]
    COUNTRYNAME,                     -- Countries/Regions [EHFND_COUNTRIES_DESC_ENH]
    CMPLRQAPPLICATIONCOMPONENT,      -- Solution Area [EHFND_SOLUTION_AREA]
    CHMLCMPLNCINTERNALNAME,          -- Internal Name [EHFND_CCI_INTERNAL_NAME]
    CHMLCMPLNCINFOTYPE,              -- Type of Chemical Compliance Information [EHFND_CCI_TYPE]
    CHMLCMPLNCPRODISRESEARCHED,      -- R&D Sample [EHFND_CCI_IS_RESEARCHED]
    SPECIFICATION,                   -- Internal Number [EHFND_INTERNAL_NR_NC]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, CMPLRQRSLTUUID)
);

Learn More