BNK_BATCH_ITEM
Batch Payment Items
BNK_BATCH_ITEM is an SAP database table in S/4HANA. Batch Payment Items. It contains 24 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /PF1/I_BNK_BATCH_ITEM | view | from | Batch Items | |
| I_BankPaymentBatchItem | view | from | BASIC | Bank Payment Batch Item |
| I_Paymentstatistics_Base | view | from | BASIC | Base View for Payment Statistics |
| P_Bcmitem | view | from | BASIC | Analyze Payment Detail BCM Item |
| VFCP_DDL_BCM | view | from |
Fields (24)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | guid | BNK_COM_BTCH_GUID | Batch GUID | |||
| KEY | item_no | BNK_COM_BTCH_CNT | Item Number | |||
| batch_no | BNK_COM_BTCH_NO | Batch Number | ||||
| pay_grp_id | BNK_COM_PAY_GRP_ID | Pymt_Group_id | ||||
| lifnr | LIFNR | Supplier | ||||
| kunnr | KUNNR | Customer | ||||
| empfg | EMPFG | Pmnt Recipient | ||||
| vblnr | VBLNR | Payment Doc.No. | ||||
| grpno | GRPNO_FPM | Group No. | ||||
| laufd_o | LAUFD | Run On | ||||
| laufi_o | LAUFI | Identification | ||||
| zbukr | DZBUKR | Paying co. code | ||||
| laufd | BNK_COM_BTCH_MRGE_DAT | Merge date | ||||
| laufi | BNK_COM_BTCH_MRGE_ID | Merge Id | ||||
| xvorl | XVORL | Indicator: Only Proposal Run? | ||||
| status | BNK_COM_BTCH_STATUS_ID | Status Id | ||||
| amt_rulecu | BNK_COM_PYMNTAMT_IN_RULCU | PymtAmt(rlcur) | ||||
| hbkid | HBKID | House Bank | ||||
| paym_system | BNK_PAYM_SYSTEM | Payment System | ||||
| cur_sts | BNK_ITM_CUR_STS | Payment Current Status | ||||
| end_to_end_id_ext | BNK_COM_END_TO_END_ID_EXT | End to End ID | ||||
| ext_stat | BNK_COM_STSCD | Ext. Status Cd | ||||
| gpi_code | BNK_COM_GPI_CODE | GPI Reason Code |
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.
-- Batch Payment Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BNK_BATCH_ITEM (
MANDT, -- Client [MANDT]
GUID, -- Batch GUID [BNK_COM_BTCH_GUID]
ITEM_NO, -- Item Number [BNK_COM_BTCH_CNT]
BATCH_NO, -- Batch Number [BNK_COM_BTCH_NO]
PAY_GRP_ID, -- Pymt_Group_id [BNK_COM_PAY_GRP_ID]
LIFNR, -- Supplier [LIFNR]
KUNNR, -- Customer [KUNNR]
EMPFG, -- Pmnt Recipient [EMPFG]
VBLNR, -- Payment Doc.No. [VBLNR]
GRPNO, -- Group No. [GRPNO_FPM]
LAUFD_O, -- Run On [LAUFD]
LAUFI_O, -- Identification [LAUFI]
ZBUKR, -- Paying co. code [DZBUKR]
LAUFD, -- Merge date [BNK_COM_BTCH_MRGE_DAT]
LAUFI, -- Merge Id [BNK_COM_BTCH_MRGE_ID]
XVORL, -- Indicator: Only Proposal Run? [XVORL]
STATUS, -- Status Id [BNK_COM_BTCH_STATUS_ID]
AMT_RULECU, -- PymtAmt(rlcur) [BNK_COM_PYMNTAMT_IN_RULCU]
HBKID, -- House Bank [HBKID]
PAYM_SYSTEM, -- Payment System [BNK_PAYM_SYSTEM]
CUR_STS, -- Payment Current Status [BNK_ITM_CUR_STS]
END_TO_END_ID_EXT, -- End to End ID [BNK_COM_END_TO_END_ID_EXT]
EXT_STAT, -- Ext. Status Cd [BNK_COM_STSCD]
GPI_CODE, -- GPI Reason Code [BNK_COM_GPI_CODE]
PRIMARY KEY (MANDT, GUID, ITEM_NO)
);
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