1. SAP Tutorial
  2. FI Module

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

Here we would like to draw your attention to FPIA_FI_IDX 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_FI_IDX is a SAP standard transp table used for storing FI Index Table for Interest Calculation – Chorus related data in SAP. It comes under the package FPS_IOA.

SAP FPIA_FI_IDX table

Table FPIA_FI_IDX technical data

TableFPIA_FI_IDX
Data storingFI Index Table for Interest Calculation – Chorus
ModuleFI
Sub ModuleFI-LOC
SAP PackageFPS_IOA
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FPIA_FI_IDX 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_FI_IDX table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key for Financial document
    Its a key field.
  • BELNR : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BUZEI : Number of Line Item Within Accounting Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • INTEREST_GUID : Globally Unique Identifier
    Its data type is RAW (Byte string) with field length 16
  • INT_DOC_EXIST : Interest Document Exists
    Its data type is CHAR (Character String) with field length 1
  • .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
  • LINE_TYPE : Line type of FI-documents
    Its data type is CHAR (Character String) with field length 2
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4

    • FPIA_FI_IDX related tables

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

    FPIA_FI_IDX related transaction codes under SAP package FPS_IOA

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

    Related References

    Related Tutorials

    FPIA_FINTAP SAP tcode for – Item Interest Calculation Vendors

    FPIA_FINTAP tcode in SAP FI (Localization in FI) module. This transaction code is used for Item Interest Calculation Vendors. See...

    FPIA_INTEREST SAP table for – Table for Penalty Interest

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

    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...

    DFKKIAPT SAP table for – Interest Calculation: Log for Interest Run

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

    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_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...

    «
    »