I_IL_ASSETBALANCECUBE

CDS View
31 Fields 2 CDS Views

IL AA Depreciation for Statutory Reporting - Cube

I_IL_ASSETBALANCECUBE is a CDS View in S/4HANA. IL AA Depreciation for Statutory Reporting - Cube. It contains 31 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_IL_SumzdAmountsPerAssetC view_entity from COMPOSITE IL AA Depreciation for Statutory Reporting - Cube
I_IL_SumzdAmtPerAssetTaxGainC view_entity from COMPOSITE Asset amounts of KFC for TaxG - Cube

Fields (31)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY FixedAsset FixedAsset 1
KEY MasterFixedAsset MasterFixedAsset 1
AcquisitionValueDate AcquisitionValueDate 1
AssetAccountDetermination AssetAccountDetermination 1
AssetAdditionalDescription AssetAdditionalDescription 1
AssetBusinessArea AssetBusinessArea 1
AssetCapitalizationDate AssetCapitalizationDate 1
AssetClass AssetClass 1
AssetCostCenter AssetCostCenter 1
AssetDeactivationDate AssetDeactivationDate 1
AssetManufacturerName AssetManufacturerName 1
DepreciationStartDate DepreciationStartDate 1
DisplayCurrency DisplayCurrency 1
FixedAssetDescription FixedAssetDescription 1
FixedAssetGroup FixedAssetGroup 1
Group1AssetEvaluationKey Group1AssetEvaluationKey 1
Group2AssetEvaluationKey Group2AssetEvaluationKey 1
Group3AssetEvaluationKey Group3AssetEvaluationKey 1
Group4AssetEvaluationKey Group4AssetEvaluationKey 1
Group5AssetEvaluationKey Group5AssetEvaluationKey 1
IL_AcquisitionIndexYearMonth IL_AcquisitionIndexYearMonth 1
IL_CurrentPeriodIndexYearMonth IL_CurrentPeriodIndexYearMonth 1
IL_DeactivationIndexYearMonth IL_DeactivationIndexYearMonth 1
Inventory Inventory 1
InvestmentReason InvestmentReason 1
InvestmentSupportMeasure InvestmentSupportMeasure 1
LastRetirementValueDate LastRetirementValueDate 1
OriginalAcquisitionFiscalYear OriginalAcquisitionFiscalYear 1
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods 1
PlannedUsefulLifeInYears PlannedUsefulLifeInYears 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.

-- IL AA Depreciation for Statutory Reporting - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_IL_ASSETBALANCECUBE (
    COMPANYCODE,
    FIXEDASSET,
    MASTERFIXEDASSET,
    ACQUISITIONVALUEDATE,
    ASSETACCOUNTDETERMINATION,
    ASSETADDITIONALDESCRIPTION,
    ASSETBUSINESSAREA,
    ASSETCAPITALIZATIONDATE,
    ASSETCLASS,
    ASSETCOSTCENTER,
    ASSETDEACTIVATIONDATE,
    ASSETMANUFACTURERNAME,
    DEPRECIATIONSTARTDATE,
    DISPLAYCURRENCY,
    FIXEDASSETDESCRIPTION,
    FIXEDASSETGROUP,
    GROUP1ASSETEVALUATIONKEY,
    GROUP2ASSETEVALUATIONKEY,
    GROUP3ASSETEVALUATIONKEY,
    GROUP4ASSETEVALUATIONKEY,
    GROUP5ASSETEVALUATIONKEY,
    IL_ACQUISITIONINDEXYEARMONTH,
    IL_CURRENTPERIODINDEXYEARMONTH,
    IL_DEACTIVATIONINDEXYEARMONTH,
    INVENTORY,
    INVESTMENTREASON,
    INVESTMENTSUPPORTMEASURE,
    LASTRETIREMENTVALUEDATE,
    ORIGINALACQUISITIONFISCALYEAR,
    PLANNEDUSEFULLIFEINPERIODS,
    PLANNEDUSEFULLIFEINYEARS,
    PRIMARY KEY (COMPANYCODE, FIXEDASSET, MASTERFIXEDASSET)
);

Learn More