I_PubSecBdgtLineItemBasic

@AbapCatalog.sqlViewName: 'IPSMS4BDLNBSC'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.buffering.status: #NOT_ALLOWED
@EndUserText.label: 'Budget Line Items Basic'

@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel: {
//     representativeKey: 'FinancialPlanningEntryItem',

     usageType: {
         dataClass: #MIXED,
         serviceQuality: #D,
         sizeCategory: #XXL
     }
}

define view I_PubSecBdgtLineItemBasic
  as select from I_FinancialPlanningEntryItem as AcItem
    inner join I_PubSecPlanningCategory as _PlanningCategory on AcItem.PlanningCategory = _PlanningCategory.PlanningCategory
  association [0..1] to I_PubSecBudgetAccount     as _PubSecBudgetAccount        on  $projection.CompanyCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode
                                                                                 and $projection.GLAccount   = _PubSecBudgetAccount.PubSecBudgetAccount
{
  key AcItem.FinancialPlanningReqTransSqnc,
  key AcItem.FinancialPlanningDataPacket,
      @DefaultAggregation: #NONE
  key AcItem.FinancialPlanningEntryItem,
      AcItem.ControllingArea,
      AcItem.CompanyCode,
      AcItem.Ledger,
      
      //    Account assignments     

      AcItem.GLAccount,
      AcItem.ChartOfAccounts,
      AcItem.FiscalYear,
      AcItem.LedgerFiscalYear,
      AcItem.BusinessTransactionType,
      AcItem.FinancialTransactionType,
      AcItem.BusinessArea,
      AcItem.ProfitCenter,
      AcItem.CostCenter,
      AcItem.ProjectInternalID,
      AcItem.PartnerProjectInternalID,
      AcItem.WBSElementInternalID, 
      AcItem.PartnerWBSElementInternalID,
      AcItem.FunctionalArea,
      AcItem.Segment,
      AcItem.CostCtrActivityType,
      AcItem.CostAnalysisResource,
      AcItem.WorkPackage,
      AcItem.WorkItem,
      AcItem.IsLotSizeIndependent,
      AcItem.PartnerCompanyCode,
      AcItem.PartnerBusinessArea,
      AcItem.PartnerSegment,
      AcItem.PartnerProfitCenter,
      AcItem.PartnerCostCenter,
      AcItem.PartnerFunctionalArea,
      AcItem.PartnerCostCtrActivityType,
      AcItem.OrderID,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:    'PartnerOrder_2'
      @VDM.lifecycle.status:     #DEPRECATED
      @VDM.lifecycle.successor:  'PartnerOrder_2'
      AcItem.PartnerOrder,
      AcItem.PartnerOrder_2,
      AcItem.PartnerCompany,
      
      // Transaction data      

      AcItem.ReferenceDocumentType,
      AcItem.ReferenceDocumentContext,
      AcItem.ReferenceDocument,
      
      // Amount/Currency/Unit

      AcItem.TransactionCurrency,
      AcItem.AmountInTransactionCurrency,
      AcItem.CompanyCodeCurrency,
      AcItem.AmountInCompanyCodeCurrency,
      AcItem.GlobalCurrency,
      AcItem.AmountInGlobalCurrency,
      AcItem.ControllingObjectCurrency,
      AcItem.AmountInObjectCurrency,
      AcItem.FixedAmountInGlobalCrcy,
      AcItem.CostSourceUnit,
      AcItem.ValuationQuantity,

      // Continue with transactional data

      AcItem.FiscalYearVariant,
      AcItem.FiscalPeriod,
      AcItem.FiscalYearPeriod,
      AcItem.PostingDate,
      AcItem.SalesDocument,
      AcItem.SalesDocumentItem,
      AcItem.Plant,
      AcItem.Product,  
      AcItem.Customer,
      AcItem.PlanningCategory,
      AcItem.AccountAssignmentType,
      AcItem.PartnerAccountAssignmentType,
      AcItem.ControllingDebitCreditCode,
      AcItem.PersonnelNumber,
      AcItem.BillingDocumentType,
      AcItem.SalesOrganization,
      AcItem.DistributionChannel,
      AcItem.OrganizationDivision,
      AcItem.SoldProduct,  
      AcItem.CustomerGroup,
      AcItem.CustomerSupplierCountry,
      AcItem.CustomerSupplierIndustry,
      AcItem.SalesDistrict,
      AcItem.BillToParty,
      AcItem.ShipToParty,
      AcItem.CustomerSupplierCorporateGroup,
      
      // Add PSM account assignments

      AcItem.FinancialManagementArea,
      AcItem.Fund,
      AcItem.GrantID,
      AcItem.SponsoredClass,
      AcItem.SponsoredProgram,
      AcItem.GteeMBudgetValidityNumber,
      case
        when _PubSecBudgetAccount.PubSecBdgtAcctRevnExpnCode = 'E' or
             _PubSecBudgetAccount.PubSecBdgtAcctRevnExpnCode = 'R' then
          cast( AcItem.GLAccount as psm_bdgt_account preserving type ) 
        else 
          cast( '' as psm_bdgt_account )  
      end as PubSecBudgetAccount,
      case
        when _PubSecBudgetAccount.PubSecBdgtAcctRevnExpnCode = 'E' or
             _PubSecBudgetAccount.PubSecBdgtAcctRevnExpnCode = 'R' then
          cast( AcItem.CompanyCode as psm_bdgt_account_cocode preserving type ) 
        else 
          cast( '' as psm_bdgt_account_cocode )  
      end as PubSecBudgetAccountCoCode,
      AcItem.BudgetPeriod,
      AcItem.BudgetProcess,
      AcItem.BudgetingType,
      AcItem.BudgetDocWorkFlowStatus,
      AcItem.WorkCenterInternalID,
      AcItem.OrderOperation,
      AcItem.OrderItem,
      AcItem.PlanPriceInGlobalCurrency,
      AcItem.PlanPriceInCompanyCodeCurrency,
      AcItem.PlanPriceInTransactionCurrency,
      AcItem.GLAccountAuthorizationGroup,
      AcItem.CustomerBasicAuthorizationGrp,
      AcItem.OrderType,
      AcItem.SalesOrderType,
      
      // Asset

      AcItem.AssetDepreciationArea,
      AcItem.MasterFixedAsset,
      AcItem.FixedAsset,
      AcItem.AssetAcctTransClassfctn,
      AcItem.AssetClass,
      
      // Associations   

      AcItem._BillingDocumentType,
      AcItem._BillToParty,
      AcItem._BudgetingType,
      AcItem._BudgetPeriod,
      AcItem._BudgetProcess,
      AcItem._BusinessArea,
      AcItem._BusinessTransactionType,
      AcItem._CalendarDate,
      AcItem._ChartOfAccounts,
      AcItem._CompanyCode,
      AcItem._CompanyCodeCurrency,
      AcItem._ControllingArea,
      AcItem._ControllingDebitCreditCode,
      AcItem._ControllingObjectCurrency,
      AcItem._CostAnalysisResource,
      AcItem._CostCenter,
      AcItem._CostCtrActivityType,
      AcItem._CostSourceUnit,
      AcItem._CurrentCostCenter,
      AcItem._CurrentProfitCenter,
      AcItem._Customer,
      AcItem._CustomerGroup,
      AcItem._CustomerSupplierCountry,
      AcItem._CustomerSupplierIndustryText,
      AcItem._DistributionChannel,
      AcItem._Employment,
      AcItem._FinancialManagementArea,
      AcItem._FinancialTransactionType,
      AcItem._FiscalCalendarDate,
      AcItem._FiscalPeriodForVariant,
      AcItem._FiscalYear,
      AcItem._FiscalYearPeriodForVariant,
      AcItem._FiscalYearVariant,
      AcItem._FixedAsset,
      AcItem._FunctionalArea,
      AcItem._Fund,
      AcItem._GLAccountInChartOfAccounts,
      AcItem._GLAccountInCompanyCode,
      AcItem._GlobalCurrency,
      AcItem._Grant,
      AcItem._InternalOrder,
      AcItem._Ledger,
      AcItem._LedgerFiscalYear,
      AcItem._LedgerFiscalYearForVariant,      
      AcItem._MasterFixedAsset,
      AcItem._Order,
      AcItem._OrganizationDivision,
      AcItem._PartnerBusinessArea,
      AcItem._PartnerCompany,
      AcItem._PartnerCompanyCode,
      AcItem._PartnerCostCenter,
      AcItem._PartnerCostCtrActivityType,
      AcItem._PartnerFunctionalArea,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:   '_PartnerOrder_2'
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: '_PartnerOrder_2'
      AcItem._PartnerOrder,
      AcItem._PartnerOrder_2,
      AcItem._PartnerProfitCenter,
      AcItem._PartnerProjectBasicData,
      AcItem._PartnerSegment,
  //    AcItem._PlanningCategory,

      AcItem._Plant,
      AcItem._Product,
      AcItem._ProfitCenter,
      AcItem._ProjectBasicData,
      AcItem._SalesDistrict,
      AcItem._SalesDocument,
      AcItem._SalesDocumentItem,
      AcItem._SalesOrganization,
      AcItem._Segment,
      AcItem._SemTagGLAccount,
      AcItem._ShipToParty,
      AcItem._SoldProduct,
      AcItem._SponsoredClass,
      AcItem._SponsoredProgram,
      AcItem._TransactionCurrency,
      AcItem._WBSElementBasicData,
      AcItem._WBSElementByInternalKey,
      AcItem._PartnerWBSElementBasicData,
      AcItem._WorkCenter,
      AcItem._WorkPackage,
      AcItem._WorkPackageWorkItem,
      _PlanningCategory
// Select Budget from base or extension ledger

} where ( ( AcItem.Ledger = '0L' or AcItem.Ledger = '0E' ) )