I_PRAManualAccountingDocHdr

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_PRAManualAccountingDocHdr.
-- 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_PRAManualAccountingDocHdr AS
SELECT
  bukrs AS CompanyCode,
  cast (acct_period as oiu_vdm_acct_period ) AS PRAAccountingPeriod,
  doc_no AS AccountingDocument,
  doc_type AS AccountingDocumentType,
  ref_key AS OriginReferenceDocument,
  system_src AS PRAAcctgDocApplication,
  doc_status AS AccountingDocumentStatus,
  rvrs_doc_fl AS AccountingDocumentIsReversed,
  xcc_key AS AccountingDocumentCrossCoRef,
  total_rec_cnt AS NumberOfItems,
  rej_rec_cnt AS NumberOfRejectedItems,
  post_dt AS PostingDate,
  doc_dt AS DocumentDate,
  document_desc AS DocumentDescription,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime,
  change_user AS LastChangedByUser,
  change_timestamp AS ChangedDateTime
FROM /pra/acc_mdoc_hd
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PRAApplicationOrigin AS _Origin ON PRAAcctgDocApplication = _Origin.Origin  -- association [0..1]
LEFT OUTER JOIN I_PRAAccountingDocumentType AS _AccountingDocumentType ON PRAAcctgDocApplication = _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]
;