SAP ABAP Table CIS_VERIFY (Structure for CIS Vendor verification - Vendor Info)
Hierarchy
SAP_FIN (Software Component) SAP_FIN
   FI-LOC (Application Component) Localization
     ID-FI-WT (Package) Withholding Tax reporting
Basic Data
Table Category INTTAB    Structure 
Structure CIS_VERIFY   Table Relationship Diagram
Short Description Structure for CIS Vendor verification - Vendor Info    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 .INCLUDE       0   0   Extension Table for CIS Sub contractors  
2 MANDT MANDT MANDT CLNT 3   0   Client *
3 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
4 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
5 CATEG CIS_CATEGORY CIS_CATEGORY CHAR 12   0   Subcontractor's Business Type  
6 PARTNER_NAME CIS_PARTNER_NAME TEXT30 CHAR 30   0   Partner's Trading Name  
7 PARTNER_UTR CIS_PARTNER_UTR CHAR20 CHAR 20   0   Partner's Unique Tax Reference (UTR)  
8 STATUS CIS_VFNSTATUS CIS_VFNSTATUS CHAR 3   0   Verification Status  
9 VFNUM GB_CIS_SC_VFNNUM CHAR20 CHAR 20   0   Verification Number  
10 VFNID CIS_VFN_ID CIS_VFN_ID CHAR 1   0   Tax Status of the Verified Subcontractor  
11 .INCLUDE       0   0   Partner level additional data captured for WT UK  
12 GB_CIS_SC_TRDNM GB_CIS_SC_TRDNM CHAR64 CHAR 64   0   Subcontractor's Trading Name  
13 GB_CIS_SC_FSNM GB_CIS_SC_FSNM CHAR64 CHAR 64   0   Subcontractor's First Name  
14 GB_CIS_SC_SCNM GB_CIS_SC_SCNM CHAR64 CHAR 64   0   Subcontractor's Second Name  
15 GB_CIS_SC_INTL GB_CIS_SC_INTL CHAR64 CHAR 64   0   Subcontractor's Last Name  
16 GB_CIS_SC_VFNNUM GB_CIS_SC_VFNNUM CHAR20 CHAR 20   0   Verification Number  
17 GB_CIS_SC_UTR GB_CIS_SC_UTR CHAR20 CHAR 20   0   Subcontractor's Unique Tax Reference (UTR)  
18 GB_CIS_SC_VFNSTS GB_CIS_SC_VFNSTS CHAR1 CHAR 1   0   Sub contractor verification status  
19 GB_CIS_SCNUM NUM6 NUM06 NUMC 6   0   Numerical Character Field of Length 6  
20 .INCLUDE       0   0   Address of Company, Business Place, and Vendor or Customer  
21 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
22 .INCLUDE       0   0   Address transfer structure  
23 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
24 DATE_TO AD_DATE_TO DATUM DATS 8   0   Valid-to date in current Release only 99991231 possible  
25 .INCLUDE       0   0   Include structure with name attributes of the ADRC address  
26 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
27 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
28 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
29 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
30 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
31 NAME_TXT AD_NAMETXT TEXT50 CHAR 50   0   Converted name field (with form of address)  
32 .INCLUDE       0   0   Include structure with ADRC attributes without name fields  
33 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
34 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
35 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
36 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file ADRCITY
37 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file ADRCITYPRT
38 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
39 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file ADRCITY
40 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
41 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
42 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
43 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
44 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
45 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
46 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
47 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
48 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
49 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag TSAD12
50 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
51 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
52 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) ADRCITY
53 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
54 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
55 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
56 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
57 STREET AD_STREET TEXT60 CHAR 60   0   Street  
58 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag TSAD12
59 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File ADRSTREET
60 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
61 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
62 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
63 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
64 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
65 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
66 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
67 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
68 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
69 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
70 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
71 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
72 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
73 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
74 SORT1 AD_SORT1UL TEXT20 CHAR 20   0   Search Term 1  
75 SORT2 AD_SORT2UL TEXT20 CHAR 20   0   Search Term 2  
76 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
77 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key) TSAD6
78 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
79 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
80 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
81 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
82 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
83 REMARK AD_REMARK1 TEXT50 CHAR 50   0   Address notes  
84 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language T002
85 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
86 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service ADDRC_DELI_SERV
87 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
88 COUNTY_CODE AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county ADRCOUNTY
89 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
90 TOWNSHIP_CODE AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township ADRTOWNSHIP
91 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
92 DEFLT_COMM AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) TSAC
93 LANDX LANDX TEXT15 CHAR 15   0   Country Name  
94 NATIO NATIO TEXT15 CHAR 15   0   Nationality  
95 BEZEI AD_REGION TEXT20 CHAR 20   0   Region  
96 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
97 SC_CRN STCD1 STCD1 CHAR 16   0   Tax Number 1  
98 SC_NINO STCD2 STCD2 CHAR 11   0   Tax Number 2  
99 ACTION CIS_ACTION CIS_ACTION CHAR 10   0   Action Type  
100 SC_WORKSREF PARTNERNO   CHAR 35   0   Partner ID  
101 SC_EXTRA01 WT_EXTRA CHAR50 CHAR 50   0   CHAR 50 WITH LOWER CASE  
102 SC_EXTRA02 WT_EXTRA CHAR50 CHAR 50   0   CHAR 50 WITH LOWER CASE  
103 SC_EXTRA03 WT_EXTRA CHAR50 CHAR 50   0   CHAR 50 WITH LOWER CASE  
104 SC_EXTRA04 WT_EXTRA CHAR50 CHAR 50   0   CHAR 50 WITH LOWER CASE  
105 SC_EXTRA05 WT_EXTRA CHAR50 CHAR 50   0   CHAR 50 WITH LOWER CASE  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CIS_VERIFY ADDRORIGIN TSAD6 ORIGIN REF C CN
2 CIS_VERIFY CITYH_CODE ADRCITY CITY_CODE REF C CN
3 CIS_VERIFY CITYP_CODE ADRCITYPRT CITYP_CODE REF C CN
4 CIS_VERIFY CITY_CODE ADRCITY CITY_CODE REF C CN
5 CIS_VERIFY CITY_CODE2 ADRCITY CITY_CODE REF C CN
6 CIS_VERIFY COUNTRY T005 LAND1 REF C CN
7 CIS_VERIFY COUNTY_CODE ADRCOUNTY COUNTY_CODE REF C CN
8 CIS_VERIFY DEFLT_COMM TSAC COMM_TYPE REF C CN
9 CIS_VERIFY DELI_SERV_TYPE ADDRC_DELI_SERV DELI_SERV_TYPE 1 CN
10 CIS_VERIFY DONT_USE_P TSAD12 UNDELIVER KEY C CN
11 CIS_VERIFY DONT_USE_S TSAD12 UNDELIVER REF C CN
12 CIS_VERIFY LANGU T002 SPRAS REF C CN
13 CIS_VERIFY LANGU_CREA T002 SPRAS REF C CN
14 CIS_VERIFY PO_BOX_CTY T005 LAND1 REF C CN
15 CIS_VERIFY PO_BOX_REG T005S BLAND REF C CN
16 CIS_VERIFY REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
17 CIS_VERIFY REGION T005S BLAND REF C CN
18 CIS_VERIFY STREETABBR ADRSTRTYPE STRTYPEAB REF C CN
19 CIS_VERIFY STREETCODE ADRSTREET STRT_CODE REF C CN
20 CIS_VERIFY TIME_ZONE TTZZ TZONE REF C CN
21 CIS_VERIFY TITLE TSAD3 TITLE REF C CN
22 CIS_VERIFY TOWNSHIP_CODE ADRTOWNSHIP TOWNSHIP_CODE REF C CN
23 CIS_VERIFY TRANSPZONE TZONE ZONE1 REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in