I_ASSETVALUATION

CDS View

Asset Valuation

I_ASSETVALUATION is a CDS View in S/4HANA. Asset Valuation. It contains 15 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_AssetValuationVH view from CONSUMPTION Asset Valuation Value Help
C_FixedAssetPostingDeprAreaVH view_entity from CONSUMPTION Depreciation Area for Asset Posting
FAC_AUDIT_Z3_ASSET_MASTER view inner Asset Master
I_AssetValuationForLedger view inner COMPOSITE Fixed Asset Valuation for Ledger
I_AssetValuationTP view from TRANSACTIONAL Asset Valuation
P_AssetLedgerFiscalYear view from COMPOSITE Fiscal Year in Asset Ledger
P_AssetValuationForLedger view inner COMPOSITE Asset Valuation For Ledger
P_AstDeprBalWthAllAreasCube1 view_entity inner CONSUMPTION Asset Depreciation Balance Cube With Derived Areas 1
P_AstEndgBalForChtWthAllAreas1 view_entity inner CONSUMPTION Asset Tot.Depr., Total APC and NetBook Val. With Drvd Areas1
P_AstKeyFigBalComprnCube1 view inner CONSUMPTION Asset Key Figure Balance Comparison Cube 1
P_AstKeyFigBalWthAllAreasCube1 view_entity inner CONSUMPTION Asset Key Figure Cube Balance With Derived Areas 1
P_AstNetBookBalWthAllAreas1 view inner CONSUMPTION Asset NetBook Value
R_FixedAssetValuationTP view_entity from TRANSACTIONAL Fixed Asset Valuation

Fields (15)

KeyField CDS FieldsUsed in Views
AssetDepreciationArea AssetDepreciationArea 1
AssetOpgReadinessDate AssetOpgReadinessDate 2
DepreciationAreaType DepreciationAreaType 2
DepreciationKey DepreciationKey 1
DepreciationStartDate DepreciationStartDate 3
DeprKeyChangeoverPeriod DeprKeyChangeoverPeriod 2
DeprKeyChangeoverYear DeprKeyChangeoverYear 2
InterestCalcStartDate InterestCalcStartDate 1
LastRetirementValueDate LastRetirementValueDate 2
Ledger Ledger 1
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods 1
PlannedUsefulLifeInYears PlannedUsefulLifeInYears 1
ReplacementValueIndexSers ReplacementValueIndexSers 2
RplcmtValueAgingIndexSers RplcmtValueAgingIndexSers 1
SpecialDeprStartDate SpecialDeprStartDate 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.

-- Asset Valuation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ASSETVALUATION (
    ASSETDEPRECIATIONAREA,
    ASSETOPGREADINESSDATE,
    DEPRECIATIONAREATYPE,
    DEPRECIATIONKEY,
    DEPRECIATIONSTARTDATE,
    DEPRKEYCHANGEOVERPERIOD,
    DEPRKEYCHANGEOVERYEAR,
    INTERESTCALCSTARTDATE,
    LASTRETIREMENTVALUEDATE,
    LEDGER,
    PLANNEDUSEFULLIFEINPERIODS,
    PLANNEDUSEFULLIFEINYEARS,
    REPLACEMENTVALUEINDEXSERS,
    RPLCMTVALUEAGINGINDEXSERS,
    SPECIALDEPRSTARTDATE
);