I_ARunRelChkAmountCube

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_ARunRelChkAmountCube.
-- 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 I_ARunRelChkAmountCube AS
SELECT
  ARunReleaseCheckRunUUID,
  ARunReleaseCheckResultUUID,
  ARunReleaseCheckVariantUUID,
  SupAssgmtExecutionMode,
  _ARunRCText.ARunReleaseCheckVariantName AS ARunReleaseCheckVariantName,
  RequirementDocumentNumber,
  RequirementDocumentItem,
  RequirementType,
  cast( ProductAvailabilityDate as mbdat ) AS ProductAvailabilityDate,
  SupplyAssignmentStatus,
  PreviousSupplyAssignmentStatus,
  AssignedSupplyType,
  OrderQuantity,
  ConfirmedRqmtQtyInBaseUnit,
  DeliveredQuantityInBaseUnit,
  AssignedQuantityInBaseUnit,
  FixedQuantityInBaseUnit,
  OnHoldQuantityInBaseUnit,
  SupAssgmtReservedQtyInBaseUnit,
  BaseUnit,
  ARunMatlAvailyDateRelChkStatus,
  ARunItemRelChkStatus,
  ARunGenericArticleRelChkStatus,
  ARunDelivGrpRelChkStatus,
  ARunHeaderRelChkStatus,
  ARunShipgGrpRelChkStatus,
  ARunMatlAvailyDateRelChkRule,
  ARunItemRelChkRule,
  ARunGenericArticleRelChkRule,
  ARunDelivGrpRelChkRule,
  ARunHeaderRelChkRule,
  ARunShipgGrpRelChkRule,
  ARunMatlAvailyDateRelChkPct,
  ARunItemRelChkPct,
  ARunGenericArticleRelChkPct,
  ARunDelivGrpRelChkPct,
  ARunHeaderRelChkPct,
  ARunShipgGrpRelChkPct,
  OrderType,
  SalesOrganization,
  DistributionChannel,
  SalesGroup,
  SalesOffice,
  ShippingCondition,
  SoldToParty,
  '' AS RequestedDeliveryDate,
  cast( 0 as arun_alloc_qty) AS OpenDemandQuantity,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CompanyCode,
  CustomerReferenceNumber,
  PartnerFunction,
  ShipToParty,
  SalesDocumentItemCategory,
  Division,
  Material,
  MaterialGroup,
  SalesDocumentRjcnReason,
  DeliveryGroup,
  ItemBillingBlockReason,
  BusinessArea,
  ProfitCenter,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency,
  NetAmount,
  ActlAmt,
  DocumentCurrency,
  DeliveryPriority,
  Plant,
  StorageLocation,
  ShippingPoint,
  NetPriceAmount,
  NetPriceQuantity,
  RequirementSegment,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  FashionCancelDate,
  ShippingGroupRule,
  ShippingGroupNumber,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  CustomerGroup,
  SalesDistrict,
  PaymentTerms,
  SupAssgmtOrdStatus,
  CrossPlantConfigurableProduct,
  FreeDefinedProductAttribute01,
  FreeDefinedProductAttribute02,
  FreeDefinedProductAttribute03,
  OrderTypeName,
  CalendarMonth,
  concat_with_space('Week',CalendarWeek, 1) AS CalendarWeek,
  CalendarYear,
  CalendarMonthName,
  SupAssignRunIsSimulation,
  SupAssgmtAggrgQtyUnit
FROM I_ARunReleaseCheckCube
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocCurrency ON DocumentCurrency = _DocCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ARunReleaseCheckText AS _ARunRCText ON ARunReleaseCheckRunUUID = _ARunRCText.ARunReleaseCheckRunUUID  -- association [0..1]
;