C_QuantityContractAcctAssgmt

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_QuantityContractAcctAssgmt.
-- 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: CQTYCONTRACCT
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : vdm_validitystart, P_EndDate : vdm_validitystart

CREATE VIEW C_QuantityContractAcctAssgmt AS
SELECT
  PurchaseContractItem.PurchaseContract AS PurchaseContract,
  PurchaseContractItem.PurchaseContractItem AS PurchaseContractItem,
  AccountAssignmentNumber,
  ReleaseOrder,
  ReleaseOrderItem,
  concat(ReleaseOrder,ReleaseOrderItem) AS PurchaseOrderItemUniqueID,
  FormattedPurchaseContractItem,
  cast('1' as exbu_type ) AS DocNumber,
  Supplier,
  PurchaseContractItem.PurchasingGroup AS PurchasingGroup,
  PurchaseContractItem.PurchasingOrganization AS PurchasingOrganization,
  PurchaseContractItem.CompanyCode AS CompanyCode,
  PurchasingDocumentCategory,
  PurchaseContractType,
  PurchasingDocumentItemCategory,
  PurchaseContractItem.Material AS Material,
  PurchaseContractItem.MaterialGroup AS MaterialGroup,
  PurchaseContractItem.Plant AS Plant,
  CostCenter,
  cast(coalesce(PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory,'') as /srmsmc/purchasing_category_id) AS PurchasingCategory,
  case when PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName is null then _Doc.DomainText else PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName end as PurgCatName AS PurgCatNameendasPurgCatName,
  CreatedByUser,
  ValidityEndDate,
  RelevantDates.CalendarYear AS CalendarYear,
  RelevantDates.CalendarQuarter AS CalendarQuarter,
  RelevantDates.CalendarMonth AS CalendarMonth,
  RelevantDates.CalendarWeek AS CalendarWeek,
  PurchaseContractItem.DisplayCurrency AS DisplayCurrency,
  PurchaseContractItem.OrderQuantityUnit AS OrderQuantityUnit,
  PurchaseContractItem.TargetQuantity AS TargetQuantity,
  cast( ContractNetPriceAmount * AverageTargetQuantity as mm_a_target_amount ) AS TargetAmount,
  cast( ContractNetPriceAmount * TargetQuantity as mm_a_target_amount ) AS RelOrdLvlContractTargetAmount,
  cast(ReleaseOrderItemNetAmount as mm_a_release_ord_net_amt_21_2 ) AS ReleaseOrderItemNetAmount,
  cast( ContractNetPriceAmount * ReleaseOrderItemOrderQuantity as mm_a_release_ord_net_amt_21_2 ) AS ContrNetPrRltvReleasedAmount,
  ReleaseOrderItemOrderQuantity,
  cast(0 as mm_a_release_order_net_amount ) AS PredictedConsumptionAmount,
  cast ( '00000000' as mm_a_cntr_expiry_predict_date) AS ContractExpiryPredictedDate,
  cast(0 as abap.int4 ) AS PredictedDaysToContrExpiry,
  cast( 0 as abap.dec(15,2) ) AS PredictiveConsumptionInPct,
  cast(0 as abap.int4 ) AS NumberOfPurchaseOrders,
  P_StartDate:$parameters.P_StartDate AS P_StartDate
FROM P_QuantityContractAcctAssgmt
LEFT OUTER JOIN I_CalendarDate AS RelevantDates ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS PurchasingCategoryMatlGroup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_UNSGNDMATGRPTXT AS _Doc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON PurchaseContractType = _PurchasingDocumentType.PurchasingDocumentType AND PurchasingDocumentCategory = _PurchasingDocumentType.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchasingDocumentItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchaseOrderCategory ON PurchasingDocumentCategory = _PurchaseOrderCategory.PurchasingDocumentCategory  -- association [1..1]
-- UNION ALL with additional select branch(es): P_QuantityContractPrediction
;