P_PaymentProposalItem

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_PaymentProposalItem.
-- 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: PPAYTPRPSLITM

CREATE VIEW P_PaymentProposalItem AS
SELECT
  laufd AS PaymentRunDate,
  laufi AS PaymentRunID,
  xvorl AS PaymentRunIsProposal,
  zbukr AS PayingCompanyCode,
  lifnr AS Supplier,
  kunnr AS Customer,
  empfg AS PaymentRecipient,
  vblnr AS PaymentDocument,
  bukrs AS CompanyCode,
  belnr AS AccountingDocument,
  gjahr AS FiscalYear,
  cast (buzei as abap.int2 ) AS AccountingDocumentItem,
  gsber AS BusinessArea,
  blart AS AccountingDocumentType,
  bldat AS DocumentDate,
  zfbdt AS DueCalculationBaseDate,
  zterm AS PaymentTerms,
  bschl AS PostingKey,
  waers AS PaymentCurrency,
  poken AS PaymentRunItemMessageNumber,
  zlsch AS PaymentMethod,
  zlspr AS PaymentBlockingReason,
  xblnr AS DocumentReferenceID,
  kidno AS PaymentReference,
  vertn AS AssetContract,
  budat AS PostingDate,
  sgtxt AS DocumentItemText,
  umskz AS SpecialGLCode,
  case shkzg when 'H' then cast(-wrbtr as abap.curr( 23, 2 )) else cast(wrbtr as abap.curr( 23, 2 )) end as AmountInTransactionCurrency AS curr232endasAmountInTransactionCurrency,
  case shkzg when 'H' then cast(-wskto as abap.curr( 23, 2 )) else cast(wskto as abap.curr( 23, 2 )) end as CashDiscountAmtInTransacCrcy AS curr232endasCashDiscountAmtInTransacCrcy,
  case shkzg when 'H' then cast(-sknto as abap.curr( 23, 2 )) else cast(sknto as abap.curr( 23, 2 )) end as CashDiscountAmtInCoCodeCrcy AS curr232endasCashDiscountAmtInCoCodeCrcy,
  zbd1t AS CashDiscount1Days,
  zbd2t AS CashDiscount2Days,
  zbd2p AS CashDiscount2Percent,
  case shkzg when 'H' then cast(-qbshb as abap.curr( 23, 2 )) else cast(qbshb as abap.curr( 23, 2 )) end as WhldgTaxAmtInTransacCrcy AS curr232endasWhldgTaxAmtInTransacCrcy,
  case shkzg when 'H' then cast(-qbshh as abap.curr( 23, 2 )) else cast(qbshh as abap.curr( 23, 2 )) end as WhldgTaxAmtInCoCodeCrcy AS curr232endasWhldgTaxAmtInCoCodeCrcy,
  case shkzg when 'H' then cast(-wskto - qbshb as abap.curr( 23, 2 )) else cast(wskto + qbshb as abap.curr( 23, 2 )) end as TotDeductionAmtInTransacCrcy AS curr232endasTotDeductionAmtInTransacCrcy,
  case shkzg when 'H' then cast(-sknto - qbshh as abap.curr( 23, 2 )) else cast(sknto + qbshh as abap.curr( 23, 2 )) end as TotDeductionAmtInCoCodeCrcy AS curr232endasTotDeductionAmtInCoCodeCrcy,
  case shkzg when 'H' then cast(-wrbtr - (-wskto - qbshb) as abap.curr( 23, 2 )) else cast(wrbtr - (wskto + qbshb) as abap.curr( 23, 2 )) end as NetAmountInTransacCurrency AS curr232endasNetAmountInTransacCurrency,
  case shkzg when 'H' then cast(-dmbtr - (-sknto - qbshh) as abap.curr( 23, 2 )) else cast(dmbtr - (sknto + qbshh) as abap.curr( 23, 2 )) end as NetAmountInCoCodeCurrency AS curr232endasNetAmountInCoCodeCurrency,
  case shkzg when 'H' then cast(-dmbtr as abap.curr( 23, 2 )) else cast(dmbtr as abap.curr( 23, 2 )) end as AmountInCompanyCodeCurrency AS curr232endasAmountInCompanyCodeCurrency,
  cast(mshbt as abap.curr( 23, 2 )) AS MaxCshDiscAmtInCoCodeCrcy,
  cast(msfbt as abap.curr( 23, 2 )) AS MaxCshDiscAmtInTransacCrcy,
  lzbkz AS StateCentralBankPaymentReason,
  landl AS SupplyingCountry,
  shkzg AS DebitCreditCode
FROM regup
;