I_PaymentProposalForm

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_PaymentProposalForm.
-- 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: IPAYTPRPSLFORM
-- Parameters: P_Language : sylangu, P_PaymentRunDate : laufd, P_PaymentRunID : laufi, P_PaymentRunIsProposal : xvorl, P_CompanyCode : fis_bukrs

CREATE VIEW I_PaymentProposalForm AS
SELECT
  cast (header.PaymentRunDate as laufd) AS PaymentRunDate,
  header.PaymentRunID AS PaymentRunID,
  header.PaymentRunIsProposal AS PaymentRunIsProposal,
  header.PayingCompanyCode AS PayingCompanyCode,
  header.Supplier AS Supplier,
  header.Customer AS Customer,
  header.PaymentRecipient AS PaymentRecipient,
  header.PaymentDocument AS PaymentDocument,
  item.CompanyCode AS CompanyCode,
  item.AccountingDocument AS AccountingDocument,
  item.FiscalYear AS FiscalYear,
  item.AccountingDocumentItem AS AccountingDocumentItem,
  header.BankAccountHolderName AS BankAccountHolderName,
  header.HouseBank AS HouseBank,
  header.HouseBankAccount AS HouseBankAccount,
  header.PaymentMethod AS PaymentMethod,
  header.PaymentCurrency AS PaymentCurrency,
  header.PayeePaymentSystem AS PayeePaymentSystem,
  header.PayeeAliasType AS PayeeAliasType,
  header.PayeeAliasName AS PayeeAliasName,
  header._PayeePaymentSystem._Text[1:Language = $parameters.P_Language].PaymentSystemText AS PaymentSystemText,
  header._PayeeAliasType._Text[1:Language = $parameters.P_Language].AliasTypeText AS AliasTypeText,
  item.AccountingDocumentType AS AccountingDocumentType,
  item.PaymentTerms AS PaymentTerms,
  item.DocumentDate AS DocumentDate,
  item.PostingKey AS PostingKey,
  item.BusinessArea AS BusinessArea,
  header._Bank.BankName AS HouseBankName,
  header._HouseBankAccount._Text[1:Language = $parameters.P_Language].HouseBankAccountDescription AS HouseBankAccountDescription,
  cast(_PayingCompanyCode.CompanyCodeName as farp_zbukrstxt) AS PayingCompanyCodeName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Supplier.SupplierName AS SupplierName,
  _Customer.CustomerName AS CustomerName,
  header.BankPaymentGroupingOrigin AS BankPaymentGroupingOrigin,
  cast(header.PaidAmountInPaytCurrency as farp_rwbtr ) AS PaidAmountInPaytCurrency,
  cast(item.AmountInTransactionCurrency as farp_wrbtv) AS AmountInTransactionCurrency,
  cast(item.TotDeductionAmtInTransacCrcy as farp_wabzv) AS TotDeductionAmtInTransacCrcy,
  cast(item.NetAmountInTransacCurrency as farp_wnetv) AS NetAmountInTransacCurrency,
  header.CompanyCodeCurrency AS CompanyCodeCurrency,
  header.SWIFTTransactionReferenceUUID AS SWIFTTransactionReferenceUUID,
  cast(header.AmountInCompanyCodeCurrency as farp_rbetr ) AS PaytAmountInCoCodeCurrency,
  cast(header._PaytProposalItemAggregation.WhldgTaxAmtInCoCodeCrcy as farp_qstev) AS PaidWhldgTaxAmtInCoCodeCrcy,
  cast(header._PaytProposalItemAggregation.WhldgTaxAmtInTransacCrcy as farp_wqstv) AS WhldgTaxAmtInPaytCrcy,
  cast(header.CashDiscountAmtInCoCodeCrcy as farp_rskon ) AS PaidCashDiscountInCoCodeCrcy,
  cast(header.CashDiscountAmtInTransacCrcy as farp_wskto) AS CashDiscountAmountInPaytCrcy,
  cast(header.LostCashDiscountInCoCodeCrcy as farp_skvhw) AS LostCshDiscAmtInDspCrcy,
  cast(header.LostCashDiscountInTransacCrcy as farp_skvfw) AS LostCashDiscountInPaytCrcy,
  item.AssignmentReference AS AssignmentReference,
  item.DocumentReferenceID AS AccountingDocExternalReference,
  cast(item.HeaderAmtInCoCodeCurrency as farp_dmbtv) AS GrossAmountInCoCodeCurrency,
  cast(item.WhldgTaxAmtInCoCodeCrcy as farp_qstev) AS WhldgTaxAmtInCoCodeCrcy,
  cast(item.WhldgTaxAmtInTransacCrcy as farp_wqstv) AS WhldgTaxAmtInTransacCrcy,
  cast(item.CashDiscountAmtInCoCodeCrcy as farp_rskon) AS CashDiscountAmtInCoCodeCrcy,
  cast(item.CashDiscountAmtInTransacCrcy as farp_wskto) AS CashDiscountAmtInTransacCrcy
FROM I_PaymentProposalHeader AS header
INNER JOIN I_PaymentProposalItem AS item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PayingCompanyCode ON PayingCompanyCode = _PayingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON PaymentCurrency = _PaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
;