C_PaymentRequestTP

DDL: C_PAYMENTREQUESTTP Type: view_entity CONSUMPTION
128 Fields 1 Data Sources

Payment Request

C_PaymentRequestTP is a Consumption CDS View that provides data about "Payment Request" in SAP S/4HANA. It reads from 1 data source (R_PaymentRequestTP) and exposes 128 fields with key field PaymentRequest.

Data Sources (1)

SourceAliasJoin Type
R_PaymentRequestTP R_PaymentRequestTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name PaymentRequest view
Search.searchable true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
EndUserText.label Payment Request view

Fields (128)

KeyFieldSource TableSource FieldDescription
KEY PaymentRequest PaymentRequest
AccountingDocumentCreationDate AccountingDocumentCreationDate Journal Entry Date
ClearingDate ClearingDate Clearing Date
ClearingFiscalYear ClearingFiscalYear
CompanyCodeCountry _CompanyCode Country Venue: Ctry/Reg
CustomerBankType CustomerBankType
PayeeIBAN PayeeIBAN
PaytReqIsCompleted PaytReqIsCompleted
IsReversed IsReversed Reversed?
DocumentItemText DocumentItemText Text
AccountingDocument AccountingDocument Journal Entry
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 Amount in Additional Currency 1
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 LC2 Amount
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
PaymentRequestAmountInCCCrcy PaymentRequestAmountInCCCrcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency
PaymentRequestOrigin PaymentRequestOrigin
POBoxPostalCode POBoxPostalCode PO Box Postal Code
PayeeTitle PayeeTitle
PayeeBankCountry PayeeBankCountry
PayeeBankCountryName
PayeeBank PayeeBank
PayeeCityName PayeeCityName
PayeeCountry PayeeCountry
PayeeFaxNumber PayeeFaxNumber
PayeeLanguage PayeeLanguage
PayeeAdditionalName2 PayeeAdditionalName2
PayeeAdditionalName3 PayeeAdditionalName3
PayeeAdditionalName4 PayeeAdditionalName4
PayeePostalCode PayeePostalCode
PayeeRegion PayeeRegion
PayeeStreet PayeeStreet
PayeeTelephoneNumber PayeeTelephoneNumber
PayeePOBox PayeePOBox
PayingCompanyCode PayingCompanyCode Paying Company Code
PayingCompanyCodeName _PayingCompanyCode CompanyCodeName Company Name
PaymentReason PaymentReason Payment Reason
PaymentReference PaymentReference Payment Reference
PaymentMethodSupplement PaymentMethodSupplement Pmnt Meth. Sup.
PaymentRequestPostingDate PaymentRequestPostingDate
PaytReqIsReleasedForPayment PaytReqIsReleasedForPayment
PaytReqIsReleasedForPosting PaytReqIsReleasedForPosting
ReleaseDate ReleaseDate
ReversalReason ReversalReason Reversal Reason
SupplierBankType SupplierBankType Partner Bank Type
SupplyingCountry SupplyingCountry Supplying Ctry/Reg.
TaxID1 TaxID1 Tax Number 1
IsUrgentPayment _DataExchangeInstructionKeys IsUrgentPayment
ValueDate ValueDate Value Date
BankAliasEntryIsSelected BankAliasEntryIsSelected
PaymentBatch _BatchDocument PaymentBatch
BatchUUID _BatchDocument BatchUUID Target Grp GUID
PaymentBatchItem _BatchDocument PaymentBatchItem
PaymentBatchStatusText _BatchDocument PaymentBatchStatusText
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
PaymentRequestStatus PaymentRequestStatus Statuscode
PaymentRequestVariant PaymentRequestVariant
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
BusinessArea BusinessArea Business Area
FiscalYear FiscalYear G/L Fiscal Year
Customer Customer Sold-to Party
Supplier Supplier Supplier
PaymentRequestType PaymentRequestType
HouseBank HouseBank House Bank
BankInternalID BankInternalID Bank Key
HouseBankAccount HouseBankAccount House Bank Account
LastChangeDateTime LastChangeDateTime Timestamp
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
PaymentRequestReleasedByUser PaymentRequestReleasedByUser
PostingCreatedByUser PostingCreatedByUser
PaymentRequestAmountInPaytCrcy PaymentRequestAmountInPaytCrcy
PaymentRequestCurrency PaymentRequestCurrency
ConsideredPaymentMethods ConsideredPaymentMethods Pymt Meth.
BankChain BankChain
BankCountry BankCountry Bank Ctry/Rgn. Key
PaymentRepetitiveCode PaymentRepetitiveCode
PayeeAliasType PayeeAliasType
PayeeAliasName PayeeAliasName
PayeePaymentSystem PayeePaymentSystem
PayeeName PayeeName
PayeeBankInternalID PayeeBankInternalID
PayeeBankAccount PayeeBankAccount
PayeeBankControlKey PayeeBankControlKey
BankDetailReference BankDetailReference
IsSinglePayment IsSinglePayment
DataExchangeInstructionKey DataExchangeInstructionKey Instruction Key
DataExchangeInstruction1 DataExchangeInstruction1 Instruction 1
DataExchangeInstruction2 DataExchangeInstruction2 Instruction 2
DataExchangeInstruction3 DataExchangeInstruction3 Instruction 3
DataExchangeInstruction4 DataExchangeInstruction4 Instruction 4
StateCentralBankPaymentReason StateCentralBankPaymentReason SCB Ind.
CustomerSupplierAccount CustomerSupplierAccount
FinancialAccountType FinancialAccountType Fin. Account Type
SupplierAccountGroup _Supplier SupplierAccountGroup Account group
SupplierFinsAuthorizationGrp _Supplier AuthorizationGroup AuthorizGroup
CustomerAccountGroup _Customer CustomerAccountGroup Account group
AuthorizationGroup _Customer AuthorizationGroup AuthorizGroup
CustomerFinsAuthorizationGrp _Customer AuthorizationGroup AuthorizGroup
ReferenceTypeText ReferenceTypeText
HouseBankAccountDescription
PaymentReasonText
CurrencyName
PaymentRequestStatusName
PaymentSystemText
AliasTypeText
BusinessAreaName
BankAccountHolderName BankAccountHolderName Account Holder
CreatedByUserName _CreatedBy FullName Name
PostingCreatedByUserName _PostedBy FullName Name
ReleasedByUserName _ReleasedBy FullName Name
LastChangedByUserName _ChangedBy FullName Name
FinancialAccountTypeName FinancialAccountTypeName
CustomerName _Customer CustomerName Name of Customer
SupplierName _Supplier SupplierName Supplier Name
PaymentMethodName _PaymentMethod PaymentMethodName Text
BankName _Bank2 BankName Bank Name
PayeeBankName _PayeeBank2 BankName Bank Name
virtualUICT_IsFFPFieldHiddenabap_boolean
_Customer _Customer
_Supplier _Supplier
_CreatedBy _CreatedBy
_ChangedBy _ChangedBy
_PostedBy _PostedBy
_ReleasedBy _ReleasedBy

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_PaymentRequestTP.
-- 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.

