FIN_SubValProfSegmentLineitem

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


@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Profitability Segment Substitution'
@ObjectModel: {
                usageType: { sizeCategory: #S,
                             dataClass:  #MIXED,
                             serviceQuality: #D }
             }                             
@Metadata: { ignorePropagatedAnnotations: true,
             allowExtensions:true }                                     

define view entity FIN_SubValProfSegmentLineitem
  as select from I_GLAccountLineItemRawData
    inner join   I_CoCodeLedgerSourceLedger  on I_GLAccountLineItemRawData.SourceLedger = I_CoCodeLedgerSourceLedger.SourceLedger
                                            and I_GLAccountLineItemRawData.CompanyCode = I_CoCodeLedgerSourceLedger.CompanyCode
  /* *************************************************************
   *  association zur ID
   * *************************************************************
  */

    association [0..1]                                           to I_JournalEntry               as _JournalEntry                  on  $projection.CompanyCode        = _JournalEntry.CompanyCode
                                                                                                                                   and $projection.FiscalYear         = _JournalEntry.FiscalYear
                                                                                                                                   and $projection.AccountingDocument = _JournalEntry.AccountingDocument
  association [1..1]                                           to I_CompanyCode                  as _CompanyCode                   on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1]                                           to I_CompanyCode                  as _CompanyCodeText               on  $projection.CompanyCode = _CompanyCodeText.CompanyCode
  association [1..1]                                           to I_FiscalYearVariant            as _FiscalYearVariant             on  $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant
  association [0..1]                                           to I_FiscalYearForCompanyCode     as _FiscalYear                    on  $projection.FiscalYear  = _FiscalYear.FiscalYear
                                                                                                                                   and $projection.CompanyCode = _FiscalYear.CompanyCode
  association [0..1]                                           to I_ControllingArea              as _ControllingArea               on  $projection.ControllingArea = _ControllingArea.ControllingArea
  association [0..1]                                           to I_ControllingArea              as _ControllingAreaText           on  $projection.ControllingArea = _ControllingAreaText.ControllingArea
  association [0..1]                                           to I_Segment                      as _Segment                       on  $projection.Segment = _Segment.Segment
  association [0..1]                                           to I_ProfitCenter                 as _CurrentProfitCenter           on  $projection.ControllingArea            = _CurrentProfitCenter.ControllingArea
                                                                                                                                   and $projection.ProfitCenter               = _CurrentProfitCenter.ProfitCenter
                                                                                                                                   and _CurrentProfitCenter.ValidityStartDate <= $session.system_date
                                                                                                                                   and _CurrentProfitCenter.ValidityEndDate   >= $session.system_date
  association [0..1]                                           to I_CostCenter                   as _CurrentCostCenter             on  $projection.ControllingArea          = _CurrentCostCenter.ControllingArea
                                                                                                                                   and $projection.CostCenter               = _CurrentCostCenter.CostCenter
                                                                                                                                   and _CurrentCostCenter.ValidityStartDate <= $session.system_date
                                                                                                                                   and _CurrentCostCenter.ValidityEndDate   >= $session.system_date
                                                                                                                                   
  association [0..1]  to I_WBSElementByInternalKey      as _WBSElementInternalID          on  $projection.WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID        /*do not use any longer*/
  association [0..1]  to I_WBSElementByInternalKey      as _WBSElementInternalIDText      on  $projection.WBSElementInternalID = _WBSElementInternalIDText.WBSElementInternalID    /*do not use any longer*/
  association [0..1]  to I_WBSElementBasicData          as _WBSElementBasicData           on  $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
  association [0..1]  to I_WBSElementBasicData          as _WBSElementBasicDataText       on  $projection.WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID
  
                                                                                                                                                                                                                                                                      
  association [0..1]                                           to I_BusinessArea                 as _BusinessArea                  on  $projection.BusinessArea = _BusinessArea.BusinessArea
  association [0..1]                                           to I_FunctionalArea               as _FunctionalArea                on  $projection.FunctionalArea = _FunctionalArea.FunctionalArea
  association [0..1]                                           to I_Plant                        as _Plant                         on  $projection.Plant = _Plant.Plant
  association [1..1]                                           to I_Ledger                       as _Ledger                        on  $projection.Ledger = _Ledger.Ledger
  association [0..1]                                           to I_Ledger                       as _SourceLedger                  on  $projection.SourceLedger = _SourceLedger.Ledger
  association [0..1]                                           to I_Customer                     as _Customer                      on  $projection.Customer = _Customer.Customer
  association [0..1]                                           to I_Customer                     as _CustomerText                  on  $projection.Customer = _CustomerText.Customer
  association [0..1]                                           to I_CustomerGroup                as _CustomerGroup                 on  $projection.CustomerGroup = _CustomerGroup.CustomerGroup

 
  
  association [0..1] to I_ProductGroup                 as _SoldProductGroup              on  $projection.SoldProductGroup = _SoldProductGroup.MaterialGroup //do not use any longer, use _SoldProductGroup_2

  association [0..1] to I_ProductGroup_2               as _SoldProductGroup_2            on  $projection.SoldProductGroup = _SoldProductGroup_2.ProductGroup
  

  association [0..1]                                           to I_SalesDocument                as _SalesDocument                 on  $projection.SalesDocument = _SalesDocument.SalesDocument
  association [0..1]                                           to I_SalesDocumentItem            as _SalesDocumentItem             on  $projection.SalesDocument     = _SalesDocumentItem.SalesDocument
                                                                                                                                   and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem
  // association[0..1] to I_Order                        as _Order                      on $projection.OrderID                         = _Order.OrderID

  association [0..1]                                           to I_InternalOrder                as _InternalOrder                 on  $projection.OrderID = _InternalOrder.InternalOrder
  association [0..1]                                           to I_Order                        as _Order                         on  $projection.OrderID = _Order.OrderID
  


  association [0..1]                                           to I_BusinessProcess              as _BusinessProcess               on  $projection.ControllingArea = _BusinessProcess.ControllingArea
                                                                                                                                   and $projection.BusinessProcess = _BusinessProcess.BusinessProcess
  association [0..1]                                           to I_BillingDocumentType          as _BillingDocumentType           on  $projection.BillingDocumentType = _BillingDocumentType.BillingDocumentType

  association [0..1]                                           to I_SalesOrganization            as _SalesOrganization             on  $projection.SalesOrganization = _SalesOrganization.SalesOrganization
  association [0..1]                                           to I_DistributionChannel          as _DistributionChannel           on  $projection.DistributionChannel = _DistributionChannel.DistributionChannel

  association [0..1]                                           to I_Product                      as _SoldProduct                   on  $projection.SoldProduct = _SoldProduct.Product
  association [0..1]                                           to I_Country                      as _CustomerSupplierCountry       on  $projection.CustomerSupplierCountry = _CustomerSupplierCountry.Country
  association [0..1]                                           to I_SalesDistrict                as _SalesDistrict                 on  $projection.SalesDistrict = _SalesDistrict.SalesDistrict
  association [0..1]                                           to I_Customer                     as _BillToParty                   on  $projection.BillToParty = _BillToParty.Customer
  association [0..1]                                           to I_Customer                     as _ShipToParty                   on  $projection.ShipToParty = _ShipToParty.Customer

  association [0..1]                                           to I_ServiceDocumentType          as _ServiceDocumentType           on  $projection.ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType

  association [0..1]                                           to I_SrvcDocByDocumentType        as _ServiceDocument               on  $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType
                                                                                                                                   and $projection.ServiceDocument     = _ServiceDocument.ServiceDocument

  association [0..1]                                           to I_SrvcDocItemByDocumentType    as _ServiceDocumentItem           on  $projection.ServiceDocumentType = _ServiceDocumentItem.ServiceDocumentType
                                                                                                                                   and $projection.ServiceDocument     = _ServiceDocumentItem.ServiceDocument
                                                                                                                                   and $projection.ServiceDocumentItem = _ServiceDocumentItem.ServiceDocumentItem
  //Solution Order Reference

  association [0..1]                                           to I_ServiceDocumentEnhcd         as _SolutionOrder                 on  $projection.BusinessSolutionOrder = _SolutionOrder.ServiceDocument
                                                                                                                                  and _SolutionOrder.ServiceObjectType = 'BUS2000172'  
                                                                                             
  //Solution Order Item Reference

  association [0..1] to I_ServiceDocumentItemEnhcd            as _SolutionOrderItem             on  _SolutionOrderItem.ServiceObjectType = 'BUS2000172'
                                                                                             and $projection.BusinessSolutionOrder = _SolutionOrderItem.ServiceDocument
                                                                                             and $projection.BusinessSolutionOrderItem = _SolutionOrderItem.ServiceDocumentItem
                        
 association [0..1] to   I_CustomerSalesArea            as _CustomerSalesArea            on  $projection.Customer = _CustomerSalesArea.Customer
                 and $projection.SalesOrganization = _CustomerSalesArea.SalesOrganization
                 and $projection.DistributionChannel = _CustomerSalesArea.DistributionChannel
                 and $projection.OrganizationDivision = _CustomerSalesArea.Division
                 
                 
                                                                                                                                   

  association [1..1]                                           to E_JournalEntryItem             as _Extension                     on  $projection.SourceLedger       = _Extension.SourceLedger
                                                                                                                                   and $projection.CompanyCode        = _Extension.CompanyCode
                                                                                                                                   and $projection.FiscalYear         = _Extension.FiscalYear
                                                                                                                                   and $projection.AccountingDocument = _Extension.AccountingDocument
                                                                                                                                   and $projection.LedgerGLLineItem   = _Extension.LedgerGLLineItem

{
key I_GLAccountLineItemRawData.SourceLedger,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key I_GLAccountLineItemRawData.CompanyCode,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key I_GLAccountLineItemRawData.FiscalYear,
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key I_GLAccountLineItemRawData.AccountingDocument,
  key I_GLAccountLineItemRawData.LedgerGLLineItem,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_LedgerStdVH',
                     element: 'Ledger' }
        }]
      @ObjectModel.foreignKey.association: '_Ledger'
  key I_CoCodeLedgerSourceLedger.Ledger,
        @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_BusinessAreaStdVH',
                     element: 'BusinessArea' }
        }]
      @ObjectModel.foreignKey.association: '_BusinessArea'
I_GLAccountLineItemRawData.BusinessArea,
@Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ControllingAreaStdVH',
                     element: 'ControllingArea' }
        }]
      @ObjectModel.foreignKey.association: '_ControllingArea'
I_GLAccountLineItemRawData.ControllingArea,

 @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_FiscalYearVariantStdVH',
                    element: 'FiscalYearVariant' }
       }]
I_GLAccountLineItemRawData.FiscalYearVariant,
      @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_Customer_VH',
                    element: 'Customer' }
       }]
   I_GLAccountLineItemRawData.BillToParty,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'C_BillingDocumentTypeVH',
                     element: 'BillingDocumentType' }
        }]
      @ObjectModel.foreignKey.association: '_BillingDocumentType'   
   I_GLAccountLineItemRawData.BillingDocumentType,
   @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_BusinessProcessStdVH',
                           element: 'BusinessProcess' }
              }]
      @ObjectModel.foreignKey.association: '_BusinessProcess'
   I_GLAccountLineItemRawData.BusinessProcess,
        @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_BusinessSolutionOrderStdVH',
                     element: 'BusinessSolutionOrder' }
        }]
