I_ARunOvwConfStrgyCube

DDL: I_ARUNOVWCONFSTRGYCUBE SQL: IARUNOSTRGYCUBE Type: view COMPOSITE Package: VDM_ARUN_MONITOR
43 Fields 1 Data Sources 1 Associations

Cube View for ARun Confirmation Strategy

I_ARunOvwConfStrgyCube is a Composite CDS View (Cube) that provides data about "Cube View for ARun Confirmation Strategy" in SAP S/4HANA. It reads from 1 data source (I_ARunOvwConfStrgy) and exposes 43 fields with key fields ATPCheckUUID, RequirementDocumentNumber, RequirementDocumentItem, RequestedDate, RequirementType. It has 1 association to related views. Part of development package VDM_ARUN_MONITOR.

Data Sources (1)

SourceAliasJoin Type
I_ARunOvwConfStrgy Demand from

Associations (1)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IARUNOSTRGYCUBE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Cube View for ARun Confirmation Strategy 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 (43)

KeyFieldSource TableSource FieldDescription
KEY ATPCheckUUID ATPCheckUUID BOP Run ID
KEY RequirementDocumentNumber RequirementDocumentNumber Requirement Document Number
KEY RequirementDocumentItem RequirementDocumentItem Requirement Document Item
KEY RequestedDate RequestedDate Requested Date
KEY RequirementType RequirementType Requirement Type
RequestedRqmtQtyInBaseUnit RequestedRqmtQtyInBaseUnit Order Quantity
SupAssgmtAggrgQtyUnit
ABOPVariantUUID ABOPVariantUUID BOP Variant UUID
ABOPVariantName ABOPVariantName BOP Variant Name
StartedByUser StartedByUser
ATPCheckStartUTCDateTime ATPCheckStartUTCDateTime Start Timestamp
ATPCheckEndUTCDateTime ATPCheckEndUTCDateTime
ATPCheckStatus ATPCheckStatus
ABOPExecutionMode ABOPExecutionMode
ATPRlvtDocItmIsSupAssgmtRlvt ATPRlvtDocItmIsSupAssgmtRlvt
ABOPAssignmentPreviewIsActive ABOPAssignmentPreviewIsActive Assignment Preview
ABOPConfirmationStrategy ABOPConfirmationStrategy BOP Confirmation Strategy
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_ARunOvwConfStrgyCube.
-- 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: IARUNOSTRGYCUBE

CREATE VIEW I_ARunOvwConfStrgyCube AS
SELECT
  ATPCheckUUID,
  RequirementDocumentNumber,
  RequirementDocumentItem,
  RequestedDate,
  RequirementType,
  RequestedRqmtQtyInBaseUnit,
  cast(' ' as meins) AS SupAssgmtAggrgQtyUnit,
  ABOPVariantUUID,
  ABOPVariantName,
  StartedByUser,
  ATPCheckStartUTCDateTime,
  ATPCheckEndUTCDateTime,
  ATPCheckStatus,
  ABOPExecutionMode,
  ATPRlvtDocItmIsSupAssgmtRlvt,
  ABOPAssignmentPreviewIsActive,
  ABOPConfirmationStrategy,
  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_ARunOvwConfStrgy AS Demand
LEFT OUTER JOIN I_Currency AS _DocCurrency ON DocumentCurrency = _DocCurrency.Currency  -- association [0..1]
;

Learn More