C_PaymentRequest

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 C_PaymentRequest.
-- 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: CPAYMENTREQUEST

CREATE VIEW C_PaymentRequest AS
SELECT
  _PaymentRequest.PaymentRequest AS PaymentRequest,
  _PaymentRequest.CreatedByUser AS CreatedByUser,
  _UserContactCard.FullName AS CreatedByUserName,
  _PaymentRequest.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _PaymentRequest.CreationDateTime AS CreationDateTime,
  _PaymentRequest.LastChangeDateTime AS LastChangeDateTime,
  _PaymentRequest.LastChangedByUser AS LastChangedByUser,
  _ChangeUserContactCard.FullName AS LastChangedByUserName,
  _PaymentRequest.StatusCode AS StatusCode,
  _PaymentRequest._SystemStatusText[1:Language = $session.system_language].SystemStatusName AS SystemStatusName,
  _PaymentRequest.PaymentRequestType AS PaymentRequestType,
  _PaymentRequest.PaymentRequestVariant AS PaymentRequestVariant,
  _PaymentRequest.PaymentRequestTemplate AS PaymentRequestTemplate,
  _PaymentRequest.PaymentRepetitiveCode AS PaymentRepetitiveCode,
  _PaymentRequest.Customer AS Customer,
  _PaymentRequest.Supplier AS Supplier,
  _PaymentRequest.PayeeName AS PayeeName,
  _Customer.CustomerName AS CustomerName,
  _Supplier.SupplierName AS SupplierName,
  _PaymentRequest.PayeeTitle AS PayeeTitle,
  _PaymentRequest.PayeeAdditionalName2 AS PayeeAdditionalName2,
  _PaymentRequest.PayeeAdditionalName3 AS PayeeAdditionalName3,
  _PaymentRequest.PayeeAdditionalName4 AS PayeeAdditionalName4,
  _PaymentRequest.PayeeCityName AS PayeeCityName,
  _PaymentRequest.PayeeStreet AS PayeeStreet,
  _PaymentRequest.PayeePostalCode AS PayeePostalCode,
  _PaymentRequest.PayeeCountry AS PayeeCountry,
  _PaymentRequest.PayeeRegion AS PayeeRegion,
  _PaymentRequest.PayeePOBox AS PayeePOBox,
  _PaymentRequest.POBoxPostalCode AS POBoxPostalCode,
  _PaymentRequest.PayeeLanguage AS PayeeLanguage,
  _PaymentRequest.PayeeFaxNumber AS PayeeFaxNumber,
  _PaymentRequest.PayeeTelephoneNumber AS PayeeTelephoneNumber,
  _PaymentRequest.SupplierBankType AS SupplierBankType,
  _PaymentRequest.CustomerBankType AS CustomerBankType,
  _PaymentRequest.PayeeBankCountry AS PayeeBankCountry,
  _PayeeBank._Country._Text[1:Language = $session.system_language].CountryName AS PayeeBankCountryName,
  _PaymentRequest.PayeeBankInternalID AS PayeeBankInternalID,
  _PaymentRequest.PayeeBankAccount AS PayeeBankAccount,
  _PaymentRequest.BankDetailReference AS BankDetailReference,
  _PaymentRequest.PayeeBankControlKey AS PayeeBankControlKey,
  _PaymentRequest._PayeeBank.BankName AS PayeeBankName,
  _PaymentRequest.PayeeIBAN AS PayeeIBAN,
  _PaymentRequest.BankAccountHolderName AS BankAccountHolderName,
  _PaymentRequest.PayeeBank AS PayeeBank,
  _PaymentRequest.PayeePaymentSystem AS PayeePaymentSystem,
  _PaymentRequest.PayeeAliasType AS PayeeAliasType,
  _PaymentRequest.PayeeAliasName AS PayeeAliasName,
  _PaymentRequest.TradingPartner AS TradingPartner,
  _PayeePaymentSystem._Text[1:Language = $session.system_language].PaymentSystemText AS PaymentSystemText,
  _PayeeAliasType._Text[1:Language = $session.system_language].AliasTypeText AS AliasTypeText,
  _PaymentRequest.CompanyCode AS CompanyCode,
  _PaymentRequest.AccountingDocument AS AccountingDocument,
  _PaymentRequest.FiscalYear AS FiscalYear,
  _PaymentRequest._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PaymentRequest._PartnerCompany.CompanyName AS CompanyName,
  _PaymentRequest._CompanyCode.Country AS CompanyCodeCountry,
  _PaymentRequest.BusinessArea AS BusinessArea,
  _PaymentRequest._BusinessAreaText[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  _PaymentRequest.FinancialAccountType AS FinancialAccountType,
  cast(_PaymentRequest.FinancialAccountTypeName as farp_fin_acc_type_name preserving type) AS FinancialAccountTypeName,
  _PaymentRequest.CustomerSupplierAccount AS CustomerSupplierAccount,
  _PaymentRequest.DocumentItemText AS DocumentItemText,
  _BatchDocument.PaymentBatch AS PaymentBatch,
  _BatchDocument.BatchUUID AS BatchUUID,
  _BatchDocument.PaymentBatchItem AS PaymentBatchItem,
  _BatchDocument.PaymentBatchStatusText AS PaymentBatchStatusText,
  _PaymentRequest.PayingCompanyCode AS PayingCompanyCode,
  _PaymentRequest.ClearingAccountingDocument AS ClearingAccountingDocument,
  _PaymentRequest.ClearingDate AS ClearingDate,
  cast( _PaymentRequest.ClearingFiscalYear as fins_bat_clearing_fiscal_year preserving type ) AS ClearingFiscalYear,
  _PaymentRequest._PayingCompanyCode.CompanyCodeName AS PayingCompanyCodeName,
  _PaymentRequest.BankCountry AS BankCountry,
  _PaymentRequest.HouseBank AS HouseBank,
  _PaymentRequest._Bank.BankName AS BankName,
  _PaymentRequest.BankInternalID AS BankInternalID,
  _PaymentRequest.HouseBankAccount AS HouseBankAccount,
  _HouseBankAccount._Text[1:Language = $session.system_language].HouseBankAccountDescription AS HouseBankAccountDescription,
  _PaymentRequest.PaymentRequestAmountInPaytCrcy AS PaymentRequestAmountInPaytCrcy,
  _PaymentRequest.PaymentRequestCurrency AS PaymentRequestCurrency,
  _CurrencyText.CurrencyName AS CurrencyName,
  _PaymentRequest.PaymentRequestAmountInCCCrcy AS PaymentRequestAmountInCCCrcy,
  _PaymentRequest.CompanyCodeCurrency AS CompanyCodeCurrency,
  _PaymentRequest.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  _PaymentRequest.AdditionalCurrency1 AS AdditionalCurrency1,
  _PaymentRequest.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  _PaymentRequest.AdditionalCurrency2 AS AdditionalCurrency2,
  _PaymentRequest.PaymentMethod AS PaymentMethod,
  _PaymentRequest.PaymentMethodSupplement AS PaymentMethodSupplement,
  _PaymentRequest._PaymentMethod.PaymentMethodName AS PaymentMethodName,
  _PaymentRequest.ValueDate AS ValueDate,
  _PaymentRequest.ReferenceTypeText AS ReferenceTypeText,
  _PaymentRequest.PaymentReference AS PaymentReference,
  _PaymentRequest.PaymentReason AS PaymentReason,
  _PaymentRequest._PaymentReason._Text[1:Language = $session.system_language].PaymentReasonText AS PaymentReasonText,
  _PaymentRequest.IsSinglePayment AS IsSinglePayment,
  _PaymentRequest.DataExchangeInstructionKey AS DataExchangeInstructionKey,
  _PaymentRequest.DataExchangeInstruction1 AS DataExchangeInstruction1,
  _PaymentRequest.DataExchangeInstruction2 AS DataExchangeInstruction2,
  _PaymentRequest.DataExchangeInstruction3 AS DataExchangeInstruction3,
  _PaymentRequest.DataExchangeInstruction4 AS DataExchangeInstruction4,
  _PaymentRequest.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  _PaymentRequest.SupplyingCountry AS SupplyingCountry,
  _PaymentRequest.TaxID1 AS TaxID1,
  _PaymentRequest.BankChain AS BankChain,
  _PaymentRequest.PaymentRequestReferenceText AS PaymentRequestReferenceText,
  _PaymentRequest.IsUrgentPayment AS IsUrgentPayment,
  _PaymentRequest.PaymentRequestOrigin AS PaymentRequestOrigin,
  _PaymentRequest.PaytReqIsReleasedForPosting AS PaytReqIsReleasedForPosting,
  _PaymentRequest.PaytReqIsCompleted AS PaytReqIsCompleted,
  _PaymentRequest.PaytReqIsReleasedForPayment AS PaytReqIsReleasedForPayment,
  _PaymentRequest.IsReversed AS IsReversed,
  _PaymentRequest.ReversalReason AS ReversalReason,
  _PaymentRequest.ReleaseDate AS ReleaseDate,
  _PaymentRequest.ReleasedByUser AS ReleasedByUser,
  _ReleaseUserContactCard.FullName AS ReleasedByUserName,
  _PaymentRequest.PaymentRequestPostingDate AS PaymentRequestPostingDate,
  _PaymentRequest.PostingCreatedByUser AS PostingCreatedByUser,
  _PostUserContactCard.FullName AS PostingCreatedByUserName,
  BankAliasEntryIsSelected,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  _Customer.AuthorizationGroup AS CustomerFinsAuthorizationGrp
FROM I_PaymentRequestTP AS _PaymentRequest
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON CreatedByUser = _UserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangeUserContactCard ON LastChangedByUser = _ChangeUserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _ReleaseUserContactCard ON ReleasedByUser = _ReleaseUserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _PostUserContactCard ON PostingCreatedByUser = _PostUserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN C_PaymentBatchPaymentDocument AS _BatchDocument ON ClearingAccountingDocument = _BatchDocument.PaymentDocument AND PayingCompanyCode = _BatchDocument.PayingCompanyCode AND ClearingFiscalYear = _BatchDocument.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _CurrencyText ON _CurrencyText.Currency = _PaymentRequest.PaymentRequestCurrency AND _CurrencyText.Language = $session.system_language  -- association [0..1]
;