P_PurcContractLeakagePC

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 P_PurcContractLeakagePC.
-- 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: PMMCONTRLEAKGPC
-- Parameters: P_PurchaseContract : ebeln

CREATE VIEW P_PurcContractLeakagePC AS
SELECT
  PurchaseContractItem.PurchaseContract AS PurchaseContract,
  PurchaseContractItem.PurchaseContractItem AS PurchaseContractItem,
  concat( cast(PurchaseContract.ValidityStartDate as abap.char( 8 )),PurchaseContractItemUniqueID ) AS identifier,
  TargetAmount,
  TargetQuantity,
  ReleaseDocumentationValues.ReleaseOrderItemNetAmount AS ReleaseOrderItemNetAmount,
  ReleaseDocumentationValues.ReleaseOrderItemOrderQuantity AS ReleaseOrderItemOrderQuantity,
  PurchaseContractItem.ContractNetPriceAmount AS ContractNetPriceAmount,
  PurchaseContract.DocumentCurrency AS DocumentCurrency,
  PurchaseContractItem.Material AS Material,
  PurchaseContractItem.MaterialGroup AS MaterialGroup,
  PurchaseContract.Supplier AS Supplier,
  PurchaseContract.CompanyCode AS CompanyCode,
  PurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  PurchaseContract.PurchasingGroup AS PurchasingGroup,
  PurchaseContractItem.Plant AS ContractPlant,
  PurchaseContract.ValidityStartDate AS ValidityStartDate,
  PurchaseContract.ValidityEndDate AS ValidityEndDate,
  PurchaseContract.CreationDate AS CreationDate,
  cast( case when PurContractClassification.PurchaseContractClassification = '0' then case when ReleaseDocumentationValues.ReleaseOrderItemNetAmount is null or ReleaseDocumentationValues.ReleaseOrderItemNetAmount = 0.000 then TargetAmount else TargetAmount - ReleaseDocumentationValues.ReleaseOrderItemNetAmount end else case when ReleaseDocumentationValues.ReleaseOrderItemOrderQuantity is null or ReleaseDocumentationValues.ReleaseOrderItemOrderQuantity = 0.00 then ContractNetPriceAmount * TargetQuantity else ContractNetPriceAmount * ( TargetQuantity - ReleaseDocumentationValues.ReleaseOrderItemOrderQuantity) end end as abap.curr(21,5)) as UnreleasedAmount AS curr215asUnreleasedAmount
FROM I_PurchaseContractItem AS PurchaseContractItem
INNER JOIN I_PurchaseContract AS PurchaseContract ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurContractClassification AS PurContractClassification ON /* join condition not captured in parsed metadata */
;