P_EntProjLineItemSemTagGLAcct

@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'LedgerGLLineItem'
@VDM.private:true
//@EndUserText.label: 'GL Account Line Item in RevPrj with Semantic Tag'

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XXL,
  dataClass: #MIXED
}



define view entity P_EntProjLineItemSemTagGLAcct
  as select from I_GLAccountLineItem
//    inner join P_EnterpriseProject_F7479 as EnterpriseProject on EnterpriseProject.ProjectInternalID = I_GLAccountLineItem.ProjectInternalID

//                                  and EnterpriseProject.CompanyCode = I_GLAccountLineItem.CompanyCode

  
    inner join   I_SemTagGLAccount on  I_SemTagGLAccount.GLAccount       = I_GLAccountLineItem.GLAccount
                                   and I_SemTagGLAccount.ChartOfAccounts = I_GLAccountLineItem.ChartOfAccounts

  association [0..1] to I_SemanticTag                 as _SemanticTag                  on  $projection.SemanticTag = _SemanticTag.SemanticTag
  association [0..*] to I_GLAccountHierarchy          as _GLHierarchy                  on  $projection.GLAccountHierarchy = _GLHierarchy.GLAccountHierarchy
  association [0..1] to I_WBSElement                  as _WBSElement                   on  $projection.WBSElement = _WBSElement.WBSElement

  association [0..1] to I_WBSElementByExternalID      as _WBSElementExternalID         on  $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID
  association [0..1] to I_WBSElementByExternalID      as _WBSElementExternalIDText     on  $projection.WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID

  association [0..1] to I_ProjectByExternalID         as _ProjectExternalID            on  $projection.projectexternalid = _ProjectExternalID.ProjectExternalID
  association [0..1] to I_ProjectByExternalID         as _ProjectExternalIDText        on  $projection.projectexternalid = _ProjectExternalIDText.ProjectExternalID

  association [0..1] to I_ProjectByExternalID         as _PartnerProjectExternalID     on  $projection.PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID
  association [0..1] to I_ProjectByExternalID         as _PartnerProjectExternalIDText on  $projection.PartnerProjectExternalID = _PartnerProjectExternalIDText.ProjectExternalID

  association [0..1] to I_WBSElementBasicData         as _InvtrySpclStkWBSElmntBscData on  $projection.InvtrySpclStockWBSElmntIntID = _InvtrySpclStkWBSElmntBscData.WBSElementInternalID
  association [0..1] to I_WBSElementByExternalID      as _InvtrySpclStockWBSElmntExtID on  $projection.InvtrySpclStockWBSElmntExtID = _InvtrySpclStockWBSElmntExtID.WBSElementExternalID

  association [0..1] to I_WBSElementByExternalID      as _PartnerWBSElementExternalID  on  $projection.PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID
  association [0..1] to I_WBSElementByExternalID      as _PartnerWBSElementExtIDText   on  $projection.PartnerWBSElementExternalID = _PartnerWBSElementExtIDText.WBSElementExternalID

  association [0..1] to I_ProjectBasicData            as _ProjectBasicData             on  $projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID
  association [0..1] to I_ProjectBasicData            as _ProjectBasicDataText         on  $projection.ProjectInternalID = _ProjectBasicDataText.ProjectInternalID

  association [0..1] to I_WBSElementBasicData         as _WBSElementBasicData          on  $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
  association [0..1] to I_WBSElementBasicData         as _WBSElementBasicDataText      on  $projection.WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID

  association [0..1] to I_WBSElementBasicData         as _PartnerWBSElementBasicData   on  $projection.PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID
  association [0..1] to I_WBSElementBasicData         as _PartnerWBSElementBscDataText on  $projection.PartnerWBSElementInternalID = _PartnerWBSElementBscDataText.WBSElementInternalID

  association [0..1] to I_ProjectBasicData            as _PartnerProjectBasicData      on  $projection.PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID
  association [0..1] to I_ProjectBasicData            as _PartnerProjectBasicDataText  on  $projection.PartnerProjectInternalID = _PartnerProjectBasicDataText.ProjectInternalID
  association [0..1] to I_ProjectProfileCode           as _ProjectProfileCode            on $projection.projectprofilecode = _ProjectProfileCode.ProjectProfileCode
  association [0..1] to I_EnterpriseProjectElement     as _ProjectTask                 on $projection.WBSElementInternalID = _ProjectTask.WBSElementInternalID
  association [0..1] to I_EntProjProcessingStatus      as _ProcessingStatus            on $projection.processingstatus = _ProcessingStatus.ProcessingStatus
  association [0..1] to I_ActlHistSheetHierKeyFigSpec as _AssetKeyFigureSpecification  on  $projection.AssetAcctTransClassfctn   = _AssetKeyFigureSpecification.AssetAcctAnlytlTransClassfctn
                                                                                       and $projection.SubLedgerAcctLineItemType = _AssetKeyFigureSpecification.SubLedgerAcctLineItemType
  association [0..1] to I_AssetKeyFigure              as _AssetKeyFigure               on  $projection.AssetAccountingKeyFigure = _AssetKeyFigure.AssetAccountingKeyFigure
  association [0..*] to I_FinancialStatementHierarchy as _Hierarchy                    on  $projection.GLAccountHierarchy = _Hierarchy.GLAccountHierarchy
{
      @ObjectModel.foreignKey.association: '_Ledger'
  key I_GLAccountLineItem.Ledger,
      @ObjectModel.foreignKey.association: '_SourceLedger'
  key I_GLAccountLineItem.SourceLedger,
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key I_GLAccountLineItem.CompanyCode as CompanyCode,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key I_GLAccountLineItem.FiscalYear,
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key I_GLAccountLineItem.AccountingDocument,
  key I_GLAccountLineItem.LedgerGLLineItem,
      ///////////////////////////////////////////////////////////////////////

      // I_SemTagFuncArea

      ///////////////////////////////////////////////////////////////////////

      //      @ObjectModel.foreignKey.association: '_Hierarchy'

      //@Consumption.labelElement: 'Financial Statement Version'

  key I_SemTagGLAccount.GLAccountHierarchy,
      @ObjectModel.foreignKey.association: '_SemanticTag'
  key I_SemTagGLAccount.SemanticTag,
      @Semantics.businessDate.from: true
  key I_SemTagGLAccount.ValidityStartDate,
      @Semantics.businessDate.to: true
  key I_SemTagGLAccount.ValidityEndDate,

      @ObjectModel.foreignKey.association: '_LedgerFiscalYearForVariant'
      @Semantics.fiscal.year: false
      I_GLAccountLineItem.LedgerFiscalYear,
      I_GLAccountLineItem.GLRecordType,

      // Test workaround

      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
      I_GLAccountLineItem.ChartOfAccounts,
      @ObjectModel.foreignKey.association: '_ControllingArea'
      I_GLAccountLineItem.ControllingArea,

      ///////////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_00  Unified Journal Entry: Transaction, Currencies, Units

      ///////////////////////////////////////////////////////////////////////////////

      @ObjectModel.foreignKey.association: '_FinancialTransactionType'
      I_GLAccountLineItem.FinancialTransactionType,
      @ObjectModel.foreignKey.association: '_BusinessTransactionCategory'
      I_GLAccountLineItem.BusinessTransactionCategory,
      @ObjectModel.foreignKey.association: '_BusinessTransactionType'
      I_GLAccountLineItem.BusinessTransactionType,
      @ObjectModel.foreignKey.association: '_ReferenceDocumentType'
      I_GLAccountLineItem.ReferenceDocumentType,
      @ObjectModel.foreignKey.association: '_LogicalSystem'
      I_GLAccountLineItem.LogicalSystem,
      I_GLAccountLineItem.ReferenceDocumentContext,
      I_GLAccountLineItem.ReferenceDocument,
      I_GLAccountLineItem.ReferenceDocumentItem,
      I_GLAccountLineItem.ReferenceDocumentItemGroup,
      //SUBTA,

      I_GLAccountLineItem.IsReversal,
      I_GLAccountLineItem.IsReversed,
      //XTRUEREV,

      //AWTYP_REV,

      I_GLAccountLineItem.ReversalReferenceDocumentCntxt,
      I_GLAccountLineItem.ReversalReferenceDocument,
      //SUBTA_REV,

      I_GLAccountLineItem.IsSettlement,
      I_GLAccountLineItem.IsSettled,
      @ObjectModel.foreignKey.association: '_PredecessorReferenceDocType'
      I_GLAccountLineItem.PredecessorReferenceDocType,
      I_GLAccountLineItem.PredecessorReferenceDocCntxt,
      I_GLAccountLineItem.PredecessorReferenceDocument,
      I_GLAccountLineItem.PredecessorReferenceDocItem,
      //PREC_SUBTA,


      I_GLAccountLineItem.SourceReferenceDocumentType,
      I_GLAccountLineItem.SourceLogicalSystem,
      I_GLAccountLineItem.SourceReferenceDocumentCntxt,
      I_GLAccountLineItem.SourceReferenceDocument,
      I_GLAccountLineItem.SourceReferenceDocumentItem,
      I_GLAccountLineItem.SourceReferenceDocSubitem,
      I_GLAccountLineItem.IsCommitment,
      I_GLAccountLineItem.JrnlEntryItemObsoleteReason,

      @ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
      I_GLAccountLineItem.GLAccount,


      ////////////////////////////////////////////////////////////////////////////////////

      // .INCLUDE  ACDOC_SI_GL_ACCAS Unified Journal Entry: G/L additional account assignments

      ////////////////////////////////////////////////////////////////////////////////////

      @ObjectModel.foreignKey.association: '_CostCenter'
      I_GLAccountLineItem.CostCenter,
      @ObjectModel.foreignKey.association: '_ProfitCenter'
      I_GLAccountLineItem.ProfitCenter,
      @ObjectModel.foreignKey.association: '_FunctionalArea'
      I_GLAccountLineItem.FunctionalArea,
      @ObjectModel.foreignKey.association: '_BusinessArea'
      I_GLAccountLineItem.BusinessArea,
      @ObjectModel.foreignKey.association: '_Segment'
      I_GLAccountLineItem.Segment,
      @ObjectModel.foreignKey.association: '_PartnerCostCenter'
      I_GLAccountLineItem.PartnerCostCenter,
      @ObjectModel.foreignKey.association: '_PartnerProfitCenter'
      I_GLAccountLineItem.PartnerProfitCenter,
      @ObjectModel.foreignKey.association: '_PartnerFunctionalArea'
      I_GLAccountLineItem.PartnerFunctionalArea,
      @ObjectModel.foreignKey.association: '_PartnerBusinessArea'
      I_GLAccountLineItem.PartnerBusinessArea,
      @ObjectModel.foreignKey.association: '_PartnerCompany'
      I_GLAccountLineItem.PartnerCompany,
      I_GLAccountLineItem.PartnerSegment,


      /////////////////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_VALUE_DATA Unified Journal Entry: Value Fields

      /////////////////////////////////////////////////////////////////////////////////////


      @ObjectModel.foreignKey.association: '_BalanceTransactionCurrency'
//      @Semantics.currencyCode:true

      I_GLAccountLineItem.BalanceTransactionCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
      I_GLAccountLineItem.AmountInBalanceTransacCrcy,

      @ObjectModel.foreignKey.association: '_TransactionCurrency'
//      @Semantics.currencyCode:true

      I_GLAccountLineItem.TransactionCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      I_GLAccountLineItem.AmountInTransactionCurrency,

      @ObjectModel.foreignKey.association: '_CompanyCodeCurrency'

      I_GLAccountLineItem.CompanyCodeCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      I_GLAccountLineItem.AmountInCompanyCodeCurrency,

      ////////////////////////////////////

      // NEW

      @ObjectModel.foreignKey.association: '_GlobalCurrency'

      I_GLAccountLineItem.GlobalCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      I_GLAccountLineItem.AmountInGlobalCurrency,

      // Functional Currency

      @ObjectModel.foreignKey.association: '_FunctionalCurrency'

      I_GLAccountLineItem.FunctionalCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
      I_GLAccountLineItem.AmountInFunctionalCurrency,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency1'

      I_GLAccountLineItem.FreeDefinedCurrency1,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      I_GLAccountLineItem.AmountInFreeDefinedCurrency1,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency2'

      I_GLAccountLineItem.FreeDefinedCurrency2,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      I_GLAccountLineItem.AmountInFreeDefinedCurrency2,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency3'

      I_GLAccountLineItem.FreeDefinedCurrency3,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      I_GLAccountLineItem.AmountInFreeDefinedCurrency3,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency4'

      I_GLAccountLineItem.FreeDefinedCurrency4,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      I_GLAccountLineItem.AmountInFreeDefinedCurrency4,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency5'

      I_GLAccountLineItem.FreeDefinedCurrency5,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      I_GLAccountLineItem.AmountInFreeDefinedCurrency5,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency6'

      I_GLAccountLineItem.FreeDefinedCurrency6,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      I_GLAccountLineItem.AmountInFreeDefinedCurrency6,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency7'

      I_GLAccountLineItem.FreeDefinedCurrency7,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      I_GLAccountLineItem.AmountInFreeDefinedCurrency7,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency8'

      I_GLAccountLineItem.FreeDefinedCurrency8,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      I_GLAccountLineItem.AmountInFreeDefinedCurrency8,
      ////////////////////////////////////


      ////////////////////////////////////

      // NEW

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      I_GLAccountLineItem.FixedAmountInGlobalCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      I_GLAccountLineItem.GrpValnFixedAmtInGlobCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      I_GLAccountLineItem.PrftCtrValnFxdAmtInGlobCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      I_GLAccountLineItem.TotalPriceVarcInGlobalCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      I_GLAccountLineItem.GrpValnTotPrcVarcInGlobCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      I_GLAccountLineItem.PrftCtrValnTotPrcVarcInGlbCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      I_GLAccountLineItem.FixedPriceVarcInGlobalCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      I_GLAccountLineItem.GrpValnFixedPrcVarcInGlobCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      I_GLAccountLineItem.PrftCtrValnFxdPrcVarcInGlbCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      I_GLAccountLineItem.FixedAmountInCoCodeCrcy,
      ////////////////////////////////////



//      @Semantics.currencyCode:true

      I_GLAccountLineItem.ControllingObjectCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
      I_GLAccountLineItem.AmountInObjectCurrency,


      @ObjectModel.foreignKey.association: '_BaseUnit'
//      @Semantics.unitOfMeasure:true

      I_GLAccountLineItem.BaseUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      I_GLAccountLineItem.Quantity,

      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      I_GLAccountLineItem.FixedQuantity,

      @ObjectModel.foreignKey.association: '_CostSourceUnit'
//      @Semantics.unitOfMeasure:true

      I_GLAccountLineItem.CostSourceUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }
      I_GLAccountLineItem.ValuationQuantity,

      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }
      I_GLAccountLineItem.ValuationFixedQuantity,

      @ObjectModel.foreignKey.association: '_AdditionalQuantity1Unit'
