Application Platform (AP)
Basis Components (BC)
Business Mobile (MOB)
Business Network Solutions (BNS)
Controlling (CO)
Cross-Application Components (CA)
- Asset Retirement Obligation Management for Oil & Gas (CA-ARO)
- Available to Promise (ATP) (CA-ATP)
- Bank (CA-BK)
- CA-VCM: Value Chain Management (CA-VCM)
- Classification (CA-CL)
- Commercial Project Management (CA-CPD)
- Cross functional developments in Asset Intell. N/W (CA-AIN)
- Cross-Application Objects in HR (CA-HR)
- Data Transformation (CA-DT)
- Document Management System (CA-DMS)
- Field Logistics (CA-FL)
- General Application Functions (CA-GTF)
  - Business Document Flow (CA-GTF-BPF)
  - Business Event Handling (CA-GTF-BEH)
  - Business Event Logging (CA-GTF-BEL)
  - Business User Management (CA-GTF-BUM)
  - Commodity Pricing Engine (CA-GTF-CPE)
  - Consent Administration (CA-GTF-CON)
  - Contextual Business Navigation (CA-GTF-CBN)
  - Country/Region-Specific Application Interface Objects (CA-GTF-CSC)
  - Cross-Application Services General Ledger (CA-GTF-GL)
  - DART (Data Retention Tool) (CA-GTF-DRT)
  - Date Function (CA-GTF-DF)
  - Digital Access (CA-GTF-DA)
  - Feature Management (CA-GTF-FM)
  - Financial Closing cockpit Add-on (CA-GTF-FCC)
  - Fiori Xperience Unit (FXU) (CA-GTF-FXU)
    - Fiori FXU Finance (CA-GTF-FXU-FI)
    - Fiori FXU Procurement (CA-GTF-FXU-MM)
    - UX - Fiori Xperience Unit (FXU) - General Topics (CA-GTF-FXU-GEN)
  - HANA Search for Business Suite (CA-GTF-HSB)
  - Responsibility Management (CA-GTF-RM)
  - S/4HANA Extensibility and Integration (CA-GTF-EI)
  - SAP S/4HANA Data Migration Cockpit Content (LTMC) (CA-GTF-MIG)
  - SAP Smart Business for S/4HANA (CA-GTF-ANA)
  - Virtual Data Model (CA-GTF-VDM)
  - s-Innovations Output Management (CA-GTF-OC)
- Integration from S/4HC to Master Data for Worker (CA-WFD)
- Issue & Activity Management (CA-IAM)
- Joint Venture und Production Sharing Accounting (CA-JVA)
- Landscape Transformation (CA-LT)
- Machine Learning (CA-ML)
- Master Data Governance. (CA-MDG)
- Master Data Integration Services (CA-MDI)
- PLM Audit Management (CA-AUD)
- Prepayment agreements (CA-PPA)
- Processes and Tools for Enterprise Applications (CA-EPT)
- Production Volume Capture (CA-PVL)
- Resource Scheduling (CA-RSH)
- SAP UI development toolkit for HTML5 - Rendering library (CA-UI5)
- Situation handling across applications, generic (CA-SIT)
- Time Sheet (CA-TS)
Cross-Application Components (CA)
- Asset Retirement Obligation Management for Oil & Gas (CA-ARO)
- Available to Promise (ATP) (CA-ATP)
- Bank (CA-BK)
- CA-VCM: Value Chain Management (CA-VCM)
- Classification (CA-CL)
- Commercial Project Management (CA-CPD)
- Cross functional developments in Asset Intell. N/W (CA-AIN)
- Cross-Application Objects in HR (CA-HR)
- Data Transformation (CA-DT)
- Document Management System (CA-DMS)
- Field Logistics (CA-FL)
- General Application Functions (CA-GTF)
  - Business Document Flow (CA-GTF-BPF)
  - Business Event Handling (CA-GTF-BEH)
  - Business Event Logging (CA-GTF-BEL)
  - Business User Management (CA-GTF-BUM)
  - Commodity Pricing Engine (CA-GTF-CPE)
  - Consent Administration (CA-GTF-CON)
  - Contextual Business Navigation (CA-GTF-CBN)
  - Country/Region-Specific Application Interface Objects (CA-GTF-CSC)
  - Cross-Application Services General Ledger (CA-GTF-GL)
  - DART (Data Retention Tool) (CA-GTF-DRT)
  - Date Function (CA-GTF-DF)
  - Digital Access (CA-GTF-DA)
  - Feature Management (CA-GTF-FM)
  - Financial Closing cockpit Add-on (CA-GTF-FCC)
  - Fiori Xperience Unit (FXU) (CA-GTF-FXU)
    - Fiori FXU Finance (CA-GTF-FXU-FI)
    - Fiori FXU Procurement (CA-GTF-FXU-MM)
    - UX - Fiori Xperience Unit (FXU) - General Topics (CA-GTF-FXU-GEN)
  - HANA Search for Business Suite (CA-GTF-HSB)
  - Responsibility Management (CA-GTF-RM)
  - S/4HANA Extensibility and Integration (CA-GTF-EI)
  - SAP S/4HANA Data Migration Cockpit Content (LTMC) (CA-GTF-MIG)
  - SAP Smart Business for S/4HANA (CA-GTF-ANA)
  - Virtual Data Model (CA-GTF-VDM)
  - s-Innovations Output Management (CA-GTF-OC)
