P_PrepayBarterRefDocAmtDetTC

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 P_PrepayBarterRefDocAmtDetTC.
-- 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.
-- Parameters: P_Currency : waers, P_Date : dats

CREATE VIEW P_PrepayBarterRefDocAmtDetTC AS
SELECT
  DocTotAmt.PrepaymentAgrmtWorkCenterType AS PrepaymentAgrmtWorkCenterType,
  DocTotAmt.PrepaymentAgrmtRefDocumentCat AS PrepaymentAgrmtRefDocumentCat,
  DocTotAmt.PrepaymentAgrmtRefBusObject AS PrepaymentAgrmtRefBusObject,
  DocTotAmt.DocNumber AS DocNumber,
  DocTotAmt.DocumentItemNumber AS DocumentItemNumber,
  DocTotAmt.PrepaymentAgrmtRefDocument AS PrepaymentAgrmtRefDocument,
  DocTotAmt.Material AS Material,
  DocTotAmt.TrdgContrApplicationStatus AS TrdgContrApplicationStatus,
  DocTotAmt.Commodity AS Commodity,
  DocTotAmt.TradingContractItemQuantity AS TradingContractItemQuantity,
  DocTotAmt.TrdgContractItemUnitOfMeasure AS TrdgContractItemUnitOfMeasure,
  DocTotAmt.PurchasingDocumentItem AS PurchasingDocumentItem,
  DocTotAmt.CompanyCode AS CompanyCode,
  DocTotAmt.Counterparty AS Counterparty,
  DocTotAmt.DocumentType AS DocumentType,
  $parameters.P_Currency AS PrepaymentTotalAmtCrcy,
  cast( case when DocTotAmt.PrepaymentTotalAmtCrcy <> $parameters.P_Currency then currency_conversion(amount => curr_to_decfloat_amount(DocTotAmt.PrepaymentTotalAmt), source_currency => DocTotAmt.PrepaymentTotalAmtCrcy, target_currency => $parameters.P_Currency, exchange_rate_date => $parameters.P_Date, error_handling => 'SET_TO_NULL') when DocTotAmt.PrepaymentTotalAmtCrcy = $parameters.P_Currency then curr_to_decfloat_amount( DocTotAmt.PrepaymentTotalAmt ) else 0 end as abap.dec(23,2) ) as PrepaymentTotalAmt AS dec232asPrepaymentTotalAmt,
  DocTotAmt.PrepaymentTotalAmt AS PrepaymentAgreementAmount,
  DocTotAmt.PrepaymentTotalAmtCrcy AS PrepaymentAgreementCurrency,
  DocTotAmt.PrepaymentTotalAmtIsFixedPrice AS PrepaymentTotalAmtIsFixedPrice,
  cast(cast(coalesce(curr_to_decfloat_amount(Barter_TCDocAmt(P_Currency : $parameters.P_Currency, P_Date : $parameters.P_Date).PrepaymentAgrmtLinkAmount), 0) as abap.dec(23,2)) as abap.curr(23,2)) as PrepaymentAgrmtLinkAmount AS curr232asPrepaymentAgrmtLinkAmount,
  Barter_TCDocAmt(P_Currency : $parameters.P_Currency, P_Date : $parameters.P_Date).PrepaymentAgreement AS PrepaymentAgreement,
  Barter_TCDocAmt(P_Currency : $parameters.P_Currency, P_Date : $parameters.P_Date).PrepaymentDocumentItemNumber AS PrepaymentDocumentItemNumber,
  case when DocTotAmt.PrepaymentTotalAmtCrcy <> $parameters.P_Currency then cast('M' as abap.char(4)) else cast(' ' as abap.char(4)) end as ExchangeRateType AS char4endasExchangeRateType,
  case when DocTotAmt.PrepaymentTotalAmtCrcy <> $parameters.P_Currency then cast($parameters.P_Date as abap.dats) else cast('00000000' as abap.dats) end as ExchangeRateDate AS datsendasExchangeRateDate,
  case when DocTotAmt.PrepaymentTotalAmtCrcy <> $parameters.P_Currency then XRate(P_Date : $parameters.P_Date).ExchangeRate.AlternativeExchangeRateType else cast(' ' as abap.char(4)) end as AlternativeExchangeRateType AS char4endasAlternativeExchangeRateType,
  coalesce(PaymentTerms.PrepaymentRequestDocNumber, '') AS PrepaymentRequestDocNumber,
  Barter_TCDocAmt
FROM P_PrepayBarterRefDocTotAmtTC AS DocTotAmt
LEFT OUTER JOIN I_PrepayBarterTrdgContrLinkAmt AS Barter_TCDocAmt ON Barter_TCDocAmt.DocNumber = PrepaymentAgrmtRefDocument AND Barter_TCDocAmt.DocumentItemNumber = DocumentItemNumber  -- association [0..1]
LEFT OUTER JOIN P_PrepaymentRefDocExchangeRate AS XRate ON XRate.ExchangeRateType = 'M' AND XRate.SourceCurrency = DocTotAmt.PrepaymentTotalAmtCrcy AND XRate.TargetCurrency = $parameters.P_Currency  -- association [0..1]
;