FPIA_INTEREST SAP (Table for Penalty Interest) Table details
Dictionary Type: Table
Description: Table for Penalty Interest
Description: Table for Penalty Interest
ABAP Code to SELECT data from FPIA_INTEREST
Related tables to FPIA_INTEREST
Access table FPIA_INTEREST
Related tables to FPIA_INTEREST
Access table FPIA_INTEREST
Table field list including key, data, relationships and ABAP select examples
FPIA_INTEREST is a standard SAP Table which is used to store Table for Penalty Interest data and is available within R/3 SAP systems depending on the version and release level.
The FPIA_INTEREST table consists of various fields, each holding specific information or linking keys about Table for Penalty Interest data available in SAP. These include INTEREST_GUID (Globally Unique Identifier), BELNR (Document Number of an Invoice Document), GJAHR (Fiscal Year), GSBER (Business Area).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FPIA_INTEREST table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| CLIENT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| INTEREST_GUID | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID | ||||
| BELNR | Document Number of an Invoice Document | RE_BELNR | CHAR | 10 | ALPHA | BELNR | RBN | ||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
| DELAY_BR | Suspension Days of Budget Responsible | FPIA_DELAY_BR | DEC | 4 | |||||
| REASON_BR | Suspension Reason of Budget Responsible | FPIA_REASON_BR | CHAR | 2 | FPIA_REASON | FPIA_REASON | |||
| DELAY_AC | Suspension Days of Accountant | FPIA_DELAY_AC | DEC | 4 | |||||
| REASON_AC | Suspension Reason of Accountant | FPIA_REASON_AC | CHAR | 2 | FPIA_REASON | FPIA_REASON | |||
| VZSKZ | Interest calculation indicator | PS_VZSKZ | CHAR | 2 | T056 | VZSKZ | |||
| REC_DATE_BR | Date of Invoice Receipt by Budget Responsible | FPIA_REC_DATE_BR | DATS | 8 | |||||
| REC_DATE_AC | Date of Invoice Receipt by Accountant | FPIA_REC_DATE_AC | DATS | 8 | |||||
| ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
| ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
| ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
| ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
| ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
| ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
| INV_VALIDATION_B | Date of Invoice Validation by Budget Responsible | FPIA_INV_VALIDATION_BR | DATS | 8 | |||||
| INV_VALIDATION_A | Date of Invoice Validation by Accountant | FPIA_INV_VALIDATION_AC | DATS | 8 | |||||
| PAYMNT_COPIED | Payment Terms Copied | FPIA_PAYMNT_COPIED | CHAR | 1 | BOOLE | ||||
| ACC_DOC_EXIST | Accounting Document Exists | FPIA_ACC_DOC_EXIST | CHAR | 1 | BOOLE | ||||
| CREATED_AT | Record Created At (Time Stamp) | FPIA_CREATED_AT | DEC | 15 | TZNTSTMPS | ||||
| CREATED_BY | Record Created By | FPIA_CREATED_BY | CHAR | 12 | UNAME | ||||
| CHANGED_AT | Record Changed At (Time Stamp) | FPIA_CHANGED_AT | DEC | 15 | TZNTSTMPS | ||||
| CHANGED_BY | Record Last Changed By | FPIA_CHANGED_BY | CHAR | 12 | UNAME |
| Key field | Non-key field |
How do I retrieve data from SAP table FPIA_INTEREST using ABAP code
The following ABAP code Example will allow you to do a basic selection on FPIA_INTEREST to SELECT all data from the tableDATA: WA_FPIA_INTEREST TYPE FPIA_INTEREST.
SELECT SINGLE *
FROM FPIA_INTEREST
INTO CORRESPONDING FIELDS OF WA_FPIA_INTEREST
WHERE...
How to access SAP table FPIA_INTEREST
Within an ECC or HANA version of SAP you can also view further information about FPIA_INTEREST and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects