@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@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_GLAcctLineItemSemTagRevProj
as select from I_GLAccountLineItem
inner join P_EnterpriseProject_F7479 as EnterpriseProject on EnterpriseProject.ProjectInternalID = I_GLAccountLineItem.ProjectInternalID
// and EnterpriseProject.CompanyCode = I_GLAccountLineItem.CompanyCode
and EnterpriseProject.ProjectProfileCode = 'YP05'
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_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,
@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,
// @Aggregation.default: #SUM
// @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
// I_GLAccountLineItem.AmountInBalanceTransacCrcy,
@ObjectModel.foreignKey.association: '_TransactionCurrency'
I_GLAccountLineItem.TransactionCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
I_GLAccountLineItem.AmountInTransactionCurrency,
@ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
// @Semantics.currencyCode:true
I_GLAccountLineItem.CompanyCodeCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
I_GLAccountLineItem.AmountInCompanyCodeCurrency,
////////////////////////////////////
// NEW
@ObjectModel.foreignKey.association: '_GlobalCurrency'
// @Semantics.currencyCode:true
I_GLAccountLineItem.GlobalCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_GLAccountLineItem.AmountInGlobalCurrency,
// Functional Currency
@ObjectModel.foreignKey.association: '_FunctionalCurrency'
//@Semantics.currencyCode:true
I_GLAccountLineItem.FunctionalCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
I_GLAccountLineItem.AmountInFunctionalCurrency,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency1'
//@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
I_GLAccountLineItem.AmountInFreeDefinedCurrency1,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency2'
//@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
I_GLAccountLineItem.AmountInFreeDefinedCurrency2,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency3'
//@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
I_GLAccountLineItem.AmountInFreeDefinedCurrency3,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency4'
//@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency4,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
I_GLAccountLineItem.AmountInFreeDefinedCurrency4,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency5'
//@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency5,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
I_GLAccountLineItem.AmountInFreeDefinedCurrency5,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency6'
// @Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency6,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
I_GLAccountLineItem.AmountInFreeDefinedCurrency6,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency7'
//@Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency7,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
I_GLAccountLineItem.AmountInFreeDefinedCurrency7,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency8'
// @Semantics.currencyCode:true
I_GLAccountLineItem.FreeDefinedCurrency8,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
I_GLAccountLineItem.AmountInFreeDefinedCurrency8,
////////////////////////////////////
////////////////////////////////////
// NEW
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_GLAccountLineItem.FixedAmountInGlobalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_GLAccountLineItem.GrpValnFixedAmtInGlobCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_GLAccountLineItem.PrftCtrValnFxdAmtInGlobCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_GLAccountLineItem.TotalPriceVarcInGlobalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_GLAccountLineItem.GrpValnTotPrcVarcInGlobCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_GLAccountLineItem.PrftCtrValnTotPrcVarcInGlbCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_GLAccountLineItem.FixedPriceVarcInGlobalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_GLAccountLineItem.GrpValnFixedPrcVarcInGlobCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_GLAccountLineItem.PrftCtrValnFxdPrcVarcInGlbCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
I_GLAccountLineItem.FixedAmountInCoCodeCrcy,
////////////////////////////////////
//@Semantics.currencyCode:true
I_GLAccountLineItem.ControllingObjectCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
I_GLAccountLineItem.AmountInObjectCurrency,
@ObjectModel.foreignKey.association: '_BaseUnit'
I_GLAccountLineItem.BaseUnit,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
I_GLAccountLineItem.Quantity,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
I_GLAccountLineItem.FixedQuantity,
@ObjectModel.foreignKey.association: '_CostSourceUnit'
I_GLAccountLineItem.CostSourceUnit,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }
I_GLAccountLineItem.ValuationQuantity,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }
I_GLAccountLineItem.ValuationFixedQuantity,
@ObjectModel.foreignKey.association: '_AdditionalQuantity1Unit'
I_GLAccountLineItem.AdditionalQuantity1Unit,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity1Unit'} }
I_GLAccountLineItem.AdditionalQuantity1,
@ObjectModel.foreignKey.association: '_AdditionalQuantity2Unit'
I_GLAccountLineItem.AdditionalQuantity2Unit,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity2Unit'} }
I_GLAccountLineItem.AdditionalQuantity2,
@ObjectModel.foreignKey.association: '_AdditionalQuantity3Unit'
I_GLAccountLineItem.AdditionalQuantity3Unit,
@Aggregation.default: #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,
I_GLAccountLineItem.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,
I_GLAccountLineItem.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'
// _WBSElementBasicData.WBSElementExternalID as WBSElementExternalID,
// @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'
// _PartnerWBSElementBasicData.WBSElementExternalID as PartnerWBSElementExternalID,
// @ObjectModel.foreignKey.association: '_ProjectInternalID'
I_GLAccountLineItem.ProjectInternalID,
// @ObjectModel.foreignKey.association: '_ProjectExternalID'
_ProjectBasicData.ProjectExternalID,
EnterpriseProject.ProjectUUID,
//@ObjectModel.foreignKey.association: '_Project'
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ProjectInternalID'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ProjectInternalID'
I_GLAccountLineItem.Project,
// @ObjectModel.foreignKey.association: '_PartnerProjectBasicData'
// I_GLAccountLineItem.PartnerProjectInternalID,
// @ObjectModel.foreignKey.association: '_PartnerProjectExternalID'
// _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'
I_GLAccountLineItem.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,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
I_GLAccountLineItem.DebitAmountInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
I_GLAccountLineItem.CreditAmountInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
I_GLAccountLineItem.DebitAmountInTransCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
I_GLAccountLineItem.CreditAmountInTransCrcy,
// @Aggregation.default: #SUM
// @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
// I_GLAccountLineItem.DebitAmountInBalanceTransCrcy,
// @Aggregation.default: #SUM
// @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
// I_GLAccountLineItem.CreditAmountInBalanceTransCrcy,
////////////////////////////////////
// NEW
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_GLAccountLineItem.DebitAmountInGlobalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_GLAccountLineItem.CreditAmountInGlobalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
I_GLAccountLineItem.DebitAmountInFunctionalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
I_GLAccountLineItem.CreditAmountInFunctionalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy1 as DebitAmountInFreeDfndCrcy1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy1 as CreditAmountInFreeDfndCrcy1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy2 as DebitAmountInFreeDfndCrcy2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy2 as CreditAmountInFreeDfndCrcy2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy3 as DebitAmountInFreeDfndCrcy3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy3 as CreditAmountInFreeDfndCrcy3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy4 as DebitAmountInFreeDfndCrcy4,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy4 as CreditAmountInFreeDfndCrcy4,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy5 as DebitAmountInFreeDfndCrcy5,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy5 as CreditAmountInFreeDfndCrcy5,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy6 as DebitAmountInFreeDfndCrcy6,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy6 as CreditAmountInFreeDfndCrcy6,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy7 as DebitAmountInFreeDfndCrcy7,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy7 as CreditAmountInFreeDfndCrcy7,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy8 as DebitAmountInFreeDfndCrcy8,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
I_GLAccountLineItem.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,
EnterpriseProject.ProjectProfileCode,
EnterpriseProject.ProjectManagerUUID,
EnterpriseProject._ProjectManager.BusinessPartner as ProjectManager,
EnterpriseProject.AvailabilityControlProfile,
EnterpriseProject.AvailabilityControlIsActive,
// _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'
@Aggregation.default: #SUM
case when I_SemTagGLAccount.SemanticTag = 'ASSET' then cast (I_GLAccountLineItem.AmountInCompanyCodeCurrency as fis_asset_hsl preserving type)
else cast ( cast ('0' as abap.curr( 23,2)) as fis_asset_hsl preserving type) end as AssetAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@Aggregation.default: #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 preserving type) end as LiabilityEquityAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@Aggregation.default: #SUM
case when I_SemTagGLAccount.SemanticTag = 'UNASSIGNED' then cast (I_GLAccountLineItem.AmountInCompanyCodeCurrency as fis_unassigned_hsl preserving type)
else cast ( cast ('0' as abap.curr( 23,2)) as fis_unassigned_hsl preserving type) end as NotAssignedAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@Aggregation.default: #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 preserving type) end as NetResultAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@Aggregation.default: #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'
@Aggregation.default: #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,
//I_GLAccountLineItem._WBSElement,
//I_GLAccountLineItem._WBSElementInternalID,
// _WBSElementExternalID,
//I_GLAccountLineItem._Project,
// _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,
I_GLAccountLineItem._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,
I_GLAccountLineItem._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,
EnterpriseProject._ProjectManager,
// _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
//_ProjectBasicData.ProjectProfileCode = 'YP05' and
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