FMCCRTVENDOR - CCR Vendor Table

CCR Vendor Table information is stored in SAP table FMCCRTVENDOR.
It is part of development package FMFG_CCR_E in software component PSM-FG. This development package consists of objects that can be grouped under "Interface to Central Contractor Registry (CCR)".

Fields for table FMCCRTVENDOR

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
DUNS	DUNS Number	X	FMCCRDUNS	CHAR	18
DUNS4	DUNS+4	X	FMCCRDUNS4	CHAR	8
CAGE	CAGE Code		FMCCRCAGE	CHAR	10
EXCODE	Extract Code		FMCCREXCODE	CHAR	2
REGDATE	Registration date		FMCCREGDAT	DATS	16
RENDATE	Obsolete field (do not use) - Renewal date for CCR Vendor		FMCCRENDAT	DATS	16
BUSNAME	Legal Business Name			CHAR	240
DBANAME	Doing Business As			CHAR	120
COMPDIV	Company Division			CHAR	120
DIVNUM	Division Number			CHAR	20
STADD1	Street Address 1a			CHAR	110
STADD2	Street Address 2			CHAR	110
CITY	City			CHAR	70
STATE	State or Province			CHAR	4
POSTAL	Postal Code			CHAR	70
COUNTRY	Country Code			CHAR	6
BUSSTART	Business Start Date			DATS	16
FISCEND	Fiscal Year End Close Date			CHAR	8
COSECLVL	Company Security Level			CHAR	30
EMSECLVL	Employee Security Level			CHAR	30
URL	Corporate URL			CHAR	400
ORGTYP	Organizational Type			CHAR	4
STATEINC	State of Incorporation			CHAR	4
COUNTRYINC	Country of Incorporation			CHAR	6
PARENTDUNS	Parent DUNS Number			CHAR	26
BUSTYPES	Business Types			CHAR	40
.INCLUDE				FMCCRBUSTYPES	0
BUSTYP01	Business Type			CHAR	4
BUSTYP02	Business Type			CHAR	4
BUSTYP03	Business Type			CHAR	4
BUSTYP04	Business Type			CHAR	4
BUSTYP05	Business Type			CHAR	4
BUSTYP06	Business Type			CHAR	4
BUSTYP07	Business Type			CHAR	4
BUSTYP08	Business Type			CHAR	4
BUSTYP09	Business Type			CHAR	4
BUSTYP10	Business Type			CHAR	4
SICCODE	SIC Codes			CHAR	320
.INCLUDE				FMCCRSIC	0
SIC01	SIC Code			CHAR	16
SIC02	SIC Code			CHAR	16
SIC03	SIC Code			CHAR	16
SIC04	SIC Code			CHAR	16
SIC05	SIC Code			CHAR	16
SIC06	SIC Code			CHAR	16
SIC07	SIC Code			CHAR	16
SIC08	SIC Code			CHAR	16
SIC09	SIC Code			CHAR	16
SIC10	SIC Code			CHAR	16
SIC11	SIC Code			CHAR	16
SIC12	SIC Code			CHAR	16
SIC13	SIC Code			CHAR	16
SIC14	SIC Code			CHAR	16
SIC15	SIC Code			CHAR	16
SIC16	SIC Code			CHAR	16
SIC17	SIC Code			CHAR	16
SIC18	SIC Code			CHAR	16
SIC19	SIC Code			CHAR	16
SIC20	SIC Code			CHAR	16
NAICS	NAICS codes			CHAR	240
.INCLUDE				FMCCRNAICS	0
NAICS01	NAICS Code			CHAR	12
NAICS02	NAICS Code			CHAR	12
NAICS03	NAICS Code			CHAR	12
NAICS04	NAICS Code			CHAR	12
NAICS05	NAICS Code			CHAR	12
NAICS06	NAICS Code			CHAR	12
NAICS07	NAICS Code			CHAR	12
NAICS08	NAICS Code			CHAR	12
NAICS09	NAICS Code			CHAR	12
NAICS10	NAICS Code			CHAR	12
NAICS11	NAICS Code			CHAR	12
NAICS12	NAICS Code			CHAR	12
NAICS13	NAICS Code			CHAR	12
NAICS14	NAICS Code			CHAR	12
NAICS15	NAICS Code			CHAR	12
NAICS16	NAICS Code			CHAR	12
NAICS17	NAICS Code			CHAR	12
NAICS18	NAICS Code			CHAR	12
NAICS19	NAICS Code			CHAR	12
NAICS20	NAICS Code			CHAR	12
FSCCODE	FSC Codes			CHAR	80
.INCLUDE				FMCCRFSC	0
FSC01	FSC Code			CHAR	8
FSC02	FSC Code			CHAR	8
FSC03	FSC Code			CHAR	8
FSC04	FSC Code			CHAR	8
FSC05	FSC Code			CHAR	8
FSC06	FSC Code			CHAR	8
FSC07	FSC Code			CHAR	8
FSC08	FSC Code			CHAR	8
FSC09	FSC Code			CHAR	8
FSC10	FSC Code			CHAR	8
PSCCODE	PSC Codes			CHAR	80
.INCLUDE				FMCCRPSC	0
PSC01	PSC Code			CHAR	8
PSC02	PSC Code			CHAR	8
PSC03	PSC Code			CHAR	8
PSC04	PSC Code			CHAR	8
PSC05	PSC Code			CHAR	8
PSC06	PSC Code			CHAR	8
PSC07	PSC Code			CHAR	8
PSC08	PSC Code			CHAR	8
PSC09	PSC Code			CHAR	8
PSC10	PSC Code			CHAR	8
CREDCARD	Credit Card			CHAR	2
CORRFLAG	Correspondence Flag			CHAR	2
EDI	EDI Flag			CHAR	2
TAXID	CCR TaxID		FMCCRTAXID	NUMC	18
AVGNUMEMP	Average Number of Employees			CHAR	30
ANNUALREV	Annual Revenue			CHAR	30
SSN	Social Security Number			CHAR	18
FININST	Financial Institute (EFT)			CHAR	60
ACCNTNO	Account Number (EFT)			CHAR	40
ABAROUTE	ABA Routing ID (EFT)			CHAR	18
PAYTYPE	Payment Type (EFT)			CHAR	2
LOCKBOXNO	Lockbox Number (EFT)			CHAR	40
AUTHDATE	Authorization Date (EFT)			DATS	16
EFTWAIVER	EFT Waiver (EFT)			CHAR	2
ACH_US_PHONE	ACH US Phone (EFT)			CHAR	60
ACH_NUS_PHONE	ACH Non-US Phone (EFT)			CHAR	60
ACH_FAX	ACH Fax (EFT)			CHAR	60
ACH_EMAIL	ACH e-mail (EFT)			CHAR	160
MPIN	Marketing Partner ID Number			CHAR	18