C_SlsAcctgGrssMargPerMatlOvw

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_SlsAcctgGrssMargPerMatlOvw.
-- 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: CSAGMPMOVW
-- Parameters: P_KeyDate : datum, P_CompanyCode : fis_bukrs, P_FiscalYearPeriod : fis_jahrper_conv, P_DisplayCurrency : vdm_v_display_currency, P_PlanningCategory : fac_revvar_pln_category, P_FiscalYearComprnVariant : fco_sls_acctg_ovw_year_var, P_FiscalPeriodComprnVariant : fco_sls_acctg_ovw_period_var, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fins_fiscalperiod, P_Interval1Year : fis_gjahr, P_Interval2Year : fis_gjahr, P_Interval1FromFiscalPeriod : fis_period_from, P_Interval2FromFiscalPeriod : fis_period_from, P_Interval1Type : fac_revvar_interval_type, P_Interval2Type : fac_revvar_interval_type

CREATE VIEW C_SlsAcctgGrssMargPerMatlOvw AS
SELECT
  resultElement: 'FiscalYear' AS resultElementFiscalYear,
  resultElement: 'FiscalPeriod' AS resultElementFiscalPeriod,
  resultElement: 'Interval1Year' AS resultElementInterval1Year,
  resultElement: 'Interval2Year' AS resultElementInterval2Year,
  resultElement: 'Interval1FromFiscalPeriod' AS resultElementInterval1FromFiscalPeriod,
  resultElement: 'Interval2FromFiscalPeriod' AS resultElementInterval2FromFiscalPeriod,
  resultElement: 'Interval1Type' AS resultElementInterval1Type,
  resultElement: 'Interval2Type' AS resultElementInterval2Type,
  P_Interval1ToFiscalPeriod : :P_FiscalPeriod AS P_Interval1ToFiscalPeriodP_FiscalPeriod,
  P_Interval2ToFiscalPeriod : :P_FiscalPeriod AS P_Interval2ToFiscalPeriodP_FiscalPeriod,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  GLAccountHierarchy,
  SemanticTag,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency,
  FiscalPeriod,
  PlanningCategory,
  BaseUnit,
  BaseUnitName,
  LedgerName,
  CompanyCodeName,
  CompanyCodeCurrency,
  Country,
  CountryName,
  SalesOrganization,
  SalesOrganizationName,
  Division,
  DivisionName,
  DistributionChannel,
  DistributionChannelName,
  Customer,
  CustomerName,
  cast( Material as fco_sls_acctg_ovw_matnrname50 ) AS Material,
  MaterialName,
  MaterialGroup,
  MaterialGroupName,
  CustomerGroup,
  GLAccount,
  ProfitCenter,
  cast(CustomerSupplierCountry as fco_sls_acctg_ovw_country_name preserving type ) AS CustomerSupplierCountry,
  CustomerSupplierIndustry,
  RatioUnit,
  GlobalCurrency,
  currency_conversion( amount => Intvl1GrossProfitAmtInGlobCrcy, source_currency => GlobalCurrency, target_currency => :P_DisplayCurrency, exchange_rate_date => :P_KeyDate, exchange_rate_type => 'M', round => #CDSBoolean.true, decimal_shift => #CDSBoolean.true, decimal_shift_back => #CDSBoolean.true ) as Intvl1GrossProfitAmtInGlobCrcy AS trueasIntvl1GrossProfitAmtInGlobCrcy,
  currency_conversion( amount => Intvl1RecgdRevnAmtInGlobCrcy, source_currency => GlobalCurrency, target_currency => :P_DisplayCurrency, exchange_rate_date => :P_KeyDate, exchange_rate_type => 'M', round => #CDSBoolean.true, decimal_shift => #CDSBoolean.true, decimal_shift_back => #CDSBoolean.true ) as Intvl1RecgdRevnAmtInGlobCrcy AS trueasIntvl1RecgdRevnAmtInGlobCrcy,
  currency_conversion( amount => Intvl2GrossProfitAmtInGlobCrcy, source_currency => GlobalCurrency, target_currency => :P_DisplayCurrency, exchange_rate_date => :P_KeyDate, exchange_rate_type => 'M', round => #CDSBoolean.true, decimal_shift => #CDSBoolean.true, decimal_shift_back => #CDSBoolean.true ) as Intvl2GrossProfitAmtInGlobCrcy AS trueasIntvl2GrossProfitAmtInGlobCrcy,
  currency_conversion( amount => Intvl2RecgdRevnAmtInGlobCrcy, source_currency => GlobalCurrency, target_currency => :P_DisplayCurrency, exchange_rate_date => :P_KeyDate, exchange_rate_type => 'M', round => #CDSBoolean.true, decimal_shift => #CDSBoolean.true, decimal_shift_back => #CDSBoolean.true ) as Intvl2RecgdRevnAmtInGlobCrcy AS trueasIntvl2RecgdRevnAmtInGlobCrcy,
  cast(0.0 as fco_sls_acctg_ovw_plan_ru) AS PlanGrossMarginPercent,
  cast(0.0 as fco_sls_acctg_ovw_actual_ru) AS ActualGrossMarginPercent,
  cast(0.0 as fco_sls_acctg_ovw_prevyear_ru) AS PreviousYearGrossMarginPercent,
  cast(0.0 as fco_sls_acctg_ovw_diff_ru) AS GrossMarginDifferenceRatio,
  cast(0.0 as fco_sls_acctg_ovw_diff_ru) AS AverageGrossMarginPercent,
  FinancialAccountType,
  FunctionalArea,
  BusinessArea,
  Segment,
  ControllingArea,
  CostCenter,
  Plant,
  ValuationArea,
  OrganizationDivision,
  ServiceDocumentType,
  AssetClass,
  PostingDate,
  Supplier,
  SalesDocument,
  OrderID,
  AccountingDocumentType,
  ServiceDocument
FROM I_SlsAcctgGrssMargPerMatlOvw
;