P_BillingPlan

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 P_BillingPlan.
-- 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 P_BillingPlan AS
SELECT
  cast( fpla.fplnr as tds_bplan_id preserving type ) AS BillingPlan,
  fpla.fptyp AS BillingPlanCategory,
  fpla.bpcat AS BillingPlanUsageCategory,
  fpla.fpart AS BillingPlanType,
  cast( fpla.bedat as tds_bp_start_date preserving type) AS BillingPlanStartDate,
  fpla.bedar AS BillingPlanStartDateRule,
  cast( fpla.endat as tds_bp_end_date preserving type ) AS BillingPlanEndDate,
  fpla.endar AS BillingPlanEndDateRule,
  fpla.sortl AS BillingPlanSearchTerm,
  fpla.vbeln AS SalesDocument,
  fpla.paylink AS PaymentLinkIsRequired,
  fpla.perio AS BillingPlanNextBillingDateRule,
  cast( fpla.rfpln as tds_refbplan_id preserving type ) AS ReferenceBillingPlan
FROM fpla
LEFT OUTER JOIN P_BillingPlanItem AS _BillingPlanItem ON _BillingPlanItem.BillingPlan = BillingPlan  -- association [0..*]
LEFT OUTER JOIN I_BillingPlanCategory AS _BillingPlanCategory ON _BillingPlanCategory.BillingPlanCategory = BillingPlanCategory  -- association [0..1]
LEFT OUTER JOIN I_BillgPlnUsgeCat_2 AS _BillingPlanUsageCategory ON _BillingPlanUsageCategory.BillingPlanUsageCategory = BillingPlanUsageCategory  -- association [0..1]
LEFT OUTER JOIN I_BillingPlanType AS _BillingPlanType ON _BillingPlanType.BillingPlanType = BillingPlanType  -- association [0..1]
LEFT OUTER JOIN I_IndirectDateDetermineRule AS _StartDateRule ON _StartDateRule.IndirectDateDetermineRule = BillingPlanStartDateRule  -- association [0..1]
LEFT OUTER JOIN I_IndirectDateDetermineRule AS _EndDateRule ON _EndDateRule.IndirectDateDetermineRule = BillingPlanEndDateRule  -- association [0..1]
LEFT OUTER JOIN I_IndirectDateDetermineRule AS _NextBillingDateRule ON _NextBillingDateRule.IndirectDateDetermineRule = BillingPlanNextBillingDateRule  -- association [0..1]
;