P_PL_SAFTAssetRetirement10

DDL: P_PL_SAFTASSETRETIREMENT10 Type: view_entity CONSUMPTION
51 Fields 4 Data Sources

P_PL_SAFTAssetRetirement10 is a Consumption CDS View in SAP S/4HANA. It reads from 4 data sources (I_PL_SAFTAssetDepreciationArea, I_JournalEntry, I_AssetBalanceCube, I_FixedAssetForLedger) and exposes 51 fields with key fields CompanyCode, AssetDepreciationArea, MasterFixedAsset, FixedAsset, Ledger.

Data Sources (4)

SourceAliasJoin Type
I_PL_SAFTAssetDepreciationArea Area inner
I_JournalEntry Header inner
I_AssetBalanceCube I_AssetBalanceCube from
I_FixedAssetForLedger Ledger inner

Parameters (8)

NameTypeDefault
P_AssetAccountingKeyFigureSet faa_key_figure_set
P_FiscalYear fis_gjahr
P_ToFiscalPeriod fis_period_to
P_ReportingStartDate srf_rpg_period_start_date
P_ReportingEndDate srf_rpg_period_end_date
P_SelectedCurrencyBranch fis_selected_currency_branch
P_BookDepreciationAreaLedger saft_aa_pl_book_area_ledger
P_ConfigurationKeyDate fipl_sa_confign_key_date

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode Rtrmt CompanyCode Receiver Company Code
KEY AssetDepreciationArea Rtrmt AssetDepreciationArea Deprec. Area
KEY MasterFixedAsset Rtrmt MasterFixedAsset Fixed Asset
KEY FixedAsset Rtrmt FixedAsset Sub-number
KEY Ledger Rtrmt Ledger Ledger
KEY FiscalYear Rtrmt FiscalYear G/L Fiscal Year
KEY FiscalPeriod Rtrmt FiscalPeriod Tax period
KEY SubLedgerAcctLineItemType Rtrmt SubLedgerAcctLineItemType SLALineItemType
KEY AssetAcctTransClassfctn Rtrmt AssetAcctTransClassfctn Trans.Type Cat.
KEY AssetAccountingKeyFigure Rtrmt AssetAccountingKeyFigure
KEY AssetAccountingKeyFigureSet Rtrmt AssetAccountingKeyFigureSet
KEY AccountingDocument Rtrmt AccountingDocument Journal Entry
KEY TransactionSubitem Rtrmt TransactionSubitem Sub Transaction
KEY DebitCreditCode Rtrmt DebitCreditCode Single-Character Flag
AssignmentReference Rtrmt AssignmentReference Assignment Reference
DocumentItemText Rtrmt DocumentItemText Text
AssetClass Rtrmt AssetClass Asset Class
ChartOfDepreciation Rtrmt ChartOfDepreciation
AccountingDocumentType Rtrmt AccountingDocumentType Journal Entry Type
AccountingDocumentCreationDate Rtrmt AccountingDocumentCreationDate Journal Entry Date
CreationTime Rtrmt CreationTime Time of Change
CreationDateTime
PostingDate Rtrmt PostingDate Posting Date for GR
DocumentDate Rtrmt DocumentDate Journal Entry Date
AssetValueDate Rtrmt AssetValueDate Reference date
AssetTransactionType Rtrmt AssetTransactionType Trans.Type
BusinessTransactionCategory Rtrmt BusinessTransactionCategory Business Transaction Category
BusinessTransactionType Rtrmt BusinessTransactionType Bus.transaction
IsReversal Rtrmt IsReversal Reversal doc.
IsReversed Rtrmt IsReversed Reversed?
DisplayCurrency Rtrmt DisplayCurrency Display Currency
AmountInDisplayCurrency Rtrmt AmountInDisplayCurrency
AssetCapitalizationDate I_FixedAssetForLedger AssetCapitalizationDate Asset Capitalization
AssetDeactivationDate I_FixedAssetForLedger AssetDeactivationDate
AccountingDocumentHeaderText I_JournalEntry AccountingDocumentHeaderText Doc.Header Text
DocumentReferenceID I_JournalEntry DocumentReferenceID Reference
_CompanyCode Rtrmt _CompanyCode
_DepreciationArea Rtrmt _DepreciationArea
_MasterFixedAsset Rtrmt _MasterFixedAsset
_FixedAsset Rtrmt _FixedAsset
_AssetClass Rtrmt _AssetClass
_Ledger Rtrmt _Ledger
_FiscalYear Rtrmt _FiscalYear
_SubLedgerAccLineItemType Rtrmt _SubLedgerAccLineItemType
_AssetKeyFigure Rtrmt _AssetKeyFigure
_AssetKeyFigureSet Rtrmt _AssetKeyFigureSet
_ChartOfDepreciation Rtrmt _ChartOfDepreciation
_AccountingDocumentType Rtrmt _AccountingDocumentType
_AssetTransactionType Rtrmt _AssetTransactionType
_BusinessTransactionCategory Rtrmt _BusinessTransactionCategory
_BusinessTransactionType Rtrmt _BusinessTransactionType

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_PL_SAFTAssetRetirement10.
-- 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, P_FiscalYear : fis_gjahr, P_ToFiscalPeriod : fis_period_to, P_ReportingStartDate : srf_rpg_period_start_date, P_ReportingEndDate : srf_rpg_period_end_date, P_SelectedCurrencyBranch : fis_selected_currency_branch, P_BookDepreciationAreaLedger : saft_aa_pl_book_area_ledger, P_ConfigurationKeyDate : fipl_sa_confign_key_date

