C_CFinPndgTransMsg_F7149

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_CFinPndgTransMsg_F7149.
-- 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 C_CFinPndgTransMsg_F7149 AS
SELECT
  m.CFinRpldTransactionUUID AS CFinRpldTransactionUUID,
  m.CFinRpldTransMsgSerialNumber AS CFinRpldTransMsgSerialNumber,
  m.CFinRpldTransNamespace AS CFinRpldTransNamespace,
  m.CFinRpldTransInterfaceName AS CFinRpldTransInterfaceName,
  m.CFinRpldTransInterfaceVersion AS CFinRpldTransInterfaceVersion,
  d.SenderLogicalSystem AS SenderLogicalSystem,
  d.SenderCompanyCode AS SenderCompanyCode,
  d.SenderAccountingDocument AS SenderAccountingDocument,
  d.SenderFiscalYear AS SenderFiscalYear,
  m.CFinRpldTransactionStatus AS CFinRpldTransactionStatus,
  m.SystemMessageType AS SystemMessageType,
  m.SystemMessageClass AS SystemMessageClass,
  m.SystemMessageNumber AS SystemMessageNumber,
  m.SystemMessageVariable1 AS SystemMessageVariable1,
  m.SystemMessageVariable2 AS SystemMessageVariable2,
  m.SystemMessageVariable3 AS SystemMessageVariable3,
  m.SystemMessageVariable4 AS SystemMessageVariable4,
  m.SystemMessageTemplateText AS SystemMessageTemplateText,
  m.SystemMessageText AS SystemMessageText,
  d._Transaction.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  d._Transaction.SourceReferenceDocument AS SourceReferenceDocument,
  d._Transaction.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  d._Transaction.SourceRefDocLogicalSystem AS SourceRefDocLogicalSystem,
  d._Transaction.CFinRpldTransCreationDateTime AS CFinRpldTransCreationDateTime,
  d._Transaction.TransactionCode AS TransactionCode,
  d.CompanyCode AS CompanyCode,
  d._CompanyCode.CompanyCodeName AS CompanyCodeName,
  d.FiscalYear AS FiscalYear,
  d.AccountingDocumentType AS AccountingDocumentType,
  d._AccountingDocumentTypeText[1:Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  d.DocumentDate AS DocumentDate,
  d.PostingDate AS PostingDate,
  d.TotalAmountInLocalCurrency AS TotalAmountInLocalCurrency,
  d.CompanyCodeCurrency AS CompanyCodeCurrency,
  d.TotalAmountInGroupCrcy AS TotalAmountInGroupCrcy,
  d.GroupCurrency AS GroupCurrency,
  d.CFinPndgDocHasTemporaryPosting AS CFinPndgDocHasTemporaryPosting,
  d.CFinTemporaryPosting AS CFinTemporaryPosting,
  cast( '1' as fins_cfin_number_of_messages ) AS NumberOfSystemMessages
FROM I_CFinPndgTransactionDocument AS d
LEFT OUTER JOIN C_CFinPndgTransaction_F5482 AS _Transaction ON CFinRpldTransactionUUID = _Transaction.CFinRpldTransactionUUID  -- association [1..1]
LEFT OUTER JOIN C_CFinPndgTransDocument_F5482 AS _TransactionDocument ON CFinRpldTransactionUUID = _TransactionDocument.CFinRpldTransactionUUID AND SenderLogicalSystem = _TransactionDocument.SenderLogicalSystem AND SenderCompanyCode = _TransactionDocument.SenderCompanyCode AND SenderAccountingDocument = _TransactionDocument.SenderAccountingDocument AND SenderFiscalYear = _TransactionDocument.SenderFiscalYear  -- association [1..1]
;