CREATE VIEW C_PaymentRequestTP AS
SELECT
  PaymentRequest,
  AccountingDocumentCreationDate,
  ClearingDate,
  ClearingFiscalYear,
  _CompanyCode.Country AS CompanyCodeCountry,
  CustomerBankType,
  PayeeIBAN,
  PaytReqIsCompleted,
  IsReversed,
  DocumentItemText,
  AccountingDocument,
  AmountInAdditionalCurrency1,
  AdditionalCurrency1,
  AmountInAdditionalCurrency2,
  AdditionalCurrency2,
  PaymentRequestAmountInCCCrcy,
  CompanyCodeCurrency,
  PaymentRequestOrigin,
  POBoxPostalCode,
  PayeeTitle,
  PayeeBankCountry,
  _PayeeBank2._Country._Text[1:Language = $session.system_language].CountryName AS PayeeBankCountryName,
  PayeeBank,
  PayeeCityName,
  PayeeCountry,
  PayeeFaxNumber,
  PayeeLanguage,
  PayeeAdditionalName2,
  PayeeAdditionalName3,
  PayeeAdditionalName4,
  PayeePostalCode,
  PayeeRegion,
  PayeeStreet,
  PayeeTelephoneNumber,
  PayeePOBox,
  PayingCompanyCode,
  _PayingCompanyCode.CompanyCodeName AS PayingCompanyCodeName,
  PaymentReason,
  PaymentReference,
  PaymentMethodSupplement,
  PaymentRequestPostingDate,
  PaytReqIsReleasedForPayment,
  PaytReqIsReleasedForPosting,
  ReleaseDate,
  ReversalReason,
  SupplierBankType,
  SupplyingCountry,
  TaxID1,
  _DataExchangeInstructionKeys.IsUrgentPayment AS IsUrgentPayment,
  ValueDate,
  BankAliasEntryIsSelected,
  _BatchDocument.PaymentBatch AS PaymentBatch,
  _BatchDocument.BatchUUID AS BatchUUID,
  _BatchDocument.PaymentBatchItem AS PaymentBatchItem,
  _BatchDocument.PaymentBatchStatusText AS PaymentBatchStatusText,
  ClearingAccountingDocument,
  PaymentRequestStatus,
  PaymentRequestVariant,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  BusinessArea,
  FiscalYear,
  Customer,
  Supplier,
  PaymentRequestType,
  HouseBank,
  BankInternalID,
  HouseBankAccount,
  LastChangeDateTime,
  CreationDateTime,
  CreatedByUser,
  LastChangedByUser,
  PaymentRequestReleasedByUser,
  PostingCreatedByUser,
  PaymentRequestAmountInPaytCrcy,
  PaymentRequestCurrency,
  ConsideredPaymentMethods,
  BankChain,
  BankCountry,
  PaymentRepetitiveCode,
  PayeeAliasType,
  PayeeAliasName,
  PayeePaymentSystem,
  PayeeName,
  PayeeBankInternalID,
  PayeeBankAccount,
  PayeeBankControlKey,
  BankDetailReference,
  IsSinglePayment,
  DataExchangeInstructionKey,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  StateCentralBankPaymentReason,
  CustomerSupplierAccount,
  FinancialAccountType,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  _Customer.AuthorizationGroup AS CustomerFinsAuthorizationGrp,
  ReferenceTypeText,
  _HouseBankAccount._Text[1:Language = $session.system_language].HouseBankAccountDescription AS HouseBankAccountDescription,
  _PaymentReason._Text[1:Language = $session.system_language].PaymentReasonText AS PaymentReasonText,
  _CurrencyText[1:Language = $session.system_language].CurrencyName AS CurrencyName,
  _PaymentRequestStatusText[1:Language = $session.system_language].PaymentRequestStatusName AS PaymentRequestStatusName,
  _PayeePaymentSystem._Text[1:Language = $session.system_language].PaymentSystemText AS PaymentSystemText,
  _PayeeAliasType._Text[1:Language = $session.system_language].AliasTypeText AS AliasTypeText,
  _BusinessAreaText[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  BankAccountHolderName,
  _CreatedBy.FullName AS CreatedByUserName,
  _PostedBy.FullName AS PostingCreatedByUserName,
  _ReleasedBy.FullName AS ReleasedByUserName,
  _ChangedBy.FullName AS LastChangedByUserName,
  FinancialAccountTypeName,
  _Customer.CustomerName AS CustomerName,
  _Supplier.SupplierName AS SupplierName,
  _PaymentMethod.PaymentMethodName AS PaymentMethodName,
  _Bank2.BankName AS BankName,
  _PayeeBank2.BankName AS PayeeBankName,
  virtual UICT_IsFFPFieldHidden : abap_boolean AS virtualUICT_IsFFPFieldHiddenabap_boolean
FROM R_PaymentRequestTP
;

Learn More