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