C_FixedAssetWorklist

Fixed Asset Worklist | view: CFASSETLIST | Extraction: Not supported | Component: Fiori UI for Asset Accounting
Tables used: PRTE, T087T, T001, TKA02, CSKS, CSKS, CSKT, T005, T087K, T087L, T097, T097T, IFLOT, IFLOTX, T087, T087, T087, T087, T087G, T087S, T087I, T087J, T098, T098T, LFA1, TTXJ, TTXJT, PRPS, FAAC_ACCTDET0, T095A, FAAC_ACCTDET0_T, T095T, ANKA, FAAC_ACLS0, ANKT, FAAC_ACLS0_T, FAAT_CMP, T093C, ANLA, FAAT_MD, FAAT_MD_ROOT, T001, ANLZ, FAAT_MD_TDD, TKA02
Column Name Description
ValidityEndDate Date Validity Ends
MasterFixedAsset FK Main Asset Number
FixedAsset Asset Subnumber
CompanyCode FK Company Code
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
ValidityEndDate Date Validity Ends
KeyDate null
AssetCapitalizationDate Asset Capitalization Date
LastChangeDate Changed On
LastRetirementValueDate Asset Value Date for the Last Retirement
OriginalFixedAssetValueDate Original Acquisition Date of AuC/ Transferred Asset
FixedAssetOrderDate Asset Purchase Order Date
AssetDeactivationDate Deactivation Date
LastAssessmentNoticeDate Date of last notice of assessment
CreationDate Date on which the record was created
PlannedRetirementDate Planned Retirement Date
LastInventoryDate Last Inventory Date
LastReorganizationDate Date of Last Reorganization
LegacyDataTransferDate Legacy Data Transfer Date
AcquisitionValueDate Asset Value Date of the First Posting
ValidityStartDate Date for Beginning of Validity
Column Name Description
FixedAssetFinDataCmpltns Completeness indicator for the asset Show values
InventoryIsCounted Inventory Indicator Show values
IsGroupAsset Indicator: Asset is a group asset Show values
AssetUnderConstIsInvmtMsr Asset under Construction for Investment Measures Show values
AccountIsMarkedForDeletion Indicator: Account Marked for Deletion? Show values
IsLineItemSettled Asset under construct. with line item settlement Show values
AccountIsBlockedForPosting Indicator: Asset Locked to Acquisition Postings Show values
IsShutDown Asset shutdown Show values
Column Name Description Domain name
FixedAssetExternalID Asset Number CHAR17
FixedAssetDescription Asset Description TEXT50
CompanyCodeName Name of Company Code or Company TEXT25
Status Values for Domains: Single Value/Lower Limit DOMVAL
StatusName Status
FixedAssetFinDataCmpltnsName Short Text for Fixed Values DDTEXT
Inventory Inventory Number INVNR_ANLA
AssetCostCenter Cost Center KOSTL
CostCenterName Name of cost center TEXT20
AssetClassName Short Text for Asset Class Name TEXT20
AssetClassDescription Asset class description TEXT50
IsCapitalized Values for Domains: Single Value/Lower Limit DOMVAL
OriginalFixedAsset Original Asset That Was Transferred ANLN2
LastChangedByUser Name of Person Who Changed Object USNAM
OriginalMasterFixedAsset Original Asset That Was Transferred ANLN1
InvestmentOrder Investment Order AUFNR
NoticeOfAssessmentTaxID Tax Number of the Notice of Assessment EHWNR_ANLA
FixedAssetPropertyTypeName Property indicator description TEXT30
CreatedByUser Name of Person Responsible for Creating the Object USNAM
ManualDepreciationReasonName Description of the reason for manual net assets valuation TEXT30
AssetManufacturerName Manufacturer of Asset TEXT30
InventoryNote Supplementary Inventory Specifications INVZU_ANLA
InvestmentReasonName Name of investment reason TEXT50
AssetAccountDeterminationDesc Name of Account Determination TEXT50
AssetSupplierName Name of Supplier TEXT80
SupplierName Name of Supplier TEXT80
Group1AssetEvaluationKeyName Evaluation group:Short description 1 TEXT30
Group2AssetEvaluationKeyName Evaluation group:Short description 2 TEXT30
Group3AssetEvaluationKeyName Evaluation group:Short description 3 TEXT30
Group4AssetEvaluationKeyName Evaluation group:Short description 4 TEXT30
Group5AssetEvaluationKeyName Evaluation group:Short description 5 TXT50
InvestmentProjectWBSElement null
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
AssetSerialNumber Serial number GERNR
AssetTypeName Asset Type Name TYPBZ_ANLA
EnvironmentInvestmntReasonName Name of environment investment reason TEXT50
OriginalAcquisitionFiscalYear Fiscal Year of Original Acquisition GJAHR
FirstAcquisitionFiscalYear Fiscal Year in Which First Acquisition Was Posted GJAHR
FirstAcquisitionFiscalPeriod Period in Which First Acquisition Was Posted POPER
AssetBudgetPeriod Budget Period FM_BUDGET_PERIOD
FundsCenter Funds Center FISTL
FunctionalArea Functional Area FKBER
AssetFund Fund BP_GEBER
AssetGrant Grant GM_GRANT_NBR
RealEstateObject Internal Key for Real Estate Object IMKEY
VehicleLicensePlateNumber License Plate No. of Vehicle AM_KFZKZ
ResponsibleCostCenter Cost Center Responsible for Asset KOSTL
CostCtrActivityType Activity Type LSTAR
PersonnelNumber Personnel Number PERNR
AssetProfitCenter Profit Center PRCTR
Room Room CHAR8
FunctionalLocation Functional Location TPLNR
FunctionalLocationName Description of functional location TEXT40
TaxJurisdictionName Description TEXT50
Master Data Relations Join Conditions
Area Unit
  • Area Unit
  • Client
  • C_FIXEDASSETWORKLIST.AREASIZEUNIT == T006.MSEHI
  • C_FIXEDASSETWORKLIST.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • C_FIXEDASSETWORKLIST.ASSETBUSINESSAREA == TGSB.GSBER
  • C_FIXEDASSETWORKLIST.MANDT == TGSB.MANDT
