I_IndustryMargin

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_IndustryMargin.
-- 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: IINDMARGIN

CREATE VIEW I_IndustryMargin AS
SELECT
  Ledger,
  CompanyCode,
  ControllingArea,
  ProfitCenter,
  CompanyCodeName,
  GLAccountHierarchy,
  LeadingLedger,
  Material,
  MaterialName,
  Industry,
  SupplierIndustryName,
  CompanyCodeCurrency,
  GlobalCurrency,
  BilledRevenueAmtInCoCodeCrcy,
  SalesDeductionAmtInCoCodeCrcy,
  RevenueAdjustAmtInCoCodeCrcy,
  COGSAmountInCoCodeCrcy,
  VariancesAmountInCoCodeCrcy,
  ScrapAmountInCoCodeCrcy,
  AdminOverheadAmtInCoCodeCrcy,
  SalesOverheadAmtInCoCodeCrcy,
  MarketingOvhdAmtInCoCodeCrcy,
  ResearchDevOvhdAmtInCoCodeCrcy,
  ContrbnMargin1AmtInCoCodeCrcy,
  ContrbnMargin2AmtInCoCodeCrcy,
  ContrbnMargin3AmtInCoCodeCrcy,
  BilledRevenueAsSalesPct,
  SalesDeductionAsSalesPct,
  RevenueAdjustAsSalesPct,
  COGSAsSalesPct,
  VariancesAsSalesPct,
  ScrapAsSalesPct,
  OverheadAdminAsSalesPct,
  OverheadSalesAsSalesPct,
  OverheadMarketingAsSalesPct,
  OverheadResearchAsSalesPct,
  case BilledRevenueAmtInCoCodeCrcy when 0 then 0 else cast(ContrbnMargin1AmtInCoCodeCrcy as abap.fltp) * 100.00 / cast(BilledRevenueAmtInCoCodeCrcy as abap.fltp) end as ContributionMargin1AsSalesPct AS fltpendasContributionMargin1AsSalesPct,
  case BilledRevenueAmtInCoCodeCrcy when 0 then 0 else cast(ContrbnMargin2AmtInCoCodeCrcy as abap.fltp) * 100.00 / cast(BilledRevenueAmtInCoCodeCrcy as abap.fltp) end as ContributionMargin2AsSalesPct AS fltpendasContributionMargin2AsSalesPct,
  case BilledRevenueAmtInCoCodeCrcy when 0 then 0 else cast(ContrbnMargin3AmtInCoCodeCrcy as abap.fltp) * 100.00 / cast(BilledRevenueAmtInCoCodeCrcy as abap.fltp) end as ContributionMargin3AsSalesPct AS fltpendasContributionMargin3AsSalesPct,
  BilledRevenueAmtInGlobCrcy,
  SalesDeductionAmountInGlobCrcy,
  RevenueAdjustAmtInGlobCrcy,
  COGSAmountInGlobCrcy,
  VariancesAmountInGlobCrcy,
  ScrapAmountInGlobCrcy,
  AdminOverheadAmtInGlobCrcy,
  SalesOverheadAmtInGlobCrcy,
  MarketingOverheadAmtInGlobCrcy,
  ResearchDevOvhdAmtInGlobCrcy,
  ContrbnMargin1AmtInGlobCrcy,
  ContrbnMargin2AmtInGlobCrcy,
  ContrbnMargin3AmtInGlobCrcy
FROM P_IndustryMarginPctOfSales
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
;