C_SupDmndOvwSupAssgmtQuery

DDL: C_SUPDMNDOVWSUPASSGMTQUERY Type: view CONSUMPTION Package: VDM_ARUN_ANALYTICS
51 Fields 7 Data Sources

Consumption view for Assignments

C_SupDmndOvwSupAssgmtQuery is a Consumption CDS View that provides data about "Consumption view for Assignments" in SAP S/4HANA. It reads from 7 data sources and exposes 51 fields with key fields Plant, Material, StorageLocation, Batch, RequirementType. Part of development package VDM_ARUN_ANALYTICS.

Data Sources (7)

SourceAliasJoin Type
I_CompanyCode CompanyCode left_outer
I_DistributionChannelText DistChl left_outer
I_MaterialText MaterialText left_outer
I_MaterialGroupText MatGrpText left_outer
I_SupDmndOvwSupAssgmtCube Ovw from
I_Plant Plant left_outer
I_SalesOrganizationText SalesOrgText left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSDOOVWQUERY view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL 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 Consumption view for Assignments view
AccessControl.authorizationCheck #CHECK view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY Plant I_SupDmndOvwSupAssgmtCube Plant Valuation Area
KEY Material I_SupDmndOvwSupAssgmtCube Material Vehicle Model
KEY StorageLocation StorageLocation StorageLocation
KEY Batch Batch Batch
KEY RequirementType RequirementType Requirement Type
KEY RequirementDocumentNumber RequirementDocumentNumber Requirement Document Number
KEY RequirementDocumentItem RequirementDocumentItem Requirement Document Item
KEY AssignedSupplyType AssignedSupplyType Supply Source
KEY SupplyNumber SupplyNumber Supply Document No.
KEY SupplyItem SupplyItem Supply Document Item
KEY SupplyScheduleLine SupplyScheduleLine Supply Document Schedule Line
KEY RequestedDate RequestedDate Requested Date
KEY ProductAvailabilityDate ProductAvailabilityDate Material Availability Date
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
AssignedDemandTypeName AssignedDemandTypeName Requirement Type
AssignedSupplyTypeName AssignedSupplyTypeName Supply Source
TimeHorizonInDays TimeHorizonInDays Mat. Avail Date - Supply Delivery Date
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit Total Assigned Quantity
NormalAssignedQuantityInBsUnt NormalAssignedQuantityInBsUnt Normal Assigned Quantity
FixedQuantityInBaseUnit FixedQuantityInBaseUnit Ready for Delivery 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
SupplyDeliveryDate SupplyDeliveryDate
RequirementSegment RequirementSegment Req. Segment
StockSegment StockSegment Stock Segment
OrderType OrderType Order Type
SalesOrganization I_SupDmndOvwSupAssgmtCube SalesOrganization Sales Organization
DistributionChannel I_SupDmndOvwSupAssgmtCube DistributionChannel RefDistCh-Cust/Mat.
MaterialGroup I_SupDmndOvwSupAssgmtCube MaterialGroup Product Group
ProductSeasonYear ProductSeasonYear Season Year
ProductSeason ProductSeason Season
ProductCollection ProductCollection Collection
ProductTheme ProductTheme Theme
ShippingGroupRule ShippingGroupRule PSST Grouping Rule
ShippingGroupNumber ShippingGroupNumber PSST Group
CustomerGroup CustomerGroup Customer Group
SalesDistrict SalesDistrict Sales District
CrossPlantConfigurableProduct CrossPlantConfigurableProduct Cross-plant CP
CompanyCode I_SupDmndOvwSupAssgmtCube CompanyCode Company Code
SalesOrganizationName I_SalesOrganizationText SalesOrganizationName Sales Organization Description
MaterialName I_MaterialText MaterialName Material Description
MaterialGroupName I_MaterialGroupText MaterialGroupName prod Grp Desc.
DistributionChannelName I_DistributionChannelText DistributionChannelName
PlantName I_Plant PlantName Plant Name
CompanyCodeName I_CompanyCode CompanyCodeName Company Name

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_SupDmndOvwSupAssgmtQuery.
-- 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_SupDmndOvwSupAssgmtQuery AS
SELECT
  Ovw.Plant AS Plant,
  Ovw.Material AS Material,
  StorageLocation,
  Batch,
  RequirementType,
  RequirementDocumentNumber,
  RequirementDocumentItem,
  AssignedSupplyType,
  SupplyNumber,
  SupplyItem,
  SupplyScheduleLine,
  RequestedDate,
  ProductAvailabilityDate,
  RequestedDeliveryDate,
  AssignedDemandTypeName,
  AssignedSupplyTypeName,
  TimeHorizonInDays,
  AssignedQuantityInBaseUnit,
  NormalAssignedQuantityInBsUnt,
  FixedQuantityInBaseUnit,
  OnHoldQuantityInBaseUnit,
  ReadyForReleaseQtyInBaseUnit,
  InboundAssignedQuantityInBsUnt,
  PreviewFixedAssignedQtyInBsUnt,
  PreviewReservedAssgdQtyInBsUnt,
  PreviewOnHoldAssgdQtyInBsUnt,
  PreviewRdyForReleaseQtyInBsUnt,
  PreviewAssignedQuantityInBsUnt,
  SupplyDeliveryDate,
  RequirementSegment,
  StockSegment,
  OrderType,
  Ovw.SalesOrganization AS SalesOrganization,
  Ovw.DistributionChannel AS DistributionChannel,
  Ovw.MaterialGroup AS MaterialGroup,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  ShippingGroupRule,
  ShippingGroupNumber,
  CustomerGroup,
  SalesDistrict,
  CrossPlantConfigurableProduct,
  Ovw.CompanyCode AS CompanyCode,
  SalesOrgText.SalesOrganizationName AS SalesOrganizationName,
  MaterialText.MaterialName AS MaterialName,
  MatGrpText.MaterialGroupName AS MaterialGroupName,
  DistChl.DistributionChannelName AS DistributionChannelName,
  Plant.PlantName AS PlantName,
  CompanyCode.CompanyCodeName AS CompanyCodeName
FROM I_SupDmndOvwSupAssgmtCube AS Ovw
LEFT OUTER JOIN I_SalesOrganizationText AS SalesOrgText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialText AS MaterialText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialGroupText AS MatGrpText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DistributionChannelText AS DistChl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS Plant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More