BNK_BATCH_HEADER
Batch Header
BNK_BATCH_HEADER is an SAP database table in S/4HANA. Batch Header. It contains 38 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /PF1/P_BNK_BATCH_HEADER | view | from | Batch Header | |
| I_AprvBkPaytBatchInBckgndJob | view_entity | inner | COMPOSITE | Payment Batch In Background Job |
| I_BankPaymentBatch | view | from | BASIC | Bank Payment Batch Header |
| I_Paymentstatistics_Base | view | left_outer | BASIC | Base View for Payment Statistics |
| P_Bcmitem | view | left_outer | BASIC | Analyze Payment Detail BCM Item |
| VFCP_DDL_BCM | view | left_outer |
Fields (38)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | guid | BNK_COM_BTCH_GUID | Batch GUID | |||
| batch_no | BNK_COM_BTCH_NO | Batch Number | ||||
| rule_id | BNK_COM_BTCH_RULE_ID | Rule Id | ||||
| item_cnt | BNK_COM_BTCH_CTR | No. of Paymt | ||||
| laufd | BNK_COM_BTCH_MRGE_DAT | Merge date | ||||
| laufi | BNK_COM_BTCH_MRGE_ID | Merge Id | ||||
| xvorl | XVORL | Indicator: Only Proposal Run? | ||||
| laufd_f | BNK_COM_BTCH_FILE_DAT | File Date | ||||
| laufi_f | BNK_COM_BTCH_FILE_ID | File Id | ||||
| batch_sum | BNK_COM_BTCH_AMOUNT | Btch Amt | ||||
| batch_curr | BNK_COM_BTCH_CURR | Batch Currency | ||||
| batch_sign | SIGN | +/- Sign | ||||
| paym_sum | RWBTR | Amount Paid | ||||
| paym_curr | PYCUR | Paymnt Crcy | ||||
| max_pay_amt | BNK_COM_MAX_PAYMNT_AMOUNT | M.PymntAmt | ||||
| status | BNK_COM_BTCH_STATUS_ID | Status Id | ||||
| crusr | BNK_COM_CREATE_USER | CreateUser | ||||
| crtime | BNK_COM_CREATE_TIME | Create Time | ||||
| crdate | BNK_COM_CREATE_DATE | Create Date | ||||
| chusr | BNK_COM_CHANGE_USER | ChangeUser | ||||
| chtime | BNK_COM_CHANGE_TIME | Change Time | ||||
| chdate | BNK_COM_CHANGE_DATE | Change Date | ||||
| cur_processor | BNK_COM_CUR_PROCESSOR | Cur. processor | ||||
| archive_status | BNK_COM_ARCHIVE_STATUS | Arc_Status | ||||
| zbukr | DZBUKR | Paying co. code | ||||
| hbkid | HBKID | House Bank | ||||
| tot_btch_amt | BNK_COM_BTCH_AMT_IN_RULE_CURR | Btch Amt(rcurr) | ||||
| maxpayamt_rulecu | BNK_COM_MAX_PYMNTAMT_IN_RULCUR | M.PymtAmt(rcur) | ||||
| grp_field1_value | BNK_COM_GRP_FLD_VAL1 | Grp Fld value1 | ||||
| grp_field2_value | BNK_COM_GRP_FLD_VAL2 | Grp Fld value2 | ||||
| xreset | XFELD | Checkbox | ||||
| origin | BNK_BTCH_ORIGIN | Batch Origin | ||||
| cur_sts | BNK_BAT_CUR_STS | Batch Current Status | ||||
| xno_partial | BNK_COM_XNO_PARTIAL | No Partial Approval | ||||
| sdm_version | BNK_BAT_SDM_VERSION | SDM Version | ||||
| ext_stat | BNK_COM_STSCD | Ext. Status Cd | ||||
| gpi_code_long | BNK_COM_GPI_CODE_LONG | GPI Reason Codes |
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 Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BNK_BATCH_HEADER (
MANDT, -- Client [MANDT]
GUID, -- Batch GUID [BNK_COM_BTCH_GUID]
BATCH_NO, -- Batch Number [BNK_COM_BTCH_NO]
RULE_ID, -- Rule Id [BNK_COM_BTCH_RULE_ID]
ITEM_CNT, -- No. of Paymt [BNK_COM_BTCH_CTR]
LAUFD, -- Merge date [BNK_COM_BTCH_MRGE_DAT]
LAUFI, -- Merge Id [BNK_COM_BTCH_MRGE_ID]
XVORL, -- Indicator: Only Proposal Run? [XVORL]
LAUFD_F, -- File Date [BNK_COM_BTCH_FILE_DAT]
LAUFI_F, -- File Id [BNK_COM_BTCH_FILE_ID]
BATCH_SUM, -- Btch Amt [BNK_COM_BTCH_AMOUNT]
BATCH_CURR, -- Batch Currency [BNK_COM_BTCH_CURR]
BATCH_SIGN, -- +/- Sign [SIGN]
PAYM_SUM, -- Amount Paid [RWBTR]
PAYM_CURR, -- Paymnt Crcy [PYCUR]
MAX_PAY_AMT, -- M.PymntAmt [BNK_COM_MAX_PAYMNT_AMOUNT]
STATUS, -- Status Id [BNK_COM_BTCH_STATUS_ID]
CRUSR, -- CreateUser [BNK_COM_CREATE_USER]
CRTIME, -- Create Time [BNK_COM_CREATE_TIME]
CRDATE, -- Create Date [BNK_COM_CREATE_DATE]
CHUSR, -- ChangeUser [BNK_COM_CHANGE_USER]
CHTIME, -- Change Time [BNK_COM_CHANGE_TIME]
CHDATE, -- Change Date [BNK_COM_CHANGE_DATE]
CUR_PROCESSOR, -- Cur. processor [BNK_COM_CUR_PROCESSOR]
ARCHIVE_STATUS, -- Arc_Status [BNK_COM_ARCHIVE_STATUS]
ZBUKR, -- Paying co. code [DZBUKR]
HBKID, -- House Bank [HBKID]
TOT_BTCH_AMT, -- Btch Amt(rcurr) [BNK_COM_BTCH_AMT_IN_RULE_CURR]
MAXPAYAMT_RULECU, -- M.PymtAmt(rcur) [BNK_COM_MAX_PYMNTAMT_IN_RULCUR]
GRP_FIELD1_VALUE, -- Grp Fld value1 [BNK_COM_GRP_FLD_VAL1]
GRP_FIELD2_VALUE, -- Grp Fld value2 [BNK_COM_GRP_FLD_VAL2]
XRESET, -- Checkbox [XFELD]
ORIGIN, -- Batch Origin [BNK_BTCH_ORIGIN]
CUR_STS, -- Batch Current Status [BNK_BAT_CUR_STS]
XNO_PARTIAL, -- No Partial Approval [BNK_COM_XNO_PARTIAL]
SDM_VERSION, -- SDM Version [BNK_BAT_SDM_VERSION]
EXT_STAT, -- Ext. Status Cd [BNK_COM_STSCD]
GPI_CODE_LONG, -- GPI Reason Codes [BNK_COM_GPI_CODE_LONG]
PRIMARY KEY (MANDT, GUID)
);
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