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,
  ChartOfDepreciation,
  AccountingDocumentCreationDate,
  CreationTime,
  cast(PostingDate as fis_budat) AS PostingDate,
  cast (DocumentDate as fis_bldat) AS DocumentDate,
  AssetValueDate,
  AssetAuthorizationContext,
  PartnerCompanyCode,
  PartnerMasterFixedAsset,
  PartnerFixedAsset,
  AssetCapitalizationDate,
  AcquisitionValueDate,
  FirstAcquisitionFiscalYear,
  FirstAcquisitionFiscalPeriod,
  AccountingDocCreatedByUser,
  AssetTransactionType,
  FinancialClosingStep,
  BusinessTransactionType,
  BusinessTransactionCategory,
  AssetTransactionVariant,
  AssignmentReference,
  DocumentItemText,
  ReferenceDocumentType,
  ReferenceDocument,
  ReferenceDocumentItem,
  LogicalSystem,
  ReferenceDocumentContext,
  PredecessorJournalEntry,
  PredecessorReferenceDocument,
  PredecessorReferenceDocItem,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocType,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  ReversalTransactionSubitem,
  IsReversal,
  IsReversed,
  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(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,
  JP_PrptyTxRptClassfctnKey,
  cast( _AssetClassText[1: Language = $session.system_language].AssetClassName as faa_asset_class_name ) AS AssetClassName,
  _ReferenceDocumentTypeText[1: Language = $session.system_language].ReferenceDocumentTypeName AS ReferenceDocumentTypeName,
  _BusinessTransactionCatText[1: Language = $session.system_language].BusTransactionCategoryName AS BusTransactionCategoryName,
  _DepreciationAreaText[1: Language = $session.system_language].AssetDepreciationAreaName AS AssetDepreciationAreaName,
  _AssetTransactionTypeText[1: Language = $session.system_language].AssetTransactionTypeName AS AssetTransactionTypeName,
  _SubLedgerAccLineItemTypeText[1: Language = $session.system_language].SubLedgerAcctLineItemTypeName AS SubLedgerAcctLineItemTypeName,
  _LedgerText[1: Language = $session.system_language].LedgerName AS LedgerName,
  _AssetTransactionVariantText[1: Language = $session.system_language].AssetTransactionVariantName AS AssetTransactionVariantName,
  _TaxDepreciationGroupText[1: Language = $session.system_language].TaxDepreciationGroupDesc AS TaxDepreciationGroupDesc,
  _FinancialManagementAreaText[1: Language = $session.system_language].FinancialManagementAreaName AS FinancialManagementAreaName,
  _FunctionalAreaText[1: Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  _FundText[1: Language = $session.system_language].FundDescription AS FundDescription,
  _BudgetPeriodText[1: Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
  _DepreciationKeyText[1: Language = $session.system_language].DepreciationKeyName AS DepreciationKeyName,
  cast(_AssetCostCenterText.CostCenterName as faa_kostl_name) AS AssetCostCenterName,
  cast(_AssetProfitCenterText.ProfitCenterName as faa_prctr_name) AS AssetProfitCenterName,
  cast(_AssetSegmentText[1: Language = $session.system_language].SegmentName as faa_segment_name) AS AssetSegmentName,
  _AssetAcctDeterminationText[1: Language = $session.system_language].AssetAccountDeterminationDesc AS AssetAccountDeterminationDesc,
  _AssetAcctTransClassfctnText[1: Language = $session.system_language].AssetAcctTransClassfctnName AS AssetAcctTransClassfctnName,
  _FixedAssetNatlClfnText[1: Language = $session.system_language].NationalClassificationDesc AS NationalClassificationDesc,
  _RU_AssetOKOFText[1: Language = $session.system_language].RU_AssetOKOFDesc AS RU_AssetOKOFDesc,
  _RU_AssetDepreciationGroupText[1: Language = $session.system_language].RU_AssetDepreciationGroupDesc AS RU_AssetDepreciationGroupDesc,
  _JP_PrptyTxRptCityText[1: Language = $session.system_language].JP_PrptyTxRptCityDesc AS JP_PrptyTxRptCityDesc,
  _JP_PrptyTxRptClassfctnKeyText[1: Language = $session.system_language].JP_PrptyTxRptClassfctnKeyDesc AS JP_PrptyTxRptClassfctnKeyDesc
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_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..*]
LEFT OUTER JOIN I_ReferenceDocumentTypeText AS _ReferenceDocumentTypeText ON ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType  -- association [0..*]
;