/DCO/I_AccountingDocumentVH

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 /DCO/I_AccountingDocumentVH.
-- 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 /DCO/I_AccountingDocumentVH AS
SELECT
  DCoAccountingDocumentID,
  BusinessPartner,
  _CompanyCodeMapping.DebtCollectionsCompanyCode AS DebtCollectionsCompanyCode,
  CompanyCode,
  DCoAccountingDocumentOrigin,
  _RblPyblTransactionItem.PostingClassification AS PostingClassification,
  _RblPyblTransactionItem.PostingSubclassification AS PostingSubclassification,
  _RblPyblTransactionItem.PaymentDifferenceReason AS PaymentDifferenceReason,
  DCoAccountingDocumentDate,
  DCoAcctgDocOriginalDueDate,
  DCoAccountingDocumentDueDate,
  DCoAcctgDocLastPaymentDate,
  DCoAccountingDocumentCurrency,
  DCoAcctgDocumentOriginalAmount,
  DCoAcctgDocumentOpenAmount,
  DCoAcctgDocumentPaidAmount,
  DCoAcctgDocumentCreditedAmount,
  DCoAcctgDocWriteOffAmount,
  DCoAcctgDocCshDiscUsedAmount,
  DCoAccountingDocumentBranch,
  DCoDocumentReference,
  DCoAltvDocumentReference,
  DCoAcctgDocumentReference1ID,
  DCoAcctgDocumentReference2ID,
  DCoAcctgDocumentReference3ID,
  DCoAcctgDocIsBlockedForPayment,
  DCoAccountingDocumentIsCleared,
  DCoAcctgDocHierarchyLevelValue,
  DCoAcctgDocumentIsReversed,
  DCoOriginalReferenceDocument,
  DCoOriglReferenceDocumentType,
  DCoAcctgDocumentLogicalSystem,
  cast ( _AcctgDocumentLastChangedBy.UserDescription as /dco/acctg_doc_last_chng_usn ) AS DCoAcctgDocLastChgdByUsrName,
  cast ( _AccountingDocumentCreatedBy.UserDescription as /dco/acctg_doc_crtn_user_name ) AS DCoAcctgDocCreationUserName,
  cast ( _BranchAccount.BusinessPartnerName as /dco/acctg_doc_branch_name ) AS DCoAcctgDocumentBranchName,
  cast ( _AccountingDocumentCurrency._Text[ 1:Language = $session.system_language ].CurrencyName as /dco/acctg_doc_currency_name ) AS DCoAcctgDocumentCurrencyName,
  _RblPyblTransactionItem._PaymentDifferenceReason._Text[ 1:Language = $session.system_language ].PaymentDifferenceReasonName AS PaymentDifferenceReasonName,
  _RblPyblTransactionItem._PostingSubclassification._Text[ 1:Language = $session.system_language ].PostingSubclassificationName AS PostingSubclassificationName,
  _RblPyblTransactionItem._PostingClass._Text[ 1:Language = $session.system_language ].PostingClassificationName AS PostingClassificationName,
  _CompanyCode._Text[ 1:Language = $session.system_language ].CompanyCodeDescription AS CompanyCodeDescription,
  _CompanyCodeMapping._CompanyCode._Text[ 1:Language = $session.system_language ].DCoCompanyCodeName AS DCoCompanyCodeName,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName
FROM /DCO/I_AccountingDocument
;