I_FIXEDASSETDEPRAREA

CDS View
31 Fields 3 CDS Views

Fixed Asset Depreciation

I_FIXEDASSETDEPRAREA is a CDS View in S/4HANA. Fixed Asset Depreciation. It contains 31 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_FixedAssetDeprAreaTP view from COMPOSITE Transactional View Fixed Asset Depreciation Areas
P_AssetValuationForLedger view from COMPOSITE Asset Valuation For Ledger
P_RS_TaxDeprFixedAssetFields view inner COMPOSITE RS Tax Depreciation Fixed Asset Fields

Fields (31)

KeyField CDS FieldsUsed in Views
KEY AssetRealDepreciationArea AssetDepreciationArea,AssetRealDepreciationArea 2
KEY CompanyCode CompanyCode 2
KEY FixedAsset FixedAsset 2
KEY MasterFixedAsset MasterFixedAsset 2
KEY ValidityEndDate ValidityEndDate 2
AcqnProdnCostScrapPercent AcqnProdnCostScrapPercent 2
AssetOpgReadinessDate AssetOpgReadinessDate 1
AssetRevaluation AssetRevaluation 1
DepreciationAreaCurrency DepreciationAreaCurrency 1
DepreciationAreaIsDactvtd DepreciationAreaIsDactvtd 1
DepreciationKey DepreciationKey 2
DepreciationStartDate DepreciationStartDate 2
DeprKeyChangeoverPeriod DeprKeyChangeoverPeriod 2
DeprKeyChangeoverYear DeprKeyChangeoverYear 2
GroupFixedAsset GroupFixedAsset 1
GroupMasterFixedAsset GroupMasterFixedAsset 1
InterestCalcStartDate InterestCalcStartDate 1
InvestmentSupportMeasure InvestmentSupportMeasure 2
NegativeAmountIsAllowed NegativeAmountIsAllowed 1
OriglAstUsefulLifeInPerds OriglAstUsefulLifeInPerds 2
OriglAstUsefulLifeInYears OriglAstUsefulLifeInYears 2
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods 2
PlannedUsefulLifeInYears PlannedUsefulLifeInYears 2
ReplacementValueIndexSers ReplacementValueIndexSers 2
RplcmtValueAgingIndexSers RplcmtValueAgingIndexSers 2
ScrapAmountInCoCodeCrcy ScrapAmountInCoCodeCrcy 1
SpecialDeprStartDate SpecialDeprStartDate 2
ValidityStartDate ValidityStartDate 2
VariableDeprPercent VariableDeprPercent 2
VintageMonth VintageMonth 2
VintageYear VintageYear 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Fixed Asset Depreciation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FIXEDASSETDEPRAREA (
    ASSETREALDEPRECIATIONAREA,
    COMPANYCODE,
    FIXEDASSET,
    MASTERFIXEDASSET,
    VALIDITYENDDATE,
    ACQNPRODNCOSTSCRAPPERCENT,
    ASSETOPGREADINESSDATE,
    ASSETREVALUATION,
    DEPRECIATIONAREACURRENCY,
    DEPRECIATIONAREAISDACTVTD,
    DEPRECIATIONKEY,
    DEPRECIATIONSTARTDATE,
    DEPRKEYCHANGEOVERPERIOD,
    DEPRKEYCHANGEOVERYEAR,
    GROUPFIXEDASSET,
    GROUPMASTERFIXEDASSET,
    INTERESTCALCSTARTDATE,
    INVESTMENTSUPPORTMEASURE,
    NEGATIVEAMOUNTISALLOWED,
    ORIGLASTUSEFULLIFEINPERDS,
    ORIGLASTUSEFULLIFEINYEARS,
    PLANNEDUSEFULLIFEINPERIODS,
    PLANNEDUSEFULLIFEINYEARS,
    REPLACEMENTVALUEINDEXSERS,
    RPLCMTVALUEAGINGINDEXSERS,
    SCRAPAMOUNTINCOCODECRCY,
    SPECIALDEPRSTARTDATE,
    VALIDITYSTARTDATE,
    VARIABLEDEPRPERCENT,
    VINTAGEMONTH,
    VINTAGEYEAR,
    PRIMARY KEY (ASSETREALDEPRECIATIONAREA, COMPANYCODE, FIXEDASSET, MASTERFIXEDASSET, VALIDITYENDDATE)
);

Learn More