C_SupDmndOpenDelivQuery

DDL: C_SUPDMNDOPENDELIVQUERY Type: view CONSUMPTION Package: VDM_ARUN_ANALYTICS

Query View for Total Demand

C_SupDmndOpenDelivQuery is a Consumption CDS View that provides data about "Query View for Total Demand" in SAP S/4HANA. It reads from 8 data sources and exposes 33 fields. Part of development package VDM_ARUN_ANALYTICS.

8 data source(s) 33 fields

Data Sources (8)

SourceAliasJoin Type
I_DistributionChannelText DistChl left_outer
I_DivisionText Div left_outer
I_MaterialText MaterialText left_outer
I_MaterialGroupText MatGrpText left_outer
I_SupDmndOpenDelivCube Ovw from
I_Plant Plant left_outer
I_SalesDistrictText SalesDist left_outer
I_SalesOrganizationText SalesOrgText left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSDODMNDDLVQRY view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
AccessControl.authorizationCheck #NOT_REQUIRED 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 Total Demand view

Fields (33)

KeyFieldSource TableSource FieldDescription
RequirementDocumentNumber RequirementDocumentNumber Preceding Document
RequirementDocumentItem RequirementDocumentItem Preceding Document Item
DeliveryDocument DeliveryDocument
DeliveryDocumentItem DeliveryDocumentItem
SalesDistrict I_SupDmndOpenDelivCube SalesDistrict
ShippingPoint ShippingPoint
SalesOrganization I_SupDmndOpenDelivCube SalesOrganization
DeliveryDocumentType DeliveryDocumentType
HeaderBillingBlockReason HeaderBillingBlockReason
DeliveryBlockReason DeliveryBlockReason
DeliveryPriority DeliveryPriority
ShipToParty ShipToParty
SoldToParty SoldToParty
SalesOffice SalesOffice
Material I_SupDmndOpenDelivCube Material
Plant I_SupDmndOpenDelivCube Plant
StorageLocation StorageLocation
Batch Batch
StockSegment StockSegment
RequirementSegment RequirementSegment
DistributionChannel I_SupDmndOpenDelivCube DistributionChannel
Division I_SupDmndOpenDelivCube Division
MaterialGroup I_SupDmndOpenDelivCube MaterialGroup
ProductAvailabilityDate ProductAvailabilityDate
RequestedDeliveryDate RequestedDeliveryDate
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit Open Delivery Quantities
SalesOrganizationName I_SalesOrganizationText SalesOrganizationName
MaterialName I_MaterialText MaterialName
MaterialGroupName I_MaterialGroupText MaterialGroupName
DistributionChannelName I_DistributionChannelText DistributionChannelName
DivisionName I_DivisionText DivisionName
SalesDistrictName I_SalesDistrictText SalesDistrictName
PlantName I_Plant PlantName 
@AbapCatalog: {
  sqlViewName: 'CSDODMNDDLVQRY',
  compiler.compareFilter: true
}
@ObjectModel:{
  usageType.serviceQuality: #X,
  usageType.sizeCategory: #XXL
  }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
//@Analytics.query: true

@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Query View for Total Demand'
//@OData.publish: true

define view C_SupDmndOpenDelivQuery
  as select from    I_SupDmndOpenDelivCube    as Ovw
    left outer join I_SalesOrganizationText   as SalesOrgText on  Ovw.SalesOrganization = SalesOrgText.SalesOrganization
                                                              and SalesOrgText.Language = $session.system_language
    left outer join I_MaterialText            as MaterialText on  Ovw.Material          = MaterialText.Material
                                                              and MaterialText.Language = $session.system_language
    left outer join I_MaterialGroupText       as MatGrpText   on  Ovw.MaterialGroup     = MatGrpText.MaterialGroup
                                                              and MatGrpText.Language   = $session.system_language
                                                              and MaterialText.Language = $session.system_language
    left outer join I_DistributionChannelText as DistChl      on  Ovw.DistributionChannel = DistChl.DistributionChannel
                                                              and DistChl.Language        = $session.system_language
    left outer join I_DivisionText            as Div          on  Ovw.Division = Div.Division
                                                              and Div.Language = $session.system_language
    left outer join I_SalesDistrictText       as SalesDist    on  Ovw.SalesDistrict       = SalesDist.SalesDistrict
                                                              and SalesDist.Language = $session.system_language
    left outer join I_Plant                   as Plant        on Ovw.Plant = Plant.Plant

{
  @EndUserText.label: 'Preceding Document'
  RequirementDocumentNumber,
  @EndUserText.label: 'Preceding Document Item'
  RequirementDocumentItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  Ovw.SalesDistrict,
  ShippingPoint,
  Ovw.SalesOrganization,
  DeliveryDocumentType,
  HeaderBillingBlockReason,
  DeliveryBlockReason,
  DeliveryPriority,
  ShipToParty,
  SoldToParty,
  SalesOffice,
  Ovw.Material,
  Ovw.Plant,
  StorageLocation,
  Batch,
  @Feature:'SW:RFM_SEGMTN_UI'
  StockSegment,
  @Feature:'SW:RFM_SEGMTN_UI'
  RequirementSegment,
  Ovw.DistributionChannel,
  Ovw.Division,
  Ovw.MaterialGroup,
  ProductAvailabilityDate,
  RequestedDeliveryDate,
  @EndUserText.label: 'Open Delivery Quantities'
  DeliveredQuantityInBaseUnit,
  SalesOrgText.SalesOrganizationName,
  MaterialText.MaterialName,
  MatGrpText.MaterialGroupName,
  DistChl.DistributionChannelName,
  Div.DivisionName,
  SalesDist.SalesDistrictName,
  Plant.PlantName
}

Learn More