I_GLAccountLineItemRawData.BusinessSolutionOrder    ,
I_GLAccountLineItemRawData.BusinessSolutionOrderItem,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CostCenterStdVH',
                     element: 'CostCenter' }
        }]
I_GLAccountLineItemRawData.CostCenter               ,
// C_Costcenteractivityvalhlp

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'C_Costcenteractivityvalhlp',
                     element: 'CostCtrActivityType' }
        }]
I_GLAccountLineItemRawData.CostCtrActivityType      ,
I_GLAccountLineItemRawData.CostObject               ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_Customer_VH',
                     element: 'Customer' }
        }]
      @ObjectModel.foreignKey.association: '_Customer'
I_GLAccountLineItemRawData.Customer                 ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CustomerGroup',
                     element: 'CustomerGroup' }
        }]
      @ObjectModel.foreignKey.association: '_CustomerGroup'
I_GLAccountLineItemRawData.CustomerGroup            ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CountryVH',
                     element: 'Country' }
        }]
I_GLAccountLineItemRawData.CustomerSupplierCountry  ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CustomerSupplierIndustry',
                     element: 'Industry' }
        }]
I_GLAccountLineItemRawData.CustomerSupplierIndustry ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_DistributionChannel',
                     element: 'DistributionChannel' }
        }]
      @ObjectModel.foreignKey.association: '_DistributionChannel'
