P_AUDIT_AT_AstTransByKeyFigs

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_AstTransByKeyFigs.
-- 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: PAUDITATATBYKF
-- Parameters: P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_poper, P_KeyDate : fagl_keydate

CREATE VIEW P_AUDIT_AT_AstTransByKeyFigs AS
SELECT
  CompanyCode,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  Ledger,
  FiscalYear,
  AssetAccountingKeyFigure,
  AssetAccountingKeyFigureSet,
  AccountingDocument,
  CurrencyRole,
  SubLedgerAcctLineItemType,
  TransactionSubitem,
  FiscalPeriod,
  DebitCreditCode,
  LedgerGroup,
  FiscalYearVariant,
  LedgerFiscalYear,
  _FixedAssetLineItem.PostingDate AS PostingDate,
  _FixedAssetLineItem.AssetValueDate AS AssetValueDate,
  _FixedAssetLineItem.DocumentItemText AS DocumentItemText,
  _FixedAssetLineItem.ReferenceDocument AS ReferenceDocument,
  _FixedAssetLineItem.Quantity AS Quantity,
  BaseUnit,
  _AssetSortedKeyFigureSetSpec.AssetAcctgKeyFigureSortSqnc AS AssetAcctgKeyFigureSortSqnc,
  AssetAuthorizationContext,
  AssetClass,
  AssetAccountDetermination,
  ChartOfAccounts,
  _BalanceSheetAccount.AcqnProdnCostGLAccount AS AcqnProdnCostGLAccount,
  SelectedCurrencyBranch,
  DisplayCurrency,
  sum(AmountInDisplayCurrency) AS AmountInDisplayCurrency
FROM I_AssetBalanceCube
LEFT OUTER JOIN I_AssetBalanceSheetAccount AS _BalanceSheetAccount ON CompanyCode = _BalanceSheetAccount.CompanyCode AND AssetAccountDetermination = _BalanceSheetAccount.AssetAccountDetermination AND AssetDepreciationArea = _BalanceSheetAccount.AssetRealDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _AcqnProdnCostGLAccount ON ChartOfAccounts = _AcqnProdnCostGLAccount.ChartOfAccounts AND AcqnProdnCostGLAccount = _AcqnProdnCostGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetLineItem AS _FixedAssetLineItem ON AssetDepreciationArea = _FixedAssetLineItem.AssetDepreciationArea AND CompanyCode = _FixedAssetLineItem.CompanyCode AND FiscalYear = _FixedAssetLineItem.FiscalYear AND MasterFixedAsset = _FixedAssetLineItem.MasterFixedAsset AND FixedAsset = _FixedAssetLineItem.FixedAsset AND SubLedgerAcctLineItemType = _FixedAssetLineItem.SubLedgerAcctLineItemType AND FiscalPeriod = _FixedAssetLineItem.FiscalPeriod AND LedgerGroup = _FixedAssetLineItem.LedgerGroup AND AccountingDocument = _FixedAssetLineItem.AccountingDocument AND Ledger = _FixedAssetLineItem.Ledger AND TransactionSubitem = _FixedAssetLineItem.TransactionSubitem AND DebitCreditCode = _FixedAssetLineItem.DebitCreditCode  -- association [0..1]
;