//      @Semantics.unitOfMeasure:true

      I_GLAccountLineItem.AdditionalQuantity1Unit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity1Unit'} }
      I_GLAccountLineItem.AdditionalQuantity1,

      @ObjectModel.foreignKey.association: '_AdditionalQuantity2Unit'
//      @Semantics.unitOfMeasure:true

      I_GLAccountLineItem.AdditionalQuantity2Unit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity2Unit'} }
      I_GLAccountLineItem.AdditionalQuantity2,

      @ObjectModel.foreignKey.association: '_AdditionalQuantity3Unit'
//      @Semantics.unitOfMeasure:true

      I_GLAccountLineItem.AdditionalQuantity3Unit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity3Unit'} }
      I_GLAccountLineItem.AdditionalQuantity3,


      /////////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_FIX  Unified Journal Entry: Mandatory fields for G/L

      ////////////////////////////////////////////////////////////////////////////

      @ObjectModel.foreignKey.association: '_DebitCreditCode'
      I_GLAccountLineItem.DebitCreditCode,
      @ObjectModel.foreignKey.association: '_FiscalPeriodForVariant'
      I_GLAccountLineItem.FiscalPeriod,
      @ObjectModel.foreignKey.association: '_FiscalYearVariant'
      I_GLAccountLineItem.FiscalYearVariant,
      I_GLAccountLineItem.FiscalYearPeriod,
      I_GLAccountLineItem.PostingDate,
      I_GLAccountLineItem.DocumentDate,
      @ObjectModel.foreignKey.association: '_AccountingDocumentType'
      I_GLAccountLineItem.AccountingDocumentType,
      I_GLAccountLineItem.AccountingDocumentItem,
      I_GLAccountLineItem.AssignmentReference,
      @ObjectModel.foreignKey.association: '_AccountingDocumentCategory'
      I_GLAccountLineItem.AccountingDocumentCategory,
      @ObjectModel.foreignKey.association: '_PostingKey'
      I_GLAccountLineItem.PostingKey,
      I_GLAccountLineItem.TransactionTypeDetermination,
//      @ObjectModel.foreignKey.association: '_SubLedgerAccLineItemType'

      I_GLAccountLineItem.SubLedgerAcctLineItemType,
      //      @ObjectModel.foreignKey.association: '_User'

      I_GLAccountLineItem.AccountingDocCreatedByUser,
      I_GLAccountLineItem.LastChangeDateTime,
      I_GLAccountLineItem.CreationDateTime,
      I_GLAccountLineItem.CreationDate,
      @ObjectModel.foreignKey.association: '_EliminationProfitCenter'
      I_GLAccountLineItem.EliminationProfitCenter,
      I_GLAccountLineItem.OriginObjectType,
      @ObjectModel.foreignKey.association: '_GLAccountType'
      I_GLAccountLineItem.GLAccountType,
      @ObjectModel.foreignKey.association: '_AlternativeGLAccount'
      I_GLAccountLineItem.AlternativeGLAccount,
      @ObjectModel.foreignKey.association: '_CountryChartOfAccounts'
      I_GLAccountLineItem.CountryChartOfAccounts,


      ///////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_GEN  Unified Journal Entry: Fields for several subledgers

      //////////////////////////////////////////////////////////////////////////

      I_GLAccountLineItem.InvoiceReference,
      I_GLAccountLineItem.InvoiceReferenceFiscalYear,
      I_GLAccountLineItem.FollowOnDocumentType,
      I_GLAccountLineItem.InvoiceItemReference,
      I_GLAccountLineItem.ReferencePurchaseOrderCategory,
      @ObjectModel.foreignKey.association: '_PurchasingDocument'
      I_GLAccountLineItem.PurchasingDocument,
      @ObjectModel.foreignKey.association: '_PurchasingDocumentItem'
      I_GLAccountLineItem.PurchasingDocumentItem,
      I_GLAccountLineItem.AccountAssignmentNumber,
      I_GLAccountLineItem.DocumentItemText,
      @ObjectModel.foreignKey.association: '_SalesOrder'
      I_GLAccountLineItem.SalesOrder,
      @ObjectModel.foreignKey.association: '_SalesOrderItem'
      I_GLAccountLineItem.SalesOrderItem,
      @ObjectModel.foreignKey.association: '_SalesDocument'
      I_GLAccountLineItem.SalesDocument,
      @ObjectModel.foreignKey.association: '_Material'
      I_GLAccountLineItem.Material,
      @ObjectModel.foreignKey.association: '_Product'
      I_GLAccountLineItem.Product,
      @ObjectModel.foreignKey.association: '_Plant'
      I_GLAccountLineItem.Plant,
      @ObjectModel.foreignKey.association: '_Supplier'
      I_GLAccountLineItem.Supplier,
      @ObjectModel.foreignKey.association: '_Customer'
      I_GLAccountLineItem.Customer,

      I_GLAccountLineItem.ServicesRenderedDate,
      @ObjectModel.foreignKey.association: '_ConditionContract'
      I_GLAccountLineItem.ConditionContract,
      
      I_GLAccountLineItem.ComponentBreakdown,
      I_GLAccountLineItem.CompBreakdownScaleNumerator,
      
      /////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_FI  Unified Journal Entry: Fields for FI subledgers

      /////////////////////////////////////////////////////////////////////////

      @ObjectModel.foreignKey.association: '_FinancialAccountType'
      I_GLAccountLineItem.FinancialAccountType,
      @ObjectModel.foreignKey.association: '_SpecialGLCode'
      I_GLAccountLineItem.SpecialGLCode,
      //      @ObjectModel.foreignKey.association: '_TaxCode'

      I_GLAccountLineItem.TaxCode,
      @ObjectModel.foreignKey.association: '_HouseBank'
      I_GLAccountLineItem.HouseBank,
      @ObjectModel.foreignKey.association: '_HouseBankAccount'
      I_GLAccountLineItem.HouseBankAccount,
