I_DEPRAREABYCOCODEWITHCRCYROLE

CDS View

Depreciation Areas of Company Code with Currency Role

I_DEPRAREABYCOCODEWITHCRCYROLE is a CDS View in S/4HANA. Depreciation Areas of Company Code with Currency Role. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_FixedAssetDeprAreaTP view inner COMPOSITE Transactional View Fixed Asset Depreciation Areas
I_FxdAstDeprAreaCrcyRoleVH view from COMPOSITE Currency Roles of a Depreciation Area

Fields (10)

KeyField CDS FieldsUsed in Views
KEY AssetDepreciationArea AssetDepreciationArea 1
AccountingPrinciple AccountingPrinciple 1
AssetAcctgLastClosedFiscalYear AssetAcctgLastClosedFiscalYear 1
ChartOfDepreciation ChartOfDepreciation 1
Currency DepreciationAreaCurrency 1
DepreciationAreaCurrencyRole DepreciationAreaCurrencyRole 1
IsRealDepreciationArea IsRealDepreciationArea 1
IsValueReferenceDeprArea IsValueReferenceDeprArea 1
Ledger Ledger 1
ValueReferenceDepreciationArea ValueReferenceDepreciationArea 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.

-- Depreciation Areas of Company Code with Currency Role
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DEPRAREABYCOCODEWITHCRCYROLE (
    ASSETDEPRECIATIONAREA,
    ACCOUNTINGPRINCIPLE,
    ASSETACCTGLASTCLOSEDFISCALYEAR,
    CHARTOFDEPRECIATION,
    CURRENCY,
    DEPRECIATIONAREACURRENCYROLE,
    ISREALDEPRECIATIONAREA,
    ISVALUEREFERENCEDEPRAREA,
    LEDGER,
    VALUEREFERENCEDEPRECIATIONAREA,
    PRIMARY KEY (ASSETDEPRECIATIONAREA)
);