SAP ABAP Table /TDAG/CPS_ICMDS (Structure for 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	INTTAB	Structure
Structure	/TDAG/CPS_ICMDS	Table Relationship Diagram
Short Description	Structure for Customer MDS

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