C_BillgDocSlsVolumeBySalesArea

DDL: C_BILLGDOCSLSVOLUMEBYSALESAREA Type: view CONSUMPTION Package: ODATA_SD_CUSTOMER360
11 Fields 1 Data Sources 1 OData Services

Sales Volume by Sales Area

C_BillgDocSlsVolumeBySalesArea is a Consumption CDS View that provides data about "Sales Volume by Sales Area" in SAP S/4HANA. It reads from 1 data source (P_BillgDocSlsVolumeBySalesArea) and exposes 11 fields with key fields BillingDocument, BillingDocumentItem. It is exposed through 1 OData service (ASQL_F4645). Part of development package ODATA_SD_CUSTOMER360.

Data Sources (1)

SourceAliasJoin Type
P_BillgDocSlsVolumeBySalesArea _BillgDocSlsVolume from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CSLSVLSLSAREA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Volume by Sales Area view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4645 ASQL_F4645 C2 NOT_RELEASED

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument BillingDocument SD Document
KEY BillingDocumentItem BillingDocumentItem Item
SalesOrganization P_BillgDocSlsVolumeBySalesArea SalesOrganization Sales Organization
DistributionChannel P_BillgDocSlsVolumeBySalesArea DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_BillgDocSlsVolumeBySalesArea OrganizationDivision Org. Division
TransactionCurrency TransactionCurrency Transaction Currency
DisplayCurrency
SoldToParty SoldToParty Sold-to Party
SalesOffice P_BillgDocSlsVolumeBySalesArea SalesOffice Sales Office
SalesGroup P_BillgDocSlsVolumeBySalesArea SalesGroup Sales Group
BillingDocumentType BillingDocumentType Billing Type

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_BillgDocSlsVolumeBySalesArea.
-- 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.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW C_BillgDocSlsVolumeBySalesArea AS
SELECT
  BillingDocument,
  BillingDocumentItem,
  _BillgDocSlsVolume.SalesOrganization AS SalesOrganization,
  _BillgDocSlsVolume.DistributionChannel AS DistributionChannel,
  _BillgDocSlsVolume.OrganizationDivision AS OrganizationDivision,
  TransactionCurrency,
  :P_DisplayCurrency AS DisplayCurrency,
  SoldToParty,
  _BillgDocSlsVolume.SalesOffice AS SalesOffice,
  _BillgDocSlsVolume.SalesGroup AS SalesGroup,
  BillingDocumentType
FROM P_BillgDocSlsVolumeBySalesArea AS _BillgDocSlsVolume
;

Learn More