- Integration from S/4HC to Master Data for Worker (CA-WFD)
- Issue & Activity Management (CA-IAM)
- Joint Venture und Production Sharing Accounting (CA-JVA)
- Landscape Transformation (CA-LT)
- Machine Learning (CA-ML)
- Master Data Governance. (CA-MDG)
- Master Data Integration Services (CA-MDI)
- PLM Audit Management (CA-AUD)
- Prepayment agreements (CA-PPA)
- Processes and Tools for Enterprise Applications (CA-EPT)
- Production Volume Capture (CA-PVL)
- Resource Scheduling (CA-RSH)
- SAP UI development toolkit for HTML5 - Rendering library (CA-UI5)
- Situation handling across applications, generic (CA-SIT)
- Time Sheet (CA-TS)
Customer Relationship Management (CRM)
Enterprise Contract Management (CM)
Enterprise Controlling (EC)
Enterprise information management solutions (EIM)
Environment, Health, and Safety / Product Compliance (EHS)
Financial Accounting (FI)
Financial Services (FS)
Global Trade Services (SLL)
Investment Management (IM)
LOD Components (LOD)
Legal Content Management (LCM)
Logistics - General (LO)
Logistics Execution (LE)
Materials Management (MM)
Occasional Platform User (OPU)
Payroll (PY)
Personnel Management (PA)
Plant Maintenance (PM)
Portfolio and Project Management (PPM)
Product Lifecycle Management (PLM)
Production Planning and Control (PP)
Project System (PS)
Public Sector Management (PSM)
Purchasing SAP Cloud (PUR)
Quality Management (QM)
Real Estate Management (RE)
SAP Business Warehouse (BW)
SAP Supplier Lifecycle Management (SLC)
Sales and Distribution (SD)
Service (SV)
Supply Chain Management (SCM)
Sustainability management (SUS)
Transportation Management (TM)

C_PaymentRequest

Payment Requests | view: CPAYMENTREQUEST | Extraction: Not supported | Component: Fiori FXU Accounts Payable FI-FIO-AP

Tables used: BKPF, BNK_BATCH_ITEM, PAYRQ, PAYRQC, BSEG, CRM_JEST, CRM_JSTO, REGUH, BNKA, TBNK_CUST_DEFALT, TGSBT, T001, TKA02, TCURT, KNA1, T015W, FINSC_LEDGER, T042Z, T042ZT, LFA1, TJ02T, ADCP, ADR2, ADR3, ADR6, ADRP, USR21, T001, T014, FINSC_ACTVE_APPL, FINSC_FISC_DATE, FINSC_LD_CMP

🔑 Keys (1)
💰 Amounts (4)
∑ Quantities
📅 Dates (5)
☰ Categorical (8)
Other (60)
🔗 Relations (32)

Column Name	Description
PaymentRequest	Payment Request Key Number

Column Name	Description
💲 Payment Request Currency Key (PaymentRequestCurrency):
PaymentRequestAmountInPaytCrcy	Payment Request Amount in Payment Currency
💲 Local Currency (CompanyCodeCurrency):
PaymentRequestAmountInCCCrcy	Payment Request Amount in Local Currency
💲 Currency Key of Second Local Currency (AdditionalCurrency1):
AmountInAdditionalCurrency1	Amount in Second Local Currency or Global Currency
💲 Currency Key of Third Local Currency (AdditionalCurrency2):
AmountInAdditionalCurrency2	Amount in Third Local Currency or First Freely-Def. Currency

