I_IN_FixedAssetTransaction

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 I_IN_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.
-- SQL view name: IINFASSETTRANS
-- Parameters: P_AssetAccountingKeyFigureSet : faa_key_figure_set

CREATE VIEW I_IN_FixedAssetTransaction AS
SELECT
  fav.CompanyCode AS CompanyCode,
  fav.AssetDepreciationArea AS AssetDepreciationArea,
  fav.MasterFixedAsset AS MasterFixedAsset,
  fav.FixedAsset AS FixedAsset,
  fav.AccountingDocument AS AccountingDocument,
  fav.Ledger AS Ledger,
  fav.FiscalYear AS FiscalYear,
  fav.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  fav.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  fav.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  fav.ChartOfDepreciation AS ChartOfDepreciation,
  fav.DocumentDate AS DocumentDate,
  fav.PostingDate AS PostingDate,
  fav.AssetValueDate AS AssetValueDate,
  fav.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  fav.CompanyCodeCurrency AS CompanyCodeCurrency,
  fav.AssetCapitalizationDate AS AssetCapitalizationDate,
  fav.AssetDeactivationDate AS AssetDeactivationDate,
  fav.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  fav.PartnerFixedAsset AS PartnerFixedAsset,
  ttype.AssetTransactionTypeGroup AS AssetTransactionTypeGroup
FROM I_FixedAssetValue
INNER JOIN I_IN_TransactionType AS ttype ON /* join condition not captured in parsed metadata */
;