I_ASSETBALANCECUBE

CDS View

Asset Balances - Cube

I_ASSETBALANCECUBE is a CDS View in S/4HANA. Asset Balances - Cube. It contains 3 fields. 31 CDS views read from this table.

CDS Views using this table (31)

ViewTypeJoinVDMDescription
C_AssetBalance view from CONSUMPTION Asset Balances
C_AT_StRpAuditAssetTransacQ view from CONSUMPTION Austrian Audit Asset Transaction Query
C_BG_StRpTaxDeprTransCube view from CONSUMPTION Tax depreciation plan trans - Cube
C_GB_StRpFxdAstRevalRsrvCube view from CONSUMPTION GB Asset Revaluation Reserves - Cube
C_LU_StRpFxdAstApndxAcqnCube view from CONSUMPTION Fixed Ast Appendix Acquisitions - Cube
C_LU_StRpFxdAstApndxDeprCube view from CONSUMPTION Fixed Ast Appendix Depreciation - Cube
C_PL_SAFTFixedAssetValueCube view_entity from CONSUMPTION PL SAFT Fixed Asset Values - Cube
C_RO_SAFTFixedAssetCube view inner CONSUMPTION RO SAFT Fixed Asset - Cube
C_RO_SAFTFixedAssetTransCube view from CONSUMPTION RO SAFT Fixed Asset Transaction - Cube
C_StRpFxdAssetAcquisitionFormC view from CONSUMPTION Fixed Asset Acquisition Form Cube
C_StRpFxdAssetLocTransferFormC view inner CONSUMPTION Fixed Asset Location Transfer Form Cube
C_StRpFxdAstRetirementFormCube view from CONSUMPTION Fixed Asset Retirement Form Cube
I_AssetBalanceOverview view from COMPOSITE Asset Balance Overview
I_AstDeprValInCurPeriod view from COMPOSITE Asset Depreciation Value In Current Period
I_AstPlndDeprInCurPeriod view from COMPOSITE Asset Planned Depreciation In Current Period
I_CN_CADEFixedAssetValueCube view left_outer COMPOSITE Fixed Asset Balance Cube for CADE
I_IL_AssetBalanceCube view_entity from COMPOSITE IL AA Depreciation for Statutory Reporting - Cube
I_IL_SumPostdDeprAmtPerAstC view_entity from COMPOSITE IL AA Posted Depreciation Amount of KFC 0007700500 - Cube
I_SG_CapitalAllowanceCube view from COMPOSITE Singapore CA Report - Cube
I_TH_AssetDepreciationCube view from COMPOSITE Cube View for Thailand Depreciation List
P_AssetBalanceOverview view from COMPOSITE
P_AstPlndDeprInCurPeriod view from COMPOSITE
P_AT_AssetBalanceCube view_entity from CONSUMPTION
P_AUDIT_AT_AstTransByKeyFigs view from COMPOSITE
P_BG_StRpFixedAssetReport view from CONSUMPTION Fixed Asset Report - Fixed Asset Fields
P_BG_StRpTaxDeprValue view from CONSUMPTION Tax depreciation plan values
P_JP_FIXEDASSETVALUE view from CONSUMPTION Summarization of Company code Currency
P_PE_AssetValuationAggrgd view_entity from CONSUMPTION
P_PL_SAFTAssetRetirement10 view_entity from CONSUMPTION
P_RS_TaxGroupDepreciation view inner COMPOSITE
P_RS_TaxIndivDeprKeyFigure view inner COMPOSITE

Fields (3)

KeyField CDS FieldsUsed in Views
AcquisitionValueDate AcquisitionValueDate 1
AssetCapitalizationDate AssetCapitalizationDate 1
AssetDeactivationDate AssetDeactivationDate 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.

-- Asset Balances - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ASSETBALANCECUBE (
    ACQUISITIONVALUEDATE,
    ASSETCAPITALIZATIONDATE,
    ASSETDEACTIVATIONDATE
);