I_PRAAccountingDocumentHeader

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_PRAAccountingDocumentHeader.
-- 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: IPVACCTGDOCHDR

CREATE VIEW I_PRAAccountingDocumentHeader AS
SELECT
  cast ( bukrs as fis_bukrs ) AS CompanyCode,
  cast (acct_period as oiu_vdm_fis_period preserving type) AS FiscalPeriod,
  doc_no AS AccountingDocument,
  document_desc AS DocumentDescription,
  system_src AS Origin,
  doc_type AS AccountingDocumentType,
  ref_key AS OriginReferenceDocument,
  doc_status AS AccountingDocumentStatus,
  rvrs_doc_fl AS AccountingDocumentIsReversed,
  xcc_key AS AccountingDocumentCrossCoRef,
  post_dt AS PostingDate,
  doc_dt AS DocumentDate,
  cast( oiu_cruser as fclm_bam_created_by ) AS CreatedByUser,
  cast( oiu_timestamp as oiu_vdm_created_on_ts ) AS CreationDateTime,
  cast( change_user as fclm_bam_changed_by ) AS LastChangedByUser,
  cast( change_timestamp as oiu_vdm_changed_on_ts ) AS ChangedDateTime,
  cast( total_rec_cnt as oiu_vdm_no_of_items ) AS NumberOfItems,
  cast( rej_rec_cnt as oiu_vdm_no_of_rejected_items ) AS NumberOfRejectedItems,
  cast( 1 as oiu_vdm_no_of_docs) AS NumberOfDocuments
FROM /pra/acc_doc_hdr
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PRAApplicationOrigin AS _Origin ON Origin = _Origin.Origin  -- association [0..1]
LEFT OUTER JOIN I_PRAAccountingDocumentType AS _AccountingDocumentType ON Origin = _AccountingDocumentType.Origin AND AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_PRAAccountingDocStatus AS _AccountingDocumentStatus ON AccountingDocumentStatus = _AccountingDocumentStatus.AccountingDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _AccountingDocumentIsReversed ON AccountingDocumentIsReversed = _AccountingDocumentIsReversed.IndicatorValue  -- association [0..1]
;