I_GLAccountLineItemRawData.DistributionChannel      ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_FunctionalArea',
                     element: 'FunctionalArea' }
        }]
I_GLAccountLineItemRawData.FunctionalArea           ,
      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_Order',
                           element: 'OrderID' }
              }]
      @ObjectModel.foreignKey.association: '_Order'
I_GLAccountLineItemRawData.OrderID                  ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_Division',
                     element: 'Division' }
        }]
I_GLAccountLineItemRawData.OrganizationDivision     ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CostCenterStdVH',
                     element: 'CostCenter' }
        }]
//      @ObjectModel.foreignKey.association: '_PartnerCostCenter'

I_GLAccountLineItemRawData.PartnerCostCenter        ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ProfitCenterStdVH',
                     element: 'ProfitCenter' }
        }]
//      @ObjectModel.foreignKey.association: '_PartnerProfitCenter'

I_GLAccountLineItemRawData.PartnerProfitCenter      ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_PlantStdVH',
                     element: 'Plant' }
        }]
      @ObjectModel.foreignKey.association: '_Plant'
I_GLAccountLineItemRawData.Plant                    ,
 @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ProfitCenterStdVH',
                     element: 'ProfitCenter' }
        }]
    //  @ObjectModel.foreignKey.association: '_ProfitCenter'

I_GLAccountLineItemRawData.ProfitCenter             ,
@Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_PROVIDERCONTRACTVH',
                     element: 'ProviderContract' }
        }]
I_GLAccountLineItemRawData.ProviderContract         ,
I_GLAccountLineItemRawData.ProviderContractItem     ,
 @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_SALESDISTRICT',
                     element: 'SalesDistrict' }
        }]
I_GLAccountLineItemRawData.SalesDistrict            ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_SalesDocumentStdVH',
                     element: 'SalesDocument' }
        }]
      @ObjectModel.foreignKey.association: '_SalesDocument'
I_GLAccountLineItemRawData.SalesDocument            ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_SalesDocumentItemStdVH',
                     element: 'SalesDocumentItem' }
        }]
      @ObjectModel.foreignKey.association: '_SalesDocumentItem'
I_GLAccountLineItemRawData.SalesDocumentItem        ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_SalesOrganization',
                     element: 'SalesOrganization' }
        }]
      @ObjectModel.foreignKey.association: '_SalesOrganization'
I_GLAccountLineItemRawData.SalesOrganization        ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_SegmentStdVH',
                     element: 'Segment' }
        }]
      @ObjectModel.foreignKey.association: '_Segment'
I_GLAccountLineItemRawData.Segment                  ,
      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceDocumentVH',
                           element: 'ServiceDocument' }
              }]
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_ServiceDocument'
I_GLAccountLineItemRawData.ServiceDocument          ,
      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceDocumentItemVH',
                           element: 'ServiceDocumentItem' }
              }]
I_GLAccountLineItemRawData.ServiceDocumentItem      ,
 @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceDocumentTypeVH',
                           element: 'ServiceDocumentType' }
              }]
I_GLAccountLineItemRawData.ServiceDocumentType      ,
 @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_Customer_VH',
                    element: 'Customer' }
       }]
I_GLAccountLineItemRawData.ShipToParty              ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ProductVH',
                     element: 'Product' }
        }]
      @ObjectModel.foreignKey.association: '_SoldProduct'
