C_StRpFxdAssetLocTransferFormC

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

CREATE VIEW C_StRpFxdAssetLocTransferFormC AS
SELECT
  FixedAssetVal.CompanyCode AS CompanyCode,
  FixedAssetVal.AssetDepreciationArea AS AssetDepreciationArea,
  FixedAssetVal.MasterFixedAsset AS MasterFixedAsset,
  FixedAssetVal.FixedAsset AS FixedAsset,
  FixedAssetVal.AccountingDocument AS AccountingDocument,
  FixedAssetVal.Ledger AS Ledger,
  FixedAssetVal.FiscalYear AS FiscalYear,
  FixedAssetVal.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  FixedAssetVal.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  FixedAssetVal.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  FixedAssetVal.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  FixedAssetVal.DebitCreditCode AS DebitCreditCode,
  LocTransferAssgmt.ValidityStartDate AS ValidityStartDate,
  LocTransferAssgmt.ValidityEndDate AS ValidityEndDate,
  AssetFormCompCode.FullName AS CompanyCodeName,
  FixedAssetVal.ControllingArea AS ControllingArea,
  FixedAssetVal.Inventory AS Inventory,
  FixedAssetVal.AssetClass AS AssetClass,
  FixedAssetVal._FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  FixedAssetVal._FixedAsset.AssetAdditionalDescription AS AssetAdditionalDescription,
  Group1AssetEvaluationKey,
  Group2AssetEvaluationKey,
  Group3AssetEvaluationKey,
  Group4AssetEvaluationKey,
  Group5AssetEvaluationKey,
  LocTransferAssgmt.ValidityEndDate AS ActiveValidityEndDate,
  FixedAssetVal.AssetTransactionType AS AssetTransactionType,
  FixedAssetVal._AssetTransactionType._Text[1:Language = $session.system_language].AssetTransactionTypeName AS AssetTransactionTypeName,
  FixedAssetVal.Country AS Country,
  FixedAssetVal.AssetSerialNumber AS AssetSerialNumber,
  cast (DisplayCurrency as waers) AS CompanyCodeCurrency,
  cast( LocTransferAssgmt.OldAssetPlant as fiaagen_frm_old_plant ) AS OldAssetPlant,
  cast( LocTransferAssgmt.OldAssetLocation as fiaagen_frm_old_loc ) AS OldAssetLocation,
  cast( LocTransferAssgmt.NewAssetPlant as fiaagen_frm_new_plant ) AS NewAssetPlant,
  cast( LocTransferAssgmt.NewAssetLocation as fiaagen_frm_new_loc ) AS NewAssetLocation,
  cast( LocTransferAssgmt.OldAssetCostCenter as fiaagen_frm_old_cost_ctr ) AS OldAssetCostCenter,
  cast( LocTransferAssgmt.NewAssetCostCenter as fiaagen_frm_new_cost_ctr ) AS NewAssetCostCenter,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_ToFiscalPeriod).Plant as faa_werks) AS AssetPlant,
  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._CompanyCode AS _CompanyCode,
  FixedAssetVal._DepreciationArea AS _DepreciationArea,
  FixedAssetVal._MasterFixedAsset AS _MasterFixedAsset,
  FixedAssetVal._FixedAsset AS _FixedAsset,
  FixedAssetVal._JournalEntry AS _JournalEntry,
  FixedAssetVal._Ledger AS _Ledger,
  FixedAssetVal._FiscalYear AS _FiscalYear,
  FixedAssetVal._SubLedgerAccLineItemType AS _SubLedgerAccLineItemType,
  FixedAssetVal._AssetAcctTransClassfctn AS _AssetAcctTransClassfctn,
  FixedAssetVal._AssetKeyFigure AS _AssetKeyFigure,
  FixedAssetVal._AssetKeyFigureSet AS _AssetKeyFigureSet,
  FixedAssetVal._ControllingArea AS _ControllingArea,
  FixedAssetVal._AssetTransactionType AS _AssetTransactionType,
  FixedAssetVal._Country AS _Country
FROM P_StRpFxdAsstLocTransferAssgmt
INNER JOIN I_AssetBalanceCube ON /* join condition not captured in parsed metadata */
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_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_Plant AS _AssetPlant ON AssetPlant = _AssetPlant.Plant  -- 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]
;