C_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 C_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.
-- Parameters: P_KeyDate : fagl_keydate, P_AssetAccountingKeyFigureSet : faa_key_figure_set

CREATE VIEW C_FixedAssetTransaction AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  LedgerFiscalYear,
  FiscalPeriod,
  cast( AssetDepreciationArea as fis_afabe preserving type ) AS AssetDepreciationArea,
  Ledger,
  AccountingDocument,
  LedgerGLLineItem,
  TransactionSubitem,
  DebitCreditCode,
  CurrencyRole,
  SubLedgerAcctLineItemType,
  AssetAccountingKeyFigureSet,
  AssetAccountingKeyFigure,
  AssetAcctTransClassfctn,
  FiscalYear,
  LedgerGroup,
  FixedAssetExternalID,
  cast(GroupMasterFixedAsset as fis_anlgr) AS GroupMasterFixedAsset,
  cast(GroupFixedAsset as fis_anlgr2) AS GroupFixedAsset,
  ChartOfDepreciation,
  AccountingDocumentCreationDate,
  CreationTime,
  cast(PostingDate as fis_budat) AS PostingDate,
  cast (DocumentDate as fis_bldat) AS DocumentDate,
  AssetValueDate,
  AssetAuthorizationContext,
  PartnerCompanyCode,
  PartnerMasterFixedAsset,
  PartnerFixedAsset,
  AssetCapitalizationDate,
  AccountingDocCreatedByUser,
  AssetTransactionType,
  FinancialClosingStep,
  BusinessTransactionType,
  BusinessTransactionCategory,
  AssetTransactionVariant,
  AssignmentReference,
  DocumentItemText,
  ReferenceDocumentType,
  ReferenceDocument,
  LogicalSystem,
  ReferenceDocumentContext,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  ReversalTransactionSubitem,
  IsReversal,
  IsReversed,
  cast(BusinessArea as fis_gsber) AS BusinessArea,
  Segment,
  FinancialAccountType,
  ControllingArea,
  AssetClass,
  Inventory,
  AssetAccountDetermination,
  SelectedCurrencyBranch,
  DisplayCurrency,
  AmountInDisplayCurrency,
  AcqnProdnAmtInDspCrcy,
  ValueAdjustmentAmtInDspCrcy,
  RetirementRevenueAmtInDspCrcy,
  RetirementCostsAmtInDspCrcy,
  RetirementLossAmtInDspCrcy,
  RetirementGainAmtInDspCrcy,
  RetirementDeprAmtInDspCrcy,
  RetirementAmountInDspCrcy,
  RtrmtNetBookValueAmtInDspCrcy,
  OrdinaryDeprAmtInDspCrcy,
  SpecialDeprAmtInDspCrcy,
  UnplannedDeprAmtInDspCrcy,
  TransferredReserveAmtInDspCrcy,
  BaseUnit,
  Quantity,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast(FixedAssetDescription as fis_txa50_anlt) AS FixedAssetDescription,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  AssetAdditionalDescription,
  _AssetPlant.PlantName AS AssetPlantName,
  cast(AssetCostCenter as faa_kostl preserving type) AS AssetCostCenter,
  cast(AssetBusinessArea as faa_gsber preserving type) AS AssetBusinessArea,
  cast(AssetPlant as faa_werks) AS AssetPlant,
  cast(AssetProfitCenter as faa_prctr preserving type) AS AssetProfitCenter,
  cast(AssetSegment as faa_segment preserving type) AS AssetSegment,
  DepreciationKey,
  PlannedUsefulLifeInYears,
  PlannedUsefulLifeInPeriods,
  OriglAstUsefulLifeInYears,
  OriglAstUsefulLifeInPerds,
  DepreciationStartDate,
  DeprKeyChangeoverYear,
  DeprKeyChangeoverPeriod,
  VintageYear,
  VintageMonth,
  ReplacementValueIndexSers,
  RplcmtValueAgingIndexSers,
  Country,
  NationalClassification,
  TaxDepreciationGroup,
  FinancialManagementArea,
  Fund,
  GrantID,
  FunctionalArea,
  BudgetPeriod,
  AssetLocation,
  _AssetLocation.LocationName AS AssetLocationName,
  InvestmentProjectWBSElement AS WBSElementInternalID,
  cast(_OriginWBSElement.WBSElementExternalID as faa_inv_wbs_origin) AS WBSElement,
  RU_AssetOKOF,
  RU_AssetDepreciationGroup,
  JP_PrptyTxRptCity
FROM I_FixedAssetTransaction
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRolesVH AS _CurrencyRoleVH ON _CurrencyRoleVH.Ledger = Ledger AND _CurrencyRoleVH.CompanyCode = CompanyCode AND _CurrencyRoleVH.CurrencyRole = CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CompanyCodeAsset AS _CompanyCodeVH ON _CompanyCodeVH.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_DepreciationKey AS _DepreciationKeyVH ON ChartOfDepreciation = _DepreciationKeyVH.ChartOfDepreciation AND DepreciationKey = _DepreciationKeyVH.DepreciationKey  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _LedgerVH ON Ledger = _LedgerVH.Ledger  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_FiscCalendarDateForCompCode AS _FiscCalendarDateForCompCode ON PostingDate = _FiscCalendarDateForCompCode.CalendarDate AND CompanyCode = _FiscCalendarDateForCompCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalendarDateForLedger AS _FiscalCalendarDateForLedger ON PostingDate = _FiscalCalendarDateForLedger.CalendarDate AND CompanyCode = _FiscalCalendarDateForLedger.CompanyCode AND Ledger = _FiscalCalendarDateForLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _AssetCostCenterText ON ControllingArea = _AssetCostCenterText.ControllingArea AND AssetCostCenter = _AssetCostCenterText.CostCenter AND _AssetCostCenterText.ValidityStartDate <= $parameters.P_KeyDate AND _AssetCostCenterText.ValidityEndDate >= $parameters.P_KeyDate AND _AssetCostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _AssetProfitCenterText ON ControllingArea = _AssetProfitCenterText.ControllingArea AND AssetProfitCenter = _AssetProfitCenterText.ProfitCenter AND _AssetProfitCenterText.ValidityStartDate <= $parameters.P_KeyDate AND _AssetProfitCenterText.ValidityEndDate >= $parameters.P_KeyDate AND _AssetProfitCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusTransactionTypeText AS _BusinessTransactionTypeText ON BusinessTransactionType = _BusinessTransactionTypeText.BusinessTransactionType  -- association [0..*]
LEFT OUTER JOIN I_BusTransactionCategoryText AS _BusinessTransactionCatText ON BusinessTransactionCategory = _BusinessTransactionCatText.BusinessTransactionCategory  -- association [0..*]
;