SAP ABAP Table /TDAG/CPS_ONLY_REP_DATA (Only Representative Data)

Hierarchy

☛ TDAGBCA (Software Component) TechniData Basic Components
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ /TDAG/CP (Package) Compliance for products

Basic Data

Table Category	INTTAB	Structure
Structure	/TDAG/CPS_ONLY_REP_DATA	Table Relationship Diagram
Short Description	Only Representative Data

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	FLG_IMPORTED	☐	/TDAG/CPE_IMP_DATA	ESDBOOLE	CHAR	1	0	Imported Data
2	FLG_LGENT	☐	/TDAG/CPE_LGENT_DATA	ESDBOOLE	CHAR	1	0	Legal Entity Data
3	LGENT	☐	/TDAG/RCSE_LEGENT	BUKRS	CHAR	4	0	Legal Entity	*
4	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
5	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
6	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
7	VALFR_YEAR	☐	/TDAG/CPE_YEAR_FROM	JAHR	NUMC	4	0	Valid from Date (Year)
8	VALTO_YEAR	☐	/TDAG/CPE_YEAR_TO	JAHR	NUMC	4	0	Valid to Date (Year)
9	EKORG	☐	/TDAG/CPE_EKORG_SUP	EKORG	CHAR	4	0	Purchasing Organization of Supplier	T024E
10	ADDR_NO	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
11	PERS_NO	☐	/TDAG/CPE_CONTACT	AD_PERSNUM	CHAR	10	0	Contact	*
12	PAR_NO	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
13	KTOKK	☐	KTOKK	KTOKK	CHAR	4	0	Vendor account group	T077K
14	ONLY_REP	☐	/TDAG/RCSE_UEC_ONLY_REPR	LIFNR	CHAR	10	0	Only Representative	*
15	ONLY_REP_NAM	☐	/TDAG/RCSE_UEC_ONLY_REPR_NAME	NAME	CHAR	35	0	Name of Only Representative
16	SEARCH_TERM	☐	AD_SORT1UL	TEXT20	CHAR	20	0	Search Term 1
17	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
18	COUNTRY_NAM	☐	LANDX	TEXT15	CHAR	15	0	Country Name
19	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
20	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
21	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
22	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
23	SALUTATION_ID	☐	/TDAG/RCSE_UEC_SALUTATION_ID	AD_TITLE	CHAR	4	0	Key of Salutation	TSAD3
24	SALUTATION	☐	/TDAG/RCSE_UEC_SALUATION	TEXT30	CHAR	30	0	Salutation
25	NAME_FIRST	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
26	NAME_LAST	☐	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
27	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
28	TEL_COUNTRY_PREFIX	☐	/TDAG/RCSE_UEC_PHONE_COUNTRY	CHAR4	CHAR	4	0	Country Prefix of Phone/Fax
29	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
30	TEL_NUMBER_EXT	☐	/TDAG/RCSE_UEC_PHONE_NO_EXT	CHAR10	CHAR	10	0	Phone Number: Extension
31	FLG_UPDATE_SUP	☐	AD_UPDFLAG	AD_UPDFLAG	CHAR	1	0	Address transfer structure change flag
32	FLG_UPDATE_OR	☐	AD_UPDFLAG	AD_UPDFLAG	CHAR	1	0	Address transfer structure change flag
33	FLG_UPDATE	☐	AD_UPDFLAG	AD_UPDFLAG	CHAR	1	0	Address transfer structure change flag
34	FLG_NEW_SUPPLIER	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
35	FLG_LOCKED	☐	/TDAG/CPE_FLG_LOCKED	CHAR	CHAR	2	0	Locked Record
36	FLG_CREATE_CHANGE	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
37	FLG_DELETE_CHANGE	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
38	FLG_UPDATE_CHANGE	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
39	ROW_NO	☐	/TDAG/CPE_ROWNUMBER	INT4	INT4	10	0	Row Number
40	VALFR_ORG	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
41	VALTO_ORG	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
42	VALFR_YEAR_ORG	☐	/TDAG/CPE_YEAR_FROM	JAHR	NUMC	4	0	Valid from Date (Year)
43	VALTO_YEAR_ORG	☐	/TDAG/CPE_YEAR_TO	JAHR	NUMC	4	0	Valid to Date (Year)
44	ONLY_REP_RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
45	CELLS_COLOR_TAB	☐	LVC_T_SCOL		TTYP	0	0
46	CELLS_STYLE_TAB	☐	LVC_T_STYL		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/TDAG/CPS_ONLY_REP_DATA	COUNTRY	T005	LAND1
2	/TDAG/CPS_ONLY_REP_DATA	EKORG	T024E	EKORG
3	/TDAG/CPS_ONLY_REP_DATA	KTOKK	T077K	KTOKK
4	/TDAG/CPS_ONLY_REP_DATA	SALUTATION_ID	TSAD3	TITLE

History

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