C_SupDmndOvwQuery

DDL: C_SUPDMNDOVWQUERY Type: view CONSUMPTION Package: VDM_ARUN_ANALYTICS
67 Fields 1 Data Sources

Query View for Supply Demand Overview

C_SupDmndOvwQuery is a Consumption CDS View that provides data about "Query View for Supply Demand Overview" in SAP S/4HANA. It reads from 1 data source (I_SupDmndOvwCube) and exposes 67 fields with key fields RequirementDocumentNumber, RequirementDocumentItem, ProductAvailabilityDate, RequirementType, SupplyNumber. Part of development package VDM_ARUN_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_SupDmndOvwCube Ovw from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSDODMNDOVWQUERY view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Query View for Supply Demand Overview view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY RequirementDocumentNumber RequirementDocumentNumber
KEY RequirementDocumentItem RequirementDocumentItem
KEY ProductAvailabilityDate ProductAvailabilityDate Delivery Date
KEY RequirementType RequirementType RequirementType
KEY SupplyNumber SupplyNumber
KEY SupplyItem SupplyItem
KEY AssignedSupplyType AssignedSupplyType
KEY Material I_SupDmndOvwCube Material Vehicle Model
KEY Plant I_SupDmndOvwCube Plant Valuation Area
KEY Batch Batch Batch
KEY StorageLocation StorageLocation StorageLocation
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit Delivered Quantity
RequestedRqmtQtyInBaseUnit RequestedRqmtQtyInBaseUnit Order Quantity
ConfirmedRqmtQtyInBaseUnit ConfirmedRqmtQtyInBaseUnit Confirmed Quantity
OpenDemandQuantity OpenDemandQuantity Open Demand Quantity
SalesOrganization I_SupDmndOvwCube SalesOrganization Sales Organization
DistributionChannel I_SupDmndOvwCube DistributionChannel RefDistCh-Cust/Mat.
CompanyCode I_SupDmndOvwCube CompanyCode Receiver Company Code
Division I_SupDmndOvwCube Division Internal Division ID
MaterialGroup I_SupDmndOvwCube MaterialGroup Product Group
BaseUnit BaseUnit Unit of Measure
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 I_SupDmndOvwCube SalesDistrict Sales District
CalendarMonth CalendarMonth Month
CalendarWeek CalendarWeek Week
CalendarYear CalendarYear Year
CalendarMonthName CalendarMonthName Month
CrossPlantConfigurableProduct CrossPlantConfigurableProduct Cross-plant CP
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit Assigned Quantity
NormalAssignedQuantityInBsUnt NormalAssignedQuantityInBsUnt Normal Assigned Quantity
FixedQuantityInBaseUnit FixedQuantityInBaseUnit Ready for Delivery Quantity
SupAssgmtReservedQtyInBaseUnit SupAssgmtReservedQtyInBaseUnit Reserved Quantity
OnHoldQuantityInBaseUnit OnHoldQuantityInBaseUnit On Hold Quantity
ReadyForReleaseQtyInBaseUnit ReadyForReleaseQtyInBaseUnit Open for Release Check Quantity
InboundAssignedQuantityInBsUnt InboundAssignedQuantityInBsUnt IFO Assigned Quantity
PreviewFixedAssignedQtyInBsUnt PreviewFixedAssignedQtyInBsUnt Ready for Delivery (Preview)
PreviewReservedAssgdQtyInBsUnt PreviewReservedAssgdQtyInBsUnt Reserved (Preview)
PreviewOnHoldAssgdQtyInBsUnt PreviewOnHoldAssgdQtyInBsUnt On Hold (Preview)
PreviewRdyForReleaseQtyInBsUnt PreviewRdyForReleaseQtyInBsUnt Open for Release Check (Preview)
PreviewAssignedQuantityInBsUnt PreviewAssignedQuantityInBsUnt Preview Assigned Quantity
OpenSupplyQuantity OpenSupplyQuantity Open Supply Quantity
AssignedSupplyQtyInBaseUnit AssignedSupplyQtyInBaseUnit Total Assigned Quantity(Supply)
NormalSupplyQtyInBaseUnit NormalSupplyQtyInBaseUnit Normal Assigned Quantity(Supply)
PreviewSupplyQtyInBaseUnit PreviewSupplyQtyInBaseUnit Preview Assigned Quantity(Supply)
SupAssgmtCategory SupAssgmtCategory Demand/Supply View
SupAssgmtCategoryName SupAssgmtCategoryName Demand/Supply View
SupAssgmtSource SupAssgmtSource SDO Source
SupAssgmtSourceName SupAssgmtSourceName SDO Source
SalesOrganizationName SalesOrganizationName Sales Organization Description
MaterialName MaterialName Material Description
MaterialGroupName MaterialGroupName prod Grp Desc.
DistributionChannelName DistributionChannelName
DivisionName DivisionName Division Description
SalesDistrictName SalesDistrictName
PlantName PlantName Plant Name
CompanyCodeName CompanyCodeName Company Name
NetPriceAmount NetPriceAmount Net Price
DocumentCurrency DocumentCurrency Document Currency

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_SupDmndOvwQuery.
-- 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_SupDmndOvwQuery AS
SELECT
  RequirementDocumentNumber,
  RequirementDocumentItem,
  ProductAvailabilityDate,
  RequirementType,
  SupplyNumber,
  SupplyItem,
  AssignedSupplyType,
  Ovw.Material AS Material,
  Ovw.Plant AS Plant,
  Batch,
  StorageLocation,
  RequestedDeliveryDate,
  DeliveredQuantityInBaseUnit,
  RequestedRqmtQtyInBaseUnit,
  ConfirmedRqmtQtyInBaseUnit,
  OpenDemandQuantity,
  Ovw.SalesOrganization AS SalesOrganization,
  Ovw.DistributionChannel AS DistributionChannel,
  Ovw.CompanyCode AS CompanyCode,
  Ovw.Division AS Division,
  Ovw.MaterialGroup AS MaterialGroup,
  BaseUnit,
  ShippingPoint,
  RequirementSegment,
  StockSegment,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  ShippingGroupRule,
  ShippingGroupNumber,
  Ovw.SalesDistrict AS SalesDistrict,
  CalendarMonth,
  CalendarWeek,
  CalendarYear,
  CalendarMonthName,
  CrossPlantConfigurableProduct,
  AssignedQuantityInBaseUnit,
  NormalAssignedQuantityInBsUnt,
  FixedQuantityInBaseUnit,
  SupAssgmtReservedQtyInBaseUnit,
  OnHoldQuantityInBaseUnit,
  ReadyForReleaseQtyInBaseUnit,
  InboundAssignedQuantityInBsUnt,
  PreviewFixedAssignedQtyInBsUnt,
  PreviewReservedAssgdQtyInBsUnt,
  PreviewOnHoldAssgdQtyInBsUnt,
  PreviewRdyForReleaseQtyInBsUnt,
  PreviewAssignedQuantityInBsUnt,
  OpenSupplyQuantity,
  AssignedSupplyQtyInBaseUnit,
  NormalSupplyQtyInBaseUnit,
  PreviewSupplyQtyInBaseUnit,
  SupAssgmtCategory,
  SupAssgmtCategoryName,
  SupAssgmtSource,
  SupAssgmtSourceName,
  SalesOrganizationName,
  MaterialName,
  MaterialGroupName,
  DistributionChannelName,
  DivisionName,
  SalesDistrictName,
  PlantName,
  CompanyCodeName,
  NetPriceAmount,
  DocumentCurrency
FROM I_SupDmndOvwCube AS Ovw
;

Learn More