Asset's Country/Region of Origin
  • Client
  • Asset's Country/Region of Origin
  • C_FIXEDASSETWORKLIST.MANDT == T005.MANDT
  • C_FIXEDASSETWORKLIST.ASSETCOUNTRYOFORIGIN == T005.LAND1
Asset location
  • Asset location
  • Plant
  • Client
  • C_FIXEDASSETWORKLIST.ASSETLOCATION == T499S.STAND
  • C_FIXEDASSETWORKLIST.PLANT == T499S.WERKS
  • C_FIXEDASSETWORKLIST.MANDT == T499S.MANDT
Segment
  • Client
  • Segment for Segmental Reporting
  • C_FIXEDASSETWORKLIST.MANDT == FAGL_SEGM.MANDT
  • C_FIXEDASSETWORKLIST.ASSETSEGMENT == FAGL_SEGM.SEGMENT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_FIXEDASSETWORKLIST.BASEUNIT == T006.MSEHI
  • C_FIXEDASSETWORKLIST.MANDT == T006.MANDT
Chart of Depreciaton for Asset Valuation
  • Client
  • Chart of Depreciaton for Asset Valuation
  • C_FIXEDASSETWORKLIST.MANDT == T096.MANDT
  • C_FIXEDASSETWORKLIST.CHARTOFDEPRECIATION == T096.AFAPL
Controlling Area
  • Controlling Area
  • Client
  • C_FIXEDASSETWORKLIST.CONTROLLINGAREA == TKA01.KOKRS
  • C_FIXEDASSETWORKLIST.MANDT == TKA01.MANDT
Reason for Environmental Investment
  • Reason for Environmental Investment
  • Client
  • C_FIXEDASSETWORKLIST.ENVRNMTLINVESTMENTREASON == T087K.UMWKZ
  • C_FIXEDASSETWORKLIST.MANDT == T087K.MANDT
Asset Super Number
  • Asset Super Number
  • Client
  • C_FIXEDASSETWORKLIST.FIXEDASSETGROUP == T087U.ANLUE
  • C_FIXEDASSETWORKLIST.MANDT == T087U.MANDT
Property Indicator
  • Client
  • Property Indicator
  • C_FIXEDASSETWORKLIST.MANDT == T097.MANDT
  • C_FIXEDASSETWORKLIST.FIXEDASSETPROPERTYTYPE == T097.EIGKZ
