C_StRpFxdAstLocTransferFormQry

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_StRpFxdAstLocTransferFormQry.
-- 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: CSRFALTRFORMQ
-- Parameters: P_FromPostingDate : fiaagen_frm_ltr_date_from, P_ToPostingDate : fiaagen_frm_ltr_date_to, P_FiscalYear : fis_gjahr, P_ToFiscalPeriod : fis_period_to, P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_NationalClsfctnSourceField : fiaagen_natl_clfn_srce_fld

CREATE VIEW C_StRpFxdAstLocTransferFormQry AS
SELECT
  entity.name: 'I_AssetKeyFigureSet' AS nameI_AssetKeyFigureSet,
  entity.element: 'AssetAccountingKeyFigureSet' AS P_FiscalYear,
  P_ToFiscalPeriod: $parameters.P_ToFiscalPeriod AS P_ToFiscalPeriod,
  P_FromPostingDate: $parameters.P_FromPostingDate AS P_FromPostingDate,
  P_ToPostingDate: $parameters.P_ToPostingDate AS P_ToPostingDate,
  P_AssetAccountingKeyFigureSet: $parameters.P_AssetAccountingKeyFigureSet AS P_AssetAccountingKeyFigureSet,
  MasterFixedAsset,
  FixedAsset,
  ValidityStartDate,
  ValidityEndDate,
  FixedAssetDescription,
  FixedAssetFormNumber,
  StatryRptRunID,
  OldAssetLocation,
  OldAssetPlant,
  NewAssetLocation,
  NewAssetPlant,
  OldAssetCostCenter,
  NewAssetCostCenter,
  AcquisitionValueAmtInCCCrcy,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  AssetClass,
  _AssetClass._Text[1:Language = $session.system_language].AssetClassDescription AS AssetClassDescription,
  Ledger,
  AssetAdditionalDescription,
  Inventory,
  AssetSerialNumber,
  NationalClassification,
  NationalClassificationDesc,
  CompanyCodeCurrency,
  CompanyCodeName,
  AssetDepreciationArea,
  StatryRptgEntity,
  StatryRptCategory
FROM C_StRpFxdAssetLocTransferFormC
;