PKPS

Transparent Table Application Table
45 Fields 2 CDS Views

Control Cycle Item / Kanban

PKPS is an SAP database table in S/4HANA. Control Cycle Item / Kanban. It contains 45 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_KanbanContainer view from EXTENSION Extension view for Kanban Container
I_KanbanContainer view from BASIC Kanban Container

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY pkkey pkkey Kanban ID
pknum pknum Control Cycle
pkpos pkpos Kanban Item
pkbst pkbst Kanban Status
pkimg pkimg Actual Quantity
saedt saedt Change Date
saeuz saeuz Change Time
sadt2 saedt Change Date
sauz2 saeuz Change Time
lastchange_datetime pk_lastchange_datetime Last Change
plnum plnum Planned Order
aufnr aufnr Order
posnr co_posnr Item Number
bstyp ebstyp Doc. Category
ebeln ebeln Purchasing Doc.
ebelp ebelp Item
etenr eeten Schedule Line
rsnum rsnum Reservation
rspos rspos Item no.
tbnum tbnum TR Number
tbpos tbpos TR Item
spkkz spkkz Is Locked
mblnr mblnr Material Doc.
mjahr mjahr Mat. Doc. Year
mblpo mblpo Mat. Doc.Item
pklkz pklkz Deletion Ind.
pkbmg pkbmg Requested Qty
pkbsa pkbsa Previous status
pabnum pabnum JIT Call Number
pabpos pabpos Item
pkgpzg pkgpzg Planned receipt
hdflg hdflg Changed CC data
etens etens Sequential No.
zpunkt sa_zpunkt Reporting Point
prtnr prtnr Document log
vbeln vbeln SD Document
vbelp posnr Item
ewm_lgnum lgnum Warehouse No.
lgnum_ewm /scwm/lgnum Warehouse No.
ewm_tanum /scwm/tanum Warehouse Task
ewm_wh_request /scdl/dl_docno Document Number
ewm_wh_request_item /scdl/dl_itemno Item Number
ewm_gm_doc /scwm/de_gm_doc Warehouse Document
ewm_gm_doc_item /scwm/de_gm_doc_item GM Document Item

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Control Cycle Item / Kanban
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PKPS (
    MANDT,                -- Client [mandt]
    PKKEY,                -- Kanban ID [pkkey]
    PKNUM,                -- Control Cycle [pknum]
    PKPOS,                -- Kanban Item [pkpos]
    PKBST,                -- Kanban Status [pkbst]
    PKIMG,                -- Actual Quantity [pkimg]
    SAEDT,                -- Change Date [saedt]
    SAEUZ,                -- Change Time [saeuz]
    SADT2,                -- Change Date [saedt]
    SAUZ2,                -- Change Time [saeuz]
    LASTCHANGE_DATETIME,  -- Last Change [pk_lastchange_datetime]
    PLNUM,                -- Planned Order [plnum]
    AUFNR,                -- Order [aufnr]
    POSNR,                -- Item Number [co_posnr]
    BSTYP,                -- Doc. Category [ebstyp]
    EBELN,                -- Purchasing Doc. [ebeln]
    EBELP,                -- Item [ebelp]
    ETENR,                -- Schedule Line [eeten]
    RSNUM,                -- Reservation [rsnum]
    RSPOS,                -- Item no. [rspos]
    TBNUM,                -- TR Number [tbnum]
    TBPOS,                -- TR Item [tbpos]
    SPKKZ,                -- Is Locked [spkkz]
    MBLNR,                -- Material Doc. [mblnr]
    MJAHR,                -- Mat. Doc. Year [mjahr]
    MBLPO,                -- Mat. Doc.Item [mblpo]
    PKLKZ,                -- Deletion Ind. [pklkz]
    PKBMG,                -- Requested Qty [pkbmg]
    PKBSA,                -- Previous status [pkbsa]
    PABNUM,               -- JIT Call Number [pabnum]
    PABPOS,               -- Item [pabpos]
    PKGPZG,               -- Planned receipt [pkgpzg]
    HDFLG,                -- Changed CC data [hdflg]
    ETENS,                -- Sequential No. [etens]
    ZPUNKT,               -- Reporting Point [sa_zpunkt]
    PRTNR,                -- Document log [prtnr]
    VBELN,                -- SD Document [vbeln]
    VBELP,                -- Item [posnr]
    EWM_LGNUM,            -- Warehouse No. [lgnum]
    LGNUM_EWM,            -- Warehouse No. [/scwm/lgnum]
    EWM_TANUM,            -- Warehouse Task [/scwm/tanum]
    EWM_WH_REQUEST,       -- Document Number [/scdl/dl_docno]
    EWM_WH_REQUEST_ITEM,  -- Item Number [/scdl/dl_itemno]
    EWM_GM_DOC,           -- Warehouse Document [/scwm/de_gm_doc]
    EWM_GM_DOC_ITEM,      -- GM Document Item [/scwm/de_gm_doc_item]
    PRIMARY KEY (MANDT, PKKEY)
);

Learn More