I_FxdAstLineItemWithCrcyRole

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_FxdAstLineItemWithCrcyRole.
-- 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.

CREATE VIEW I_FxdAstLineItemWithCrcyRole AS
SELECT
  I_FixedAssetLineItem.CompanyCode AS CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  FiscalYear,
  FiscalPeriod,
  SubLedgerAcctLineItemType,
  AssetDepreciationArea,
  I_FixedAssetLineItem.LedgerGroup AS LedgerGroup,
  I_FixedAssetLineItem.Ledger AS Ledger,
  AccountingDocument,
  TransactionSubitem,
  DebitCreditCode,
  LedgerFiscalYear,
  I_FixedAssetLineItem.FiscalYearVariant AS FiscalYearVariant,
  FiscalYearPeriod,
  _LedgerGroupAssignment[1: IsRepresentativeLedger = 'X'].Ledger AS RepresentativeLedger,
  ChartOfAccounts,
  I_FixedAssetLineItem.AccountingPrinciple AS AccountingPrinciple,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  ChartOfDepreciation,
  AssetValueDate,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  AssignmentReference,
  GLBusinessTransactionType,
  DocumentItemText,
  AccountingDocumentItem,
  ReferenceDocumentType,
  ReferenceDocument,
  LogicalSystem,
  ReferenceDocumentContext,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  ReversalTransactionSubitem,
  IsReversal,
  IsReversed,
  BusinessArea,
  ProfitCenter,
  Segment,
  FinancialAccountType,
  AccountingDocumentCreationDate,
  CreationTime,
  PostingDate,
  DocumentDate,
  DepreciationFiscalPeriod,
  AccountingDocCreatedByUser,
  IsStatisticalDocument,
  ControllingArea,
  FinancialManagementArea,
  Fund,
  GrantID,
  FunctionalArea,
  BudgetPeriod,
  PurchasingDocument,
  PurchasingDocumentItem,
  CompanyCodeCurrency,
  LedgerCompanyCodeCrcyRole.CompanyCodeCurrencyRole AS CompanyCodeCurrencyRole,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  LedgerCompanyCodeCrcyRole.GlobalCurrencyRole AS GlobalCurrencyRole,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role,
  AmountInFreeDefinedCurrency8,
  BaseUnit,
  Quantity,
  I_FixedAssetLineItem._CompanyCode AS _CompanyCode,
  I_FixedAssetLineItem._Ledger AS _Ledger,
  I_FixedAssetLineItem._AccountingPrinciple AS _AccountingPrinciple,
  I_FixedAssetLineItem._FiscalYearVariant AS _FiscalYearVariant
FROM I_FixedAssetLineItem
INNER JOIN I_LedgerCompanyCodeCrcyRoles AS LedgerCompanyCodeCrcyRole ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DepreciationAreaForLedger AS _DepreciationArea ON CompanyCode = _DepreciationArea.CompanyCode AND Ledger = _DepreciationArea.Ledger AND AssetDepreciationArea = _DepreciationArea.AssetDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_LedgerGroupAssignment AS _LedgerGroupAssignment ON LedgerGroup = _LedgerGroupAssignment.LedgerGroup  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency1 ON FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency2 ON FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency3 ON FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency4 ON FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency5 ON FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency6 ON FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency7 ON FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency8 ON FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _CompanyCodeCurrencyRole ON CompanyCodeCurrencyRole = _CompanyCodeCurrencyRole.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _GlobalCurrencyRole ON GlobalCurrencyRole = _GlobalCurrencyRole.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency1Role ON FreeDefinedCurrency1Role = _FreeDefinedCurrency1Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency2Role ON FreeDefinedCurrency2Role = _FreeDefinedCurrency2Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency3Role ON FreeDefinedCurrency3Role = _FreeDefinedCurrency3Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency4Role ON FreeDefinedCurrency4Role = _FreeDefinedCurrency4Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency5Role ON FreeDefinedCurrency5Role = _FreeDefinedCurrency5Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency6Role ON FreeDefinedCurrency6Role = _FreeDefinedCurrency6Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency7Role ON FreeDefinedCurrency7Role = _FreeDefinedCurrency7Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency8Role ON FreeDefinedCurrency8Role = _FreeDefinedCurrency8Role.CurrencyRole  -- association [0..1]
;