INTITPF
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_APARInterestDocument | view | from | BASIC | Interest Run |
| P_InterestDocumentOMPrmDet | view | from | BASIC |
Fields (24)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
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