PPMGAG_T_IRATES
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_PrepaymentAgrmtIntrstRates | view | from | EXTENSION | Extension View for Interest Rates |
| I_PrepaymentAgrmtIntrstRates | view | from | BASIC | Prepayment Agrmt Intrst Rates IF View |
Fields (18)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA