FINOC_RULE_MAT_EXAMPLE

DDL: FINOC_RULE_MAT_EXAMPLE SQL: FINOCV_RULE_MATE Type: view
7 Fields 2 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 2 data sources (FINOC_RULE_MAT_BASE, mara) and exposes 7 fields with key fields matnr, werks, orgl_change.

Data Sources (2)

SourceAliasJoin Type
FINOC_RULE_MAT_BASE base from
mara mara inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FINOCV_RULE_MATE view
AbapCatalog.compiler.compareFilter 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 FINOC_RULE_MAT_BASE matnr Vehicle Model
KEY werks FINOC_RULE_MAT_BASE werks Receiving Plant
KEY orgl_change FINOC_RULE_MAT_BASE orgl_change Organizational Change
kokrs FINOC_RULE_MAT_BASE kokrs Org. Value
bukrs FINOC_RULE_MAT_BASE bukrs Value
prctr_old FINOC_RULE_MAT_BASE prctr_old Old Profit Center
mtartXYZthenPC1elsePC2endasprctr

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
  base.matnr AS matnr,
  base.werks AS werks,
  base.orgl_change AS orgl_change,
  base.kokrs AS kokrs,
  base.bukrs AS bukrs,
  base.prctr_old AS prctr_old,
  case when base.werks = '0001' and mara.mtart = 'XYZ' then 'PC1' else 'PC2' end as prctr AS mtartXYZthenPC1elsePC2endasprctr
FROM FINOC_RULE_MAT_BASE AS base
INNER JOIN mara ON /* join condition not captured in parsed metadata */
;

Learn More