I_ASSETTIMEBASEDVALUATION

CDS View
22 Fields 5 CDS Views

Time Based Valuation of Asset

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

CDS Views using this table (5)

ViewTypeJoinVDMDescription
FAC_AUDIT_Z3_ASSET_MASTER view left_outer Asset Master
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_BG_StRpTaxDeprShutdown view union_all CONSUMPTION Tax depr. plan - shutdowns

Fields (22)

KeyField CDS FieldsUsed in Views
KEY AssetDepreciationArea AssetRealDepreciationArea 1
KEY FixedAsset FixedAsset 2
KEY Ledger Ledger 1
KEY MasterFixedAsset MasterFixedAsset 2
KEY ValidityEndDate ValidityEndDate,ValuationValidityEndDate 2
AcqnProdnCostScrapPercent AcqnProdnCostScrapPercent 1
DepreciationKey DepreciationKey 2
FixedAssetUsageObject FixedAssetUsageObject 1
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods 2
PlannedUsefulLifeInYears PlannedUsefulLifeInYears 2
ScrapAmountInCoCodeCrcy ScrapAmountInCoCodeCrcy 2
ScrapAmountInFreeDefinedCrcy1 ScrapAmountInFreeDefinedCrcy1 1
ScrapAmountInFreeDefinedCrcy2 ScrapAmountInFreeDefinedCrcy2 1
ScrapAmountInFreeDefinedCrcy3 ScrapAmountInFreeDefinedCrcy3 1
ScrapAmountInFreeDefinedCrcy4 ScrapAmountInFreeDefinedCrcy4 1
ScrapAmountInFreeDefinedCrcy5 ScrapAmountInFreeDefinedCrcy5 1
ScrapAmountInFreeDefinedCrcy6 ScrapAmountInFreeDefinedCrcy6 1
ScrapAmountInFreeDefinedCrcy7 ScrapAmountInFreeDefinedCrcy7 1
ScrapAmountInFreeDefinedCrcy8 ScrapAmountInFreeDefinedCrcy8 1
ScrapAmountInGlobCrcy ScrapAmountInGlobCrcy 1
ValidityStartDate ValidityStartDate,ValuationValidityStartDate 2
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,
    FIXEDASSET,
    LEDGER,
    MASTERFIXEDASSET,
    VALIDITYENDDATE,
    ACQNPRODNCOSTSCRAPPERCENT,
    DEPRECIATIONKEY,
    FIXEDASSETUSAGEOBJECT,
    PLANNEDUSEFULLIFEINPERIODS,
    PLANNEDUSEFULLIFEINYEARS,
    SCRAPAMOUNTINCOCODECRCY,
    SCRAPAMOUNTINFREEDEFINEDCRCY1,
    SCRAPAMOUNTINFREEDEFINEDCRCY2,
    SCRAPAMOUNTINFREEDEFINEDCRCY3,
    SCRAPAMOUNTINFREEDEFINEDCRCY4,
    SCRAPAMOUNTINFREEDEFINEDCRCY5,
    SCRAPAMOUNTINFREEDEFINEDCRCY6,
    SCRAPAMOUNTINFREEDEFINEDCRCY7,
    SCRAPAMOUNTINFREEDEFINEDCRCY8,
    SCRAPAMOUNTINGLOBCRCY,
    VALIDITYSTARTDATE,
    VARIABLEDEPRPERCENT,
    PRIMARY KEY (ASSETDEPRECIATIONAREA, FIXEDASSET, LEDGER, MASTERFIXEDASSET, VALIDITYENDDATE)
);

Learn More