I_GLAccountLineItemRawData.SoldProduct              ,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ProductGroupVH',
                     element: 'ProductGroup' }
        }]
I_GLAccountLineItemRawData.SoldProductGroup         ,
@Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_WBSElementBasicDataStdVH',
                           element: 'WBSElementInternalID' }
              }]
      @ObjectModel.foreignKey.association: '_WBSElementInternalID'
I_GLAccountLineItemRawData.WBSElementInternalID,

@Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_GLAccountStdVH',
                           element: 'GLAccount' }
              }]
I_GLAccountLineItemRawData.GLAccount,

_JournalEntry           ,     
_CompanyCode            ,
_CompanyCodeText        ,
_FiscalYearVariant      ,
_FiscalYear             ,              
_ControllingArea        ,
_ControllingAreaText    ,
_Segment                ,
_CurrentProfitCenter    ,
_CurrentCostCenter      ,
_WBSElementInternalID    ,
_WBSElementInternalIDText,
_WBSElementBasicData     ,
_WBSElementBasicDataText ,
_BusinessArea           ,
_FunctionalArea         ,
_Plant                  ,
_Ledger                 ,
_SourceLedger           ,
_Customer               ,
_CustomerText           ,
_CustomerGroup          ,
@API.element.releaseState: #DEPRECATED
@API.element.successor:    '_SoldProductGroup_2'
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: '_SoldProductGroup_2'
_SoldProductGroup       ,

_SoldProductGroup_2     ,
_SalesDocument          ,
_SalesDocumentItem      ,
_InternalOrder          ,   
_Order                  ,  
_SolutionOrder          , 
_SolutionOrderItem      ,
_BusinessProcess        ,   
_BillingDocumentType    ,  
_SalesOrganization      ,   
_DistributionChannel    ,  
_SoldProduct            ,   
_CustomerSupplierCountry,   
_SalesDistrict          ,   
_BillToParty            ,   
_ShipToParty            ,   
_ServiceDocumentType    ,   
_ServiceDocument        ,   
_ServiceDocumentItem    ,
_CustomerSalesArea      ,
I_GLAccountLineItemRawData._CustomerCompany                  ,
I_GLAccountLineItemRawData._ProviderContract                 ,
I_GLAccountLineItemRawData._ProviderContractItem             


     
      //_Extension  Extensions must be local


}
where I_GLAccountLineItemRawData.SourceLedger <> I_GLAccountLineItemRawData.SourceLedger
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COCODELEDGERSOURCELEDGER",
"I_GLACCOUNTLINEITEMRAWDATA"
],
"ASSOCIATED":
[
"I_BILLINGDOCUMENTTYPE",
"I_BUSINESSAREA",
"I_BUSINESSPROCESS",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_COUNTRY",
"I_CUSTOMER",
"I_CUSTOMERCOMPANY",
"I_CUSTOMERGROUP",
"I_CUSTOMERSALESAREA",
"I_DISTRIBUTIONCHANNEL",
"I_FISCALYEARFORCOMPANYCODE",
"I_FISCALYEARVARIANT",
"I_FUNCTIONALAREA",
"I_INTERNALORDER",
"I_JOURNALENTRY",
"I_LEDGER",
"I_ORDER",
"I_PLANT",
"I_PRODUCT",
"I_PRODUCTGROUP",
"I_PRODUCTGROUP_2",
"I_PROFITCENTER",
"I_PROVIDERCONTRACT",
"I_PROVIDERCONTRACTITEM",
"I_SALESDISTRICT",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SALESORGANIZATION",
"I_SEGMENT",
"I_SERVICEDOCUMENTENHCD",
"I_SERVICEDOCUMENTITEMENHCD",
"I_SERVICEDOCUMENTTYPE",
"I_SRVCDOCBYDOCUMENTTYPE",
"I_SRVCDOCITEMBYDOCUMENTTYPE",
"I_WBSELEMENTBASICDATA",
"I_WBSELEMENTBYINTERNALKEY"
],
"BASE":
[
"I_GLACCOUNTLINEITEMRAWDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/