I_ProjectBillingRequestItemTP

//@AbapCatalog.sqlViewName: 'IPROJBILREQITM'

//@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Item Details of Project Billing Request'
@ObjectModel.usageType: {
    sizeCategory: #XL,
    dataClass:  #TRANSACTIONAL,
    serviceQuality: #X
}
@Consumption.dbHints: [ 'CS_JOIN_REDUCTION_MULTICOLUMN_FIRST(\'ACDOCA.BELNR\')' ]

define view entity I_ProjectBillingRequestItemTP
  as select from           I_ProjectBillingRequestItem   as ProjectBillingRequestItem

  //Changed the associations to joins by FXU for Performed By Contact Card

    left outer to one join I_PrjBlgElmEntrJrnlEntrLinkTP as _PrjBlgElmEntrJrnlEntrLinkTP on ProjectBillingRequestItem.ProjBillgElmntEntrItmUUID = _PrjBlgElmEntrJrnlEntrLinkTP.ProjBillgElmntEntrItmUUID

   // left outer to one join I_PersonWorkAgreement_1       as _PersonWorkAgreement_1       on _PrjBlgElmEntrJrnlEntrLinkTP.PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement



   association[0..1] to I_WorkForcePersonMappings        as _WorkForcePerson              on  $projection.PersonnelNumber = _WorkForcePerson.WorkforceAssignment


  association [0..1] to I_ProjectBillingElementEntryTP   as _ProjectBillingElementEntryTP on  $projection.ProjBillgElmntEntrItmUUID = _ProjectBillingElementEntryTP.ProjBillgElmntEntrItmUUID
  // association[1..1] to R_PrjBlgElmEntrJrnlEntrLinkTP    as _PrjBlgElmEntrJrnlEntrLinkTP  on  $projection.ProjBillgElmntEntrItmUUID = _PrjBlgElmEntrJrnlEntrLinkTP.ProjBillgElmntEntrItmUUID

  association [0..1] to I_WorkItem                       as _WorkItem                     on  $projection.WorkItem = _WorkItem.WorkItem
  association [0..1] to I_MaterialGroup                  as _MaterialGroup                on  $projection.MaterialGroup = _MaterialGroup.MaterialGroup
  association        to parent I_ProjectBillingRequestTP as _ProjectBillingRequestTP      on  $projection.ProjectBillingRequestUUID = _ProjectBillingRequestTP.ProjectBillingRequestUUID

 // association [0..1] to I_SlsDocItemBillingPlan          as _SalesDocItemBillPlan         on  $projection.BillingPlan = _SalesDocItemBillPlan.BillingPlan


  association [0..1] to I_BillingControlCategoryText     as _BillingControlCategoryText   on  $projection.BillingControlCategory   = _BillingControlCategoryText.BillingControlCategory
                                                                                          and _BillingControlCategoryText.Language = $session.system_language
  
  association [1..1] to I_SalesDocumentItem as _SalesDocumentItem on $projection.SalesDocument = _SalesDocumentItem.SalesDocument 
                                                                     and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem                                                                                        


