FMCCRTVENDOR SAP table for – CCR Vendor Table

Here we would like to draw your attention to FMCCRTVENDOR table in SAP. As we know it is being mainly used with the SAP PSM-FG (Functions for U.S. Federal Government in PSM) component which is coming under PSM module (Public Sector Management). FMCCRTVENDOR is a SAP standard transp table used for storing CCR Vendor Table related data in SAP. It comes under the package FMFG_CCR_E.

SAP FMCCRTVENDOR table

Table FMCCRTVENDOR technical data

TableFMCCRTVENDOR
Data storingCCR Vendor Table
ModulePSM
Sub ModulePSM-FG
SAP PackageFMFG_CCR_E
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP FMCCRTVENDOR Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMCCRTVENDOR table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DUNS : DUNS Number
    Its a key field. Its data type is CHAR (Character String) with field length 9
  • DUNS4 : DUNS+4
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • CAGE : Cage Code
    Its data type is CHAR (Character String) with field length 5
  • EXCODE : Extract Code
    Its data type is CHAR (Character String) with field length 1
  • REGDATE : Registration date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RENDATE : Renewal date for CCR Vendor (Expired)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUSNAME : Comment
    Its data type is CHAR (Character String) with field length 120
  • DBANAME
    Its data type is CHAR (Character String) with field length 60
  • COMPDIV
    Its data type is CHAR (Character String) with field length 60
  • DIVNUM
    Its data type is CHAR (Character String) with field length 10
  • STADD1
    Its data type is CHAR (Character String) with field length 55
  • STADD2
    Its data type is CHAR (Character String) with field length 55
  • CITY : String 20 -> Name, Usrname, pwd, … – use STRING for forms
    Its data type is CHAR (Character String) with field length 35
  • STATE : Single-Character Flag
    Its data type is CHAR (Character String) with field length 2
  • POSTAL
    Its data type is CHAR (Character String) with field length 35
  • COUNTRY : Country Key
    Its data type is CHAR (Character String) with field length 3
  • BUSSTART
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FISCEND
    Its data type is CHAR (Character String) with field length 4
  • COSECLVL
    Its data type is CHAR (Character String) with field length 15
  • EMSECLVL
    Its data type is CHAR (Character String) with field length 15
  • URL : Text field length 200
    Its data type is CHAR (Character String) with field length 200
  • ORGTYP : Organization Type
    Its data type is CHAR (Character String) with field length 2
  • STATEINC
    Its data type is CHAR (Character String) with field length 2
  • COUNTRYINC
    Its data type is CHAR (Character String) with field length 3
  • PARENTDUNS
    Its data type is CHAR (Character String) with field length 13
  • BUSTYPES
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : CCR Vendor Business Types
  • BUSTYP01
    Its data type is CHAR (Character String) with field length 2
  • BUSTYP02
    Its data type is CHAR (Character String) with field length 2
  • BUSTYP03
    Its data type is CHAR (Character String) with field length 2
  • BUSTYP04
    Its data type is CHAR (Character String) with field length 2
  • BUSTYP05
    Its data type is CHAR (Character String) with field length 2
  • BUSTYP06
    Its data type is CHAR (Character String) with field length 2
  • BUSTYP07
    Its data type is CHAR (Character String) with field length 2
  • BUSTYP08
    Its data type is CHAR (Character String) with field length 2
  • BUSTYP09
    Its data type is CHAR (Character String) with field length 2
  • BUSTYP10
    Its data type is CHAR (Character String) with field length 2
  • SICCODE
    Its data type is CHAR (Character String) with field length 160
  • .INCLUDE : CCR SIC structure
  • SIC01
    Its data type is CHAR (Character String) with field length 8
  • SIC02
    Its data type is CHAR (Character String) with field length 8
  • SIC03
    Its data type is CHAR (Character String) with field length 8
  • SIC04
    Its data type is CHAR (Character String) with field length 8
  • SIC05
    Its data type is CHAR (Character String) with field length 8
  • SIC06
    Its data type is CHAR (Character String) with field length 8
  • SIC07
    Its data type is CHAR (Character String) with field length 8
  • SIC08
    Its data type is CHAR (Character String) with field length 8
  • SIC09
    Its data type is CHAR (Character String) with field length 8
  • SIC10
    Its data type is CHAR (Character String) with field length 8
  • SIC11
    Its data type is CHAR (Character String) with field length 8
  • SIC12
    Its data type is CHAR (Character String) with field length 8
  • SIC13
    Its data type is CHAR (Character String) with field length 8
  • SIC14
    Its data type is CHAR (Character String) with field length 8
  • SIC15
    Its data type is CHAR (Character String) with field length 8
  • SIC16
    Its data type is CHAR (Character String) with field length 8
  • SIC17
    Its data type is CHAR (Character String) with field length 8
  • SIC18
    Its data type is CHAR (Character String) with field length 8
  • SIC19
    Its data type is CHAR (Character String) with field length 8
  • SIC20
    Its data type is CHAR (Character String) with field length 8
  • NAICS : NAICS code
    Its data type is CHAR (Character String) with field length 120
  • .INCLUDE : CCR NAICS Structure
  • NAICS01
    Its data type is CHAR (Character String) with field length 6
  • NAICS02
    Its data type is CHAR (Character String) with field length 6
  • NAICS03
    Its data type is CHAR (Character String) with field length 6
  • NAICS04
    Its data type is CHAR (Character String) with field length 6
  • NAICS05
    Its data type is CHAR (Character String) with field length 6
  • NAICS06
    Its data type is CHAR (Character String) with field length 6
  • NAICS07
    Its data type is CHAR (Character String) with field length 6
  • NAICS08
    Its data type is CHAR (Character String) with field length 6
  • NAICS09
    Its data type is CHAR (Character String) with field length 6
  • NAICS10
    Its data type is CHAR (Character String) with field length 6
  • NAICS11
    Its data type is CHAR (Character String) with field length 6
  • NAICS12
    Its data type is CHAR (Character String) with field length 6
  • NAICS13
    Its data type is CHAR (Character String) with field length 6
  • NAICS14
    Its data type is CHAR (Character String) with field length 6
  • NAICS15
    Its data type is CHAR (Character String) with field length 6
  • NAICS16
    Its data type is CHAR (Character String) with field length 6
  • NAICS17
    Its data type is CHAR (Character String) with field length 6
  • NAICS18
    Its data type is CHAR (Character String) with field length 6
  • NAICS19
    Its data type is CHAR (Character String) with field length 6
  • NAICS20
    Its data type is CHAR (Character String) with field length 6
  • FSCCODE
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : CCR FSC Codes Structure
  • FSC01
    Its data type is CHAR (Character String) with field length 4
  • FSC02
    Its data type is CHAR (Character String) with field length 4
  • FSC03
    Its data type is CHAR (Character String) with field length 4
  • FSC04
    Its data type is CHAR (Character String) with field length 4
  • FSC05
    Its data type is CHAR (Character String) with field length 4
  • FSC06
    Its data type is CHAR (Character String) with field length 4
  • FSC07
    Its data type is CHAR (Character String) with field length 4
  • FSC08
    Its data type is CHAR (Character String) with field length 4
  • FSC09
    Its data type is CHAR (Character String) with field length 4
  • FSC10
    Its data type is CHAR (Character String) with field length 4
  • PSCCODE
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : CCR Vendor PSC Code Structure
  • PSC01
    Its data type is CHAR (Character String) with field length 4
  • PSC02
    Its data type is CHAR (Character String) with field length 4
  • PSC03
    Its data type is CHAR (Character String) with field length 4
  • PSC04
    Its data type is CHAR (Character String) with field length 4
  • PSC05
    Its data type is CHAR (Character String) with field length 4
  • PSC06
    Its data type is CHAR (Character String) with field length 4
  • PSC07
    Its data type is CHAR (Character String) with field length 4
  • PSC08
    Its data type is CHAR (Character String) with field length 4
  • PSC09
    Its data type is CHAR (Character String) with field length 4
  • PSC10
    Its data type is CHAR (Character String) with field length 4
  • CREDCARD
    Its data type is CHAR (Character String) with field length 1
  • CORRFLAG
    Its data type is CHAR (Character String) with field length 1
  • EDI : Indicator: EDI to Owner
    Its data type is CHAR (Character String) with field length 1
  • TAXID : CCR TaxID
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • AVGNUMEMP
    Its data type is CHAR (Character String) with field length 15
  • ANNUALREV
    Its data type is CHAR (Character String) with field length 15
  • SSN
    Its data type is CHAR (Character String) with field length 9
  • FININST
    Its data type is CHAR (Character String) with field length 30
  • ACCNTNO : WC Account Number for Wyoming
    Its data type is CHAR (Character String) with field length 20
  • ABAROUTE
    Its data type is CHAR (Character String) with field length 9
  • PAYTYPE : BSI: Payment type
    Its data type is CHAR (Character String) with field length 1
  • LOCKBOXNO
    Its data type is CHAR (Character String) with field length 20
  • AUTHDATE : Processing Timestamp – Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EFTWAIVER
    Its data type is CHAR (Character String) with field length 1
  • ACH_US_PHONE
    Its data type is CHAR (Character String) with field length 30
  • ACH_NUS_PHONE
    Its data type is CHAR (Character String) with field length 30
  • ACH_FAX
    Its data type is CHAR (Character String) with field length 30
  • ACH_EMAIL
    Its data type is CHAR (Character String) with field length 80
  • MPIN
    Its data type is CHAR (Character String) with field length 9