FINOC_RULE_WBS_EXAMPLE

DDL: FINOC_RULE_WBS_EXAMPLE SQL: FINOCV_RULE_WBSE Type: view Package: FINS_ORGL_CHANGE_RULE
7 Fields 1 Data Sources

Organizational Change: Customer Rule WBS

FINOC_RULE_WBS_EXAMPLE is a CDS View that provides data about "Organizational Change: Customer Rule WBS" in SAP S/4HANA. It reads from 1 data source (FINOC_RULE_WBS_DEFAULT) and exposes 7 fields with key fields ps_psp_pnr, orgl_change. Part of development package FINS_ORGL_CHANGE_RULE.

Data Sources (1)

SourceAliasJoin Type
FINOC_RULE_WBS_DEFAULT default from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FINOCV_RULE_WBSE 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 Organizational Change: Customer Rule WBS view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ps_psp_pnr FINOC_RULE_WBS_DEFAULT ps_psp_pnr WBS Element
KEY orgl_change FINOC_RULE_WBS_DEFAULT orgl_change Organizational Change
bukrs FINOC_RULE_WBS_DEFAULT bukrs Value
kokrs FINOC_RULE_WBS_DEFAULT kokrs Org. Value
prctr_old FINOC_RULE_WBS_DEFAULT prctr_old Old Profit Center
prctr FINOC_RULE_WBS_DEFAULT prctr Profit Centers
objnr FINOC_RULE_WBS_DEFAULT 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_RULE_WBS_EXAMPLE.
-- 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_RULE_WBSE

CREATE VIEW FINOC_RULE_WBS_EXAMPLE AS
SELECT
  default.ps_psp_pnr AS ps_psp_pnr,
  default.orgl_change AS orgl_change,
  default.bukrs AS bukrs,
  default.kokrs AS kokrs,
  default.prctr_old AS prctr_old,
  default.prctr AS prctr,
  default.objnr AS objnr
FROM FINOC_RULE_WBS_DEFAULT AS default
;

Learn More