P_BillingPlanItem

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_BillingPlanItem.
-- 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_BillingPlanItem AS
SELECT
  cast( fplt.fplnr as tds_bplan_id preserving type ) AS BillingPlan,
  fplt.fpltr AS BillingPlanItem,
  fplt.afdat AS BillingPlanBillingDate,
  fplt.fakwr AS BillingPlanAmount,
  fplt.waers AS TransactionCurrency,
  cast( fplt.faksp as tds_billing_block preserving type ) AS BillingBlockReason,
  cast( fplt.fksaf as tds_billing_status preserving type ) AS BillingPlanRelatedBillgStatus,
  cast( fplt.fpttp as tds_bp_date_category preserving type ) AS BillingPlanDateCategory,
  cast( fplt.nfdat as sdbp_start_date preserving type ) AS BillingPlanServiceStartDate,
  cast( fplt.fkdat as sdbp_end_date preserving type ) AS BillingPlanServiceEndDate,
  fplt.zterm AS CustomerPaymentTerms,
  cast( fplt.fkarv as tds_ord_rl_billing_type preserving type ) AS ProposedBillingDocumentType,
  cast ( fplt.fpfix as tds_fixed_date preserving type ) AS AdoptingBillingDateID,
  fplt.fareg AS BillingPlanBillingRule,
  fplt.tetxt AS BillingPlanDateDescriptionCode,
  fplt.mlbez AS BillingPlanMilestoneUsage,
  fplt.fproz AS BillingPlanAmountPercent,
  cast( fplt.korte as tds_correction_date preserving type ) AS BillgPlnDteCorrectionRfndType,
  cast( fplt.kurrf as kurrf_not_converted preserving type ) AS AccountingExchangeRate,
  fplt.postpr AS PostponementReason,
  fplt.item_usage AS BillingPlanItemUsage,
  fplt.item_usage AS BillingPlanItemUsage_2,
  _BillingPlan.BillingPlanUsageCategory AS BillingPlanUsageCategory,
  fplt.descr AS BillingPlanItemDescription,
  fplt.project_milestone_uuid AS EnterpriseProjectMilestoneUUID,
  fplt.project_milestone_id AS EnterpriseProjectMilestone
FROM fplt
LEFT OUTER JOIN P_BillingPlan AS _BillingPlan ON _BillingPlan.BillingPlan = BillingPlan  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON _TransactionCurrency.Currency = TransactionCurrency  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _BillingBlockReason ON _BillingBlockReason.BillingBlockReason = BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_BillingPlanRelatedBillgSts AS _BillingPlanRelatedBillgSts ON _BillingPlanRelatedBillgSts.BillingPlanRelatedBillgStatus = BillingPlanRelatedBillgStatus  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _CustomerPaymentTerms ON _CustomerPaymentTerms.CustomerPaymentTerms = CustomerPaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_BillgPlnDteCrrtnRfndType AS _BillgPlnDteCrrtnRfndType ON _BillgPlnDteCrrtnRfndType.BillgPlnDteCorrectionRfndType = BillgPlnDteCorrectionRfndType  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON _BillingDocumentType.BillingDocumentType = ProposedBillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_BillgPlnDteDescCode AS _BillgPlnDteDescCode ON _BillgPlnDteDescCode.BillingPlanDateDescriptionCode = BillingPlanDateDescriptionCode  -- association [0..1]
LEFT OUTER JOIN I_AdoptingBillingDateID AS _AdoptingBillingDateID ON _AdoptingBillingDateID.AdoptingBillingDateID = AdoptingBillingDateID  -- association [0..1]
LEFT OUTER JOIN I_BillingPlanBillingRule AS _BillingPlanBillingRule ON _BillingPlanBillingRule.BillingPlanBillingRule = BillingPlanBillingRule  -- association [0..1]
LEFT OUTER JOIN I_BillingPlanMilestoneUsage AS _BillingPlanMilestoneUsage ON _BillingPlanMilestoneUsage.UsageCode = BillingPlanMilestoneUsage  -- association [0..1]
LEFT OUTER JOIN I_BillgPlanItemUsage AS _BillgPlanItemUsage ON _BillgPlanItemUsage.BillingPlanItemUsage = BillingPlanItemUsage  -- association [0..1]
LEFT OUTER JOIN I_BillingPlanItemUsage AS _BillgPlanItemUsage_2 ON _BillgPlanItemUsage_2.BillingPlanItemUsage = BillingPlanItemUsage_2 AND _BillgPlanItemUsage_2.BillingPlanUsageCategory = BillingPlanUsageCategory  -- association [0..1]
LEFT OUTER JOIN I_BillgPlnUsgeCat_2 AS _BillingPlanUsageCategory ON _BillingPlanUsageCategory.BillingPlanUsageCategory = BillingPlanUsageCategory  -- association [0..1]
;