P_USFedRblStatusBasic

@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: { usageType: { sizeCategory: #XXL,
                             dataClass:  #MIXED,
                             serviceQuality: #A },
                supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE],
                modelingPattern: #ANALYTICAL_CUBE }
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view entity P_USFedRblStatusBasic
  as select from I_GLAccountLineItemRawData

{
  key SourceLedger,
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key LedgerGLLineItem,


      I_GLAccountLineItemRawData.InvoiceReference               as InvoiceReference, //REBZG

      I_GLAccountLineItemRawData.InvoiceReferenceFiscalYear     as InvoiceReferenceFiscalYear, //REBZJ

      I_GLAccountLineItemRawData.InvoiceItemReference           as InvoiceItemReference, //REBZZ


      I_GLAccountLineItemRawData.AccountingDocumentItem         as AccountingDocumentItem, //BUZEI

      I_GLAccountLineItemRawData.AccountingDocumentType         as AccountingDocumentType,
      I_GLAccountLineItemRawData.DocumentDate                   as DocumentDate,
      I_GLAccountLineItemRawData.FinancialAccountType           as FinancialAccountType,
      I_GLAccountLineItemRawData.DebitCreditCode                as DebitCreditCode,
      I_GLAccountLineItemRawData.PostingDate                    as PostingDate,
      I_GLAccountLineItemRawData.BusinessTransactionType        as BusinessTransactionType,
      I_GLAccountLineItemRawData.ChartOfAccounts                as ChartOfAccounts,
      I_GLAccountLineItemRawData.GLAccount                      as GLAccount,
      I_GLAccountLineItemRawData.OffsettingChartOfAccounts      as OffsettingChartOfAccounts,
      I_GLAccountLineItemRawData.OffsettingAccount              as OffsettingAccount,
      I_GLAccountLineItemRawData.OffsettingAccountType          as OffsettingAccountType,
      I_GLAccountLineItemRawData.ClearingJournalEntry           as ClearingJournalEntry,
      I_GLAccountLineItemRawData.ClearingJournalEntryFiscalYear as ClearingJournalEntryFiscalYear,
      I_GLAccountLineItemRawData.IsReversal                     as IsReversal,
      I_GLAccountLineItemRawData.IsReversed                     as IsReversed,

      I_GLAccountLineItemRawData.Fund                           as Fund, //RFUND

      I_GLAccountLineItemRawData.FinancialManagementArea        as FinancialManagementArea, //FIKRS

      I_GLAccountLineItemRawData.BudgetPeriod                   as BudgetPeriod, //BUDPER

      I_GLAccountLineItemRawData.FundsCenter                    as FundsCenter, //FISTL

      I_GLAccountLineItemRawData.FunctionalArea                 as FunctionalArea, //RFAREA

      I_GLAccountLineItemRawData.FundedProgram                  as FundedProgram, //measure,

      I_GLAccountLineItemRawData.Customer                       as Customer, //KUNNR

      I_GLAccountLineItemRawData.PartnerCompany                 as PartnerCompany, //RASCC


      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      I_GLAccountLineItemRawData.AmountInCompanyCodeCurrency    as AmountInCompanyCodeCurrency, //HSL

      I_GLAccountLineItemRawData.CompanyCodeCurrency            as CompanyCodeCurrency,

      //Associations

      I_GLAccountLineItemRawData._CompanyCode                   as _CompanyCode,
      I_GLAccountLineItemRawData._FiscalYear                    as _FiscalYear,
      I_GLAccountLineItemRawData._Ledger                        as _Ledger,
      I_GLAccountLineItemRawData._JournalEntry                  as _JournalEntry,
      I_GLAccountLineItemRawData._AccountingDocumentType        as _AccountingDocumentType,
      I_GLAccountLineItemRawData._DebitCreditCode               as _DebitCreditCode,
      I_GLAccountLineItemRawData._BusinessTransactionType       as _BusinessTransactionType,
      I_GLAccountLineItemRawData._ChartOfAccounts               as _ChartOfAccounts,
      I_GLAccountLineItemRawData._GLAccountInChartOfAccounts    as _GLAccountInChartOfAccounts,
      I_GLAccountLineItemRawData._OffsettingChartOfAccounts     as _OffsettingChartOfAccounts,
      I_GLAccountLineItemRawData._OffsettingAccount             as _OffsettingAccount,
      I_GLAccountLineItemRawData._OffsettingAccountType         as _OffsettingAccountType,
      I_GLAccountLineItemRawData._ClearingJournalEntry          as _ClearingJournalEntry,
      I_GLAccountLineItemRawData._Fund                          as _Fund,
      I_GLAccountLineItemRawData._FinancialManagementArea       as _FinancialManagementArea,
      I_GLAccountLineItemRawData._BudgetPeriod                  as _BudgetPeriod,
      I_GLAccountLineItemRawData._FundsCenter                   as _FundsCenter,
      I_GLAccountLineItemRawData._FunctionalArea                as _FunctionalArea,
      I_GLAccountLineItemRawData._FundedProgram                 as _FundedProgram,
      I_GLAccountLineItemRawData._Customer                      as _Customer,
      I_GLAccountLineItemRawData._PartnerCompany                as _PartnerCompany

}
where
      FinancialAccountType = 'D' //KOART

  and IsOpenItemManaged    = 'X' // XOPVW