I_FIXEDASSETVALUE

CDS View
17 Fields 7 CDS Views

I_FixedAssetValue

I_FIXEDASSETVALUE is a CDS View in S/4HANA. I_FixedAssetValue. It contains 17 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_IN_FixedAssetTransaction view from COMPOSITE CDS view for Fixed Asset Transaction (India)
P_DartFixedAssetValue view from COMPOSITE
P_DartFixedAssetValue view union_all COMPOSITE
P_RO_StRpFixedAssetChartValue view from CONSUMPTION
P_RU_FixedAssetValueTrans1 view from CONSUMPTION
P_RU_PropertyTaxFixedAssetVal0 view from COMPOSITE
P_RU_PropertyTaxFixedAssetVal1 view inner COMPOSITE

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY FiscalPeriod FiscalPeriod 2
KEY FiscalYear FiscalYear 2
KEY Ledger Ledger 2
_CompanyCode _CompanyCode 2
_Country _Country 1
_FiscalPeriod _FiscalPeriod 1
_FiscalYear _FiscalYear 2
_FiscalYearVariant _FiscalYearVariant 4
_Ledger _Ledger 2
AccountingPrinciple AccountingPrinciple 1
ChartOfAccounts ChartOfAccounts 1
Country Country 1
DepreciationFiscalPeriod DepreciationFiscalPeriod 1
FinancialStatementVariant FinancialStatementVariant 1
FiscalYearPeriod FiscalYearPeriod 2
FiscalYearVariant FiscalYearVariant 2

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.

-- I_FixedAssetValue
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FIXEDASSETVALUE (
    COMPANYCODE,
    FISCALPERIOD,
    FISCALYEAR,
    LEDGER,
    _COMPANYCODE,
    _COUNTRY,
    _FISCALPERIOD,
    _FISCALYEAR,
    _FISCALYEARVARIANT,
    _LEDGER,
    ACCOUNTINGPRINCIPLE,
    CHARTOFACCOUNTS,
    COUNTRY,
    DEPRECIATIONFISCALPERIOD,
    FINANCIALSTATEMENTVARIANT,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    PRIMARY KEY (COMPANYCODE, FISCALPERIOD, FISCALYEAR, LEDGER)
);

Learn More