P_AllocRunJournalEntryItem1

@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PALLOCRUNJEI1'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL

@VDM.viewType: #CONSUMPTION
@VDM.private: true

@Metadata.ignorePropagatedAnnotations: true

define view P_AllocRunJournalEntryItem1
  as select from P_AllocRunJournalEntryItem as Document  
  inner join I_GLAccountLineItemRawData as JournalEntryItem on JournalEntryItem.ReferenceDocumentType = 'ACAL'
                                                    and JournalEntryItem.ReferenceDocumentContext = Document.FiscalYear
                                                    and JournalEntryItem.ReferenceDocument = Document.ReferenceDocumentNumber
//                                                    and JournalEntryItem.FiscalPeriod = Document.FiscalPeriod

                                                    and JournalEntryItem.FiscalYear = Document.FiscalYear
//                                                    and JournalEntryItem.Ledger = Document.Ledger    

                                                    and (  JournalEntryItem.BusinessTransactionType = 'ACPA'
                                                        or JournalEntryItem.BusinessTransactionType = 'ACPD'
                                                        or JournalEntryItem.BusinessTransactionType = 'ACAA'
                                                        or JournalEntryItem.BusinessTransactionType = 'ACAD'
                                                        or JournalEntryItem.BusinessTransactionType = 'ACAC'
                                                        or JournalEntryItem.BusinessTransactionType = 'APPA'
                                                        or JournalEntryItem.BusinessTransactionType = 'APPD'
                                                        or JournalEntryItem.BusinessTransactionType = 'APAD'
                                                        or JournalEntryItem.BusinessTransactionType = 'APAA'
                                                        or JournalEntryItem.BusinessTransactionType = 'AJAA'
                                                        or JournalEntryItem.BusinessTransactionType = 'AJAD'
                                                        or JournalEntryItem.BusinessTransactionType = 'AAAT'
                                                        or JournalEntryItem.BusinessTransactionType = 'AMAA'
                                                        or JournalEntryItem.BusinessTransactionType = 'AMAD'
                                                        or JournalEntryItem.BusinessTransactionType = 'AMPA'
                                                        or JournalEntryItem.BusinessTransactionType = 'AMPD' ) 
  
//  association[0..1] to I_JournalEntry as _JournalEntry on _JournalEntry.ReferenceDocumentType = 'ACAL'

//                                                           and _JournalEntry.FiscalYear = Document.FiscalYear

//                                                           and _ReversalDocument.DocumentReferenceID = Document.ReferenceDocumentNumber

//                                                           and _ReversalDocument.Ledger = JournalEntryItem.Ledger  

//                                                           

// ReverseDocument,

