I_PAYMENTREQUESTTP
Payment Request Draft
I_PAYMENTREQUESTTP is a CDS View in S/4HANA. Payment Request Draft. It contains 92 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_PaymentRequest | view | from | CONSUMPTION | Payment Requests |
Fields (92)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | PaymentRequest | PaymentRequest | 1 |
| AccountingDocument | AccountingDocument | 1 | |
| AccountingDocumentCreationDate | AccountingDocumentCreationDate | 1 | |
| AdditionalCurrency1 | AdditionalCurrency1 | 1 | |
| AdditionalCurrency2 | AdditionalCurrency2 | 1 | |
| AmountInAdditionalCurrency1 | AmountInAdditionalCurrency1 | 1 | |
| AmountInAdditionalCurrency2 | AmountInAdditionalCurrency2 | 1 | |
| BankAccountHolderName | BankAccountHolderName | 1 | |
| BankChain | BankChain | 1 | |
| BankCountry | BankCountry | 1 | |
| BankDetailReference | BankDetailReference | 1 | |
| BankInternalID | BankInternalID | 1 | |
| BusinessArea | BusinessArea | 1 | |
| ClearingAccountingDocument | ClearingAccountingDocument | 1 | |
| ClearingDate | ClearingDate | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDateTime | CreationDateTime | 1 | |
| Customer | Customer | 1 | |
| CustomerBankType | CustomerBankType | 1 | |
| CustomerSupplierAccount | CustomerSupplierAccount | 1 | |
| DataExchangeInstruction1 | DataExchangeInstruction1 | 1 | |
| DataExchangeInstruction2 | DataExchangeInstruction2 | 1 | |
| DataExchangeInstruction3 | DataExchangeInstruction3 | 1 | |
| DataExchangeInstruction4 | DataExchangeInstruction4 | 1 | |
| DataExchangeInstructionKey | DataExchangeInstructionKey | 1 | |
| DocumentItemText | DocumentItemText | 1 | |
| FinancialAccountType | FinancialAccountType | 1 | |
| FiscalYear | FiscalYear | 1 | |
| HouseBank | HouseBank | 1 | |
| HouseBankAccount | HouseBankAccount | 1 | |
| IsReversed | IsReversed | 1 | |
| IsSinglePayment | IsSinglePayment | 1 | |
| IsUrgentPayment | IsUrgentPayment | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| PayeeAdditionalName2 | PayeeAdditionalName2 | 1 | |
| PayeeAdditionalName3 | PayeeAdditionalName3 | 1 | |
| PayeeAdditionalName4 | PayeeAdditionalName4 | 1 | |
| PayeeAliasName | PayeeAliasName | 1 | |
| PayeeAliasType | PayeeAliasType | 1 | |
| PayeeBank | PayeeBank | 1 | |
| PayeeBankAccount | PayeeBankAccount | 1 | |
| PayeeBankControlKey | PayeeBankControlKey | 1 | |
| PayeeBankCountry | PayeeBankCountry | 1 | |
| PayeeBankInternalID | PayeeBankInternalID | 1 | |
| PayeeCityName | PayeeCityName | 1 | |
| PayeeCountry | PayeeCountry | 1 | |
| PayeeFaxNumber | PayeeFaxNumber | 1 | |
| PayeeIBAN | PayeeIBAN | 1 | |
| PayeeLanguage | PayeeLanguage | 1 | |
| PayeeName | PayeeName | 1 | |
| PayeePaymentSystem | PayeePaymentSystem | 1 | |
| PayeePOBox | PayeePOBox | 1 | |
| PayeePostalCode | PayeePostalCode | 1 | |
| PayeeRegion | PayeeRegion | 1 | |
| PayeeStreet | PayeeStreet | 1 | |
| PayeeTelephoneNumber | PayeeTelephoneNumber | 1 | |
| PayeeTitle | PayeeTitle | 1 | |
| PayingCompanyCode | PayingCompanyCode | 1 | |
| PaymentMethod | PaymentMethod | 1 | |
| PaymentMethodSupplement | PaymentMethodSupplement | 1 | |
| PaymentReason | PaymentReason | 1 | |
| PaymentReference | PaymentReference | 1 | |
| PaymentRepetitiveCode | PaymentRepetitiveCode | 1 | |
| PaymentRequestAmountInCCCrcy | PaymentRequestAmountInCCCrcy | 1 | |
| PaymentRequestAmountInPaytCrcy | PaymentRequestAmountInPaytCrcy | 1 | |
| PaymentRequestCurrency | PaymentRequestCurrency | 1 | |
| PaymentRequestOrigin | PaymentRequestOrigin | 1 | |
| PaymentRequestPostingDate | PaymentRequestPostingDate | 1 | |
| PaymentRequestReferenceText | PaymentRequestReferenceText | 1 | |
| PaymentRequestTemplate | PaymentRequestTemplate | 1 | |
| PaymentRequestType | PaymentRequestType | 1 | |
| PaymentRequestVariant | PaymentRequestVariant | 1 | |
| PaytReqIsCompleted | PaytReqIsCompleted | 1 | |
| PaytReqIsReleasedForPayment | PaytReqIsReleasedForPayment | 1 | |
| PaytReqIsReleasedForPosting | PaytReqIsReleasedForPosting | 1 | |
| POBoxPostalCode | POBoxPostalCode | 1 | |
| PostingCreatedByUser | PostingCreatedByUser | 1 | |
| ReferenceTypeText | ReferenceTypeText | 1 | |
| ReleaseDate | ReleaseDate | 1 | |
| ReleasedByUser | ReleasedByUser | 1 | |
| ReversalReason | ReversalReason | 1 | |
| StateCentralBankPaymentReason | StateCentralBankPaymentReason | 1 | |
| StatusCode | StatusCode | 1 | |
| Supplier | Supplier | 1 | |
| SupplierBankType | SupplierBankType | 1 | |
| SupplyingCountry | SupplyingCountry | 1 | |
| TaxID1 | TaxID1 | 1 | |
| TradingPartner | TradingPartner | 1 | |
| ValueDate | ValueDate | 1 |
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 Request Draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PAYMENTREQUESTTP (
PAYMENTREQUEST,
ACCOUNTINGDOCUMENT,
ACCOUNTINGDOCUMENTCREATIONDATE,
ADDITIONALCURRENCY1,
ADDITIONALCURRENCY2,
AMOUNTINADDITIONALCURRENCY1,
AMOUNTINADDITIONALCURRENCY2,
BANKACCOUNTHOLDERNAME,
BANKCHAIN,
BANKCOUNTRY,
BANKDETAILREFERENCE,
BANKINTERNALID,
BUSINESSAREA,
CLEARINGACCOUNTINGDOCUMENT,
CLEARINGDATE,
COMPANYCODE,
COMPANYCODECURRENCY,
CREATEDBYUSER,
CREATIONDATETIME,
CUSTOMER,
CUSTOMERBANKTYPE,
CUSTOMERSUPPLIERACCOUNT,
DATAEXCHANGEINSTRUCTION1,
DATAEXCHANGEINSTRUCTION2,
DATAEXCHANGEINSTRUCTION3,
DATAEXCHANGEINSTRUCTION4,
DATAEXCHANGEINSTRUCTIONKEY,
DOCUMENTITEMTEXT,
FINANCIALACCOUNTTYPE,
FISCALYEAR,
HOUSEBANK,
HOUSEBANKACCOUNT,
ISREVERSED,
ISSINGLEPAYMENT,
ISURGENTPAYMENT,
LASTCHANGEDATETIME,
LASTCHANGEDBYUSER,
PAYEEADDITIONALNAME2,
PAYEEADDITIONALNAME3,
PAYEEADDITIONALNAME4,
PAYEEALIASNAME,
PAYEEALIASTYPE,
PAYEEBANK,
PAYEEBANKACCOUNT,
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,
PAYMENTREQUESTREFERENCETEXT,
PAYMENTREQUESTTEMPLATE,
PAYMENTREQUESTTYPE,
PAYMENTREQUESTVARIANT,
PAYTREQISCOMPLETED,
PAYTREQISRELEASEDFORPAYMENT,
PAYTREQISRELEASEDFORPOSTING,
POBOXPOSTALCODE,
POSTINGCREATEDBYUSER,
REFERENCETYPETEXT,
RELEASEDATE,
RELEASEDBYUSER,
REVERSALREASON,
STATECENTRALBANKPAYMENTREASON,
STATUSCODE,
SUPPLIER,
SUPPLIERBANKTYPE,
SUPPLYINGCOUNTRY,
TAXID1,
TRADINGPARTNER,
VALUEDATE,
PRIMARY KEY (PAYMENTREQUEST)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA