C_MasterProjectBillingPlan

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 C_MasterProjectBillingPlan.
-- 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: CMPBILLPLAN

CREATE VIEW C_MasterProjectBillingPlan AS
SELECT
  BillingPlan.MasterProject AS MasterProject,
  BillingPlan.BillingPlan AS BillingPlan,
  BillingPlan.BillingPlanItem AS BillingPlanItem,
  cast(BillingPlan.SalesDocument as /cpd/pws_rcb_vbeln) AS SalesDocument,
  SalesDocument AS SalesOrder,
  SalesDocumentItem AS SalesOrderItem,
  _SalesDocumentItem.SalesDocumentItemText AS SalesDocumentItemText,
  (ltrim(SalesDocumentItem,'0') ) AS SalesDocumentItem,
  cast(BillingPlan._SalesDocument.SalesDocumentType as auart) AS SalesDocumentType,
  BillingPlan.SalesOrganization AS SalesOrganization,
  _SalesOrganizationText.SalesOrganizationName AS SalesOrganizationName,
  cast(BillingPlan.ControllingObjectExternalID as /cpd/cpm_struct_elm) AS ControllingObjectExternalID,
  cast(BillingPlan.ControllingObjectDescription as /cpd/cpm_str_elm_nm) AS ControllingObjectDescription,
  BillingPlan.MasterProjectName AS MasterProjectName,
  BillingPlan.BillingDate AS BillingDate,
  cast(BillingPlan.PostingDate as /cpd/pws_rcb_budat) AS PostingDate,
  cast(BillingPlan.PricingDate as /cpd/pws_rcb_pridat) AS PricingDate,
  BillingPlan.EventType AS EventType,
  cast(BillingPlan.BillingEventTypeName as /cpd/pws_ws_bilevnt_typ_desc) AS BillingEventTypeName,
  BillingPlan.BillingPlanBillingDateText AS BillingPlanBillingDateText,
  BillingPlan.SDDocumentStatus AS SDDocumentStatus,
  BillingPlan.DocumentStatusName AS DocumentStatusName,
  cast(BillingPlan.DocumentStatusDesc as /cpd/pws_ws_bildoc_stsdesc) AS DocumentStatusDesc,
  cast(BillingPlan.MaterialName as matnr) AS Material,
  cast(BillingPlan.MaterialDesc as /cpd/pws_ws_material_desc) AS MaterialName,
  BillingPlan.NetAmount AS NetAmount,
  cast(BillingPlan.MstrProjResourceQuantity as /cpd/pws_ws_bilrcv_rescqty) AS MstrProjResourceQuantity,
  BillingPlan.TransactionCurrency AS TransactionCurrency,
  BillingPlan.UnitOfMeasure AS UnitOfMeasure,
  BillingPlan.BillingBlockReasonDescription AS BillingBlockReasonDescription,
  BillingPlan.IsBillingCreatedInAdvance AS IsBillingCreatedInAdvance,
  BillingPlan.BillingPlanCategoryName AS BillingPlanCategoryName,
  BillingPlan.BillingPlanRuleName AS BillingPlanRuleName,
  BillingPlan.SoldToParty AS SoldToParty,
  BillingPlan.CustomerName AS CustomerName,
  BillingPlan._SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  _MasterProject.UserIsInvolved AS UserIsInvolved,
  _MasterProject.MasterProjectType AS MasterProjectType
FROM I_BPMasterProject AS BillingPlan
LEFT OUTER JOIN I_MasterProjectVH AS _MasterProject ON MasterProject = _MasterProject.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_MPStructureElement AS _ControllingObject ON ControllingObjectExternalID = _ControllingObject.ControllingObjectExternalID AND MasterProject = _ControllingObject.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON SoldToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON SalesOrganization = _SalesOrganizationText.SalesOrganization AND _SalesOrganizationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesOrder = _SalesDocumentItem.SalesDocument AND SalesOrderItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_MPBillPlanRRB AS _ExtensionRRB ON BillingPlan = _ExtensionRRB.BillingPlan  -- association [0..1]
LEFT OUTER JOIN E_MPBillPlanBAP AS _ExtensionBAP ON BillingPlan = _ExtensionBAP.BillingPlan  -- association [0..1]
LEFT OUTER JOIN E_MPBillPlanFixed AS _ExtensionFixed ON BillingPlan = _ExtensionFixed.BillingPlan  -- association [0..1]
;