FIAPPTD_TRANS SAP table for – Table to store the transaction details of the CBR PT

Here we would like to draw your attention to FIAPPTD_TRANS 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_TRANS is a SAP standard transp table used for storing Table to store the transaction details of the CBR PT related data in SAP. It comes under the package ID-FI-PT.

SAP FIAPPTD_TRANS table

Table FIAPPTD_TRANS technical data

TableFIAPPTD_TRANS
Data storingTable to store the transaction details of the CBR PT
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-FI-PT
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FIAPPTD_TRANS 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_TRANS 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
  • BELNR : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • DOC_YEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) 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
  • 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
  • PAY_DOC : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • PAY_DOC_YEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • ACCOUNT : Account Number
    Its data type is CHAR (Character String) with field length 10
  • KOART : Account type
    Its data type is CHAR (Character String) with field length 1
  • ORIGIN_RUN_ID : Run ID
    Its data type is CHAR (Character String) with field length 20
  • REPORTING_YEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • 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
  • NPC2 : Entity ID
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • WRBTR : Amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • SCB_IND : SCB Indicator
    Its data type is CHAR (Character String) with field length 5
  • 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