P_ACMApplicationLatestVersion

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_ACMApplicationLatestVersion.
-- 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: PACMAPPLATESTVER

CREATE VIEW P_ACMApplicationLatestVersion AS
SELECT
  LatestAppVersion.ContractApplicationUUID AS ContractApplicationUUID,
  LatestAppVersion.ContractApplicationVersion AS ContractApplicationVersion,
  ApplicationData.contract_num AS ContractNum,
  ApplicationData.contract_item AS ContractItem,
  ApplicationData.commodity_item AS ContractCommodityItem,
  ApplicationData.refdoc_type AS ReferenceDocumentType,
  ApplicationData.appl_status AS ContractApplicationStatus,
  ApplicationData.appl_qty AS Quantity,
  ApplicationData.eval_qty AS EvaulatedQuantity,
  ApplicationData.umrez AS ConversionFactorNmrtrValue,
  ApplicationData.umren AS ConversionFactorDnmntrValue,
  ApplicationData.trade_unit AS UnitOfMeasure,
  cascai.appl_objnr AS ContractApplStatusObject,
  ApplicationData.adjusted_qty AS AdjustedQuantity,
  ApplicationData.delivery_date AS DeliveryDate,
  ApplicationData.refdoc AS ReferenceApplicationDocument,
  ApplicationData.refdoc_item AS ReferenceApplicationItem,
  ApplicationData.refdoc_side AS ReferenceApplicationSide,
  ApplicationData.refdoc_sub_item AS ReferenceApplicationSubItem,
  ApplicationData.refdoc_type AS ReferenceApplicationType,
  case when ApplicationData.overfill_qty_dec <> 0 then ApplicationData.overfill_qty_dec when ApplicationData.overfill_pro_dec <> 0 then ApplicationData.overfill_pro_dec else ApplicationData.overfill_qty_dec end as ACMOverfillQuantity AS overfill_qty_decendasACMOverfillQuantity,
  ApplicationData.uom AS TrdgContractApplUnitOfMeasure,
  ApplicationData.changed_by AS ChangedBy,
  ApplicationData.changed_on AS ChangedOn,
  ApplicationData.created_by AS CreatedBy,
  ApplicationData.created_on AS CreatedOn,
  ApplicationData.qrep_guid AS ACMRepositoryWeightAppUUID,
  ApplicationData.qrep_version AS LatestGroupVersion
FROM P_ApplicationLatestVersion1 AS LatestAppVersion
INNER JOIN /accgo/t_appdata AS ApplicationData ON /* join condition not captured in parsed metadata */
INNER JOIN /accgo/t_cas_cai AS cascai ON /* join condition not captured in parsed metadata */
;