I_FIXEDASSETFORLEDGER

CDS View
13 Fields 18 CDS Views

Fixed Asset for Ledger

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

CDS Views using this table (18)

ViewTypeJoinVDMDescription
C_BG_StRpTaxDeprShutdownCube view inner CONSUMPTION Tax depreciation plan shutdowns - Cube
C_CN_CADEAssetByPeriod view inner CONSUMPTION Asset Assignment by Period for CADE
C_PL_SAFTFixedAssetValueCube view_entity inner CONSUMPTION PL SAFT Fixed Asset Values - Cube
FAA_MD_CAP_DATE view from Earliest non-initial cap. date per asset
I_AssetLedgerTP view from TRANSACTIONAL Asset Ledger
I_CN_CADEFixedAssetValueCube view inner COMPOSITE Fixed Asset Balance Cube for CADE
I_TH_AssetDisposalCube view left_outer COMPOSITE Thailand: Disposal List Cube
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_CN_CADEAssetChangeLog view from CONSUMPTION Asset Change Log for CADE
P_CN_CADEAssetChangeLog view union_all CONSUMPTION Asset Change Log for CADE
P_FixedAssetVH1 view from COMPOSITE P_FixedAssetStdVH
P_PL_SAFTAssetRetirement10 view_entity inner CONSUMPTION PL SAFT Asset Retirement, level 10
P_PL_SAFTFixedAssetFields10 view_entity inner CONSUMPTION PL SAFT Fixed Asset Level 10
P_RO_SAFTFixedAsset view_entity inner COMPOSITE RO SAFT Fixed Asset Master Data
P_RS_TaxDeprFixedAssetFields view inner COMPOSITE RS Tax Depreciation Fixed Asset Fields
P_RU_PropertyTaxFixedAsset2 view inner COMPOSITE Russia Property Tax Fixed Asset Data
R_FixedAssetLedgerTP view_entity from TRANSACTIONAL Fixed Asset Ledger

Fields (13)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 3
KEY FixedAsset FixedAsset 4
KEY Ledger Ledger 4
KEY MasterFixedAsset MasterFixedAsset 4
_CompanyCode _CompanyCode 1
_FixedAsset _FixedAsset 1
_MasterFixedAsset _MasterFixedAsset 1
AcquisitionValueDate AcquisitionValueDate 4
AssetCapitalizationDate AssetCapitalizationDate,AssetDeactivationDate 11
AssetDeactivationDate AssetDeactivationDate 10
FirstAcquisitionFiscalPeriod FirstAcquisitionFiscalPeriod 1
FirstAcquisitionFiscalYear FirstAcquisitionFiscalYear 2
LastRevaluationDate LastRevaluationDate 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 for Ledger
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FIXEDASSETFORLEDGER (
    COMPANYCODE,
    FIXEDASSET,
    LEDGER,
    MASTERFIXEDASSET,
    _COMPANYCODE,
    _FIXEDASSET,
    _MASTERFIXEDASSET,
    ACQUISITIONVALUEDATE,
    ASSETCAPITALIZATIONDATE,
    ASSETDEACTIVATIONDATE,
    FIRSTACQUISITIONFISCALPERIOD,
    FIRSTACQUISITIONFISCALYEAR,
    LASTREVALUATIONDATE,
    PRIMARY KEY (COMPANYCODE, FIXEDASSET, LEDGER, MASTERFIXEDASSET)
);

Learn More