SAP ABAP Table /TDAG/CPA_ICMDS (Customer MDS)

Hierarchy

☛ TDAGBCA (Software Component) TechniData Basic Components
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ /TDAG/CP_IMDS (Package) IMDS Advanced Interface Integration

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/TDAG/CPA_ICMDS	Table Relationship Diagram
Short Description	Customer MDS

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	.INCLUDE	☑				0	0	Key fields
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☑	GUID		RAW	16	0	Globally Unique Identifier
4	.INCLUDE	☐				0	0	Admin data for data base tables
5	CRDAT	☐	/TDAG/RCSE_CRDAT	DATUM	DATS	8	0	Creation Date
6	CRNAM	☐	/TDAG/RCSE_CRNAM	USNAM	CHAR	12	0	Creation User
7	CRTSTMP	☐	/TDAG/RCSE_CRTSTMP	TZNTSTMPS	DEC	15	0	Creation Time Stamp
8	UPDDAT	☐	/TDAG/RCSE_UPDDAT	DATUM	DATS	8	0	Update Date
9	UPDNAM	☐	/TDAG/RCSE_UPDNAM	USNAM	CHAR	12	0	Update User
10	UPDTSTMP	☐	/TDAG/RCSE_UPDTSTMP	TZNTSTMPS	DEC	15	0	Update Time Stamp
11	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
12	SPEC_ID	☐	/TDAG/CPE_CUS_SPEC_ID	ESDSUBID	CHAR	12	0	Assignment of a Specification to a Customer MDS
13	MODULE_ID	☐	/TDAG/CPE_IMDSID		CHAR	18	0	MDS Module ID
14	MODULE_VERSION	☐	/TDAG/CPE_MODULE_VERS	DEC	DEC	6	3	Module Version
15	NODE_ID	☐	/TDAG/CPE_IMDSNODE		CHAR	18	0	Node ID
16	MDS_TYPE	☐	/TDAG/CPE_MDS_TYPE	/TDAG/CPD_REQ_MDS_TYPE	CHAR	1	0	MDS Type
17	PART_NO	☐	/TDAG/CPE_PARTNO	TEXT50	CHAR	50	0	Part/Item/Material Number
18	PART_NO_NORM	☐	/TDAG/CPE_PARTNO	TEXT50	CHAR	50	0	Part/Item/Material Number
19	PART_NAME	☐	/TDAG/CPE_PARTNAME	TEXT_250	CHAR	250	0	Article Name
20	PART_NAME_NORM	☐	/TDAG/CPE_PARTNAME	TEXT_250	CHAR	250	0	Article Name
21	MDS_STATUS	☐	/TDAG/CPE_MDS_STATUS	/TDAG/CPD_MDS_STATUS	CHAR	1	0	MDS Status
22	PREC_MDS_STATUS	☐	/TDAG/CPE_MDS_STATUS	/TDAG/CPD_MDS_STATUS	CHAR	1	0	MDS Status
23	SEND_DATE	☐	/TDAG/CPE_SEND_DATE	DATE	DATS	8	0	Transmission Date
24	SEND_TIME	☐	/TDAG/CPE_SEND_TIME	TIME	TIMS	6	0	Transmission Time
25	DEVSAMPLEREP	☐	/TDAG/CPE_DEVSAMPLEREP	YESNO	CHAR	1	0	Development Sample Report
26	.INCLUDE	☐				0	0	DMS Keys for Result File
27	RF_DOCTYPE	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	*
28	RF_DOCNUMBER	☐	DOKNR	DOKNR	CHAR	25	0	Document number	*
29	RF_DOCPART	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
30	RF_DOCVERSION	☐	DOKVR	DOKVR	CHAR	2	0	Document version
31	.INCLUDE	☐				0	0	DMS Keys for Source File
32	SF_DOCTYPE	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	*
33	SF_DOCNUMBER	☐	DOKNR	DOKNR	CHAR	25	0	Document number	*
34	SF_DOCPART	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
35	SF_DOCVERSION	☐	DOKVR	DOKVR	CHAR	2	0	Document version
36	OWN_ORGID	☐	/TDAG/CPE_OWN_ORG_ID	/TDAG/CPD_ORGID	CHAR	9	0	Company ID / Organization ID	*
37	OWN_CONTPERS	☐	/TDAG/CPE_OWN_CONT_ID	/TDAG/CPD_PERSID	CHAR	9	0	Own Contact Person ID	*
38	COMM_STATUS	☐	/TDAG/CPE_COMM_STATUS	/TDAG/CPD_COMM_STATUS	CHAR	1	0	Communication Status
39	IMPORT_STATUS	☐	/TDAG/CPE_FILE_STATUS	/TDAG/CPD_FILE_STATUS	CHAR	1	0	File Status
40	APPL_LOG	☐	/TDAG/CPE_APPLOG	SYSUUID_22	CHAR	22	0	Application Log
41	OUTG_TEMPL	☐	/TDAG/CPE_TEMPL_ID	/TDAG/RCSD_TEMPLID	CHAR	10	0	Outgoing Template	*
42	CREATE_DATE	☐	/TDAG/CPE_CREATE_DATE	DATE	DATS	8	0	Creation Date
43	CHECK_DATE	☐	/TDAG/CPE_CHECK_DATE	DATE	DATS	8	0	Check Date
44	CHANGE_DATE	☐	/TDAG/CPE_CHG_DATE	DATE	DATS	8	0	Change Date
45	RELEASE_DATE	☐	/TDAG/CPE_RELEASE_DATE	DATE	DATS	8	0	Release Date
46	DATASH_TYPE	☐	/TDAG/CPE_DATASHEET_TYPE	/TDAG/CPD_DATASHEET_TYPE	CHAR	1	0	Data Sheet Type

History

Last changed by/on	SAP	20141109
SAP Release Created in	200_600