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.
-- SQL view name: RPROJBILREQITM

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,
  _PrjBlgElmEntrJrnlEntrLinkTP._GLAccountLineItemRawData._OriginCostCtrActivityType[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date ]._Text[1:Language = $session.system_language].CostCtrActivityTypeDesc AS CostCtrActivityTypeDesc,
  _ProjectBillingElementEntryTP._Material.MaterialGroup AS MaterialGroup,
  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,
  _PersonWorkAgreement_1._BusinessPartner.PersonFullName AS PersonFullName,
  _PersonWorkAgreement_1._BusinessPartner.PersonNumber AS PersonNumber,
  _PersonWorkAgreement_1.BusinessPartner AS BusinessPartner,
  _PersonWorkAgreement_1._WorkForcePersonBPDetails.BusinessPartnerUUID AS BusinessPartnerUUID,
  _PrjBlgElmEntrJrnlEntrLinkTP._GLAccountLineItemRawData.WorkItem AS WorkItem,
  _PrjBlgElmEntrJrnlEntrLinkTP.PersonnelNumber AS PersonnelNumber,
  _ProjectBillingRequestTP.SalesDocument AS SalesDocument,
  _ProjectBillingRequestTP._SalesOrder.SalesOrganization AS SalesOrganization,
  _ProjectBillingRequestTP._SalesOrder.DistributionChannel AS DistributionChannel,
  _ProjectBillingRequestTP._SalesOrder.SoldToParty AS SoldToParty,
  _ProjectBillingRequestTP.ProjectBillingCategory AS ProjectBillingCategory,
  _ProjectBillingElementEntryTP.ProjBillgElmntEntrSourceType AS ProjBillgElmntEntrSourceType,
  _PrjBlgElmEntrJrnlEntrLinkTP.Ledger AS Ledger,
  _PrjBlgElmEntrJrnlEntrLinkTP.CompanyCode AS CompanyCode,
  _PrjBlgElmEntrJrnlEntrLinkTP.FiscalYear AS FiscalYear,
  _PrjBlgElmEntrJrnlEntrLinkTP.LedgerGLLineItem AS LedgerGLLineItem,
  _PrjBlgElmEntrJrnlEntrLinkTP.AccountingDocument AS AccountingDocument,
  _ProjectBillingElementEntryTP._WBSElement.WBSElementObject AS WBSElementObject,
  _DueBillingDate.DueBillingDate AS DueBillingDate,
  ProjectBillingRequestItem._Material AS _Material,
  ProjectBillingRequestItem.ProjBillgTransfCostQtyCode AS ProjBillgTransfCostQtyCode,
  ProjectBillingRequestItem.ProjBillgItmValIsNotActualCost AS ProjBillgItmValIsNotActualCost,
  _ProjectBillingElementEntryTP.PrjBlgElmEntryLongText AS PrjBlgElmEntryLongText,
  ProjectBillingRequestItem.ProjBillingRequestItemLongText AS ProjBillingRequestItemLongText,
  _PrjBlgElmEntrJrnlEntrLinkTP._GLAccountLineItemRawData.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  $session.user_date AS UserLocalDate,
  ProjectBillingRequestItem._ProjectBillingRequest AS _ProjectBillingRequest
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_WorkPackageWorkItem AS _WorkPackageItem ON WorkItem = _WorkPackageItem.WorkItem AND WBSElementObject = _WorkPackageItem.WBSElementObject  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- 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 I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument  -- association [1..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_SalesDocItemBillingPlan AS _SalesDocItemBillPlan ON SalesDocument = _SalesDocItemBillPlan.SalesDocument  -- association [1..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]
;