CREATE VIEW P_PL_SAFTAssetRetirement10 AS
SELECT
  Rtrmt.CompanyCode AS CompanyCode,
  Rtrmt.AssetDepreciationArea AS AssetDepreciationArea,
  Rtrmt.MasterFixedAsset AS MasterFixedAsset,
  Rtrmt.FixedAsset AS FixedAsset,
  Rtrmt.Ledger AS Ledger,
  Rtrmt.FiscalYear AS FiscalYear,
  Rtrmt.FiscalPeriod AS FiscalPeriod,
  Rtrmt.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  Rtrmt.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  Rtrmt.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  Rtrmt.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  Rtrmt.AccountingDocument AS AccountingDocument,
  Rtrmt.TransactionSubitem AS TransactionSubitem,
  Rtrmt.DebitCreditCode AS DebitCreditCode,
  Rtrmt.AssignmentReference AS AssignmentReference,
  Rtrmt.DocumentItemText AS DocumentItemText,
  Rtrmt.AssetClass AS AssetClass,
  Rtrmt.ChartOfDepreciation AS ChartOfDepreciation,
  Rtrmt.AccountingDocumentType AS AccountingDocumentType,
  Rtrmt.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  Rtrmt.CreationTime AS CreationTime,
  concat(Rtrmt.AccountingDocumentCreationDate, Rtrmt.CreationTime) AS CreationDateTime,
  Rtrmt.PostingDate AS PostingDate,
  Rtrmt.DocumentDate AS DocumentDate,
  Rtrmt.AssetValueDate AS AssetValueDate,
  Rtrmt.AssetTransactionType AS AssetTransactionType,
  Rtrmt.BusinessTransactionCategory AS BusinessTransactionCategory,
  Rtrmt.BusinessTransactionType AS BusinessTransactionType,
  Rtrmt.IsReversal AS IsReversal,
  Rtrmt.IsReversed AS IsReversed,
  Rtrmt.DisplayCurrency AS DisplayCurrency,
  Rtrmt.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  Ledger.AssetCapitalizationDate AS AssetCapitalizationDate,
  Ledger.AssetDeactivationDate AS AssetDeactivationDate,
  Header.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  Header.DocumentReferenceID AS DocumentReferenceID,
  Rtrmt._CompanyCode AS _CompanyCode,
  Rtrmt._DepreciationArea AS _DepreciationArea,
  Rtrmt._MasterFixedAsset AS _MasterFixedAsset,
  Rtrmt._FixedAsset AS _FixedAsset,
  Rtrmt._AssetClass AS _AssetClass,
  Rtrmt._Ledger AS _Ledger,
  Rtrmt._FiscalYear AS _FiscalYear,
  Rtrmt._SubLedgerAccLineItemType AS _SubLedgerAccLineItemType,
  Rtrmt._AssetKeyFigure AS _AssetKeyFigure,
  Rtrmt._AssetKeyFigureSet AS _AssetKeyFigureSet,
  Rtrmt._ChartOfDepreciation AS _ChartOfDepreciation,
  Rtrmt._AccountingDocumentType AS _AccountingDocumentType,
  Rtrmt._AssetTransactionType AS _AssetTransactionType,
  Rtrmt._BusinessTransactionCategory AS _BusinessTransactionCategory,
  Rtrmt._BusinessTransactionType AS _BusinessTransactionType
FROM I_AssetBalanceCube
INNER JOIN I_FixedAssetForLedger AS Ledger ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntry AS Header ON /* join condition not captured in parsed metadata */
INNER JOIN I_PL_SAFTAssetDepreciationArea AS Area ON /* join condition not captured in parsed metadata */
;

Learn More