1. SAP Tutorial
  2. FI Module

FIOTPOI SAP table for – One-Time Postings: Items

Here we would like to draw your attention to FIOTPOI table in SAP. As we know it is being mainly used with the SAP FI-LA (Lease Accounting in FI) component which is coming under FI module (Financial Accounting). FIOTPOI is a SAP standard transp table used for storing One-Time Postings: Items related data in SAP. It comes under the package FI_OTP.

SAP FIOTPOI table

Table FIOTPOI technical data

TableFIOTPOI
Data storingOne-Time Postings: Items
ModuleFI
Sub ModuleFI-LA
SAP PackageFI_OTP
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP FIOTPOI 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 FIOTPOI table.

  • .INCLUDE : Key: One-Time Postings
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • COMP : Accrual Engine Application Component
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • OBJID : Object Number
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • SUBID : Subobject Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • TMSTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • DOCNO : Document Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • ACCRULE : Accounting Principle
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • DOCGROUP : Document Group Characteristic
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • ACCASSGMT : Account Determination Rule
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • AMOUNT : Amount
    Its data type is CURR (Currency Field) with field length 15
  • ITEM_TXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • ALLOC_NMBR : Assignment number
    Its data type is CHAR (Character String) with field length 18
  • OBJ_TYPE : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • OBJ_KEY : Object key
    Its data type is CHAR (Character String) with field length 20
  • OBJ_SYS : Logical system of source document
    Its data type is CHAR (Character String) with field length 10

    • FIOTPOI related tables

    • TFIOTP_002T : Document Group Characteristic Name
    • TFIOTP_003 : Posting Key for Document Grouping Characteristic
    • FIOTPOI : One-Time Postings: Items
    • TFIOTP_001T : Document Group Characteristic Name
    • FIOTPOH : One-Time Postings: Header
    • TFIOTP_002 : Account Determination Rule
    • TFIOTP_001 : Document Group Characteristic

    FIOTPOI related transaction codes under SAP package FI_OTP

    • FIOTP_NRIV : One-Time PostingsNumber Range Maint.
    • 0FIOTP003_1 : Posting Control for One-Off Postings
    • S_XB7_96000167 : IMG
    • S_XB7_96000052 : IMG
    • S_XB7_96000057 : IMG
    • S_PLN_16000127 : Call Customizing with Transaction
    • S_XB7_96000056 : IMG
    • FIOTPKOFIMAINTAIN : Maintain Derivation Rule Entries
    • S_XB7_96000274 : IMG Activity: 0FIOTP_DOC_ADJUST

    Related References

    Related Tutorials

    FIOTPOH SAP table for – One-Time Postings: Header

    FIOTPOH table in SAP FI (Lease Accounting in FI) module. This table is used for storing data of One-Time Postings:...

    0FIOTP003_1 SAP tcode for – Posting Control for One-Off Postings

    0FIOTP003_1 tcode in SAP FI (Lease Accounting in FI) module. This transaction code is used for Posting Control for One-Off...

    TFILA_GF_005 SAP table for – Specifications for One-Time Postings per Value ID

    TFILA_GF_005 table in SAP FI (Lease Accounting in FI) module. This table is used for storing data of Specifications for...

    VIXCFRSRULOG SAP table for – Log of SRU Postings

    VIXCFRSRULOG table in SAP FI (Localization in FI) module. This table is used for storing data of Log of SRU...

    FAGL_EMP_PROCESS SAP table for – Document Splitting: Process Adjustment for HR Postings

    FAGL_EMP_PROCESS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Document...

    FAGL_MIG_REV_DOC SAP table for – Documents from Inverse Postings During the Migration

    FAGL_MIG_REV_DOC table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Documents...

    TFILA_GF_004CF SAP table for – Assignment of Payment Schedule for Accrual Postings

    TFILA_GF_004CF table in SAP FI (Lease Accounting in FI) module. This table is used for storing data of Assignment of...

    «
    »