//stjah as ReverseDocumentFiscalYear,                                                 

  
{
  key Document.UniversalAllocationRun,
  key Document.AllocationCycle,
  key Document.AllocationCycleStartDate,
  key Document.FiscalYear,
  key Document.FiscalPeriod,
  key Document.AllocDocumentSequenceNumber,
  key JournalEntryItem.AccountingDocument,
  key JournalEntryItem.LedgerGLLineItem,
      Document.AllocationType,
      Document.AllocationActualPlanVariant,
      Document.AllocationPostingType,
      Document.AllocationCycleName,
      Document.ReferenceDocumentNumber,
      Document.ReversalReferenceDocument,
//      Document.Ledger,

//      Document.ReferenceDocumentNumber,

      JournalEntryItem.SourceLedger as Ledger,
//      @ObjectModel.text.element: ['CompanyCodeName']

      JournalEntryItem.CompanyCode,
//      _CompanyCodeText.CompanyCodeName,

      JournalEntryItem.LedgerFiscalYear,
      JournalEntryItem.GLRecordType,
      JournalEntryItem.FinancialTransactionType,
      JournalEntryItem.BusinessTransactionType,
      JournalEntryItem.ReferenceDocumentType,
      JournalEntryItem.LogicalSystem,
      JournalEntryItem.ReferenceDocumentContext,
      JournalEntryItem.ReferenceDocument,
      JournalEntryItem.ReferenceDocumentItem,
      JournalEntryItem.ReferenceDocumentItemGroup,
      JournalEntryItem.IsReversal,
      JournalEntryItem.IsReversed,
      JournalEntryItem.ReversalReferenceDocumentCntxt,
//      JournalEntryItem.ReversalReferenceDocument,

      JournalEntryItem.IsSettlement,
      JournalEntryItem.IsSettled,
      JournalEntryItem.PredecessorReferenceDocType,
      JournalEntryItem.PredecessorReferenceDocCntxt,
      JournalEntryItem.PredecessorReferenceDocument,
      JournalEntryItem.PredecessorReferenceDocItem,
      JournalEntryItem.SourceReferenceDocumentType,
      JournalEntryItem.SourceLogicalSystem,
      JournalEntryItem.SourceReferenceDocumentCntxt,
      JournalEntryItem.SourceReferenceDocument,
      JournalEntryItem.SourceReferenceDocumentItem,
      JournalEntryItem.SourceReferenceDocSubitem,
      JournalEntryItem.IsCommitment,
      JournalEntryItem.JrnlEntryItemObsoleteReason,
      JournalEntryItem.BalanceTransactionCurrency,
      JournalEntryItem.TransactionCurrency,
      JournalEntryItem.CompanyCodeCurrency,
      JournalEntryItem.GlobalCurrency,
      JournalEntryItem.FreeDefinedCurrency1,
      JournalEntryItem.FreeDefinedCurrency2,
      JournalEntryItem.FreeDefinedCurrency3,
      JournalEntryItem.FreeDefinedCurrency4,
      JournalEntryItem.FreeDefinedCurrency5,
      JournalEntryItem.FreeDefinedCurrency6,
      JournalEntryItem.FreeDefinedCurrency7,
      JournalEntryItem.FreeDefinedCurrency8,
      JournalEntryItem.ControllingObjectCurrency,
      JournalEntryItem.BaseUnit,
      JournalEntryItem.CostSourceUnit,
      JournalEntryItem.AdditionalQuantity1Unit,
      JournalEntryItem.AdditionalQuantity2Unit,
      JournalEntryItem.AdditionalQuantity3Unit,
//      JournalEntryItem.@ObjectModel.text.element: ['GLAccountName']

      JournalEntryItem.GLAccount,
//      JournalEntryItem._GLAcctInChartOfAccountsText.GLAccountName,

//      JournalEntryItem.@ObjectModel.text.element: ['CostCenterName']

      JournalEntryItem.CostCenter,
//      JournalEntryItem._CostCenterText.CostCenterName,

//      JournalEntryItem.@ObjectModel.text.element: ['ProfitCenterName']

      JournalEntryItem.ProfitCenter,
//      JournalEntryItem._ProfitCenterText.ProfitCenterName,

      JournalEntryItem.FunctionalArea,
      JournalEntryItem.BusinessArea,
      JournalEntryItem.ControllingArea,
      JournalEntryItem.Segment,
      JournalEntryItem.PartnerCostCenter,
      JournalEntryItem.PartnerProfitCenter,
      JournalEntryItem.PartnerFunctionalArea,
      JournalEntryItem.PartnerBusinessArea,
      JournalEntryItem.PartnerCompany,
      JournalEntryItem.PartnerSegment,
      JournalEntryItem.AmountInBalanceTransacCrcy,
      JournalEntryItem.AmountInTransactionCurrency,
      JournalEntryItem.AmountInCompanyCodeCurrency,
      JournalEntryItem.AmountInGlobalCurrency,
      JournalEntryItem.AmountInFreeDefinedCurrency1,
      JournalEntryItem.AmountInFreeDefinedCurrency2,
      JournalEntryItem.AmountInFreeDefinedCurrency3,
      JournalEntryItem.AmountInFreeDefinedCurrency4,
      JournalEntryItem.AmountInFreeDefinedCurrency5,
      JournalEntryItem.AmountInFreeDefinedCurrency6,
      JournalEntryItem.AmountInFreeDefinedCurrency7,
      JournalEntryItem.AmountInFreeDefinedCurrency8,
      JournalEntryItem.FixedAmountInGlobalCrcy,
      JournalEntryItem.GrpValnFixedAmtInGlobCrcy,
      JournalEntryItem.PrftCtrValnFxdAmtInGlobCrcy,
      JournalEntryItem.TotalPriceVarcInGlobalCrcy,
      JournalEntryItem.GrpValnTotPrcVarcInGlobCrcy,
      JournalEntryItem.PrftCtrValnTotPrcVarcInGlbCrcy,
      JournalEntryItem.FixedPriceVarcInGlobalCrcy,
      JournalEntryItem.GrpValnFixedPrcVarcInGlobCrcy,
      JournalEntryItem.PrftCtrValnFxdPrcVarcInGlbCrcy,
      JournalEntryItem.AmountInObjectCurrency,
      JournalEntryItem.Quantity,
      JournalEntryItem.FixedQuantity,
      JournalEntryItem.ValuationQuantity,
      JournalEntryItem.ValuationFixedQuantity,
      JournalEntryItem.AdditionalQuantity1,
      JournalEntryItem.AdditionalQuantity2,
      JournalEntryItem.AdditionalQuantity3,
      JournalEntryItem.DebitCreditCode,
//      JournalEntryItem.FiscalPeriod,

      JournalEntryItem.FiscalYearVariant,
      JournalEntryItem.FiscalYearPeriod,
      JournalEntryItem.PostingDate,
      JournalEntryItem.DocumentDate,
      JournalEntryItem.AccountingDocumentType,
      JournalEntryItem.AccountingDocumentItem,
      JournalEntryItem.AssignmentReference,
      JournalEntryItem.PostingKey,
      JournalEntryItem.AccountingDocumentCategory,
      JournalEntryItem.TransactionTypeDetermination,
      JournalEntryItem.SubLedgerAcctLineItemType,
      JournalEntryItem.AccountingDocCreatedByUser,
      JournalEntryItem.CreationDateTime,
      JournalEntryItem.EliminationProfitCenter,
      JournalEntryItem.OriginObjectType,
      JournalEntryItem.GLAccountType,
      JournalEntryItem.ChartOfAccounts,
      JournalEntryItem.AlternativeGLAccount,
      JournalEntryItem.CountryChartOfAccounts,
      JournalEntryItem.InvoiceReference,
      JournalEntryItem.InvoiceReferenceFiscalYear,
      JournalEntryItem.InvoiceItemReference,
      JournalEntryItem.FollowOnDocumentType,
      JournalEntryItem.ReferencePurchaseOrderCategory,
      JournalEntryItem.PurchasingDocument,
      JournalEntryItem.PurchasingDocumentItem,
      JournalEntryItem.AccountAssignmentNumber,
      JournalEntryItem.DocumentItemText,
      cast(JournalEntryItem.SalesDocument as vdm_sales_order preserving type ) as SalesOrder,
      JournalEntryItem.SalesDocumentItem,
      cast(JournalEntryItem.Product as matnr preserving type ) as Material,
      JournalEntryItem.Plant,
      JournalEntryItem.Supplier,
      JournalEntryItem.Customer,
      JournalEntryItem.ServicesRenderedDate,
      JournalEntryItem.ConditionContract,
      JournalEntryItem.FinancialAccountType,
      JournalEntryItem.SpecialGLCode,
      JournalEntryItem.TaxCode,
      JournalEntryItem.HouseBank,
      JournalEntryItem.HouseBankAccount,
      JournalEntryItem.IsOpenItemManaged,
      JournalEntryItem.ClearingDate,
      JournalEntryItem.ClearingAccountingDocument,
      JournalEntryItem.ClearingDocFiscalYear,
      JournalEntryItem.AssetDepreciationArea,
      JournalEntryItem.MasterFixedAsset,
      JournalEntryItem.FixedAsset,
      JournalEntryItem.AssetValueDate,
      JournalEntryItem.AssetTransactionType,
      JournalEntryItem.AssetAcctTransClassfctn,
      JournalEntryItem.DepreciationFiscalPeriod,
      JournalEntryItem.GroupMasterFixedAsset,
      JournalEntryItem.GroupFixedAsset,
      JournalEntryItem.AssetClass,
      JournalEntryItem.CostEstimate,
      JournalEntryItem.InventorySpecialStockValnType,
      JournalEntryItem.InventorySpecialStockType,
      JournalEntryItem.InventorySpclStkSalesDocument,
      JournalEntryItem.InventorySpclStkSalesDocItm,
      JournalEntryItem.InvtrySpclStockWBSElmntIntID,
      JournalEntryItem.InventorySpclStockWBSElement,
      JournalEntryItem.InventorySpecialStockSupplier,
      JournalEntryItem.InventoryValuationType,
      JournalEntryItem.ValuationArea,
      JournalEntryItem.SenderGLAccount,
      JournalEntryItem.SenderAccountAssignment,
      JournalEntryItem.SenderAccountAssignmentType,
      JournalEntryItem.ControllingObject,
      JournalEntryItem.CostOriginGroup,
      JournalEntryItem.OriginSenderObject,
      JournalEntryItem.ControllingDebitCreditCode,
      JournalEntryItem.ControllingObjectDebitType,
      JournalEntryItem.QuantityIsIncomplete,
      JournalEntryItem.OffsettingAccount,
      JournalEntryItem.OffsettingAccountType,
      JournalEntryItem.LineItemIsCompleted,
      JournalEntryItem.PersonnelNumber,
      JournalEntryItem.ControllingObjectClass,
      JournalEntryItem.PartnerCompanyCode,
      JournalEntryItem.PartnerControllingObjectClass,
      JournalEntryItem.OriginCostCenter,
      JournalEntryItem.OriginCostCtrActivityType,
      JournalEntryItem.OriginProfitCenter,
      JournalEntryItem.AccountAssignment,
      JournalEntryItem.AccountAssignmentType,
      JournalEntryItem.CostCtrActivityType,
      JournalEntryItem.OrderID,
      JournalEntryItem.OrderCategory,
      JournalEntryItem.WBSElementInternalID,
//      JournalEntryItem.WBSElementExternalID,

//      JournalEntryItem.@ObjectModel.text.element: ['WBSDescription']

      JournalEntryItem.WBSElement,
//      JournalEntryItem._WBSElementText._WBSElementLangBsdDesc[1:Language = $session.system_language].WBSElementLangBsdDescription,

//      JournalEntryItem._WBSElementText.WBSDescription,

      JournalEntryItem.ProjectInternalID,
      JournalEntryItem.Project,
      JournalEntryItem.ProjectNetwork,
      JournalEntryItem.RelatedNetworkActivity,
      JournalEntryItem.BusinessProcess,
      JournalEntryItem.CostObject,
      JournalEntryItem.BillableControl,
      JournalEntryItem.CostAnalysisResource,
      JournalEntryItem.CustomerServiceNotification,
      JournalEntryItem.ServiceDocumentType,
      JournalEntryItem.ServiceDocument,
      JournalEntryItem.ServiceDocumentItem,
      JournalEntryItem.ServiceContractType,
      JournalEntryItem.ServiceContract,
      JournalEntryItem.ServiceContractItem,
      JournalEntryItem.BusinessSolutionOrder,
      JournalEntryItem.BusinessSolutionOrderItem,
      JournalEntryItem.TimeSheetOvertimeCategory,
      JournalEntryItem.WorkPackage,
      JournalEntryItem.WorkItem,
      JournalEntryItem.OperatingConcern,
      JournalEntryItem.PartnerAccountAssignment,
      JournalEntryItem.PartnerAccountAssignmentType,
      JournalEntryItem.PartnerCostCtrActivityType,
      JournalEntryItem.PartnerOrder,
      JournalEntryItem.PartnerOrderCategory,
      JournalEntryItem.PartnerWBSElementInternalID,
      JournalEntryItem.PartnerWBSElement,
      JournalEntryItem.PartnerProjectInternalID,
      JournalEntryItem.PartnerProject,
      JournalEntryItem.PartnerSalesDocument,
      JournalEntryItem.PartnerSalesDocumentItem,
      JournalEntryItem.PartnerProjectNetwork,
      JournalEntryItem.PartnerProjectNetworkActivity,
      JournalEntryItem.PartnerBusinessProcess,
      JournalEntryItem.PartnerCostObject,
      JournalEntryItem.BillingDocumentType,
      JournalEntryItem.SalesOrganization,
      JournalEntryItem.DistributionChannel,
      JournalEntryItem.OrganizationDivision,
      JournalEntryItem.SoldProduct,
      JournalEntryItem.SoldProductGroup,
      JournalEntryItem.CustomerGroup,
      JournalEntryItem.CustomerSupplierCountry,
      JournalEntryItem.CustomerSupplierIndustry,
      JournalEntryItem.SalesDistrict,
      JournalEntryItem.BillToParty,
      JournalEntryItem.ShipToParty,
      JournalEntryItem.CustomerSupplierCorporateGroup,
//    JournalEntryItem.  VolumeRebateGroup,

//    JournalEntryItem.  SalesGroup,

//    JournalEntryItem.  MaterialABCClassification,

//    JournalEntryItem.  SalesOffice,

//    JournalEntryItem.  ProductHierarchy,

      JournalEntryItem.FinancialManagementArea,
      JournalEntryItem.FundsCenter,
      JournalEntryItem.FundedProgram,
      JournalEntryItem.Fund,
      JournalEntryItem.GrantID,
      JournalEntryItem.BudgetPeriod,
      JournalEntryItem.PartnerFund,
      JournalEntryItem.PartnerGrant,
      JournalEntryItem.PartnerBudgetPeriod,
      JournalEntryItem.JointVenture,
      JournalEntryItem.JointVentureEquityGroup,
      JournalEntryItem.JointVentureCostRecoveryCode,
      JournalEntryItem.JointVenturePartner,
      JournalEntryItem.JointVentureBillingType,
      JournalEntryItem.JointVentureEquityType,
      JournalEntryItem.JointVentureProductionDate,
      JournalEntryItem.JointVentureBillingDate,
      JournalEntryItem.JointVentureOperationalDate,
      JournalEntryItem.CutbackRun,
      JournalEntryItem.JointVentureAccountingActivity,
      cast( JournalEntryItem.PartnerVenture as fco_alloc_run_partner_venture preserving type ) as PartnerVenture,
      JournalEntryItem.PartnerEquityGroup,
      JournalEntryItem.SenderCostRecoveryCode,
      JournalEntryItem.CutbackAccount,
      JournalEntryItem.CutbackCostObject,
      JournalEntryItem.SettlementReferenceDate,
      JournalEntryItem.ControllingBusTransacType,
      JournalEntryItem.PrdcssrJournalEntryCompanyCode,
      JournalEntryItem.PrdcssrJournalEntryFiscalYear,
      JournalEntryItem.PredecessorJournalEntry,
      JournalEntryItem.PredecessorJournalEntryItem,
      JournalEntryItem.OrganizationalChange,
      JournalEntryItem.GrantCurrency,
      JournalEntryItem.AmountInGrantCurrency,
      JournalEntryItem.ReferenceQuantityUnit,
      JournalEntryItem.ReferenceQuantity,
      JournalEntryItem.LastChangeDateTime,
      JournalEntryItem.SalesDocument,
      JournalEntryItem.Product,
      JournalEntryItem.PerformancePeriodStartDate,
      JournalEntryItem.PerformancePeriodEndDate,
      JournalEntryItem.TaxCountry,
      JournalEntryItem.ValueDate,
      JournalEntryItem.SenderCompanyCode,
      JournalEntryItem.OriginCtrlgDebitCreditCode,
      JournalEntryItem.OriginProduct,
      JournalEntryItem.VarianceOriginGLAccount,
      JournalEntryItem.PartnerServiceDocumentType,
      JournalEntryItem.PartnerServiceDocument,
      JournalEntryItem.PartnerServiceDocumentItem,
      JournalEntryItem.CashLedgerCompanyCode,
      JournalEntryItem.CashLedgerAccount,
      JournalEntryItem.PubSecBudgetAccount,
      JournalEntryItem.PubSecBudgetAccountCoCode,
      JournalEntryItem.PubSecBudgetCnsmpnDate,
      JournalEntryItem.PubSecBudgetCnsmpnFsclPeriod,
      JournalEntryItem.PubSecBudgetCnsmpnFsclYear,
      JournalEntryItem.PubSecBudgetIsRelevant,
      JournalEntryItem.PubSecBudgetCnsmpnType,
      JournalEntryItem.PubSecBudgetCnsmpnAmtType,
      JournalEntryItem.SponsoredProgram,
      JournalEntryItem.SponsoredClass,
      JournalEntryItem.REBusinessEntity,
      JournalEntryItem.RealEstateBuilding,
      JournalEntryItem.RealEstateProperty,
      JournalEntryItem.RERentalObject,
      JournalEntryItem.RealEstateContract,
      JournalEntryItem.REServiceChargeKey,
      JournalEntryItem.RESettlementUnitID,
      JournalEntryItem.REPartnerBusinessEntity,
      JournalEntryItem.RealEstatePartnerBuilding,
      JournalEntryItem.RealEstatePartnerProperty,
      JournalEntryItem.REPartnerRentalObject,
      JournalEntryItem.RealEstatePartnerContract,
      JournalEntryItem.REPartnerServiceChargeKey,
      JournalEntryItem.REPartnerSettlementUnitID,
      JournalEntryItem.PartnerSettlementReferenceDate,
      JournalEntryItem.FunctionalCurrency,
      JournalEntryItem.AmountInFunctionalCurrency,
      Document.AllocationRunStartDateTime
//      _ReversalDocument.AccountingDocument as ReversalAccountingDocument

//      JournalEntryItem.StatisticalKeyFigure

}     
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEMRAWDATA",
"P_ALLOCRUNJOURNALENTRYITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/