SAP table PCEC (Prenumbered Checks)

SAP table PCEC has 5 primary key fields being MANDT,ZBUKR,HBKID,HKTID,STAPL.

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 T000 MANDT
ZBUKR Paying company code CHAR 4 0 T001 DZBUKR
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
HKTID ID for Account Details CHAR 5 0 T012K HKTID
STAPL Lot Number NUMC 4 0 STAPL
CHECF Check Number From CHAR 13 0 CHECF
CHECT Check number CHAR 13 0 CHECT
FSTAP Next Lot NUMC 4 0 FSTAP
CHECL Last Check Number Assigned CHAR 13 0 CHECL
STAPI Short Information on the Lot CHAR 30 0 STAPI
XARCP Check Number Interval Partially Archived CHAR 1 0 XARCP
XARCT Check Number Interval Completely Archived CHAR 1 0 XARCT
XCHCH Indicator: Non-Sequential Check Number Management CHAR 1 0 XCHCH
PURDT Purchase date DATS 8 0 PURDT
DUMMY_CHKBOOKMNG_INCL_EEW_PS Data element for checkbook management field extensition CHAR 1 0 CHKBOOKMNG_INCL_EEW
ZWELS List of Pmnt Methods Permitted for This Check Lot CHAR 10 0 RZAWL
MINIALERTNUM Minimal Alert Number NUMC 13 0 FAP_CB_ALERTNUMBER
PURCHASEBY Purchase By CHAR 12 0 FAP_CB_PURCHASEBY
CREATEBY Created By CHAR 12 0 FAP_CB_CREATEBY
CREATEDATE Date DATS 8 0 FAP_CB_DATE
CREATETIME Time TIMS 6 0 FAP_CB_TIME
CHECKTYPE Type of Check for China Specific CHAR 2 0 FAP_CHECKTYPE
00 Cash Check
01 Transfer Check
02 Open Check

PCEC foreign key relationships

Table Field Check Table Check Field
0 PCEC HBKID T012 House Banks BUKRS
1 PCEC HKTID T012K House Bank Accounts MANDT
1 PCEC HKTID T012K House Bank Accounts BUKRS
1 PCEC HKTID T012K House Bank Accounts HBKID
1 PCEC HKTID T012K House Bank Accounts HKTID
0 PCEC MANDT T000 Clients MANDT
1 PCEC ZBUKR T001 Company Codes BUKRS