- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- 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)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
- 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_LockboxBatchItemWorklist
View for Worklist of Lockbox items
| view: CLBBATITMWL
| Extraction:
Not supported
| Component: Fiori UI for General Ledger Accounting
Tables used:
FAR_IPF_HEADER, FEBEP, FEBRE, FEBRE_ORIG, SRGBTBREL, FEBKO, FEBKO, FEBEP, FEBKO_REVERSED, FEBKO, FAR_IPF_LINE, BNKA, FCLM_BAM_ACLINK2, T012, 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, T033F
Column Name | Description | |
---|---|---|
LockboxBatchInternalKey | Short Key for Bank Statement (Surrogate Key) | |
LockboxBatchItem | Memo Record Number (Line Item Number in Bank Statement) | |
LockboxBatch | Batch Number (Bundle Number) |
Column Name | Description | |
---|---|---|
💲 Account Currency Key (Currency): | ||
AmountInTransactionCurrency | Payment Amount | |
FeeAmountInTransactionCrcy | Fees in Account Currency | |
OverdueChargeAmtInTransacCrcy | Overdue Charges from/to Partners in Account Currency | |
💲 Foreign Currency Key (Not Account Currency) (OriginalCurrency): | ||
FeeAmountInOriginalCrcy | Fees in Foreign Currency (Not Same as Account Currency) | |
AmountInOriginalCurrency | Foreign Currency Amount (Different from Account Currency) |
Column Name | Description |
---|
Column Name | Description | |
---|---|---|
ValueDate | Value Date of the Item to Be Cleared | |
DepositDate | Deposit Date | |
BankPostingDate | Posting Date at the Bank | |
PostingDate | Posting Date in the Document | |
BankStatementImportDate | Import Date into Bank Data Buffer | |
BankStatementImportTime | Import Time into Bank Data Buffer |
Column Name | Description | |
---|---|---|
BankLedgerIsPosted | Indicator that posting Area 1 was posted or not | Show values |
SubledgerIsPostedSuccessfully | Indicator that posting Area 2 was posted or not | Show values |
MemoLineIsChanged | Note to Payee Has Been Changed Manually | Show values |
PaymentAdviceAccountType | Payment Advice Account Type | Show values |
TreasuryContractType | Contract Type | Show values |
MachineLrngBankStmntItemStatus | Machine Learning Status of Item | Show values |
Column Name | Description | Domain name | |
---|---|---|---|
Lockbox | Lockbox Number | CHAR7 | |
LockboxBatchOrigin | null | ||
LockboxBatchDestination | null | ||
HouseBank | House Bank Key | HBKID | |
HouseBankAccount | House Bank Account | HKTID | |
Customer | Customer Number | KUNNR | |
Cheque | Cheque Number | CHCKN | |
PartnerBank | Partner Bank Account: Bank Number | BANKK | |
PartnerBankAccount | Partner Bank Account: Account Number | BANKN | |
MemoLine | Memo Line | FAR_MEMO_LINE | |
MemoLine1 | Line 1 of Memo Line | CHAR65 | |
PaymentAdvice | Payment Advice Number | AVSID | |
BankLedgerDocument | Document Number of an Accounting Document | BELNR | |
AssignmentReference | Assignment number | ZUONR | |
PaymentExternalTransacType | External Payment Transaction | CHAR3 | |
DocumentItemText | Text Field | TEXT50 | |
DocumentReferenceID | Reference Document Number | XBLNR1 | |
FiscalYear | Fiscal Year | GJAHR | |
BankLedgerAcctgDocFiscalYear | Fiscal Year of Bank Accounting Document | GJAHR | |
LockboxItemLifeCycSts | null | ||
LockboxProcessingStatus | null | ||
SubledgerOnAccountDocument | Payment on account document number | BELNR | |
SubledgerDocument | Subledger document number | BELNR | |
SubledgerAcctgDocFiscalYear | Fiscal Year of Subledger Accounting Document | GJAHR | |
BankPostingKey | Text Key | CHAR4 | |
BankReference | Bank Reference Number | CHAR35 | |
BusinessArea | Business Area | CHAR4 | |
BusinessPartnerName | Business Partner | CHAR55 | |
TreasuryContract | Contract Number | RANL | |
DaybookEntry | Daybook Number | CHAR10 | |
DunningBlockingReason | Dunning Block | MANSP | |
ExchangeRate | Exchange Rate: Foreign Currency to Account Currency | KURSF | |
PartnerBankIBAN | Partner Bank Account: IBAN | IBAN | |
PartnerBankSWIFTCode | SWIFT Code of Partner Bank | SWIFT | |
PaymentAdviceAccount | Account Number | KTONR | |
PaymentAdviceAccountTypeName | Short Text for Fixed Values | DDTEXT | |
PaymentReference | Payment Reference | CHAR30 | |
PostingErrorStatus | Error Status | CHAR4 | |
ReferenceDocument | Reference Key | AWKEY | |
ReferenceDocumentType | Reference procedure | AWTYP | |
ReturnReason | Customer-to-Customer Reference | CHAR35 | |
ValueDateTime | Value Date Time | TIME6 | |
ProfitCenter | Profit Center | PRCTR | |
IsCompleted | Line Item Completed | CHAR1 | |
CostCenter | Cost Center | CHAR10 | |
BankAccount | Bank account number | BANKN | |
BankAccountHolderName | Bank Account Holder | CHAR35 | |
BankAccountAdditionalName | Special Account Name | CHAR35 | |
BankAccountType | Bank Account Type | CHAR23 | |
BankName | Name of Financial Institution | TEXT60 | |
CreatedByUser | User Who Fills the Bank Data Buffer | CHAR12 | |
InterestRateInPercent | Credit Interest | HZINS_EB | |
BankAccountReferenceText | Reference Details for Bank Details | CHAR20 | |
DebitCreditCode | Debit/Credit Key for Line Items (for Bank Purposes) | CHAR1 | |
BankStatementItemDraftUUID | Draft key (raw16) | RAW16 | |
LockboxSubledgerDocument | Number of second subledger document | BELNR | |
MachineLrngBkStmntItemStatName | Machine Learning Status Name of Item | DDTEXT |
Master Data Relations | Join Conditions |
---|---|
Bank Account Technical ID
|
|
Reprocessing Reason Code
|
|
Chart of Accounts
| |
Company code
| |
General ledger account
| |
Foreign currency (not account currency)
| |
Partner Bank
|