P_SalesVolume

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 P_SalesVolume.
-- 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: PSDSLSVOL

CREATE VIEW P_SalesVolume AS
SELECT
  BillgDocItmBsc.BillingDocument AS SDDocument,
  BillgDocItmBsc.BillingDocumentItem AS SDDocumentItem,
  BillingDocumentDate AS DocumentDate,
  BillingDocumentType,
  cast(BillingDocumentDate as sales_performance_date) AS SalesPerformanceDate,
  cast(CalDte.YearMonth as sales_perf_date_year_month) AS SalesPerformanceYearMonth,
  cast(CalDte.YearQuarter as sales_perf_date_year_quarter) AS SlsPerformanceYearQuarter,
  cast(CalDte.CalendarYear as sales_performance_date_year) AS SalesPerformanceYear,
  SlsPln.SalesPlanUUID AS SalesPlanUUID,
  SlsPln.SalesPlan AS SalesPlan,
  SlsPln.SalesPlanVersion AS SalesPlanVersion,
  SlsPln.CreatedByUser AS CreatedByUser,
  SlsPln.SalesPlanPurpose AS SalesPlanPurpose,
  BillgDocItmBsc.SalesOrganization AS SalesOrganization,
  BillgDocItmBsc.DistributionChannel AS DistributionChannel,
  BillgDocItmBsc.Division AS OrganizationDivision,
  BillgDocItmBsc.SalesOffice AS SalesOffice,
  BillgDocItmBsc.SalesGroup AS SalesGroup,
  BillgDocItmBsc.SalesDistrict AS SalesDistrict,
  BillgDocItmBsc.SoldToParty AS Customer,
  BillgDocItmBsc.CustomerGroup AS CustomerGroup,
  cast( case when ShipToParty.Customer is null then '' else ShipToParty.Customer end as kunwe) as ShipToParty AS CustomerendaskunweasShipToParty,
  cast( case when BillToParty.Customer is null then '' else BillToParty.Customer end as kunre) as BillToParty AS CustomerendaskunreasBillToParty,
  cast( case when PayerParty.Customer is null then '' else PayerParty.Customer end as kunrg) as PayerParty AS CustomerendaskunrgasPayerParty,
  BillgDocItmBsc.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  BillgDocItmBsc.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  BillgDocItmBsc.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  BillgDocItmBsc.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  BillgDocItmBsc.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  BillgDocItmBsc.Division AS Division,
  BillgDocItmBsc.Material AS Material,
  BillgDocItmBsc.Product AS Product,
  BillgDocItmBsc.MaterialGroup AS MaterialGroup,
  BillgDocItmBsc.ProductGroup AS ProductGroup,
  BillgDocItmBsc.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  BillgDocItmBsc.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  BillgDocItmBsc.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  BillgDocItmBsc.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  BillgDocItmBsc.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  cast( SalesEmployee.Personnel as sales_empl ) AS SalesEmployee,
  BillgDocItmBsc.Plant AS Plant,
  cast( '' as vsarttr ) AS ShippingType,
  BillgDocItmBsc.ProfitCenter AS ProfitCenter,
  BillgDocItmBsc.CostCenter AS CostCenter,
  BillgDocItmBsc.CompanyCode AS CompanyCode,
  BillgDocItmBsc.ControllingArea AS ControllingArea,
  BillgDocItmBsc.BusinessArea AS BusinessArea,
  BillgDocItmBsc.Country AS Country,
  BillgDocItmBsc.BillToPartyCountry AS BillToPartyCountry,
  BillgDocItmBsc.Region AS Region,
  BillgDocItmBsc.BillToPartyRegion AS BillToPartyRegion,
  BillgDocItmBsc.TransactionCurrency AS TransactionCurrency,
  BaseUnit,
  BillingQuantityUnit
FROM I_BillingDocExtdItemBasic AS BillgDocItmBsc
;