SAP ABAP Table JVTMCP_ITEM (IS-M: TMCP Structures (CRoute/GUnit))

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JVTMCP_ITEM	Table Relationship Diagram
Short Description	IS-M: TMCP Structures (CRoute/GUnit)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	PUBLICATION	☑	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
3	EDITION	☑	PVA	PVA	CHAR	8	0	Edition	JDTPVA
4	PUBLDATE	☑	ERSCHDAT	DATUM	DATS	8	0	Publication Date
5	BEZIRK	☑	BEZIRK	BEZIRK	CHAR	10	0	Carrier Route	*
6	GEOEIN	☑	GEOEIN	GEOEIN	CHAR	10	0	Number of Geographical Unit	*
7	XNO_HHADR_FOUND	☐	TMCP_XNO_HH	XFELD	CHAR	1	0	Indicator: No Households Found for Carrier Route/Geo. Unit
8	XFINISHED	☐	TMCP_XFINISHED	XFELD	CHAR	1	0	Indicator: Market Coverage Completed
9	XMANUALLY_CLOSED	☐	TMCP_XMANUALLY_CLOSED	XFELD	CHAR	1	0	Indicator: Market Coverage Closed Manually
10	EXCL_TYPE	☐	TMCP_EXCLUDE_TYPE	TMCP_EXCLUDE_TYPE	NUMC	2	0	Type of Market Coverage Exclusion
11	XORDER_GENERATED	☐	XORDER_GENERATED	XFELD	CHAR	1	0	Market Coverage: Shipping Orders Generated
12	SHIPORDNBR	☐	SHIPORDNBR	SHIPORDNBR	CHAR	10	0	Address-Based Shipping Order Number	*
13	XTMCP	☐	TMCP_XTMC	XFELD	CHAR	1	0	Indicator: Total Market Coverage
14	XSATURATION	☐	TMCP_XSATURATION	XFELD	CHAR	1	0	Indicator: Market Saturation
15	SEQ_NR_LAST	☐	TMCP_SEQUENCE_NUMBER_LAST	NUM3	NUMC	3	0	Last Sequence Number for Market Coverage Execution
16	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
17	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
18	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
19	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
20	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
21	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
22	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
23	TASK_ID	☐	TMCP_TASK_ID	CHAR0032	CHAR	32	0	Task ID
24	TASK_SYSTEM	☐	TMCP_TASK_RFCDEST	RFCDEST	CHAR	32	0	RFC System ID	*
25	TASK_START_DATE	☐	TMCP_TASK_STARTDATE	DATS	DATS	8	0	Task Start Date
26	TASK_END_DATE	☐	TMCP_TASK_ENDDATE	DATS	DATS	8	0	Task End Date
27	TASK_START_TIME	☐	TMCP_TASK_START_TIME	TIMS	TIMS	6	0	Task Start Time
28	TASK_END_TIME	☐	TMCP_TASK_END_TIME	TIMS	TIMS	6	0	Task End Time
29	TASK_ERROR	☐	ERROR	ERROR	CHAR	2	0	Number of Message Type	*
30	ERROR_MESSAGE	☐	MSG	CHAR83	CHAR	83	0	Message Row

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JVTMCP_ITEM	EDITION	JDTPVA	PVA
2	JVTMCP_ITEM	MANDT	T000	MANDT
3	JVTMCP_ITEM	PUBLICATION	JDTDRER	DRERZ

History

Last changed by/on	SAP	20110901
SAP Release Created in	472