I_FIXEDASSETFORLEDGER

CDS View
10 Fields 14 CDS Views

Fixed Asset for Ledger

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

CDS Views using this table (14)

ViewTypeJoinVDMDescription
C_BG_StRpTaxDeprShutdownCube view inner CONSUMPTION Tax depreciation plan shutdowns - Cube
C_CN_CADEAssetByPeriod view inner CONSUMPTION Asset Assignment by Period for CADE
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
P_AUDIT_AT_AssetTransaction view left_outer COMPOSITE
P_CN_CADEAssetChangeLog view from CONSUMPTION
P_CN_CADEAssetChangeLog view union_all CONSUMPTION
P_FixedAssetVH1 view from COMPOSITE
P_RO_SAFTFixedAsset view_entity inner COMPOSITE RO SAFT Fixed Asset Master Data
P_RS_TaxDeprFixedAssetFields view inner COMPOSITE
P_RU_PropertyTaxFixedAsset2 view inner COMPOSITE

Fields (10)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY FixedAsset FixedAsset 3
KEY Ledger Ledger 4
KEY MasterFixedAsset MasterFixedAsset 3
AcquisitionValueDate AcquisitionValueDate 3
AssetCapitalizationDate AssetCapitalizationDate,AssetDeactivationDate 8
AssetDeactivationDate AssetDeactivationDate 7
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,
    ACQUISITIONVALUEDATE,
    ASSETCAPITALIZATIONDATE,
    ASSETDEACTIVATIONDATE,
    FIRSTACQUISITIONFISCALPERIOD,
    FIRSTACQUISITIONFISCALYEAR,
    LASTREVALUATIONDATE,
    PRIMARY KEY (COMPANYCODE, FIXEDASSET, LEDGER, MASTERFIXEDASSET)
);

Learn More