FINOC_RT_FA_FILL_HISTORY

DDL: FINOC_RT_FA_FILL_HISTORY Type: view_entity Package: FINS_ORGL_CHANGE_RUNTIME
15 Fields 2 Data Sources

Orgl Change: Fill RT FA (Hist.)

FINOC_RT_FA_FILL_HISTORY is a CDS View that provides data about "Orgl Change: Fill RT FA (Hist.)" in SAP S/4HANA. It reads from 2 data sources (finoc_rh_fa, FINOC_RT_FA_OPEN_ORGL) and exposes 15 fields with key fields ChangeUUID, CompanyCode, AssetNumber, AssetSubNumber, OrganizationalChange. Part of development package FINS_ORGL_CHANGE_RUNTIME.

Data Sources (2)

SourceAliasJoin Type
finoc_rh_fa h from
FINOC_RT_FA_OPEN_ORGL rt left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Orgl Change: Fill RT FA (Hist.) view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ChangeUUID finoc_rh_fa change_uuid UUID
KEY CompanyCode finoc_rh_fa bukrs Value
KEY AssetNumber finoc_rh_fa anln1 Asset
KEY AssetSubNumber finoc_rh_fa anln2 Sub-number
KEY OrganizationalChange finoc_rh_fa orgl_change Organizational Change
ControllingArea finoc_rh_fa kokrs Org. Value
ProfitCenterBeforeOrglChange finoc_rh_fa prctr_old Old Profit Center
ProfitCenterByOrglChange finoc_rh_fa prctr_old Old Profit Center
ProfitCenterDerivationSrceType finoc_rh_fa prctr_drvtn_source_type Profit Center Source
SourceCostCenter finoc_rh_fa srce_kostl Source Cost Center
SourceWBSElementInternalID
SourceProjectInternalID
SourceOrder finoc_rh_fa srce_aufnr Source Order
TransferStatus finoc_rh_fa transfer_status Transfer Status
TransferTimestamp finoc_rh_fa transfer_timestamp Transfer Time

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_HISTORY.
-- 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.

CREATE VIEW FINOC_RT_FA_FILL_HISTORY AS
SELECT
  h.change_uuid AS ChangeUUID,
  h.bukrs AS CompanyCode,
  h.anln1 AS AssetNumber,
  h.anln2 AS AssetSubNumber,
  h.orgl_change AS OrganizationalChange,
  h.kokrs AS ControllingArea,
  h.prctr_old AS ProfitCenterBeforeOrglChange,
  h.prctr_old AS ProfitCenterByOrglChange,
  h.prctr_drvtn_source_type AS ProfitCenterDerivationSrceType,
  h.srce_kostl AS SourceCostCenter,
  cast (h.srce_ps_psp_pnr as ps_s4_proj_pspnr preserving type) AS SourceWBSElementInternalID,
  cast (h.srce_ps_prj_pnr as ps_s4_proj_pspnr preserving type) AS SourceProjectInternalID,
  h.srce_aufnr AS SourceOrder,
  h.transfer_status AS TransferStatus,
  h.transfer_timestamp AS TransferTimestamp
FROM finoc_rh_fa AS h
LEFT OUTER JOIN FINOC_RT_FA_OPEN_ORGL AS rt ON /* join condition not captured in parsed metadata */
;

Learn More