EHFNDD_PC_SRVREQ

Transparent Table Application Table
22 Fields 1 CDS Views

Service Request Database Table

EHFNDD_PC_SRVREQ is an SAP database table in S/4HANA. Service Request Database Table. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdCmplncServiceRequest view from BASIC Basic View for Product Compliance Service Requests

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prodcmplncservicerequestuuid PRODCMPLNCSERVICEREQUESTUUID Request ID
prodcmplncservicerequesttype PRODCMPLNCSERVICEREQUESTTYPE Service Request Type
prodcmplncservicerequestorigin PRODCMPLNCSERVICEREQUESTORIGIN Origin
prodcmplncservicerequeststatus PRODCMPLNCSERVICEREQUESTSTATUS Request Status
prodcmplncsrvcreqextstatus PRODCMPLNCSRVCREQEXTSTATUS Processing Status
prodcmplncsrvcreqfailurereason PRODCMPLNCSRVCREQFAILUREREASON Reason
createdbyuser PRODCMPLNCSRVCREQINITIATORUSER Initiated By
lastchangedatetime EHFND_BO_LCHG_DATE_TIME Last Changed On
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
chemicalcomplianceinfo EHFND_INTERNAL_NR Internal Number
substanceuuid EHFND_SUB_UUID Substance
companysubstance EHFND_INTERNAL_NR Internal Number
prodcmplncservicerequestnote PRODCMPLNCPRODUCTREQUESTNOTE Status Note
substanceinternalname EHFND_SUB_INTERNAL_SUBNAM Internal Name
casnumber EHFND_CHM_CAS_NO CAS Number
ecnumber EHFND_LISU_EC_NUMBER EC Number
prodcmplncproductorcompname PRODCMPLNCPRODUCTORCOMPNAME Product / Substance
physchmlprptyuuid EHFND_PHYSCHEM_UUID Physical-Chemical Property
chmlcompositionuuid EHFND_CCI_CCMPS_UUID Chemical Composition
pcsftyprptyuuid EHFND_SR_UUID Safety-Related Property
detailedloggingenabled EHFND_BOOLEAN Select

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.

-- Service Request Database Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_PC_SRVREQ (
    MANDT,                           -- Client [MANDT]
    PRODCMPLNCSERVICEREQUESTUUID,    -- Request ID [PRODCMPLNCSERVICEREQUESTUUID]
    PRODCMPLNCSERVICEREQUESTTYPE,    -- Service Request Type [PRODCMPLNCSERVICEREQUESTTYPE]
    PRODCMPLNCSERVICEREQUESTORIGIN,  -- Origin [PRODCMPLNCSERVICEREQUESTORIGIN]
    PRODCMPLNCSERVICEREQUESTSTATUS,  -- Request Status [PRODCMPLNCSERVICEREQUESTSTATUS]
    PRODCMPLNCSRVCREQEXTSTATUS,      -- Processing Status [PRODCMPLNCSRVCREQEXTSTATUS]
    PRODCMPLNCSRVCREQFAILUREREASON,  -- Reason [PRODCMPLNCSRVCREQFAILUREREASON]
    CREATEDBYUSER,                   -- Initiated By [PRODCMPLNCSRVCREQINITIATORUSER]
    LASTCHANGEDATETIME,              -- Last Changed On [EHFND_BO_LCHG_DATE_TIME]
    CHMLCMPLNCINFOUUID,              -- Chemical Compliance Information [EHFND_CCI_UUID]
    CHEMICALCOMPLIANCEINFO,          -- Internal Number [EHFND_INTERNAL_NR]
    SUBSTANCEUUID,                   -- Substance [EHFND_SUB_UUID]
    COMPANYSUBSTANCE,                -- Internal Number [EHFND_INTERNAL_NR]
    PRODCMPLNCSERVICEREQUESTNOTE,    -- Status Note [PRODCMPLNCPRODUCTREQUESTNOTE]
    SUBSTANCEINTERNALNAME,           -- Internal Name [EHFND_SUB_INTERNAL_SUBNAM]
    CASNUMBER,                       -- CAS Number [EHFND_CHM_CAS_NO]
    ECNUMBER,                        -- EC Number [EHFND_LISU_EC_NUMBER]
    PRODCMPLNCPRODUCTORCOMPNAME,     -- Product / Substance [PRODCMPLNCPRODUCTORCOMPNAME]
    PHYSCHMLPRPTYUUID,               -- Physical-Chemical Property [EHFND_PHYSCHEM_UUID]
    CHMLCOMPOSITIONUUID,             -- Chemical Composition [EHFND_CCI_CCMPS_UUID]
    PCSFTYPRPTYUUID,                 -- Safety-Related Property [EHFND_SR_UUID]
    DETAILEDLOGGINGENABLED,          -- Select [EHFND_BOOLEAN]
    PRIMARY KEY (MANDT, PRODCMPLNCSERVICEREQUESTUUID)
);

Learn More