FMCCRTVENDOR SAP (CCR Vendor Table) Table details

Dictionary Type: Table
Description: CCR Vendor Table




ABAP Code to SELECT data from FMCCRTVENDOR
Related tables to FMCCRTVENDOR
Access table FMCCRTVENDOR




Table field list including key, data, relationships and ABAP select examples

FMCCRTVENDOR is a standard SAP Table which is used to store CCR Vendor Table data and is available within R/3 SAP systems depending on the version and release level.

The FMCCRTVENDOR table consists of various fields, each holding specific information or linking keys about CCR Vendor Table data available in SAP. These include DUNS (DUNS Number), DUNS4 (DUNS+4), CAGE (CAGE Code), EXCODE (Extract Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FMCCRTVENDOR table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
DUNSDUNS Number FMCCRDUNSCHAR9
DUNS4DUNS+4 FMCCRDUNS4CHAR4
CAGECAGE Code FMCCRCAGECHAR5
EXCODEExtract Code FMCCREXCODECHAR1
REGDATERegistration date FMCCREGDATDATS8
RENDATEObsolete field (do not use) - Renewal date for CCR Vendor FMCCRENDATDATS8DATS
BUSNAME Legal Business Name0
DBANAME Doing Business As0
COMPDIV Company Division0
DIVNUM Division Number0
STADD1 Street Address 1a0
STADD2 Street Address 20
CITY City0
STATE State or Province0
POSTAL Postal Code0
COUNTRY Country Code0
BUSSTART Business Start Date0
FISCEND Fiscal Year End Close Date0
COSECLVL Company Security Level0
EMSECLVL Employee Security Level0
URL Corporate URL0
ORGTYP Organizational Type0
STATEINC State of Incorporation0
COUNTRYINC Country of Incorporation0
PARENTDUNS Parent DUNS Number0
BUSTYPES Business Types0
BUSTYP01 Business Type0
BUSTYP02 Business Type0
BUSTYP03 Business Type0
BUSTYP04 Business Type0
BUSTYP05 Business Type0
BUSTYP06 Business Type0
BUSTYP07 Business Type0
BUSTYP08 Business Type0
BUSTYP09 Business Type0
BUSTYP10 Business Type0
SICCODE SIC Codes0
SIC01 SIC Code0
SIC02 SIC Code0
SIC03 SIC Code0
SIC04 SIC Code0
SIC05 SIC Code0
SIC06 SIC Code0
SIC07 SIC Code0
SIC08 SIC Code0
SIC09 SIC Code0
SIC10 SIC Code0
SIC11 SIC Code0
SIC12 SIC Code0
SIC13 SIC Code0
SIC14 SIC Code0
SIC15 SIC Code0
SIC16 SIC Code0
SIC17 SIC Code0
SIC18 SIC Code0
SIC19 SIC Code0
SIC20 SIC Code0
NAICS NAICS codes0
NAICS01 NAICS Code0
NAICS02 NAICS Code0
NAICS03 NAICS Code0
NAICS04 NAICS Code0
NAICS05 NAICS Code0
NAICS06 NAICS Code0
NAICS07 NAICS Code0
NAICS08 NAICS Code0
NAICS09 NAICS Code0
NAICS10 NAICS Code0
NAICS11 NAICS Code0
NAICS12 NAICS Code0
NAICS13 NAICS Code0
NAICS14 NAICS Code0
NAICS15 NAICS Code0
NAICS16 NAICS Code0
NAICS17 NAICS Code0
NAICS18 NAICS Code0
NAICS19 NAICS Code0
NAICS20 NAICS Code0
FSCCODE FSC Codes0
FSC01 FSC Code0
FSC02 FSC Code0
FSC03 FSC Code0
FSC04 FSC Code0
FSC05 FSC Code0
FSC06 FSC Code0
FSC07 FSC Code0
FSC08 FSC Code0
FSC09 FSC Code0
FSC10 FSC Code0
PSCCODE PSC Codes0
PSC01 PSC Code0
PSC02 PSC Code0
PSC03 PSC Code0
PSC04 PSC Code0
PSC05 PSC Code0
PSC06 PSC Code0
PSC07 PSC Code0
PSC08 PSC Code0
PSC09 PSC Code0
PSC10 PSC Code0
CREDCARD Credit Card0
CORRFLAG Correspondence Flag0
EDI EDI Flag0
TAXIDCCR TaxID FMCCRTAXIDNUMC9
AVGNUMEMP Average Number of Employees0
ANNUALREV Annual Revenue0
SSN Social Security Number0
FININST Financial Institute (EFT)0
ACCNTNO Account Number (EFT)0
ABAROUTE ABA Routing ID (EFT)0
PAYTYPE Payment Type (EFT)0
LOCKBOXNO Lockbox Number (EFT)0
AUTHDATE Authorization Date (EFT)0
EFTWAIVER EFT Waiver (EFT)0
ACH_US_PHONE ACH US Phone (EFT)0
ACH_NUS_PHONE ACH Non-US Phone (EFT)0
ACH_FAX ACH Fax (EFT)0
ACH_EMAIL ACH e-mail (EFT)0
MPIN Marketing Partner ID Number0

Key field Non-key field



How do I retrieve data from SAP table FMCCRTVENDOR using ABAP code

The following ABAP code Example will allow you to do a basic selection on FMCCRTVENDOR to SELECT all data from the table
DATA: WA_FMCCRTVENDOR TYPE FMCCRTVENDOR.

SELECT SINGLE *
FROM FMCCRTVENDOR
INTO CORRESPONDING FIELDS OF WA_FMCCRTVENDOR
WHERE...

How to access SAP table FMCCRTVENDOR

Within an ECC or HANA version of SAP you can also view further information about FMCCRTVENDOR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!