P_SupDmndAllDocRetDelivAssgmt

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

View for Returns Delivery

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

Data Sources (1)

SourceAliasJoin Type
I_SupDmndAllDocRetDeliv _SupDmndAllDocRetDeliv from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSUPDMNDRETDELAS 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
SupplyNumber I_SupDmndAllDocRetDeliv SupplyNumber
SupplyItem I_SupDmndAllDocRetDeliv SupplyItem
SupplyScheduleLine I_SupDmndAllDocRetDeliv SupplyScheduleLine
AssignedSupplyType I_SupDmndAllDocRetDeliv AssignedSupplyType
SupAssgmtSource I_SupDmndAllDocRetDeliv SupAssgmtSource
SupplyDeliveryDate I_SupDmndAllDocRetDeliv SupplyDeliveryDate Mat.Avail.Date
ProductAvailabilityDate I_SupDmndAllDocRetDeliv ProductAvailabilityDate Mat.Avail.Date
RequestedDeliveryDate I_SupDmndAllDocRetDeliv RequestedDeliveryDate Requested Delivery Date
TotalQuantity I_SupDmndAllDocRetDeliv TotalQuantity Activity Quantity
OpenSupplyQuantity
BaseUnit I_SupDmndAllDocRetDeliv BaseUnit Unit of Measure
Material I_SupDmndAllDocRetDeliv Material Vehicle Model
MaterialGroup I_SupDmndAllDocRetDeliv MaterialGroup Product Group
Plant I_SupDmndAllDocRetDeliv Plant Valuation Area
OrderType I_SupDmndAllDocRetDeliv OrderType Order Type
PurchasingOrganization I_SupDmndAllDocRetDeliv PurchasingOrganization Purchasing Organization
PurchasingGroup I_SupDmndAllDocRetDeliv PurchasingGroup Purchasing Group
SalesOrganization I_SupDmndAllDocRetDeliv SalesOrganization Sales Organization
SalesDistrict I_SupDmndAllDocRetDeliv SalesDistrict Sales District
Batch I_SupDmndAllDocRetDeliv Batch Lot No.
StorageLocation I_SupDmndAllDocRetDeliv StorageLocation StorageLocation
MaterialType I_SupDmndAllDocRetDeliv MaterialType Material Type
StockSegment I_SupDmndAllDocRetDeliv StockSegment Stock Segment
CrossPlantConfigurableProduct I_SupDmndAllDocRetDeliv CrossPlantConfigurableProduct Cross-plant CP
Customer I_SupDmndAllDocRetDeliv Customer Sold-to Party
Supplier I_SupDmndAllDocRetDeliv Supplier Supplier
CompanyCode I_SupDmndAllDocRetDeliv CompanyCode Receiver Company Code
NetPriceAmount I_SupDmndAllDocRetDeliv NetPriceAmount Net Price
DocumentCurrency I_SupDmndAllDocRetDeliv DocumentCurrency Document Currency

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_SupDmndAllDocRetDelivAssgmt.
-- 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_SupDmndAllDocRetDelivAssgmt AS
SELECT
  _SupDmndAllDocRetDeliv.SupplyNumber AS SupplyNumber,
  _SupDmndAllDocRetDeliv.SupplyItem AS SupplyItem,
  _SupDmndAllDocRetDeliv.SupplyScheduleLine AS SupplyScheduleLine,
  _SupDmndAllDocRetDeliv.AssignedSupplyType AS AssignedSupplyType,
  _SupDmndAllDocRetDeliv.SupAssgmtSource AS SupAssgmtSource,
  _SupDmndAllDocRetDeliv.SupplyDeliveryDate AS SupplyDeliveryDate,
  _SupDmndAllDocRetDeliv.ProductAvailabilityDate AS ProductAvailabilityDate,
  _SupDmndAllDocRetDeliv.RequestedDeliveryDate AS RequestedDeliveryDate,
  _SupDmndAllDocRetDeliv.TotalQuantity AS TotalQuantity,
  ( _SupDmndAllDocRetDeliv.OpenSupplyQuantity - coalesce( _ARunAssgmtSup.AssignedQuantityInBaseUnit , 0 ) ) AS OpenSupplyQuantity,
  _SupDmndAllDocRetDeliv.BaseUnit AS BaseUnit,
  _SupDmndAllDocRetDeliv.Material AS Material,
  _SupDmndAllDocRetDeliv.MaterialGroup AS MaterialGroup,
  _SupDmndAllDocRetDeliv.Plant AS Plant,
  _SupDmndAllDocRetDeliv.OrderType AS OrderType,
  _SupDmndAllDocRetDeliv.PurchasingOrganization AS PurchasingOrganization,
  _SupDmndAllDocRetDeliv.PurchasingGroup AS PurchasingGroup,
  _SupDmndAllDocRetDeliv.SalesOrganization AS SalesOrganization,
  _SupDmndAllDocRetDeliv.SalesDistrict AS SalesDistrict,
  _SupDmndAllDocRetDeliv.Batch AS Batch,
  _SupDmndAllDocRetDeliv.StorageLocation AS StorageLocation,
  _SupDmndAllDocRetDeliv.MaterialType AS MaterialType,
  _SupDmndAllDocRetDeliv.StockSegment AS StockSegment,
  _SupDmndAllDocRetDeliv.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  _SupDmndAllDocRetDeliv.Customer AS Customer,
  _SupDmndAllDocRetDeliv.Supplier AS Supplier,
  _SupDmndAllDocRetDeliv.CompanyCode AS CompanyCode,
  _SupDmndAllDocRetDeliv.NetPriceAmount AS NetPriceAmount,
  _SupDmndAllDocRetDeliv.DocumentCurrency AS DocumentCurrency
FROM I_SupDmndAllDocRetDeliv AS _SupDmndAllDocRetDeliv
;

Learn More