C_WIPQuantityDocument

DDL: C_WIPQUANTITYDOCUMENT Type: view_entity CONSUMPTION Package: FCML4H_DISPLAY
32 Fields 1 Data Sources 1 OData Services

Work In Process Quantity Document

C_WIPQuantityDocument is a Consumption CDS View that provides data about "Work In Process Quantity Document" in SAP S/4HANA. It reads from 1 data source (I_WIPQuantityDocument) and exposes 32 fields with key fields ControllingDocument, Plant, CostEstimate, FiscalYear, FiscalPeriod. It is exposed through 1 OData service (ASQL_F3498). Part of development package FCML4H_DISPLAY.

Data Sources (1)

SourceAliasJoin Type
I_WIPQuantityDocument I_WIPQuantityDocument from

Parameters (3)

NameTypeDefault
P_FromFiscalYearPeriod fml_fyearperiod_from
P_ToFiscalYearPeriod fml_fyearperiod_to
P_OrderID fis_order_number

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
EndUserText.label Work In Process Quantity Document view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3498 ASQL_F3498 C2 NOT_RELEASED

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY ControllingDocument ControllingDocument
KEY Plant Plant Valuation Area
KEY CostEstimate CostEstimate Cost EstimateNo
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
FiscalYearPeriod FiscalYearPeriod Period/Year
ObjectInternalID ObjectInternalID Object number
OrderID OrderID Order ID
OrderItem OrderItem
ControllingArea ControllingArea Controlling Area
ProductionProcess ProductionProcess
PostingPeriod PostingPeriod Posting Period
PostingDate PostingDate Posting Date for GR
CreatedByUser CreatedByUser User Name
ActualCostingObjectType ActualCostingObjectType
ActualCostingObjectTypeName ActualCostingObjectTypeName
Material Material Vehicle Model
InventoryValuationType InventoryValuationType Valuation Type
InventorySpecialStockType InventorySpecialStockType Special Stock Type
InventorySpecialStockTypeName InventorySpecialStockTypeName
InventorySpecialStockValnType InventorySpecialStockValnType Valuation
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementExternalID WBSElementExternalID WBS Element External ID
CostCenter CostCenter Cost Center
CostCtrActivityType CostCtrActivityType Activity Type
QuantityUnit QuantityUnit Unit of measure
WIPQuantity WIPQuantity
DeltaQuantity DeltaQuantity
_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 C_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, P_OrderID : fis_order_number

CREATE VIEW C_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 I_WIPQuantityDocument
;

Learn More