I_PRAIntrstDetAcctgDoc

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_PRAIntrstDetAcctgDoc.
-- 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.

CREATE VIEW I_PRAIntrstDetAcctgDoc AS
SELECT
  int_doc_link_guid AS PRAIntrstRevnAcctgDocLinkUUID,
  int_dtl_link_guid AS PRAInterestCalcDetailUUID,
  run_id AS ProcessRun,
  cast( bukrs as fis_bukrs preserving type ) AS CompanyCode,
  cast (acct_period as oiu_vdm_acct_period ) AS PRAAccountingPeriod,
  doc_no AS AccountingDocument,
  line_no AS ValnDocAcctgItem,
  status AS PRAInterestCalculationStatus
FROM /pra/int_dtl_doc
LEFT OUTER JOIN I_PRAAcctgDocDetail AS _PRAAcctgDocDetail ON CompanyCode = _PRAAcctgDocDetail.CompanyCode AND PRAAccountingPeriod = _PRAAcctgDocDetail.FiscalPeriod AND AccountingDocument = _PRAAcctgDocDetail.AccountingDocument AND ValnDocAcctgItem = _PRAAcctgDocDetail.AccountingDocumentItem  -- association [0..1]
;