Evaluation Group 1
  • Evaluation group 1
  • Client
  • ?
  • C_FIXEDASSETWORKLIST.GROUP1ASSETEVALUATIONKEY == T087.ORD4X
  • C_FIXEDASSETWORKLIST.MANDT == T087.MANDT
  • C_FIXEDASSETWORKLIST.[column in domain "ORDNR"] == T087.ORDNR
Evaluation Group 2
  • Client
  • ?
  • Evaluation Group 2
  • C_FIXEDASSETWORKLIST.MANDT == T087.MANDT
  • C_FIXEDASSETWORKLIST.[column in domain "ORDNR"] == T087.ORDNR
  • C_FIXEDASSETWORKLIST.GROUP2ASSETEVALUATIONKEY == T087.ORD4X
Evaluation Group 3
  • Client
  • ?
  • Evaluation Group 3
  • C_FIXEDASSETWORKLIST.MANDT == T087.MANDT
  • C_FIXEDASSETWORKLIST.[column in domain "ORDNR"] == T087.ORDNR
  • C_FIXEDASSETWORKLIST.GROUP3ASSETEVALUATIONKEY == T087.ORD4X
Evaluation group 4
  • Evaluation group 4
  • Client
  • ?
  • C_FIXEDASSETWORKLIST.GROUP4ASSETEVALUATIONKEY == T087.ORD4X
  • C_FIXEDASSETWORKLIST.MANDT == T087.MANDT
  • C_FIXEDASSETWORKLIST.[column in domain "ORDNR"] == T087.ORDNR
Guideline group
  • Evaluation Group 5
  • Client
  • C_FIXEDASSETWORKLIST.GROUP5ASSETEVALUATIONKEY == T087G.GDLGRP
  • C_FIXEDASSETWORKLIST.MANDT == T087G.MANDT
Internal Order
  • Internal Order
  • Client
  • C_FIXEDASSETWORKLIST.INTERNALORDER == AUFK.AUFNR
  • C_FIXEDASSETWORKLIST.MANDT == AUFK.MANDT
Reason for Investment
  • Reason for Investment
  • Client
  • C_FIXEDASSETWORKLIST.INVESTMENTREASON == T087I.IZWEK
  • C_FIXEDASSETWORKLIST.MANDT == T087I.MANDT
Maintenance Order
  • Maintenance Order
  • Client
  • C_FIXEDASSETWORKLIST.MAINTENANCEORDER == AUFK.AUFNR
  • C_FIXEDASSETWORKLIST.MANDT == AUFK.MANDT
Reason for Manual Valuation of Net Assets
  • Reason for Manual Valuation of Net Assets
  • Client
  • C_FIXEDASSETWORKLIST.MANUALDEPRECIATIONREASON == T098.GRUND
  • C_FIXEDASSETWORKLIST.MANDT == T098.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_FIXEDASSETWORKLIST.MANDT == T880.MANDT
  • C_FIXEDASSETWORKLIST.PARTNERCOMPANY == T880.RCOMP
Plant
  • Plant
  • Client
  • C_FIXEDASSETWORKLIST.PLANT == T001W.WERKS
  • C_FIXEDASSETWORKLIST.MANDT == T001W.MANDT
Account number of vendor (other key word)
  • Account number of vendor (other key word)
  • Client
  • C_FIXEDASSETWORKLIST.SUPPLIER == LFA1.LIFNR
  • C_FIXEDASSETWORKLIST.MANDT == LFA1.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • C_FIXEDASSETWORKLIST.MANDT == T683.MANDT
  • C_FIXEDASSETWORKLIST.[column in domain "KVEWE"] == T683.KVEWE
  • C_FIXEDASSETWORKLIST.[column in domain "KAPPL"] == T683.KAPPL
  • C_FIXEDASSETWORKLIST.TAXCALCULATIONPROCEDURE == T683.KALSM
Tax Jurisdiction
  • Tax Jurisdiction
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • C_FIXEDASSETWORKLIST.TAXJURISDICTION == TTXJ.TXJCD
  • C_FIXEDASSETWORKLIST.MANDT == TTXJ.MANDT
  • C_FIXEDASSETWORKLIST.TAXCALCULATIONPROCEDURE == TTXJ.KALSM