I_PUBSECINTRSTAPPRTMT

CDS View

PSM Interest Apportionment

I_PUBSECINTRSTAPPRTMT is a CDS View in S/4HANA. PSM Interest Apportionment. It contains 6 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_FundIntrstApprtmt view from COMPOSITE WUFUND Interest Apportionment Master
P_FundIntrstApprtmt view inner COMPOSITE WUFUND Interest Apportionment Master
P_GrantIntrstApprtmt view inner COMPOSITE WUGRANT Interest Apportionment Master
R_PubSecIntrstApprtmtTP view_entity from TRANSACTIONAL PSM Interest Apportionment

Fields (6)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY InvestmentPoolID InvestmentPoolID 2
KEY InvestmentPoolUUID InvestmentPoolUUID 2
InvestmentPoolIDChangedBy InvestmentPoolIDChangedBy 2
InvestmentPoolIDCreatedBy InvestmentPoolIDCreatedBy 2
UserName UserName 1

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.

-- PSM Interest Apportionment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PUBSECINTRSTAPPRTMT (
    COMPANYCODE,
    INVESTMENTPOOLID,
    INVESTMENTPOOLUUID,
    INVESTMENTPOOLIDCHANGEDBY,
    INVESTMENTPOOLIDCREATEDBY,
    USERNAME,
    PRIMARY KEY (COMPANYCODE, INVESTMENTPOOLID, INVESTMENTPOOLUUID)
);