SAP ABAP Table MCKANB (Kanban Communication Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MD05 (Package) Development class KANBAN

Basic Data

Table Category	INTTAB	Structure
Structure	MCKANB	Table Relationship Diagram
Short Description	Kanban Communication Structure

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
2	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area	PVBE
4	PKNUM	☐	PKNUM	PKNUM	CHAR	7	0	Control cycle number	PKHD
5	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
6	RGVRV	☐	RGVER	DISPO	CHAR	3	0	Person responsible for one or more supply areas	T024D
7	RGVRQ	☐	RGVER	DISPO	CHAR	3	0	Person responsible for one or more supply areas	T024D
8	SAEDT	☐	SAEDT	DATUM	DATS	8	0	Date of last change
9	SAEUZ	☐	SAEUZ	UZEIT	TIMS	6	0	Time of the last status change
10	BEHMG	☐	BEHMG	MENG13	QUAN	13	3	Kanban Quantity
11	BEHAZ	☐	BEHAZ	BEHAZ	NUMC	3	0	Number of Kanban Containers
12	DWIBZ	☐	DWIBZ	PKSUZ	DEC	9	2	Sum of the total replenishment lead time from status 2 to 5
13	AZWIB	☐	AZWIB	ANZWB	INT4	10	0	Number of replenishment operations from status 2 to 5
14	SMIST	☐	SMIST	MENG15	QUAN	15	3	Total container quantity; actual
15	SMSOL	☐	SMSOL	MENG15	QUAN	15	3	Total container quantity; target
16	D2N4Z	☐	D2N4Z	PKSUZ	DEC	9	2	Sum of the refill times from status 2 to 4
17	AZ2N4	☐	AZ2N4	ANZWB	INT4	10	0	Number of refill operations: status 2 to 4
18	D4N5Z	☐	D4N5Z	PKSUZ	DEC	9	2	Total of the times from status 4 to 5
19	AZ4N5	☐	AZ4N5	ANZWB	INT4	10	0	Number of transfer operations, status 4 to 5
20	DLIGZ	☐	DLIGZ	PKSUZ	DEC	9	2	Sum of the wait times from status 5 to 1 or 2
21	AZLIG	☐	AZLIG	ANZWB	INT4	10	0	Number of wait operations, status 5 to 1 or 2
22	D1N2Z	☐	D1N2Z	PKSUZ	DEC	9	2	Total trigger times from status 1 to 2
23	AZ1N2	☐	AZ1N2	ANZWB	INT4	10	0	Number of signals from status 1 to 2
24	AZBFU	☐	AZBFU	ANZWB	INT4	10	0	Number of replenishment operations for stock transfer
25	AZBFE	☐	AZBFE	ANZWB	INT4	10	0	Number of in-house production operations
26	AZBFF	☐	AFBFF	ANZWB	INT4	10	0	Number of external replenishment operations
27	AZFEH	☐	AZFEH	ANZWB	INT4	10	0	Number of errors in container processing
28	DFEHZ	☐	DFEHZ	PKSUZ	DEC	9	2	Sum of the times in error status 9
29	AZWB0	☐	AZWB0	ANZWB	INT4	10	0	Number of replenishment operations on the same day
30	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
31	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
32	BAMME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
33	SSLOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
34	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
35	ARLTD	☐	ARLTD	DEC5_2	DEC	7	2	Actual Replenishment Lead Time in Days
36	ARLTH	☐	ARLTH	DEC5_2	DEC	7	2	Actual Replenishment Lead Time in Hours
37	ERLTD	☐	ERLTD	DEC5_2	DEC	7	2	Expected Replenishment Lead Time in Days
38	ERLTH	☐	ERLTH	DEC5_2	DEC	7	2	Expected Replenishment Lead Time in Hours
39	ACPTD	☐	ACPTD	DEC5_2	DEC	7	2	Actual Consumption Time in Days
40	ACPTH	☐	ACPTH	DEC5_2	DEC	7	2	Actual Consumption Time in Hours
41	ARFTD	☐	ARFTD	DEC5_2	DEC	7	2	Actual Refill Time in Days
42	ARFTH	☐	ARFTH	DEC5_2	DEC	7	2	Actual Refill Time in Hours
43	AWTTD	☐	AWTTD	DEC5_2	DEC	7	2	Actual Wait Time in Days
44	AWTTH	☐	AWTTH	DEC5_2	DEC	7	2	Actual Wait Time in Hours
45	AIPTD	☐	AIPTD	DEC5_2	DEC	7	2	Actual In Process/In Transit Time in Days
46	AIPTH	☐	AIPTH	DEC5_2	DEC	7	2	Actual In Process/In Transit Time in Hours
47	ACRTD	☐	ACRTD	DEC5_2	DEC	7	2	Actual Kanban Correction Time in Days
48	ACRTH	☐	ACRTH	DEC5_2	DEC	7	2	Actual Kanban Correction Time in Hours
49	ERRNM	☐	ERRNM	ANZWB	INT4	10	0	Number of Kanbans with Status "Error"
50	FULLBX	☐	FULLBX	ANZWB	INT4	10	0	Number of Kanbans with Status "Full"
51	EMTYBX	☐	EMTYBX	ANZWB	INT4	10	0	Number of Kanbans with Status "Empty"
52	SIGAZ	☐	SIGAZ	BEHAZ	NUMC	3	0	Maximum Number of Empty Kanban Containers
53	PKBMG	☐	PKFMG	MENG13	QUAN	13	3	Fixed Kanban Quantity
54	TOTSTCK	☐	GSBEST	MENGV15	QUAN	15	3	Total stock
55	PROCMD	☐	PROCMD	PROCMD	CHAR	1	0	Replenishment Type
56	REPSTI	☐	PKSTE	PKSTS	CHAR	4	0	Control Cycle Replenishment Strategy for In-House Production	*
57	REPSTE	☐	PKSTF	PKSTF	CHAR	4	0	Replenishment Strategy of Control Cycle - Ext. Procurement	*
58	REPSTS	☐	PKSTU	PKSTU	CHAR	4	0	Control Cycle Replenishment Strategy for Stock Transfer	*
59	ACQTY	☐	SMIST	MENG15	QUAN	15	3	Total container quantity; actual
60	TRQTY	☐	SMSOL	MENG15	QUAN	15	3	Total container quantity; target
61	TRXHR	☐	TRXHR	INT2	INT2	5	0	Hour of Last Status Change (Format 24HH)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCKANB	BAMME	T006	MSEHI	REF	1	CN
2	MCKANB	BUKRS	T001	BUKRS	REF	1	CN
3	MCKANB	LGORT	T001L	LGORT	KEY	1	CN
4	MCKANB	MATNR	MARA	MATNR	KEY	1	CN
5	MCKANB	PKNUM	PKHD	PKNUM	KEY	1	CN
6	MCKANB	PRVBE	PVBE	PRVBE	KEY	1	CN
7	MCKANB	RGVRQ	T024D	DISPO	KEY	1	CN
8	MCKANB	RGVRV	T024D	DISPO	KEY	1	CN
9	MCKANB	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in