//      IsOpenItemManaged,

      I_GLAccountLineItem.ClearingDate,
      @ObjectModel.foreignKey.association: '_ClearingAccountingDocument'
      I_GLAccountLineItem.ClearingAccountingDocument,
      I_GLAccountLineItem.ClearingDocFiscalYear,


      /////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_FAA  Unified Journal Entry: Fields for Asset Accounting

      /////////////////////////////////////////////////////////////////////////

      I_GLAccountLineItem.AssetDepreciationArea,
      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
      I_GLAccountLineItem.MasterFixedAsset,
      @ObjectModel.foreignKey.association: '_FixedAsset'
      I_GLAccountLineItem.FixedAsset,
      I_GLAccountLineItem.AssetValueDate,
      @ObjectModel.foreignKey.association: '_AssetTransactionType'
      I_GLAccountLineItem.AssetTransactionType,
      @ObjectModel.foreignKey.association: '_MovementCategory'
      I_GLAccountLineItem.AssetAcctTransClassfctn,
      I_GLAccountLineItem.DepreciationFiscalPeriod,
      @ObjectModel.foreignKey.association: '_GroupMasterFixedAsset'
      I_GLAccountLineItem.GroupMasterFixedAsset,
      @ObjectModel.foreignKey.association: '_GroupFixedAsset'
      I_GLAccountLineItem.GroupFixedAsset,


      //////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_ML Unified Journal Entry: Fields for Material Ledger

      //////////////////////////////////////////////////////////////////////////

      I_GLAccountLineItem.CostEstimate,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:   'InvtrySpecialStockValnType_2'
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: 'InvtrySpecialStockValnType_2'
      @ObjectModel.foreignKey.association: '_InventorySpecialStockValnType'
      I_GLAccountLineItem.InventorySpecialStockValnType,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_InventorySpclStockValnType'
      I_GLAccountLineItem.InvtrySpecialStockValnType_2,
      //xobew,

      @ObjectModel.foreignKey.association: '_InventorySpecialStockType'
      I_GLAccountLineItem.InventorySpecialStockType,
      @ObjectModel.foreignKey.association: '_InventorySpclStkSalesDocument'
      I_GLAccountLineItem.InventorySpclStkSalesDocument, //  as InventorySpecialStockSalesDocument,

      @ObjectModel.foreignKey.association: '_InventorySpclStkSalesDocItm'
      I_GLAccountLineItem.InventorySpclStkSalesDocItm, //  as InventorySpecialStockSalesDocumentItem,

      @ObjectModel.foreignKey.association: '_InvtrySpclStockWBSElmntIntID'
      I_GLAccountLineItem.InvtrySpclStockWBSElmntIntID,
      @ObjectModel.foreignKey.association: '_InvtrySpclStockWBSElmntExtID'
      I_GLAccountLineItem._InvtrySpclStkWBSElmntBscData.WBSElementExternalID                                  as InvtrySpclStockWBSElmntExtID,
      @ObjectModel.foreignKey.association: '_InventorySpclStockWBSElement'
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:   'InvtrySpclStockWBSElmntIntID'
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: 'InvtrySpclStockWBSElmntIntID'
      I_GLAccountLineItem.InventorySpclStockWBSElement, //  as InventorySpecialStockWBSElement,

      @ObjectModel.foreignKey.association: '_InventorySpecialStockSupplier'
      I_GLAccountLineItem.InventorySpecialStockSupplier,
      @ObjectModel.foreignKey.association: '_InventoryValuationType'
      I_GLAccountLineItem.InventoryValuationType,
      @ObjectModel.foreignKey.association: '_Purreqvaluationarea'
      I_GLAccountLineItem.ValuationArea,


      ////////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_CFIN   Unified Journal Entry: Fields for Central Finance

      //////////////////////////////////////////////////////////////////////////////

      //@ObjectModel.foreignKey.association: '_SenderGLAccount'

      I_GLAccountLineItem.SenderGLAccount,
      I_GLAccountLineItem.SenderAccountAssignment,
      I_GLAccountLineItem.SenderAccountAssignmentType,


      ////////////////////////////////////////////////////////////////////////////

      //  .INCLUDE  ACDOC_SI_CO  Unified Journal Entry: CO fields

      ///////////////////////////////////////////////////////////////////////////

      //      @ObjectModel.foreignKey.association: '_CostOriginGroup'

      I_GLAccountLineItem.CostOriginGroup,
      @ObjectModel.foreignKey.association: '_OriginSenderObject'
      I_GLAccountLineItem.OriginSenderObject,
      @ObjectModel.foreignKey.association: '_ControllingDebitCreditCode'
      I_GLAccountLineItem.ControllingDebitCreditCode,
      I_GLAccountLineItem.ControllingObjectDebitType,
