P_FixedAssetTransaction2

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_FixedAssetTransaction2.
-- 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_FixedAssetTransaction2 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.FiscalPeriod AS FiscalPeriod,
  Values.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  Values.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  AssetKeyFigureSetSpec.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  AssetKeyFigureSetSpec.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  Values.AccountingDocument AS AccountingDocument,
  Values.LedgerGLLineItem AS LedgerGLLineItem,
  Values.TransactionSubitem AS TransactionSubitem,
  Values.DebitCreditCode AS DebitCreditCode,
  Values.ChartOfDepreciation AS ChartOfDepreciation,
  Values.ControllingArea AS ControllingArea,
  Values.Country AS Country,
  Values.FinancialManagementArea AS FinancialManagementArea,
  Values.FiscalYearVariant AS FiscalYearVariant,
  Values.LedgerFiscalYear AS LedgerFiscalYear,
  Values.FiscalYearPeriod AS FiscalYearPeriod,
  Values.LedgerGroup AS LedgerGroup,
  Values.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  Values.GroupFixedAsset AS GroupFixedAsset,
  Values.PartnerCompanyCode AS PartnerCompanyCode,
  Values.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  Values.PartnerFixedAsset AS PartnerFixedAsset,
  Values.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  Values.CreationTime AS CreationTime,
  Values.PostingDate AS PostingDate,
  Values.DocumentDate AS DocumentDate,
  Values.AssetValueDate AS AssetValueDate,
  Values.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  Values.FinancialClosingStep AS FinancialClosingStep,
  Values.BusinessTransactionType AS BusinessTransactionType,
  Values.BusinessTransactionCategory AS BusinessTransactionCategory,
  Values.AssetTransactionType AS AssetTransactionType,
  Values.AssignmentReference AS AssignmentReference,
  Values.DocumentItemText AS DocumentItemText,
  Values.ReferenceDocumentType AS ReferenceDocumentType,
  Values.ReferenceDocument AS ReferenceDocument,
  Values.LogicalSystem AS LogicalSystem,
  Values.ReferenceDocumentContext AS ReferenceDocumentContext,
  Values.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  Values.ReversalReferenceDocument AS ReversalReferenceDocument,
  Values.ReversalTransactionSubitem AS ReversalTransactionSubitem,
  Values.IsReversal AS IsReversal,
  Values.IsReversed AS IsReversed,
  Values.BusinessArea AS BusinessArea,
  Values.Segment AS Segment,
  Values.FinancialAccountType AS FinancialAccountType,
  Values.Fund AS Fund,
  Values.GrantID AS GrantID,
  Values.FunctionalArea AS FunctionalArea,
  Values.BudgetPeriod AS BudgetPeriod,
  Values.IsStatisticalDocument AS IsStatisticalDocument,
  Values.CompanyCodeCurrency AS CompanyCodeCurrency,
  Values.GlobalCurrency AS GlobalCurrency,
  Values.FunctionalCurrency AS FunctionalCurrency,
  Values.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  Values.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  Values.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  Values.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  Values.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  Values.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  Values.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  Values.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  Values.BaseUnit AS BaseUnit,
  Values.Quantity AS Quantity,
  Values.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Values.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  Values.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  Values.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  Values.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  Values.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  Values.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  Values.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  Values.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  Values.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  Values.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  LedgerCompanyCodeCrcyRole.CompanyCodeCurrencyRole AS CompanyCodeCurrencyRole,
  LedgerCompanyCodeCrcyRole.GlobalCurrencyRole AS GlobalCurrencyRole,
  LedgerCompanyCodeCrcyRole.FunctionalCurrencyRole AS FunctionalCurrencyRole,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role
FROM I_LedgerCompanyCodeCrcyRoles AS LedgerCompanyCodeCrcyRole
INNER JOIN I_FixedAssetLineItem AS Values ON /* join condition not captured in parsed metadata */
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 */
;