EHPMAD_SVT_AGIBP

Transparent Table Application Table
19 Fields 1 CDS Views

Red Layerd - Item by Business Process

EHPMAD_SVT_AGIBP is an SAP database table in S/4HANA. Red Layerd - Item by Business Process. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SVTAggrgnItmByBusProcess view from BASIC Aggregated SVT Item by Business Process

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY svtaggrgnitmbybusprocuuid ehpma_svt_aggrgn_item_bp_uuid Aggr BP uuid
lastchangeutcdatetime abp_lastchange_tstmpl Changed On
lastchangedatetime ehpma_svt_last_change_datetime Ch. Date Time
svtbusinessprocess ehpma_svt_bsns_prcs Business Process
svtbusinessprocessscenario ehfnd_bp_scenario Scenario
subperiodtrackingstartdate ehpma_svt_subperiod_start_date Tracking Start Date
subperiodtrackingenddate ehpma_svt_subperiod_end_date Tracking End Date
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
chmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
svtaggregationitemuuid ehpma_svt_aggrgn_item_uuid Aggr item uuid
svtaggregationheaderuuid ehpma_svt_aggregation_hdr_uuid Agg header doc uuid
plant ehfnd_plant_id Plant ID
material matnr Material
polymercompositionintid ehfnd_sub_pcmps_int_id Internal Number
parentpolymersubstanceuuid ehfnd_sub_uuid Substance

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.

-- Red Layerd - Item by Business Process
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHPMAD_SVT_AGIBP (
    CLIENT,                        -- Client [mandt]
    SVTAGGRGNITMBYBUSPROCUUID,     -- Aggr BP uuid [ehpma_svt_aggrgn_item_bp_uuid]
    LASTCHANGEUTCDATETIME,         -- Changed On [abp_lastchange_tstmpl]
    LASTCHANGEDATETIME,            -- Ch. Date Time [ehpma_svt_last_change_datetime]
    SVTBUSINESSPROCESS,            -- Business Process [ehpma_svt_bsns_prcs]
    SVTBUSINESSPROCESSSCENARIO,    -- Scenario [ehfnd_bp_scenario]
    SUBPERIODTRACKINGSTARTDATE,    -- Tracking Start Date [ehpma_svt_subperiod_start_date]
    SUBPERIODTRACKINGENDDATE,      -- Tracking End Date [ehpma_svt_subperiod_end_date]
    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]
    CHMLCMPLNCINFOUUID,            -- Chemical Compliance Information [ehfnd_cci_uuid]
    SVTAGGREGATIONITEMUUID,        -- Aggr item uuid [ehpma_svt_aggrgn_item_uuid]
    SVTAGGREGATIONHEADERUUID,      -- Agg header doc uuid [ehpma_svt_aggregation_hdr_uuid]
    PLANT,                         -- Plant ID [ehfnd_plant_id]
    MATERIAL,                      -- Material [matnr]
    POLYMERCOMPOSITIONINTID,       -- Internal Number [ehfnd_sub_pcmps_int_id]
    PARENTPOLYMERSUBSTANCEUUID,    -- Substance [ehfnd_sub_uuid]
    PRIMARY KEY (CLIENT, SVTAGGRGNITMBYBUSPROCUUID)
);

Learn More