P_AvgDailyBalACDOCAItem

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'PADBKFCITEM'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED

define view P_AvgDailyBalACDOCAItem
  as select from    I_GLAccountLineItem as I_GLAccountLineItem
    left outer to one join I_FiscalYearPeriod  as fip  on  fip.FiscalYearVariant = I_GLAccountLineItem.FiscalYearVariant
                                                and fip.FiscalYear        = I_GLAccountLineItem.LedgerFiscalYear
                                                and fip.FiscalPeriod      = I_GLAccountLineItem.FiscalPeriod
    left outer to one join I_FiscalYearPeriod  as fip0 on  fip0.FiscalYearVariant = I_GLAccountLineItem.FiscalYearVariant
                                                and fip0.FiscalYear        = I_GLAccountLineItem.LedgerFiscalYear
                                                and fip0.FiscalPeriod      = '001'

{
  key I_GLAccountLineItem.Ledger as Ledger,
  key I_GLAccountLineItem.CompanyCode,
  key I_GLAccountLineItem.FiscalYear,
  key I_GLAccountLineItem.AccountingDocument,
  key I_GLAccountLineItem.LedgerGLLineItem,

  I_GLAccountLineItem.SourceLedger as SourceLedger,

      I_GLAccountLineItem.LedgerFiscalYear,
      cast( I_GLAccountLineItem.LedgerFiscalYear as fis_ryear_flow preserving type ) as FlowOfFundsLedgerFiscalYear,
      I_GLAccountLineItem.GLRecordType,
      I_GLAccountLineItem.FinancialTransactionType,
      I_GLAccountLineItem.ControllingBusTransacType,
      I_GLAccountLineItem.BusinessTransactionType,
      I_GLAccountLineItem.ReferenceDocumentContext,
      I_GLAccountLineItem.ReferenceDocument,
      I_GLAccountLineItem.ReferenceDocumentItem,
      I_GLAccountLineItem.ReferenceDocumentItemGroup,
      TransactionSubitem,
      I_GLAccountLineItem.IsReversal,
      I_GLAccountLineItem.IsReversed,
      I_GLAccountLineItem.ReversalReferenceDocumentCntxt,
      I_GLAccountLineItem.ReversalReferenceDocument,
      I_GLAccountLineItem.IsSettlement,
      I_GLAccountLineItem.IsSettled,
      I_GLAccountLineItem.PredecessorReferenceDocType,
      I_GLAccountLineItem.PredecessorReferenceDocCntxt,
      I_GLAccountLineItem.PredecessorReferenceDocument,
      I_GLAccountLineItem.PredecessorReferenceDocItem,
      I_GLAccountLineItem.SourceReferenceDocumentType,
      I_GLAccountLineItem.SourceLogicalSystem,
      I_GLAccountLineItem.SourceReferenceDocumentCntxt,
      I_GLAccountLineItem.SourceReferenceDocument,
      I_GLAccountLineItem.SourceReferenceDocumentItem,
      I_GLAccountLineItem.SourceReferenceDocSubitem,
      I_GLAccountLineItem.IsCommitment,
      I_GLAccountLineItem.JrnlEntryItemObsoleteReason,
      I_GLAccountLineItem.BalanceTransactionCurrency,
      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.ControllingObjectCurrency,
      I_GLAccountLineItem.BaseUnit,
      I_GLAccountLineItem.CostSourceUnit,
      I_GLAccountLineItem.GLAccount,
      I_GLAccountLineItem.CostCenter,
      I_GLAccountLineItem.ProfitCenter,
      I_GLAccountLineItem.FunctionalArea,
      I_GLAccountLineItem.BusinessArea,
      I_GLAccountLineItem.Segment,
      I_GLAccountLineItem.ControllingArea,
      I_GLAccountLineItem.PartnerCostCenter,
      I_GLAccountLineItem.PartnerProfitCenter,
      I_GLAccountLineItem.PartnerFunctionalArea,
      I_GLAccountLineItem.PartnerBusinessArea,
      I_GLAccountLineItem.PartnerCompany,
      I_GLAccountLineItem.PartnerSegment,
      I_GLAccountLineItem.AmountInBalanceTransacCrcy,
      I_GLAccountLineItem.AmountInCompanyCodeCurrency,
      I_GLAccountLineItem.AmountInGlobalCurrency,
      I_GLAccountLineItem.AmountInFunctionalCurrency,
      I_GLAccountLineItem.AmountInFreeDefinedCurrency1,
      I_GLAccountLineItem.AmountInFreeDefinedCurrency2,
      I_GLAccountLineItem.AmountInFreeDefinedCurrency3,
      I_GLAccountLineItem.AmountInFreeDefinedCurrency4,
      I_GLAccountLineItem.AmountInFreeDefinedCurrency5,
      I_GLAccountLineItem.AmountInFreeDefinedCurrency6,
      I_GLAccountLineItem.AmountInFreeDefinedCurrency7,
      I_GLAccountLineItem.AmountInFreeDefinedCurrency8,
      I_GLAccountLineItem.TotalPriceVarcInGlobalCrcy,
      I_GLAccountLineItem.FixedPriceVarcInGlobalCrcy,
      I_GLAccountLineItem.Quantity,
      I_GLAccountLineItem.ValuationQuantity,
      I_GLAccountLineItem.DebitCreditCode,
      I_GLAccountLineItem.FiscalPeriod,
      I_GLAccountLineItem.FiscalYearVariant,
      I_GLAccountLineItem.FiscalYearPeriod,
      case
        when PostingDate = '00000000'
        then case
             when I_GLAccountLineItem.FiscalPeriod = '000'
             then fip0.FiscalPeriodStartDate
             else fip.FiscalPeriodStartDate
             end
        else PostingDate
        end                                                                                          as PostingDate,
      case
      when I_GLAccountLineItem.FiscalPeriod = '000'
      then fip0.FiscalPeriodStartDate
      else dats_add_days( fip.FiscalPeriodEndDate, 1, 'NULL' )
      end                                                                                            as next_period_start,
      I_GLAccountLineItem.DocumentDate,
      I_GLAccountLineItem.AccountingDocumentType,
      I_GLAccountLineItem.AccountingDocumentItem,
      I_GLAccountLineItem.AssignmentReference,
      I_GLAccountLineItem.PostingKey,
      I_GLAccountLineItem.AccountingDocumentCategory,
      I_GLAccountLineItem.TransactionTypeDetermination,
      I_GLAccountLineItem.SubLedgerAcctLineItemType,
      I_GLAccountLineItem.AccountingDocCreatedByUser,
      I_GLAccountLineItem.LastChangeDateTime,
      I_GLAccountLineItem.EliminationProfitCenter,
      I_GLAccountLineItem.OriginObjectType,
      I_GLAccountLineItem.GLAccountType,
      I_GLAccountLineItem.ChartOfAccounts,
      I_GLAccountLineItem.AlternativeGLAccount,
      I_GLAccountLineItem.CountryChartOfAccounts,
      I_GLAccountLineItem.InvoiceReference,
      I_GLAccountLineItem.InvoiceReferenceFiscalYear,
      I_GLAccountLineItem.FollowOnDocumentType,
      I_GLAccountLineItem.InvoiceItemReference,
      I_GLAccountLineItem.ReferencePurchaseOrderCategory,
      I_GLAccountLineItem.PurchasingDocument,
      I_GLAccountLineItem.PurchasingDocumentItem,
      I_GLAccountLineItem.AccountAssignmentNumber,
      I_GLAccountLineItem.DocumentItemText,
      I_GLAccountLineItem.SalesDocument,
      I_GLAccountLineItem.SalesDocumentItem,
      I_GLAccountLineItem.Product,
      I_GLAccountLineItem.Plant,
      I_GLAccountLineItem.Supplier,
      I_GLAccountLineItem.Customer,
      I_GLAccountLineItem.ServicesRenderedDate,
      I_GLAccountLineItem.ConditionContract,
      I_GLAccountLineItem.FinancialAccountType,
      I_GLAccountLineItem.SpecialGLCode,
      //       '_TaxCode'

      I_GLAccountLineItem.TaxCode,
      I_GLAccountLineItem.HouseBank,
      I_GLAccountLineItem.HouseBankAccount,
      I_GLAccountLineItem.IsOpenItemManaged,
      I_GLAccountLineItem.ClearingDate,
      I_GLAccountLineItem.ClearingAccountingDocument,
      I_GLAccountLineItem.ClearingDocFiscalYear,
      I_GLAccountLineItem.AssetDepreciationArea,
      I_GLAccountLineItem.MasterFixedAsset,
      I_GLAccountLineItem.FixedAsset,
      I_GLAccountLineItem.AssetValueDate,
      I_GLAccountLineItem.AssetTransactionType,
      I_GLAccountLineItem.AssetAcctTransClassfctn,
      I_GLAccountLineItem.DepreciationFiscalPeriod,
      I_GLAccountLineItem.GroupMasterFixedAsset,
      I_GLAccountLineItem.GroupFixedAsset,
      I_GLAccountLineItem.AssetClass,
      I_GLAccountLineItem.CostEstimate,
      I_GLAccountLineItem.InventorySpecialStockValnType,
      //xobew,

      I_GLAccountLineItem.InventorySpecialStockType,
      I_GLAccountLineItem.InventorySpclStkSalesDocument, //  as InventorySpecialStockSalesDocument,

      I_GLAccountLineItem.InventorySpclStkSalesDocItm, //  as InventorySpecialStockSalesDocumentItem,

      I_GLAccountLineItem.InvtrySpclStockWBSElmntIntID,
      cast( I_GLAccountLineItem.InventorySpclStockWBSElement as fis_invspstock_wbs preserving type ) as InventorySpclStockWBSElement, //  as InventorySpecialStockWBSElement,

      I_GLAccountLineItem.InventorySpecialStockSupplier,
      I_GLAccountLineItem.InventoryValuationType,
      I_GLAccountLineItem.ValuationArea,
      I_GLAccountLineItem.SenderGLAccount,
      I_GLAccountLineItem.SenderAccountAssignment,
      I_GLAccountLineItem.SenderAccountAssignmentType,
      I_GLAccountLineItem.CostOriginGroup,
      I_GLAccountLineItem.OriginSenderObject,
      I_GLAccountLineItem.ControllingDebitCreditCode,
      I_GLAccountLineItem.ControllingObjectDebitType,
      I_GLAccountLineItem.QuantityIsIncomplete,
      I_GLAccountLineItem.OffsettingAccount,
      I_GLAccountLineItem.OffsettingAccountType,
      I_GLAccountLineItem.OffsettingChartOfAccounts,
      I_GLAccountLineItem.LineItemIsCompleted,
      I_GLAccountLineItem.PersonnelNumber,
      I_GLAccountLineItem.ControllingObjectClass,
      I_GLAccountLineItem.PartnerCompanyCode,
      I_GLAccountLineItem.PartnerControllingObjectClass,
      I_GLAccountLineItem.OriginCostCenter,
      I_GLAccountLineItem.OriginProfitCenter,
      I_GLAccountLineItem.OriginCostCtrActivityType,
      I_GLAccountLineItem.AccountAssignment,
      I_GLAccountLineItem.AccountAssignmentType,
      I_GLAccountLineItem.CostCtrActivityType,
      I_GLAccountLineItem.OrderID,
      I_GLAccountLineItem.OrderCategory,
      I_GLAccountLineItem.WBSElementInternalID,
      I_GLAccountLineItem.ProjectNetwork,
      I_GLAccountLineItem.RelatedNetworkActivity,
      I_GLAccountLineItem.BusinessProcess,
      I_GLAccountLineItem.CostObject,
      I_GLAccountLineItem.BillableControl,
      I_GLAccountLineItem.CostAnalysisResource,
      I_GLAccountLineItem.CustomerServiceNotification,
      I_GLAccountLineItem.OperatingConcern,
      I_GLAccountLineItem.PartnerAccountAssignment,
      I_GLAccountLineItem.PartnerAccountAssignmentType,
      I_GLAccountLineItem.PartnerCostCtrActivityType,
      I_GLAccountLineItem.PartnerOrder,
      I_GLAccountLineItem.PartnerOrderCategory,
      I_GLAccountLineItem.PartnerSalesDocument,
      I_GLAccountLineItem.PartnerSalesDocumentItem,
      I_GLAccountLineItem.PartnerProjectNetwork,
      I_GLAccountLineItem.PartnerProjectNetworkActivity,
      I_GLAccountLineItem.PartnerBusinessProcess,
      I_GLAccountLineItem.PartnerCostObject,
      I_GLAccountLineItem.WorkItem,
      I_GLAccountLineItem.WorkCenterInternalID,
      I_GLAccountLineItem.OrderOperation,
      I_GLAccountLineItem.OrderItem,
      I_GLAccountLineItem.OrderSuboperation,
      I_GLAccountLineItem.Equipment,
      I_GLAccountLineItem.FunctionalLocation,
      I_GLAccountLineItem.Assembly,
      I_GLAccountLineItem.MaintenanceActivityType,
      I_GLAccountLineItem.MaintenanceOrderPlanningCode,
      I_GLAccountLineItem.MaintPriorityType,
      I_GLAccountLineItem.MaintPriority,
      I_GLAccountLineItem.SuperiorOrder,
      I_GLAccountLineItem.ProductGroup,
      I_GLAccountLineItem.MaintenanceOrderIsPlanned,
      I_GLAccountLineItem.BillingDocumentType,
      I_GLAccountLineItem.SalesOrganization,
      I_GLAccountLineItem.DistributionChannel,
      I_GLAccountLineItem.OrganizationDivision,
      I_GLAccountLineItem.SoldProduct,
      I_GLAccountLineItem.SoldProductGroup,
      I_GLAccountLineItem.CustomerGroup,
      I_GLAccountLineItem.CustomerSupplierCountry,
      I_GLAccountLineItem.CustomerSupplierIndustry,
      I_GLAccountLineItem.SalesDistrict,
      I_GLAccountLineItem.BillToParty,
      I_GLAccountLineItem.ShipToParty,
      I_GLAccountLineItem.CustomerSupplierCorporateGroup,
      I_GLAccountLineItem.CashLedgerCompanyCode,
      I_GLAccountLineItem.CashLedgerAccount,
      I_GLAccountLineItem.FinancialManagementArea,
      I_GLAccountLineItem.FundsCenter,
      I_GLAccountLineItem.FundedProgram,
      I_GLAccountLineItem.Fund,
      I_GLAccountLineItem.GrantID,
      I_GLAccountLineItem.BudgetPeriod,
      I_GLAccountLineItem.PartnerFund,
      I_GLAccountLineItem.PartnerGrant,
      I_GLAccountLineItem.PartnerBudgetPeriod,

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

      // .INCLUDE ACDOC_SI_JVA  Universal Journal Entry: Fields for Financial Services

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

      I_GLAccountLineItem.FinancialServicesProductGroup,
      I_GLAccountLineItem.FinancialServicesBranch,
      I_GLAccountLineItem.FinancialDataSource,

      I_GLAccountLineItem.JointVenture,
      I_GLAccountLineItem.JointVentureEquityGroup,
      I_GLAccountLineItem.JointVentureCostRecoveryCode,
      I_GLAccountLineItem.JointVenturePartner,
      I_GLAccountLineItem.JointVentureBillingType,
      I_GLAccountLineItem.JointVentureEquityType,
      I_GLAccountLineItem.JointVentureProductionDate,
      I_GLAccountLineItem.JointVentureBillingDate,
      I_GLAccountLineItem.JointVentureOperationalDate,
      I_GLAccountLineItem.CutbackRun,
      I_GLAccountLineItem.JointVentureAccountingActivity,
      I_GLAccountLineItem.PartnerVenture,
      I_GLAccountLineItem.PartnerEquityGroup,
      I_GLAccountLineItem.SenderCostRecoveryCode,
      I_GLAccountLineItem.CutbackAccount,
      I_GLAccountLineItem.CutbackCostObject,
      REBusinessEntity,
      RealEstateBuilding,
      RealEstateProperty,
      RERentalObject,
      RealEstateContract,
      REServiceChargeKey,
      RESettlementUnitID,
      SettlementReferenceDate,
      REPartnerBusinessEntity,
      RealEstatePartnerBuilding,
      RealEstatePartnerProperty,
      REPartnerRentalObject,
      RealEstatePartnerContract,
      REPartnerServiceChargeKey,
      REPartnerSettlementUnitID,
      PartnerSettlementReferenceDate,
      I_GLAccountLineItem.AccrualObjectType,
      // '_AccrualObject'

      I_GLAccountLineItem.AccrualObject,
      // '_AccrualSubobject'

      I_GLAccountLineItem.AccrualSubobject,
      // '_AccrualItemType'

      I_GLAccountLineItem.AccrualItemType,
      I_GLAccountLineItem.ServiceDocument,
      I_GLAccountLineItem.ServiceDocumentType,

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

      // .INCLUDE ACDOC_SI_FINCS   Universal Journal Entry: Fields for Group Reporting

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

      I_GLAccountLineItem.ConsolidationUnit,
      I_GLAccountLineItem.PartnerConsolidationUnit,
      I_GLAccountLineItem.Company,
      I_GLAccountLineItem.ConsolidationChartOfAccounts,
      I_GLAccountLineItem.CnsldtnFinancialStatementItem,
      I_GLAccountLineItem.CnsldtnSubitemCategory,
      I_GLAccountLineItem.CnsldtnSubitem
}
;