PPMGAG_T_IRATES

Transparent Table Application Table

Prepayment Agreement Interest Rates

PPMGAG_T_IRATES is an SAP database table in S/4HANA. Prepayment Agreement Interest Rates. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_PrepaymentAgrmtIntrstRates view from EXTENSION Extension View for Interest Rates
I_PrepaymentAgrmtIntrstRates view from BASIC Prepayment Agrmt Intrst Rates IF View

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY prepaymentinterestrateuuid /bobf/uuid Key
prepaymentagreementuuid /bobf/uuid Key
prepaymentintrstvalidfromdate ppmgag_e_intratevalidfrom Int Rate Valid From
prepaymentintrstvalidtodate ppmgag_e_intratevalidto Int Rate Valid To
prepaymentintrstcalclogic ppmgag_e_cal_method_id Calculation Method
prepaymentintrstfxdrate ppmgag_e_intrst_fxdrate Fixed Interest
prepaymentnetintrstrate ppmgag_e_net_intrstrate Net Interest Rate
prepaymentintrstfltgratetype referenz Ref.int.rate
ppmgac_sur_dummy cfd_dummy Dummy
ppmgac_bp_dummy cfd_dummy Dummy

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.

-- Prepayment Agreement Interest Rates
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPMGAG_T_IRATES (
    MANDT,                          -- Client [mandt]
    PREPAYMENTINTERESTRATEUUID,     -- Key [/bobf/uuid]
    PREPAYMENTAGREEMENTUUID,        -- Key [/bobf/uuid]
    PREPAYMENTINTRSTVALIDFROMDATE,  -- Int Rate Valid From [ppmgag_e_intratevalidfrom]
    PREPAYMENTINTRSTVALIDTODATE,    -- Int Rate Valid To [ppmgag_e_intratevalidto]
    PREPAYMENTINTRSTCALCLOGIC,      -- Calculation Method [ppmgag_e_cal_method_id]
    PREPAYMENTINTRSTFXDRATE,        -- Fixed Interest [ppmgag_e_intrst_fxdrate]
    PREPAYMENTNETINTRSTRATE,        -- Net Interest Rate [ppmgag_e_net_intrstrate]
    PREPAYMENTINTRSTFLTGRATETYPE,   -- Ref.int.rate [referenz]
    PPMGAC_SUR_DUMMY,               -- Dummy [cfd_dummy]
    PPMGAC_BP_DUMMY,                -- Dummy [cfd_dummy]
    PRIMARY KEY (MANDT, PREPAYMENTINTERESTRATEUUID)
);