SAP table CIS_VERIFY (Structure for CIS Vendor verification - Vendor Info)

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

CIS_VERIFY foreign key relationships

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