I_PAYMENTREQUEST

CDS View
102 Fields 5 CDS Views

Payment Requests

I_PAYMENTREQUEST is a CDS View in S/4HANA. Payment Requests. It contains 102 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_PaymentRequestTP view from TRANSACTIONAL Payment Request Draft
P_PAYMENTREQUESTPAYEE view_entity from COMPOSITE
P_PFFPaymentRequestType view from COMPOSITE
P_PFFPaymentRequestType view union_all COMPOSITE
R_PaymentRequestTP view_entity from TRANSACTIONAL Payment Request

Fields (102)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 3
KEY CreatedByUser CreatedByUser 3
KEY PayeeBankAccount BankAccount,PayeeBankAccount 2
KEY PaymentRequest PaymentRequest 2
_AdditionalCurrency1 _AdditionalCurrency1 1
_AdditionalCurrency2 _AdditionalCurrency2 1
_Bank _Bank 1
_Bank2 _Bank2 1
_BusinessAreaText _BusinessAreaText 2
_CalendarDateForCompanyCode _CalendarDateForCompanyCode 1
_CompanyCode _CompanyCode 2
_CompanyCodeCurrency _CompanyCodeCurrency 1
_CreatedBy _CreatedBy 1
_CurrencyText _CurrencyText 1
_DataExchangeInstructionKeys _DataExchangeInstructionKeys 2
_HouseBankAccount _HouseBankAccount 2
_PayeeAliasType _PayeeAliasType 1
_PayeeBank _PayeeBank 1
_PayeeBank2 _PayeeBank2 1
_PayeePaymentSystem _PayeePaymentSystem 1
_PayingCompanyCode _PayingCompanyCode 2
_PaymentMethod _PaymentMethod 2
_PaymentReason _PaymentReason 2
_PaymentRequestCurrency _PaymentRequestCurrency 1
_PaytReqChangeAndPost _PaytReqChangeAndPost 2
_PostedBy _PostedBy 1
_ReleasedBy _ReleasedBy 1
_ReversalReason _ReversalReason 1
_SystemStatusText _SystemStatusText 2
AccountingDocument AccountingDocument 2
AccountingDocumentCreationDate AccountingDocumentCreationDate 2
AdditionalCurrency1 AdditionalCurrency1 2
AdditionalCurrency2 AdditionalCurrency2 2
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 2
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 2
BankAccountHolderName BankAccountHolderName 2
BankCountry BankCountry 3
BankDetailReference BankDetailReference 2
BankInternalID BankInternalID 2
BusinessArea BusinessArea 2
ClearingAccountingDocument ClearingAccountingDocument 2
ClearingDate ClearingDate 2
CompanyCodeCurrency CompanyCodeCurrency 2
DataExchangeInstruction1 DataExchangeInstruction1 2
DataExchangeInstruction2 DataExchangeInstruction2 2
DataExchangeInstruction3 DataExchangeInstruction3 2
DataExchangeInstruction4 DataExchangeInstruction4 2
DataExchangeInstructionKey DataExchangeInstructionKey 2
FiscalYear FiscalYear 2
GLAccount GLAccount 2
HouseBank HouseBank 2
HouseBankAccount HouseBankAccount 2
IsReversed IsReversed 2
IsSinglePayment IsSinglePayment 2
PayeeAdditionalName2 PayeeAdditionalName2 2
PayeeAdditionalName3 PayeeAdditionalName3 2
PayeeAdditionalName4 PayeeAdditionalName4 2
PayeeAliasName PayeeAliasName 2
PayeeAliasType PayeeAliasType 2
PayeeBank PayeeBank 2
PayeeBankControlKey PayeeBankControlKey 2
PayeeBankCountry PayeeBankCountry 2
PayeeBankInternalID PayeeBankInternalID 2
PayeeCityName PayeeCityName 2
PayeeCountry PayeeCountry 2
PayeeFaxNumber PayeeFaxNumber 2
PayeeIBAN PayeeIBAN 2
PayeeLanguage PayeeLanguage 2
PayeeName PayeeName 2
PayeePaymentSystem PayeePaymentSystem 2
PayeePOBox PayeePOBox 2
PayeePostalCode PayeePostalCode 2
PayeeRegion PayeeRegion 2
PayeeStreet PayeeStreet 2
PayeeTelephoneNumber PayeeTelephoneNumber 2
PayeeTitle PayeeTitle 2
PayingCompanyCode PayingCompanyCode 2
PaymentMethod ConsideredPaymentMethods,PaymentMethod 2
PaymentMethodSupplement PaymentMethodSupplement 2
PaymentReason PaymentReason 2
PaymentReference PaymentReference 2
PaymentRepetitiveCode PaymentRepetitiveCode 2
PaymentRequestAmountInCCCrcy PaymentRequestAmountInCCCrcy 2
PaymentRequestAmountInPaytCrcy PaymentRequestAmountInPaytCrcy 2
PaymentRequestCurrency PaymentRequestCurrency 2
PaymentRequestOrigin PaymentRequestOrigin 2
PaymentRequestPostingDate PaymentRequestPostingDate 2
PaymentRequestReleasedByUser PaymentRequestReleasedByUser 1
PaytReqIsCompleted PaytReqIsCompleted 2
PaytReqIsReleasedForPayment PaytReqIsReleasedForPayment 2
PaytReqIsReleasedForPosting PaytReqIsReleasedForPosting 2
POBoxPostalCode POBoxPostalCode 2
PostingCreatedByUser PostingCreatedByUser 2
ReferenceTypeText ReferenceTypeText 2
ReleaseDate ReleaseDate 2
ReleasedByUser ReleasedByUser 1
ReversalReason ReversalReason 2
StateCentralBankPaymentReason StateCentralBankPaymentReason 2
StatusCode PaymentRequestStatus,StatusCode 2
SupplyingCountry SupplyingCountry 2
TaxID1 TaxID1 2
ValueDate ValueDate 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Payment Requests
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PAYMENTREQUEST (
    COMPANYCODE,
    CREATEDBYUSER,
    PAYEEBANKACCOUNT,
    PAYMENTREQUEST,
    _ADDITIONALCURRENCY1,
    _ADDITIONALCURRENCY2,
    _BANK,
    _BANK2,
    _BUSINESSAREATEXT,
    _CALENDARDATEFORCOMPANYCODE,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CREATEDBY,
    _CURRENCYTEXT,
    _DATAEXCHANGEINSTRUCTIONKEYS,
    _HOUSEBANKACCOUNT,
    _PAYEEALIASTYPE,
    _PAYEEBANK,
    _PAYEEBANK2,
    _PAYEEPAYMENTSYSTEM,
    _PAYINGCOMPANYCODE,
    _PAYMENTMETHOD,
    _PAYMENTREASON,
    _PAYMENTREQUESTCURRENCY,
    _PAYTREQCHANGEANDPOST,
    _POSTEDBY,
    _RELEASEDBY,
    _REVERSALREASON,
    _SYSTEMSTATUSTEXT,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    BANKACCOUNTHOLDERNAME,
    BANKCOUNTRY,
    BANKDETAILREFERENCE,
    BANKINTERNALID,
    BUSINESSAREA,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    COMPANYCODECURRENCY,
    DATAEXCHANGEINSTRUCTION1,
    DATAEXCHANGEINSTRUCTION2,
    DATAEXCHANGEINSTRUCTION3,
    DATAEXCHANGEINSTRUCTION4,
    DATAEXCHANGEINSTRUCTIONKEY,
    FISCALYEAR,
    GLACCOUNT,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    ISREVERSED,
    ISSINGLEPAYMENT,
    PAYEEADDITIONALNAME2,
    PAYEEADDITIONALNAME3,
    PAYEEADDITIONALNAME4,
    PAYEEALIASNAME,
    PAYEEALIASTYPE,
    PAYEEBANK,
    PAYEEBANKCONTROLKEY,
    PAYEEBANKCOUNTRY,
    PAYEEBANKINTERNALID,
    PAYEECITYNAME,
    PAYEECOUNTRY,
    PAYEEFAXNUMBER,
    PAYEEIBAN,
    PAYEELANGUAGE,
    PAYEENAME,
    PAYEEPAYMENTSYSTEM,
    PAYEEPOBOX,
    PAYEEPOSTALCODE,
    PAYEEREGION,
    PAYEESTREET,
    PAYEETELEPHONENUMBER,
    PAYEETITLE,
    PAYINGCOMPANYCODE,
    PAYMENTMETHOD,
    PAYMENTMETHODSUPPLEMENT,
    PAYMENTREASON,
    PAYMENTREFERENCE,
    PAYMENTREPETITIVECODE,
    PAYMENTREQUESTAMOUNTINCCCRCY,
    PAYMENTREQUESTAMOUNTINPAYTCRCY,
    PAYMENTREQUESTCURRENCY,
    PAYMENTREQUESTORIGIN,
    PAYMENTREQUESTPOSTINGDATE,
    PAYMENTREQUESTRELEASEDBYUSER,
    PAYTREQISCOMPLETED,
    PAYTREQISRELEASEDFORPAYMENT,
    PAYTREQISRELEASEDFORPOSTING,
    POBOXPOSTALCODE,
    POSTINGCREATEDBYUSER,
    REFERENCETYPETEXT,
    RELEASEDATE,
    RELEASEDBYUSER,
    REVERSALREASON,
    STATECENTRALBANKPAYMENTREASON,
    STATUSCODE,
    SUPPLYINGCOUNTRY,
    TAXID1,
    VALUEDATE,
    PRIMARY KEY (COMPANYCODE, CREATEDBYUSER, PAYEEBANKACCOUNT, PAYMENTREQUEST)
);

Learn More