C_SalesOrderByMonth

DDL: C_SALESORDERBYMONTH SQL: CSDSLSORDBYMNTH Type: view CONSUMPTION
24 Fields 2 Data Sources

Sales Order by Month

C_SalesOrderByMonth is a Consumption CDS View that provides data about "Sales Order by Month" in SAP S/4HANA. It reads from 2 data sources (I_Customer, I_SalesOrderByMonthCube) and exposes 24 fields with key fields SalesOrder, YearMonth.

Data Sources (2)

SourceAliasJoin Type
I_Customer I_Customer left_outer
I_SalesOrderByMonthCube I_SalesOrderByMonthCube from

Parameters (2)

NameTypeDefault
P_ExchangeRateType kurst
P_DisplayCurrency vdm_v_display_currency

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Sales Order by Month view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName CSDSLSORDBYMNTH view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrder SD Document
KEY YearMonth Year Month
SalesOrderType SalesOrderType Sales Order Type
CalendarMonth CalendarMonth Calendar Month
_CalendarMonth _CalendarMonth
CalendarMonthName
SoldToParty SoldToParty Sold-to Party
_SoldToParty _SoldToParty
AuthorizationGroup AuthorizationGroup AuthorizGroup
SalesOrganization SalesOrganization Sales Organization
_SalesOrganization _SalesOrganization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
_DistributionChannel _DistributionChannel
OrganizationDivision OrganizationDivision Org. Division
_OrganizationDivision _OrganizationDivision
SalesOffice SalesOffice Sales Office
_SalesOffice _SalesOffice
SalesGroup SalesGroup Sales Group
_SalesGroup _SalesGroup
DisplayCurrency DisplayCurrency Display Currency
IncomingSalesOrdersNetAmtInDC IncomingSalesOrdersNetAmtInDC Net Value of Current Year
ComprnIncgSlsOrdersNetAmtInDC ComprnIncgSlsOrdersNetAmtInDC Net Value of Previous Year
NumberOfSalesOrders NumberOfSalesOrders Number of Current Year
ComparisonNumberOfSalesOrders ComparisonNumberOfSalesOrders Number of Previous Year

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_SalesOrderByMonth.
-- 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: CSDSLSORDBYMNTH
-- Parameters: P_ExchangeRateType : kurst, P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW C_SalesOrderByMonth AS
SELECT
  SalesOrder,
  cast( YearMonth as ovp_year_month ) AS YearMonth,
  SalesOrderType,
  CalendarMonth,
  _CalendarMonth._Text[1: Language=$session.system_language].CalendarMonthName AS CalendarMonthName,
  SoldToParty,
  AuthorizationGroup,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesOffice,
  SalesGroup,
  DisplayCurrency,
  IncomingSalesOrdersNetAmtInDC,
  ComprnIncgSlsOrdersNetAmtInDC,
  NumberOfSalesOrders,
  ComparisonNumberOfSalesOrders
FROM I_SalesOrderByMonthCube
LEFT OUTER JOIN I_Customer ON /* join condition not captured in parsed metadata */
;

Learn More