FINOC_RULE_MAT_EXAMPLE

DDL: FINOC_RULE_MAT_EXAMPLE SQL: FINOCV_RULE_MATE Type: view

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.

2 data source(s) 7 fields

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
KEY werks FINOC_RULE_MAT_BASE werks
KEY orgl_change FINOC_RULE_MAT_BASE orgl_change
kokrs FINOC_RULE_MAT_BASE kokrs
bukrs FINOC_RULE_MAT_BASE bukrs
prctr_old FINOC_RULE_MAT_BASE prctr_old
mtartXYZthenPC1elsePC2endasprctr 
@AbapCatalog.sqlViewName: 'FINOCV_RULE_MATE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Organizational Change: Customer Rule MAT'

define view FINOC_RULE_MAT_EXAMPLE
  as select from FINOC_RULE_MAT_BASE as base
    inner join mara on mara.matnr = base.matnr
{
  key base.matnr,
  key base.werks,
  key base.orgl_change,
      base.kokrs,
      base.bukrs,
      base.prctr_old,
      case 
        when base.werks = '0001' and mara.mtart = 'XYZ' then 'PC1'
        else                                                 'PC2'
      end as prctr,
      base.prctr_drvtn_source_type
}

Learn More