//      QuantityIsIncomplete,

      @ObjectModel.foreignKey.association: '_OffsettingAccountWithBP'
      I_GLAccountLineItem.OffsettingAccount,
      @ObjectModel.foreignKey.association: '_OffsettingAccountType'
      I_GLAccountLineItem.OffsettingAccountType,
      @ObjectModel.foreignKey.association: '_OffsettingChartOfAccounts'
      I_GLAccountLineItem.OffsettingChartOfAccounts,
      I_GLAccountLineItem.LineItemIsCompleted,
      I_GLAccountLineItem.PersonnelNumber,
      @ObjectModel.foreignKey.association: '_ControllingObjectClass'
      I_GLAccountLineItem.ControllingObjectClass,
      @ObjectModel.foreignKey.association: '_PartnerCompanyCode'
      I_GLAccountLineItem.PartnerCompanyCode,
      @ObjectModel.foreignKey.association: '_PartnerControllingObjectClass'
      I_GLAccountLineItem.PartnerControllingObjectClass,
      @ObjectModel.foreignKey.association: '_OriginCostCenter'
      I_GLAccountLineItem.OriginCostCenter,
      @ObjectModel.foreignKey.association: '_OriginProfitCenter'
      I_GLAccountLineItem.OriginProfitCenter,
      @ObjectModel.foreignKey.association: '_OriginCostCtrActivityType'
      I_GLAccountLineItem.OriginCostCtrActivityType,
      I_GLAccountLineItem.AccountAssignment,
      I_GLAccountLineItem.AccountAssignmentType,
      @ObjectModel.foreignKey.association: '_CostCtrActivityType'
      I_GLAccountLineItem.CostCtrActivityType,
      @ObjectModel.foreignKey.association: '_Order'
      I_GLAccountLineItem.OrderID,
      @ObjectModel.foreignKey.association: '_OrderCategory'
      I_GLAccountLineItem.OrderCategory,
      @ObjectModel.foreignKey.association: '_WBSElementInternalID'
      I_GLAccountLineItem.WBSElementInternalID,
      @ObjectModel.foreignKey.association: '_WBSElementExternalID'
      I_GLAccountLineItem._WBSElementBasicData.WBSElementExternalID                                           as WBSElementExternalID,
   
      @ObjectModel.foreignKey.association: '_ProcessingStatus'
      _ProjectTask.ProcessingStatus,//I_GLAccountLineItem.ProcessingStatus,   

      @ObjectModel.foreignKey.association: '_WBSElement'
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:   'WBSElementInternalID'
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: 'WBSElementInternalID'
      I_GLAccountLineItem.WBSElement,
      @ObjectModel.foreignKey.association: '_PartnerWBSElementBasicData'
      I_GLAccountLineItem.PartnerWBSElementInternalID,
      @ObjectModel.foreignKey.association: '_PartnerWBSElementExternalID'
      I_GLAccountLineItem._PartnerWBSElementBasicData.WBSElementExternalID                                    as PartnerWBSElementExternalID,
      @ObjectModel.foreignKey.association: '_ProjectInternalID'
      I_GLAccountLineItem.ProjectInternalID,
      @ObjectModel.foreignKey.association: '_ProjectExternalID'
      _ProjectBasicData.ProjectExternalID,//I_GLAccountLineItem.ProjectExternalID,

      @ObjectModel.foreignKey.association: '_Project'
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:   'ProjectInternalID'
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: 'ProjectInternalID'
      cast( I_GLAccountLineItem.Project as fis_rep_project preserving type )                                  as project,
      
      @ObjectModel.foreignKey.association: '_ProjectProfileCode'
      _ProjectBasicData.ProjectProfileCode,   //I_GLAccountLineItem.ProjectProfileCode,      

      @ObjectModel.foreignKey.association: '_PartnerProjectBasicData'
      I_GLAccountLineItem.PartnerProjectInternalID,
      @ObjectModel.foreignKey.association: '_PartnerProjectExternalID'
      I_GLAccountLineItem._PartnerProjectBasicData.ProjectExternalID                                          as PartnerProjectExternalID,
      @ObjectModel.foreignKey.association: '_OperatingConcern'
      I_GLAccountLineItem.OperatingConcern,
      @ObjectModel.foreignKey.association: '_ProjectNetwork'
      I_GLAccountLineItem.ProjectNetwork,
      //      @ObjectModel.foreignKey.association: '_RelatedNetworkActivity'

      I_GLAccountLineItem.RelatedNetworkActivity,
      @ObjectModel.foreignKey.association: '_BusinessProcess'
      I_GLAccountLineItem.BusinessProcess,
      I_GLAccountLineItem.CostObject,
      I_GLAccountLineItem.BillableControl,
      //bemot,

      @ObjectModel.foreignKey.association: '_CostAnalysisResource'
      I_GLAccountLineItem.CostAnalysisResource,
      I_GLAccountLineItem.CustomerServiceNotification,
      @ObjectModel.foreignKey.association: '_ServiceDocumentType'
      I_GLAccountLineItem.ServiceDocumentType,
      @ObjectModel.foreignKey.association: '_ServiceDocument'
      I_GLAccountLineItem.ServiceDocument,
      @ObjectModel.foreignKey.association: '_ServiceDocumentItem'
      I_GLAccountLineItem.ServiceDocumentItem,
      @ObjectModel.foreignKey.association: '_ServiceContractType'
      I_GLAccountLineItem.ServiceContractType,
      @ObjectModel.foreignKey.association: '_ServiceContract'
      I_GLAccountLineItem.ServiceContract,
      @ObjectModel.foreignKey.association: '_ServiceContractItem'
      I_GLAccountLineItem.ServiceContractItem,

      I_GLAccountLineItem.BusinessSolutionOrder,
      I_GLAccountLineItem.BusinessSolutionOrderItem,

      @ObjectModel.foreignKey.association: '_ProviderContract'
      I_GLAccountLineItem.ProviderContract,
      @ObjectModel.foreignKey.association: '_ProviderContractItem'
      I_GLAccountLineItem.ProviderContractItem,

      @ObjectModel.foreignKey.association: '_TimeSheetOvertimeCat'
      I_GLAccountLineItem.TimeSheetOvertimeCategory,

      I_GLAccountLineItem.PartnerAccountAssignment,
      I_GLAccountLineItem.PartnerAccountAssignmentType,
      @ObjectModel.foreignKey.association: '_PartnerCostCtrActivityType'
      I_GLAccountLineItem.PartnerCostCtrActivityType,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:    'PartnerOrder_2'
      @VDM.lifecycle.status:     #DEPRECATED
      @VDM.lifecycle.successor:  'PartnerOrder_2'
      @ObjectModel.foreignKey.association: '_PartnerOrder'
      I_GLAccountLineItem.PartnerOrder,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_PartnerOrder_2'
      I_GLAccountLineItem.PartnerOrder_2,
      @ObjectModel.foreignKey.association: '_PartnerOrderCategory'
      I_GLAccountLineItem.PartnerOrderCategory,
      @ObjectModel.foreignKey.association: '_PartnerWBSElement'
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:    'PartnerWBSElementInternalID'
      @VDM.lifecycle.status:     #DEPRECATED
      @VDM.lifecycle.successor:  'PartnerWBSElementInternalID'
      I_GLAccountLineItem.PartnerWBSElement,
      @ObjectModel.foreignKey.association: '_PartnerProject'
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:    'PartnerProjectInternalID'
      @VDM.lifecycle.status:     #DEPRECATED
      @VDM.lifecycle.successor:  'PartnerProjectInternalID'
      I_GLAccountLineItem.PartnerProject,
      @ObjectModel.foreignKey.association: '_PartnerSalesDocument'
      I_GLAccountLineItem.PartnerSalesDocument,
      @ObjectModel.foreignKey.association: '_PartnerSalesDocumentItem'
      I_GLAccountLineItem.PartnerSalesDocumentItem,
      I_GLAccountLineItem.PartnerProjectNetwork,
      //      @ObjectModel.foreignKey.association: '_PartnerProjectNetworkActivity'

      I_GLAccountLineItem.PartnerProjectNetworkActivity,
      @ObjectModel.foreignKey.association: '_PartnerBusinessProcess'
      I_GLAccountLineItem.PartnerBusinessProcess,
      I_GLAccountLineItem.PartnerCostObject,

      //////////////////////////////////////////////////////////////////////

      //  .INCLUDE  ACDOC_SI_COPA  Unified Journal Entry: CO-PA fields

      //////////////////////////////////////////////////////////////////////

      @ObjectModel.foreignKey.association: '_BillingDocumentType'
      I_GLAccountLineItem.BillingDocumentType,
      @ObjectModel.foreignKey.association: '_SalesOrganization'
      I_GLAccountLineItem.SalesOrganization,
      @ObjectModel.foreignKey.association: '_DistributionChannel'
      I_GLAccountLineItem.DistributionChannel,
      I_GLAccountLineItem.OrganizationDivision,
      @ObjectModel.foreignKey.association: '_SoldMaterial'
      I_GLAccountLineItem.SoldMaterial,
      @ObjectModel.foreignKey.association: '_SoldProduct'
      I_GLAccountLineItem.SoldProduct,
      @ObjectModel.foreignKey.association: '_MaterialGroup'
      I_GLAccountLineItem.MaterialGroup,
      @ObjectModel.foreignKey.association: '_SoldProductGroup'
      I_GLAccountLineItem.SoldProductGroup,
      @ObjectModel.foreignKey.association: '_ProductGroup'
      I_GLAccountLineItem.ProductGroup,
      @ObjectModel.foreignKey.association: '_CustomerGroup'
      I_GLAccountLineItem.CustomerGroup,
      @ObjectModel.foreignKey.association: '_CustomerSupplierCountry'
      I_GLAccountLineItem.CustomerSupplierCountry,
      I_GLAccountLineItem.CustomerSupplierIndustry,
      @ObjectModel.foreignKey.association: '_SalesDistrict'
      I_GLAccountLineItem.SalesDistrict,
      @ObjectModel.foreignKey.association: '_BillToParty'
      I_GLAccountLineItem.BillToParty,
      @ObjectModel.foreignKey.association: '_ShipToParty'
      I_GLAccountLineItem.ShipToParty,
      I_GLAccountLineItem.CustomerSupplierCorporateGroup,


      //////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_PS  Unified Journal Entry: Fields for Public Sector

      /////////////////////////////////////////////////////////////////////

      @ObjectModel.foreignKey.association: '_FinancialManagementArea'
      I_GLAccountLineItem.FinancialManagementArea,
      @ObjectModel.foreignKey.association: '_Fund'
      I_GLAccountLineItem.Fund,
      I_GLAccountLineItem.GrantID,
      @ObjectModel.foreignKey.association: '_BudgetPeriod'
      I_GLAccountLineItem.BudgetPeriod,
      @ObjectModel.foreignKey.association: '_PartnerFund'
      I_GLAccountLineItem.PartnerFund,
      I_GLAccountLineItem.PartnerGrant,
      I_GLAccountLineItem.PartnerBudgetPeriod,
      @ObjectModel.foreignKey.association: '_FundsCenter'
      I_GLAccountLineItem.FundsCenter,
      I_GLAccountLineItem.FundedProgram,

      ///////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_JVA  Unified Journal Entry: Fields for Joint Venture Accounting

      ///////////////////////////////////////////////////////////////////////

      I_GLAccountLineItem.JointVenture,
      I_GLAccountLineItem.JointVentureEquityGroup,
      I_GLAccountLineItem.JointVentureCostRecoveryCode,
      //vptnr,

      //btype,

      I_GLAccountLineItem.JointVentureEquityType,
      //prodper,


      ///////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_RE STRU  0 0 Unified Journal Entry: Fields for Real Estate

      ///////////////////////////////////////////////////////////////////////

      //swenr,

      //sgenr,

      //sgrnr,

      //smenr,

      //recnnr,

      //snksl,

      //sempsl,

      I_GLAccountLineItem.SettlementReferenceDate,
      //pswenr,

      //psgenr,

      //psgrnr,

      //psmenr,

      //precnnr,

      //psnksl,

      //psempsl,

      //pdabrz

      I_GLAccountLineItem.WorkCenterInternalID,
      I_GLAccountLineItem.OrderOperation,
      I_GLAccountLineItem.OrderItem,

      //////////////////////////////////////////////////

      // .INCLUDE  ACDOC_SI_LOG_ACT:  New Fields  PM  //

      //////////////////////////////////////////////////

      //@ObjectModel.foreignKey.association: '_MaintenanceOrderSubOperation'

      I_GLAccountLineItem.OrderSuboperation,
      @ObjectModel.foreignKey.association: '_Equipment'
      I_GLAccountLineItem.Equipment,
