I_BPAllData

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 I_BPAllData.
-- 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: IBPALLDATA

CREATE VIEW I_BPAllData AS
SELECT
  BillingPlan,
  cast(' ' as fpltr) AS BillingPlanItem,
  SalesDocument,
  SalesDocumentItem,
  BillingDate,
  PostingDate,
  PricingDate,
  EventType,
  BillingEventTypeName,
  BillingPlanBillingDateText,
  SDDocumentStatus,
  DocumentStatusName,
  DocumentStatusDesc,
  MaterialDesc,
  MaterialName,
  NetAmount,
  MstrProjResourceQuantity,
  TransactionCurrency,
  UnitOfMeasure,
  SoldToParty,
  cast('' as faksp) AS BillingBlockReason,
  cast('' as bezei_faksp) AS BillingBlockReasonDescription,
  cast('' as autte) AS IsBillingCreatedInAdvance,
  cast('' as ttbez) AS BillingPlanCategoryName,
  cast('' as fareg) AS BillingPlanRule,
  cast('00000000' as abap.dats(8))as PostingDate AS dats8asPostingDate,
  cast('00000000' as abap.dats(8))as PricingDate AS dats8asPricingDate,
  BillingPlanRuleName
FROM I_Bpcpmdata
;