SAP table J_1AINFMET (Inflation Methods)

SAP table J_1AINFMET has 3 primary key fields being MANDT,LAND1,J_1AINFMET.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
J_1AINFMET Inflation Method CHAR 4 0 J_1AINFME_
J_1AFIACT Inflation Accounting Active for Financial Accounting (FI) CHAR 1 0 J_1AFIACT
J_1ATBEAPP TBE Variant CHAR 2 0 J_1AINFT04 J_1ATBEDEP
J_1AIPMNG General Inflation Index CHAR 5 0 J_1AINFT20 J_1AIPMNGP
J_1ANOTRT No Adjustment Split CHAR 1 0 J_1ANOTRTP
J_1AIBLART Document Type for Adjustments to Items in Local Currency CHAR 2 0 T003 J_1AIBLARP
J_1AFWBLAT Document Type for Adjustments to Items in Foreign Currency CHAR 2 0 T003 J_1AFWBLAT
J_1ACBSCHL Credit Posting Key for Inflation Adjustment Documents CHAR 2 0 TBSL J_1ACBSCHP
J_1ADBSCHL Debit Posting Key for Inflation Adjustment Documents CHAR 2 0 TBSL J_1ADBSCHP
J_1AIMWSKZ Input Tax Code for Inflation Adjustment Documents CHAR 2 0 T007A J_1AIMWSKP
J_1AOMWSKZ Output Tax Code for Inflation Adjustment Documents CHAR 2 0 T007A J_1AOMWSKP
J_1APOSMET Posting Method for FI Inflation CHAR 1 0 J_1APOSMEP
1 Reverse provisional postings and post definitive values
2 Post only the difference between prov. and final values
J_1AAMACT Inflation Accounting Active for Asset Accounting (FI-AA) CHAR 1 0 J_1AAMACT
J_1AAAUCTF Settle Revaluation Amounts Proportionately CHAR 1 0 J_1AAAUCTF
J_1AABBWNC Transaction Type for Revaluation Amounts CHAR 3 0 TABW J_1AABBWNC
J_1AABBWND Transaction Type for Revaluation Amounts CHAR 3 0 TABW J_1AABBWND
J_1ATPODEP Posting Variant CHAR 2 0 J_1AINFT12 J_1ATPODEP
J_1ARVSTRT Last Revaluation Date in Legacy System DATS 8 0 J_1ARVSTRT
J_1AAKBWND Adjustment transaction type for Transfers/retirement CHAR 3 0 TABW J_1AAKBWND
J_1AAKBWNC Transaction type for adjustments of transfer/ retirements CHAR 3 0 TABW J_1AAKBWNC
J_1AMMACT Inflation Accounting Active for Materials Management (MM) CHAR 1 0 J_1AMMACT
J_1APORECO Post Replacement Cost Valuation (Price Change) CHAR 1 0 J_1APORECO
J_1AINDXF Fiscal Inflation Index CHAR 5 0 J_1AINFT20 J_1AINDXF
J_1ADELCST Delivery Costs in Market Price Determination CHAR 1 0 J_1ADELCST
0 do not include delivery cost
1 include delivery cost if included in invoice
2 include delivery cost if planned even if invoice not rcvd.
3 like 2 (incl. delivery costs for contracts and info rec.)
J_1ADELCTF Delivery Costs in Fiscal Valuation CHAR 1 0 J_1ADELCTF
J_1ATBFISC TBE Variant for Fiscal Inflation Index CHAR 2 0 J_1AINFT04 J_1ATBFISC
J_1AMANPR Manual Change of Replacement Cost Relevant CHAR 1 0 J_1AMANPR
J_1AMMCUTY Exchange Rate Type for Replacement Cost Valuation CHAR 4 0 TCURV J_1AMMCUTY
J_1APOINDX Indexing Active CHAR 1 0 J_1APOINDX
J_1AVLEVEL Valuation Level for Replacement Cost Valuation CHAR 1 0 J_1AVLEVEL
1 Valuation at valuation area level
2 Valuation at company code level
INDEXM Inflation Indexing Method CHAR 1 0 J_1AINDXM
Price-based indexing
1 Stock-based indexing
2 Stock-based indexing including goods issue revaluation
J_1AAXREVD Split Revaluation of Depreciation CHAR 1 0 J_1AAXREVD
J_1AAOTTYC Transaction Type for Revaluation Amounts CHAR 3 0 TABW J_1AAOTTYC
J_1AAOTTYD Transaction Type for Revaluation Amounts CHAR 3 0 TABW J_1AAOTTYD
J_1AA_RVEND Allow Revaluation After End of Useful Life CHAR 1 0 J_1AAM_RVEND_CONT
J_1AMMDAC Don't post to Materials Management (MM) CHAR 1 0 J_1AMMDAC
J_1AERTYPE Exchange Rate Type for G/L Account Evaluation CHAR 4 0 TCURV J_1AERTYPE
J_1ALEDGER Ledger Group CHAR 4 0 FAGL_TLDGRP J_1ALEDGER