//      @ObjectModel.foreignKey.association: '_FunctionalLocation'

//      FunctionalLocation,

      @ObjectModel.foreignKey.association: '_Assembly'
      I_GLAccountLineItem.Assembly,
      @ObjectModel.foreignKey.association: '_MaintenanceActivityType'
      I_GLAccountLineItem.MaintenanceActivityType,
      @ObjectModel.foreignKey.association: '_MaintOrdPlngDegreeCode'
      I_GLAccountLineItem.MaintenanceOrderPlanningCode,
      @ObjectModel.foreignKey.association: '_PMNotificationPriorityType'
      I_GLAccountLineItem.MaintPriorityType,
      @ObjectModel.foreignKey.association: '_PMNotificationPriority'
      I_GLAccountLineItem.MaintPriority,
      @ObjectModel.foreignKey.association: '_SuperiorOrder'
      I_GLAccountLineItem.SuperiorOrder,
      I_GLAccountLineItem.MaintenanceOrderIsPlanned,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      I_GLAccountLineItem.DebitAmountInCoCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      I_GLAccountLineItem.CreditAmountInCoCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      I_GLAccountLineItem.DebitAmountInTransCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      I_GLAccountLineItem.CreditAmountInTransCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
      I_GLAccountLineItem.DebitAmountInBalanceTransCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
      I_GLAccountLineItem.CreditAmountInBalanceTransCrcy,

      ////////////////////////////////////

      // NEW

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      I_GLAccountLineItem.DebitAmountInGlobalCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      I_GLAccountLineItem.CreditAmountInGlobalCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
      I_GLAccountLineItem.DebitAmountInFunctionalCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
      I_GLAccountLineItem.CreditAmountInFunctionalCrcy,
//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }

//      DebitAmountInFreeDefinedCrcy1                                                       as DebitAmountInFreeDfndCrcy1,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }

//      CreditAmountInFreeDefinedCrcy1                                                      as CreditAmountInFreeDfndCrcy1,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }

//      DebitAmountInFreeDefinedCrcy2                                                       as DebitAmountInFreeDfndCrcy2,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }

//      CreditAmountInFreeDefinedCrcy2                                                      as CreditAmountInFreeDfndCrcy2,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }

//      DebitAmountInFreeDefinedCrcy3                                                       as DebitAmountInFreeDfndCrcy3,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }

//      CreditAmountInFreeDefinedCrcy3                                                      as CreditAmountInFreeDfndCrcy3,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }

//      DebitAmountInFreeDefinedCrcy4                                                       as DebitAmountInFreeDfndCrcy4,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }

//      CreditAmountInFreeDefinedCrcy4                                                      as CreditAmountInFreeDfndCrcy4,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }

//      DebitAmountInFreeDefinedCrcy5                                                       as DebitAmountInFreeDfndCrcy5,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }

//      CreditAmountInFreeDefinedCrcy5                                                      as CreditAmountInFreeDfndCrcy5,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }

//      DebitAmountInFreeDefinedCrcy6                                                       as DebitAmountInFreeDfndCrcy6,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }

//      CreditAmountInFreeDefinedCrcy6                                                      as CreditAmountInFreeDfndCrcy6,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }

//      DebitAmountInFreeDefinedCrcy7                                                       as DebitAmountInFreeDfndCrcy7,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }

//      CreditAmountInFreeDefinedCrcy7                                                      as CreditAmountInFreeDfndCrcy7,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }

//      DebitAmountInFreeDefinedCrcy8                                                       as DebitAmountInFreeDfndCrcy8,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }

//      CreditAmountInFreeDefinedCrcy8                                                      as CreditAmountInFreeDfndCrcy8,

      //////////////////////////////////



      I_GLAccountLineItem.IsStatisticalOrder,
      I_GLAccountLineItem.IsStatisticalCostCenter,
      I_GLAccountLineItem.IsStatisticalSalesDocument,
      I_GLAccountLineItem.WBSIsStatisticalWBSElement,

      ///////////////////////////////////////////////////////////////////////

      // Additional requested fields

      ///////////////////////////////////////////////////////////////////////

      //      @ObjectModel.foreignKey.association: '_FiscalQuarter'

      I_GLAccountLineItem._FiscalCalendarDate.FiscalQuarter                                                   as FiscalQuarter,
      I_GLAccountLineItem._FiscalCalendarDate.FiscalYearQuarter                                               as FiscalYearQuarter,

      //      _Employment._Employee.Employee                                                                                               as Employee,

      //      _Employment._Employee.EmployeeFullName                                                                                       as EmployeeFullName,


      @ObjectModel.foreignKey.association: '_AssetKeyFigure'
      cast(_AssetKeyFigureSpecification.AssetAccountingKeyFigure as fis_asset_key_figure) as AssetAccountingKeyFigure,


      ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

      // Key Figures

      ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////



      /////////////////////////////////////////////////////////////////////////////

      // Fixed Semantic Tags

      /////////////////////////////////////////////////////////////////////////////

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      @DefaultAggregation: #SUM
      case when I_SemTagGLAccount.SemanticTag = 'ASSET' then cast (I_GLAccountLineItem.AmountInCompanyCodeCurrency as fis_asset_hsl)
      else cast ( cast ('0' as abap.curr( 23,2))   as fis_asset_hsl) end                  as AssetAmtInCCCrcy,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      @DefaultAggregation: #SUM
      case when I_SemTagGLAccount.SemanticTag = 'LIAB_EQUIT' then cast (I_GLAccountLineItem.AmountInCompanyCodeCurrency * (-1) as fis_liab_equity_hsl)
      else cast ( cast ('0' as abap.curr( 23,2))   as fis_liab_equity_hsl) end            as LiabilityEquityAmtInCCCrcy,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      @DefaultAggregation: #SUM
      case when I_SemTagGLAccount.SemanticTag = 'UNASSIGNED' then cast (I_GLAccountLineItem.AmountInCompanyCodeCurrency as fis_unassigned_hsl)
      else cast ( cast ('0' as abap.curr( 23,2))   as fis_unassigned_hsl) end             as NotAssignedAmtInCCCrcy,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      @DefaultAggregation: #SUM
      case when I_SemTagGLAccount.SemanticTag = 'NETRESULT' then cast (I_GLAccountLineItem.AmountInCompanyCodeCurrency * (-1) as fis_netresult_hsl)
      else cast ( cast ('0' as abap.curr( 23,2))   as fis_netresult_hsl) end              as NetResultAmtInCCCrcy,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      @DefaultAggregation: #SUM
      case when I_SemTagGLAccount.SemanticTag = 'PL_RESULT' then cast (I_GLAccountLineItem.AmountInCompanyCodeCurrency * (-1) as fins_cfs_pl_result)
      else cast ( cast ('0' as abap.curr( 23,2))   as fins_cfs_pl_result) end             as PnLResultAmtInCCCrcy,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      @DefaultAggregation: #SUM
      case when I_SemTagGLAccount.SemanticTag = 'NTINC_ALAC' then cast (I_GLAccountLineItem.AmountInCompanyCodeCurrency * (-1) as fis_ntinc_alac_hsl)
      else cast ( cast ('0' as abap.curr( 23,2))   as fis_ntinc_alac_hsl) end             as GLAcctNetIncomeAmtInCCCrcy,

      ///////////////////////////////////////////////////////////////////////

      // Associations

      ///////////////////////////////////////////////////////////////////////


      I_GLAccountLineItem._JournalEntry,
      I_GLAccountLineItem._CompanyCode,
      I_GLAccountLineItem._FiscalYear,
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: '_FiscalPeriodForVariant'
      I_GLAccountLineItem._FiscalPeriod,
      I_GLAccountLineItem._FiscalPeriodForVariant,
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: '_LedgerFiscalYearForVariant'
      I_GLAccountLineItem._LedgerFiscalYear,
      I_GLAccountLineItem._LedgerFiscalYearForVariant,
      I_GLAccountLineItem._FiscalYearVariant,
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: '_FiscalYearPeriodForVariant'
      I_GLAccountLineItem._FiscalYearPeriod,
      I_GLAccountLineItem._FiscalYearPeriodForVariant,
      I_GLAccountLineItem._CalendarDate,
      I_GLAccountLineItem._FiscalCalendarDate,
      I_GLAccountLineItem._ControllingArea,
      I_GLAccountLineItem._BalanceTransactionCurrency,
      I_GLAccountLineItem._TransactionCurrency,
      I_GLAccountLineItem._CompanyCodeCurrency,
      I_GLAccountLineItem._GlobalCurrency,
      I_GLAccountLineItem._FunctionalCurrency,
      I_GLAccountLineItem._FreeDefinedCurrency1,
      I_GLAccountLineItem._FreeDefinedCurrency2,
      I_GLAccountLineItem._FreeDefinedCurrency3,
      I_GLAccountLineItem._FreeDefinedCurrency4,
      I_GLAccountLineItem._FreeDefinedCurrency5,
      I_GLAccountLineItem._FreeDefinedCurrency6,
      I_GLAccountLineItem._FreeDefinedCurrency7,
      I_GLAccountLineItem._FreeDefinedCurrency8,
      I_GLAccountLineItem._BaseUnit,
      I_GLAccountLineItem._CostSourceUnit,
      I_GLAccountLineItem._AdditionalQuantity1Unit,
      I_GLAccountLineItem._AdditionalQuantity2Unit,
      I_GLAccountLineItem._AdditionalQuantity3Unit,
      I_GLAccountLineItem._Segment,
      I_GLAccountLineItem._ProfitCenter,
      I_GLAccountLineItem._CurrentProfitCenter,
      I_GLAccountLineItem._CostCenter,
      I_GLAccountLineItem._CurrentCostCenter,
      I_GLAccountLineItem._CostAnalysisResource,
      _ProcessingStatus,//I_GLAccountLineItem._ProcessingStatus,

      _WBSElement,
      I_GLAccountLineItem._WBSElementInternalID,
      _WBSElementExternalID,
      I_GLAccountLineItem._Project,
      _ProjectProfileCode,
      _ProjectExternalID,
      I_GLAccountLineItem._BusinessArea,
      I_GLAccountLineItem._FunctionalArea,
      I_GLAccountLineItem._GLAccountInChartOfAccounts,
      I_GLAccountLineItem._GLAccountInCompanyCode,
      I_GLAccountLineItem._ChartOfAccounts,
      I_GLAccountLineItem._AccountingDocumentType,
      I_GLAccountLineItem._FinancialAccountType,
      I_GLAccountLineItem._DebitCreditCode,
      I_GLAccountLineItem._Material,
      I_GLAccountLineItem._Product,
      I_GLAccountLineItem._Plant,
      I_GLAccountLineItem._Ledger,
      I_GLAccountLineItem._SourceLedger,

      I_GLAccountLineItem._Customer,
      I_GLAccountLineItem._CustomerGroup,

      I_GLAccountLineItem._Supplier,

      I_GLAccountLineItem._MaterialGroup,
      I_GLAccountLineItem._ProductGroup,

      I_GLAccountLineItem._SalesOrder,
      I_GLAccountLineItem._SalesOrderItem,
      I_GLAccountLineItem._SalesDocument,
      I_GLAccountLineItem._InternalOrder,
      I_GLAccountLineItem._Order,

      //      _Employment,

      I_GLAccountLineItem._FinancialTransactionType,
      I_GLAccountLineItem._BusinessTransactionCategory,
      I_GLAccountLineItem._BusinessTransactionType,
      I_GLAccountLineItem._ReferenceDocumentType,
      I_GLAccountLineItem._PredecessorReferenceDocType,

      I_GLAccountLineItem._PartnerCostCenter,
      I_GLAccountLineItem._PartnerProfitCenter,
      I_GLAccountLineItem._PartnerBusinessArea,
      I_GLAccountLineItem._PartnerFunctionalArea,
      I_GLAccountLineItem._PartnerCompanyCode,
      I_GLAccountLineItem._PartnerSegment,

      I_GLAccountLineItem._AccountingDocumentCategory,

      I_GLAccountLineItem._PostingKey,
