P_ML_Balance_Bcf

@VDM: {
  viewType: #COMPOSITE,
  private:true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity P_ML_Balance_Bcf
  with parameters
    P_CalendarDate : calendardate

  as select from I_GLAccountLineItemRawData as it
  
    inner join P_ML_CoCode_Ledger_BCF(P_CalendarDate : $parameters.P_CalendarDate ) as ml  on  it.CompanyCode  = ml.CompanyCode
                                                                                           and it.SourceLedger = ml.Ledger


  association [0..1] to I_MaterialValuation       as _MaterialValuation       on  _MaterialValuation.CostEstimate  = it.CostEstimate
                                                                              and _MaterialValuation.Material      = it.Product
                                                                              and _MaterialValuation.ValuationArea = it.ValuationArea

  association [0..1] to I_BusinessTransactionType as _BusinessTransactionType on  _BusinessTransactionType.BusinessTransactionType = it.BusinessTransactionType

{
  key it.CompanyCode,
  key it.SourceLedger                               as Ledger,
  key it.GLAccount,
  key it.FiscalYear,
  key it.AccountingDocument,
  key it.LedgerGLLineItem,
  key it.Product,
      @VDM.lifecycle: {
        status: #DEPRECATED,
        successor: 'Product' }
      it.Product                                    as Material,
      it.CostEstimate,
      it.ChartOfAccounts,
      it.AccountingDocumentType,
      it.ValuationArea,
      it.InventoryValuationType,
      it.FiscalPeriod,
      it.FiscalYearVariant,
      it.LedgerFiscalYear,
      it.PostingDate,
      it.PostingDate                                as MatlDocLatestPostgDate,
      it.ReferenceDocument,
      it.ReferenceDocumentType,
      it.BusinessTransactionType,
      it.DocumentDate,
      it.ProfitCenter,
      it.CostCenter,
      it.Segment,
      it.AccountingDocCreatedByUser,
      it.LastChangeDateTime,
      it.FiscalYearPeriod,
      it.PurchasingDocument,
      it.OrderID                                    as ProductionOrder,
      it.TransactionTypeDetermination,
      @VDM.lifecycle: {
        status: #DEPRECATED,
        successor: 'ProductGroup' }
      it.ProductGroup                               as MaterialGroup,
      it.ProductGroup                               as ProductGroup,
      _MaterialValuation.MaterialValuationClass     as MaterialValuationClass,
      _MaterialValuation.InventoryValuationCategory as InventoryValuationCategory,
      it.ControllingArea,
      it.Plant,
      it.MaterialLedgerProcessType,
      it.MaterialLedgerCategory,
      it.IsSupplierStockValuation,
      it.InventorySpecialStockValnType,
      it.InventorySpclStkSalesDocument,
      it.InventorySpclStkSalesDocItm,
      it.InvtrySpclStockWBSElmntIntID,
      it.InventorySpecialStockSupplier,
      ml.FromFiscalYear,

      //----------------------------------------

      //KEY FIGURES

      //----------------------------------------

      it.CompanyCodeCurrency,
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      it.AmountInCompanyCodeCurrency,
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      it.SlsPriceAmountInCoCodeCrcy,

      it.GlobalCurrency                             as GroupCurrency,
      @Semantics: { amount : {currencyCode: 'GroupCurrency'} }
      it.AmountInGlobalCurrency                     as AmountInGroupCurrency,

      it.FreeDefinedCurrency1,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      it.AmountInFreeDefinedCurrency1,

      it.FreeDefinedCurrency2,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      it.AmountInFreeDefinedCurrency2,

      it.FreeDefinedCurrency3,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      it.AmountInFreeDefinedCurrency3,

      it.FreeDefinedCurrency4,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      it.AmountInFreeDefinedCurrency4,

      it.FreeDefinedCurrency5,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      it.AmountInFreeDefinedCurrency5,

      it.FreeDefinedCurrency6,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      it.AmountInFreeDefinedCurrency6,

      it.FreeDefinedCurrency7,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      it.AmountInFreeDefinedCurrency7,

      it.FreeDefinedCurrency8,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      it.AmountInFreeDefinedCurrency8,

      it.CostSourceUnit,
      @Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }
      it.ValuationQuantity                          as InventoryQty,

      //----------------------------------------

      //Associations

      //----------------------------------------

      it._GLAccountInChartOfAccounts,
      it._ChartOfAccounts,
      it._Segment,
      it._CompanyCode,
      it._Ledger,
      it._ProfitCenter,
      it._CostCenter,
      it._CompanyCodeCurrency,
      it._GlobalCurrency,
      it._FreeDefinedCurrency1,
      it._FreeDefinedCurrency2,
      it._FreeDefinedCurrency3,
      it._FreeDefinedCurrency4,
      it._FreeDefinedCurrency5,
      it._FreeDefinedCurrency6,
      it._FreeDefinedCurrency7,
      it._FreeDefinedCurrency8,
      it._CostSourceUnit,
      it._ControllingArea,
      it._Product,
      _BusinessTransactionType

}
where
      it.TransactionTypeDetermination = 'BSX'
  and it.CostEstimate                 > '000000000000'
  and it.GLRecordType                 = '0'