P_FixedAssetTransaction

DDL: P_FIXEDASSETTRANSACTION Type: view COMPOSITE
51 Fields 3 Data Sources

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

Data Sources (3)

SourceAliasJoin Type
I_AssetKeyFigureSetSpec AssetKeyFigureSetSpec inner
I_AssetKeyFigureSpecification AssetKeyFigureSpec inner
P_FxdAstValueWithCurrencyRole P_FxdAstValueWithCurrencyRole from

Parameters (1)

NameTypeDefault
P_AssetAccountingKeyFigureSet faa_key_figure_set

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFASSETTRAN view
AbapCatalog.preserveKey true 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 (51)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_FxdAstValueWithCurrencyRole 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 LedgerGroup LedgerGroup Ledger Group
KEY Ledger Ledger Ledger
KEY AccountingDocument AccountingDocument Journal Entry
KEY TransactionSubitem TransactionSubitem Sub Transaction
KEY DebitCreditCode DebitCreditCode Single-Character Flag
KEY CurrencyRole CurrencyRole Curr./Val. Type
KEY SubLedgerAcctLineItemType P_FxdAstValueWithCurrencyRole SubLedgerAcctLineItemType SLALineItemType
LedgerFiscalYear LedgerFiscalYear
FiscalYearVariant FiscalYearVariant FY Variant
FiscalYearPeriod FiscalYearPeriod Period/Year
AssetAccountingKeyFigure I_AssetKeyFigureSpecification AssetAccountingKeyFigure Key Figure
GroupMasterFixedAsset GroupMasterFixedAsset
GroupFixedAsset GroupFixedAsset
ChartOfDepreciation ChartOfDepreciation
AccountingDocumentCreationDate AccountingDocumentCreationDate Journal Entry Date
CreationTime CreationTime Time of Change
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
AssetValueDate AssetValueDate Reference date
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
AssetTransactionType AssetTransactionType Trans.Type
AssetAcctTransClassfctn AssetAcctTransClassfctn Trans.Type Cat.
AssignmentReference AssignmentReference Assignment Reference
DocumentItemText DocumentItemText Text
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocument ReferenceDocument Reference Document
LogicalSystem LogicalSystem Logical System
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReversalReferenceDocument ReversalReferenceDocument Reversal Reference Document
ReversalTransactionSubitem ReversalTransactionSubitem Reversal Sub Trans
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
BusinessArea BusinessArea Business Area
Segment Segment Segment number
FinancialAccountType FinancialAccountType Fin. Account Type
ControllingArea ControllingArea Controlling Area
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
AmountInDisplayCurrency AmountInDisplayCurrency
IsStatisticalDocument IsStatisticalDocument

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_FixedAssetTransaction.
-- 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_AssetAccountingKeyFigureSet : faa_key_figure_set

CREATE VIEW P_FixedAssetTransaction AS
SELECT
  P_FxdAstValueWithCurrencyRole.CompanyCode AS CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  FiscalYear,
  FiscalPeriod,
  AssetDepreciationArea,
  LedgerGroup,
  Ledger,
  AccountingDocument,
  TransactionSubitem,
  DebitCreditCode,
  CurrencyRole,
  P_FxdAstValueWithCurrencyRole.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  LedgerFiscalYear,
  FiscalYearVariant,
  FiscalYearPeriod,
  AssetKeyFigureSpec.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  ChartOfDepreciation,
  AccountingDocumentCreationDate,
  CreationTime,
  PostingDate,
  DocumentDate,
  AssetValueDate,
  AccountingDocCreatedByUser,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  AssignmentReference,
  DocumentItemText,
  ReferenceDocumentType,
  ReferenceDocument,
  LogicalSystem,
  ReferenceDocumentContext,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  ReversalTransactionSubitem,
  IsReversal,
  IsReversed,
  BusinessArea,
  Segment,
  FinancialAccountType,
  ControllingArea,
  FinancialManagementArea,
  Fund,
  GrantID,
  FunctionalArea,
  BudgetPeriod,
  DisplayCurrency,
  AmountInDisplayCurrency,
  IsStatisticalDocument
FROM P_FxdAstValueWithCurrencyRole
INNER JOIN I_AssetKeyFigureSetSpec AS AssetKeyFigureSetSpec ON /* join condition not captured in parsed metadata */
INNER JOIN I_AssetKeyFigureSpecification AS AssetKeyFigureSpec ON /* join condition not captured in parsed metadata */
;

Learn More