C_GrossMarginKPI

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_GrossMarginKPI.
-- 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: CGROSSMARGKPI
-- Parameters: P_Ledger : fins_ledger

CREATE VIEW C_GrossMarginKPI AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  GLAccountHierarchy,
  SemanticTag,
  ValidityStartDate,
  ValidityEndDate,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  DocumentDate,
  ProfitCenter,
  GLAccount,
  SalesOrder,
  SalesOrganization,
  DistributionChannel,
  cast (SoldMaterial as fins_matnr_pa preserving type) AS SoldProduct,
  MaterialGroup AS ProductGroup,
  CustomerGroup,
  Customer,
  FiscalQuarter,
  FiscalPeriod,
  FiscalYearVariant,
  cast(FiscalYearPeriod as abap.char( 7 )) AS FiscalYearPeriod,
  _FiscalPeriodForVariant.FiscalPeriodStartDate AS FiscalPeriodStartDate,
  _FiscalPeriodForVariant.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  CompanyCodeCurrency,
  GlobalCurrency,
  SalesDistrict,
  Segment,
  SalesOrderItem,
  OrderType,
  Division,
  BusinessTransactionType,
  BusinessArea,
  CostCenter,
  CustomerSupplierCountry,
  _GrossMargin.ControllingArea AS ControllingArea,
  AccountingDocumentCategory,
  PostingDate,
  CreationDate,
  _GrossMargin.ChartOfAccounts AS ChartOfAccounts,
  LedgerFiscalYear,
  FinancialTransactionType,
  TransactionCurrency,
  DebitCreditCode,
  AssignmentReference,
  PostingKey,
  AccountingDocCreatedByUser,
  GLAccountType,
  Plant,
  FinancialAccountType,
  SpecialGLCode,
  ClearingDate,
  ClearingAccountingDocument,
  BillingDocumentType,
  CustomerSupplierIndustry,
  BillToParty,
  ShipToParty,
  SourceReferenceDocumentType,
  SourceReferenceDocument,
  OperatingConcern,
  TransactionTypeDetermination,
  ControllingDebitCreditCode,
  AccountingDocumentType,
  ReferenceDocumentType,
  JrnlEntryItemObsoleteReason,
  ActlRecognizedRevnAmtInCCCrcy,
  ActlRecgdRevenueAmtInGlobCrcy,
  ActualCostAmtInCCCrcy,
  ActlCostOfGdsSoldAmtInGlobCrcy,
  ActlRecognizedMargAmtInCCCrcy,
  ActlRecgdMargAmtInGlobCrcy,
  ActlSlsDeductionAmtInGlobCrcy,
  ActlSlsDeductionAmtInCCCrcy,
  ActlBilledRevenueAmtInGlobCrcy,
  ActlBilledRevenueAmtInCCCrcy,
  PrdtdRecognizedRevnAmtInCCCrcy,
  PrdtdRecgdRevenueAmtInGlobCrcy,
  PrdtdCostAmtInCompanyCodeCrcy,
  PrdtdCostAmtInGlobCrcy,
  PrdtdRecognizedMargAmtInCCCrcy,
  PrdtdRecgdMargAmtInGlobCrcy,
  PrdtdSlsDeductionAmtInGlobCrcy,
  PrdtdSlsDeductionAmtInCCCrcy,
  PrdtdBilledRevnAmtInGlobCrcy,
  PrdtdBilledRevenueAmtInCCCrcy,
  RecognizedRevnAmtInCCCrcy,
  RecognizedRevnAmtInGlobCrcy,
  CostAmountInCompanyCodeCrcy,
  CostOfGoodsSoldAmtInGlobCrcy,
  RecognizedMarginAmtInCCCrcy,
  RecognizedMarginAmount,
  SalesDeductionAmountInGlobCrcy,
  SalesDeductionAmtInCoCodeCrcy,
  BilledRevenueAmtInGlobCrcy,
  BilledRevenueAmtInCoCodeCrcy,
  PlnRecognizedRevnAmtInCCCrcy,
  PlnRecgdRevenueAmtInGlobCrcy,
  PlnCostAmtInCompanyCodeCrcy,
  PlnCostOfGdsSoldAmtInGlobCrcy,
  PlnRecognizedMargAmtInCCCrcy,
  PlnRecognizedMargAmtInGlobCrcy,
  PlnSlsDeductionAmtInGlobCrcy,
  PlnSlsDeductionAmtInCCCrcy,
  PlnBilledRevenueAmtInGlobCrcy,
  PlnBilledRevenueAmtInCCCrcy,
  cast(PlanningCategory as fac_revvar_pln_category) AS PlanningCategory,
  BaseUnit,
  Quantity,
  Quantity AS AmountFulfillmentPercent,
  cast('%' as msehi) AS UnitOfMeasure,
  IsSimulation,
  cast(100 as abap.int1) AS MktgKPIToleranceRangeLow,
  cast(100 as abap.int1) AS MktgKPIDeviationRangeLow,
  AuthorizationGroup
FROM I_GrossMargin
;