J_1AINFMET foreign key relationships

Table Field Check Table Check Field
0 J_1AINFMET J_1AABBWNC TABW Asset transaction types MANDT
1 J_1AINFMET J_1AABBWND TABW Asset transaction types MANDT
0 J_1AINFMET J_1AAKBWNC TABW Asset transaction types MANDT
1 J_1AINFMET J_1AAKBWND TABW Asset transaction types MANDT
0 J_1AINFMET J_1AAOTTYC TABW Asset transaction types MANDT
1 J_1AINFMET J_1AAOTTYD TABW Asset transaction types MANDT
0 J_1AINFMET J_1ACBSCHL TBSL Posting Key MANDT
0 J_1AINFMET J_1ACBSCHL TBSL Posting Key BSCHL
1 J_1AINFMET J_1ADBSCHL TBSL Posting Key MANDT
1 J_1AINFMET J_1ADBSCHL TBSL Posting Key BSCHL
0 J_1AINFMET J_1AERTYPE TCURV Exchange rate types for currency translation MANDT
0 J_1AINFMET J_1AERTYPE TCURV Exchange rate types for currency translation KURST
1 J_1AINFMET J_1AFWBLAT T003 Document Types MANDT
0 J_1AINFMET J_1AIBLART T003 Document Types MANDT
1 J_1AINFMET J_1AIMWSKZ T007A Tax Keys KALSM
1 J_1AINFMET J_1AIMWSKZ T007A Tax Keys MWSKZ
0 J_1AINFMET J_1AINDXF J_1AINFT20 Inflation: Index Definition MANDT
1 J_1AINFMET J_1AIPMNG J_1AINFT20 Inflation: Index Definition MANDT
0 J_1AINFMET J_1ALEDGER FAGL_TLDGRP Ledger Group LDGRP
1 J_1AINFMET J_1AMMCUTY TCURV Exchange rate types for currency translation MANDT
1 J_1AINFMET J_1AMMCUTY TCURV Exchange rate types for currency translation KURST
0 J_1AINFMET J_1AOMWSKZ T007A Tax Keys KALSM
0 J_1AINFMET J_1AOMWSKZ T007A Tax Keys MWSKZ
1 J_1AINFMET J_1ATBEAPP J_1AINFT04 Time base definition MANDT
1 J_1AINFMET J_1ATBEAPP J_1AINFT04 Time base definition J_1ATBEDEP
0 J_1AINFMET J_1ATBFISC J_1AINFT04 Time base definition MANDT
0 J_1AINFMET J_1ATBFISC J_1AINFT04 Time base definition J_1ATBEDEP
1 J_1AINFMET J_1ATPODEP J_1AINFT12 Posting variant definition MANDT
1 J_1AINFMET J_1ATPODEP J_1AINFT12 Posting variant definition J_1ATPODEP
0 J_1AINFMET LAND1 T005 Countries MANDT
0 J_1AINFMET LAND1 T005 Countries LAND1
1 J_1AINFMET MANDT T000 Clients MANDT