SAP table BNK_BATCH_HEADER (Batch Header)
SAP table BNK_BATCH_HEADER has 2 primary key fields being MANDT,GUID.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
GUID to identify the batch
RAW
16
0
BNK_COM_BTCH_GUID
BATCH_NO
Batch Identification Number
NUMC
10
0
BNK_COM_BTCH_NO
RULE_ID
Rule Id
CHAR
10
0
TBNK_RULE
BNK_COM_BTCH_RULE_ID
ITEM_CNT
Number of Payments
NUMC
5
0
BNK_COM_BTCH_CTR
LAUFD
Merge Date
DATS
8
0
BNK_COM_BTCH_MRGE_DAT
LAUFI
Merge Id
CHAR
6
0
BNK_COM_BTCH_MRGE_ID
XVORL
Indicator: Only Proposal Run?
CHAR
1
0
XVORL
LAUFD_F
File Date
DATS
8
0
BNK_COM_BTCH_FILE_DAT
LAUFI_F
File Id
CHAR
6
0
BNK_COM_BTCH_FILE_ID
BATCH_SUM
Batch Amount in batch currency
CURR
13
2
BNK_COM_BTCH_AMOUNT
BATCH_CURR
Batch Currency
CUKY
5
0
BNK_COM_BTCH_CURR
BATCH_SIGN
+/- Sign
CHAR
1
0
SIGN
Possible values
PAYM_SUM
Amount Paid in the Payment Currency
CURR
13
2
RWBTR_CS
PAYM_CURR
Currency for Automatic Payment
CUKY
5
0
PYCUR
MAX_PAY_AMT
Maximum payment amount in batch currency
CURR
13
2
BNK_COM_MAX_PAYMNT_AMOUNT
STATUS
Status Id
RAW
16
0
BNK_COM_BTCH_STATUS_ID
CRUSR
Create User
CHAR
12
0
BNK_COM_CREATE_USER
CRTIME
Create Time
TIMS
6
0
BNK_COM_CREATE_TIME
CRDATE
Create Date
DATS
8
0
BNK_COM_CREATE_DATE
CHUSR
Change User
CHAR
12
0
BNK_COM_CHANGE_USER
CHTIME
Change Time
TIMS
6
0
BNK_COM_CHANGE_TIME
CHDATE
Change Date
DATS
8
0
BNK_COM_CHANGE_DATE
CUR_PROCESSOR
Current processor
CHAR
12
0
BNK_COM_CUR_PROCESSOR
ARCHIVE_STATUS
Archive Status
CHAR
2
0
BNK_COM_ARCHIVE_STATUS
Possible values
01
Document not archived
02
Document set for Archive
03
Document Archived
ZBUKR
Paying company code
CHAR
4
0
DZBUKR
HBKID
Short Key for a House Bank
CHAR
5
0
HBKID
TOT_BTCH_AMT
Total batch amount in rule currency
CURR
13
2
BNK_COM_BTCH_AMT_IN_RULE_CURR
MAXPAYAMT_RULECU
Maximum payment Amount in rule currency
CURR
13
2
BNK_COM_MAX_PYMNTAMT_IN_RULCUR
GRP_FIELD1_VALUE
Grouping field val1
CHAR
30
0
BNK_COM_GRP_FLD_VAL1
GRP_FIELD2_VALUE
Grouping field val2
CHAR
30
0
BNK_COM_GRP_FLD_VAL2
XRESET
Checkbox
CHAR
1
0
XFELD
Possible values
ORIGIN
Identification of Batch Origin
CHAR
10
0
BNK_BTCH_ORIGIN
Possible values
Internal
APM
Advanced Payment Management
CUR_STS
Batch Current Status
CHAR
5
0
BNK_BAT_CUR_STS
XNO_PARTIAL
Partial Approval Not Possible in BNK_INI (Flag)
CHAR
1
0
BNK_COM_XNO_PARTIAL
SDM_VERSION
SDM: Version field for BNK_BATCH_HEADER
CHAR
2
0
BNK_BAT_SDM_VERSION
Possible values
01
Migrated
02
Migrated 02 version
EXT_STAT
Status Code
CHAR
35
0
BNK_COM_STSCD
GPI_CODE_LONG
Current GPI Status Reason Codes (Long)
CHAR
60
0
BNK_COM_GPI_CODE_LONG
BNK_BATCH_HEADER foreign key relationships
Table
Field
Check Table
Check Field
0 BNK_BATCH_HEADER
MANDT
T000 Clients
MANDT
1 BNK_BATCH_HEADER
RULE_ID
TBNK_RULE Rule definition table
MANDT
1 BNK_BATCH_HEADER
RULE_ID
TBNK_RULE Rule definition table
RULE_ID
1 BNK_BATCH_HEADER
RULE_ID
TBNK_RULE Rule definition table
PRIORITY