SAP ABAP Table S029 (KANBAN)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S029	Table Relationship Diagram
Short Description	KANBAN

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	PRVBE	☑	PRVBE	PRVBE	CHAR	10	0	Production Supply Area	PVBE
10	LGORT	☑	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
11	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
12	RGVRV	☑	RGVER	DISPO	CHAR	3	0	Person responsible for one or more supply areas	T024D
13	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
14	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
15	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
16	AZBFF	☐	AFBFF	ANZWB	INT4	10	0	Number of external replenishment operations
17	AZ1N2	☐	AZ1N2	ANZWB	INT4	10	0	Number of signals from status 1 to 2
18	AZBFE	☐	AZBFE	ANZWB	INT4	10	0	Number of in-house production operations
19	AZFEH	☐	AZFEH	ANZWB	INT4	10	0	Number of errors in container processing
20	AZLIG	☐	AZLIG	ANZWB	INT4	10	0	Number of wait operations, status 5 to 1 or 2
21	AZ4N5	☐	AZ4N5	ANZWB	INT4	10	0	Number of transfer operations, status 4 to 5
22	AZBFU	☐	AZBFU	ANZWB	INT4	10	0	Number of replenishment operations for stock transfer
23	AZ2N4	☐	AZ2N4	ANZWB	INT4	10	0	Number of refill operations: status 2 to 4
24	AZWIB	☐	AZWIB	ANZWB	INT4	10	0	Number of replenishment operations from status 2 to 5
25	AZWB0	☐	AZWB0	ANZWB	INT4	10	0	Number of replenishment operations on the same day
26	BEHAZ	☐	BEHAZ	BEHAZ	NUMC	3	0	Number of Kanban Containers
27	BEHMG	☐	BEHMG	MENG13	QUAN	13	3	Kanban Quantity
28	D1N2Z	☐	D1N2Z	PKSUZ	DEC	9	2	Total trigger times from status 1 to 2
29	DFEHZ	☐	DFEHZ	PKSUZ	DEC	9	2	Sum of the times in error status 9
30	SMIST	☐	SMIST	MENG15	QUAN	15	3	Total container quantity; actual
31	DLIGZ	☐	DLIGZ	PKSUZ	DEC	9	2	Sum of the wait times from status 5 to 1 or 2
32	SMSOL	☐	SMSOL	MENG15	QUAN	15	3	Total container quantity; target
33	D4N5Z	☐	D4N5Z	PKSUZ	DEC	9	2	Total of the times from status 4 to 5
34	D2N4Z	☐	D2N4Z	PKSUZ	DEC	9	2	Sum of the refill times from status 2 to 4
35	DWIBZ	☐	DWIBZ	PKSUZ	DEC	9	2	Sum of the total replenishment lead time from status 2 to 5

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S029	LGORT	T001L	LGORT	KEY	1	CN
2	S029	MANDT	T000	MANDT
3	S029	MATNR	MARA	MATNR	KEY	1	CN
4	S029	PERIV	T009	PERIV
5	S029	PRVBE	PVBE	PRVBE	KEY	1	CN
6	S029	RGVRV	T024D	DISPO	KEY	1	CN
7	S029	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in