FINOC_PACKAGE_OP_MAT

DDL: FINOC_PACKAGE_OP_MAT SQL: FINOCV_PCK_OPMAT Type: view

Organizational Change: Packaging OP-MAT

FINOC_PACKAGE_OP_MAT is a CDS View that provides data about "Organizational Change: Packaging OP-MAT" in SAP S/4HANA. It reads from 2 data sources (acdoca, acdoca) and exposes 17 fields with key fields rldnr, rbukrs, belnr, gjahr, buzei.

2 data source(s) 17 fields

Data Sources (2)

SourceAliasJoin Type
acdoca i from
acdoca i union_all

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINOCV_PCK_OPMAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Organizational Change: Packaging OP-MAT view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY rldnr acdoca rldnr
KEY rbukrs acdoca rbukrs
KEY belnr acdoca belnr
KEY gjahr acdoca gjahr
KEY buzei acdoca buzei
KEY docln acdoca docln
orgl_change rt orgl_change
augbl acdoca augbl
rldnr
KEY rbukrs acdoca rbukrs
KEY belnr acdoca belnr
KEY gjahr acdoca gjahr
KEY buzei acdoca buzei
KEY docln acdoca docln
orgl_change rt orgl_change
augbl acdoca augbl
augdt acdoca augdt 
@AbapCatalog.sqlViewName: 'FINOCV_PCK_OPMAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Organizational Change: Packaging OP-MAT'

@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL 
@ObjectModel.usageType.dataClass: #MIXED

define view FINOC_PACKAGE_OP_MAT as 
select from acdoca       as i 
       join fagl_splinfo as s on s.bukrs = i.rbukrs and s.belnr = i.belnr and s.buzei = i.buzei
       join finoc_rt_mat as rt on rt.werks = s.werks and rt.matnr = s.matnr 
{
    key i.rldnr,
    key i.rbukrs,
    key i.belnr,
    key i.gjahr,
    key i.buzei,
    key i.docln,
    rt.orgl_change,
    i.augbl,
    i.augdt
}
where i.xopvw = 'X'
  and i.poper <> '000'
  and i.bstat <> 'C'
  and s.prctr_drvtn_source_type = 'MA'

union all

select from acdoca       as i 
       join finoc_rt_mat as rt on rt.werks = i.werks and rt.matnr = i.matnr 
{
    key i.rldnr,
    key i.rbukrs,
    key i.belnr,
    key i.gjahr,
    key i.buzei,
    key i.docln,
    rt.orgl_change,
    i.augbl,
    i.augdt
}
where i.xopvw = 'X'
  and i.poper <> '000'
  and i.bstat <> 'C'
  and i.prctr_drvtn_source_type = 'MA'
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"FAGL_SPLINFO",
"FINOC_RT_MAT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More