C_SupDmndTotPOQuery

DDL: C_SUPDMNDTOTPOQUERY Type: view CONSUMPTION Package: VDM_ARUN_ANALYTICS
75 Fields 1 Data Sources

Query View for Total Supply

C_SupDmndTotPOQuery is a Consumption CDS View that provides data about "Query View for Total Supply" in SAP S/4HANA. It reads from 1 data source (I_SupDmndOvwTotalSupplyCube) and exposes 75 fields with key fields Material, Plant, StorageLocation, Batch, SupplyNumber. Part of development package VDM_ARUN_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_SupDmndOvwTotalSupplyCube I_SupDmndOvwTotalSupplyCube from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CSDOSUPPOQRY view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Analytics.query true view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Query View for Total Supply view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.ignorePropagatedAnnotations true view
OData.publish true view

Fields (75)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY StorageLocation StorageLocation StorageLocation
KEY Batch Batch Lot No.
KEY SupplyNumber SupplyNumber
KEY SupplyItem SupplyItem
KEY SupplyScheduleLine SupplyScheduleLine
KEY AssignedSupplyType AssignedSupplyType
TotalQuantity TotalQuantity Total Supply Quantity
OpenSupplyQuantity OpenSupplyQuantity Open Supply Quantity
SupplyDeliveryDate SupplyDeliveryDate
StockSegment StockSegment Stock Segment
MaterialGroup MaterialGroup Product Group
BaseUnit BaseUnit Unit of Measure
AssignedSupplyTypeName AssignedSupplyTypeName Supply Source
FreeDefinedProductAttribute01 FreeDefinedProductAttribute01
FreeDefinedProductAttribute02 FreeDefinedProductAttribute02
FreeDefinedProductAttribute03 FreeDefinedProductAttribute03
RetailArticleColor RetailArticleColor
RetailArticleMainSize RetailArticleMainSize
RetailArticleSecondSize RetailArticleSecondSize
RoughGoodsReceiptQty RoughGoodsReceiptQty Goods Received Quantity
ProductCharacteristic1 ProductCharacteristic1 Characteristic 1
ProductCharacteristic2 ProductCharacteristic2 Characteristic 2
ProductCharacteristic3 ProductCharacteristic3 Characteristic 3
CompanyCode CompanyCode Receiver Company Code
NetPriceAmount NetPriceAmount Net Price
NetPriceQuantity NetPriceQuantity Price Unit
NetAmount NetAmount Stated Amount
Customer Customer Sold-to Party
ItemIsRejectedBySupplier ItemIsRejectedBySupplier Rejection Ind.
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
CrossPlantConfigurableProduct CrossPlantConfigurableProduct Cross-plant CP
PurchasingOrderReason PurchasingOrderReason Reason for Ord.
OrderType OrderType Order Type
PaymentTerms PaymentTerms Pyt Terms
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
DocumentCurrency DocumentCurrency Document Currency
SupplyingPlant SupplyingPlant Supplying Plant
Supplier Supplier Supplier
DeliveryDocument DeliveryDocument Outbound Delivery
ProductSeason ProductSeason Season
ProductSeasonYear ProductSeasonYear Season Year
ProductCollection ProductCollection Collection
ProductTheme ProductTheme Theme
InventorySpecialStockType InventorySpecialStockType Special Stock Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
ItemQuantity ItemQuantity
MfgOrderItemGoodsReceiptQty MfgOrderItemGoodsReceiptQty
MfgOrderItemActualDeviationQty MfgOrderItemActualDeviationQty
MfgOrderItemPlannedScrapQty MfgOrderItemPlannedScrapQty
DeliveredQuantity DeliveredQuantity Qty. in OPUn
CalendarMonth CalendarMonth Calendar Month
CalendarWeek CalendarWeek Calendar Week
CalendarYear CalendarYear Year
CalendarMonthName CalendarMonthName
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit Total 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
SupAssgmtCategory SupAssgmtCategory
SupAssgmtCategoryName SupAssgmtCategoryName
ShippingGroupRule ShippingGroupRule PSST Grouping Rule
ShippingGroupNumber ShippingGroupNumber PSST Group
PurchasingDocument SupplyNumber

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_SupDmndTotPOQuery.
-- 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_SupDmndTotPOQuery AS
SELECT
  Material,
  Plant,
  StorageLocation,
  Batch,
  SupplyNumber,
  SupplyItem,
  SupplyScheduleLine,
  AssignedSupplyType,
  TotalQuantity,
  OpenSupplyQuantity,
  SupplyDeliveryDate,
  StockSegment,
  MaterialGroup,
  BaseUnit,
  AssignedSupplyTypeName,
  FreeDefinedProductAttribute01,
  FreeDefinedProductAttribute02,
  FreeDefinedProductAttribute03,
  RetailArticleColor,
  RetailArticleMainSize,
  RetailArticleSecondSize,
  RoughGoodsReceiptQty,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  CompanyCode,
  NetPriceAmount,
  NetPriceQuantity,
  NetAmount,
  Customer,
  ItemIsRejectedBySupplier,
  PurchasingDocumentCategory,
  CrossPlantConfigurableProduct,
  PurchasingOrderReason,
  OrderType,
  PaymentTerms,
  PurchasingOrganization,
  PurchasingGroup,
  DocumentCurrency,
  SupplyingPlant,
  Supplier,
  DeliveryDocument,
  ProductSeason,
  ProductSeasonYear,
  ProductCollection,
  ProductTheme,
  InventorySpecialStockType,
  SalesOrder,
  SalesOrderItem,
  ItemQuantity,
  MfgOrderItemGoodsReceiptQty,
  MfgOrderItemActualDeviationQty,
  MfgOrderItemPlannedScrapQty,
  DeliveredQuantity,
  CalendarMonth,
  CalendarWeek,
  CalendarYear,
  CalendarMonthName,
  AssignedQuantityInBaseUnit,
  NormalAssignedQuantityInBsUnt,
  FixedQuantityInBaseUnit,
  SupAssgmtReservedQtyInBaseUnit,
  OnHoldQuantityInBaseUnit,
  ReadyForReleaseQtyInBaseUnit,
  InboundAssignedQuantityInBsUnt,
  PreviewFixedAssignedQtyInBsUnt,
  PreviewReservedAssgdQtyInBsUnt,
  PreviewOnHoldAssgdQtyInBsUnt,
  PreviewRdyForReleaseQtyInBsUnt,
  PreviewAssignedQuantityInBsUnt,
  SupAssgmtCategory,
  SupAssgmtCategoryName,
  ShippingGroupRule,
  ShippingGroupNumber,
  SupplyNumber AS PurchasingDocument
FROM I_SupDmndOvwTotalSupplyCube
;

Learn More