SAP table PKPS (Control Cycle Item / Kanban)

SAP table PKPS has 2 primary key fields being MANDT,PKKEY.

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
PKKEY Kanban Identification Number NUMC 10 0 PKKEY
PKNUM Control Cycle CHAR 7 0 PKHD PKNUM
PKPOS Kanban Control Cycle Item NUMC 3 0 PKPOS
PKBST Kanban Status CHAR 1 0 PKBST
1 Container waiting (empty, w/o replen.)
2 Container empty, with replenishment
3 Container in process
4 Container in transit
5 Container full
6 Container in use
9 Container incorrect
PKIMG Actual Quantity QUAN 13 3 PKIMG
SAEDT Date of Last Change DATS 8 0 SAEDT
SAEUZ Time of the Last Status Change TIMS 6 0 SAEUZ
SADT2 Date of Last Change DATS 8 0 SAEDT
SAUZ2 Time of the Last Status Change TIMS 6 0 SAEUZ
LASTCHANGE_DATETIME Last Change Timestamp DEC 21 7 PK_LASTCHANGE_DATETIME
PLNUM Planned Order CHAR 10 0 PLAF PLNUM
AUFNR Order Number CHAR 12 0 AUFK AUFNR
POSNR Order item number NUMC 4 0 CO_POSNR
BSTYP Purchasing Document Category CHAR 1 0 EBSTYP
A Request for Quotation
C Central Contract
F Purchase Order
K Contract
L Scheduling Agreement
N Central Request for Quotation
O Quotation
P Central Purchsae Order
R RFQ
T Central Supplier Quotation
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
ETENR Delivery Schedule Line Counter NUMC 4 0 EETEN
DUMMY_KANBAN_CTN_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
RSNUM Number of reservation/dependent requirements NUMC 10 0 RESB RSNUM
RSPOS Item Number of Reservation / Dependent Requirements NUMC 4 0 RSPOS
TBNUM Transfer Requirement Number NUMC 10 0 TBNUM
TBPOS Transfer Requirement Item NUMC 4 0 TBPOS
SPKKZ Indicator: Kanban is Blocked CHAR 1 0 SPKKZ
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
MBLPO Item in Material Document NUMC 4 0 MBLPO
PKLKZ Deletion Indicator for a Kanban CHAR 1 0 PKLKZ
PKBMG Requested Quantity QUAN 13 3 PKBMG
PKBSA Previous kanban status CHAR 1 0 PKBSA
PABNUM JIT Call Number CHAR 10 0 PABNUM
PABPOS JIT call item NUMC 4 0 PABPOS
PKGPZG Planned Receipt DEC 15 0 PKGPZG
HDFLG Indicator: Changed Control Cycle Data Available for Kanban CHAR 1 0 HDFLG
ETENS Sequential Number of Supplier Confirmation NUMC 4 0 EKES ETENS
ZPUNKT Reporting Point CHAR 4 0 SA_ZPUNKT
PRTNR Confirmation number NUMC 10 0 PRTNR
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
VBELP Item number of the SD document NUMC 6 0 POSNR
EWM_LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 LGNUM
EWM_TANUM Warehouse Task NUMC 12 0 /SCWM/TANUM
EWM_GM_DOC Warehouse Document for Goods Movement NUMC 12 0 /SCWM/DE_GM_DOC
EWM_GM_DOC_ITEM Goods Movement Document Item NUMC 4 0 /SCWM/DE_GM_DOC_ITEM

PKPS foreign key relationships

Table Field Check Table Check Field
0 PKPS AUFNR AUFK Order master data AUFNR
1 PKPS EBELN EKKO Purchasing Document Header EBELN
0 PKPS EBELP EKPO Purchasing Document Item MANDT
0 PKPS EBELP EKPO Purchasing Document Item EBELN
1 PKPS ETENS EKES Supplier Confirmations EBELN
1 PKPS ETENS EKES Supplier Confirmations EBELP
1 PKPS ETENS EKES Supplier Confirmations ETENS
0 PKPS MANDT T000 Clients MANDT
1 PKPS PKNUM PKHD Control Cycle MANDT
0 PKPS PLNUM PLAF Planned Order MANDT
1 PKPS RSNUM RESB Reservation/dependent requirements MANDT
1 PKPS RSNUM RESB Reservation/dependent requirements RSNUM
1 PKPS RSNUM RESB Reservation/dependent requirements RSPOS