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