C_SalesVolumeAnalyticsQry

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

CREATE VIEW C_SalesVolumeAnalyticsQry AS
SELECT
  BillingDocument,
  BillingDocumentItem,
  SDDocumentCategory,
  BillingDocumentType,
  BillingDocumentCategory,
  SalesDocumentItemCategory,
  SalesDocumentItemType,
  ReturnItemProcessingType,
  DisplayCurrency,
  NetAmountInDisplayCurrency,
  CustCrdtMemoNetAmtInDspCrcy,
  cast(1 as net_prf_marg_net_amt_idc ) AS NetSlsProfitMargNetAmtInDC,
  CreatedByUser,
  CreatedByUserName,
  CreationDate,
  CreationTime,
  LogicalSystem,
  CreationDateYear,
  CreationDateYearQuarter,
  CreationDateYearMonth,
  BillingDocumentDateYear,
  BillingDocDateYearQuarter,
  BillingDocDateYearMonth,
  SoldToParty,
  Customer,
  SoldToPartyClassification,
  ShipToParty,
  BillToParty,
  PayerParty,
  SalesEmployee,
  ResponsibleEmployee,
  PartnerCompany,
  PurchaseOrderByCustomer,
  CustomerGroup,
  SalesDistrict,
  Country,
  Region,
  CityCode,
  County_2,
  CreditControlArea,
  CustomerRebateAgreement,
  SalesGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  SDDocumentReason,
  RetailPromotion,
  VolumeRebateGroup,
  ItemIsRelevantForCredit,
  SalesDeal,
  SalesDealDescription,
  SalesPromotion,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  Division,
  SalesOffice,
  Material,
  Product,
  InternationalArticleNumber,
  PricingReferenceMaterial,
  Batch,
  ProductHierarchyNode,
  MaterialGroup,
  ProductGroup,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  MaterialCommissionGroup,
  Plant,
  StorageLocation,
  BillingDocumentDate,
  BillingDocumentIsCancelled,
  CancelledBillingDocument,
  ForeignTrade,
  IsExportDelivery,
  BillingDocCombinationCriteria,
  ManualInvoiceMaintIsRelevant,
  BillingDocumentItemText,
  ServicesRenderedDate,
  BillingQuantityUnit,
  BaseUnit,
  ItemWeightUnit,
  ItemVolumeUnit,
  BillingToBaseQuantityDnmntr,
  BillingToBaseQuantityNmrtr,
  BillToPartyCountry,
  BillToPartyRegion,
  BillingPlanRule,
  BillingPlan,
  BillingPlanItem,
  CustomerPriceGroup,
  PriceListType,
  TaxDepartureCountry,
  VATRegistration,
  VATRegistrationOrigin,
  VATRegistrationCountry,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  SDPricingProcedure,
  PricingDate,
  ShippingCondition,
  IncotermsClassification,
  IncotermsTransferLocation,
  ShippingPoint,
  ContractAccount,
  CustomerPaymentTerms,
  PaymentMethod,
  PaymentReference,
  FixedValueDate,
  AdditionalValueDays,
  _CustomerProject.EngagementProjectName AS EngagementProjectName,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  FiscalPeriod,
  CustomerAccountAssignmentGroup,
  AccountingExchangeRateIsSet,
  ExchangeRateType,
  DocumentReferenceID,
  AssignmentReference,
  DunningArea,
  DunningBlockingReason,
  DunningKey,
  InternalFinancialDocument,
  BusinessArea,
  ProfitCenter,
  WBSElement,
  WBSElementInternalID,
  WBSElementExternalID,
  ProfitabilitySegment,
  ProfitabilitySegment_2,
  OrderID,
  CostCenter,
  OriginSDDocument,
  OriginSDDocumentItem,
  ExchangeRateDate,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  SalesDocument,
  SalesDocumentItem,
  SalesSDDocumentCategory,
  HigherLevelItem,
  BillingDocumentItemInPartSgmt,
  MainItemPricingRefMaterial,
  PropagatePrftbltySgmt2BOM,
  CostDeterminationIsRequired,
  OverallSDProcessStatus,
  OverallBillingStatus,
  AccountingPostingStatus,
  AccountingTransferStatus,
  BillingIssueType,
  InvoiceListStatus,
  OvrlItmGeneralIncompletionSts,
  OverallPricingIncompletionSts
FROM I_BillingDocumentItemCube
;