C_ValueContractReleaseSts

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

CREATE VIEW C_ValueContractReleaseSts AS
SELECT
  PurchaseContract.PurchaseContract AS PurchaseContract,
  PurchaseContract.Supplier AS Supplier,
  PurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  PurchaseContract.PurchasingGroup AS PurchasingGroup,
  PurchaseContract.CompanyCode AS CompanyCode,
  PurchasingDocumentCategory,
  PurchaseContract.PurchaseContractType AS PurchaseContractType,
  PurchaseContract.CreatedByUser AS CreatedByUser,
  Calendar.CalendarYear AS CalendarYear,
  Calendar.CalendarQuarter AS CalendarQuarter,
  Calendar.CalendarMonth AS CalendarMonth,
  Calendar.CalendarWeek AS CalendarWeek,
  cast( $parameters.P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  cast( ReleaseOrderItemNetAmount as mm_a_release_ord_net_amt_21_2 ) AS ReleaseOrderItemNetAmount
FROM I_PurchaseContract AS PurchaseContract
INNER JOIN I_PurContractClassification AS ContractClassification ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS Calendar ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ReleaseAmountInValueContract ON /* join condition not captured in parsed metadata */
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_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- 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_PurchasingDocumentCategory AS _PurchaseOrderCategory ON PurchasingDocumentCategory = _PurchaseOrderCategory.PurchasingDocumentCategory  -- association [1..1]
;