C_SalesOrderQ2301

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_SalesOrderQ2301.
-- 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: CFISALESORDQ2301
-- Parameters: P_KeyDate : vdm_v_key_date, P_Language : sylangu, P_BusinessUser : syuname, P_ControllingArea : kokrs, P_Ledger : fins_ledger

CREATE VIEW C_SalesOrderQ2301 AS
SELECT
  resultElement: 'ControllingArea' AS resultElementControllingArea,
  resultElement: 'Ledger' AS resultElementLedger,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  GLAccount,
  _GLAccountInChartOfAccounts._Text[1:Language = $parameters.P_Language].GLAccountName AS GLAccountName,
  BusinessTransactionType,
  CalendarMonth,
  CalendarQuarter,
  CalendarWeek,
  CalendarYear,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  CompanyCodeCurrency,
  ControllingDebitCreditCode,
  Customer,
  CustomerGroup,
  FiscalPeriod,
  FiscalQuarter,
  FiscalWeek,
  FiscalYearPeriod,
  FiscalYearQuarter,
  FiscalYearWeek,
  FunctionalArea,
  _FunctionalArea._Text[1:Language = $parameters.P_Language].FunctionalAreaName AS FunctionalAreaName,
  GlobalCurrency,
  AccountingDocument,
  LedgerGLLineItem,
  LedgerFiscalYear,
  Material,
  PartnerCostCtrActivityType,
  PartnerCostCenter,
  PartnerFunctionalArea,
  PartnerOrder_2 AS PartnerOrder,
  PartnerProfitCenter,
  PartnerProject,
  PartnerProjectExternalID,
  PartnerWBSElement,
  PartnerWBSElementExternalID,
  PostingDate,
  AccountingDocumentItem,
  Product,
  SoldProduct,
  ProfitCenter,
  _ProfitCenter[1:ValidityEndDate >= $parameters.P_KeyDate and ValidityStartDate <= $parameters.P_KeyDate]._Text[1:Language = $parameters.P_Language].ProfitCenterName AS ProfitCenterName,
  Segment,
  _Segment._Text[1:Language = $parameters.P_Language].SegmentName AS SegmentName,
  cast(SoldMaterial as fis_sold_material preserving type) AS SoldMaterial,
  PartnerCompany,
  TransactionCurrency,
  WorkItem,
  _WorkPackageWorkItem.WorkItemName AS WorkItemName,
  CalendarYearMonth,
  CalendarYearQuarter,
  CalendarYearWeek,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency,
  Quantity
FROM I_JournalEntryItemCube
;