R_ProjectBillingRequestItemTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_ProjectBillingRequestItemTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_ProjectBillingRequestItemTP AS
SELECT
  ProjectBillingRequestItem.ProjectBillingRequestItemUUID AS ProjectBillingRequestItemUUID,
  ProjectBillingRequestItem.ProjectBillingRequestUUID AS ProjectBillingRequestUUID,
  ProjectBillingRequestItem.ProjBillgElmntEntrItmUUID AS ProjBillgElmntEntrItmUUID,
  ProjectBillingRequestItem.ProjectBillingElementUUID AS ProjectBillingElementUUID,
  ProjectBillingRequestItem.SalesDocumentItem AS SalesDocumentItem,
  ProjectBillingRequestItem.BillingPlan AS BillingPlan,
  ProjectBillingRequestItem.BillingPlanItem AS BillingPlanItem,
  ProjectBillingRequestItem.ToBePostponedQuantity AS ToBePostponedQuantity,
  ProjectBillingRequestItem.ToBePostponedAmtInTransacCrcy AS ToBePostponedAmtInTransacCrcy,
  ProjectBillingRequestItem.ToBePostponedAmtInProjectCrcy AS ToBePostponedAmtInProjectCrcy,
  ProjectBillingRequestItem.ToBePostponedAmtInGlobalCrcy AS ToBePostponedAmtInGlobalCrcy,
  ProjectBillingRequestItem.ToBeWrittenOffQuantity AS ToBeWrittenOffQuantity,
  ProjectBillingRequestItem.ToBeWrittenOffAmtInTransCrcy AS ToBeWrittenOffAmtInTransCrcy,
  ProjectBillingRequestItem.ToBeWrittenOffAmtInProjectCrcy AS ToBeWrittenOffAmtInProjectCrcy,
  ProjectBillingRequestItem.ToBeWrittenOffAmtInGlobalCrcy AS ToBeWrittenOffAmtInGlobalCrcy,
  ProjectBillingRequestItem.BillableRevenueAmtInDocCrcy AS BillableRevenueAmtInDocCrcy,
  ProjectBillingRequestItem.ProjBillgReqItmCrtedByUser AS ProjBillgReqItmCrtedByUser,
  ProjectBillingRequestItem.ProjBillgReqItmCrtedAtDteTme AS ProjBillgReqItmCrtedAtDteTme,
  ProjectBillingRequestItem.ProjBillgReqItmLastChgdBy AS ProjBillgReqItmLastChgdBy,
  ProjectBillingRequestItem.ProjBillgReqItmLastChgdDteTme AS ProjBillgReqItmLastChgdDteTme,
  ProjectBillingRequestItem.ServicesRenderedDate AS ServicesRenderedDate,
  ProjectBillingRequestItem.ToBeBilledQuantity AS ToBeBilledQuantity,
  ProjectBillingRequestItem.ToBeBilledAmtInTransCrcy AS ToBeBilledAmtInTransCrcy,
  ProjectBillingRequestItem.ToBeBilledAmtInProjCurrency AS ToBeBilledAmtInProjCurrency,
  ProjectBillingRequestItem.ToBeBilledAmtInGlobCurrency AS ToBeBilledAmtInGlobCurrency,
  ProjectBillingRequestItem.OpenQuantity AS OpenQuantity,
  ProjectBillingRequestItem.OpenAmountInTransCrcy AS OpenAmountInTransCrcy,
  ProjectBillingRequestItem.OpenAmountInProjectCurrency AS OpenAmountInProjectCurrency,
  ProjectBillingRequestItem.OpenAmountInGlobalCurrency AS OpenAmountInGlobalCurrency,
  ProjectBillingRequestItem.OpenRevenueAmtInDocCrcy AS OpenRevenueAmtInDocCrcy,
  ProjectBillingRequestItem.NetPriceAmountInDocCrcy AS NetPriceAmountInDocCrcy,
  ProjectBillingRequestItem.NetPriceQuantity AS NetPriceQuantity,
  ProjectBillingRequestItem.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  ProjectBillingRequestItem.Material AS Material,
  ProjectBillingRequestItem.TransactionCurrency AS TransactionCurrency,
  ProjectBillingRequestItem.ProjectCurrency AS ProjectCurrency,
  ProjectBillingRequestItem.QuantityUnit AS QuantityUnit,
  ProjectBillingRequestItem.GlobalCurrency AS GlobalCurrency,
  ProjectBillingRequestItem.DocumentCurrency AS DocumentCurrency,
  ProjectBillingRequestItem.ManualBillgSelForPrjBlgReqItem AS ManualBillgSelForPrjBlgReqItem,
  ProjectBillingRequestItem.ProjectBillingRequestItemDesc AS ProjectBillingRequestItemDesc,
  ProjectBillingRequestItem.ProjBillgReqItmSourceType AS ProjBillgReqItmSourceType,
  ProjectBillingRequestItem.ProjBillgTransfCostQtyCode AS ProjBillgTransfCostQtyCode,
  ProjectBillingRequestItem.ProjBillgItmValIsNotActualCost AS ProjBillgItmValIsNotActualCost,
  ProjectBillingRequestItem.ProjBillingRequestItemLongText AS ProjBillingRequestItemLongText,
  _ProjectBillingRequestTP.SalesDocument AS SalesDocument,
  _ProjectBillingRequestTP._SalesOrder.SalesOrganization AS SalesOrganization,
  _ProjectBillingRequestTP._SalesOrder.DistributionChannel AS DistributionChannel,
  _ProjectBillingRequestTP._SalesOrder.SoldToParty AS SoldToParty,
  _ProjectBillingRequestTP.ProjectBillingCategory AS ProjectBillingCategory,
  _ProjectBillingRequestTP.ProjectBillingRequestStatus AS ProjectBillingRequestStatus,
  _ProjectBillingRequestTP.UserID AS UserID,
  _PrjBlgElmEntrJrnlEntrLinkTP.PersonnelNumber AS PersonnelNumber,
  _PrjBlgElmEntrJrnlEntrLinkTP.Ledger AS Ledger,
  _PrjBlgElmEntrJrnlEntrLinkTP.CompanyCode AS CompanyCode,
  _PrjBlgElmEntrJrnlEntrLinkTP.FiscalYear AS FiscalYear,
  _PrjBlgElmEntrJrnlEntrLinkTP.LedgerGLLineItem AS LedgerGLLineItem,
  _PrjBlgElmEntrJrnlEntrLinkTP.AccountingDocument AS AccountingDocument,
  _PrjBlgElmEntrJrnlEntrLinkTP._GLAccountLineItemRawData.WorkItem AS WorkItem,
  _PrjBlgElmEntrJrnlEntrLinkTP._GLAccountLineItemRawData.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  _PersonWorkAgreement_1._WorkForcePersonBPDetails.BusinessPartnerUUID AS BusinessPartnerUUID,
  case when ProjectBillingRequestItem.ProjBillgReqItmSourceType = 'A' then case when _ProjBillgElmntTEBillgDate.MaxBillingDate is not null then _ProjBillgElmntTEBillgDate.MaxBillingDate when _ProjBillgElmntTEBillgDate.MinBillingDate is not null then _ProjBillgElmntTEBillgDate.MinBillingDate when _ProjBillgElmntTEBillgDate.MaxBillingDate is null and _ProjBillgElmntTEBillgDate.MinBillingDate is null then cast( '99991231' as fkdat ) end else _ProjectBillingElementEntryTP.ServicesRenderedDate end as DueBillingDate AS ServicesRenderedDateendasDueBillingDate,
  $session.user_date AS UserLocalDate,
  _ProjectBillingElementEntryTP._PrjBlgElmEntrBillgPlnLnk._SalesDocumentBillingPlanItem.BillingPlanServiceStartDate AS BillingPlanServiceStartDate,
  _ProjectBillingElementEntryTP._PrjBlgElmEntrBillgPlnLnk._SalesDocumentBillingPlanItem.BillingPlanServiceEndDate AS BillingPlanServiceEndDate,
  case when _ProjectBillingElementEntryTP.OriginalTotalQuantity is not initial then cast( cast( ( curr_to_decfloat_amount( _ProjectBillingElementEntryTP.OriginalAmountInTransacCrcy ) / _ProjectBillingElementEntryTP.OriginalTotalQuantity ) as abap.dec(23,2) ) as abap.curr(23,2) ) else cast( 0 as abap.curr(23,2) ) end as BaseUnitActualCost AS curr232endasBaseUnitActualCost,
  _PrjBlgElmEntrJrnlEntrLinkTP._GLAccountLineItemRawData.PartnerCostCenter AS PartnerCostCenter,
  ProjectBillingRequestItem._Material AS _Material,
  ProjectBillingRequestItem._ProjectBillingRequest AS _ProjectBillingRequest,
  ProjectBillingRequestItem._TransactionCurrency AS _TransactionCurrency,
  ProjectBillingRequestItem._ProjectCurrency AS _ProjectCurrency,
  ProjectBillingRequestItem._GlobalCurrency AS _GlobalCurrency,
  ProjectBillingRequestItem._DocumentCurrency AS _DocumentCurrency,
  ProjectBillingRequestItem._ProjBillgReqItmSrceType AS _ProjBillgReqItmSrceType,
  ProjectBillingRequestItem._TransactionCurrencyText AS _TransactionCurrencyText,
  ProjectBillingRequestItem._ProjectCurrencyText AS _ProjectCurrencyText,
  ProjectBillingRequestItem._GlobalCurrencyText AS _GlobalCurrencyText,
  ProjectBillingRequestItem._DocumentCurrencyText AS _DocumentCurrencyText,
  ProjectBillingRequestItem._ProjBillgReqItmSrceTypeText AS _ProjBillgReqItmSrceTypeText
