I_SupDmndAllDocConfirmations

DDL: I_SUPDMNDALLDOCCONFIRMATIONS Type: view COMPOSITE Package: VDM_ARUN_ANALYTICS_ALL
31 Fields 2 Data Sources

View for Supplier Confirmations

I_SupDmndAllDocConfirmations is a Composite CDS View that provides data about "View for Supplier Confirmations" in SAP S/4HANA. It reads from 2 data sources (P_ARunAssgmtSup, I_SupDmndAllDocConfBsc) and exposes 31 fields. Part of development package VDM_ARUN_ANALYTICS_ALL.

Data Sources (2)

SourceAliasJoin Type
P_ARunAssgmtSup Assgmt left_outer
I_SupDmndAllDocConfBsc Conf 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 ISUPDMNDADCONF 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 Supplier Confirmations view

Fields (31)

KeyFieldSource TableSource FieldDescription
SupplyNumber I_SupDmndAllDocConfBsc SupplyNumber
SupplyItem I_SupDmndAllDocConfBsc SupplyItem
SupplyScheduleLine I_SupDmndAllDocConfBsc SupplyScheduleLine
AssignedSupplyType I_SupDmndAllDocConfBsc AssignedSupplyType
SupAssgmtSource I_SupDmndAllDocConfBsc SupAssgmtSource
SupplyDeliveryDate I_SupDmndAllDocConfBsc SupplyDeliveryDate Delivery Date
ProductAvailabilityDate I_SupDmndAllDocConfBsc ProductAvailabilityDate Mat.Avail.Date
TotalQuantity I_SupDmndAllDocConfBsc TotalQuantity Activity Quantity
OpenSupplyQuantity
AssignedQuantityInBaseUnit P_ARunAssgmtSup AssignedQuantityInBaseUnit
NormalAssignedQuantityInBsUnt P_ARunAssgmtSup NormalAssignedQuantityInBsUnt
PreviewAssignedQuantityInBsUnt P_ARunAssgmtSup PreviewAssignedQuantityInBsUnt
BaseUnit I_SupDmndAllDocConfBsc BaseUnit Unit of Measure
Material I_SupDmndAllDocConfBsc Material Vehicle Model
MaterialGroup I_SupDmndAllDocConfBsc MaterialGroup Product Group
Plant I_SupDmndAllDocConfBsc Plant Valuation Area
CrossPlantConfigurableProduct I_SupDmndAllDocConfBsc CrossPlantConfigurableProduct Cross-plant CP
OrderType I_SupDmndAllDocConfBsc OrderType Order Type
PurchasingOrganization I_SupDmndAllDocConfBsc PurchasingOrganization Purchasing Organization
PurchasingGroup I_SupDmndAllDocConfBsc PurchasingGroup Purchasing Group
Batch I_SupDmndAllDocConfBsc Batch Lot No.
StorageLocation I_SupDmndAllDocConfBsc StorageLocation StorageLocation
Customer I_SupDmndAllDocConfBsc Customer Sold-to Party
CompanyCode I_SupDmndAllDocConfBsc CompanyCode Receiver Company Code
Supplier I_SupDmndAllDocConfBsc Supplier Supplier
SalesOrder I_SupDmndAllDocConfBsc SalesOrder SD Document
SalesOrderItem I_SupDmndAllDocConfBsc SalesOrderItem Sales Order Item
PurgReleaseSequenceStatus I_SupDmndAllDocConfBsc PurgReleaseSequenceStatus Release State
StockSegment I_SupDmndAllDocConfBsc StockSegment Stock Segment
GoodsReceiptDurationInDays I_SupDmndAllDocConfBsc GoodsReceiptDurationInDays GR proc. time
MRPArea I_SupDmndAllDocConfBsc MRPArea MRP Area

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

Learn More