P_SupDmndAllDocPlndOrdComp

DDL: P_SUPDMNDALLDOCPLNDORDCOMP Type: view COMPOSITE
27 Fields 1 Data Sources

P_SupDmndAllDocPlndOrdComp is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SupDmndAllDocPlndOrdComp) and exposes 27 fields.

Data Sources (1)

SourceAliasJoin Type
I_SupDmndAllDocPlndOrdComp _SupDmndAllDocPlndPrdComp from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSUPDMNDADCMP4 view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view

Fields (27)

KeyFieldSource TableSource FieldDescription
RequirementDocumentNumber I_SupDmndAllDocPlndOrdComp RequirementDocumentNumber Reservation
RequirementDocumentItem I_SupDmndAllDocPlndOrdComp RequirementDocumentItem
RequirementType I_SupDmndAllDocPlndOrdComp RequirementType RequirementType
RequestedDate I_SupDmndAllDocPlndOrdComp RequestedDate Reqmts date
ProductAvailabilityDate I_SupDmndAllDocPlndOrdComp ProductAvailabilityDate Mat.Avail.Date
RequestedRqmtQtyInBaseUnit I_SupDmndAllDocPlndOrdComp RequestedRqmtQtyInBaseUnit Threshold value
ConfirmedRqmtQtyInBaseUnit I_SupDmndAllDocPlndOrdComp ConfirmedRqmtQtyInBaseUnit Threshold value
DeliveredQuantityInBaseUnit I_SupDmndAllDocPlndOrdComp DeliveredQuantityInBaseUnit
OpenDemandQuantity
AssignedQuantityInBaseUnit I_SupDmndAllDocPlndOrdComp AssignedQuantityInBaseUnit
NormalAssignedQuantityInBsUnt I_SupDmndAllDocPlndOrdComp NormalAssignedQuantityInBsUnt
PreviewAssignedQuantityInBsUnt I_SupDmndAllDocPlndOrdComp PreviewAssignedQuantityInBsUnt
WithdrawnQuantity I_SupDmndAllDocPlndOrdComp WithdrawnQuantity Withdrawn Quantity
OpenQuantity I_SupDmndAllDocPlndOrdComp OpenQuantity PBE Entry Open Qty
BaseUnit I_SupDmndAllDocPlndOrdComp BaseUnit Unit of Measure
Material I_SupDmndAllDocPlndOrdComp Material Vehicle Model
MaterialGroup I_SupDmndAllDocPlndOrdComp MaterialGroup Product Group
Plant I_SupDmndAllDocPlndOrdComp Plant Valuation Area
OrderType I_SupDmndAllDocPlndOrdComp OrderType Order Type
CrossPlantConfigurableProduct I_SupDmndAllDocPlndOrdComp CrossPlantConfigurableProduct Cross-plant CP
MaterialType I_SupDmndAllDocPlndOrdComp MaterialType Material Type
RequirementSegment I_SupDmndAllDocPlndOrdComp RequirementSegment Req. Segment
StorageLocation I_SupDmndAllDocPlndOrdComp StorageLocation StorageLocation
SalesOrder I_SupDmndAllDocPlndOrdComp SalesOrder SD Document
SalesOrderItem I_SupDmndAllDocPlndOrdComp SalesOrderItem Sales Order Item
SegmentationStrategy I_SupDmndAllDocPlndOrdComp SegmentationStrategy
SegmentationStrategyScope I_SupDmndAllDocPlndOrdComp SegmentationStrategyScope

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 P_SupDmndAllDocPlndOrdComp.
-- 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 P_SupDmndAllDocPlndOrdComp AS
SELECT
  _SupDmndAllDocPlndPrdComp.RequirementDocumentNumber AS RequirementDocumentNumber,
  _SupDmndAllDocPlndPrdComp.RequirementDocumentItem AS RequirementDocumentItem,
  _SupDmndAllDocPlndPrdComp.RequirementType AS RequirementType,
  _SupDmndAllDocPlndPrdComp.RequestedDate AS RequestedDate,
  _SupDmndAllDocPlndPrdComp.ProductAvailabilityDate AS ProductAvailabilityDate,
  _SupDmndAllDocPlndPrdComp.RequestedRqmtQtyInBaseUnit AS RequestedRqmtQtyInBaseUnit,
  _SupDmndAllDocPlndPrdComp.ConfirmedRqmtQtyInBaseUnit AS ConfirmedRqmtQtyInBaseUnit,
  _SupDmndAllDocPlndPrdComp.DeliveredQuantityInBaseUnit AS DeliveredQuantityInBaseUnit,
  ( _SupDmndAllDocPlndPrdComp.OpenDemandQuantity - coalesce( _ARunAssgmtDmnd.AssignedQuantityInBaseUnit , 0 ) ) AS OpenDemandQuantity,
  _SupDmndAllDocPlndPrdComp.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
  _SupDmndAllDocPlndPrdComp.NormalAssignedQuantityInBsUnt AS NormalAssignedQuantityInBsUnt,
  _SupDmndAllDocPlndPrdComp.PreviewAssignedQuantityInBsUnt AS PreviewAssignedQuantityInBsUnt,
  _SupDmndAllDocPlndPrdComp.WithdrawnQuantity AS WithdrawnQuantity,
  _SupDmndAllDocPlndPrdComp.OpenQuantity AS OpenQuantity,
  _SupDmndAllDocPlndPrdComp.BaseUnit AS BaseUnit,
  _SupDmndAllDocPlndPrdComp.Material AS Material,
  _SupDmndAllDocPlndPrdComp.MaterialGroup AS MaterialGroup,
  _SupDmndAllDocPlndPrdComp.Plant AS Plant,
  _SupDmndAllDocPlndPrdComp.OrderType AS OrderType,
  _SupDmndAllDocPlndPrdComp.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  _SupDmndAllDocPlndPrdComp.MaterialType AS MaterialType,
  _SupDmndAllDocPlndPrdComp.RequirementSegment AS RequirementSegment,
  _SupDmndAllDocPlndPrdComp.StorageLocation AS StorageLocation,
  _SupDmndAllDocPlndPrdComp.SalesOrder AS SalesOrder,
  _SupDmndAllDocPlndPrdComp.SalesOrderItem AS SalesOrderItem,
  _SupDmndAllDocPlndPrdComp.SegmentationStrategy AS SegmentationStrategy,
  _SupDmndAllDocPlndPrdComp.SegmentationStrategyScope AS SegmentationStrategyScope
FROM I_SupDmndAllDocPlndOrdComp AS _SupDmndAllDocPlndPrdComp
;

Learn More