P_SupDmndAllDocStkTransptReqn

DDL: P_SUPDMNDALLDOCSTKTRANSPTREQN Type: view COMPOSITE
31 Fields 1 Data Sources

P_SupDmndAllDocStkTransptReqn is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SupDmndAllDocStkTransptReqn) and exposes 31 fields.

Data Sources (1)

SourceAliasJoin Type
I_SupDmndAllDocStkTransptReqn _SupDmndAllDocStkTransptReqn from

Annotations (9)

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

Fields (31)

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

Learn More