I_SupDmndAllDocProdnOrd

DDL: I_SUPDMNDALLDOCPRODNORD Type: view COMPOSITE
25 Fields 2 Data Sources

View for Production Order

I_SupDmndAllDocProdnOrd is a Composite CDS View that provides data about "View for Production Order" in SAP S/4HANA. It reads from 2 data sources (P_ARunAssgmtSup, I_SupDmndAllDocProdnOrdBsc) and exposes 25 fields.

Data Sources (2)

SourceAliasJoin Type
P_ARunAssgmtSup Assgmt left_outer
I_SupDmndAllDocProdnOrdBsc ProdOrd from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISUPDMNDADPROD view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
EndUserText.label View for Production Order view

Fields (25)

KeyFieldSource TableSource FieldDescription
SupplyNumber I_SupDmndAllDocProdnOrdBsc SupplyNumber SettlementOrder
SupplyItem I_SupDmndAllDocProdnOrdBsc SupplyItem
MRPArea I_SupDmndAllDocProdnOrdBsc MRPArea MRP Area
SupplyScheduleLine I_SupDmndAllDocProdnOrdBsc SupplyScheduleLine
AssignedSupplyType I_SupDmndAllDocProdnOrdBsc AssignedSupplyType
SupAssgmtSource I_SupDmndAllDocProdnOrdBsc SupAssgmtSource
SupplyDeliveryDate I_SupDmndAllDocProdnOrdBsc SupplyDeliveryDate Basic fin. date
ProductAvailabilityDate I_SupDmndAllDocProdnOrdBsc ProductAvailabilityDate Mat.Avail.Date
TotalQuantity I_SupDmndAllDocProdnOrdBsc TotalQuantity Activity Quantity
OpenSupplyQuantity
AssignedQuantityInBaseUnit P_ARunAssgmtSup AssignedQuantityInBaseUnit
NormalAssignedQuantityInBsUnt P_ARunAssgmtSup NormalAssignedQuantityInBsUnt
PreviewAssignedQuantityInBsUnt P_ARunAssgmtSup PreviewAssignedQuantityInBsUnt
BaseUnit I_SupDmndAllDocProdnOrdBsc BaseUnit Unit of Measure
Material I_SupDmndAllDocProdnOrdBsc Material Vehicle Model
MaterialGroup I_SupDmndAllDocProdnOrdBsc MaterialGroup Product Group
Plant I_SupDmndAllDocProdnOrdBsc Plant Valuation Area
CrossPlantConfigurableProduct I_SupDmndAllDocProdnOrdBsc CrossPlantConfigurableProduct Cross-plant CP
OrderType I_SupDmndAllDocProdnOrdBsc OrderType Order Type
Batch I_SupDmndAllDocProdnOrdBsc Batch Lot No.
StorageLocation I_SupDmndAllDocProdnOrdBsc StorageLocation StorageLocation
SalesOrder I_SupDmndAllDocProdnOrdBsc SalesOrder SD Document
SalesOrderItem I_SupDmndAllDocProdnOrdBsc SalesOrderItem Sales Order Item
StockSegment I_SupDmndAllDocProdnOrdBsc StockSegment Stock Segment
GoodsReceiptDurationInDays I_SupDmndAllDocProdnOrdBsc GoodsReceiptDurationInDays GR proc. time

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 I_SupDmndAllDocProdnOrd.
-- 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 I_SupDmndAllDocProdnOrd AS
SELECT
  ProdOrd.SupplyNumber AS SupplyNumber,
  ProdOrd.SupplyItem AS SupplyItem,
  ProdOrd.MRPArea AS MRPArea,
  ProdOrd.SupplyScheduleLine AS SupplyScheduleLine,
  ProdOrd.AssignedSupplyType AS AssignedSupplyType,
  ProdOrd.SupAssgmtSource AS SupAssgmtSource,
  ProdOrd.SupplyDeliveryDate AS SupplyDeliveryDate,
  ProdOrd.ProductAvailabilityDate AS ProductAvailabilityDate,
  ProdOrd.TotalQuantity AS TotalQuantity,
  ( ProdOrd.OpenSupplyQuantity - coalesce( Assgmt.AssignedQuantityInBaseUnit, 0 ) ) AS OpenSupplyQuantity,
  Assgmt.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
  Assgmt.NormalAssignedQuantityInBsUnt AS NormalAssignedQuantityInBsUnt,
  Assgmt.PreviewAssignedQuantityInBsUnt AS PreviewAssignedQuantityInBsUnt,
  ProdOrd.BaseUnit AS BaseUnit,
  ProdOrd.Material AS Material,
  ProdOrd.MaterialGroup AS MaterialGroup,
  ProdOrd.Plant AS Plant,
  ProdOrd.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  ProdOrd.OrderType AS OrderType,
  ProdOrd.Batch AS Batch,
  ProdOrd.StorageLocation AS StorageLocation,
  ProdOrd.SalesOrder AS SalesOrder,
  ProdOrd.SalesOrderItem AS SalesOrderItem,
  ProdOrd.StockSegment AS StockSegment,
  ProdOrd.GoodsReceiptDurationInDays AS GoodsReceiptDurationInDays
FROM I_SupDmndAllDocProdnOrdBsc AS ProdOrd
LEFT OUTER JOIN P_ARunAssgmtSup AS Assgmt ON /* join condition not captured in parsed metadata */
;

Learn More