P_AUDIT_AT_AssetTransaction

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_AUDIT_AT_AssetTransaction.
-- 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: PAUDITATASTTRANS
-- Parameters: P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_CompanyCode : fis_bukrs, P_Ledger : fis_rldnr, P_AssetDepreciationArea : fis_afabe, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_period_to, P_FiscalPeriodEndDate : fagl_keydate, P_SelectedCurrencyBranch : fis_curtp

CREATE VIEW P_AUDIT_AT_AssetTransaction AS
SELECT
  Values.CompanyCode AS CompanyCode,
  Values.AssetDepreciationArea AS AssetDepreciationArea,
  Values.MasterFixedAsset AS MasterFixedAsset,
  Values.FixedAsset AS FixedAsset,
  Values.Ledger AS Ledger,
  Values.FiscalYear AS FiscalYear,
  Values.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  Values.AccountingDocument AS AccountingDocument,
  Values.CurrencyRole AS CurrencyRole,
  Values.AssetAuthorizationContext AS AssetAuthorizationContext,
  Values.AssetClass AS AssetClass,
  Values._AssetClass._Text[1: Language = $session.system_language].AssetClassName AS AssetClassName,
  Values._AssetClass._Text[1: Language = $session.system_language].AssetClassDescription AS AssetClassDescription,
  Values._MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  Values._FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  Values._FixedAsset.AssetAdditionalDescription AS AssetAdditionalDescription,
  Values.BaseUnit AS BaseUnit,
  FixedAssetForLedger.AssetCapitalizationDate AS AssetCapitalizationDate,
  FixedAssetForLedger.AssetDeactivationDate AS AssetDeactivationDate,
  Values.AssetAccountDetermination AS AssetAccountDetermination,
  Values.ChartOfAccounts AS ChartOfAccounts,
  Values.AcqnProdnCostGLAccount AS AcqnProdnCostGLAccount,
  _AcqnProdnCostGLAccount._Text[1: Language = $session.system_language].GLAccountName AS APCGLAccountDescription,
  Values.PostingDate AS PostingDate,
  Values.AssetValueDate AS AssetValueDate,
  Values.DocumentItemText AS DocumentItemText,
  FixedAssetAssgmt.ReferenceDocument AS ReferenceDocument,
  Values.Quantity AS Quantity,
  Values.SelectedCurrencyBranch AS SelectedCurrencyBranch,
  Values.DisplayCurrency AS DisplayCurrency,
  Values.AmountInDisplayCurrency1 AS AmountInDisplayCurrency1,
  Values.AmountInDisplayCurrency2 AS AmountInDisplayCurrency2,
  Values.AmountInDisplayCurrency3 AS AmountInDisplayCurrency3,
  Values.AmountInDisplayCurrency4 AS AmountInDisplayCurrency4,
  Values.AmountInDisplayCurrency5 AS AmountInDisplayCurrency5,
  Values.AmountInDisplayCurrency6 AS AmountInDisplayCurrency6,
  Values.AmountInDisplayCurrency7 AS AmountInDisplayCurrency7,
  Values.AmountInDisplayCurrency8 AS AmountInDisplayCurrency8,
  Values.AmountInDisplayCurrency9 AS AmountInDisplayCurrency9,
  Values.AmountInDisplayCurrency10 AS AmountInDisplayCurrency10,
  Values.AmountInDisplayCurrency11 AS AmountInDisplayCurrency11,
  Values.AmountInDisplayCurrency12 AS AmountInDisplayCurrency12,
  Values.AmountInDisplayCurrency13 AS AmountInDisplayCurrency13,
  Values.AmountInDisplayCurrency14 AS AmountInDisplayCurrency14,
  Values.AmountInDisplayCurrency15 AS AmountInDisplayCurrency15,
  Values.AmountInDisplayCurrency16 AS AmountInDisplayCurrency16,
  Values.AmountInDisplayCurrency17 AS AmountInDisplayCurrency17,
  Values.AmountInDisplayCurrency18 AS AmountInDisplayCurrency18,
  Values.AmountInDisplayCurrency19 AS AmountInDisplayCurrency19,
  Values.AmountInDisplayCurrency20 AS AmountInDisplayCurrency20,
  Values.AmountInDisplayCurrency21 AS AmountInDisplayCurrency21,
  Values.AmountInDisplayCurrency22 AS AmountInDisplayCurrency22,
  Values.AmountInDisplayCurrency23 AS AmountInDisplayCurrency23,
  Values._CompanyCode AS _CompanyCode,
  Values._DepreciationArea AS _DepreciationArea,
  Values._MasterFixedAsset AS _MasterFixedAsset,
  Values._FixedAsset AS _FixedAsset,
  Values._Ledger AS _Ledger,
  Values._FiscalYear AS _FiscalYear,
  Values._AssetKeyFigureSet AS _AssetKeyFigureSet,
  Values._JournalEntry AS _JournalEntry,
  Values._CurrencyRole AS _CurrencyRole,
  Values._AssetClass AS _AssetClass,
  Values._AssetAccountDetermination AS _AssetAccountDetermination,
  Values._ChartOfAccounts AS _ChartOfAccounts,
  Values._AcqnProdnCostGLAccount AS _AcqnProdnCostGLAccount,
  Values._SelectedCurrencyBranch AS _SelectedCurrencyBranch,
  Values._UnitOfMeasure AS _UnitOfMeasure
FROM P_AUDIT_AT_AstTransToKeyFigs
LEFT OUTER JOIN I_FixedAssetAssgmt AS FixedAssetAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FixedAssetForLedger AS FixedAssetForLedger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AssetValuationForLedger AS AssetValuationForLedger ON /* join condition not captured in parsed metadata */
;