Which tables does FINOC_PACKAGE_OP_oi use?

FINOC_PACKAGE_OP_oi reads from 1 data source(s): acdoca.

How many fields does FINOC_PACKAGE_OP_oi have?

FINOC_PACKAGE_OP_oi has 9 fields. Key fields: rldnr, rbukrs, belnr, gjahr, buzei.

FINOC_PACKAGE_OP_oi

DDL: FINOC_PACKAGE_OP_OI SQL: FINOCV_PCK_OPOI Type: view

Organizational Change: Packaging OP-OI

FINOC_PACKAGE_OP_oi is a CDS View that provides data about "Organizational Change: Packaging OP-OI" in SAP S/4HANA. It reads from 1 data source (acdoca) and exposes 9 fields with key fields rldnr, rbukrs, belnr, gjahr, buzei.

Data Sources (1)

Source	Alias	Join Type
acdoca	i	from

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	FINOCV_PCK_OPOI	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Organizational Change: Packaging OP-OI	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (9)

Key	Field	Source Table	Source Field
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
	augdt	acdoca	augdt

@AbapCatalog.sqlViewName: 'FINOCV_PCK_OPOI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Organizational Change: Packaging OP-OI'

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

define view FINOC_PACKAGE_OP_oi 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_oi as rt on rt.open_item_id = s.open_item_id 
{
    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 = 'OI'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"FAGL_SPLINFO",
"FINOC_RT_OI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

FINOC_PACKAGE_OP_oi view

acdoca