BNK_BATCH_ITEM

Transparent Table Application Table

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)

ViewTypeJoinVDMDescription
/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)

KeyField Data ElementDescription DomainTypeLength
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)
);