FINOC_RT_CCR_FILL_HISTORY

DDL: FINOC_RT_CCR_FILL_HISTORY SQL: FINOCV_RCCRFILLH Type: view
9 Fields 2 Data Sources

Orgl Change: Fill RT Cost Center (Hist.)

FINOC_RT_CCR_FILL_HISTORY is a CDS View that provides data about "Orgl Change: Fill RT Cost Center (Hist.)" in SAP S/4HANA. It reads from 2 data sources (finoc_rh_ccr, FINOC_RT_CCR_OPEN_ORGL) and exposes 9 fields with key fields ChangeUUID, ControllingArea, CostCenter, OrganizationalChange.

Data Sources (2)

SourceAliasJoin Type
finoc_rh_ccr h from
FINOC_RT_CCR_OPEN_ORGL rt left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FINOCV_RCCRFILLH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE 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 Cost Center (Hist.) view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ChangeUUID finoc_rh_ccr change_uuid UUID
KEY ControllingArea finoc_rh_ccr kokrs Org. Value
KEY CostCenter finoc_rh_ccr kostl Substitute CC
KEY OrganizationalChange finoc_rh_ccr orgl_change Organizational Change
CompanyCode finoc_rh_ccr bukrs Value
ProfitCenterBeforeOrglChange finoc_rh_ccr prctr_old Old Profit Center
ProfitCenterByOrglChange finoc_rh_ccr prctr_old Old Profit Center
ProfitCenterDerivationSrceType finoc_rh_ccr prctr_drvtn_source_type Profit Center Source
ObjectNumber finoc_rh_ccr objnr Val. Obj. No.

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_CCR_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.
-- SQL view name: FINOCV_RCCRFILLH

CREATE VIEW FINOC_RT_CCR_FILL_HISTORY AS
SELECT
  h.change_uuid AS ChangeUUID,
  h.kokrs AS ControllingArea,
  h.kostl AS CostCenter,
  h.orgl_change AS OrganizationalChange,
  h.bukrs AS CompanyCode,
  h.prctr_old AS ProfitCenterBeforeOrglChange,
  h.prctr_old AS ProfitCenterByOrglChange,
  h.prctr_drvtn_source_type AS ProfitCenterDerivationSrceType,
  h.objnr AS ObjectNumber
FROM finoc_rh_ccr AS h
LEFT OUTER JOIN FINOC_RT_CCR_OPEN_ORGL AS rt ON /* join condition not captured in parsed metadata */
;

Learn More