SAP ABAP Table /TDAG/CPA_ISMDS (Supplier 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_ISMDS	Table Relationship Diagram
Short Description	Supplier 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	MODULE_ID	☐	/TDAG/CPE_IMDSID		CHAR	18	0	MDS Module ID
13	MODULE_VERSION	☐	/TDAG/CPE_MODULE_VERS	DEC	DEC	6	3	Module Version
14	NODE_ID	☐	/TDAG/CPE_IMDSNODE		CHAR	18	0	Node ID
15	PART_NO	☐	/TDAG/CPE_PARTNO	TEXT50	CHAR	50	0	Part/Item/Material Number
16	PART_NO_NORM	☐	/TDAG/CPE_PARTNO	TEXT50	CHAR	50	0	Part/Item/Material Number
17	PART_NAME	☐	/TDAG/CPE_PARTNAME	TEXT_250	CHAR	250	0	Article Name
18	PART_NAME_NORM	☐	/TDAG/CPE_PARTNAME	TEXT_250	CHAR	250	0	Article Name
19	SPEC_ID	☐	/TDAG/CPE_SUP_SPEC_ID	ESDSUBID	CHAR	12	0	Assignment of a Specification to a Supplier MDS
20	MDS_TYPE	☐	/TDAG/CPE_MDS_TYPE	/TDAG/CPD_REQ_MDS_TYPE	CHAR	1	0	MDS Type
21	MDS_STATUS	☐	/TDAG/CPE_MDS_STATUS_SUP	/TDAG/CPD_MDS_STATUS_SUP	CHAR	1	0	MDS Status
22	CHECK_STATUS	☐	/TDAG/CPE_CHECK_STATUS	/TDAG/CPD_CHECK_STATUS	CHAR	1	0	Check Status
23	CHECK_DATE	☐	/TDAG/CPE_CHECK_DATE	DATE	DATS	8	0	Check Date
24	CREATE_DATE	☐	/TDAG/CPE_CREATE_DATE	DATE	DATS	8	0	Creation Date
25	CHANGE_DATE	☐	/TDAG/CPE_CHG_DATE	DATE	DATS	8	0	Change Date
26	RELEASE_DATE	☐	/TDAG/CPE_RELEASE_DATE	DATE	DATS	8	0	Release Date
27	SUPPL_COMP	☐	/TDAG/CPE_SUPP_COMP_ID	/TDAG/CPD_ORGID	CHAR	9	0	Supplier Company ID	*
28	SUPPL_ORG	☐	/TDAG/CPE_COMPANY_ID	/TDAG/CPD_ORGID	CHAR	9	0	Company ID / Organization ID	*
29	SUPPL_CONTPERS	☐	/TDAG/CPE_SUPP_CONT_ID	/TDAG/CPD_PERSID	CHAR	9	0	Supplier Contact Person ID	*
30	COMM_STATUS	☐	/TDAG/CPE_COMM_STATUS	/TDAG/CPD_COMM_STATUS	CHAR	1	0	Communication Status
31	IMPORT_STATUS	☐	/TDAG/CPE_IMPORT_STATUS	/TDAG/CPD_IMPORT_STATUS	CHAR	1	0	Import Status
32	APPL_LOG	☐	/TDAG/CPE_APPLOG	SYSUUID_22	CHAR	22	0	Application Log
33	SEND_DATE	☐	/TDAG/CPE_SEND_DATE	DATE	DATS	8	0	Transmission Date
34	SEND_TIME	☐	/TDAG/CPE_SEND_TIME	TIME	TIMS	6	0	Transmission Time
35	DEVSAMPLEREP	☐	/TDAG/CPE_DEVSAMPLEREP	YESNO	CHAR	1	0	Development Sample Report
36	.INCLUDE	☐				0	0	DMS Keys for Result File
37	RF_DOCTYPE	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	*
38	RF_DOCNUMBER	☐	DOKNR	DOKNR	CHAR	25	0	Document number	*
39	RF_DOCPART	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
40	RF_DOCVERSION	☐	DOKVR	DOKVR	CHAR	2	0	Document version
41	.INCLUDE	☐				0	0	DMS Keys for Source File
42	SF_DOCTYPE	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	*
43	SF_DOCNUMBER	☐	DOKNR	DOKNR	CHAR	25	0	Document number	*
44	SF_DOCPART	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
45	SF_DOCVERSION	☐	DOKVR	DOKVR	CHAR	2	0	Document version

History

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