EHSDSW_CRR_ESDSA

Transparent Table Application Table
36 Fields 1 CDS Views

I_CMPLRQRSLTPCESANNEXASSMTTP I_CMPLRQRSLTPCESANNEXASSMTTP

EHSDSW_CRR_ESDSA is an SAP database table in S/4HANA. I_CMPLRQRSLTPCESANNEXASSMTTP I_CMPLRQRSLTPCESANNEXASSMTTP. It contains 36 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ExpsrScenAnnexAssmtDraft view from BASIC Annex Assessment - Draft

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cmplrqrsltuuid EHFND_CRR_UUID Compliance Assessment UUID
activecmplrqrsltuuid EHFND_CRR_ACTIVE_UUID Active 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
chemicalcustomermaterialuuid EHFND_CCM_UUID Customer 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
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
cmplrqrsltprelimcmplncsts EHFND_CRR_PRELIM_COMP_STAT Preliminary 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
pcesscenariouuid EHFND_ES_SCENARIO_UUID Scenario UUID
activeuuid /BOBF/UUID Key
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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.

-- I_CMPLRQRSLTPCESANNEXASSMTTP I_CMPLRQRSLTPCESANNEXASSMTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHSDSW_CRR_ESDSA (
    MANDT,                          -- Client [MANDT]
    CMPLRQRSLTUUID,                 -- Compliance Assessment UUID [EHFND_CRR_UUID]
    ACTIVECMPLRQRSLTUUID,           -- Active Compliance Assessment UUID [EHFND_CRR_ACTIVE_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]
    CHEMICALCUSTOMERMATERIALUUID,   -- Customer Material [EHFND_CCM_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]
    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]
    CMPLRQRSLTPRELIMCMPLNCSTS,      -- Preliminary Compliance Status [EHFND_CRR_PRELIM_COMP_STAT]
    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]
    PCESSCENARIOUUID,               -- Scenario UUID [EHFND_ES_SCENARIO_UUID]
    ACTIVEUUID,                     -- Key [/BOBF/UUID]
    HASACTIVEENTITY,                -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, CMPLRQRSLTUUID)
);

Learn More