P_SupDmndAllDocRetsSup

DDL: P_SUPDMNDALLDOCRETSSUP Type: view COMPOSITE Package: VDM_ARUN_ANALYTICS_ALL
29 Fields 1 Data Sources

View for Return PO

P_SupDmndAllDocRetsSup is a Composite CDS View that provides data about "View for Return PO" in SAP S/4HANA. It reads from 1 data source (I_SupDmndAllDocRetsSup) and exposes 29 fields. Part of development package VDM_ARUN_ANALYTICS_ALL.

Data Sources (1)

SourceAliasJoin Type
I_SupDmndAllDocRetsSup _SupDmndAllDocRetsSup from

Annotations (9)

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

Fields (29)

KeyFieldSource TableSource FieldDescription
RequirementDocumentNumber I_SupDmndAllDocRetsSup RequirementDocumentNumber Source PurchDoc
RequirementDocumentItem I_SupDmndAllDocRetsSup RequirementDocumentItem
RequirementType I_SupDmndAllDocRetsSup RequirementType RequirementType
RequestedDate I_SupDmndAllDocRetsSup RequestedDate
ProductAvailabilityDate I_SupDmndAllDocRetsSup ProductAvailabilityDate Mat.Avail.Date
RequestedDeliveryDate I_SupDmndAllDocRetsSup RequestedDeliveryDate Requested Delivery Date
RequestedRqmtQtyInBaseUnit I_SupDmndAllDocRetsSup RequestedRqmtQtyInBaseUnit
ConfirmedRqmtQtyInBaseUnit I_SupDmndAllDocRetsSup ConfirmedRqmtQtyInBaseUnit
DeliveredQuantityInBaseUnit I_SupDmndAllDocRetsSup DeliveredQuantityInBaseUnit
OpenDemandQuantity
AssignedQuantityInBaseUnit I_SupDmndAllDocRetsSup AssignedQuantityInBaseUnit
NormalAssignedQuantityInBsUnt I_SupDmndAllDocRetsSup NormalAssignedQuantityInBsUnt
PreviewAssignedQuantityInBsUnt I_SupDmndAllDocRetsSup PreviewAssignedQuantityInBsUnt
BaseUnit I_SupDmndAllDocRetsSup BaseUnit Unit of Measure
Material I_SupDmndAllDocRetsSup Material Vehicle Model
MaterialGroup I_SupDmndAllDocRetsSup MaterialGroup Product Group
Plant I_SupDmndAllDocRetsSup Plant Valuation Area
OrderType I_SupDmndAllDocRetsSup OrderType Order Type
MaterialType I_SupDmndAllDocRetsSup MaterialType Material Type
RequirementSegment I_SupDmndAllDocRetsSup RequirementSegment Req. Segment
PurchasingOrganization I_SupDmndAllDocRetsSup PurchasingOrganization Purchasing Organization
PurchasingGroup I_SupDmndAllDocRetsSup PurchasingGroup Purchasing Group
CompanyCode I_SupDmndAllDocRetsSup CompanyCode Receiver Company Code
StorageLocation I_SupDmndAllDocRetsSup StorageLocation StorageLocation
PurgReleaseSequenceStatus I_SupDmndAllDocRetsSup PurgReleaseSequenceStatus Release State
NetPriceAmount I_SupDmndAllDocRetsSup NetPriceAmount Net Price
DocumentCurrency I_SupDmndAllDocRetsSup DocumentCurrency Document Currency
SegmentationStrategy I_SupDmndAllDocRetsSup SegmentationStrategy
SegmentationStrategyScope I_SupDmndAllDocRetsSup 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_SupDmndAllDocRetsSup.
-- 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_SupDmndAllDocRetsSup AS
SELECT
  _SupDmndAllDocRetsSup.RequirementDocumentNumber AS RequirementDocumentNumber,
  _SupDmndAllDocRetsSup.RequirementDocumentItem AS RequirementDocumentItem,
  _SupDmndAllDocRetsSup.RequirementType AS RequirementType,
  _SupDmndAllDocRetsSup.RequestedDate AS RequestedDate,
  _SupDmndAllDocRetsSup.ProductAvailabilityDate AS ProductAvailabilityDate,
  _SupDmndAllDocRetsSup.RequestedDeliveryDate AS RequestedDeliveryDate,
  _SupDmndAllDocRetsSup.RequestedRqmtQtyInBaseUnit AS RequestedRqmtQtyInBaseUnit,
  _SupDmndAllDocRetsSup.ConfirmedRqmtQtyInBaseUnit AS ConfirmedRqmtQtyInBaseUnit,
  _SupDmndAllDocRetsSup.DeliveredQuantityInBaseUnit AS DeliveredQuantityInBaseUnit,
  ( _SupDmndAllDocRetsSup.OpenDemandQuantity - coalesce( _ARunAssgmtDmnd.AssignedQuantityInBaseUnit , 0 ) ) AS OpenDemandQuantity,
  _SupDmndAllDocRetsSup.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
  _SupDmndAllDocRetsSup.NormalAssignedQuantityInBsUnt AS NormalAssignedQuantityInBsUnt,
  _SupDmndAllDocRetsSup.PreviewAssignedQuantityInBsUnt AS PreviewAssignedQuantityInBsUnt,
  _SupDmndAllDocRetsSup.BaseUnit AS BaseUnit,
  _SupDmndAllDocRetsSup.Material AS Material,
  _SupDmndAllDocRetsSup.MaterialGroup AS MaterialGroup,
  _SupDmndAllDocRetsSup.Plant AS Plant,
  _SupDmndAllDocRetsSup.OrderType AS OrderType,
  _SupDmndAllDocRetsSup.MaterialType AS MaterialType,
  _SupDmndAllDocRetsSup.RequirementSegment AS RequirementSegment,
  _SupDmndAllDocRetsSup.PurchasingOrganization AS PurchasingOrganization,
  _SupDmndAllDocRetsSup.PurchasingGroup AS PurchasingGroup,
  _SupDmndAllDocRetsSup.CompanyCode AS CompanyCode,
  _SupDmndAllDocRetsSup.StorageLocation AS StorageLocation,
  _SupDmndAllDocRetsSup.PurgReleaseSequenceStatus AS PurgReleaseSequenceStatus,
  _SupDmndAllDocRetsSup.NetPriceAmount AS NetPriceAmount,
  _SupDmndAllDocRetsSup.DocumentCurrency AS DocumentCurrency,
  _SupDmndAllDocRetsSup.SegmentationStrategy AS SegmentationStrategy,
  _SupDmndAllDocRetsSup.SegmentationStrategyScope AS SegmentationStrategyScope
FROM I_SupDmndAllDocRetsSup AS _SupDmndAllDocRetsSup
;

Learn More