@AbapCatalog.sqlViewName: 'CFIGLACCTBALFLOW'
@EndUserText.label: 'G/L Account Balance with Flow-Measure'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.preserveKey: true
@Analytics.settings.maxProcessingEffort: #HIGH
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@AbapCatalog.compiler.compareFilter:true
@AccessControl.personalData.blocking:#REQUIRED
@ObjectModel.query.implementedBy:'ABAP:CL_FIS_GL_ACCOUNT_BAL_FLOW_CDS'
@UI.presentationVariant.requestAtLeast: ['Ledger, CompanyCode, LedgerFiscalYear, GLAccountFlowType']
//@Consumption.filter.businessDate.at: true
define view C_GLAccountBalanceFlow
as select from I_GLAccountLineItem as I_GLAccountLineItem
left outer to one join I_FiscalCalendarDate as _FiscalCalendarDate on I_GLAccountLineItem.FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant
and I_GLAccountLineItem.PostingDate = _FiscalCalendarDate.CalendarDate
association [0..1] to I_CurrentCostCenter as _CurrentCostCenter on $projection.ControllingArea = _CurrentCostCenter.ControllingArea
and $projection.CostCenter = _CurrentCostCenter.CostCenter
association [0..1] to I_CurrentProfitCenter as _CurrentProfitCenter on $projection.ControllingArea = _CurrentProfitCenter.ControllingArea
and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter
association [0..1] to I_AccrualObject as _AccrualObject on $projection.AccrualObjectType = _AccrualObject.AccrualObjectType
and $projection.AccrualObjectLogicalSystem = _AccrualObject.AccrualObjectLogicalSystem
and $projection.CompanyCode = _AccrualObject.CompanyCode
and $projection.AccrualObject = _AccrualObject.AccrualObject
association [0..1] to I_AccrualSubObject as _AccrualSubobject on $projection.AccrualObjectType = _AccrualSubobject.AccrualObjectType
and $projection.AccrualObjectLogicalSystem = _AccrualSubobject.AccrualObjectLogicalSystem
and $projection.CompanyCode = _AccrualSubobject.CompanyCode
and $projection.AccrualObject = _AccrualSubobject.AccrualObject
and $projection.AccrualSubobject = _AccrualSubobject.AccrualSubobject
association [0..1] to I_FunctionalLocationLabel as _FunctionalLocationLabel on $projection.FunctionalLocation = _FunctionalLocationLabel.FunctionalLocation
association [1..1] to E_JournalEntryItem as _Extension on $projection.SourceLedger = _Extension.SourceLedger
and $projection.CompanyCode = _Extension.CompanyCode
and $projection.FiscalYear = _Extension.FiscalYear
and $projection.AccountingDocument = _Extension.AccountingDocument
and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem
{
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_LedgerStdVH' , element: 'Ledger' }
}]
key I_GLAccountLineItem.SourceLedger,
------------------------------------------------------------------------------------------------------
-- FREE
------------------------------------------------------------------------------------------------------
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_LedgerStdVH' , element: 'Ledger' }
}]
@Consumption.filter: {selectionType: #SINGLE, multipleSelections: false, mandatory: true}
key I_GLAccountLineItem.Ledger,
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_LedgerCompanyCodeVH' , element: 'CompanyCode' }
}]
key I_GLAccountLineItem.CompanyCode,
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_FiscalYearForCompanyCode' , element: 'FiscalYear' },
additionalBinding: [ { localElement: 'CompanyCode' , element: 'CompanyCode' } ]
}]
@Consumption.filter: { selectionType: #SINGLE, multipleSelections: true, mandatory: false}
key I_GLAccountLineItem.FiscalYear,
key I_GLAccountLineItem.LedgerGLLineItem,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_JournalEntryVH', element: 'AccountingDocument' }
}]
@Consumption.semanticObject: 'AccountingDocument'
key I_GLAccountLineItem.AccountingDocument,
@Consumption.semanticObject: 'GLAccount'
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_GLAccountInCompanyCodeStdVH' , element: 'GLAccount' },
additionalBinding: [ { localElement: 'CompanyCode' , element: 'CompanyCode' } ]
}]
@Consumption.filter: { selectionType: #RANGE, multipleSelections: true, mandatory: false }
@UI.fieldGroup: [{ qualifier: '_BASIC', groupLabel: 'Basic Fields', position: 04, exclude: false, importance: #HIGH, type: #STANDARD }]
@UI.selectionField: [{position: 20}]
@UI.lineItem: [{position:20, invocationGrouping}]
I_GLAccountLineItem.GLAccount,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_FiscalYearPeriodForLedger', element: 'FiscalYearPeriod' },
additionalBinding: [ { localElement: 'LedgerFiscalYear' , element: 'FiscalYear' },
{ localElement: 'FiscalPeriod' , element: 'FiscalPeriod' },
{ localElement: 'CompanyCode' , element: 'CompanyCode' },
{ localElement: 'Ledger' , element: 'Ledger' }
]
}]
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
case when I_GLAccountLineItem.PostingDate is initial then I_GLAccountLineItem.FiscalYearPeriod
when I_GLAccountLineItem.FiscalYearPeriod > _FiscalCalendarDate.FiscalYearPeriod then _FiscalCalendarDate.FiscalYearPeriod
when I_GLAccountLineItem.FiscalPeriod = '000' then I_GLAccountLineItem.FiscalYearPeriod
when I_GLAccountLineItem.FiscalPeriod = _FiscalCalendarDate.FiscalPeriod then I_GLAccountLineItem.FiscalYearPeriod
end as FiscalYearPeriod,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
I_GLAccountLineItem.PostingDate,
@Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_GLAccountTypeFlowType' , element: 'GLAccountTypeFlowType' }
}]
@UI.fieldGroup: [{ qualifier: '_BASIC', groupLabel: 'Basic Fields', position: 07, exclude: false, importance: #HIGH, type: #STANDARD }]
@UI.selectionField: [{position: 30}]
@UI.lineItem: [{position:30, invocationGrouping}]
cast( '' as fis_glacct_type_flow_type ) as GLAccountTypeFlowType,
@Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_GLAccountFlowType' , element: 'GLAccountFlowType' }
}]
@UI.fieldGroup: [{ qualifier: '_BASIC', groupLabel: 'Basic Fields', position: 08, exclude: false, importance: #HIGH, type: #STANDARD }]
@UI.selectionField: [{position: 31}]
@UI.lineItem: [{position:31, invocationGrouping}]
cast( '' as fis_glaccount_flow_type ) as GLAccountFlowType,
@Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
I_GLAccountLineItem._GLAccountInChartOfAccounts.IsBalanceSheetAccount as IsBalanceSheetAccount,
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_FiscalYearForCompanyCode' , element: 'FiscalYear' },
additionalBinding: [ { localElement: 'CompanyCode' , element: 'CompanyCode' } ]
}]
@Consumption.filter: { selectionType: #SINGLE, multipleSelections: true, mandatory: false}
@UI.fieldGroup: [{ qualifier: '_BASIC', groupLabel: 'Basic Fields', position: 09, exclude: false, importance: #HIGH, type: #STANDARD }]
I_GLAccountLineItem.LedgerFiscalYear,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ChartOfAccountsStdVH', element: 'ChartOfAccounts' }
}]
I_GLAccountLineItem.ChartOfAccounts,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ControllingAreaStdVH', element: 'ControllingArea' }
}]
@Consumption.semanticObject: 'ControllingArea'
// @Consumption.filter.businessDate.at: true
I_GLAccountLineItem.ControllingArea,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_FinancialTransactionType', element: 'FinancialTransactionType' }
}]
I_GLAccountLineItem.FinancialTransactionType,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_BusinessTransactionType', element: 'BusinessTransactionType' }
}]
I_GLAccountLineItem.BusinessTransactionType,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ReferenceDocumentTypeVH', element: 'ReferenceDocumentType' }
}]
I_GLAccountLineItem.ReferenceDocumentType,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_LogicalSystem', element: 'LogicalSystem' }
}]
I_GLAccountLineItem.LogicalSystem,
I_GLAccountLineItem.ReferenceDocumentItemGroup,
I_GLAccountLineItem.IsReversal,
I_GLAccountLineItem.IsReversed,
I_GLAccountLineItem.IsSettlement,
I_GLAccountLineItem.IsSettled,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ReferenceDocumentTypeVH', element: 'ReferenceDocumentType' }
}]
I_GLAccountLineItem.PredecessorReferenceDocType,
@Consumption.semanticObject: 'CostCenter'
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_CostCenterVH' , element: 'CostCenter' },
additionalBinding: [ { localElement: 'ControllingArea' , element: 'ControllingArea' },
{ localElement: 'ProfitCenter' , element: 'ProfitCenter' },
{ localElement: 'CompanyCode' , element: 'CompanyCode' } ]
}]
// @ObjectModel.text.association: '_CostCenterText'
// @Consumption.filter.businessDate.at: true
I_GLAccountLineItem.CostCenter,
@Consumption.semanticObject: 'ProfitCenter'
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_ProfitCenterVH' , element: 'ProfitCenter' },
additionalBinding: [ { localElement: 'ControllingArea' , element: 'ControllingArea' },
{ localElement: 'Segment' , element: 'Segment' } ]
}]
// @ObjectModel.text.association: '_ProfitCenterText'
// @Consumption.filter.businessDate.at: true
I_GLAccountLineItem.ProfitCenter,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_FunctionalArea', element: 'FunctionalArea' }
}]
// @ObjectModel.text.association: '_FunctionalAreaText'
I_GLAccountLineItem.FunctionalArea,
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_BusinessAreaStdVH', element: 'BusinessArea' }
}]
// @ObjectModel.text.association: '_BusinessAreaText'
I_GLAccountLineItem.BusinessArea,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_SegmentStdVH', element: 'Segment' }
}]
// @ObjectModel.text.association: '_SegmentText'
I_GLAccountLineItem.Segment,
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_CostCenterVH' , element: 'CostCenter' },
additionalBinding: [ { localElement: 'ControllingArea' , element: 'ControllingArea' } ]
}]
I_GLAccountLineItem.PartnerCostCenter,
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_ProfitCenterVH' , element: 'ProfitCenter' },
additionalBinding: [ { localElement: 'ControllingArea' , element: 'ControllingArea' } ]
}]
I_GLAccountLineItem.PartnerProfitCenter,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_FunctionalArea', element: 'FunctionalArea' }
}]
I_GLAccountLineItem.PartnerFunctionalArea,
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_BusinessAreaStdVH', element: 'BusinessArea' }
}]
I_GLAccountLineItem.PartnerBusinessArea,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_PartnerCompanyStdVH', element: 'PartnerCompany' }
}]
I_GLAccountLineItem.PartnerCompany,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_SegmentStdVH', element: 'Segment' }
}]
I_GLAccountLineItem.PartnerSegment,
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_DebitCreditCode', element: 'DebitCreditCode' }
}]
// @ObjectModel.text.association: '_DebitCreditCodeText'
I_GLAccountLineItem.DebitCreditCode,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
// @Consumption.hidden: true
case when I_GLAccountLineItem.PostingDate is initial then I_GLAccountLineItem.FiscalPeriod
when I_GLAccountLineItem.FiscalPeriod > _FiscalCalendarDate.FiscalPeriod then _FiscalCalendarDate.FiscalPeriod
when I_GLAccountLineItem.FiscalPeriod = '000' then I_GLAccountLineItem.FiscalPeriod
when I_GLAccountLineItem.FiscalPeriod = _FiscalCalendarDate.FiscalPeriod then I_GLAccountLineItem.FiscalPeriod
end as FiscalPeriod,
I_GLAccountLineItem.FiscalYearVariant,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_AccountingDocumentTypeStdVH', element: 'AccountingDocumentType' }
}]
// @ObjectModel.text.association: '_AccountingDocumentTypeText'
I_GLAccountLineItem.AccountingDocumentType,
I_GLAccountLineItem.AssignmentReference,
I_GLAccountLineItem.AccountingDocumentCategory,
I_GLAccountLineItem.PostingKey,
------------------------------------------------------------------------------------------------------
-- MEASURES
------------------------------------------------------------------------------------------------------
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CurrencyStdVH', element: 'Currency' }
}]
@Semantics.currencyCode:true
I_GLAccountLineItem.BalanceTransactionCurrency,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'BalanceTransactionCurrency'
I_GLAccountLineItem.AmountInBalanceTransacCrcy,
// @Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'BalanceTransactionCurrency'
cast( I_GLAccountLineItem.AmountInBalanceTransacCrcy as fis_tsl_flow preserving type ) as FlowAmountInBalanceTransCrcy,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'BalanceTransactionCurrency'
I_GLAccountLineItem.DebitAmountInBalanceTransCrcy,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'BalanceTransactionCurrency'
I_GLAccountLineItem.CreditAmountInBalanceTransCrcy,
@Semantics.currencyCode:true
I_GLAccountLineItem.TransactionCurrency,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'TransactionCurrency'
I_GLAccountLineItem.AmountInTransactionCurrency,
// @Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'TransactionCurrency'
cast( I_GLAccountLineItem.AmountInTransactionCurrency as fis_wsl_flow preserving type ) as FlowAmountInTransCrcy,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'TransactionCurrency'
I_GLAccountLineItem.DebitAmountInTransCrcy,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'TransactionCurrency'
I_GLAccountLineItem.CreditAmountInTransCrcy,
@Semantics.currencyCode:true
@UI.selectionField: [{position: 101}]
@UI.lineItem: [{position:101, invocationGrouping}]
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CurrencyStdVH', element: 'Currency' }
}]
I_GLAccountLineItem.CompanyCodeCurrency,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
I_GLAccountLineItem.AmountInCompanyCodeCurrency,
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@UI.selectionField: [{position: 100}]
@UI.lineItem: [{position:100, invocationGrouping}]
cast( I_GLAccountLineItem.AmountInCompanyCodeCurrency as fis_hsl_flow preserving type ) as FlowAmountInCoCodeCrcy,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
I_GLAccountLineItem.DebitAmountInCoCodeCrcy,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
I_GLAccountLineItem.CreditAmountInCoCodeCrcy,
@Semantics.currencyCode:true
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CurrencyStdVH', element: 'Currency' }
}]
I_GLAccountLineItem.GlobalCurrency,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'GlobalCurrency'
I_GLAccountLineItem.AmountInGlobalCurrency,
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'GlobalCurrency'
cast( I_GLAccountLineItem.AmountInGlobalCurrency as fis_ksl_flow preserving type ) as FlowAmountInGlobalCrcy,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'GlobalCurrency'
I_GLAccountLineItem.DebitAmountInGlobalCrcy,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'GlobalCurrency'
I_GLAccountLineItem.CreditAmountInGlobalCrcy,
@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency1,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
I_GLAccountLineItem.AmountInFreeDefinedCurrency1,
// @Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
cast( I_GLAccountLineItem.AmountInFreeDefinedCurrency1 as fis_osl_flow preserving type ) as FlowAmountInFreeDfndCrcy1,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy1 as DebitAmountInFreeDfndCrcy1,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy1 as CreditAmountInFreeDfndCrcy1,
@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency2,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
I_GLAccountLineItem.AmountInFreeDefinedCurrency2,
// @Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
cast( I_GLAccountLineItem.AmountInFreeDefinedCurrency2 as fis_vsl_flow preserving type ) as FlowAmountInFreeDfndCrcy2,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy2 as DebitAmountInFreeDfndCrcy2,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy2 as CreditAmountInFreeDfndCrcy2,
@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency3,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
I_GLAccountLineItem.AmountInFreeDefinedCurrency3,
// @Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
cast( I_GLAccountLineItem.AmountInFreeDefinedCurrency3 as fis_bsl_flow preserving type ) as FlowAmountInFreeDfndCrcy3,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy3 as DebitAmountInFreeDfndCrcy3,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy3 as CreditAmountInFreeDfndCrcy3,
@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency4,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
I_GLAccountLineItem.AmountInFreeDefinedCurrency4,
// @Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
cast( I_GLAccountLineItem.AmountInFreeDefinedCurrency4 as fis_csl_flow preserving type ) as FlowAmountInFreeDfndCrcy4,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy4 as DebitAmountInFreeDfndCrcy4,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy4 as CreditAmountInFreeDfndCrcy4,
@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency5,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
I_GLAccountLineItem.AmountInFreeDefinedCurrency5,
// @Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
cast( I_GLAccountLineItem.AmountInFreeDefinedCurrency5 as fis_dsl_flow preserving type ) as FlowAmountInFreeDfndCrcy5,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy5 as DebitAmountInFreeDfndCrcy5,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy5 as CreditAmountInFreeDfndCrcy5,
@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency6,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
I_GLAccountLineItem.AmountInFreeDefinedCurrency6,
// @Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
cast( I_GLAccountLineItem.AmountInFreeDefinedCurrency6 as fis_esl_flow preserving type ) as FlowAmountInFreeDfndCrcy6,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy6 as DebitAmountInFreeDfndCrcy6,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy6 as CreditAmountInFreeDfndCrcy6,
@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency7,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
I_GLAccountLineItem.AmountInFreeDefinedCurrency7,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
cast( I_GLAccountLineItem.AmountInFreeDefinedCurrency7 as fis_fsl_flow preserving type ) as FlowAmountInFreeDfndCrcy7,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy7 as DebitAmountInFreeDfndCrcy7,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy7 as CreditAmountInFreeDfndCrcy7,
@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency8,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
I_GLAccountLineItem.AmountInFreeDefinedCurrency8,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
cast( I_GLAccountLineItem.AmountInFreeDefinedCurrency8 as fis_gsl_flow preserving type ) as FlowAmountInFreeDfndCrcy8,
// @Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy8 as DebitAmountInFreeDfndCrcy8,
@Consumption.hidden: true
@Aggregation.default: #SUM
@Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy8 as CreditAmountInFreeDfndCrcy8,
I_GLAccountLineItem.TransactionTypeDetermination,
I_GLAccountLineItem.AccountingDocCreatedByUser,
I_GLAccountLineItem.EliminationProfitCenter,
I_GLAccountLineItem.OriginObjectType,
I_GLAccountLineItem.GLAccountType,
I_GLAccountLineItem.AlternativeGLAccount,
I_GLAccountLineItem.CountryChartOfAccounts,
I_GLAccountLineItem.PurchasingDocument,
I_GLAccountLineItem.PurchasingDocumentItem,
I_GLAccountLineItem.AccountAssignmentNumber,
// @Consumption.valueHelpDefinition: [{ entity: { name: 'I_SalesOrderStdVH', element: 'SalesOrder' }
// }]
// SalesOrder,
// SalesOrderItem,
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_SalesDocumentStdVH', element: 'SalesDocument' }
}]
I_GLAccountLineItem.SalesDocument,
I_GLAccountLineItem.SalesDocumentItem,
I_GLAccountLineItem.Product,
I_GLAccountLineItem.Plant,
I_GLAccountLineItem.Supplier,
I_GLAccountLineItem.Customer,
I_GLAccountLineItem.FinancialAccountType,
I_GLAccountLineItem.SpecialGLCode,
I_GLAccountLineItem.TaxCode,
I_GLAccountLineItem.HouseBank,
I_GLAccountLineItem.HouseBankAccount,
@Semantics.booleanIndicator
I_GLAccountLineItem.IsOpenItemManaged,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntry'
I_GLAccountLineItem.ClearingAccountingDocument,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntryFiscalYear'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'
I_GLAccountLineItem.ClearingDocFiscalYear,
@Analytics.internalName: #LOCAL
I_GLAccountLineItem.ClearingJournalEntry,
@Semantics.fiscal.year: true
@Analytics.internalName: #LOCAL
I_GLAccountLineItem.ClearingJournalEntryFiscalYear,
I_GLAccountLineItem.AssetDepreciationArea,
I_GLAccountLineItem.MasterFixedAsset,
I_GLAccountLineItem.FixedAsset,
I_GLAccountLineItem.AssetValueDate,
I_GLAccountLineItem.AssetTransactionType,
I_GLAccountLineItem.GroupMasterFixedAsset,
I_GLAccountLineItem.GroupFixedAsset,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'InvtrySpecialStockValnType_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'InvtrySpecialStockValnType_2'
I_GLAccountLineItem.InventorySpecialStockValnType,
I_GLAccountLineItem.InvtrySpecialStockValnType_2,
I_GLAccountLineItem.InventorySpecialStockType,
I_GLAccountLineItem.InventorySpclStkSalesDocument,
I_GLAccountLineItem.InventorySpclStkSalesDocItm,
I_GLAccountLineItem.InvtrySpclStockWBSElmntIntID,
cast( I_GLAccountLineItem._InvtrySpclStkWBSElmntBscData.WBSElementExternalID as fis_invspstock_wbsext_no_conv ) as InvtrySpclStockWBSElmntExtID,
I_GLAccountLineItem.InventorySpecialStockSupplier,
I_GLAccountLineItem.InventoryValuationType,
I_GLAccountLineItem.ValuationArea,
I_GLAccountLineItem.SenderGLAccount,
I_GLAccountLineItem.SenderAccountAssignment,
I_GLAccountLineItem.SenderAccountAssignmentType,
I_GLAccountLineItem.ControllingObjectDebitType,
I_GLAccountLineItem.QuantityIsIncomplete,
I_GLAccountLineItem.OffsettingAccount,
I_GLAccountLineItem.OffsettingAccountType,
I_GLAccountLineItem.LineItemIsCompleted,
I_GLAccountLineItem.PersonnelNumber,
I_GLAccountLineItem.ControllingObjectClass,
I_GLAccountLineItem.PartnerCompanyCode,
I_GLAccountLineItem.PartnerControllingObjectClass,
I_GLAccountLineItem.OriginCostCenter,
I_GLAccountLineItem.OriginProfitCenter,
I_GLAccountLineItem.OriginCostCtrActivityType,
I_GLAccountLineItem.AccountAssignment,
I_GLAccountLineItem.AccountAssignmentType,
I_GLAccountLineItem.CostCtrActivityType,
I_GLAccountLineItem.OrderID,
I_GLAccountLineItem.OrderCategory,
I_GLAccountLineItem.OperatingConcern,
I_GLAccountLineItem.ProjectNetwork,
I_GLAccountLineItem.BusinessProcess,
I_GLAccountLineItem.CostObject,
I_GLAccountLineItem.CustomerServiceNotification,
I_GLAccountLineItem.PartnerAccountAssignment,
I_GLAccountLineItem.PartnerAccountAssignmentType,
I_GLAccountLineItem.WorkPackage,
I_GLAccountLineItem.WorkItem,
I_GLAccountLineItem.ServiceDocumentType,
I_GLAccountLineItem.ServiceDocument,
I_GLAccountLineItem.ServiceDocumentItem,
I_GLAccountLineItem.ServiceContractType,
I_GLAccountLineItem.ServiceContract,
I_GLAccountLineItem.ServiceContractItem,
I_GLAccountLineItem.TimeSheetOvertimeCategory,
I_GLAccountLineItem.PartnerCostCtrActivityType,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'PartnerOrder_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'PartnerOrder_2'
I_GLAccountLineItem.PartnerOrder,
I_GLAccountLineItem.PartnerOrder_2,
I_GLAccountLineItem.PartnerOrderCategory,
I_GLAccountLineItem.PartnerSalesDocument,
I_GLAccountLineItem.PartnerSalesDocumentItem,
I_GLAccountLineItem.PartnerProjectNetwork,
I_GLAccountLineItem.PartnerBusinessProcess,
I_GLAccountLineItem.PartnerCostObject,
I_GLAccountLineItem.BillingDocumentType,
I_GLAccountLineItem.SalesOrganization,
I_GLAccountLineItem.DistributionChannel,
I_GLAccountLineItem.OrganizationDivision,
I_GLAccountLineItem.SoldProduct,
// MaterialGroup,
I_GLAccountLineItem.SoldProductGroup,
I_GLAccountLineItem.ProductGroup,
I_GLAccountLineItem.CustomerGroup,
I_GLAccountLineItem.FinancialManagementArea,
I_GLAccountLineItem.Fund,
I_GLAccountLineItem.GrantID,
I_GLAccountLineItem.BudgetPeriod,
I_GLAccountLineItem.PartnerFund,
I_GLAccountLineItem.PartnerGrant,
I_GLAccountLineItem.PartnerBudgetPeriod,
I_GLAccountLineItem.FundsCenter,
I_GLAccountLineItem.FundedProgram,
I_GLAccountLineItem.JointVenture,
I_GLAccountLineItem.JointVentureEquityGroup,
I_GLAccountLineItem.JointVentureCostRecoveryCode,
I_GLAccountLineItem.JointVentureEquityType,
I_GLAccountLineItem.SettlementReferenceDate,
I_GLAccountLineItem.CalendarYear,
I_GLAccountLineItem.CalendarQuarter,
I_GLAccountLineItem.CalendarYearQuarter,
I_GLAccountLineItem.CalendarMonth,
I_GLAccountLineItem.CalendarYearMonth,
I_GLAccountLineItem.CalendarWeek,
I_GLAccountLineItem.CalendarYearWeek,
_FiscalCalendarDate.FiscalQuarter as FiscalQuarter,
_FiscalCalendarDate.FiscalWeek as FiscalWeek,
_FiscalCalendarDate.FiscalYearQuarter as FiscalYearQuarter,
_FiscalCalendarDate.FiscalYearWeek as FiscalYearWeek,
@Consumption.hidden: true
cast( ' ' as acr_logsys preserving type ) as AccrualObjectLogicalSystem,
I_GLAccountLineItem.AccrualObjectType,
I_GLAccountLineItem.AccrualObject,
I_GLAccountLineItem.AccrualSubobject,
I_GLAccountLineItem.AccrualItemType,
I_GLAccountLineItem.AssetClass,
I_GLAccountLineItem.WBSElementInternalID,
cast( I_GLAccountLineItem._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv preserving type ) as WBSElementExternalID,
I_GLAccountLineItem.ProjectInternalID,
cast( I_GLAccountLineItem._ProjectBasicData.ProjectExternalID as fis_projectext_no_conv preserving type ) as ProjectExternalID,
I_GLAccountLineItem.PartnerWBSElementInternalID,
cast( I_GLAccountLineItem._PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv preserving type ) as PartnerWBSElementExternalID,
I_GLAccountLineItem.PartnerProjectInternalID,
cast( I_GLAccountLineItem._PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv preserving type ) as PartnerProjectExternalID,
cast( I_GLAccountLineItem.FunctionalLocation as vdm_eam_tplnr preserving type ) as FunctionalLocation,
/* Associations */
/*Authorizations */
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
@UI.hidden: true
@Consumption.hidden: true
I_GLAccountLineItem._GLAccountInCompanyCode,
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
@UI.hidden: true
@Consumption.hidden: true
I_GLAccountLineItem._Supplier,
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
@UI.hidden: true
@Consumption.hidden: true
I_GLAccountLineItem._Customer,
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
@UI.hidden: true
@Consumption.hidden: true
I_GLAccountLineItem._AccountingDocumentType,
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
@UI.hidden: true
@Consumption.hidden: true
I_GLAccountLineItem._Order,
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
@UI.hidden: true
@Consumption.hidden: true
I_GLAccountLineItem._SalesDocument,
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
@UI.hidden: true
@Consumption.hidden: true
I_GLAccountLineItem._ServiceDocument,
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
@UI.hidden: true
@Consumption.hidden: true
_AccrualSubobject,
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
@UI.hidden: true
@Consumption.hidden: true
_AccrualObject,
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
@UI.hidden: true
@Consumption.hidden: true
_CurrentProfitCenter,
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
@UI.hidden: true
@Consumption.hidden: true
_CurrentCostCenter,
/*Extensibility */
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
_FunctionalLocationLabel
}
where
I_GLAccountLineItem.GLRecordType != '5'