INTITPF

Transparent Table Application Table

Interest Data per Form and Posting

INTITPF is an SAP database table in S/4HANA. Interest Data per Form and Posting. It contains 24 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_APARInterestDocument view from BASIC Interest Run
P_InterestDocumentOMPrmDet view from BASIC

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs_to BUKRS Company Code
KEY form_to INT_FORM Form Number
KEY gjahr_to INT_GJAHR FYear of Int. Doc.
account_to INT_KTONR Receiver Account No.
koart_to INT_KOART Receiver Acct Type
array INT_GROUP Grouping
int_curr WAERS Currency
int_amount INT_AMOUNT Interest Amount
int_shkzg SHKZG Debit/Credit
tax_amount FWSTE_SHB_X8 Tax with +/- Sign
tax_shkzg SHKZG Debit/Credit
int_cpudt CPUDT Entered On
int_cputm CPUTM Entered at
int_usnam USNAM User Name
belnr_to INT_BELNR Interest Document
rspocredat RSPOCREDAT Created
int_until DUZIBSZT Period Upper Limit
a_form TDSFNAME Form Name
a_formdt BUDAT Posting Date
a_nodens DUZIZIBR Int.Rate Change
a_addipr DUZIZISZ IR Table
a_forpdf FPWBFORMNAME Form
log_number BALOGNR Log Number

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.

-- Interest Data per Form and Posting
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE INTITPF (
    MANDT,       -- Client [MANDT]
    BUKRS_TO,    -- Company Code [BUKRS]
    FORM_TO,     -- Form Number [INT_FORM]
    GJAHR_TO,    -- FYear of Int. Doc. [INT_GJAHR]
    ACCOUNT_TO,  -- Receiver Account No. [INT_KTONR]
    KOART_TO,    -- Receiver Acct Type [INT_KOART]
    ARRAY,       -- Grouping [INT_GROUP]
    INT_CURR,    -- Currency [WAERS]
    INT_AMOUNT,  -- Interest Amount [INT_AMOUNT]
    INT_SHKZG,   -- Debit/Credit [SHKZG]
    TAX_AMOUNT,  -- Tax with +/- Sign [FWSTE_SHB_X8]
    TAX_SHKZG,   -- Debit/Credit [SHKZG]
    INT_CPUDT,   -- Entered On [CPUDT]
    INT_CPUTM,   -- Entered at [CPUTM]
    INT_USNAM,   -- User Name [USNAM]
    BELNR_TO,    -- Interest Document [INT_BELNR]
    RSPOCREDAT,  -- Created [RSPOCREDAT]
    INT_UNTIL,   -- Period Upper Limit [DUZIBSZT]
    A_FORM,      -- Form Name [TDSFNAME]
    A_FORMDT,    -- Posting Date [BUDAT]
    A_NODENS,    -- Int.Rate Change [DUZIZIBR]
    A_ADDIPR,    -- IR Table [DUZIZISZ]
    A_FORPDF,    -- Form [FPWBFORMNAME]
    LOG_NUMBER,  -- Log Number [BALOGNR]
    PRIMARY KEY (MANDT, BUKRS_TO, FORM_TO, GJAHR_TO)
);