@AbapCatalog.
sqlViewName: 'ZFIORI_VBAKN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'MAIN'
@OData.publish: true
define view ZFIORI_VBAK_MAIN
as select from vbak
association [1..*] to ZFIORI_VBAP_ITEM as _LITEM on $projection.SORDER =
_LITEM.sorder
@UI.facet: [{
id: 'Line Item',
purpose: #STANDARD,
type: #IDENTIFICATION_REFERENCE,
position: 10,
label: 'Sales Order Item'
}]
@UI.lineItem: [{ position: 10, label: 'Sales Order' }]
key vbeln as SORDER,
@UI.lineItem: [{ position: 20, label: 'Line Item' }]
erdat as Erdat,
@UI.lineItem: [{ position: 30}]
erzet as Erzet,
@UI.lineItem: [{ position: 40}]
ernam as Ernam,
@UI.lineItem: [{ position: 50}]
auart as Auart,
@UI.lineItem: [{ position: 60}]
augru as Augru,
@UI.lineItem: [{ position: 70}]
lifsk as Lifsk,
@UI.lineItem: [{ position: 80}]
netwr as Netwr,
@UI.lineItem: [{ position: 90}]
waerk as Waerk,
@UI.lineItem: [{ position: 100}]
vkorg as Vkorg,
@UI.lineItem: [{ position: 110}]
vtweg as Vtweg
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VBAK"
],
"ASSOCIATED":
[
"ZFIORI_VBAP_ITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
