I_ProjectBillingElementEntryTP

//@AbapCatalog.sqlViewName: 'IPRJBLGELMENTRTP'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
//@ClientHandling.algorithm: #SESSION_VARIABLE

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Entry Details of Billing Element'

@ObjectModel.usageType: {
    sizeCategory: #L,
    dataClass:  #TRANSACTIONAL,
    serviceQuality: #A
} 
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'R_ProjectBillingElementEntryTP'

define view entity I_ProjectBillingElementEntryTP
  as select from I_ProjectBillingElementEntry as ProjectBillingElementEntry

  association to parent I_ProjectBillingElementTP as _ProjectBillingElement on $projection.ProjectBillingElementUUID = _ProjectBillingElement.ProjectBillingElementUUID
 // association [0..1] to I_Material                       as _Material              on $projection.Material = _Material.Material

 
//  association [0..1] to I_PrjBlgElmEntrBillgPlnLinkTP    as _PrjBlgElmEntryBillgPlnLink    on  $projection.ProjBillgElmntEntrItmUUID = _PrjBlgElmEntryBillgPlnLink.ProjBillgElmntEntrItmUUID

//  association [0..1] to I_WBSElementBasicData            as _WBSElementBasicData           on  $projection.WBSElementInternalID      = _WBSElementBasicData.WBSElementInternalID

  // the below association is exclusively for DCL only.

// commented below association as used I_WBSElementBasicData in DCL   

//  association [0..1] to I_WBSElementBasicData            as _WBSElement           on  $projection.BillingWBSElementInternalID      = _WBSElement.WBSElementInternalID

    
//    association [0..1] to I_PrjBlgElmEntrBillgPlnLinkTP    as _PrjBlgElmEntrBillgPlnLink    on  $projection.ProjBillgElmntEntrItmUUID = _PrjBlgElmEntrBillgPlnLink.ProjBillgElmntEntrItmUUID

 
  composition [0..*] of I_ProjectBillgElmntEntrFlwTP     as _ProjectBillgElmntEntrFlw
  composition [0..1] of I_PrjBlgElmEntrJrnlEntrLinkTP    as _PrjBlgElmEntrJrnlEntrLink
  composition [0..1] of I_PrjBlgElmEntrBillgPlnLinkTP    as _PrjBlgElmEntrBillgPlnLink

