C_SupDmndOvwFltr

DDL: C_SUPDMNDOVWFLTR Type: view CONSUMPTION Package: VDM_ARUN_ANALYTICS

Filters For Supply Demand Overview

C_SupDmndOvwFltr is a Consumption CDS View that provides data about "Filters For Supply Demand Overview" in SAP S/4HANA. Part of development package VDM_ARUN_ANALYTICS.

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CSUPDMNDOVWFLTR view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Filters For Supply Demand Overview view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY RequirementDocumentNumber RequirementDocumentNumber Requirement Document
KEY ProductAvailabilityDate ProductAvailabilityDate Delivery Date
KEY RequirementType RequirementType Requirement Type
KEY SupplyNumber SupplyNumber Supply Document
KEY AssignedSupplyType AssignedSupplyType Supply Type
KEY StorageLocation StorageLocation StorageLocation
KEY Batch Batch Lot No.
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
CompanyCode CompanyCode Company Code
Division Division Internal Division ID
MaterialGroup MaterialGroup Product Group
ShippingPoint ShippingPoint Shipping Point
RequirementSegment RequirementSegment Req. Segment
StockSegment StockSegment Stock Segment
ProductSeasonYear ProductSeasonYear Season Year
ProductSeason ProductSeason Season
ProductCollection ProductCollection Collection
ProductTheme ProductTheme Theme
ShippingGroupRule ShippingGroupRule PSST Grouping Rule
ShippingGroupNumber ShippingGroupNumber PSST Group
SalesDistrict SalesDistrict Sales District
CrossPlantConfigurableProduct CrossPlantConfigurableProduct Generic Product

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_SupDmndOvwFltr.
-- 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.

CREATE VIEW C_SupDmndOvwFltr AS
SELECT
  Material,
  Plant,
  RequirementDocumentNumber,
  ProductAvailabilityDate,
  RequirementType,
  SupplyNumber,
  AssignedSupplyType,
  StorageLocation,
  Batch,
  RequestedDeliveryDate,
  SalesOrganization,
  DistributionChannel,
  CompanyCode,
  Division,
  MaterialGroup,
  ShippingPoint,
  RequirementSegment,
  StockSegment,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  ShippingGroupRule,
  ShippingGroupNumber,
  SalesDistrict,
  CrossPlantConfigurableProduct
;