P_AssetBalanceLineItem

P_AssetBalanceLineItem | view: PASSTBALINEITMS | Extraction: Not supported | Component: Master Data
Tables used: FAAT_DOC_IT, ACDOCA, T093, T001, TKA02, FINSC_LEDGER, FINS_TECH_LEDGER, FAAT_CMP, T093C, T093C, TACC_PRINCIPLE, TACC_TRGT_LDGR, FINSC_ACTVE_APPL, FINSC_LD_CMP, FAGL_TLDGRP_MAP
Column Name Description
AssetDepreciationArea FK Asset Depreciation Area (Real or Derived)
CompanyCode FK Company Code
FiscalYear Fiscal Year
MasterFixedAsset FK Fixed Asset
FixedAsset FK Asset Subnumber
Ledger FK Ledger in General Ledger Accounting
FiscalPeriod Fiscal Period
SubLedgerAcctLineItemType FK Subledger-Specific Line Item Type
AssetAcctTransClassfctn FK Transaction Type Category
AccountingDocument Journal Entry
TransactionSubitem Partial Document to be balanced to zero
DebitCreditCode Debit/Credit Code Show values
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
ActualAmountInCompanyCodeCrcy Amount in Company Code Currency
PlanAmountInCompanyCodeCrcy Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
ActualAmountInGlobalCurrency Amount in Company Code Currency
PlanAmountInGlobalCurrency Amount in Company Code Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
ActualAmountInFreeDfndCrcy1 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy1 Amount in Company Code Currency
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
ActualAmountInFreeDfndCrcy2 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy2 Amount in Company Code Currency
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
ActualAmountInFreeDfndCrcy3 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy3 Amount in Company Code Currency
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
ActualAmountInFreeDfndCrcy4 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy4 Amount in Company Code Currency
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
ActualAmountInFreeDfndCrcy5 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy5 Amount in Company Code Currency
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
ActualAmountInFreeDfndCrcy6 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy6 Amount in Company Code Currency
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
ActualAmountInFreeDfndCrcy7 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy7 Amount in Company Code Currency
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
ActualAmountInFreeDfndCrcy8 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy8 Amount in Company Code Currency
Column Name Description
Column Name Description
AccountingDocumentCreationDate Journal Entry Creation Date
CreationTime Journal Entry Creation Time
PostingDate Posting Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Financial Account Type Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
Column Name Description Domain name
PersonnelNumber Personnel Number PERNR
Master Data Relations Join Conditions
Transaction Type Category P_ASSETBALANCELINEITEM.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • P_ASSETBALANCELINEITEM.ASSETTRANSACTIONTYPE == TABW.BWASL
  • P_ASSETBALANCELINEITEM.MANDT == TABW.MANDT
Business Area
  • Business Area
  • Client
  • P_ASSETBALANCELINEITEM.BUSINESSAREA == TGSB.GSBER
  • P_ASSETBALANCELINEITEM.MANDT == TGSB.MANDT
Chart of Depreciaton for Asset Valuation
  • Chart of Depreciaton for Asset Valuation
  • Client
  • P_ASSETBALANCELINEITEM.CHARTOFDEPRECIATION == T096.AFAPL
  • P_ASSETBALANCELINEITEM.MANDT == T096.MANDT
Company Code
  • Company Code
  • Client
  • P_ASSETBALANCELINEITEM.COMPANYCODE == T001.BUKRS
  • P_ASSETBALANCELINEITEM.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_ASSETBALANCELINEITEM.MANDT == TCURC.MANDT
  • P_ASSETBALANCELINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
Cost Center
  • ?
  • ?
  • Client
  • Cost Center
  • P_ASSETBALANCELINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • P_ASSETBALANCELINEITEM.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_ASSETBALANCELINEITEM.MANDT == CSKS.MANDT
  • P_ASSETBALANCELINEITEM.COSTCENTER == CSKS.KOSTL
