- 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)
- 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)
- 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)
FARMLVD_PAYMTADV_LOCKBOX
Open Payment Advice created by Lockbox
| view: FMLVPALBX
| Extraction:
Not supported
| Component: Financial Cash Application Intelligence
Tables used:
AVIK, AVIP, FEBEP, FEBRE, FEBRE_ORIG, SRGBTBREL, FEBKO, FEBKO_REVERSED, BSEG, T001, TKA02, T005, FEB_TATYP, FEB_TATYP_C, FEB_TATYP_T, FEB_TATYP_TC, T028I, FCLM_BAM_ACLINK2, FDC_D_DFT_AC_HDR, FDC_D_DFT_HDR, FEB_REPRO_RRCT, T012, T028E, T001, T014, T033F
- 🔑 Keys
- 💰 Amounts (3)
- ∑ Quantities
- 📅 Dates (1)
- ☰ Categorical (3)
- Other (29)
- 🔗 Relations (5)
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| PaidAmountInPaytCurrency | Payment Amount from the Payment Advice Header | |
| 💲 Currency Key (Currency): | ||
| NetPaymentAmountInPaytCurrency | Net Payment Amount with +/- Sign | |
| GrossAmountInPaymentCurrency | Gross Amount | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| CreationDate | Date on which the record was created |
| Column Name | Description | |
|---|---|---|
| PaymentAdviceAccountType | Payment Advice Account Type | Show values |
| PaymentAdviceAltvAccountType | Account Type | Show values |
| IsPostedOnAccount | Indicator: Posting on Account | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| StatementShortID | Short Key for Bank Statement (Surrogate Key) | KUKEY_EB | |
| StatementItem | Memo Record Number (Line Item Number in Bank Statement) | NUM5 | |
| PaymentAdviceAccount | Account Number | KTONR | |
| PaymentAdvice | Payment Advice Number | AVSID | |
| PaymentAdviceItem | Payment Advice Item | AVSPO | |
| FiscalYear | Fiscal Year | GJAHR | |
| AccountingDocument | Document Number of an Accounting Document | BELNR | |
| BillingDocument | Billing Document | VBELN | |
| DocumentReferenceID | Reference Document | XBLNR1 | |
| AssignmentReference | Assignment number | ZUONR | |
| Reference1IDByBusinessPartner | Business Partner Reference Key 1 | CHAR12 | |
| Reference2IDByBusinessPartner | Business Partner Reference Key 2 | CHAR12 | |
| DocumentItemText | Item Text | TEXT50 | |
| PaymentReference | Payment Reference | CHAR30 | |
| PurchasingDocReferenceByCust | Customer Reference | BSTNK | |
| PaymentAdviceAltvAccount | Alternative Account (Payment Advice Management) | KTONR | |
| PaytDifferenceReasonExtCode | External Reason Code for Payment Differences | CHAR3 | |
| Ref_Paid_Amount | null | ||
| PartnerBank | null | ||
| PartnerBankAccount | null | ||
| LockboxFreeText_h | null | ||
| Invoice | null | ||
| PaymentAmount | null | ||
| DeductionAmountInPaytCurrency | null | ||
| Ref_Reason | null | ||
| LockboxFreeText | null | ||
| BankStatementKey | null | ||
| ReceivableKey | null | ||
| PaymentAdviceKey | null |
| Master Data Relations | Join Conditions |
|---|---|
Alternative Company Code (Payment Advice Management)
| |
Company Code
| |
Country/Region Key
| |
Currency Key
| |
Reason Code for Payments
|