What is I_WIPQuantityDocument in SAP S/4HANA?

I_WIPQuantityDocument is a composite CDS view in SAP S/4HANA. Work In Process Quantity Document It contains 32 fields.

Which tables does I_WIPQuantityDocument read from?

I_WIPQuantityDocument reads data from: P_MLWIPQuantityDoc.

What VDM layer is I_WIPQuantityDocument?

I_WIPQuantityDocument is classified as a Composite view that combines data from multiple basic views.

I_WIPQuantityDocument

DDL: I_WIPQUANTITYDOCUMENT Type: view_entity COMPOSITE Package: FCML4H_DISPLAY

32 Fields 1 Data Sources 3 Associations

Work In Process Quantity Document

I_WIPQuantityDocument (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_WIPQuantityDocument is a Composite CDS View that provides data about "Work In Process Quantity Document" in SAP S/4HANA. It reads from 1 data source (P_MLWIPQuantityDoc) and exposes 32 fields with key fields ControllingDocument, Plant, CostEstimate, FiscalYear, FiscalPeriod. It has 3 associations to related views. Part of development package FCML4H_DISPLAY.

SAP Help Documentation

Category	CDS Views for Inventory Accounting

Purpose
This CDS view displays work-in-progress (WIP) quantity document records within a selected fiscal year period. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: BWKEY (Valuation Area) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included. The CDS View is included in the business catalog SAP_A4C_BC_DEV_TST_FIN_IA0_PC .

Structure
Parameters The parameters of the CDS view are as follows: P_FromFiscalYearPeriod P_ToFiscalYearPeriod These parameters are used to define the fiscal year and period. Important Fields Important fields in this view include the following: Field Attribute Field Name Description Key ControllingDocument Controlling Document Number Key Plant Plant Key CostEstimate Cost Estimate Number Key FiscalYear Fiscal Year Key FiscalPeriod Fiscal Period Attribute ObjectInternalID Object ID Attribute OrderID Order Number Attribute OrderItem Order Item Number Attribute ControllingArea Controlling Area Attribute ProductionProcess Production Process Attribute PostingPeriod Document Posting Period Attribute PostingDate Posting Date Attribute CreatedByUser Created by User Attribute ActualCostingObjectType Actual Costing Object Type Text ActualCostingObjectTypeName Actual Costing Object Type Description Attribute Material Material Attribute InventoryValuationType Valuation Type Attribute InventorySpecialStockType Special Stock Text InventorySpecialStockTypeName Special Stock Description Attribute InventorySpecialStockValnType Special Stock Valuation Type Attribute SalesOrder SD Document Attribute SalesOrderItem Item (SD) Attribute WBSElementExternalID WBS Element Attribute CostCenter Cost Center Attribute CostCtrActivityType Activity Type Unit QuantityUnit Quantity Unit Value WIPQuantity WIP Quantity Value DeltaQuantity WIP Delta Quantity

View on SAP Help Portal →

SAP API Hub

Category	Composite
State	C1
Line of Business	Accounting and Financial Close
Application Component	CO-PC-ACT-2CL
Capabilities	Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Accounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view displays work-in-progress (WIP) quantity document records within a selected fiscal year period.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_MLWIPQuantityDoc	P_MLWIPQuantityDoc	from

Parameters (2)

Name	Type	Default
P_FromFiscalYearPeriod	fml_fyearperiod_from
P_ToFiscalYearPeriod	fml_fyearperiod_to

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_Product	_Product	`$projection.Material = _Product.Product`
[0..1]	I_Plant	_Plant	`$projection.Plant = _Plant.Plant`
[1..1]	I_UnitOfMeasure	_QuantityUnit	`$projection.QuantityUnit = _QuantityUnit.UnitOfMeasure`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Work In Process Quantity Document	view

Fields (32)

Key	Field	Source Field	Description
KEY	ControllingDocument	ControllingDocument	Document Number
KEY	Plant	Plant	Valuation Area
KEY	CostEstimate	CostEstimate	Cost Estimate Number for Cost Est. w/o Qty Structure
KEY	FiscalYear	FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod	FiscalPeriod	Document Period
	FiscalYearPeriod	FiscalYearPeriod	Fiscal Year + Fiscal Period
	ObjectInternalID	ObjectInternalID	Object number
	OrderID	OrderID	Order Number
	OrderItem	OrderItem	Order Item
	ControllingArea	ControllingArea	Controlling Area
	ProductionProcess	ProductionProcess	Production Process
	PostingPeriod	PostingPeriod	WIP Quantity Period
	PostingDate	PostingDate	Posting Date in the Document
	CreatedByUser	CreatedByUser	Created By
	ActualCostingObjectType	ActualCostingObjectType	Object Type
	ActualCostingObjectTypeName	ActualCostingObjectTypeName	Short Text for Fixed Values
	Material	Material	Material Number
	InventoryValuationType	InventoryValuationType	Valuation Type
	InventorySpecialStockType	InventorySpecialStockType	Special Stock Indicator
	InventorySpecialStockTypeName	InventorySpecialStockTypeName	Special Stock Type Name
	InventorySpecialStockValnType	InventorySpecialStockValnType	Valuation of Special Stock
	SalesOrder	SalesOrder	Sales and Distribution Document Number
	SalesOrderItem	SalesOrderItem	Item number of the SD document
	WBSElementExternalID	WBSElementExternalID	Work Breakdown Structure Element (WBS Element) Edited
	CostCenter	CostCenter	Cost Center
	CostCtrActivityType	CostCtrActivityType	Activity Type
	QuantityUnit	QuantityUnit	Unit of Measure for Display
	WIPQuantity	WIPQuantity	WIP Quantity for Period Layer
	DeltaQuantity	DeltaQuantity	WIP Quantity Changes
	_Product	_Product
	_Plant	_Plant
	_QuantityUnit	_QuantityUnit

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_WIPQuantityDocument.
-- 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.
-- Parameters: P_FromFiscalYearPeriod : fml_fyearperiod_from, P_ToFiscalYearPeriod : fml_fyearperiod_to

CREATE VIEW I_WIPQuantityDocument AS
SELECT
  ControllingDocument,
  Plant,
  CostEstimate,
  FiscalYear,
  FiscalPeriod,
  FiscalYearPeriod,
  ObjectInternalID,
  OrderID,
  OrderItem,
  ControllingArea,
  ProductionProcess,
  PostingPeriod,
  PostingDate,
  CreatedByUser,
  ActualCostingObjectType,
  ActualCostingObjectTypeName,
  Material,
  InventoryValuationType,
  InventorySpecialStockType,
  InventorySpecialStockTypeName,
  InventorySpecialStockValnType,
  SalesOrder,
  SalesOrderItem,
  WBSElementExternalID,
  CostCenter,
  CostCtrActivityType,
  QuantityUnit,
  WIPQuantity,
  DeltaQuantity
FROM P_MLWIPQuantityDoc
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnit ON QuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [1..1]
;

Depth:

I_WIPQuantityDocument view_entity

P_MLWIPQuantityDoc view_entity

C_WIPQuantityDocument view_entity