INTITFX

Transparent Table Application Table
32 Fields 1 CDS Views

Fixed Interest Amounts per Invoice

INTITFX is an SAP database table in S/4HANA. Fixed Interest Amounts per Invoice. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_APARInterestItem view union BASIC Interest History Item

Fields (32)

KeyField Data ElementDescription DomainTypeLength
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_until DUZIBSZT Period Upper Limit
awsys LOGSYSTEM Logical System
awtyp AWTYP Ref. procedure
awkey AWKEY Reference Key
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
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
form_to INT_FORM Form Number
int_cpudt CPUDT Entered On
int_cputm CPUTM Entered at
int_usnam USNAM User Name
int_ind VZSKZ Interest Indic.
int_basamt INT_BASAMT Int. Base Amount
netdt NETDT Due On
int_fxdat INT_FXDAT Fixed Amt Date
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.

-- Fixed Interest Amounts per Invoice
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE INTITFX (
    MANDT,       -- Client [MANDT]
    BUKRS,       -- Company Code [BUKRS]
    BELNR,       -- Journal Entry [FARP_BELNR_D]
    GJAHR,       -- Fiscal Year [GJAHR]
    BUZEI,       -- Item [BUZEI]
    INT_UNTIL,   -- Period Upper Limit [DUZIBSZT]
    AWSYS,       -- Logical System [LOGSYSTEM]
    AWTYP,       -- Ref. procedure [AWTYP]
    AWKEY,       -- Reference Key [AWKEY]
    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]
    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]
    FORM_TO,     -- Form Number [INT_FORM]
    INT_CPUDT,   -- Entered On [CPUDT]
    INT_CPUTM,   -- Entered at [CPUTM]
    INT_USNAM,   -- User Name [USNAM]
    INT_IND,     -- Interest Indic. [VZSKZ]
    INT_BASAMT,  -- Int. Base Amount [INT_BASAMT]
    NETDT,       -- Due On [NETDT]
    INT_FXDAT,   -- Fixed Amt Date [INT_FXDAT]
    XBLNR,       -- Reference [XBLNR1]
    PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR, BUZEI, INT_UNTIL)
);

Learn More