FINOC_PACKAGE_OP_REC

DDL: FINOC_PACKAGE_OP_REC SQL: FINOCV_PCK_OPREC Type: view Package: FINS_ORGL_CHANGE_TRANSFER

Organizational Change: Packaging OP-REC

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

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_OPREC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Organizational Change: Packaging OP-REC 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_OPREC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Organizational Change: Packaging OP-REC'

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

define view FINOC_PACKAGE_OP_REC 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_rec as rt on rt.imkey = s.imkey 
{
    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 = 'IS'

union all

select from acdoca       as i 
       join finoc_rt_rec as rt on rt.recnnr  = i.recnnr and rt.bukrs = i.rbukrs
{
    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 = 'IS'

Learn More