P_FixedAssetDepreciationListKF

DDL: P_FIXEDASSETDEPRECIATIONLISTKF SQL: PFASSETDPRLISTKF Type: view COMPOSITE
22 Fields 4 Data Sources

P_FixedAssetDepreciationListKF is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_AssetKeyFigureSet, I_AssetKeyFigureSetSpec, I_AssetKeyFigureSpecification, P_FxdAstValueWithCurrencyRole) and exposes 22 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, FiscalYear, FiscalPeriod.

Data Sources (4)

SourceAliasJoin Type
I_AssetKeyFigureSet KeyFigureSet inner
I_AssetKeyFigureSetSpec KeyFigureSetSpec inner
I_AssetKeyFigureSpecification KeyFigureSpec inner
P_FxdAstValueWithCurrencyRole Values from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PFASSETDPRLISTKF view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY AssetDepreciationArea AssetDepreciationArea Deprec. Area
KEY Ledger Ledger Ledger
KEY CurrencyRole CurrencyRole Curr./Val. Type
KEY SubLedgerAcctLineItemType P_FxdAstValueWithCurrencyRole SubLedgerAcctLineItemType SLALineItemType
KEY AssetAcctTransClassfctn P_FxdAstValueWithCurrencyRole AssetAcctTransClassfctn Trans.Type Cat.
KEY AssetAccountingKeyFigureSet I_AssetKeyFigureSetSpec AssetAccountingKeyFigureSet Key Figure Group
KEY AssetAccountingKeyFigure I_AssetKeyFigureSetSpec AssetAccountingKeyFigure Key Figure
LedgerGroup LedgerGroup Ledger Group
GroupMasterFixedAsset GroupMasterFixedAsset
GroupFixedAsset GroupFixedAsset
ChartOfDepreciation ChartOfDepreciation
FinancialManagementArea FinancialManagementArea FM Area
Fund Fund Sender Fund
GrantID GrantID Sender Grant
FunctionalArea FunctionalArea Sendr Fctl Area
BudgetPeriod BudgetPeriod Budget Period
DisplayCurrency DisplayCurrency Display Currency

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 P_FixedAssetDepreciationListKF.
-- 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.
-- SQL view name: PFASSETDPRLISTKF

CREATE VIEW P_FixedAssetDepreciationListKF AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  FiscalYear,
  FiscalPeriod,
  AssetDepreciationArea,
  Ledger,
  CurrencyRole,
  Values.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  Values.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  KeyFigureSetSpec.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  KeyFigureSetSpec.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  LedgerGroup,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  ChartOfDepreciation,
  FinancialManagementArea,
  Fund,
  GrantID,
  FunctionalArea,
  BudgetPeriod,
  DisplayCurrency
FROM P_FxdAstValueWithCurrencyRole AS Values
INNER JOIN I_AssetKeyFigureSpecification AS KeyFigureSpec ON /* join condition not captured in parsed metadata */
INNER JOIN I_AssetKeyFigureSetSpec AS KeyFigureSetSpec ON /* join condition not captured in parsed metadata */
INNER JOIN I_AssetKeyFigureSet AS KeyFigureSet ON /* join condition not captured in parsed metadata */
;

Learn More