FROM I_ProjectBillingRequestItem AS ProjectBillingRequestItem
LEFT OUTER JOIN I_WorkForcePersonMappings AS _PersonWorkAgreement_1 ON _PrjBlgElmEntrJrnlEntrLinkTP.PersonnelNumber = _PersonWorkAgreement_1.WorkforceAssignment  -- association [0..1]
LEFT OUTER JOIN R_ProjectBillingElementEntryTP AS _ProjectBillingElementEntryTP ON ProjBillgElmntEntrItmUUID = _ProjectBillingElementEntryTP.ProjBillgElmntEntrItmUUID  -- association [0..1]
LEFT OUTER JOIN I_BillingControlCategoryText AS _BillingControlCategoryText ON BillingControlCategory = _BillingControlCategoryText.BillingControlCategory AND _BillingControlCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_JournalEntryItem AS _JournalEntryItemExtension ON Ledger = _JournalEntryItemExtension.SourceLedger AND CompanyCode = _JournalEntryItemExtension.CompanyCode AND FiscalYear = _JournalEntryItemExtension.FiscalYear AND AccountingDocument = _JournalEntryItemExtension.AccountingDocument AND LedgerGLLineItem = _JournalEntryItemExtension.LedgerGLLineItem  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetOvertimeCatText AS _TimeSheetOvertimeCatText ON TimeSheetOvertimeCategory = _TimeSheetOvertimeCatText.TimeSheetOvertimeCategory AND _TimeSheetOvertimeCatText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CustomerMaterial_2 AS _CustomerMaterial ON salesorganization = _CustomerMaterial.SalesOrganization AND distributionchannel = _CustomerMaterial.DistributionChannel AND soldtoparty = _CustomerMaterial.Customer AND Material = _CustomerMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_PrjBlgElmEntrJrnlEntrLink AS _PrjBlgElmEntrJrnlEntrLink ON ProjectBillingRequestItem.ProjBillgElmntEntrItmUUID = _PrjBlgElmEntrJrnlEntrLink.ProjBillgElmntEntrItmUUID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBillingElmntDueDate AS _DueBillingDate ON ProjectBillingElementUUID = _DueBillingDate.ProjectBillingElementUUID  -- association [1..1]
LEFT OUTER JOIN I_ProjectBillingCategory AS _ProjectBillingCategory ON projectbillingcategory = _ProjectBillingCategory.ProjectBillingCategory  -- association [0..1]
LEFT OUTER JOIN I_ProjectBillingCategoryText AS _ProjectBillingCategoryText ON projectbillingcategory = _ProjectBillingCategoryText.ProjectBillingCategory  -- association [1..*]
LEFT OUTER JOIN E_ProjectBillingRequestItem AS _Extension ON ProjectBillingRequestItemUUID = _Extension.ProjectBillingRequestItemUUID  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrgDets AS _EngmntPrjSrvcOrgDets ON PartnerCostCenter = _EngmntPrjSrvcOrgDets.AssignedOrganisation AND _EngmntPrjSrvcOrgDets.AssignedOrganisationType = 'CS'  -- association [0..*]
LEFT OUTER JOIN R_ProjBillgReqItemPrpsdNoteTP AS _ProjBillgReqItemPrpsdNoteTP ON /* condition not available in parsed metadata */  -- association [0..1]
;