C_MrkdDeltnSuplrOpenItem

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 C_MrkdDeltnSuplrOpenItem.
-- 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: CGRCDELSUPOPNITM

CREATE VIEW C_MrkdDeltnSuplrOpenItem AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument AS JournalEntry,
  AccountingDocumentItem,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  AmountInCompanyCodeCurrency,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  GLAccount,
  AccountingDocumentType,
  PostingDate,
  _FiscalYearPeriodForCmpnyCode.FiscalYearPeriod AS FiscalYearPeriod,
  _JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _JournalEntry.TransactionCode AS TransactionCode,
  _JournalEntry.ReverseDocument AS ReverseDocument,
  _JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  AccountingDocumentCategory,
  ReferenceDocumentType,
  CompanyCodeCurrency,
  ChartOfAccounts,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  ProfitCenter,
  CostCenter,
  DocumentDate,
  _JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _JournalEntry.LastChangeDate AS LastChangeDate,
  PostingKey,
  SpecialGLCode,
  SpecialGLTransactionType,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _FiscalYearPeriodForCmpnyCode.FiscalYearVariant AS FiscalYearVariant,
  FiscalPeriod,
  DebitCreditCode,
  FinancialAccountType,
  Customer,
  IsCompletelyDelivered,
  ClearingIsReversed,
  IsSalesRelated,
  IsUsedInPaymentTransaction
FROM I_OperationalAcctgDocItem
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalYearPeriodForCmpnyCode ON CompanyCode = _FiscalYearPeriodForCmpnyCode.CompanyCode AND FiscalYear = _FiscalYearPeriodForCmpnyCode.FiscalYear AND FiscalPeriod = _FiscalYearPeriodForCmpnyCode.FiscalPeriod  -- association [1..1]
;