I_ASSETTIMEBASEDVALUATION

CDS View
27 Fields 7 CDS Views

Time Based Valuation of Asset

I_ASSETTIMEBASEDVALUATION is a CDS View in S/4HANA. Time Based Valuation of Asset. It contains 27 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
FAC_AUDIT_Z3_ASSET_MASTER view left_outer Asset Master
I_AssetRevalIndexWhereUsed view_entity inner COMPOSITE Where used of Asset Revaluation Index
I_AssetTimeBasedValuationTP view from TRANSACTIONAL Time Based Valuation of Asset
I_FixedAssetUsageObjWhereUsd view inner COMPOSITE Where used of Fixed Asset Usage Object
P_AssetValuationForLedger view union_all COMPOSITE
P_AssetValuationScrapAmount view_entity from COMPOSITE Fixed Asset Valuation Scrap Values
P_BG_StRpTaxDeprShutdown view union_all CONSUMPTION Tax depr. plan - shutdowns

Fields (27)

KeyField CDS FieldsUsed in Views
KEY AssetDepreciationArea AssetRealDepreciationArea 1
KEY CompanyCode CompanyCode 2
KEY FixedAsset FixedAsset 4
KEY Ledger Ledger 2
KEY MasterFixedAsset MasterFixedAsset 4
KEY ValidityEndDate ValidityEndDate,ValuationValidityEndDate 3
AcqnProdnCostScrapPercent AcqnProdnCostScrapPercent 2
AssetRevaluationIndex AssetRevaluationIndex 1
DeprCalcBaseValuePercent DeprCalcBaseValuePercent 1
DepreciationKey DepreciationKey 2
FixedAssetUsageObject FixedAssetUsageObject 1
IsShutDown IsShutDown 1
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods 2
PlannedUsefulLifeInYears PlannedUsefulLifeInYears 2
ScrapAmountInCoCodeCrcy ScrapAmountInCoCodeCrcy 3
ScrapAmountInFreeDefinedCrcy1 ScrapAmountInFreeDefinedCrcy1 2
ScrapAmountInFreeDefinedCrcy2 ScrapAmountInFreeDefinedCrcy2 2
ScrapAmountInFreeDefinedCrcy3 ScrapAmountInFreeDefinedCrcy3 2
ScrapAmountInFreeDefinedCrcy4 ScrapAmountInFreeDefinedCrcy4 2
ScrapAmountInFreeDefinedCrcy5 ScrapAmountInFreeDefinedCrcy5 2
ScrapAmountInFreeDefinedCrcy6 ScrapAmountInFreeDefinedCrcy6 2
ScrapAmountInFreeDefinedCrcy7 ScrapAmountInFreeDefinedCrcy7 2
ScrapAmountInFreeDefinedCrcy8 ScrapAmountInFreeDefinedCrcy8 2
ScrapAmountInGlobCrcy ScrapAmountInGlobCrcy 2
ShiftOperationFactor ShiftOperationFactor 1
ValidityStartDate ValidityStartDate,ValuationValidityStartDate 3
VariableDeprPercent VariableDeprPercent 1

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.

-- Time Based Valuation of Asset
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ASSETTIMEBASEDVALUATION (
    ASSETDEPRECIATIONAREA,
    COMPANYCODE,
    FIXEDASSET,
    LEDGER,
    MASTERFIXEDASSET,
    VALIDITYENDDATE,
    ACQNPRODNCOSTSCRAPPERCENT,
    ASSETREVALUATIONINDEX,
    DEPRCALCBASEVALUEPERCENT,
    DEPRECIATIONKEY,
    FIXEDASSETUSAGEOBJECT,
    ISSHUTDOWN,
    PLANNEDUSEFULLIFEINPERIODS,
    PLANNEDUSEFULLIFEINYEARS,
    SCRAPAMOUNTINCOCODECRCY,
    SCRAPAMOUNTINFREEDEFINEDCRCY1,
    SCRAPAMOUNTINFREEDEFINEDCRCY2,
    SCRAPAMOUNTINFREEDEFINEDCRCY3,
    SCRAPAMOUNTINFREEDEFINEDCRCY4,
    SCRAPAMOUNTINFREEDEFINEDCRCY5,
    SCRAPAMOUNTINFREEDEFINEDCRCY6,
    SCRAPAMOUNTINFREEDEFINEDCRCY7,
    SCRAPAMOUNTINFREEDEFINEDCRCY8,
    SCRAPAMOUNTINGLOBCRCY,
    SHIFTOPERATIONFACTOR,
    VALIDITYSTARTDATE,
    VARIABLEDEPRPERCENT,
    PRIMARY KEY (ASSETDEPRECIATIONAREA, COMPANYCODE, FIXEDASSET, LEDGER, MASTERFIXEDASSET, VALIDITYENDDATE)
);

Learn More