FIAPPTD_BALANCE SAP table for – Table to store the Balances for Vendor/Customer/Bank Account

Here we would like to draw your attention to FIAPPTD_BALANCE 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). FIAPPTD_BALANCE is a SAP standard transp table used for storing Table to store the Balances for Vendor/Customer/Bank Account related data in SAP. It comes under the package ID-FI-PT.

SAP FIAPPTD_BALANCE table

Table FIAPPTD_BALANCE technical data

TableFIAPPTD_BALANCE
Data storingTable to store the Balances for Vendor/Customer/Bank Account
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-FI-PT
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • REPORTING_YEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • PERIOD : Month
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • RUN_ID : Run ID
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • ACCOUNT : Account Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • KOART : Account type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • WAERS : Currency Key
    Its a key field. Its data type is CUKY (Currency key for a currency field) with field length 5
  • WRBTR : Amount
    Its data type is CURR (Currency Field) with field length 24
  • ORIGIN_RUN_ID : Run ID
    Its data type is CHAR (Character String) with field length 20
  • REFERENCE_DATE : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REGISTER_ID : ID of the Register
    Its data type is CHAR (Character String) with field length 1
  • SCB_IND : SCB Indicator
    Its data type is CHAR (Character String) with field length 5
  • NPC2 : Entity ID
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • VALUE_TYPE : CBR Value Type
    Its data type is CHAR (Character String) with field length 1
  • BANK_ACC_TYPE : Bank Account Type
    Its data type is CHAR (Character String) with field length 1
  • BANK_ID : Bank ID
    Its data type is CHAR (Character String) with field length 4
  • PAIS_CONTA : Foreign Account Country
    Its data type is CHAR (Character String) with field length 3
  • PAIS_CONTRAPARTE : Customer/Vendor Country
    Its data type is CHAR (Character String) with field length 3
  • PAIS_ATIVO : Financial Active Entity
    Its data type is CHAR (Character String) with field length 3
  • DUE_DATE : Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • STCEG : Counterpart ID or VAT Registration Number
    Its data type is CHAR (Character String) with field length 20
  • OBSERVATIONS : Observations
    Its data type is CHAR (Character String) with field length 120
  • ISOCD : ISO currency code
    Its data type is CHAR (Character String) with field length 3