EHFNDV_SUB

7 Fields 2 CDS Views

EHFNDV_SUB is an SAP database table in S/4HANA. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_Substance view from BASIC Substance
I_SubstanceActiveDraft view from BASIC Active and draft substances

Fields (7)

KeyField CDS FieldsUsed in Views
KEY substanceuuid SubstanceUUID 1
listedsubstanceuuid ListedSubstanceUUID 1
polymerisbsdonoecddef PolymerIsBsdOnOECDDef 1
responsibleunit ProdStewardshipRespUnit,ResponsibleUnit 2
specification Specification 1
specificationinternalid SpecificationInternalID 1
substanceinternalname SubstanceInternalName 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDV_SUB (
    SUBSTANCEUUID,
    LISTEDSUBSTANCEUUID,
    POLYMERISBSDONOECDDEF,
    RESPONSIBLEUNIT,
    SPECIFICATION,
    SPECIFICATIONINTERNALID,
    SUBSTANCEINTERNALNAME,
    PRIMARY KEY (SUBSTANCEUUID)
);

Learn More