FINOC_RULE_MAT_EXAMPLE

DDL: FINOC_RULE_MAT_EXAMPLE SQL: FINOCV_RULE_MATE Type: view Package: FINS_ORGL_CHANGE_RULE
7 Fields 1 Data Sources

Organizational Change: Customer Rule MAT

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

Data Sources (1)

SourceAliasJoin Type
FINOC_RULE_MAT_DEFAULT default from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FINOCV_RULE_MATE 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 MAT view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY matnr matnr Vehicle Model
KEY werks werks Receiving Plant
KEY orgl_change orgl_change Organizational Change
kokrs kokrs Org. Value
bukrs bukrs Value
prctr_old prctr_old Old Profit Center
prctr prctr Profit Centers

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_MAT_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_MATE

CREATE VIEW FINOC_RULE_MAT_EXAMPLE AS
SELECT
  matnr,
  werks,
  orgl_change,
  kokrs,
  bukrs,
  prctr_old,
  prctr
FROM FINOC_RULE_MAT_DEFAULT AS default
;

Learn More