Which tables does FINOC_RULE_MAT_EXAMPLE use?

FINOC_RULE_MAT_EXAMPLE reads from 2 data source(s): FINOC_RULE_MAT_BASE, mara.

How many fields does FINOC_RULE_MAT_EXAMPLE have?

FINOC_RULE_MAT_EXAMPLE has 7 fields. Key fields: matnr, werks, orgl_change.

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.

Data Sources (2)

Source	Alias	Join Type
FINOC_RULE_MAT_BASE	base	from
mara	mara	inner

Annotations (9)

Name	Value	Level
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)

Key	Field	Source Table	Source Field
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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINOC_RULE_MAT_BASE",
"MARA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

FINOC_RULE_MAT_EXAMPLE view

FINOC_RULE_MAT_BASE view
mara