{
  key ProjectBillingRequestItem.ProjectBillingRequestItemUUID                                                                                                                        as ProjectBillingRequestItemUUID,
      _ProjectBillingRequestTP,

      _ProjectBillingElementEntryTP,

    //  _SalesDocItemBillPlan,


      ProjectBillingRequestItem.ProjectBillingRequestUUID                                                                                                                            as ProjectBillingRequestUUID,
      ProjectBillingRequestItem.ProjBillgElmntEntrItmUUID                                                                                                                            as ProjBillgElmntEntrItmUUID,
      ProjectBillingRequestItem.ProjectBillingElementUUID                                                                                                                            as ProjectBillingElementUUID,


      ProjectBillingRequestItem.SalesDocumentItem                                                                                                                                    as SalesDocumentItem,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      ProjectBillingRequestItem.ToBePostponedQuantity                                                                                                                                as ToBePostponedQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      ProjectBillingRequestItem.ToBePostponedAmtInTransacCrcy                                                                                                                        as ToBePostponedAmtInTransacCrcy,
      @Semantics.amount.currencyCode: 'ProjectCurrency'
      ProjectBillingRequestItem.ToBePostponedAmtInProjectCrcy                                                                                                                        as ToBePostponedAmtInProjectCrcy,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      ProjectBillingRequestItem.ToBePostponedAmtInGlobalCrcy                                                                                                                         as ToBePostponedAmtInGlobalCrcy,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      ProjectBillingRequestItem.ToBeWrittenOffQuantity                                                                                                                               as ToBeWrittenOffQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      ProjectBillingRequestItem.ToBeWrittenOffAmtInTransCrcy                                                                                                                         as ToBeWrittenOffAmtInTransCrcy,
      @Semantics.amount.currencyCode: 'ProjectCurrency'
      ProjectBillingRequestItem.ToBeWrittenOffAmtInProjectCrcy                                                                                                                       as ToBeWrittenOffAmtInProjectCrcy,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      ProjectBillingRequestItem.ToBeWrittenOffAmtInGlobalCrcy                                                                                                                        as ToBeWrittenOffAmtInGlobalCrcy,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      ProjectBillingRequestItem.BillableRevenueAmtInDocCrcy                                                                                                                          as BillableRevenueAmtInDocCrcy,
      @Semantics.user.createdBy: true
      ProjectBillingRequestItem.ProjBillgReqItmCrtedByUser                                                                                                                           as ProjBillgReqItmCrtedByUser,            
      @Semantics.systemDateTime.createdAt: true
      ProjectBillingRequestItem.ProjBillgReqItmCrtedAtDteTme                                                                                                                         as ProjBillgReqItmCrtedAtDteTme,
      @Semantics.user.lastChangedBy: true
      ProjectBillingRequestItem.ProjBillgReqItmLastChgdBy                                                                                                                            as ProjBillgReqItmLastChgdBy,
      @Semantics.systemDateTime.lastChangedAt: true
      ProjectBillingRequestItem.ProjBillgReqItmLastChgdDteTme                                                                                                                        as ProjBillgReqItmLastChgdDteTme,
      ProjectBillingRequestItem.ServicesRenderedDate                                                                                                                                 as ServicesRenderedDate,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      ProjectBillingRequestItem.ToBeBilledQuantity                                                                                                                                   as ToBeBilledQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      ProjectBillingRequestItem.ToBeBilledAmtInTransCrcy                                                                                                                             as ToBeBilledAmtInTransCrcy,
      @Semantics.amount.currencyCode: 'ProjectCurrency'
      ProjectBillingRequestItem.ToBeBilledAmtInProjCurrency                                                                                                                          as ToBeBilledAmtInProjCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      ProjectBillingRequestItem.ToBeBilledAmtInGlobCurrency                                                                                                                          as ToBeBilledAmtInGlobCurrency,

      // ********************** newly added fields in the table *****************************

      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      ProjectBillingRequestItem.OpenQuantity                                                                                                                                                                   as OpenQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      ProjectBillingRequestItem.OpenAmountInTransCrcy                                                                                                                                                          as OpenAmountInTransCrcy,
      @Semantics.amount.currencyCode: 'ProjectCurrency'
      ProjectBillingRequestItem.OpenAmountInProjectCurrency                                                                                                                                                    as OpenAmountInProjectCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      ProjectBillingRequestItem.OpenAmountInGlobalCurrency                                                                                                                                                     as OpenAmountInGlobalCurrency,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      ProjectBillingRequestItem.OpenRevenueAmtInDocCrcy                                                                                                                                                        as OpenRevenueAmtInDocCrcy,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      ProjectBillingRequestItem.NetPriceAmountInDocCrcy                                                                                                                                                        as NetPriceAmountInDocCrcy,
      ProjectBillingRequestItem.Material                                                                                                                                                                       as Material,
      _PrjBlgElmEntrJrnlEntrLinkTP._GLAccountLineItemRawData._OriginCostCtrActivityType._Text[1:Language = $session.system_language].CostCtrActivityTypeDesc                                                   as CostCtrActivityTypeDesc,

//      case

//        when Material = 'A002' then ''

//         else

//           case

//            when ( ProjectBillingRequestItem.ToBeBilledAmtInTransCrcy is not initial or ProjectBillingRequestItem.ToBeBilledQuantity is not initial )

//            then cast ('X' as boolean)

//            else cast ('' as boolean)

//            end

//        end                                                                                                                                                                          as ProjBillgReqItmHasBillableVal,

//

//      case

//       when Material = 'A002' then ''

//        else

//          case

//           when ( ProjectBillingRequestItem.ToBeWrittenOffAmtInTransCrcy is not initial or ProjectBillingRequestItem.ToBeWrittenOffQuantity is not initial )

//           then cast ('X' as boolean)

//           else cast ('' as boolean)

//           end

//       end                                                                                                                                                                           as ProjBillgReqItmHasWrtOffVal,


//      case

//       when Material = 'A002' then ''

//        else

//          case

//           when ( ProjectBillingRequestItem.ToBePostponedAmtInTransacCrcy is not initial or ProjectBillingRequestItem.ToBePostponedQuantity is not initial )

//           then cast ('X' as boolean)

//           else cast ('' as boolean)

//           end

//       end                                                                                                                                                                           as ProjBillgReqItmHasPostponedVal,

      // ********************** newly added fields in the table *****************************


      _ProjectBillingElementEntryTP._Material.MaterialGroup                                                                                                                          as MaterialGroup,
      ProjectBillingRequestItem.TransactionCurrency,
      ProjectBillingRequestItem.ProjectCurrency,
      ProjectBillingRequestItem.QuantityUnit,
      ProjectBillingRequestItem.GlobalCurrency,
      ProjectBillingRequestItem.DocumentCurrency,
      ProjectBillingRequestItem.ProjBillgTransfCostQtyCode,
      ProjectBillingRequestItem.ProjBillgItmValIsNotActualCost,
      // _PrjBlgElmEntrJrnlEntrLinkTP ,


      //   @Semantics.amount.currencyCode: 'ProjectCurrency'

      //   _ProjectBillingElementEntryTP.OriginalAmountInProjectCrcy             as OriginalAmountInProjectCrcy,

    
      ProjectBillingRequestItem.ManualBillgSelForPrjBlgReqItem as ManualBillgSelForPrjBlgReqItem,
       
      _MaterialGroup,

      _PrjBlgElmEntrJrnlEntrLinkTP.BillingControlCategory                                                                                                                            as BillingControlCategory, //added by FXU


      //   _PersonWorkAgreement_1.PersonFullName                as PersonFullName,            //added by FXU

      _WorkForcePerson.PersonFullName                                                                                                                         as PersonFullName,
      _WorkForcePerson._BusinessPartner.PersonNumber                                                                                                                           as PersonNumber, //added by FXU

      _WorkForcePerson._BusinessPartner.BusinessPartnerUUID                                                                                                                    as BusinessPartnerUUID,
      //   _PersonWorkAgreement_1 ,


      _PrjBlgElmEntrJrnlEntrLinkTP._GLAccountLineItemRawData.WorkItem                                                                                                                as WorkItem,
      _PrjBlgElmEntrJrnlEntrLinkTP.PersonnelNumber                                                                                                                                   as PersonnelNumber,


      _ProjectBillingRequestTP.SalesDocument                                                                                                                                         as SalesDocument,
      _WorkItem,

      concat(ltrim(_ProjectBillingRequestTP.SalesDocument,'0'),concat('/',ltrim(ProjectBillingRequestItem.SalesDocumentItem,'0')) )                                                  as SalesOrderItemConcatenatedID,



      // _ProjectBillingElementEntryTP._PrjBlgElmEntrBillgPlnLink._CustProjSlsOrdItmBillgPlnItm.BillingPlanItemUsage                                                                                                                                                                                            as BillingPlanItemUsage,

      //  _ProjectBillingElementEntryTP._PrjBlgElmEntrBillgPlnLink._CustProjSlsOrdItmBillgPlnItm.BillingPlanBillingDate                                                                                                                                                                                          as BillingPlanBillingDate,


      //_ProjectBillingElementEntryTP._Material._Text[1:Language = $session.system_language].MaterialName                                                                              as MaterialName,


      _BillingControlCategoryText,

    //  _ProjectBillingElementEntryTP._PrjBlgElmEntrBillgPlnLink.BillingPlan                                                                                                           as BillingPlan,



      _PrjBlgElmEntrJrnlEntrLinkTP.FiscalYear,

      _PrjBlgElmEntrJrnlEntrLinkTP.LedgerGLLineItem                                                                                                                                  as LedgerGLLineItem,
      _PrjBlgElmEntrJrnlEntrLinkTP.AccountingDocument                                                                                                                                as AccountingDocument,

      //concat(_PrjBlgElmEntrJrnlEntrLinkTP.AccountingDocument,concat('/',concat(_PrjBlgElmEntrJrnlEntrLinkTP.LedgerGLLineItem,concat('/',_PrjBlgElmEntrJrnlEntrLinkTP.FiscalYear))) ) as JournalEntrySemanticKey,


      //      case

      //        when _ProjectBillingElementEntryTP._ProjectBillingElement._ProjBillingDueDate.DueBillingDate > $session.system_date

      //          or _ProjectBillingElementEntryTP._ProjectBillingElement._ProjBillingDueDate.DueBillingDate is null //is initial

      //          or _ProjectBillingElementEntryTP._ProjectBillingElement._ProjBillingDueDate.DueBillingDate = '00000000'

      //       //   or _ProjectBillingElementEntryTP._ProjectBillingElement._ProjBillingDueDate.IsPostedOnAccount = 'X'

      //          then cast(substring( cast( tstmp_current_utctimestamp() as abap.char(17) ), 1, 8 ) as fkdat)

      //

      //        else cast(_ProjectBillingElementEntryTP._ProjectBillingElement._ProjBillingDueDate.DueBillingDate as fkdat)

      //      end as DueBillingDate

      //_ProjectBillingElementEntryTP.WBSElementInternalID,



      //      case

      //        when _ProjectBillingElementEntryTP._ProjectBillingElement.BillingPlanBillingDate > $session.system_date

      //          or _ProjectBillingElementEntryTP._ProjectBillingElement.BillingPlanBillingDate is null //is initial

      //          or _ProjectBillingElementEntryTP._ProjectBillingElement.BillingPlanBillingDate = '00000000'

      //          then cast(substring( cast( tstmp_current_utctimestamp() as abap.char(17) ), 1, 8 ) as fkdat)

      //

      //        else cast(_ProjectBillingElementEntryTP._ProjectBillingElement.BillingPlanBillingDate as fkdat)

      //      end as DueBillingDate

      //      case

      //        when _ProjBillingDueDate(P_BillingPlanItemUsage: '').DueBillingDate > $session.system_date

      //          or _ProjBillingDueDate(P_BillingPlanItemUsage: '').DueBillingDate is null //is initial

      //          or _ProjBillingDueDate(P_BillingPlanItemUsage: '').DueBillingDate = '00000000'

      //          then cast(substring( cast( tstmp_current_utctimestamp() as abap.char(17) ), 1, 8 ) as fkdat)

      //

      //        else cast(_ProjBillingDueDate(P_BillingPlanItemUsage: '').DueBillingDate as fkdat)

      //      end as DueBillingDate


      _ProjectBillingElementEntryTP._ProjectBillingElement.BillingPlanBillingDate as DueBillingDate,
       _SalesDocumentItem,
      _ProjectBillingElementEntryTP.PrjBlgElmEntryLongText as PrjBlgElmEntryLongText,
      ProjectBillingRequestItem.ProjBillingRequestItemLongText as ProjBillingRequestItemLongText,
      ProjectBillingRequestItem._ProjectBillingRequest
                                                                                                        

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_COSTCENTERACTIVITYTYPE",
"I_COSTCENTERACTIVITYTYPETEXT",
"I_GLACCOUNTLINEITEMRAWDATA",
"I_MATERIAL",
"I_PRJBLGELMENTRJRNLENTRLINKTP",
"I_PROJECTBILLINGELEMENTENTRYTP",
"I_PROJECTBILLINGELEMENTTP",
"I_PROJECTBILLINGREQUESTITEM",
"I_PROJECTBILLINGREQUESTTP",
"I_WORKFORCEPERSONMAPPINGS"
],
"ASSOCIATED":
[
"I_BILLINGCONTROLCATEGORYTEXT",
"I_MATERIALGROUP",
"I_PROJECTBILLINGELEMENTENTRYTP",
"I_PROJECTBILLINGREQUEST",
"I_PROJECTBILLINGREQUESTTP",
"I_SALESDOCUMENTITEM",
"I_WORKITEM"
],
"BASE":
[
"I_PROJECTBILLINGREQUESTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/