{
  key ProjectBillingElementEntry.ProjBillgElmntEntrItmUUID,
      ProjectBillingElementEntry.ProjectBillingElementUUID,
      ProjectBillingElementEntry.ProjBillgElmntEntrSourceType,
      ProjectBillingElementEntry.WBSElementInternalID,
      ProjectBillingElementEntry.Material,
      ProjectBillingElementEntry.QuantityUnit,
      ProjectBillingElementEntry.ProjBillgElmntEntrIsCancelled,
      ProjectBillingElementEntry.PricingDate,
      ProjectBillingElementEntry.NetPriceAmountIsManual,
      ProjectBillingElementEntry.TransactionCurrency,
      ProjectBillingElementEntry.ProjectCurrency,
      ProjectBillingElementEntry.GlobalCurrency,
      ProjectBillingElementEntry.DocumentCurrency,
      ProjectBillingElementEntry.ServicesRenderedDate,
      ProjectBillingElementEntry.OriginalTotalQuantity,
      ProjectBillingElementEntry.OriginalAmountInTransacCrcy,
      ProjectBillingElementEntry.OriginalAmountInProjectCrcy,
      ProjectBillingElementEntry.OriginalAmountInGlobalCurrency,
      ProjectBillingElementEntry.OpenQuantity,
      ProjectBillingElementEntry.OpenAmountInTransCrcy,
      ProjectBillingElementEntry.OpenAmountInProjectCurrency,
      ProjectBillingElementEntry.OpenAmountInGlobalCurrency,
      ProjectBillingElementEntry.ToBeBilledQuantity,
      ProjectBillingElementEntry.ToBeBilledAmtInTransCrcy,
      ProjectBillingElementEntry.ToBeBilledAmtInProjCurrency,
      ProjectBillingElementEntry.ToBeBilledAmtInGlobCurrency,
      ProjectBillingElementEntry.ToBeWrittenOffQuantity,
      ProjectBillingElementEntry.ToBeWrittenOffAmtInTransCrcy,
      ProjectBillingElementEntry.ToBeWrittenOffAmtInProjectCrcy,
      ProjectBillingElementEntry.ToBeWrittenOffAmtInGlobalCrcy,
      ProjectBillingElementEntry.ToBePostponedQuantity,
      ProjectBillingElementEntry.ToBePostponedAmtInTransacCrcy,
      ProjectBillingElementEntry.ToBePostponedAmtInProjectCrcy,
      ProjectBillingElementEntry.ToBePostponedAmtInGlobalCrcy,
      ProjectBillingElementEntry.BillableRevenueAmtInDocCrcy,
      ProjectBillingElementEntry.ManualNetPriceAmtInDocCrcy,
      ProjectBillingElementEntry.NetPriceAmountInDocCrcy,
      ProjectBillingElementEntry.OriginalRevenueAmtInDocCrcy,
      ProjectBillingElementEntry.OpenRevenueAmtInDocCrcy,
      ProjectBillingElementEntry.ProjBillgElmntEntrIsReversed,
      ProjectBillingElementEntry.ProjBillgElmntEntrIsReversal,
      ProjectBillingElementEntry.PrjBlgElmEntrCanclnSrceCode,
    //  ProjectBillingElementEntry.MaterialGroup,

      @Semantics.user.createdBy: true
      ProjectBillingElementEntry.PrjBlgElmEntrCreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      ProjectBillingElementEntry.PrjBlgElmEntrCreatedAtDteTme,
      @Semantics.user.lastChangedBy: true
      ProjectBillingElementEntry.PrjBlgElmEntrLastChgdByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      ProjectBillingElementEntry.PrjBlgElmEntrLastChgdAtDteTme,
     //Exposing for DCL 

 //    _WBSElement,

      //Exposing for DCL

      ProjectBillingElementEntry._ProjectBillingElement.BillingWBSElementInternalID,
      ProjectBillingElementEntry.PrjBlgElmEntryLongText,
      ProjectBillingElementEntry.ProjBillgTransfCostQtyCode,
      ProjectBillingElementEntry.ProjBillgItmValIsNotActualCost,
//      //FXU to test segmented tabs

//      case when ProjBillgElmntEntrSourceID = 'A'

//      then cast('B' as pbe_segmentfilter)

//      else cast('P' as pbe_segmentfilter)

//      end as time_range,



// FXU Segmented button logic shifting to below views

// Conditions added to handle Openquantity as well IM : 2070186054

    
//    

//      case

//         when Material = 'A002' then ''

//         else 

//           case

//            when ToBeBilledAmtInTransCrcy is not initial

//            then cast ('B' as pbe_segmentfilter)

//            when ToBeBilledAmtInTransCrcy is initial and OpenAmountInTransCrcy = ToBePostponedAmtInTransacCrcy 

//            then cast ('P' as pbe_segmentfilter)

//            when ToBeBilledAmtInTransCrcy is initial and OpenAmountInTransCrcy = ToBeWrittenOffAmtInTransCrcy

//            then cast ('W' as pbe_segmentfilter)

//            else cast ('B' as pbe_segmentfilter)

//            end                                                                                                                                                                                                                                                                

//        end                                                                as AvailyCtrlTimeRangeType,        

//        

// FXU Segmented button logic shifting to below views



      _PrjBlgElmEntrBillgPlnLink,
      _ProjectBillingElement,
      _ProjectBillgElmntEntrFlw,
      _PrjBlgElmEntrJrnlEntrLink,
//     _PrjBlgElmEntrBillgPlnLink,

      ProjectBillingElementEntry._Material as _Material,
     // _WBSElementBasicData

      _WBSElement
    //  ProjectBillingElementEntry.SalesDocument,

    //  ProjectBillingElementEntry.ProjectBillingCategory,

    //  ProjectBillingElementEntry._SalesDocument

      

}
// where ProjBillgElmntEntrIsCancelled != 'X'