SAP Table CIS_VF_EXT

Extension Table for CIS Sub contractors

CIS_VF_EXT (Extension Table for CIS Sub contractors) 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_VF_EXT to other SAP tables.

CIS_VF_EXT 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