C_StRpFxdAstRetirementFormCube

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_StRpFxdAstRetirementFormCube.
-- 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.
-- SQL view name: CSRFARETFORMC
-- Parameters: P_FiscalYear : fis_gjahr, P_ToFiscalPeriod : fis_period_to, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_DateFieldPrintedOnForm : fiaagen_frm_date_fld_prntd, P_NationalClsfctnSourceField : fiaagen_natl_clfn_srce_fld

CREATE VIEW C_StRpFxdAstRetirementFormCube AS
SELECT
  FixedAssetVal.CompanyCode AS CompanyCode,
  AssetDepreciationArea,
  FixedAssetVal.MasterFixedAsset AS MasterFixedAsset,
  FixedAssetVal.FixedAsset AS FixedAsset,
  FixedAssetVal.AccountingDocument AS AccountingDocument,
  LedgerGLLineItem,
  FixedAssetVal.Ledger AS Ledger,
  FixedAssetVal.FiscalYear AS FiscalYear,
  SubLedgerAcctLineItemType,
  AssetAcctTransClassfctn,
  FixedAssetVal.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  AssetAccountingKeyFigure,
  DebitCreditCode,
  AssetFormCompCode.FullName AS CompanyCodeName,
  ControllingArea,
  Inventory,
  PostingDate,
  DocumentDate,
  AssetValueDate,
  AssetClass,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  _FixedAsset.AssetAdditionalDescription AS AssetAdditionalDescription,
  Group1AssetEvaluationKey,
  Group2AssetEvaluationKey,
  Group3AssetEvaluationKey,
  Group4AssetEvaluationKey,
  Group5AssetEvaluationKey,
  AssetTransactionType,
  _AssetTransactionType._Text[1:Language = $session.system_language].AssetTransactionTypeName AS AssetTransactionTypeName,
  Country,
  AssetSerialNumber,
  cast (DisplayCurrency as waers) AS CompanyCodeCurrency,
  GLAccount,
  ChartOfAccounts,
  cast (_AssignmentByFiscalPeriodEnd( P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_ToFiscalPeriod).Plant as faa_werks) AS AssetPlant,
  _AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_ToFiscalPeriod).AssetLocation AS AssetLocation,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_ToFiscalPeriod).CostCenter as faa_kostl) AS AssetCostCenter,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_ToFiscalPeriod).BusinessArea as faa_gsber) AS AssetBusinessArea,
  FormNumber.FixedAssetFormNumber AS FixedAssetFormNumber,
  FormNumber.StatryRptgEntity AS StatryRptgEntity,
  FormNumber.StatryRptCategory AS StatryRptCategory,
  FormNumber.StatryRptRunID AS StatryRptRunID,
  FixedAssetVal._Ledger AS _Ledger,
  FixedAssetVal._FiscalYear AS _FiscalYear
FROM I_AssetBalanceCube
LEFT OUTER JOIN I_FixedAssetFormNumber AS FormNumber ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_STRPFxdAssetFormCompanyCode AS AssetFormCompCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FxdAstAssgmtByFsclPerdEndDte AS _AssignmentByFiscalPeriodEnd ON FixedAssetVal.CompanyCode = _AssignmentByFiscalPeriodEnd.CompanyCode AND FixedAssetVal.Ledger = _AssignmentByFiscalPeriodEnd.Ledger AND FixedAssetVal.AssetDepreciationArea = _AssignmentByFiscalPeriodEnd.AssetDepreciationArea AND FixedAssetVal.MasterFixedAsset = _AssignmentByFiscalPeriodEnd.MasterFixedAsset AND FixedAssetVal.FixedAsset = _AssignmentByFiscalPeriodEnd.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _AssetPlant ON AssetPlant = _AssetPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Location AS _AssetLocation ON assetlocation = _AssetLocation.Location AND AssetPlant = _AssetLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _AssetCostCenter ON ControllingArea = _AssetCostCenter.ControllingArea AND AssetCostCenter = _AssetCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _AssetBusinessArea ON AssetBusinessArea = _AssetBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Group1AssetEvaluationKey AS _EvaluationGroup1 ON Group1AssetEvaluationKey = _EvaluationGroup1.Group1AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group2AssetEvaluationKey AS _EvaluationGroup2 ON Group2AssetEvaluationKey = _EvaluationGroup2.Group2AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group3AssetEvaluationKey AS _EvaluationGroup3 ON Group3AssetEvaluationKey = _EvaluationGroup3.Group3AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group4AssetEvaluationKey AS _EvaluationGroup4 ON Group4AssetEvaluationKey = _EvaluationGroup4.Group4AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group5AssetEvaluationKey AS _EvaluationGroup5 ON Group5AssetEvaluationKey = _EvaluationGroup5.Group5AssetEvaluationKey  -- association [0..1]
;