I_StockWorklist

DDL: I_STOCKWORKLIST SQL: ISTOCKWORKLIST Type: view BASIC
26 Fields 1 Data Sources

Stock Worklist

I_StockWorklist is a Basic CDS View that provides data about "Stock Worklist" in SAP S/4HANA. It reads from 1 data source (stck_worklist) and exposes 26 fields with key fields Mandt, RowIndex, Material, Plant, Customer.

Data Sources (1)

SourceAliasJoin Type
stck_worklist STCK from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISTOCKWORKLIST view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Stock Worklist view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Mandt stck_worklist mandt Editing Client
KEY RowIndex stck_worklist rowindex Row index
KEY Material stck_worklist material Vehicle Model
KEY Plant stck_worklist plant Valuation Area
KEY Customer stck_worklist customer Sold-to Party
KEY IssueType stck_worklist issuetype Issue Type for stock
KEY SolutionType stck_worklist solutiontype Solution Type
KEY SalesOrder stck_worklist salesorder SD Document
KEY SalesOrderItem stck_worklist salesorderitem Sales Order Item
KEY Batch stck_worklist batch Lot No.
KEY ReferenceDocumentScheduleLine stck_worklist referencedocumentscheduleline Schedule Line
IssueDate stck_worklist issuedate Order End Date
OriginalDeliveryQuantity stck_worklist originaldeliveryquantity Base quantity
DeliveryQuantityInBaseUnit stck_worklist deliveryquantityinbaseunit Base quantity
QuantityUnit stck_worklist quantityunit Unit of measure
OriginalDeliveryDate
ActualDeliveryQuantity stck_worklist actualdeliveryquantity Base quantity
DeliveryQuantity stck_worklist deliveryquantity Delivery unit
ActualDeliveryDate stck_worklist actualdeliverydate Delivery Date
DeliveryDate stck_worklist deliverydate Delivery Date
SolutionMargin stck_worklist solutionmargin Average value
Profit stck_worklist profit Net Price
SolutionCoverage stck_worklist solutioncoverage Average value
Revenue stck_worklist revenue Net Price
CompanyCodeCurrency stck_worklist companycodecurrency Local Currency
CreatedByUserName createdbyusername Person Resp.

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_StockWorklist.
-- 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: ISTOCKWORKLIST

CREATE VIEW I_StockWorklist AS
SELECT
  STCK.mandt AS Mandt,
  STCK.rowindex AS RowIndex,
  STCK.material AS Material,
  STCK.plant AS Plant,
  STCK.customer AS Customer,
  STCK.issuetype AS IssueType,
  STCK.solutiontype AS SolutionType,
  STCK.salesorder AS SalesOrder,
  STCK.salesorderitem AS SalesOrderItem,
  STCK.batch AS Batch,
  STCK.referencedocumentscheduleline AS ReferenceDocumentScheduleLine,
  STCK.issuedate AS IssueDate,
  STCK.originaldeliveryquantity AS OriginalDeliveryQuantity,
  STCK.deliveryquantityinbaseunit AS DeliveryQuantityInBaseUnit,
  STCK.quantityunit AS QuantityUnit,
  STCK.actualdeliveryquantity AS ActualDeliveryQuantity,
  STCK.deliveryquantity AS DeliveryQuantity,
  STCK.actualdeliverydate AS ActualDeliveryDate,
  STCK.deliverydate AS DeliveryDate,
  STCK.solutionmargin AS SolutionMargin,
  STCK.profit AS Profit,
  STCK.solutioncoverage AS SolutionCoverage,
  STCK.revenue AS Revenue,
  STCK.companycodecurrency AS CompanyCodeCurrency,
  CreatedByUserName
FROM stck_worklist AS STCK
;

Learn More