C_AssetDeprBalByCrcyRole

DDL: C_ASSETDEPRBALBYCRCYROLE Type: view_entity CONSUMPTION Package: FINS_FAA_MD_VALUES
22 Fields 1 Data Sources 1 OData Services

Manage Asset - Depreciation Balance by Currency Role

C_AssetDeprBalByCrcyRole is a Consumption CDS View that provides data about "Manage Asset - Depreciation Balance by Currency Role" in SAP S/4HANA. It reads from 1 data source (P_AstDeprBalWthAllAreasCube1) and exposes 22 fields with key fields AssetDepreciationArea, CompanyCode, Ledger, MasterFixedAsset, FixedAsset. It is exposed through 1 OData service (UI_FIXEDASSET_MANAGE). Part of development package FINS_FAA_MD_VALUES.

Data Sources (1)

SourceAliasJoin Type
P_AstDeprBalWthAllAreasCube1 P_AstDeprBalWthAllAreasCube1 from

Parameters (7)

NameTypeDefault
P_MasterFixedAsset anln1
P_FixedAsset anln2
P_CompanyCode bukrs
P_AssetDepreciationArea fis_afabe
P_Ledger fins_ledger
P_CurrencyRole fis_curtp
P_CreationDateTime timestampl

Annotations (9)

NameValueLevelField
AccessControl.auditFilter #ENABLED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manage Asset - Depreciation Balance by Currency Role view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
OData.applySupportedForAggregation #FULL view

OData Services (1)

ServiceBindingVersionContractRelease
UI_FIXEDASSET_MANAGE UI_FIXEDASSET_MANAGE V4 C1 NOT_RELEASED

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY AssetDepreciationArea AssetDepreciationArea Deprec. Area
KEY CompanyCode CompanyCode Receiver Company Code
KEY Ledger Ledger Ledger
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY AssetAccountingKeyFigure AssetAccountingKeyFigure
KEY DepreciationStatus DepreciationStatus
KEY AssetValuationView AssetValuationView
KEY DepreciationFiscalPeriod DepreciationFiscalPeriod Deprec. Period
FiscalYearPeriod
Currency DisplayCurrency Display Currency
OrdinaryDeprAmtInDspCrcy
OrdnryDeprOnRevalAmtInDspCrcy
SpecialDeprAmtInDspCrcy
UnplannedDeprAmtInDspCrcy
TransferredReserveAmtInDspCrcy
RevaluationAmountInDspCrcy
RevalOrdnryDeprAmtInDspCrcy
InterestAmountInDspCrcy
_FixedAsset _FixedAsset

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_AssetDeprBalByCrcyRole.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_MasterFixedAsset : anln1, P_FixedAsset : anln2, P_CompanyCode : bukrs, P_AssetDepreciationArea : fis_afabe, P_Ledger : fins_ledger, P_CurrencyRole : fis_curtp, P_CreationDateTime : timestampl

CREATE VIEW C_AssetDeprBalByCrcyRole AS
SELECT
  AssetDepreciationArea,
  CompanyCode,
  Ledger,
  MasterFixedAsset,
  FixedAsset,
  FiscalYear,
  FiscalPeriod,
  AssetAccountingKeyFigure,
  DepreciationStatus,
  AssetValuationView,
  DepreciationFiscalPeriod,
  cast(cast(concat(FiscalYear,FiscalPeriod) as char07 preserving type) as fins_fyearperiod) AS FiscalYearPeriod,
  DisplayCurrency AS Currency,
  cast(OrdinaryDeprAmtInDspCrcy as fis_ordinarydepramt preserving type) AS OrdinaryDeprAmtInDspCrcy,
  cast(OrdnryDeprOnRevalAmtInDspCrcy as fis_orddepr_on_reval_amt preserving type) AS OrdnryDeprOnRevalAmtInDspCrcy,
  cast(SpecialDeprAmtInDspCrcy as fis_specialdepramt preserving type) AS SpecialDeprAmtInDspCrcy,
  cast(UnplannedDeprAmtInDspCrcy as fis_unplanneddepramt preserving type) AS UnplannedDeprAmtInDspCrcy,
  cast(TransferredReserveAmtInDspCrcy as fis_transferedreserveamt preserving type) AS TransferredReserveAmtInDspCrcy,
  cast(RevaluationAmountInDspCrcy as fis_revaluationamt preserving type) AS RevaluationAmountInDspCrcy,
  cast(RevalOrdnryDeprAmtInDspCrcy as fis_revaluation_orddepr_amt preserving type) AS RevalOrdnryDeprAmtInDspCrcy,
  cast(InterestAmountInDspCrcy as fis_interestamt preserving type) AS InterestAmountInDspCrcy
FROM P_AstDeprBalWthAllAreasCube1
;

Learn More