I_PRAAccountingDocumentHdrDet

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_PRAAccountingDocumentHdrDet.
-- 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: IPVACCTGDOCHD

CREATE VIEW I_PRAAccountingDocumentHdrDet AS
SELECT
  bukrs AS CompanyCode,
  cast (acct_period as oiu_vdm_acct_period) AS PRAAccountingPeriod,
  doc_no AS AccountingDocument,
  document_desc AS DocumentDescription,
  system_src AS PRAOrigin,
  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,
  debit_amt AS TotalDebitAmount,
  credit_amt AS TotalCreditAmount,
  stat_amt AS TotalStatisticalAmount,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  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 PRAOrigin = _Origin.Origin  -- association [0..1]
LEFT OUTER JOIN I_PRAAccountingDocumentType AS _AccountingDocumentType ON PRAOrigin = _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]
LEFT OUTER JOIN I_Currency AS _Currency ON CompanyCodeCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PRAFiscalPeriod AS _PRAFiscalPeriod ON CompanyCode = _PRAFiscalPeriod.CompanyCode AND PRAAccountingPeriod = _PRAFiscalPeriod.FiscalPeriod  -- association [0..1]
;