SAP Table MCKANB

Kanban Communication Structure

MCKANB (Kanban Communication Structure) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MCKANB to other SAP tables.

MCKANB table fields

Field Data element Checktable Datatype Length Decimals
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
PRVBE Production Supply Area PRVBE PVBE CHAR 10 0
PKNUM Control cycle number PKNUM PKHD CHAR 7 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
RGVRV Person responsible for one or more supply areas RGVER T024D CHAR 3 0
RGVRQ Person responsible for one or more supply areas RGVER T024D CHAR 3 0
SAEDT Date of last change SAEDT DATS 8 0
SAEUZ Time of the last status change SAEUZ TIMS 6 0
BEHMG Kanban Quantity BEHMG QUAN 13 3
BEHAZ Number of Kanban Containers BEHAZ NUMC 3 0
DWIBZ Sum of the total replenishment lead time from status 2 to 5 DWIBZ DEC 9 2
AZWIB Number of replenishment operations from status 2 to 5 AZWIB INT4 10 0
SMIST Total container quantity; actual SMIST QUAN 15 3
SMSOL Total container quantity; target SMSOL QUAN 15 3
D2N4Z Sum of the refill times from status 2 to 4 D2N4Z DEC 9 2
AZ2N4 Number of refill operations: status 2 to 4 AZ2N4 INT4 10 0
D4N5Z Total of the times from status 4 to 5 D4N5Z DEC 9 2
AZ4N5 Number of transfer operations, status 4 to 5 AZ4N5 INT4 10 0
DLIGZ Sum of the wait times from status 5 to 1 or 2 DLIGZ DEC 9 2
AZLIG Number of wait operations, status 5 to 1 or 2 AZLIG INT4 10 0
D1N2Z Total trigger times from status 1 to 2 D1N2Z DEC 9 2
AZ1N2 Number of signals from status 1 to 2 AZ1N2 INT4 10 0
AZBFU Number of replenishment operations for stock transfer AZBFU INT4 10 0
AZBFE Number of in-house production operations AZBFE INT4 10 0
AZBFF Number of external replenishment operations AFBFF INT4 10 0
AZFEH Number of errors in container processing AZFEH INT4 10 0
DFEHZ Sum of the times in error status 9 DFEHZ DEC 9 2
AZWB0 Number of replenishment operations on the same day AZWB0 INT4 10 0
SUPKZ Statistics update indicator (post in/post out) SUPKZ CHAR 1 0
1 Old status: charge off (negative posting)
2 New status: record
3 Standard item in a return (SD only)
0 Returns item in standard order (SD only)
BUKRS Company Code BUKRS T001 CHAR 4 0
BAMME Base Unit of Measure MEINS T006 UNIT 3 0
SSLOC Storage Location LGORT_D CHAR 4 0
LIFNR Vendor Account Number ELIFN CHAR 10 0
ARLTD Actual Replenishment Lead Time in Days ARLTD DEC 7 2
ARLTH Actual Replenishment Lead Time in Hours ARLTH DEC 7 2
ERLTD Expected Replenishment Lead Time in Days ERLTD DEC 7 2
ERLTH Expected Replenishment Lead Time in Hours ERLTH DEC 7 2
ACPTD Actual Consumption Time in Days ACPTD DEC 7 2
ACPTH Actual Consumption Time in Hours ACPTH DEC 7 2
ARFTD Actual Refill Time in Days ARFTD DEC 7 2
ARFTH Actual Refill Time in Hours ARFTH DEC 7 2
AWTTD Actual Wait Time in Days AWTTD DEC 7 2
AWTTH Actual Wait Time in Hours AWTTH DEC 7 2
AIPTD Actual In Process/In Transit Time in Days AIPTD DEC 7 2
AIPTH Actual In Process/In Transit Time in Hours AIPTH DEC 7 2
ACRTD Actual Kanban Correction Time in Days ACRTD DEC 7 2
ACRTH Actual Kanban Correction Time in Hours ACRTH DEC 7 2
ERRNM Number of Kanbans with Status "Error" ERRNM INT4 10 0
FULLBX Number of Kanbans with Status "Full" FULLBX INT4 10 0
EMTYBX Number of Kanbans with Status "Empty" EMTYBX INT4 10 0
SIGAZ Maximum Number of Empty Kanban Containers SIGAZ NUMC 3 0
PKBMG Fixed Kanban Quantity PKFMG QUAN 13 3
TOTSTCK Total stock GSBEST QUAN 15 3
PROCMD Replenishment Type PROCMD CHAR 1 0
I In-House Production
E External Procurement
S Storage Location
REPSTI Control Cycle Replenishment Strategy for In-House Production PKSTE CHAR 4 0
REPSTE Replenishment Strategy of Control Cycle - Ext. Procurement PKSTF CHAR 4 0
REPSTS Control Cycle Replenishment Strategy for Stock Transfer PKSTU CHAR 4 0
ACQTY Total container quantity; actual SMIST QUAN 15 3
TRQTY Total container quantity; target SMSOL QUAN 15 3
TRXHR Hour of Last Status Change (Format 24HH) TRXHR INT2 5 0

MCKANB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MCKANB BAMME SYST MANDT T006 Units of Measurement MANDT
MCKANB BAMME MCKANB BAMME T006 Units of Measurement MSEHI
MCKANB BUKRS SYST MANDT T001 Company Codes MANDT
MCKANB BUKRS MCKANB BUKRS T001 Company Codes BUKRS
MCKANB LGORT SYST MANDT T001L Storage Locations MANDT
MCKANB LGORT MCKANB WERKS T001L Storage Locations WERKS
MCKANB LGORT MCKANB LGORT T001L Storage Locations LGORT
MCKANB MATNR SYST MANDT MARA General Material Data MANDT
MCKANB MATNR MCKANB MATNR MARA General Material Data MATNR
MCKANB PKNUM SYST MANDT PKHD Control Cycle MANDT
MCKANB PKNUM MCKANB PKNUM PKHD Control Cycle PKNUM
MCKANB PRVBE SYST MANDT PVBE Production Supply Area MANDT
MCKANB PRVBE MCKANB WERKS PVBE Production Supply Area WERKS
MCKANB PRVBE MCKANB PRVBE PVBE Production Supply Area PRVBE
MCKANB RGVRQ MCKANB RGVRQ T024D MRP controllers DISPO
MCKANB RGVRQ SYST MANDT T024D MRP controllers MANDT
MCKANB RGVRQ MCKANB WERKS T024D MRP controllers WERKS
MCKANB RGVRV SYST MANDT T024D MRP controllers MANDT
MCKANB RGVRV MCKANB WERKS T024D MRP controllers WERKS
MCKANB RGVRV MCKANB RGVRV T024D MRP controllers DISPO
MCKANB WERKS SYST MANDT T001W Plants/Branches MANDT
MCKANB WERKS MCKANB WERKS T001W Plants/Branches WERKS