What is C_ARunAmountQuery in SAP S/4HANA?

C_ARunAmountQuery is a consumption CDS view in SAP S/4HANA. Query View Amount in Display Currency It contains 53 fields.

Which tables does C_ARunAmountQuery read from?

C_ARunAmountQuery reads data from: I_ARunAmountCube.

What VDM layer is C_ARunAmountQuery?

C_ARunAmountQuery is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ARunAmountQuery

DDL: C_ARUNAMOUNTQUERY Type: view CONSUMPTION

53 Fields 1 Data Sources 2 Fiori Apps

Query View Amount in Display Currency

C_ARunAmountQuery is a Consumption CDS View that provides data about "Query View Amount in Display Currency" in SAP S/4HANA. It reads from 1 data source (I_ARunAmountCube) and exposes 53 fields with key fields ATPCheckUUID, RequirementDocumentNumber, RequirementDocumentItem, RequirementType, CalendarYear. It is used in 2 Fiori applications: Compare Supply Assignment Runs Simulation, Supply Assignment Run Detailed Analysis.

Data Sources (1)

Source	Alias	Join Type
I_ARunAmountCube	I_ARunAmountCube	from

Parameters (2)

Name	Type	Default
P_ExchangeRateType	kurst
P_DisplayCurrency	vdm_v_display_currency

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CARUNAMOUNTQUERY	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
Metadata.ignorePropagatedAnnotations	true	view
ClientHandling.type	#INHERITED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
Analytics.query	true	view
EndUserText.label	Query View Amount in Display Currency	view
OData.publish	true	view

Fiori Apps (2)

App ID	App Name	Type	Description
F3640	Compare Supply Assignment Runs Simulation	Analytical	Compare Supply Assignment Runs Simulation
F3666	Supply Assignment Run Detailed Analysis	Analytical	Supply Assignment Run Detailed Analysis

Compare Supply Assignment Runs Simulation

Business Role: Order Fulfillment Manager (Retail)

You can use the following applications to perform supply assignment related operations on the existing assignments to gain transparency and improve customer satisfaction. Supply Assignment Release Check RunConfigure Release Check Variant Schedule Release Check Run Monitor Release Check Run Schedule Deletion of Release Check Run Logs Supply Assignment Run AnalysisCompare Supply Assignment Simulation Runs Supply Assignment Run Detailed Analysis Monitor Supply Assignment Runs Supply Assignment Release Check Run AnalysisCompare Release Check Simulation Runs Release Check Run Detailed Analysis You can also compare the simulation results of supply assignment using various strategic key-performance indicators.

Supply Assignment Run Detailed Analysis

Business Role: Order Fulfillment Manager (Retail)

Fields (53)

Key	Field	Source Field	Description
KEY	ATPCheckUUID	ATPCheckUUID	BOP Run
KEY	RequirementDocumentNumber	RequirementDocumentNumber	Requirement Document Number
KEY	RequirementDocumentItem	RequirementDocumentItem	Requirement Document Item
KEY	RequirementType	RequirementType	Requirement Type
KEY	CalendarYear	CalendarYear	Year
KEY	CalendarMonth	CalendarMonth	Calendar Month
KEY	CalendarDay	CalendarDay	Day
	DeliveredQuantityInBaseUnit	DeliveredQuantityInBaseUnit	Delivered Quantity
	RequestedRqmtQtyInBaseUnit	RequestedRqmtQtyInBaseUnit	Order Quantity
	ConfirmedRqmtQtyInBaseUnit	ConfirmedRqmtQtyInBaseUnit	Confirmed Quantity
	OpenDemandQuantity	OpenDemandQuantity	Open Demand Quantity
	AssignedQuantityInBaseUnit	AssignedQuantityInBaseUnit	Total Assigned Quantity
	FixedQuantityInBaseUnit	FixedQuantityInBaseUnit	Ready for Delivery Quantity
	SupAssgmtReservedQtyInBaseUnit	SupAssgmtReservedQtyInBaseUnit	Reserved Quantity
	ReadyForReleaseQtyInBaseUnit	ReadyForReleaseQtyInBaseUnit	Open for Release Check Quantity
	OnHoldQuantityInBaseUnit	OnHoldQuantityInBaseUnit	On Hold Quantity
	InboundAssignedQuantityInBsUnt	InboundAssignedQuantityInBsUnt	IFO Assigned Quantity
	CalendarWeek	CalendarWeek	Week
	CalendarMonthName	CalendarMonthName	Month
	ABOPVariantUUID	ABOPVariantUUID	BOP Variant UUID
	ABOPVariantName	ABOPVariantName	BOP Variant Name
	StartedByUser	StartedByUser
	ATPCheckStatus	ATPCheckStatus
	ABOPExecutionMode	ABOPExecutionMode
	ATPRlvtDocItmIsSupAssgmtRlvt	ATPRlvtDocItmIsSupAssgmtRlvt
	ABOPAssignmentPreviewIsActive	ABOPAssignmentPreviewIsActive	Assignment Preview
	Material	Material	Product
	Plant	Plant	Valuation Area
	RequirementSegment	RequirementSegment	Req. Segment
	BaseUnit	BaseUnit	Unit of Measure
	SalesOrganization	SalesOrganization	Sales Organization
	DistributionChannel	DistributionChannel	RefDistCh-Cust/Mat.
	Division	Division	Internal Division ID
	SalesDistrict	SalesDistrict	Sales District
	CustomerGroup	CustomerGroup	Customer Group
	CompanyCode	CompanyCode	Company Code
	MaterialGroup	MaterialGroup	Product Group
	OrderType	OrderType	Order Type
	OrderTypeName	OrderTypeName	Order Type Name
	SoldToParty	SoldToParty	Sold-To Party
	ShipToParty	ShipToParty	Ship-To Party
	CrossPlantConfigurableProduct	CrossPlantConfigurableProduct	Generic Article
	DeliveryGroup	DeliveryGroup	Delivery Group
	ProductSeasonYear	ProductSeasonYear	Season Year
	ProductSeason	ProductSeason	Season
	ProductCollection	ProductCollection	Collection
	ProductTheme	ProductTheme	Theme
	ActlAmt	ActlAmt	Amount(Document Currency)
	DocumentCurrency	DocumentCurrency	Document Currency
	DisplayCurrency	DisplayCurrency	Display Currency
	TotActualAmtInDisplayCurrency	TotActualAmtInDisplayCurrency	Amount
	ARunReqdRqmtQtyFlfmtPercent	1	Fulfillment Percent - Order Quantity
	ARunConfdRqmtQtyFlfmtPercent	1	Fulfillment Percent - Confirmed Quantity

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_ARunAmountQuery.
-- 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_ExchangeRateType : kurst, P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW C_ARunAmountQuery AS
SELECT
  ATPCheckUUID,
  RequirementDocumentNumber,
  RequirementDocumentItem,
  RequirementType,
  CalendarYear,
  CalendarMonth,
  CalendarDay,
  DeliveredQuantityInBaseUnit,
  RequestedRqmtQtyInBaseUnit,
  ConfirmedRqmtQtyInBaseUnit,
  OpenDemandQuantity,
  AssignedQuantityInBaseUnit,
  FixedQuantityInBaseUnit,
  SupAssgmtReservedQtyInBaseUnit,
  ReadyForReleaseQtyInBaseUnit,
  OnHoldQuantityInBaseUnit,
  InboundAssignedQuantityInBsUnt,
  CalendarWeek,
  CalendarMonthName,
  ABOPVariantUUID,
  ABOPVariantName,
  StartedByUser,
  ATPCheckStatus,
  ABOPExecutionMode,
  ATPRlvtDocItmIsSupAssgmtRlvt,
  ABOPAssignmentPreviewIsActive,
  Material,
  Plant,
  RequirementSegment,
  BaseUnit,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesDistrict,
  CustomerGroup,
  CompanyCode,
  MaterialGroup,
  OrderType,
  OrderTypeName,
  SoldToParty,
  ShipToParty,
  CrossPlantConfigurableProduct,
  DeliveryGroup,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  ActlAmt,
  DocumentCurrency,
  DisplayCurrency,
  TotActualAmtInDisplayCurrency,
  1 AS ARunReqdRqmtQtyFlfmtPercent,
  1 AS ARunConfdRqmtQtyFlfmtPercent
FROM I_ARunAmountCube
;

Depth:

C_ARunAmountQuery view

I_ARunAmountCube view