I_ValuationDocumentHdr

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 I_ValuationDocumentHdr.
-- 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: IPVVALNDOCHDR

CREATE VIEW I_ValuationDocumentHdr AS
SELECT
  doc_year AS ValuationDocumentYear,
  doc_no AS ValuationDocumentNumber,
  dn_no AS DeliveryNetwork,
  sale_dt AS SalesDate,
  freq_cd AS AllocationFrequency,
  doc_status AS ValuationDocumentStatus,
  doc_type AS ValuationDocumentType,
  proc_status AS ProcessingStatus,
  run_date AS LastExecutionDate,
  run_time AS LastExecutionTime,
  cast( arch_flag as xarch ) AS DocumentIsArchived,
  cast( oiu_cruser as fclm_bam_created_by ) AS CreatedByUser,
  cast( 1 as oiu_vdm_no_of_docs ) AS NumberOfDocuments,
  cast( 'O3URV_DOC' as fqm_origin_trans_id ) AS OriginTransaction
FROM oiurv_doc_hdr
LEFT OUTER JOIN I_CalendarYear AS _ValuationDocumentYear ON ValuationDocumentYear = _ValuationDocumentYear.CalendarYear  -- association [0..1]
LEFT OUTER JOIN I_DeliveryNetwork AS _DeliveryNetwork ON DeliveryNetwork = _DeliveryNetwork.DeliveryNetwork  -- association [0..1]
LEFT OUTER JOIN I_AllocationFrequencyCode AS _AllocationFrequencyCode ON AllocationFrequency = _AllocationFrequencyCode.AllocationFrequency  -- association [0..1]
LEFT OUTER JOIN I_ValnDocProcessingStatus AS _ValnDocProcessingStatus ON ProcessingStatus = _ValnDocProcessingStatus.ProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_ValnDocStatus AS _ValnDocStatus ON ValuationDocumentStatus = _ValnDocStatus.ValuationDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_ValnDocType AS _ValnDocType ON ValuationDocumentType = _ValnDocType.ValuationDocumentType  -- association [0..1]
;