I_PaymentProposalHeader

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_PaymentProposalHeader.
-- 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: IPAYTPRPSLHDR

CREATE VIEW I_PaymentProposalHeader AS
SELECT
  cast( PaymentRunDate as farp_laufd ) AS PaymentRunDate,
  PaymentRunID,
  PaymentRunIsProposal,
  PayingCompanyCode,
  Supplier,
  Customer,
  PaymentRecipient,
  PaymentDocument,
  AccountByShipper AS SupplierClerkIDBySupplier,
  PayeeBankAccountHolderName AS BankAccountHolderName,
  HouseBankAccount,
  AccountingClerk,
  PaymentAmountInPaytCurrency AS PaidAmountInPaytCurrency,
  PaytAmountInCoCodeCurrency AS AmountInCompanyCodeCurrency,
  PayeeBankControlKey,
  BankControlKey,
  BankCountry,
  PayeeBankKey AS PayeeBankInternalID,
  PayeeBank,
  BusinessArea,
  CashDiscountAmountInPaytCrcy AS CashDiscountAmtInTransacCrcy,
  CashDiscountAmtInCoCodeCrcy,
  CityName AS SupplierCityName,
  PayeeCityName,
  Country AS SupplierCountry,
  PayeeBankCountry,
  PaymentCurrency,
  PayeeDistrictName AS District,
  PaymentDueDate AS PaidItemDueDate,
  EDIPaymentOrderStatus,
  EDIPaymentAdviceStatus,
  PaymentRequestPaymentGroup,
  HouseBank,
  BankInternalID,
  Bank,
  IBAN AS HouseBankIBAN,
  PayeeIBAN,
  DataExchangeInstructionKey,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  PaymentReason,
  BranchCode,
  DirectDebitType,
  LostCashDiscountInPaytCrcy AS LostCashDiscountInTransacCrcy,
  LostCashDiscountInCoCodeCrcy,
  FunctionalCurrency,
  PaymentAmountInFunctionalCrcy,
  CashDiscountAmountInFuncnlCrcy,
  PayeeName,
  PayeeAdditionalName,
  PayeeTitle,
  AddressID,
  NumberOfTextLines,
  NumberOfPaidItems,
  BankAccount,
  POBoxDeviatingCityName,
  POBoxPostalCode,
  PayeePOBoxPostalCode,
  PayeePostalCode,
  PayeeCountry,
  PayeeLanguage,
  PayeePOBox,
  PayeeStreet,
  PaymentMethod,
  PaymentReference,
  PersonnelNumber,
  PaymentMethodSupplement,
  POBox,
  PostalCode,
  PostingDate,
  PayeeBankDetailReference AS BankAccountReferenceText,
  Region,
  PaymentOrder,
  SendingCompanyCode,
  PayeeSEPASequenceType AS SEPASequenceType,
  StreetAddressName,
  PayeeSWIFTCode AS SWIFTCode,
  ValueDate,
  PayeeSEPAMandateUUID AS SEPAMandateUUID,
  PayeeRegion AS SupplierRegion,
  ExchangeRate,
  PaymentsGroupingCriterion AS PaymentOrigin,
  BillOfExchangeIssueDate,
  BillOfExchangeDueDate,
  PaymentOrigin AS BankPaymentGroupingOrigin,
  SWIFTTransactionReferenceUUID,
  BusinessPlace,
  BankChainBank1Type,
  BankChainBank1Country,
  BankChainBank1,
  BankChainBank1BankAccount,
  BankChainBank1ControlKey,
  BankChainBank1DetailReference,
  BankChainBank1IBAN,
  BankChainBank2Type,
  BankChainBank2Country,
  BankChainBank2,
  BankChainBank2BankAccount,
  BankChainBank2ControlKey,
  BankChainBank2DetailReference,
  BankChainBank2IBAN,
  BankChainBank3Type,
  BankChainBank3Country,
  BankChainBank3,
  BankChainBank3BankAccount,
  BankChainBank3ControlKey,
  BankChainBank3DetailReference,
  BankChainBank3IBAN,
  PayeePaymentSystem,
  PayeeAliasType,
  PayeeAliasName,
  CompanyCodeCurrency,
  CompanyCodeCountry AS Country
FROM I_PaymentProposalPayment
LEFT OUTER JOIN I_Paymentmethodsupplementtext AS _AdditionalPaytMethod ON PaymentMethodSupplement = _AdditionalPaytMethod.PaymentMethodSupplement  -- association [1..*]
LEFT OUTER JOIN I_PaymentMethodText AS _PaymentMethodText ON Country = _PaymentMethodText.Country AND PaymentMethod = _PaymentMethodText.PaymentMethod  -- association [1..*]
LEFT OUTER JOIN I_PaytProposalItemAggregation AS _PaytProposalItemAggregation ON PaymentRunID = _PaytProposalItemAggregation.PaymentRunID AND PaymentRunDate = _PaytProposalItemAggregation.PaymentRunDate AND PaymentDocument = _PaytProposalItemAggregation.PaymentDocument AND PaymentRunIsProposal = _PaytProposalItemAggregation.PaymentRunIsProposal AND PayingCompanyCode = _PaytProposalItemAggregation.PayingCompanyCode AND Supplier = _PaytProposalItemAggregation.Supplier AND Customer = _PaytProposalItemAggregation.Customer AND PaymentRecipient = _PaytProposalItemAggregation.PaymentRecipient  -- association [0..1]
LEFT OUTER JOIN I_PaymentOrder AS _PaymentOrder ON PaymentOrder = _PaymentOrder.PaymentOrder  -- association [0..1]
;