- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Business Accounting (FIN-BAC)
- Business Analytics (FIN-BA)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Corporate Governance (FIN-CGV)
- Financial Shared Service Center (FIN-SSC)
- Financial Supply Chain Management (FIN-FSCM)
- Financials Basis (FIN-FB)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Generic Contract Accounts Receivable and Payable (FI-CAX)
- Lease Accounting (FI-LA)
- Localization (FI-LOC)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4H Best Practices - Content and Content Activation (FI-CNT)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Strategic Enterprise Management (FIN-SEM)
- Tax Management Framework (FIN-TMF)
- Tax Subledger (FI-TXL)
- Travel Management (FI-TV)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- 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 HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
FPRL_ITEM
Item Data
|
#transactional
|
Component: Payment Progam / Payment transfer (DE, JP, US)
- 🔑 Keys (2)
- 💰 Amounts (7)
- ∑ Quantities
- 📅 Dates (11)
- ☰ Categorical (12)
- Other (119)
- 🔗 Relations (24)
| Column Name | Description | |
|---|---|---|
| MANDT | Client | |
| GUID | UUID in X form (binary) |
| Column Name | Description | |
|---|---|---|
| 💲 Currency Key (WAERS): | ||
| WRBTR | Amount in document currency | |
| SKFBT | Amount Eligible for Cash Discount in Document Currency | |
| WSKTO | Cash Discount Amount in Document Currency | |
| QBSHB | Withholding Tax Amount (in Document Currency) | |
| PAMTF | Payment Request Amount in Payment Currency | |
| 💲 Update Currency for General Ledger Transaction Figures (PSWSL): | ||
| PSWBT | Amount for Updating in General Ledger | |
| PSSKT | Cash Discount Deduction for the Item | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| BUDAT | Posting Date in the Document | |
| BLDAT | Document Date in Document | |
| ZFBDT | Baseline Date for Due Date Calculation | |
| LAUFD_PAY | Date on Which the Program Is to Be Run | |
| LAUFD | Date of Proposal Run | |
| ZALDT | Posting Date of Payment Document | |
| VALUT | Value date | |
| AUSFD | Due date of the paid items | |
| ANFAE | Bill of Exchange Payment Request Due Date | |
| WEFAE | Bill of Exchange Due Date | |
| WDATE | Bill of Exchange Issue Date |
| Column Name | Description | |
|---|---|---|
| SHKZG | Debit/Credit Indicator | Show values |
| KOART | Account type | Show values |
| XREBZ | Indicator: Item Is an Invoice-Related Credit Memo | Show values |
| XCPDD | Indicator: Address and Bank Data Set Individually | Show values |
| XINVE | Indicator: Capital Goods Affected? | Show values |
| EPIC_STATUS | Item Status | Show values |
| EPIC_EDITED | General Flag | Show values |
| AVC_STATUS | Cash Control Status | Show values |
| XF110_EXEC | General Flag | Show values |
| BTYP1 | Type of bank in a bank chain (correspondent, intermediary) | Show values |
| BTYP2 | Type of bank in a bank chain (correspondent, intermediary) | Show values |
| BTYP3 | Type of bank in a bank chain (correspondent, intermediary) | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| CREA_USER | Created By | USNAM | |
| CREA_TIME | Created On | FPRL_TIMESTAMP | |
| CHANGE_USER | Last Changed By | USNAM | |
| CHANGE_TIME | Last Changed On | FPRL_TIMESTAMP | |
| BELNR | Document Number of an Accounting Document | BELNR | |
| GJAHR | Fiscal Year | GJAHR | |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | |
| FILKD | Account Number of the Branch | MAXKK | |
| EMPFB | Payee/Payer | MAXKK | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | |
| QSSKZ | Withholding Tax Code | QSSKZ | |
| SGTXT | Item Text | TEXT50 | |
| ZBD1T | Cash discount days 1 | ZBDXT | |
| ZBD2T | Cash discount days 2 | ZBDXT | |
| ZBD3T | Net Payment Terms Period | ZBDXT | |
| ZBD1P | Cash discount percentage 1 | PRZ23 | |
| ZBD2P | Cash Discount Percentage 2 | PRZ23 | |
| ESRNR | ISR subscriber number | ESRNR | |
| ESRRE | ISR/QR Reference Number | ESRRE | |
| ESRPZ | POR check digit | CHAR2 | |
| STCEG | VAT Registration Number | STCEG | |
| XBLNR | Reference Document Number | XBLNR1 | |
| NPLNR | Network Number for Account Assignment | AUFNR | |
| AUFPL | Routing number of operations in the order | AUFPL | |
| ZUONR | Assignment number | ZUONR | |
| VERTN | Contract Number | RANL | |
| REBZT | Follow-On Document Type | REBZT | |
| REBZG | Document No. of the Invoice to Which the Transaction Belongs | BELNR | |
| REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | GJAHR | |
| REBZZ | Line Item in the Relevant Invoice | BUZEI | |
| KOSTL | Cost Center | KOSTL | |
| VBEL2 | Sales Document | VBELN | |
| POSN2 | Sales Document Item | POSNR | |
| PRCTR | Profit Center | PRCTR | |
| XREF1 | Business Partner Reference Key | CHAR12 | |
| XREF2 | Business Partner Reference Key | CHAR12 | |
| XREF3 | Reference key for line item | CHAR20 | |
| DTWS1 | Instruction Key 1 | DTWSX | |
| DTWS2 | Instruction Key 2 | DTWSX | |
| DTWS3 | Instruction key 3 | DTWSX | |
| DTWS4 | Instruction key 4 | DTWSX | |
| BUPLA | Business Place | J_1BBRANCH | |
| PPRCT | Partner Profit Center | PRCTR | |
| GRANT_NBR | Grant | GM_GRANT_NBR | |
| FKBER | Functional Area | FKBER | |
| GEBER | Fund | BP_GEBER | |
| KEYNO | Key Number for Payment Request | PRQ_KEYNO | |
| ORIGIN | Origin Indicator | FIBL_ORIGIN | |
| EPIC_PROCESSOR | Processor | XUBNAME | |
| AVC_PRIORITY | Cash Control Priority | ||
| FIPOS_ES | Commitment Item | FIPOS | |
| FISTL_ES | Funds Center | FISTL | |
| GRANT_NBR_ES | Grant | GM_GRANT_NBR | |
| FKBER_ES | Functional Area | FKBER | |
| GEBER_ES | Fund | BP_GEBER | |
| PROJK_ES | Work Breakdown Structure Element (WBS Element) | PS_POSNR | |
| CISUB1_ES | Substring 1 of Commitment Item | CHAR10 | |
| CISUB2_ES | Substring 2 of Commitment Item | CHAR10 | |
| CISUB3_ES | Substring 3 of Commitment Item | CHAR10 | |
| CISUB4_ES | Substring 4 of Commitment Item | CHAR10 | |
| CISUB5_ES | Substring 5 of Commitment Item | CHAR10 | |
| LOTKZ_ES | Lot Number for Requests | LOTKZ | |
| EBELN_CO | Purchasing Document Number | EBELN | |
| SAPLONGNUM | Smart Number | /SAPPSPRO/LONGNUM | |
| KBLNR | Document Number for Earmarked Funds | KBLNR | |
| ACCOUNTANT | Accountant | FPCR_ACCOUNTANT | |
| CO_STATUS | Status of Garnishment | FPCL_CO_STAT | |
| STCD2 | Tax Number 2 | STCD2 | |
| POKEN | Item Indicator | CHAR3 | |
| LAUFI_PAY | Additional Identification | LAUFI | |
| VBLNR_PAY | Document Number of the Payment Document | BELNR | |
| PYORD_PAY | Payment Order | PYORD | |
| LAUFI | Payment Proposal | LAUFI | |
| KURST | Alternative Ex.Rate Type for Payments in Foreign Currency | KURST | |
| JOBCOUNT | Job ID | TEXT8 | |
| ABSBU | Sending company code | BUKRS | |
| ZNME1 | Name of the payee | TEXT35 | |
| ZPSTL | Postal Code of the Payee | PSTLZ | |
| ZORT1 | City of the payee | TEXT35 | |
| ZLAND | Country/Region Key | LAND1 | |
| ZREGI | Regional code of the payee | REGIO | |
| ZSPRA | Language key of the payee | SPRAS | |
| NAME1 | Name 1 | NAME | |
| ZBVTY | Bank Data Indicator for the Payee | BVTYP | |
| ZBNKS | Country/Region Key | LAND1 | |
| ZBNKY | Bank key of the payee's bank | BANKK | |
| ZBNKL | Bank number of the payee's bank | BANKL | |
| ZBNKN | Bank account number of the payee | BANKN | |
| ZBKON | Bank Control Key of the Payee's Bank | BKONT | |
| BKREF | Reference Details for Bank Details | CHAR20 | |
| ZSWIF | SWIFT/BIC for International Payments | SWIFT | |
| ZIBAN | IBAN (International Bank Account Number) | IBAN | |
| KOINH | Account Holder Name | KOINH | |
| HKTID | ID for Account Details | HKTID | |
| UBNKS | Country/Region Key of Bank | LAND1 | |
| UBNKY | Bank Key of Our Bank | BANKK | |
| UBNKL | Bank number of our bank | BANKL | |
| UBKNT | Our account number at the bank | BANKN | |
| UBKON | Bank control key at our bank | BKONT | |
| UBHKT | G/L Account Number for Our Bank Account / Bank Subaccount | SAKNR | |
| DTAWS | Instruction Key for Data Medium Exchange | DTAWS | |
| BUSAB | Accounting Clerk Abbreviation | BUSAB | |
| EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | CHAR12 | |
| KIDNO | Payment Reference | CHAR30 | |
| RFTTRN | Payment code | RFTTRN_BF | |
| BNKS1 | Country/Region Key of Bank | LAND1 | |
| BNKL1 | Bank Keys | BANKK | |
| BNKN1 | Bank account number | BANKN | |
| BNKS2 | Country/Region Key of Bank | LAND1 | |
| BNKL2 | Bank Keys | BANKK | |
| BNKN2 | Bank account number | BANKN | |
| BNKS3 | Country/Region Key of Bank | LAND1 | |
| BNKL3 | Bank Keys | BANKK | |
| BNKN3 | Bank account number | BANKN | |
| MGUID | SEPA Mandate: GUID of Mandate | ||
| MNDID | Unique Reference to Mandate for each Payee | ID035 | |
| INV_NO | Document Number or Invoice Reference Number | BELNR | |
| INV_YEAR | Fiscal Year of DocNo/Inf.ref. | GJAHR | |
| INV_ITEM | Line Item within Accounting Document or Relevant Invoice | BUZEI |
| Master Data Relations | Join Conditions |
|---|---|
Approval Level
|
|
| Payment Release List Application ID | FPRL_ITEM.APPLIC == FPRL_APPLIC.APPLICATION |
Document Type
| |
| Posting Key | |
| Company Code | |
| Business Area | |
Short Key for a House Bank
| |
General Ledger Account
| |
| Customer Number | |
Supplying Country/Region
| |
| Account Number of Supplier | |
| State Central Bank Indicator | |
Payment Method
| |
G/L Account Number
| |
| Item Status ID | FPRL_ITEM.STATUS == FPRL_ITEM_STAT.STATUS |
Special G/L Indicator
| |
| Payment method supplement | |
| Company ID of Trading Partner | |
| Currency Key | |
| Paying company code | |
Payment Block Key
|