1. Home
  2. Resources
  3. SAP Tables
  4. CIS_VERIFY - Structure for CIS Vendor verification - Vendor Info

SAP Table CIS_VERIFY

Structure for CIS Vendor verification - Vendor Info

CIS_VERIFY (Structure for CIS Vendor verification - Vendor Info) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CIS_VERIFY to other SAP tables.

CIS_VERIFY table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS CHAR 4 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
CATEG Subcontractor's Business Type CIS_CATEGORY CHAR 12 0
ST soletrader
TT trust
CO company
PT partnership
PARTNER_NAME Partner's Trading Name CIS_PARTNER_NAME CHAR 30 0
PARTNER_UTR Partner's Unique Tax Reference (UTR) CIS_PARTNER_UTR CHAR 20 0
STATUS Verification Status CIS_VFNSTATUS CHAR 3 0
ST1 Unmatched by HMRC, details must be verified with subcontract
ST2 Unmatched, details must be matched and verified by HMRC
ST3 Unmatched, details must be verified by HMRC
ST4 Verified, verification number and tax treatment not updated
ST5 Verified, vendor master data updated
VFNUM Verification Number GB_CIS_SC_VFNNUM CHAR 20 0
VFNID Tax Status of the Verified Subcontractor CIS_VFN_ID CHAR 1 0
G Gross
N Net
U Unidentified
GB_CIS_SC_TRDNM Subcontractor's Trading Name GB_CIS_SC_TRDNM CHAR 64 0
GB_CIS_SC_FSNM Subcontractor's First Name GB_CIS_SC_FSNM CHAR 64 0
GB_CIS_SC_SCNM Subcontractor's Second Name GB_CIS_SC_SCNM CHAR 64 0
GB_CIS_SC_INTL Subcontractor's Last Name GB_CIS_SC_INTL CHAR 64 0
GB_CIS_SC_VFNNUM Verification Number GB_CIS_SC_VFNNUM CHAR 20 0
GB_CIS_SC_UTR Subcontractor's Unique Tax Reference (UTR) GB_CIS_SC_UTR CHAR 20 0
GB_CIS_SC_VFNSTS Sub contractor verification status GB_CIS_SC_VFNSTS CHAR 1 0
GB_CIS_SCNUM Numerical Character Field of Length 6 NUM6 NUMC 6 0
ADDRNUMBER Address number AD_ADDRNUM CHAR 10 0
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 0
DATE_TO Valid-to date in current Release only 99991231 possible AD_DATE_TO DATS 8 0
TITLE Form-of-Address Key AD_TITLE TSAD3 CHAR 4 0
NAME1 Name 1 AD_NAME1 CHAR 40 0
NAME2 Name 2 AD_NAME2 CHAR 40 0
NAME3 Name 3 AD_NAME3 CHAR 40 0
NAME4 Name 4 AD_NAME4 CHAR 40 0
NAME_TXT Converted name field (with form of address) AD_NAMETXT CHAR 50 0
NAME_CO c/o name AD_NAME_CO CHAR 40 0
CITY1 City AD_CITY1 CHAR 40 0
CITY2 District AD_CITY2 CHAR 40 0
CITY_CODE City code for city/street file AD_CITYNUM ADRCITY CHAR 12 0
CITYP_CODE District code for City and Street file AD_CITYPNM ADRCITYPRT CHAR 8 0
HOME_CITY City (different from postal city) AD_CITY3 CHAR 40 0
CITYH_CODE Different city for city/street file AD_CITYHNM ADRCITY CHAR 12 0
CHCKSTATUS City file test status AD_CHECKST CHAR 1 0
NULL Not checked
C checked against city index
D differs from city index
REGIOGROUP Regional structure grouping REGIOGROUP ADRREGGRP CHAR 8 0
POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
POST_CODE2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
POST_CODE3 Company Postal Code (for Large Customers) AD_PSTCD3 CHAR 10 0
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XT CHAR 10 0
PCODE2_EXT (Not Supported) PO Box Postal Code Extension AD_PST2XT CHAR 10 0
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension AD_PST3XT CHAR 10 0
PO_BOX PO Box AD_POBX CHAR 10 0
DONT_USE_P PO Box Address Undeliverable Flag AD_NO_USEP TSAD12 CHAR 4 0
PO_BOX_NUM Flag: PO Box Without Number AD_POBXNUM CHAR 1 0
X Yes
NULL No
PO_BOX_LOC PO Box city AD_POBXLOC CHAR 40 0
CITY_CODE2 City PO box code (City file) AD_CIT2NUM ADRCITY CHAR 12 0
PO_BOX_REG Region for PO Box (Country, State, Province, ...) AD_POBXREG T005S CHAR 3 0
PO_BOX_CTY PO box country AD_POBXCTY T005 CHAR 3 0
POSTALAREA (Not Supported) Post Delivery District AD_PSTLAR CHAR 15 0
TRANSPZONE Transportation zone to or from which the goods are delivered LZONE TZONE CHAR 10 0
STREET Street AD_STREET CHAR 60 0
DONT_USE_S Street Address Undeliverable Flag AD_NO_USES TSAD12 CHAR 4 0
STREETCODE Street Number for City/Street File AD_STRNUM ADRSTREET CHAR 12 0
STREETABBR (Not Supported) Abbreviation of Street Name AD_STRABBR ADRSTRTYPE CHAR 2 0
HOUSE_NUM1 House Number AD_HSNM1 CHAR 10 0
HOUSE_NUM2 House number supplement AD_HSNM2 CHAR 10 0
HOUSE_NUM3 (Not supported) House Number Range AD_HSNM3 CHAR 10 0
STR_SUPPL1 Street 2 AD_STRSPP1 CHAR 40 0
STR_SUPPL2 Street 3 AD_STRSPP2 CHAR 40 0
STR_SUPPL3 Street 4 AD_STRSPP3 CHAR 40 0
LOCATION Street 5 AD_LCTN CHAR 40 0
BUILDING Building (Number or Code) AD_BLDNG CHAR 20 0
FLOOR Floor in building AD_FLOOR CHAR 10 0
ROOMNUMBER Room or Appartment Number AD_ROOMNUM CHAR 10 0
COUNTRY Country Key LAND1 T005 CHAR 3 0
LANGU Language Key SPRAS T002 LANG 1 0
REGION Region (State, Province, County) REGIO T005S CHAR 3 0
SORT1 Search Term 1 AD_SORT1UL CHAR 20 0
SORT2 Search Term 2 AD_SORT2UL CHAR 20 0
SORT_PHN (Not Supported) Phonetic Search Sort Field AD_SRTPHN CHAR 20 0
ADDRORIGIN (Not Supported) Address Data Source (Key) AD_ORIGINA TSAD6 CHAR 4 0
EXTENSION1 Extension (only for data conversion) (e.g. data line) AD_EXTENS1 CHAR 40 0
EXTENSION2 Extension (only for data conversion) (e.g. telebox) AD_EXTENS2 CHAR 40 0
TIME_ZONE Address time zone AD_TZONE TTZZ CHAR 6 0
TAXJURCODE Tax Jurisdiction AD_TXJCD CHAR 15 0
ADDRESS_ID (Not supported) Physical address ID AD_ADDR_ID CHAR 10 0
REMARK Address notes AD_REMARK1 CHAR 50 0
LANGU_CREA Address record creation original language AD_LANGUCR T002 LANG 1 0
PO_BOX_LOBBY PO Box Lobby AD_PO_BOX_LBY CHAR 40 0
DELI_SERV_TYPE Type of Delivery Service AD_DELIVERY_SERVICE_TYPE ADDRC_DELI_SERV CHAR 4 0
DELI_SERV_NUMBER Number of Delivery Service AD_DELIVERY_SERVICE_NUMBER CHAR 10 0
COUNTY_CODE County code for county AD_CNTYNUM ADRCOUNTY CHAR 8 0
COUNTY County AD_COUNTY CHAR 40 0
TOWNSHIP_CODE Township code for Township AD_TWSHPNUM ADRTOWNSHIP CHAR 8 0
TOWNSHIP Township AD_TOWNSHIP CHAR 40 0
DEFLT_COMM Communication Method (Key) (Business Address Services) AD_COMM TSAC CHAR 3 0
LANDX Country Name LANDX CHAR 15 0
NATIO Nationality NATIO CHAR 15 0
BEZEI Region AD_REGION CHAR 20 0
TEL_NUMBER First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
SC_CRN Tax Number 1 STCD1 CHAR 16 0
SC_NINO Tax Number 2 STCD2 CHAR 11 0
ACTION Action Type CIS_ACTION CHAR 10 0
MATCH Match
VERIFY Verify
SC_WORKSREF Partner ID PARTNERNO CHAR 35 0
SC_EXTRA01 CHAR 50 WITH LOWER CASE WT_EXTRA CHAR 50 0
SC_EXTRA02 CHAR 50 WITH LOWER CASE WT_EXTRA CHAR 50 0
SC_EXTRA03 CHAR 50 WITH LOWER CASE WT_EXTRA CHAR 50 0
SC_EXTRA04 CHAR 50 WITH LOWER CASE WT_EXTRA CHAR 50 0
SC_EXTRA05 CHAR 50 WITH LOWER CASE WT_EXTRA CHAR 50 0

