P_SalesContractProcessFlow0

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_SalesContractProcessFlow0.
-- 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: PSLSCONTRPROCF0
-- Parameters: P_SalesContract : vbeln_von

CREATE VIEW P_SalesContractProcessFlow0 AS
SELECT
  SalesContractItem.SalesContract AS SalesContract,
  SalesContractItem.SalesContractItem AS SalesContractItem,
  cast( 'G' as vbtypl ) AS SDDocumentCategory,
  SalesContractItem.TargetQuantity AS QuantityInBaseUnit,
  SalesContractItem.TargetQuantityUnit AS BaseUnit,
  SalesContractItem.NetAmount AS NetAmount,
  SalesContractItem.TransactionCurrency AS StatisticsCurrency,
  cast( '' as status_bez ) AS SDProcessStatusDesc,
  cast( '0000' as gjahr ) AS FiscalYear,
  cast( '' as bukrs ) AS CompanyCode,
  cast( '0000' as mjahr ) AS MaterialDocumentYear,
  cast( 'SalesContract' as bpf_sem_obj ) AS SemanticObject,
  _SDDocumentCategory._Text[1:Language=$session.system_language].SDDocumentCategoryName AS SDDocumentCategoryName,
  _SalesContract.CreationDate AS CreationDate,
  _SalesContract.CreationTime AS CreationTime
FROM I_SalesContractItem AS SalesContractItem
INNER JOIN I_SalesContract AS _SalesContract ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _StatisticsCurrency ON StatisticsCurrency = _StatisticsCurrency.Currency  -- association [0..1]
;