Column Name	Description

Column Name	Description
AccountingDocumentCreationDate	Accounting Document Entry Date
ClearingDate	Clearing Date
ValueDate	Value Date for the Sending Bank
ReleaseDate	Release Date for Payment
PaymentRequestPostingDate	Day on Which Payment Request Was Posted

Column Name	Description
StatusCode	Status of Payment Request	Show values
FinancialAccountType	Financial Account Type (Free Form Payments)	Show values
IsSinglePayment	Indicator: Individual Payment	Show values
IsUrgentPayment	Urgent Payment	Show values
PaytReqIsReleasedForPosting	Indicator: Released for Posting	Show values
PaytReqIsCompleted	Indicator: Complete	Show values
PaytReqIsReleasedForPayment	Indicator: Released for Payment	Show values
IsReversed	Indicator: Payment Request Is Reversed	Show values

Column Name	Description	Domain name
CreatedByUserName	Full Name of Person	TEXT80
CreationDateTime	Creation Date and Time	TZNTSTMPL
LastChangeDateTime	Change Date and Time	TZNTSTMPL
LastChangedByUser	Changed By	XUBNAME
LastChangedByUserName	Full Name of Person	TEXT80
SystemStatusName	Object status	TEXT30
PaymentRequestVariant	Variant Name	CHAR14
PaymentRepetitiveCode	Repetitive Code	RFTTRN_BF
Customer	Customer ID	KUNNR
Supplier	Account Number of Supplier	LIFNR
PayeeName	Payee Name	TEXT80
CustomerName	Name of Customer	TEXT80
SupplierName	Name of Supplier	TEXT80
PayeeTitle	Title of the payee	TEXT15
PayeeAdditionalName2	Additional Name of the Payee 2	TEXT35
PayeeAdditionalName3	Additional Name of the Payee 3	TEXT35
PayeeAdditionalName4	Additional Name of the Payee 4	TEXT35
PayeeCityName	Payee City Name	TEXT35
PayeeStreet	Payee's Street	TEXT35
PayeePostalCode	Postal Code of the Payee	PSTLZ
PayeePOBox	P.O. box of the payee	PFACH
POBoxPostalCode	P.O. Box Postal Code	PSTLZ
PayeeFaxNumber	Fax Number of the Payee	TEXT31
PayeeTelephoneNumber	Telephone Number of the Payee	TEXT16
SupplierBankType	Supplier Bank Details ID	BVTYP
CustomerBankType	Customer Bank Details ID	BVTYP
PayeeBankAccount	Bank Account Number of The Payee	BANKN
BankDetailReference	Reference Specifications for Bank Details	CHAR20
PayeeBankControlKey	Bank Control Key of the Payee's Bank	BKONT
PayeeBankName	Name of Financial Institution	TEXT60
PayeeIBAN	IBAN of the Payee	IBAN
BankAccountHolderName	Account Holder Name	BU_KOINH
PayeeBank	Payee Bank Number	BANKL
AccountingDocument	Journal Entry	BELNR
FiscalYear	Fiscal Year	GJAHR
CompanyCodeName	Name of Company Code or Company	TEXT25
BusinessAreaName	Business Area Description	TEXT30
FinancialAccountTypeName	Financial Account Type Name	DDTEXT
CustomerSupplierAccount	Account Number	CHAR35
DocumentItemText	Item Text	TEXT50
PaymentBatch	Bank Payment Batch (CHAR10)	CHAR10
BatchUUID	GUID to identify the batch	SYSUUID
PaymentBatchItem	Batch Item Number	BNK_COM_CTR
PaymentBatchStatusText	Payment Batch Status Text	TEXT30
ClearingAccountingDocument	Clearing Journal Entry	BELNR
ClearingFiscalYear	Clearing Fiscal Year	GJAHR
PayingCompanyCodeName	Name of Company Code or Company	TEXT25
BankName	Name of Financial Institution	TEXT60
CurrencyName	Description	TEXT40
PaymentMethod	List of Respected Payment Methods	ZWELS
PaymentMethodName	Payment Method Name	TEXT30
ReferenceTypeText	Reference Type Text	TEXT50
PaymentReference	Payment Reference	CHAR30
TaxID1	Tax Number 1	STCD1
BankChain	ID for Bank Chain	CHAINID
ReleasedByUserName	Full Name of Person	TEXT80
PostingCreatedByUserName	Full Name of Person	TEXT80
SupplierFinsAuthorizationGrp	Authorization Group	BRGRU
AuthorizationGroup	Authorization Group	BRGRU
CustomerFinsAuthorizationGrp	Authorization Group	BRGRU

