SAP table FMFG_LFACCR (Vendor Master Central Contractor Registry (CCR))

SAP table FMFG_LFACCR has 2 primary key fields being MANDT,LIFNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
DUNS DUNS Number CHAR 9 0 FMCCRDUNS
DUNS4 DUNS+4 CHAR 4 0 FMCCRDUNS4
CAGE CAGE Code CHAR 5 0 FMCCRCAGE
RENDATE Obsolete field (do not use) - Renewal date for CCR Vendor DATS 8 0 FMCCRENDAT
REG_IND CCR Registration Indicator CHAR 1 0 FMFGCCRREGIND
R Required
X Exempt
REG_STAT Obsolete field (do not use) - CCR Registration Status CHAR 1 0 FMFGCCRREGSTAT
A Active
I Inactive
U Unregistered
X Expired
SAM_UE_ID System for Award Management Unique Entity Identifier CHAR 12 0 FMFG_UNIQUE_ENTITY_ID
SAM_EFT_IND System for Award Management Electronic Funds Transfer Ind CHAR 4 0 FMFG_EFT_IND

FMFG_LFACCR foreign key relationships

Table Field Check Table Check Field
0 FMFG_LFACCR LIFNR LFA1 Supplier Master (General Section) MANDT
0 FMFG_LFACCR LIFNR LFA1 Supplier Master (General Section) LIFNR