//      _SubLedgerAccLineItemType,

      I_GLAccountLineItem._User,

      I_GLAccountLineItem._EliminationProfitCenter,

      //_ControllingObject,


      I_GLAccountLineItem._GLAccountType,
      I_GLAccountLineItem._OffsettingAccountType,
      I_GLAccountLineItem._OffsettingChartOfAccounts,
      I_GLAccountLineItem._OffsettingAccount,
      I_GLAccountLineItem._OffsettingAccountWithBP,
      I_GLAccountLineItem._AlternativeGLAccount,
      //_SenderGLAccount,

      I_GLAccountLineItem._CountryChartOfAccounts,

      I_GLAccountLineItem._PurchasingDocument,
      I_GLAccountLineItem._PurchasingDocumentItem,

      I_GLAccountLineItem._SpecialGLCode,
      I_GLAccountLineItem._TaxCode,

      I_GLAccountLineItem._HouseBank,

      I_GLAccountLineItem._ClearingAccountingDocument,

      I_GLAccountLineItem._FixedAsset,
      I_GLAccountLineItem._MasterFixedAsset,
      I_GLAccountLineItem._GroupMasterFixedAsset,
      I_GLAccountLineItem._GroupFixedAsset,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:    '_InventorySpclStockValnType'
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: '_InventorySpclStockValnType'
      I_GLAccountLineItem._InventorySpecialStockValnType,
      I_GLAccountLineItem._InventorySpclStockValnType,
      I_GLAccountLineItem._InventorySpecialStockType,
      I_GLAccountLineItem._InventorySpclStkSalesDocument,
      I_GLAccountLineItem._InventorySpclStkSalesDocItm,
      I_GLAccountLineItem._InvtrySpclStockWBSElmntIntID,
      I_GLAccountLineItem._InventorySpclStockWBSElement,
      I_GLAccountLineItem._InventorySpecialStockSupplier,
      I_GLAccountLineItem._InventoryValuationType,
      I_GLAccountLineItem._ControllingDebitCreditCode,
      I_GLAccountLineItem._OriginSenderObject,
      I_GLAccountLineItem._ControllingObjectClass,
      I_GLAccountLineItem._PartnerControllingObjectClass,
      I_GLAccountLineItem._OriginCostCenter,
      I_GLAccountLineItem._OriginProfitCenter,
      I_GLAccountLineItem._CostCtrActivityType,
      I_GLAccountLineItem._OriginCostCtrActivityType,
      I_GLAccountLineItem._OrderCategory,
      //_RelatedNetworkActivity,

      //_PartnerProjectNetworkActivity,


      I_GLAccountLineItem._BusinessProcess,
      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._PartnerWBSElement,
      I_GLAccountLineItem._PartnerProject,
      I_GLAccountLineItem._PartnerSalesDocument,
      I_GLAccountLineItem._PartnerSalesDocumentItem,
      I_GLAccountLineItem._PartnerBusinessProcess,

      I_GLAccountLineItem._BillingDocumentType,

      I_GLAccountLineItem._SalesOrganization,
      I_GLAccountLineItem._DistributionChannel,

      I_GLAccountLineItem._SoldMaterial,
      I_GLAccountLineItem._SoldProduct,

      I_GLAccountLineItem._Fund,
      I_GLAccountLineItem._PartnerFund,
      I_GLAccountLineItem._FundsCenter,

      I_GLAccountLineItem._MovementCategory,
      I_GLAccountLineItem._AssetTransactionType,

      I_GLAccountLineItem._BudgetPeriod,

      I_GLAccountLineItem._CostOriginGroup,

      I_GLAccountLineItem._CustomerSupplierCountry,
      I_GLAccountLineItem._SalesDistrict,
      I_GLAccountLineItem._BillToParty,
      I_GLAccountLineItem._ShipToParty,

      I_GLAccountLineItem._FinancialManagementArea,
      //_FundedProgram


      I_GLAccountLineItem._HouseBankAccount,

      I_GLAccountLineItem._LogicalSystem,

      I_GLAccountLineItem._OperatingConcern,

      I_GLAccountLineItem._PartnerCompany,

      I_GLAccountLineItem._ProjectNetwork,

      I_GLAccountLineItem._PurReqValuationArea,

      //_Extension  Extensions must be local


     _SemanticTag,
      //      _Hierarchy,


      I_GLAccountLineItem._Equipment,
//      _FunctionalLocation,

      I_GLAccountLineItem._MaintenanceActivityType,
      I_GLAccountLineItem._MaintOrdPlngDegreeCode,
      I_GLAccountLineItem._PMNotificationPriorityType,
      I_GLAccountLineItem._PMNotificationPriority,
      I_GLAccountLineItem._MaintenanceOrderSubOperation,
      I_GLAccountLineItem._Assembly,
      I_GLAccountLineItem._SuperiorOrder,
      I_GLAccountLineItem._ProjectInternalID,
      I_GLAccountLineItem._ConditionContract,
      I_GLAccountLineItem._SoldProductGroup,

      I_GLAccountLineItem._ServiceDocumentType,
      I_GLAccountLineItem._ServiceDocument,
      I_GLAccountLineItem._ServiceDocumentItem,
      I_GLAccountLineItem._ServiceContract,
      I_GLAccountLineItem._ServiceContractItem,
      I_GLAccountLineItem._ServiceContractType,

      I_GLAccountLineItem._ProviderContract,
      I_GLAccountLineItem._ProviderContractItem,

      I_GLAccountLineItem._TimeSheetOvertimeCat,

      _WBSElementBasicData,
      _WBSElementBasicDataText,
      _ProjectBasicData,
      _ProjectBasicDataText,
      _PartnerProjectExternalID,
      _PartnerProjectExternalIDText,
      _PartnerWBSElementExternalID,
      _PartnerWBSElementExtIDText,
      _PartnerProjectBasicData,
      _PartnerProjectBasicDataText,
      _PartnerWBSElementBasicData,
      _PartnerWBSElementBscDataText,

      _InvtrySpclStkWBSElmntBscData,
      _InvtrySpclStockWBSElmntExtID,

      I_GLAccountLineItem.GLAccountAuthorizationGroup,
      I_GLAccountLineItem.SupplierBasicAuthorizationGrp,
      I_GLAccountLineItem.CustomerBasicAuthorizationGrp,
      I_GLAccountLineItem.AcctgDocTypeAuthorizationGroup,
      I_GLAccountLineItem.OrderType,
      I_GLAccountLineItem.SalesOrderType,
      I_GLAccountLineItem.AssetClass,
      ///////////////////////////////////////////////////////////////////////

      // Additional requested associations

      ///////////////////////////////////////////////////////////////////////

      _AssetKeyFigure

}

where
     ( I_SemTagGLAccount.SemanticTag          = 'NTINC_ALAC'
  or I_SemTagGLAccount.FunctionalAreaIsUsed = ''
  or I_SemTagGLAccount.FunctionalAreaIsUsed is null )
  and I_SemTagGLAccount.ValidityStartDate <= $session.system_date
  and I_SemTagGLAccount.ValidityEndDate   >= $session.system_date