1. SAP Tutorial
  2. FI Module

IDFIAA_JP_RESULT SAP table for – Results of Property Tax Report (Japan)

Here we would like to draw your attention to IDFIAA_JP_RESULT table in SAP. As we know it is being mainly used with the SAP FI-AA (Asset Accounting in FI) component which is coming under FI module (Financial Accounting). IDFIAA_JP_RESULT is a SAP standard transp table used for storing Results of Property Tax Report (Japan) related data in SAP. It comes under the package ID-FIAA-JP.

SAP IDFIAA_JP_RESULT table

Table IDFIAA_JP_RESULT technical data

TableIDFIAA_JP_RESULT
Data storingResults of Property Tax Report (Japan)
ModuleFI
Sub ModuleFI-AA-SVA-NT
SAP PackageID-FIAA-JP
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : ANLA Key Without Client
    Its a key field.
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • ANLN1 : Main Asset Number
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • ANLN2 : Asset Subnumber
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • NUMC_DECL_YEAR : Tax Declaration Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • CHAR1_RUN_TYPE : Run Type Indicator (Prov, Final, Budget)
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • NUMC14_LOG_SEC : Data Saved At
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 14
  • NUMC14_STORE_SEC : Record Number
    Its data type is NUMC (Character String with Digits Only) with field length 14
  • .INCLUDE : Structure of Asset Master Data – Japanese Tax Report
  • VMGLI : Property classification key
    Its data type is CHAR (Character String) with field length 4
  • GDLGRP : Evaluation group 5
    Its data type is CHAR (Character String) with field length 8
  • CHAR40_ASST_TXT : Asset Description
    Its data type is CHAR (Character String) with field length 40
  • MENGE : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • RET_MENGE : Retirement: Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • AKTIV : Asset capitalization date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • GRUND : Reason for manual valuation of net assets
    Its data type is CHAR (Character String) with field length 3
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • NDJAR : Planned useful life in years
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • AFABG : Depreciation calculation start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XAFABCH : Asset acquired used
    Its data type is CHAR (Character String) with field length 1
  • ZUGDT : Asset value date of the first posting
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • KTOGR : Account determination
    Its data type is CHAR (Character String) with field length 8
  • AFASL : Depreciation key
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Additional Data From BADI
  • DEC_ADD_RATE : Additional Depreciation Rate (Prov., Final, Budgeting)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 16
  • DEC_SP_RATE : Special Rule – Depreciation Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 16
  • CHAR5_SP_FRACTN : Special Rule Fraction
    Its data type is CHAR (Character String) with field length 5
  • CHAR10_SP_CODE : Special Rule
    Its data type is CHAR (Character String) with field length 10
  • CHAR30_SP_TEXT : Special Rule Text
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Data from T097JP
  • PROZ_TW : FI-AA: % rate for Japan net asset valuation (book value)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • PROZ_BW : FI-AA: % rate for val. of net assets Japan (theor.value 1yr)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • .INCLUDE : Previous Year Data from Output Table
  • CURR_APC_LY : Last Year’s Total Acquisition and Production Costs
    Its data type is CURR (Currency Field) with field length 16
  • CURR_TAX_BVL_LY : Last Year’s Tax Book Value
    Its data type is CURR (Currency Field) with field length 16
  • CURR_TAX_EVA_LY : Last Year’s Tax Evaluation Amount
    Its data type is CURR (Currency Field) with field length 16
  • .INCLUDE : Values Calculated by Report
  • CURR_APC_TOTAL : Total APC at End of Tax Declaration Period
    Its data type is CURR (Currency Field) with field length 16
  • CURR_APC_INCR : Increase in APC in Tax Declaration Period
    Its data type is CURR (Currency Field) with field length 16
  • CURR_APC_DECR : Decrease in APC in Tax Declaration Period
    Its data type is CURR (Currency Field) with field length 16
  • CURR_TAX_BVL : Tax Book Value
    Its data type is CURR (Currency Field) with field length 16
  • CURR_TAX_EVA : Tax Evaluation Amount
    Its data type is CURR (Currency Field) with field length 16
  • CURR_TAXB_AMNT : Taxable Amount
    Its data type is CURR (Currency Field) with field length 16
  • CURR_DCD_VALUE : Decided Value
    Its data type is CURR (Currency Field) with field length 16
  • CURR_TAX_PAYABLE : Tax Payable
    Its data type is CURR (Currency Field) with field length 16
  • CURR_D_PROV_FIN : Change in Taxable Value
    Its data type is CURR (Currency Field) with field length 16
  • CHAR1_LIST_STAT : Indicator for Status of Output List
    Its data type is CHAR (Character String) with field length 1
  • CHAR1_RET_CLASS : Indicator for Retirement Class
    Its data type is CHAR (Character String) with field length 1
  • CHAR1_RSN_CODE : Reason Code
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • IDFIAA_JP_RESULT related tables

    • IDFIAA_JP_TAX2 : Japanese Tax Report – Transaction Types Intra-City Transfer
    • IDFIAA_JP_RESULT : Results of Property Tax Report (Japan)
    • IDFIAA_JP_COND1 : Selection Criteria for Stored Reports
    • IDFIAA_JP_TAX1 : Japanese Tax Report – Areas and Transaction Types

    IDFIAA_JP_RESULT related transaction codes under SAP package ID-FIAA-JP

    • S_ALN_01001767 : Property Tax Report (Japan)

    Related References

    Related Tutorials

    S_ALN_01001767 SAP tcode for – Property Tax Report (Japan)

    S_ALN_01001767 tcode in SAP FI (Asset Accounting in FI) module. This transaction code is used for Property Tax Report (Japan)....

    /KJRTAX01/A05 SAP table for – Property Tax Report: Declaration Key

    /KJRTAX01/A05 table in SAP FI (Localization in FI) module. This table is used for storing data of Property Tax Report:...

    /KJRTAX01/A03 SAP table for – Property Tax Report: Tax Office Code

    /KJRTAX01/A03 table in SAP FI (Localization in FI) module. This table is used for storing data of Property Tax Report:...

    J_3R_PTAX_ABROAD SAP table for – Tax Paid Abroad Property tax

    J_3R_PTAX_ABROAD table in SAP FI (Localization in FI) module. This table is used for storing data of Tax Paid Abroad...

    IDFIAA_JP_TAX1 SAP table for – Japanese Tax Report – Areas and Transaction Types

    IDFIAA_JP_TAX1 table in SAP FI (Asset Accounting in FI) module. This table is used for storing data of Japanese Tax...

    DFKKREV07 SAP table for – Report on Tax on Sales/Purchases (clearing time)

    DFKKREV07 table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    /KJRTAX01/A06 SAP table for – Property Tax Report: Assign Decl.Key to C.Code and City Code

    /KJRTAX01/A06 table in SAP FI (Localization in FI) module. This table is used for storing data of Property Tax Report:...

    «
    »