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
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  ValidityStartDate,
  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,
  ValidityEndDate,
  Inventory,
  AssetSerialNumber,
  NationalClassification,
  NationalClassificationDesc,
  CompanyCodeCurrency,
  CompanyCodeName,
  AssetDepreciationArea,
  StatryRptgEntity,
  StatryRptCategory
FROM C_StRpFxdAssetLocTransferFormC
LEFT OUTER JOIN I_AssetKeyFigureSet AS _AssetKeyFigureSet ON _AssetKeyFigureSet.AssetAccountingKeyFigureSet = :P_AssetAccountingKeyFigureSet AND _AssetKeyFigureSet.AssetAcctgKeyFigSetAnlytlCntxt = '05'  -- association [0..1]
;