FINOC_HARD_DEPENDENCY_RAR

DDL: FINOC_HARD_DEPENDENCY_RAR Type: view_entity

Orgl Change: RAR Hard Dependencies

FINOC_HARD_DEPENDENCY_RAR is a CDS View that provides data about "Orgl Change: RAR Hard Dependencies" in SAP S/4HANA. It reads from 8 data sources and exposes 28 fields with key fields pob_id, orgl_change, orgl_change.

Data Sources (8)

SourceAliasJoin Type
I_PrftCtrToRAPerfObligation _ProfitCenterToRAPerfOblig left_outer
I_RAPerformanceObligation _RAPerformanceObligation inner
I_RevenueAccountingContract _RevenueAccountingContract inner
FINOC_RT_RAR_FROM_SOI_OR_SRV dependent_pob union_all
I_OrganizationalChange OrglChange inner
I_OrglChangePerfObligation PoBUiEntry left_outer
I_OrglChangePerfObligation PoBUiEntry left_outer
I_SegmentToProfitCenter SegmentToProfitCenter from

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: RAR Hard Dependencies view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY pob_id I_RAPerformanceObligation PerformanceObligation Performance Obligation
KEY orgl_change I_OrganizationalChange OrganizationalChange Organizational Change
kokrs I_SegmentToProfitCenter ControllingArea Org. Value
bukrs I_PrftCtrToRAPerfObligation CompanyCode Value
prctr_old I_SegmentToProfitCenter ProfitCenter Old Profit Center
prctr I_SegmentToProfitCenter ProfitCenter Profit Centers
segment_old I_SegmentToProfitCenter SegmentBeforeOrglChange
segment I_SegmentToProfitCenter Segment Segment number
srce_kdauf Source Sales Order
srce_kdpos Source Sales Order Item
srce_pob_id
srce_matnr Source Product
srce_werks Source Plant
srce_aufnr Source Order
KEY orgl_change FINOC_RT_RAR_FROM_SOI_OR_SRV orgl_change Organizational Change
kokrs FINOC_RT_RAR_FROM_SOI_OR_SRV kokrs Org. Value
bukrs FINOC_RT_RAR_FROM_SOI_OR_SRV bukrs Value
prctr_old FINOC_RT_RAR_FROM_SOI_OR_SRV prctr_old Old Profit Center
prctr FINOC_RT_RAR_FROM_SOI_OR_SRV prctr Profit Centers
segment_old FINOC_RT_RAR_FROM_SOI_OR_SRV segment_old
segment FINOC_RT_RAR_FROM_SOI_OR_SRV segment Segment number
srce_kdauf FINOC_RT_RAR_FROM_SOI_OR_SRV srce_kdauf Source Sales Order
srce_kdpos FINOC_RT_RAR_FROM_SOI_OR_SRV srce_kdpos Source Sales Order Item
srce_pob_id FINOC_RT_RAR_FROM_SOI_OR_SRV srce_pob_id
srce_matnr FINOC_RT_RAR_FROM_SOI_OR_SRV srce_matnr Source Product
srce_werks FINOC_RT_RAR_FROM_SOI_OR_SRV srce_werks Source Plant
srce_aufnr FINOC_RT_RAR_FROM_SOI_OR_SRV srce_aufnr Source Order
contract_id FINOC_RT_RAR_FROM_SOI_OR_SRV contract_id Contract ID

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_HARD_DEPENDENCY_RAR.
-- 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_HARD_DEPENDENCY_RAR AS
SELECT
  _RAPerformanceObligation.PerformanceObligation AS pob_id,
  OrglChange.OrganizationalChange AS orgl_change,
  SegmentToProfitCenter.ControllingArea AS kokrs,
  _ProfitCenterToRAPerfOblig.CompanyCode AS bukrs,
  SegmentToProfitCenter.ProfitCenter AS prctr_old,
  SegmentToProfitCenter.ProfitCenter AS prctr,
  SegmentToProfitCenter.SegmentBeforeOrglChange AS segment_old,
  SegmentToProfitCenter.Segment AS segment,
  cast( ' ' as finoc_srce_kdauf preserving type ) AS srce_kdauf,
  cast( '000000' as finoc_srce_kdpos preserving type ) AS srce_kdpos,
  cast(' ' as finoc_srce_pob_id preserving type) AS srce_pob_id,
  cast(' ' as finoc_srce_matnr preserving type) AS srce_matnr,
  cast(' ' as finoc_srce_werks preserving type) AS srce_werks,
  cast(' ' as finoc_srce_aufnr preserving type) AS srce_aufnr,
  dependent_pob.contract_id AS contract_id
FROM I_SegmentToProfitCenter AS SegmentToProfitCenter
INNER JOIN I_OrganizationalChange AS OrglChange ON /* join condition not captured in parsed metadata */
INNER JOIN I_RAPerformanceObligation AS _RAPerformanceObligation ON /* join condition not captured in parsed metadata */
INNER JOIN I_RevenueAccountingContract AS _RevenueAccountingContract ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PrftCtrToRAPerfObligation AS _ProfitCenterToRAPerfOblig ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrglChangePerfObligation AS PoBUiEntry ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): FINOC_RT_RAR_FROM_SOI_OR_SRV
;