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 18 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 (18)

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_ir_dummy CFD_DUMMY Dummy
ppmgag_dummy CFD_DUMMY Dummy
createdbyuser PPMGAG_E_CREATEDBYUSER Created By
creationdatetime PPMGAG_E_CREATIONDATETIME Rec. Crtn Timestamp
lastchangedbyuser PPMGAG_E_LASTCHANGEDBYUSER Last Changed By
lastchangedatetime PPMGAG_E_LASTCHANGEDATETIME Last Changed On
ppmgac_sur_dummy CFD_DUMMY Dummy
ppmgac_bp_dummy CFD_DUMMY Dummy
ppmgag_irates_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_IR_DUMMY,                -- Dummy [CFD_DUMMY]
    PPMGAG_DUMMY,                   -- Dummy [CFD_DUMMY]
    CREATEDBYUSER,                  -- Created By [PPMGAG_E_CREATEDBYUSER]
    CREATIONDATETIME,               -- Rec. Crtn Timestamp [PPMGAG_E_CREATIONDATETIME]
    LASTCHANGEDBYUSER,              -- Last Changed By [PPMGAG_E_LASTCHANGEDBYUSER]
    LASTCHANGEDATETIME,             -- Last Changed On [PPMGAG_E_LASTCHANGEDATETIME]
    PPMGAC_SUR_DUMMY,               -- Dummy [CFD_DUMMY]
    PPMGAC_BP_DUMMY,                -- Dummy [CFD_DUMMY]
    PPMGAG_IRATES_DUMMY,            -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PREPAYMENTINTERESTRATEUUID)
);