EHPMAD_SVT_AGITM

Transparent Table Application Table
18 Fields 1 CDS Views

Item Documentation for Aggregation Layer

EHPMAD_SVT_AGITM is an SAP database table in S/4HANA. Item Documentation for Aggregation Layer. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SVTAggregationItem view from BASIC Aggregated SVT Item

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY svtaggregationitemuuid EHPMA_SVT_AGGRGN_ITEM_UUID Aggr item uuid
lastchangedatetime EHPMA_SVT_LAST_CHANGE_DATETIME Ch. Date Time
legalentity EHPMA_SVT_LEGAL_ENTITY Legal Entity
cmplncrqmtsubstregnnumber EHPMA_SVT_REGISTRATION_NUMBER Registration Number
cmplncrqmtsubstregntype EHPMA_SVT_REGISTRATION_TYPE Registration Type
substancelist EHFND_REQ_REGLIST_ID Internal List ID
totalsubstancevolume EHPMA_SVT_TOTAL_SUBST_VOL Total Subst Vol
totalsubstancevolumeunit EHPMA_SVT_TOTAL_SUBST_VOL_UNIT Subst Volume Unit
plannedsubstancevolume EHPMA_SVT_PLND_SUBST_VOL Planned Subst Vol
plannedsubstancevolumeunit EHPMA_SVT_PLND_SUBST_VOL_UNIT Subst Vol Unit
confirmedsubstancevolume EHPMA_SVT_CONFD_SUBST_VOL Conf subst vol
confirmedsubstancevolumeunit EHPMA_SVT_CONFD_SUBST_VOL_UNIT Conf subst vol unit
substancevolumethreshold EHPMA_SVT_SUBST_VOL_THLD Subst Vol Threshold
substancevolumethresholdunit EHPMA_SVT_SUBST_VOL_THLD_UNIT Subst Vol Thld Unit
lglentitysubstvolthldreachpct EHPMA_SVT_SUB_VOL_THLD_PRCNTG Percent of Threshold
legalentitysvtstatus EHPMA_SVT_LEGAL_ENTITY_STATUS Legal Entity Status
svtaggregationheaderuuid EHPMA_SVT_AGGREGATION_HDR_UUID Agg header doc uuid

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.

-- Item Documentation for Aggregation Layer
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHPMAD_SVT_AGITM (
    CLIENT,                         -- Client [MANDT]
    SVTAGGREGATIONITEMUUID,         -- Aggr item uuid [EHPMA_SVT_AGGRGN_ITEM_UUID]
    LASTCHANGEDATETIME,             -- Ch. Date Time [EHPMA_SVT_LAST_CHANGE_DATETIME]
    LEGALENTITY,                    -- Legal Entity [EHPMA_SVT_LEGAL_ENTITY]
    CMPLNCRQMTSUBSTREGNNUMBER,      -- Registration Number [EHPMA_SVT_REGISTRATION_NUMBER]
    CMPLNCRQMTSUBSTREGNTYPE,        -- Registration Type [EHPMA_SVT_REGISTRATION_TYPE]
    SUBSTANCELIST,                  -- Internal List ID [EHFND_REQ_REGLIST_ID]
    TOTALSUBSTANCEVOLUME,           -- Total Subst Vol [EHPMA_SVT_TOTAL_SUBST_VOL]
    TOTALSUBSTANCEVOLUMEUNIT,       -- Subst Volume Unit [EHPMA_SVT_TOTAL_SUBST_VOL_UNIT]
    PLANNEDSUBSTANCEVOLUME,         -- Planned Subst Vol [EHPMA_SVT_PLND_SUBST_VOL]
    PLANNEDSUBSTANCEVOLUMEUNIT,     -- Subst Vol Unit [EHPMA_SVT_PLND_SUBST_VOL_UNIT]
    CONFIRMEDSUBSTANCEVOLUME,       -- Conf subst vol [EHPMA_SVT_CONFD_SUBST_VOL]
    CONFIRMEDSUBSTANCEVOLUMEUNIT,   -- Conf subst vol unit [EHPMA_SVT_CONFD_SUBST_VOL_UNIT]
    SUBSTANCEVOLUMETHRESHOLD,       -- Subst Vol Threshold [EHPMA_SVT_SUBST_VOL_THLD]
    SUBSTANCEVOLUMETHRESHOLDUNIT,   -- Subst Vol Thld Unit [EHPMA_SVT_SUBST_VOL_THLD_UNIT]
    LGLENTITYSUBSTVOLTHLDREACHPCT,  -- Percent of Threshold [EHPMA_SVT_SUB_VOL_THLD_PRCNTG]
    LEGALENTITYSVTSTATUS,           -- Legal Entity Status [EHPMA_SVT_LEGAL_ENTITY_STATUS]
    SVTAGGREGATIONHEADERUUID,       -- Agg header doc uuid [EHPMA_SVT_AGGREGATION_HDR_UUID]
    PRIMARY KEY (CLIENT, SVTAGGREGATIONITEMUUID)
);

Learn More