Master Data Relations	Join Conditions
Currency Key of Second Local Currency Client Currency Key of Second Local Currency	`C_PAYMENTREQUEST.MANDT == TCURC.MANDT` `C_PAYMENTREQUEST.ADDITIONALCURRENCY1 == TCURC.WAERS`
Currency Key of Third Local Currency Currency Key of Third Local Currency Client	`C_PAYMENTREQUEST.ADDITIONALCURRENCY2 == TCURC.WAERS` `C_PAYMENTREQUEST.MANDT == TCURC.MANDT`
Country/Region Key of Bank Client Country/Region Key of Bank	`C_PAYMENTREQUEST.MANDT == T005.MANDT` `C_PAYMENTREQUEST.BANKCOUNTRY == T005.LAND1`
Business Area Client Business Area	`C_PAYMENTREQUEST.MANDT == TGSB.MANDT` `C_PAYMENTREQUEST.BUSINESSAREA == TGSB.GSBER`
Company Code Company Code Client	`C_PAYMENTREQUEST.COMPANYCODE == T001.BUKRS` `C_PAYMENTREQUEST.MANDT == T001.MANDT`
Country/Region Key Country/Region Key Client	`C_PAYMENTREQUEST.COMPANYCODECOUNTRY == T005.LAND1` `C_PAYMENTREQUEST.MANDT == T005.MANDT`
Local Currency Local Currency Client	`C_PAYMENTREQUEST.COMPANYCODECURRENCY == TCURC.WAERS` `C_PAYMENTREQUEST.MANDT == TCURC.MANDT`
Created By User Client Created By User	`C_PAYMENTREQUEST.MANDT == USR02.MANDT` `C_PAYMENTREQUEST.CREATEDBYUSER == USR02.BNAME`
Customer Account Group Customer Account Group Client	`C_PAYMENTREQUEST.CUSTOMERACCOUNTGROUP == T077D.KTOKD` `C_PAYMENTREQUEST.MANDT == T077D.MANDT`
Instruction Key 1 ? ? Instruction Key 1	`C_PAYMENTREQUEST.[column in domain "DTWSF"] == T015W1.DTWSF` `C_PAYMENTREQUEST.[column in domain "DTWSC"] == T015W1.DTWSC` `C_PAYMENTREQUEST.DATAEXCHANGEINSTRUCTION1 == T015W1.DTWSX`
Instruction Key 2 ? ? Instruction Key 2	`C_PAYMENTREQUEST.[column in domain "DTWSF"] == T015W1.DTWSF` `C_PAYMENTREQUEST.[column in domain "DTWSC"] == T015W1.DTWSC` `C_PAYMENTREQUEST.DATAEXCHANGEINSTRUCTION2 == T015W1.DTWSX`
Instruction Key 3 ? ? Instruction Key 3	`C_PAYMENTREQUEST.[column in domain "DTWSF"] == T015W1.DTWSF` `C_PAYMENTREQUEST.[column in domain "DTWSC"] == T015W1.DTWSC` `C_PAYMENTREQUEST.DATAEXCHANGEINSTRUCTION3 == T015W1.DTWSX`
Instruction Key 4 ? ? Instruction Key 4	`C_PAYMENTREQUEST.[column in domain "DTWSF"] == T015W1.DTWSF` `C_PAYMENTREQUEST.[column in domain "DTWSC"] == T015W1.DTWSC` `C_PAYMENTREQUEST.DATAEXCHANGEINSTRUCTION4 == T015W1.DTWSX`
Instruction key for data medium exchange ? Client Instruction key for data medium exchange Country/Region Key of Bank	`C_PAYMENTREQUEST.[column in domain "DZLSCH"] == T015W.ZLSCH` `C_PAYMENTREQUEST.MANDT == T015W.MANDT` `C_PAYMENTREQUEST.DATAEXCHANGEINSTRUCTIONKEY == T015W.DTAWS` `C_PAYMENTREQUEST.BANKCOUNTRY == T015W.BANKS`
House Bank Key House Bank Key Paying Company Code Client	`C_PAYMENTREQUEST.HOUSEBANK == T012.HBKID` `C_PAYMENTREQUEST.PAYINGCOMPANYCODE == T012.BUKRS` `C_PAYMENTREQUEST.MANDT == T012.MANDT`
ID for Account Details House Bank Key Paying Company Code Client ID for Account Details	`C_PAYMENTREQUEST.HOUSEBANK == T012K.HBKID` `C_PAYMENTREQUEST.PAYINGCOMPANYCODE == T012K.BUKRS` `C_PAYMENTREQUEST.MANDT == T012K.MANDT` `C_PAYMENTREQUEST.HOUSEBANKACCOUNT == T012K.HKTID`
Payee Bank Country/Region Payee Bank Country/Region Client	`C_PAYMENTREQUEST.PAYEEBANKCOUNTRY == T005.LAND1` `C_PAYMENTREQUEST.MANDT == T005.MANDT`
Payee Bank Key Payee Bank Country/Region Payee Bank Key Client	`C_PAYMENTREQUEST.PAYEEBANKCOUNTRY == BNKA.BANKS` `C_PAYMENTREQUEST.PAYEEBANKINTERNALID == BNKA.BANKL` `C_PAYMENTREQUEST.MANDT == BNKA.MANDT`
Payee Country/Region Key Client Payee Country/Region Key	`C_PAYMENTREQUEST.MANDT == T005.MANDT` `C_PAYMENTREQUEST.PAYEECOUNTRY == T005.LAND1`
Payee Language Key	`C_PAYMENTREQUEST.PAYEELANGUAGE == T002.SPRAS`
Regional Code of the Payee Client Payee Country/Region Key Regional Code of the Payee	`C_PAYMENTREQUEST.MANDT == T005S.MANDT` `C_PAYMENTREQUEST.PAYEECOUNTRY == T005S.LAND1` `C_PAYMENTREQUEST.PAYEEREGION == T005S.BLAND`
Paying Company Code Paying Company Code Client	`C_PAYMENTREQUEST.PAYINGCOMPANYCODE == T001.BUKRS` `C_PAYMENTREQUEST.MANDT == T001.MANDT`
Payment Method Supplement Payment Method Supplement Client	`C_PAYMENTREQUEST.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE` `C_PAYMENTREQUEST.MANDT == T042F.MANDT`
Payment Request Currency Key Client Payment Request Currency Key	`C_PAYMENTREQUEST.MANDT == TCURC.MANDT` `C_PAYMENTREQUEST.PAYMENTREQUESTCURRENCY == TCURC.WAERS`
Origin Indicator Payment Request Type Origin Indicator	`C_PAYMENTREQUEST.PAYMENTREQUESTTYPE == TFIBLORIGIN.ORIGIN` `C_PAYMENTREQUEST.PAYMENTREQUESTORIGIN == TFIBLORIGIN.ORIGIN`
Payment Request Type Payment Request Type Origin Indicator	`C_PAYMENTREQUEST.PAYMENTREQUESTTYPE == TFIBLORIGIN.ORIGIN` `C_PAYMENTREQUEST.PAYMENTREQUESTORIGIN == TFIBLORIGIN.ORIGIN`
User Who Carried Out the Posting Client User Who Carried Out the Posting	`C_PAYMENTREQUEST.MANDT == USR02.MANDT` `C_PAYMENTREQUEST.POSTINGCREATEDBYUSER == USR02.BNAME`
User Who Carried Out the Release Client User Who Carried Out the Release	`C_PAYMENTREQUEST.MANDT == USR02.MANDT` `C_PAYMENTREQUEST.RELEASEDBYUSER == USR02.BNAME`
Reason for Reversal or Inverse Posting Client Reason for Reversal or Inverse Posting	`C_PAYMENTREQUEST.MANDT == T041C.MANDT` `C_PAYMENTREQUEST.REVERSALREASON == T041C.STGRD`
State Central Bank Indicator Client State Central Bank Indicator	`C_PAYMENTREQUEST.MANDT == T015L.MANDT` `C_PAYMENTREQUEST.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ`
Vendor account group Client Vendor account group	`C_PAYMENTREQUEST.MANDT == T077K.MANDT` `C_PAYMENTREQUEST.SUPPLIERACCOUNTGROUP == T077K.KTOKK`
Supplying Country/Region Supplying Country/Region Client	`C_PAYMENTREQUEST.SUPPLYINGCOUNTRY == T005.LAND1` `C_PAYMENTREQUEST.MANDT == T005.MANDT`