FINOC_RT_FA_FILL

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 FINOC_RT_FA_FILL.
-- 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: FINOCV_RTFAFILL

CREATE VIEW FINOC_RT_FA_FILL AS
SELECT
  FixedAssetUiEntry.CompanyCode AS CompanyCode,
  FixedAssetUiEntry.MasterFixedAsset AS AssetNumber,
  FixedAssetUiEntry.FixedAsset AS AssetSubNumber,
  OrglChange.OrganizationalChange AS OrganizationalChange,
  FixedAssetUiEntry.ControllingArea AS ControllingArea,
  FixedAssetUiEntry.ProfitCenter AS ProfitCenterBeforeOrglChange,
  FixedAssetUiEntry.ProfitCenterByOrglChange AS ProfitCenterByOrglChange,
  case when ProfitCenterOld.Segment is null then cast(' ' as finoc_segment_before_orgl_chg preserving type) else ProfitCenterOld.Segment end as SegmentBeforeOrglChange AS SegmentendasSegmentBeforeOrglChange,
  ProfitCenterNew.Segment AS SegmentByOrglChange,
  cast(' ' as finoc_prctr_drvtn_source_type preserving type) AS ProfitCenterDerivationSrceType,
  cast(' ' as finoc_srce_kostl preserving type) AS SourceCostCenter,
  cast('00000000' as finoc_srce_ps_psp_pnr preserving type) AS SourceWbsElementInternalID,
  cast('00000000' as finoc_srce_ps_prj_pnr preserving type) AS SourceProjectInternalID,
  cast(' ' as finoc_srce_aufnr preserving type) AS SourceOrder,
  'RULE' AS SemanticObject
FROM I_OrglChangeFixedAsset AS FixedAssetUiEntry
INNER JOIN I_OrganizationalChange AS OrglChange ON /* join condition not captured in parsed metadata */
INNER JOIN I_FixedAssetAssgmt AS FixedAssetAssgmnt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProfitCenter AS ProfitCenterOld ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProfitCenter AS ProfitCenterNew ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): finoc_rule_t_fa
;