C_ARunAmountQuery

DDL: C_ARUNAMOUNTQUERY Type: view CONSUMPTION Package: VDM_ARUN_MONITOR
53 Fields 1 Data Sources

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. Part of development package VDM_ARUN_MONITOR.

Data Sources (1)

SourceAliasJoin Type
I_ARunAmountCube I_ARunAmountCube from

Parameters (2)

NameTypeDefault
P_ExchangeRateType kurst
P_DisplayCurrency vdm_v_display_currency

Annotations (13)

NameValueLevelField
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

Fields (53)

KeyFieldSource TableSource FieldDescription
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
;

Learn More