Asset Subnumber
  • Fixed Asset
  • Asset Subnumber
  • Client
  • ?
  • P_ASSETBALANCELINEITEM.MASTERFIXEDASSET == ANLA.ANLN1
  • P_ASSETBALANCELINEITEM.FIXEDASSET == ANLA.ANLN2
  • P_ASSETBALANCELINEITEM.MANDT == ANLA.MANDT
  • P_ASSETBALANCELINEITEM.[column in domain "BUKRS"] == ANLA.BUKRS
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_ASSETBALANCELINEITEM.MANDT == TCURC.MANDT
  • P_ASSETBALANCELINEITEM.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_ASSETBALANCELINEITEM.MANDT == TCURC.MANDT
  • P_ASSETBALANCELINEITEM.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_ASSETBALANCELINEITEM.MANDT == TCURC.MANDT
  • P_ASSETBALANCELINEITEM.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_ASSETBALANCELINEITEM.MANDT == TCURC.MANDT
  • P_ASSETBALANCELINEITEM.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • P_ASSETBALANCELINEITEM.FREEDEFINEDCURRENCY5 == TCURC.WAERS
  • P_ASSETBALANCELINEITEM.MANDT == TCURC.MANDT
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_ASSETBALANCELINEITEM.MANDT == TCURC.MANDT
  • P_ASSETBALANCELINEITEM.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_ASSETBALANCELINEITEM.MANDT == TCURC.MANDT
  • P_ASSETBALANCELINEITEM.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_ASSETBALANCELINEITEM.MANDT == TCURC.MANDT
  • P_ASSETBALANCELINEITEM.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • P_ASSETBALANCELINEITEM.MANDT == TFKB.MANDT
  • P_ASSETBALANCELINEITEM.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Client
  • Fund
  • ?
  • P_ASSETBALANCELINEITEM.MANDT == FMFINCODE.MANDT
  • P_ASSETBALANCELINEITEM.FUND == FMFINCODE.FINCODE
  • P_ASSETBALANCELINEITEM.[column in domain "FIKRS"] == FMFINCODE.FIKRS
General Ledger Account
  • Company Code
  • General Ledger Account
  • Client
  • P_ASSETBALANCELINEITEM.COMPANYCODE == SKB1.BUKRS
  • P_ASSETBALANCELINEITEM.GLACCOUNT == SKB1.SAKNR
  • P_ASSETBALANCELINEITEM.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • P_ASSETBALANCELINEITEM.GLOBALCURRENCY == TCURC.WAERS
  • P_ASSETBALANCELINEITEM.MANDT == TCURC.MANDT
Group Asset Subnumber
  • Group Asset Subnumber
  • Client
  • Group Asset
  • ?
  • P_ASSETBALANCELINEITEM.GROUPFIXEDASSET == ANLA.ANLN2
  • P_ASSETBALANCELINEITEM.MANDT == ANLA.MANDT
  • P_ASSETBALANCELINEITEM.GROUPMASTERFIXEDASSET == ANLA.ANLN1
  • P_ASSETBALANCELINEITEM.[column in domain "BUKRS"] == ANLA.BUKRS
Joint Venture Cost Recovery Code
  • Joint Venture Cost Recovery Code
  • Client
  • ?
  • P_ASSETBALANCELINEITEM.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • P_ASSETBALANCELINEITEM.MANDT == T8JJ.MANDT
  • P_ASSETBALANCELINEITEM.[column in domain "BUKRS"] == T8JJ.BUKRS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Target Ledger Group
  • Target Ledger Group
  • Client
Plant
  • Plant
  • Client
  • P_ASSETBALANCELINEITEM.PLANT == T001W.WERKS
  • P_ASSETBALANCELINEITEM.MANDT == T001W.MANDT
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • P_ASSETBALANCELINEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • P_ASSETBALANCELINEITEM.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_ASSETBALANCELINEITEM.MANDT == CEPC.MANDT
  • P_ASSETBALANCELINEITEM.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_ASSETBALANCELINEITEM.MANDT == FAGL_SEGM.MANDT
  • P_ASSETBALANCELINEITEM.SEGMENT == FAGL_SEGM.SEGMENT
Subledger-Specific Line Item Type P_ASSETBALANCELINEITEM.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE