I_ARunCompareAssgmtCube

DDL: I_ARUNCOMPAREASSGMTCUBE SQL: IARUNCOMPCUBE Type: view COMPOSITE Package: VDM_ARUN_MONITOR
41 Fields 1 Data Sources 1 Associations

ARun Compare Assignments Cube View

I_ARunCompareAssgmtCube is a Composite CDS View (Cube) that provides data about "ARun Compare Assignments Cube View" in SAP S/4HANA. It reads from 1 data source (I_ARunCompareAssgmt) and exposes 41 fields with key fields ATPCheckUUID, RequirementDocumentNumber, RequirementDocumentItem, RequirementType. It has 1 association to related views. Part of development package VDM_ARUN_MONITOR.

Data Sources (1)

SourceAliasJoin Type
I_ARunCompareAssgmt Assgmt from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _DocCurrency $projection.DocumentCurrency = _DocCurrency.Currency

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IARUNCOMPCUBE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label ARun Compare Assignments Cube View view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
AccessControl.personalData.blocking #REQUIRED view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY ATPCheckUUID ATPCheckUUID BOP Run ID
KEY RequirementDocumentNumber RequirementDocumentNumber Requirement Document Number
KEY RequirementDocumentItem RequirementDocumentItem Requirement Document Item
KEY RequirementType I_ARunCompareAssgmt RequirementType Requirement Type
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit Simulation
NormalAssignedQuantityInBsUnt NormalAssignedQuantityInBsUnt Normal
PreviewAssignedQuantityInBsUnt PreviewAssignedQuantityInBsUnt Preview
SupAssgmtAggrgQtyUnit
ABOPVariantUUID ABOPVariantUUID BOP Variant UUID
ABOPVariantName ABOPVariantName BOP Variant Name
StartedByUser StartedByUser
ATPCheckStartUTCDateTime ATPCheckStartUTCDateTime Start Timestamp
ATPCheckEndUTCDateTime ATPCheckEndUTCDateTime
ATPCheckStatus ATPCheckStatus
ABOPExecutionMode ABOPExecutionMode
Material Material Vehicle Model
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
SoldToParty SoldToParty Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)
CrossPlantConfigurableProduct CrossPlantConfigurableProduct Cross-plant CP
DeliveryGroup DeliveryGroup Delivery Group
ProductSeasonYear ProductSeasonYear Season Year
ProductSeason ProductSeason Season
ProductCollection ProductCollection Collection
ProductTheme ProductTheme Theme
NetPriceAmount NetPriceAmount Net Price
NetPriceQuantity NetPriceQuantity Price Unit
NetAmount NetAmount Stated Amount
DocumentCurrency DocumentCurrency Document Currency
_DocCurrency _DocCurrency

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_ARunCompareAssgmtCube.
-- 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: IARUNCOMPCUBE

CREATE VIEW I_ARunCompareAssgmtCube AS
SELECT
  ATPCheckUUID,
  RequirementDocumentNumber,
  RequirementDocumentItem,
  Assgmt.RequirementType AS RequirementType,
  AssignedQuantityInBaseUnit,
  NormalAssignedQuantityInBsUnt,
  PreviewAssignedQuantityInBsUnt,
  cast(' ' as meins) AS SupAssgmtAggrgQtyUnit,
  ABOPVariantUUID,
  ABOPVariantName,
  StartedByUser,
  ATPCheckStartUTCDateTime,
  ATPCheckEndUTCDateTime,
  ATPCheckStatus,
  ABOPExecutionMode,
  Material,
  Plant,
  RequirementSegment,
  BaseUnit,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesDistrict,
  CustomerGroup,
  CompanyCode,
  MaterialGroup,
  OrderType,
  OrderTypeName,
  SoldToParty,
  ShipToParty,
  CrossPlantConfigurableProduct,
  DeliveryGroup,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  NetPriceAmount,
  NetPriceQuantity,
  NetAmount,
  DocumentCurrency
FROM I_ARunCompareAssgmt AS Assgmt
LEFT OUTER JOIN I_Currency AS _DocCurrency ON DocumentCurrency = _DocCurrency.Currency  -- association [0..1]
;

Learn More