I_SupDmndAllDocPurReqn

DDL: I_SUPDMNDALLDOCPURREQN Type: view COMPOSITE
31 Fields 2 Data Sources

View for Purchase Requisition

I_SupDmndAllDocPurReqn is a Composite CDS View that provides data about "View for Purchase Requisition" in SAP S/4HANA. It reads from 2 data sources (P_ARunAssgmtSup, I_SupDmndAllDocPurReqnBsc) and exposes 31 fields.

Data Sources (2)

SourceAliasJoin Type
P_ARunAssgmtSup Assgmt left_outer
I_SupDmndAllDocPurReqnBsc PurReqn 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 ISUPDMNDADPR 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 Purchase Requisition view

Fields (31)

KeyFieldSource TableSource FieldDescription
SupplyNumber I_SupDmndAllDocPurReqnBsc SupplyNumber
SupplyItem I_SupDmndAllDocPurReqnBsc SupplyItem
MRPArea I_SupDmndAllDocPurReqnBsc MRPArea MRP Area
SupplyScheduleLine I_SupDmndAllDocPurReqnBsc SupplyScheduleLine
AssignedSupplyType I_SupDmndAllDocPurReqnBsc AssignedSupplyType
SupAssgmtSource I_SupDmndAllDocPurReqnBsc SupAssgmtSource
SupplyDeliveryDate I_SupDmndAllDocPurReqnBsc SupplyDeliveryDate Delivery Date
ProductAvailabilityDate I_SupDmndAllDocPurReqnBsc ProductAvailabilityDate Mat.Avail.Date
TotalQuantity I_SupDmndAllDocPurReqnBsc TotalQuantity Activity Quantity
OpenSupplyQuantity
AssignedQuantityInBaseUnit P_ARunAssgmtSup AssignedQuantityInBaseUnit
NormalAssignedQuantityInBsUnt P_ARunAssgmtSup NormalAssignedQuantityInBsUnt
PreviewAssignedQuantityInBsUnt P_ARunAssgmtSup PreviewAssignedQuantityInBsUnt
BaseUnit I_SupDmndAllDocPurReqnBsc BaseUnit Unit of Measure
Material I_SupDmndAllDocPurReqnBsc Material Vehicle Model
MaterialGroup I_SupDmndAllDocPurReqnBsc MaterialGroup Product Group
Plant I_SupDmndAllDocPurReqnBsc Plant Valuation Area
CrossPlantConfigurableProduct I_SupDmndAllDocPurReqnBsc CrossPlantConfigurableProduct Cross-plant CP
OrderType I_SupDmndAllDocPurReqnBsc OrderType Order Type
PurchasingOrganization I_SupDmndAllDocPurReqnBsc PurchasingOrganization Purchasing Organization
PurchasingGroup I_SupDmndAllDocPurReqnBsc PurchasingGroup Purchasing Group
Batch I_SupDmndAllDocPurReqnBsc Batch Lot No.
StorageLocation I_SupDmndAllDocPurReqnBsc StorageLocation StorageLocation
Customer I_SupDmndAllDocPurReqnBsc Customer Sold-to Party
Supplier I_SupDmndAllDocPurReqnBsc Supplier Supplier
CompanyCode I_SupDmndAllDocPurReqnBsc CompanyCode Receiver Company Code
SalesOrder I_SupDmndAllDocPurReqnBsc SalesOrder SD Document
SalesOrderItem I_SupDmndAllDocPurReqnBsc SalesOrderItem Sales Order Item
PurgReleaseSequenceStatus I_SupDmndAllDocPurReqnBsc PurgReleaseSequenceStatus Release State
StockSegment I_SupDmndAllDocPurReqnBsc StockSegment Stock Segment
GoodsReceiptDurationInDays I_SupDmndAllDocPurReqnBsc 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_SupDmndAllDocPurReqn.
-- 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_SupDmndAllDocPurReqn AS
SELECT
  PurReqn.SupplyNumber AS SupplyNumber,
  PurReqn.SupplyItem AS SupplyItem,
  PurReqn.MRPArea AS MRPArea,
  PurReqn.SupplyScheduleLine AS SupplyScheduleLine,
  PurReqn.AssignedSupplyType AS AssignedSupplyType,
  PurReqn.SupAssgmtSource AS SupAssgmtSource,
  PurReqn.SupplyDeliveryDate AS SupplyDeliveryDate,
  PurReqn.ProductAvailabilityDate AS ProductAvailabilityDate,
  PurReqn.TotalQuantity AS TotalQuantity,
  ( PurReqn.OpenSupplyQuantity - coalesce( Assgmt.AssignedQuantityInBaseUnit, 0 ) ) AS OpenSupplyQuantity,
  Assgmt.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
  Assgmt.NormalAssignedQuantityInBsUnt AS NormalAssignedQuantityInBsUnt,
  Assgmt.PreviewAssignedQuantityInBsUnt AS PreviewAssignedQuantityInBsUnt,
  PurReqn.BaseUnit AS BaseUnit,
  PurReqn.Material AS Material,
  PurReqn.MaterialGroup AS MaterialGroup,
  PurReqn.Plant AS Plant,
  PurReqn.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  PurReqn.OrderType AS OrderType,
  PurReqn.PurchasingOrganization AS PurchasingOrganization,
  PurReqn.PurchasingGroup AS PurchasingGroup,
  PurReqn.Batch AS Batch,
  PurReqn.StorageLocation AS StorageLocation,
  PurReqn.Customer AS Customer,
  PurReqn.Supplier AS Supplier,
  PurReqn.CompanyCode AS CompanyCode,
  PurReqn.SalesOrder AS SalesOrder,
  PurReqn.SalesOrderItem AS SalesOrderItem,
  PurReqn.PurgReleaseSequenceStatus AS PurgReleaseSequenceStatus,
  PurReqn.StockSegment AS StockSegment,
  PurReqn.GoodsReceiptDurationInDays AS GoodsReceiptDurationInDays
FROM I_SupDmndAllDocPurReqnBsc AS PurReqn
LEFT OUTER JOIN P_ARunAssgmtSup AS Assgmt ON /* join condition not captured in parsed metadata */
;

Learn More