C_JrnlEntryCorrespnc

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_JrnlEntryCorrespnc.
-- 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: CJRNLENCOR

CREATE VIEW C_JrnlEntryCorrespnc AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentType,
  _AccountingDocumentTypeText[1:Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  DocumentDate,
  PostingDate,
  FiscalPeriod,
  AccountingDocumentCreationDate,
  CreationTime,
  LastManualChangeDate,
  LastAutomaticChangeDate,
  LastChangeDate,
  ExchangeRateDate,
  AccountingDocCreatedByUser,
  TransactionCode,
  IntercompanyTransaction,
  DocumentReferenceID,
  RecurringAccountingDocument,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  AccountingDocumentHeaderText,
  TransactionCurrency,
  ExchangeRate,
  AccountingDocumentCategory,
  BusinessTransactionType,
  BatchInputSession,
  ReferenceDocumentType,
  _ReferenceDocumentTypeText[1:Language = $session.system_language].ReferenceDocumentTypeName AS ReferenceDocumentTypeName,
  OriginalReferenceDocument,
  FinancialManagementArea,
  CompanyCodeCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  ReversalIsPlanned,
  PlannedReversalDate,
  TaxIsCalculatedAutomatically,
  TaxBaseAmountIsNetAmount,
  SourceCompanyCode,
  LogicalSystem,
  ReferenceDocumentLogicalSystem,
  TaxExchangeRate,
  ReversalReason,
  ParkingDate,
  ParkingTime,
  Branch,
  NmbrOfPages,
  IsDiscountDocument,
  Reference1InDocumentHeader,
  Reference2InDocumentHeader,
  InvoiceReceiptDate,
  Ledger,
  LedgerGroup,
  cast(AlternativeReferenceDocument as fis_xblnr_alt_alpha) AS AlternativeReferenceDocument,
  TaxReportingDate,
  AccountingDocumentClass,
  ExchangeRateType,
  SenderLogicalSystem,
  SenderCompanyCode,
  SenderAccountingDocument,
  SenderFiscalYear,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  LatePaymentReason,
  SalesDocumentCondition,
  IsReversal,
  IsReversed,
  Ledger AS SourceLedger,
  _CompanyCode.ControllingArea AS ControllingArea,
  _CompanyCode._ControllingAreaText.ControllingAreaName AS ControllingAreaName
FROM I_JournalEntry
LEFT OUTER JOIN C_JrnlEntryItemCorrespnc AS _Item ON AccountingDocument = _Item.AccountingDocument AND CompanyCode = _Item.CompanyCode AND FiscalYear = _Item.FiscalYear  -- association [1..*]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_ReferenceDocumentTypeText AS _ReferenceDocumentTypeText ON ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType  -- association [0..*]
LEFT OUTER JOIN I_CurrencyTypesCorrespnc AS _CurrencyTypesCorrespnc ON CompanyCode = _CurrencyTypesCorrespnc.CompanyCode AND SourceLedger = _CurrencyTypesCorrespnc.Ledger  -- association [1..1]
LEFT OUTER JOIN C_CorrespondenceHeaderNote AS _CorrespondenceHeaderNote ON CompanyCode = _CorrespondenceHeaderNote.CompanyCode AND FiscalYear = _CorrespondenceHeaderNote.FiscalYear AND AccountingDocument = _CorrespondenceHeaderNote.AccountingDocument  -- association [0..*]
;