SAP ABAP Table FMCCRTVENDOR (CCR Vendor Table)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FG (Application Component) Functions for U.S. Federal Government
     ⤷ FMFG_CCR_E (Package) Interface to Central Contractor Registry (CCR)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FMCCRTVENDOR	Table Relationship Diagram
Short Description	CCR Vendor Table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	DUNS	☑	FMCCRDUNS		CHAR	9	0	DUNS Number
3	DUNS4	☑	FMCCRDUNS4		CHAR	4	0	DUNS+4
4	CAGE	☐	FMCCRCAGE		CHAR	5	0	Cage Code
5	EXCODE	☐	FMCCREXCODE		CHAR	1	0	Extract Code
6	REGDATE	☐	FMCCREGDAT		DATS	8	0	Registration date
7	RENDATE	☐	FMCCRENDAT	DATS	DATS	8	0	Renewal date for CCR Vendor (Expired)
8	BUSNAME	☐			CHAR	120	0
9	DBANAME	☐			CHAR	60	0
10	COMPDIV	☐			CHAR	60	0
11	DIVNUM	☐			CHAR	10	0
12	STADD1	☐			CHAR	55	0
13	STADD2	☐			CHAR	55	0
14	CITY	☐			CHAR	35	0
15	STATE	☐			CHAR	2	0
16	POSTAL	☐			CHAR	35	0
17	COUNTRY	☐			CHAR	3	0
18	BUSSTART	☐			DATS	8	0
19	FISCEND	☐			CHAR	4	0
20	COSECLVL	☐			CHAR	15	0
21	EMSECLVL	☐			CHAR	15	0
22	URL	☐			CHAR	200	0
23	ORGTYP	☐			CHAR	2	0
24	STATEINC	☐			CHAR	2	0
25	COUNTRYINC	☐			CHAR	3	0
26	PARENTDUNS	☐			CHAR	13	0
27	BUSTYPES	☐			CHAR	20	0
28	.INCLUDE	☐				0	0	CCR Vendor Business Types
29	BUSTYP01	☐			CHAR	2	0
30	BUSTYP02	☐			CHAR	2	0
31	BUSTYP03	☐			CHAR	2	0
32	BUSTYP04	☐			CHAR	2	0
33	BUSTYP05	☐			CHAR	2	0
34	BUSTYP06	☐			CHAR	2	0
35	BUSTYP07	☐			CHAR	2	0
36	BUSTYP08	☐			CHAR	2	0
37	BUSTYP09	☐			CHAR	2	0
38	BUSTYP10	☐			CHAR	2	0
39	SICCODE	☐			CHAR	160	0
40	.INCLUDE	☐				0	0	CCR SIC structure
41	SIC01	☐			CHAR	8	0
42	SIC02	☐			CHAR	8	0
43	SIC03	☐			CHAR	8	0
44	SIC04	☐			CHAR	8	0
45	SIC05	☐			CHAR	8	0
46	SIC06	☐			CHAR	8	0
47	SIC07	☐			CHAR	8	0
48	SIC08	☐			CHAR	8	0
49	SIC09	☐			CHAR	8	0
50	SIC10	☐			CHAR	8	0
51	SIC11	☐			CHAR	8	0
52	SIC12	☐			CHAR	8	0
53	SIC13	☐			CHAR	8	0
54	SIC14	☐			CHAR	8	0
55	SIC15	☐			CHAR	8	0
56	SIC16	☐			CHAR	8	0
57	SIC17	☐			CHAR	8	0
58	SIC18	☐			CHAR	8	0
59	SIC19	☐			CHAR	8	0
60	SIC20	☐			CHAR	8	0
61	NAICS	☐			CHAR	120	0
62	.INCLUDE	☐				0	0	CCR NAICS Structure
63	NAICS01	☐			CHAR	6	0
64	NAICS02	☐			CHAR	6	0
65	NAICS03	☐			CHAR	6	0
66	NAICS04	☐			CHAR	6	0
67	NAICS05	☐			CHAR	6	0
68	NAICS06	☐			CHAR	6	0
69	NAICS07	☐			CHAR	6	0
70	NAICS08	☐			CHAR	6	0
71	NAICS09	☐			CHAR	6	0
72	NAICS10	☐			CHAR	6	0
73	NAICS11	☐			CHAR	6	0
74	NAICS12	☐			CHAR	6	0
75	NAICS13	☐			CHAR	6	0
76	NAICS14	☐			CHAR	6	0
77	NAICS15	☐			CHAR	6	0
78	NAICS16	☐			CHAR	6	0
79	NAICS17	☐			CHAR	6	0
80	NAICS18	☐			CHAR	6	0
81	NAICS19	☐			CHAR	6	0
82	NAICS20	☐			CHAR	6	0
83	FSCCODE	☐			CHAR	40	0
84	.INCLUDE	☐				0	0	CCR FSC Codes Structure
85	FSC01	☐			CHAR	4	0
86	FSC02	☐			CHAR	4	0
87	FSC03	☐			CHAR	4	0
88	FSC04	☐			CHAR	4	0
89	FSC05	☐			CHAR	4	0
90	FSC06	☐			CHAR	4	0
91	FSC07	☐			CHAR	4	0
92	FSC08	☐			CHAR	4	0
93	FSC09	☐			CHAR	4	0
94	FSC10	☐			CHAR	4	0
95	PSCCODE	☐			CHAR	40	0
96	.INCLUDE	☐				0	0	CCR Vendor PSC Code Structure
97	PSC01	☐			CHAR	4	0
98	PSC02	☐			CHAR	4	0
99	PSC03	☐			CHAR	4	0
100	PSC04	☐			CHAR	4	0
101	PSC05	☐			CHAR	4	0
102	PSC06	☐			CHAR	4	0
103	PSC07	☐			CHAR	4	0
104	PSC08	☐			CHAR	4	0
105	PSC09	☐			CHAR	4	0
106	PSC10	☐			CHAR	4	0
107	CREDCARD	☐			CHAR	1	0
108	CORRFLAG	☐			CHAR	1	0
109	EDI	☐			CHAR	1	0
110	TAXID	☐	FMCCRTAXID		NUMC	9	0	CCR TaxID
111	AVGNUMEMP	☐			CHAR	15	0
112	ANNUALREV	☐			CHAR	15	0
113	SSN	☐			CHAR	9	0
114	FININST	☐			CHAR	30	0
115	ACCNTNO	☐			CHAR	20	0
116	ABAROUTE	☐			CHAR	9	0
117	PAYTYPE	☐			CHAR	1	0
118	LOCKBOXNO	☐			CHAR	20	0
119	AUTHDATE	☐			DATS	8	0
120	EFTWAIVER	☐			CHAR	1	0
121	ACH_US_PHONE	☐			CHAR	30	0
122	ACH_NUS_PHONE	☐			CHAR	30	0
123	ACH_FAX	☐			CHAR	30	0
124	ACH_EMAIL	☐			CHAR	80	0
125	MPIN	☐			CHAR	9	0

History

Last changed by/on	SAP	20110901
SAP Release Created in	10A