SAP table BNK_BATCH_ITEM (Batch Payment Items)
SAP table BNK_BATCH_ITEM has 3 primary key fields being MANDT,GUID,ITEM_NO.
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
MANDT
GUID to identify the batch
RAW
16
0
BNK_COM_BTCH_GUID
Item Count Number
NUMC
5
0
BNK_COM_BTCH_CNT
BATCH_NO
Batch Identification Number
NUMC
10
0
BNK_COM_BTCH_NO
PAY_GRP_ID
Payment Group Identifier (FPM_Key)
CHAR
15
0
BNK_COM_PAY_GRP_ID
LIFNR
Account Number of Supplier
CHAR
10
0
LIFNR
KUNNR
Customer Number
CHAR
10
0
KUNNR
EMPFG
Payment Recipient Code
CHAR
16
0
EMPFG
VBLNR
Document Number of the Payment Document
CHAR
10
0
VBLNR
GRPNO
Grouping Criterium for Payments
INT4
10
0
GRPNO_FPM
Possible values
1
Exceptions
2
Zero balance
3
Intercompany billing
LAUFD_O
Date on Which the Program Is to Be Run
DATS
8
0
LAUFD
LAUFI_O
Additional Identification
CHAR
6
0
LAUFI
ZBUKR
Paying company code
CHAR
4
0
*
DZBUKR
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
STATUS
Status Id
RAW
16
0
BNK_COM_BTCH_STATUS_ID
AMT_RULECU
Payment amount in rule currency
CURR
13
2
BNK_COM_PYMNTAMT_IN_RULCU
HBKID
Short Key for a House Bank
CHAR
5
0
HBKID
PAYM_SYSTEM
Payment System
CHAR
1
0
BNK_PAYM_SYSTEM
Possible values
Internal Payment
E
External Payment
CUR_STS
Batch Payment Item Current Status
CHAR
5
0
BNK_ITM_CUR_STS
END_TO_END_ID_EXT
End to End Identification (External)
CHAR
35
0
BNK_COM_END_TO_END_ID_EXT
EXT_STAT
Status Code
CHAR
35
0
BNK_COM_STSCD
GPI_CODE
Current GPI Status Reason Code
CHAR
35
0
BNK_COM_GPI_CODE