I_PT_SAFTSettlementMgmtHeader

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_PT_SAFTSettlementMgmtHeader.
-- 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: IPTSAFTSMHEADER

CREATE VIEW I_PT_SAFTSettlementMgmtHeader AS
SELECT
  DigitalSignature.CompanyCode AS CompanyCode,
  DigitalSignature.SettlementDocInvoiceNumber AS PortugueseInvoiceNumber,
  DigitalSignature.InvoiceDate AS PortugueseInvoiceDate,
  SettlmtMgmtHeader.SettlmtMgmtDoc AS SettlmtMgmtDoc,
  SettlmtMgmtHeader._PayerParty.Customer AS Customer,
  SettlmtMgmtHeader._PayerParty.IsOneTimeAccount AS IsOneTimeAccount,
  SettlmtMgmtHeader.FiscalPeriod AS FiscalPeriod,
  ' ' AS DocumentTransaction,
  SettlmtMgmtHeader.SettlmtMgmtDocIsCancelled AS SettlmtMgmtDocIsCancelled,
  SettlmtMgmtHeader.CancelledSettlmtMgmtDoc AS CancelledSettlmtMgmtDoc,
  SettlmtMgmtHeader.DocumentBillingStatus AS DocumentBillingStatus,
  SettlmtMgmtHeader.SettlmtDocType AS SettlmtDocType,
  SettlmtMgmtHeader.CreatedByUser AS CreatedByUser,
  SettlmtMgmtHeader.LastChangeDate AS LastChangeDate,
  SettlmtMgmtHeader.SettlmtDocActivityReason AS SettlmtDocActivityReason,
  'P' AS SourceBillingDocumentType,
  DigitalSignature.PortugueseDigitalSignature AS PortugueseDigitalSignature,
  DigitalSignature.PortugueseDgtlSgntrKeyVersion AS PortugueseDgtlSgntrKeyVersion,
  SettlmtMgmtHeader.CreationDateTime AS CreationDateTime,
  SettlmtMgmtHeader.SettlmtDate AS SettlmtDate,
  DigitalSignature.PortugueseDigitalSignatureDate AS PortugueseDgtlSgntrDocChgDate,
  SettlmtMgmtHeader.CustomerPaymentTerms AS CustomerPaymentTerms,
  _Customer.PortugueseCustomerWithVersion AS PortugueseCustomerWithVersion,
  _Customer.Country AS VATRegistrationCountry,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  DigitalSignature.TotalGrossAmount AS TotalGrossAmount,
  case when SettlmtMgmtHeader.SettlmtDocCurrency <> _CompanyCode.Currency and SettlmtMgmtHeader.SettlmtDocCurrency is not initial then SettlmtMgmtHeader.ExchangeRate else 0 end as ExchangeRate AS ExchangeRateelse0endasExchangeRate,
  SettlmtMgmtHeader.AuthorizationGroup AS AuthorizationGroup,
  cast( case when SettlmtMgmtHeader.SettlmtDocCurrency = CompanyCode.Currency then coalesce(abs(SettlmtMgmtHeader.CustomerTotalNetAmount),0) else case when SettlmtMgmtHeader.ExchangeRate < 0 then abs(division(SettlmtMgmtHeader.CustomerTotalNetAmount ,ExchangeRate,7)) else abs(SettlmtMgmtHeader.CustomerTotalNetAmount * SettlmtMgmtHeader.ExchangeRate) end end as abap.dec(28,7)) as TotalNetAmount AS dec287asTotalNetAmount,
  cast( case when SettlmtMgmtHeader.SettlmtDocCurrency = CompanyCode.Currency then coalesce(abs(SettlmtMgmtHeader.CustomerTotalTaxAmount ),0) else case when SettlmtMgmtHeader.ExchangeRate < 0 then abs(division(SettlmtMgmtHeader.CustomerTotalTaxAmount,ExchangeRate,7)) else abs(SettlmtMgmtHeader.CustomerTotalTaxAmount * ExchangeRate) end end as abap.dec(28,7)) as TotalTaxAmount AS dec287asTotalTaxAmount,
  SettlmtMgmtHeader.CashDiscount1Days AS CashDiscount1Days,
  SettlmtMgmtHeader.CashDiscount2Days AS CashDiscount2Days,
  SettlmtMgmtHeader.CustomerPaymentTermsName AS CustomerPaymentTermsName,
  DigitalSignature.PT_SeriesDocumentNumber AS PT_SeriesDocumentNumber,
  DigitalSignature.PT_SeriesDocumentType AS PT_SeriesDocumentType,
  _CompanyCode._Currency AS _Currency
FROM I_SAFTSettlementMgmtHeader AS SettlmtMgmtHeader
INNER JOIN I_PT_SettlmtDocsDgtlSgntr AS DigitalSignature ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PT_SAFTSettlmtMgmtCustomer AS _Customer ON SettlmtMgmtHeader.SettlmtMgmtDoc = _Customer.SettlmtMgmtDoc AND DigitalSignature.CompanyCode = _Customer.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON DigitalSignature.CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;