SAP table OIUCW_CHECKLOT (Check Lot Details for Payments)

SAP table OIUCW_CHECKLOT has 3 primary key fields being MANDT,LOTNO,PAYMENT_METHOD.

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
MANDT Client CLNT 3 0 MANDT
LOTNO Check Lot Number CHAR 6 0 OIUCW_LOTCONTROL OIUCW_LOTNO
PAYMENT_METHOD Payment Type CHAR 1 0 OIU_PAYMENT_TYPE
C Check
E EFT
N Netout
W Wire Transfer
PREFIX_CHECKNO Prefix Check Number in Check Registr with Payment Method Cd CHAR 1 0 OIUCW_PREFIXCHECKNO
N Do not Prefix Check Number in Check Register with Pmnt Methd
Y Prefix Check Number in Check Register with Payment Method
ORG_LVL_1 Organization level 1 number (Company Code) CHAR 3 0 OIUH_OR_LVL_1_NO
NR_INTERVAL Number range number CHAR 2 0 NRNR

OIUCW_CHECKLOT foreign key relationships

Table Field Check Table Check Field
0 OIUCW_CHECKLOT LOTNO OIUCW_LOTCONTROL Check Lot Control Master MANDT
0 OIUCW_CHECKLOT LOTNO OIUCW_LOTCONTROL Check Lot Control Master LOTNO