1. SAP Tutorial
  2. FI Module

FPIA_INTEREST SAP table for – Table for Penalty Interest

Here we would like to draw your attention to FPIA_INTEREST table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). FPIA_INTEREST is a SAP standard transp table used for storing Table for Penalty Interest related data in SAP. It comes under the package FPS_IOA.

SAP FPIA_INTEREST table

Table FPIA_INTEREST technical data

TableFPIA_INTEREST
Data storingTable for Penalty Interest
ModuleFI
Sub ModuleFI-LOC
SAP PackageFPS_IOA
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FPIA_INTEREST Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FPIA_INTEREST table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INTEREST_GUID : Globally Unique Identifier
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Key for Incoming Invoice (MM)
  • BELNR : Document Number of an Invoice Document
    Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Changeable fields in FPIA _INTERERST
  • DELAY_BR : Suspension Days of Budget Responsible
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • REASON_BR : Suspension Reason of Budget Responsible
    Its data type is CHAR (Character String) with field length 2
  • DELAY_AC : Suspension Days of Accountant
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • REASON_AC : Suspension Reason of Accountant
    Its data type is CHAR (Character String) with field length 2
  • VZSKZ : Interest calculation indicator
    Its data type is CHAR (Character String) with field length 2
  • REC_DATE_BR : Date of Invoice Receipt by Budget Responsible
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REC_DATE_AC : Date of Invoice Receipt by Accountant
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Payment Terms
  • ZFBDT : Baseline date for due date calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZTERM : Terms of payment key
    Its data type is CHAR (Character String) with field length 4
  • ZBD1T : Cash discount days 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZBD1P : Cash discount percentage 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ZBD2T : Cash discount days 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZBD2P : Cash Discount Percentage 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ZBD3T : Net Payment Terms Period
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • INV_VALIDATION_B : Date of Invoice Validation by Budget Responsible
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INV_VALIDATION_A : Date of Invoice Validation by Accountant
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PAYMNT_COPIED : Payment Terms Copied
    Its data type is CHAR (Character String) with field length 1
  • ACC_DOC_EXIST : Accounting Document Exists
    Its data type is CHAR (Character String) with field length 1
  • CREATED_AT : Record Created At (Time Stamp)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CREATED_BY : Record Created By
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_AT : Record Changed At (Time Stamp)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CHANGED_BY : Record Last Changed By
    Its data type is CHAR (Character String) with field length 12

    • FPIA_INTEREST related tables

    • FPIA_REASONT : Interruption Reason Penalty Interest Description
    • FPIA_SET_VAL_C : Set Update of Validation Date
    • FPIA_FIELDSTAT_C : Field status control for IoA fields
    • FPIA_INTEREST : Table for Penalty Interest
    • FPIA_FI_IDX : FI Index Table for Interest Calculation – Chorus
    • FPIA_GROUP_S : User groups for IoA process (SAP)
    • FPIA_INT_VZSKZ : IOA: VZSKZ for Interest Documents
    • FPIA_INTCAL_IND : Assign Successive Interest Indicators
    • FPIA_GROUP_ST : Text table for user groups for IoA process (SAP)
    • FPIA_ACTIONST : Define Actions
    • FPIA_GROUP_C : User groups for IoA process (Customer)
    • FPIA_FIELDSTAT_S : Field status control for IoA fields (SAP)
    • FPIA_ACTIONS : Action Attributes
    • FPIA_IOA_ACTIV : IoA solution activation
    • FPIA_REASON : Interruption Reason Penalty Interest
    • FPIA_GROUP_CT : Text table for user groups for IoA process (SAP)

    FPIA_INTEREST related transaction codes under SAP package FPS_IOA

    • FPIA_SINGLE_03 : FPIA Single Transaction Display
    • FPIA_FINTAP : Item Interest Calculation Vendors
    • FPIA_INTSHOW : Overview of Int. Runs for Item. Int.
    • FPIA_KEPL00 : List of vendor line items
    • FPIA_MASS_UPD : Penalty Interest Mass Changes
    • FPIA_SINGLE_02 : FPIA Single Transaction Create/Chang

    Related References

    Related Tutorials

    FPIA_REASON SAP table for – Interruption Reason Penalty Interest

    FPIA_REASON table in SAP FI (Localization in FI) module. This table is used for storing data of Interruption Reason Penalty...

    FPIA_REASONT SAP table for – Interruption Reason Penalty Interest Description

    FPIA_REASONT table in SAP FI (Localization in FI) module. This table is used for storing data of Interruption Reason Penalty...

    FPIA_FI_IDX SAP table for – FI Index Table for Interest Calculation – Chorus

    FPIA_FI_IDX table in SAP FI (Localization in FI) module. This table is used for storing data of FI Index Table...

    FPIA_MASS_UPD SAP tcode for – Penalty Interest Mass Changes

    FPIA_MASS_UPD tcode in SAP FI (Localization in FI) module. This transaction code is used for Penalty Interest Mass Changes. See...

    FPIA_INT_VZSKZ SAP table for – IOA: VZSKZ for Interest Documents

    FPIA_INT_VZSKZ table in SAP FI (Localization in FI) module. This table is used for storing data of IOA: VZSKZ for...

    FPIA_INTCAL_IND SAP table for – Assign Successive Interest Indicators

    FPIA_INTCAL_IND table in SAP FI (Localization in FI) module. This table is used for storing data of Assign Successive Interest...

    T056I SAP table for – Time-dep.terms for interest calc.rule

    T056I table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    «
    »