I_ASSETVALUATIONFORLEDGER

CDS View
18 Fields 12 CDS Views

Fixed Asset Valuation for Ledger

I_ASSETVALUATIONFORLEDGER is a CDS View in S/4HANA. Fixed Asset Valuation for Ledger. It contains 18 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_RO_StRpFxdAstChartValueCube view inner CONSUMPTION RO Asset Chart Values and Trans - Cube
I_CN_CADEFixedAssetValueCube view left_outer COMPOSITE Fixed Asset Balance Cube for CADE
I_FxdAstDeprAreaByFsclPerdEnd view from COMPOSITE Depreciation Area valid at fiscal period end date
P_AUDIT_AT_AssetHistorySheet view left_outer COMPOSITE Austrian Audit Asset History Sheet
P_AUDIT_AT_AssetTransaction view left_outer COMPOSITE Austrian Audit Asset Transaction
P_DepreciationEndDate view from COMPOSITE Depreciation End Date
P_IT_StRpFxdAstRegDeprArea view from CONSUMPTION IT FxdAst Reg. - Depr.area at FY per.end
P_PH_Excd1PMTaxItem view left_outer COMPOSITE Asset Tax Item Exceeding 1PM for PH VAT
P_PL_SAFTMainAreasFields10 view_entity from CONSUMPTION PL SAFT Fixed Asset Area Level 10
P_RO_SAFTFixedAsset view_entity inner COMPOSITE RO SAFT Fixed Asset Master Data
P_RS_TaxDeprBookAreaFields view from COMPOSITE RS Tax depr. - Book area fields
P_RS_TaxDeprTaxAreaFields view from COMPOSITE RS Tax depr. - Tax area fields

Fields (18)

KeyField CDS FieldsUsed in Views
KEY AssetRealDepreciationArea AssetDepreciationArea,AssetRealDepreciationArea 2
KEY CompanyCode CompanyCode 5
KEY FixedAsset FixedAsset 4
KEY Ledger Ledger 2
KEY MasterFixedAsset MasterFixedAsset 4
_CompanyCode _CompanyCode 1
_FixedAsset _FixedAsset 1
_Ledger _Ledger 1
_MasterFixedAsset _MasterFixedAsset 1
AssetOpgReadinessDate AssetOpgReadinessDate 1
DepreciationKey DepreciationKey 2
DepreciationStartDate DepreciationStartDate 1
DeprKeyChangeoverYear DeprKeyChangeoverYear 1
LastRetirementValueDate LastRetirementValueDate 1
PlannedUsefulLifeInPeriods BookPlannedUsefulLifeInPeriods,PlannedUsefulLifeInPeriods 3
PlannedUsefulLifeInYears BookPlannedUsefulLifeInYears,PlannedUsefulLifeInYears 3
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Fixed Asset Valuation for Ledger
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ASSETVALUATIONFORLEDGER (
    ASSETREALDEPRECIATIONAREA,
    COMPANYCODE,
    FIXEDASSET,
    LEDGER,
    MASTERFIXEDASSET,
    _COMPANYCODE,
    _FIXEDASSET,
    _LEDGER,
    _MASTERFIXEDASSET,
    ASSETOPGREADINESSDATE,
    DEPRECIATIONKEY,
    DEPRECIATIONSTARTDATE,
    DEPRKEYCHANGEOVERYEAR,
    LASTRETIREMENTVALUEDATE,
    PLANNEDUSEFULLIFEINPERIODS,
    PLANNEDUSEFULLIFEINYEARS,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (ASSETREALDEPRECIATIONAREA, COMPANYCODE, FIXEDASSET, LEDGER, MASTERFIXEDASSET)
);

Learn More