CIS_VERIFY foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CIS_VERIFY ADDRORIGIN * TSAD6 Source Address or Personal Data (Business Address Services) CLIENT
CIS_VERIFY ADDRORIGIN CIS_VERIFY ADDRORIGIN TSAD6 Source Address or Personal Data (Business Address Services) ORIGIN
CIS_VERIFY CITYH_CODE * ADRCITY Postal cities CLIENT
CIS_VERIFY CITYH_CODE CIS_VERIFY COUNTRY ADRCITY Postal cities COUNTRY
CIS_VERIFY CITYH_CODE CIS_VERIFY CITYH_CODE ADRCITY Postal cities CITY_CODE
CIS_VERIFY CITYP_CODE CIS_VERIFY COUNTRY ADRCITYPRT Postal districts COUNTRY
CIS_VERIFY CITYP_CODE CIS_VERIFY CITY_CODE ADRCITYPRT Postal districts CITY_CODE
CIS_VERIFY CITYP_CODE CIS_VERIFY CITYP_CODE ADRCITYPRT Postal districts CITYP_CODE
CIS_VERIFY CITYP_CODE * ADRCITYPRT Postal districts CLIENT
CIS_VERIFY CITY_CODE CIS_VERIFY CITY_CODE ADRCITY Postal cities CITY_CODE
CIS_VERIFY CITY_CODE * ADRCITY Postal cities CLIENT
CIS_VERIFY CITY_CODE CIS_VERIFY COUNTRY ADRCITY Postal cities COUNTRY
CIS_VERIFY CITY_CODE2 * ADRCITY Postal cities CLIENT
CIS_VERIFY CITY_CODE2 CIS_VERIFY COUNTRY ADRCITY Postal cities COUNTRY
CIS_VERIFY CITY_CODE2 CIS_VERIFY CITY_CODE2 ADRCITY Postal cities CITY_CODE
CIS_VERIFY COUNTRY * T005 Countries MANDT
CIS_VERIFY COUNTRY CIS_VERIFY COUNTRY T005 Countries LAND1
CIS_VERIFY COUNTY_CODE CIS_VERIFY COUNTY_CODE ADRCOUNTY County codes COUNTY_CODE
CIS_VERIFY COUNTY_CODE SYST MANDT ADRCOUNTY County codes CLIENT
CIS_VERIFY COUNTY_CODE CIS_VERIFY PO_BOX_CTY ADRCOUNTY County codes COUNTRY
CIS_VERIFY COUNTY_CODE CIS_VERIFY PO_BOX_REG ADRCOUNTY County codes REGION
CIS_VERIFY DEFLT_COMM CIS_VERIFY DEFLT_COMM TSAC Communication Methods (Business Address Services) COMM_TYPE
CIS_VERIFY DELI_SERV_TYPE SYST MANDT ADDRC_DELI_SERV Address Service Types CLIENT
CIS_VERIFY DELI_SERV_TYPE CIS_VERIFY DELI_SERV_TYPE ADDRC_DELI_SERV Address Service Types DELI_SERV_TYPE
CIS_VERIFY DONT_USE_P SYST MANDT TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
CIS_VERIFY DONT_USE_P CIS_VERIFY DONT_USE_P TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
CIS_VERIFY DONT_USE_S SYST MANDT TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
CIS_VERIFY DONT_USE_S CIS_VERIFY DONT_USE_S TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
CIS_VERIFY LANGU CIS_VERIFY LANGU T002 Language Keys (Component BC-I18) SPRAS
CIS_VERIFY LANGU_CREA CIS_VERIFY LANGU_CREA T002 Language Keys (Component BC-I18) SPRAS
CIS_VERIFY PO_BOX_CTY * T005 Countries MANDT
CIS_VERIFY PO_BOX_CTY CIS_VERIFY PO_BOX_CTY T005 Countries LAND1
CIS_VERIFY PO_BOX_REG CIS_VERIFY PO_BOX_CTY T005S Taxes: Region (Province) Key LAND1
CIS_VERIFY PO_BOX_REG CIS_VERIFY PO_BOX_REG T005S Taxes: Region (Province) Key BLAND
CIS_VERIFY PO_BOX_REG * T005S Taxes: Region (Province) Key MANDT
CIS_VERIFY REGIOGROUP * ADRREGGRP Regional structure grouping CLIENT
CIS_VERIFY REGIOGROUP CIS_VERIFY REGIOGROUP ADRREGGRP Regional structure grouping REGIOGROUP
CIS_VERIFY REGION * T005S Taxes: Region (Province) Key MANDT
CIS_VERIFY REGION CIS_VERIFY COUNTRY T005S Taxes: Region (Province) Key LAND1
CIS_VERIFY REGION CIS_VERIFY REGION T005S Taxes: Region (Province) Key BLAND
CIS_VERIFY STREETABBR * ADRSTRTYPE Street type CLIENT
CIS_VERIFY STREETABBR CIS_VERIFY COUNTRY ADRSTRTYPE Street type COUNTRY
CIS_VERIFY STREETABBR CIS_VERIFY STREETABBR ADRSTRTYPE Street type STRTYPEAB
CIS_VERIFY STREETCODE CIS_VERIFY STREETCODE ADRSTREET Streets STRT_CODE
CIS_VERIFY STREETCODE * ADRSTREET Streets CLIENT
CIS_VERIFY STREETCODE CIS_VERIFY COUNTRY ADRSTREET Streets COUNTRY
CIS_VERIFY TIME_ZONE * TTZZ Time zones CLIENT
CIS_VERIFY TIME_ZONE CIS_VERIFY TIME_ZONE TTZZ Time zones TZONE
CIS_VERIFY TITLE CIS_VERIFY TITLE TSAD3 Forms of Address (Key) (Business Address Services) TITLE
CIS_VERIFY TITLE * TSAD3 Forms of Address (Key) (Business Address Services) CLIENT
CIS_VERIFY TOWNSHIP_CODE CIS_VERIFY PO_BOX_CTY ADRTOWNSHIP Township codes COUNTRY
CIS_VERIFY TOWNSHIP_CODE CIS_VERIFY PO_BOX_REG ADRTOWNSHIP Township codes REGION
CIS_VERIFY TOWNSHIP_CODE CIS_VERIFY COUNTY_CODE ADRTOWNSHIP Township codes COUNTY_CODE
CIS_VERIFY TOWNSHIP_CODE CIS_VERIFY TOWNSHIP_CODE ADRTOWNSHIP Township codes TOWNSHIP_CODE
CIS_VERIFY TOWNSHIP_CODE SYST MANDT ADRTOWNSHIP Township codes CLIENT
CIS_VERIFY TRANSPZONE * TZONE Customers: Regional zones MANDT
CIS_VERIFY TRANSPZONE CIS_VERIFY COUNTRY TZONE Customers: Regional zones LAND1
CIS_VERIFY TRANSPZONE CIS_VERIFY TRANSPZONE TZONE Customers: Regional zones ZONE1