INTITIT
Interest Calculation Details per Item
INTITIT is an SAP database table in S/4HANA. Interest Calculation Details per Item. It contains 34 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_APARInterestItem | view | from | BASIC | Interest History Item |
Fields (34)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | bukrs | BUKRS | Company Code | |||
| KEY | belnr | FARP_BELNR_D | Journal Entry | |||
| KEY | gjahr | GJAHR | Fiscal Year | |||
| KEY | buzei | BUZEI | Item | |||
| KEY | int_end | INT_END | Interest Calc. To | |||
| KEY | int_until | DUZIBSZT | Period Upper Limit | |||
| int_begin | INT_BEGIN | Interest Calc. From | ||||
| int_days | ANZTAGE | Days | ||||
| int_ind | VZSKZEX | Interest Indic. | ||||
| int_sign | BEWEGART | Trans.type | ||||
| int_rate | AZINSSATZ | Interest Rate | ||||
| 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 | ||||
| account | FARP_ACCOUNT_APAR | Account Number | ||||
| koart | KOART | Account type | ||||
| array | INT_GROUP | Grouping | ||||
| bukrs_to | BUKRS | Company Code | ||||
| belnr_to | INT_BELNR | Interest Document | ||||
| gjahr_to | INT_GJAHR | FYear of Int. Doc. | ||||
| buzei_to | INT_BUZEI | Interest Doc. LI | ||||
| account_to | INT_KTONR | Receiver Account No. | ||||
| koart_to | INT_KOART | Receiver Acct Type | ||||
| rspocredat | RSPOCREDAT | Created | ||||
| form_to | INT_FORM | Form Number | ||||
| int_basedays | INT_BASEDAYS | Base Days | ||||
| int_basamt | INT_BASAMT | Int. Base Amount | ||||
| xblnr | XBLNR1 | Reference |
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 Calculation Details per Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE INTITIT (
MANDT, -- Client [MANDT]
BUKRS, -- Company Code [BUKRS]
BELNR, -- Journal Entry [FARP_BELNR_D]
GJAHR, -- Fiscal Year [GJAHR]
BUZEI, -- Item [BUZEI]
INT_END, -- Interest Calc. To [INT_END]
INT_UNTIL, -- Period Upper Limit [DUZIBSZT]
INT_BEGIN, -- Interest Calc. From [INT_BEGIN]
INT_DAYS, -- Days [ANZTAGE]
INT_IND, -- Interest Indic. [VZSKZEX]
INT_SIGN, -- Trans.type [BEWEGART]
INT_RATE, -- Interest Rate [AZINSSATZ]
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]
ACCOUNT, -- Account Number [FARP_ACCOUNT_APAR]
KOART, -- Account type [KOART]
ARRAY, -- Grouping [INT_GROUP]
BUKRS_TO, -- Company Code [BUKRS]
BELNR_TO, -- Interest Document [INT_BELNR]
GJAHR_TO, -- FYear of Int. Doc. [INT_GJAHR]
BUZEI_TO, -- Interest Doc. LI [INT_BUZEI]
ACCOUNT_TO, -- Receiver Account No. [INT_KTONR]
KOART_TO, -- Receiver Acct Type [INT_KOART]
RSPOCREDAT, -- Created [RSPOCREDAT]
FORM_TO, -- Form Number [INT_FORM]
INT_BASEDAYS, -- Base Days [INT_BASEDAYS]
INT_BASAMT, -- Int. Base Amount [INT_BASAMT]
XBLNR, -- Reference [XBLNR1]
PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR, BUZEI, INT_END, INT_UNTIL)
);
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