P_Stockworklistquantity

DDL: P_STOCKWORKLISTQUANTITY SQL: PSTCKWRKQTY Type: view COMPOSITE
11 Fields 1 Data Sources

P_Stockworklistquantity is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_StckWorklist) and exposes 11 fields with key fields Material, Plant, BubbleDate, Customer, IssueType.

Data Sources (1)

SourceAliasJoin Type
I_StckWorklist STCK from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSTCKWRKQTY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Material I_StckWorklist Material Vehicle Model
KEY Plant I_StckWorklist Plant Valuation Area
KEY BubbleDate I_StckWorklist IssueDate Order End Date
KEY Customer I_StckWorklist Customer Sold-to Party
KEY IssueType I_StckWorklist IssueType Issue Type for stock
KEY SolutionType I_StckWorklist SolutionType Solution Type
KEY SalesOrder I_StckWorklist SalesOrder SD Document
KEY SalesOrderItem I_StckWorklist SalesOrderItem Sales Order Item
KEY Batch I_StckWorklist Batch Lot No.
SumOriginalBaseQuantity
ReferenceDocumentScheduleLine I_StckWorklist ReferenceDocumentScheduleLine Schedule Line

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_Stockworklistquantity.
-- 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.
-- SQL view name: PSTCKWRKQTY

CREATE VIEW P_Stockworklistquantity AS
SELECT
  STCK.Material AS Material,
  STCK.Plant AS Plant,
  STCK.IssueDate AS BubbleDate,
  STCK.Customer AS Customer,
  STCK.IssueType AS IssueType,
  STCK.SolutionType AS SolutionType,
  STCK.SalesOrder AS SalesOrder,
  STCK.SalesOrderItem AS SalesOrderItem,
  STCK.Batch AS Batch,
  sum(STCK.DeliveryQuantityInBaseUnit ) AS SumOriginalBaseQuantity,
  STCK.ReferenceDocumentScheduleLine AS ReferenceDocumentScheduleLine
FROM I_StckWorklist AS STCK
;

Learn More