I_FixedAssetSimulationPosting

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_FixedAssetSimulationPosting.
-- 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_FixedAssetSimulationPosting AS
SELECT
  posting_uuid AS FixedAssetPostingUUID,
  awitem AS ReferenceDocumentItem,
  _FixedAssetPosting.CompanyCode AS CompanyCode,
  Ledger,
  depr_area AS AssetDepreciationArea,
  fisc_year AS FiscalYear,
  slalittype AS SubLedgerAcctLineItemType,
  subta AS TransactionSubitem,
  posnr AS AccountingDocumentItemRef,
  awtyp AS ReferenceDocumentType,
  awref AS ReferenceDocument,
  aworg AS ReferenceDocumentContext,
  awsys AS LogicalSystem,
  vorgn AS GLBusinessTransactionType,
  racct AS GLAccount,
  budat AS PostingDate,
  bzdat AS AssetValueDate,
  bldat AS DocumentDate,
  poper AS FiscalPeriod,
  drcrk AS DebitCreditCode,
  koart AS FinancialAccountType,
  Quantity,
  base_unit AS BaseUnit,
  depr_period AS DepreciationFiscalPeriod,
  movcat AS AssetAcctTransClassfctn,
  anlkl AS AssetClass,
  ktogr AS AssetAccountDetermination,
  panl1 AS PartnerMasterFixedAsset,
  panl2 AS PartnerFixedAsset,
  glvor AS BusinessTransactionType,
  cast( awitgrp as fis_awitgrp preserving type ) AS ReferenceDocumentItemGroup,
  buzei AS AccountingDocumentItem,
  xreversing AS IsReversal,
  xreversed AS IsReversed,
  xsettling AS IsSettlement,
  xsettled AS IsSettled,
  cast( prec_awtyp as fis_prec_awtyp preserving type ) AS PredecessorReferenceDocType,
  cast( prec_aworg as fis_prec_aworg preserving type ) AS PredecessorReferenceDocCntxt,
  cast( prec_awref as fis_prec_awref preserving type ) AS PredecessorReferenceDocument,
  cast( aworg_rev as fis_aworg_rev preserving type ) AS ReversalReferenceDocumentCntxt,
  cast( awref_rev as fis_awref_rev preserving type ) AS ReversalReferenceDocument,
  subta_rev AS ReversalTransactionSubitem,
  ref_doc_nr AS DocumentReferenceID,
  item_text AS DocumentItemText,
  trading_partner AS TradingPartner,
  alloc_nmbr AS AssignmentReference,
  offset_account AS OffsettingAccount,
  kunnr AS Customer,
  lifnr AS Supplier,
  fkber AS FunctionalArea,
  kokrs AS ControllingArea,
  kostl AS CostCenter,
  lstar AS CostCtrActivityType,
  aufnr AS OrderID,
  prctr AS ProfitCenter,
  Segment,
  pprctr AS PartnerProfitCenter,
  Fund,
  grant_id AS GrantID,
  posting_type AS AssetGLPostingMethod,
  rtcur AS BalanceTransactionCurrency,
  tsl AS AmountInBalanceTransacCrcy,
  rwcur AS TransactionCurrency,
  wsl AS AmountInTransactionCurrency,
  rhcur AS CompanyCodeCurrency,
  hsl AS AmountInCompanyCodeCurrency,
  rkcur AS GlobalCurrency,
  ksl AS AmountInGlobalCurrency,
  rfccur AS FunctionalCurrency,
  fcsl AS AmountInFunctionalCurrency,
  rocur AS FreeDefinedCurrency1,
  osl AS AmountInFreeDefinedCurrency1,
  rvcur AS FreeDefinedCurrency2,
  vsl AS AmountInFreeDefinedCurrency2,
  cast( rbcur as fis_curr3 preserving type ) AS FreeDefinedCurrency3,
  bsl AS AmountInFreeDefinedCurrency3,
  cast( rccur as fis_curr4 preserving type ) AS FreeDefinedCurrency4,
  csl AS AmountInFreeDefinedCurrency4,
  cast( rdcur as fis_curr5 preserving type ) AS FreeDefinedCurrency5,
  dsl AS AmountInFreeDefinedCurrency5,
  cast( recur as fis_curr6 preserving type ) AS FreeDefinedCurrency6,
  esl AS AmountInFreeDefinedCurrency6,
  rfcur AS FreeDefinedCurrency7,
  fsl AS AmountInFreeDefinedCurrency7,
  cast( rgcur as fis_curr8 preserving type ) AS FreeDefinedCurrency8,
  gsl AS AmountInFreeDefinedCurrency8,
  _FixedAssetPosting._CompanyCode AS _CompanyCode
FROM faat_tr_simdoc
LEFT OUTER JOIN I_FixedAssetPosting AS _FixedAssetPosting ON FixedAssetPostingUUID = _FixedAssetPosting.FixedAssetPostingUUID AND ReferenceDocumentItem = _FixedAssetPosting.ReferenceDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _BalanceTransactionCurrency ON BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _FunctionalCurrency ON FunctionalCurrency = _FunctionalCurrency.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_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_DepreciationArea AS _DepreciationArea ON CompanyCode = _DepreciationArea.CompanyCode AND Ledger = _DepreciationArea.Ledger AND AssetDepreciationArea = _DepreciationArea.AssetDepreciationArea  -- association [1..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _SubLedgerAccLineItemType ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType  -- association [1..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger AND _LedgerText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DeprAreaForLedgerText AS _DepreciationAreaText ON CompanyCode = _DepreciationAreaText.CompanyCode AND Ledger = _DepreciationAreaText.Ledger AND AssetDepreciationArea = _DepreciationAreaText.AssetDepreciationArea AND _DepreciationAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemTypeT AS _SubLedgerAccLineItemTypeText ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemTypeText.SubLedgerAcctLineItemType AND _SubLedgerAccLineItemTypeText.Language = $session.system_language  -- association [0..1]
;