SAP Table IDWTPARTNER
Withholding Tax Type, Code, and Vendor/Customer Master Data
IDWTPARTNER (Withholding Tax Type, Code, and Vendor/Customer Master Data) 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 IDWTPARTNER to other SAP tables.
IDWTPARTNER table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||
|
PARTNO_TYPE
Type of partner number
|
WT_PARTNO_TYPE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
PARTNERNO
Partner ID
|
PARTNERNO |
CHAR
|
35 | 0 | ||||||||||
|
WT_PERIOD
Reporting Period
|
WT_REPPERIOD |
NUMC
|
2 | 0 | ||||||||||
|
MONA
Posting date calendar month
|
BUMON |
NUMC
|
2 | 0 | ||||||||||
|
WITHT
Indicator for withholding tax type
|
WITHT |
CHAR
|
2 | 0 | ||||||||||
|
WT_WITHCD
Withholding tax code
|
WT_WITHCD |
CHAR
|
2 | 0 | ||||||||||
|
QLAND
Withholding Tax Country Key
|
QLAND |
CHAR
|
3 | 0 | ||||||||||
|
QLTXT
Country for the Withholding Tax
|
WT_QLTXT |
CHAR
|
30 | 0 | ||||||||||
|
LIFNR
Account Number of Vendor or Creditor
|
LIFNR |
CHAR
|
10 | 0 | ||||||||||
|
KUNNR
Customer Number
|
KUNNR |
CHAR
|
10 | 0 | ||||||||||
|
PARTNER_SEQ_NB
Partner sequential number on Withholding Tax lists
|
PARTNER_SEQ_NB |
NUMC
|
6 | 0 | ||||||||||
|
TEXT40
Description of Withholding tax type for Ext. WT
|
WT_TYPE_DESC |
CHAR
|
40 | 0 | ||||||||||
|
WT_TYPECODE_TEXT
Description of Wth/Tax Type + code for Ext. WT
|
WT_TYPE_CODE_DESC |
CHAR
|
40 | 0 | ||||||||||
|
QSCOD
Official Withholding Tax Key
|
WT_OWTCD |
CHAR
|
4 | 0 | ||||||||||
|
WT_OFFWT_TEXT
Text of the Official Withholding Tax Code
|
WT_OFFWT_TEXT |
CHAR
|
40 | 0 | ||||||||||
|
TAX_REGION
Tax Region Code for Withholding Tax Code
|
TAX_REGIO |
CHAR
|
3 | 0 | ||||||||||
|
TAX_REGION_NUM
Official numerical state code
|
WT_REGIO_NUM |
CHAR
|
3 | 0 | ||||||||||
|
TAX_REGION_TXT
Tax Region Name for Wtihholding Tax Code
|
TAX_REGION_TXT |
CHAR
|
20 | 0 | ||||||||||
|
CTNUMBER
Withholding Tax Certificate Number
|
CTNUMBER |
CHAR
|
10 | 0 | ||||||||||
|
WT_POSTM
Posting time
|
WT_POSTM |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
WT_POSIN
Posting indicator
|
WT_POSIN |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
FPRCD
Provincial tax code
|
FPRCD |
CHAR
|
3 | 0 | ||||||||||
|
QEKAR
Income Type
|
QEKAR |
CHAR
|
4 | 0 | ||||||||||
|
EATXT
Description of the income type
|
WT_INCOME_TYPE_DESC |
CHAR
|
40 | 0 | ||||||||||
|
XQFOR
Indicator: Calculate withholding tax according to formula?
|
XQFOR |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
QPROZ
Percentage Subject to Withholding Tax
|
QPROZ |
DEC
|
5 | 2 | ||||||||||
|
QSATZ
Withholding tax rate
|
WT_QSATZ |
DEC
|
7 | 4 | ||||||||||
|
QSATR
Reduced withholding tax rate
|
WT_QSATR |
DEC
|
7 | 4 | ||||||||||
|
SORTL
Sort field
|
SORTL |
CHAR
|
10 | 0 | ||||||||||
|
SPRAS
Language Key
|
SPRAS |
LANG
|
1 | 0 | ||||||||||
|
BRSCH
Industry key
|
BRSCH |
CHAR
|
4 | 0 | ||||||||||
|
STCD1
Tax Number 1
|
STCD1 |
CHAR
|
16 | 0 | ||||||||||
|
STCD2
Tax Number 2
|
STCD2 |
CHAR
|
11 | 0 | ||||||||||
|
STCD3
Tax Number 3
|
STCD3 |
CHAR
|
18 | 0 | ||||||||||
|
STCD4
Tax Number 4
|
STCD4 |
CHAR
|
18 | 0 | ||||||||||
|
GBDAT
Date of birth of the person subject to withholding tax
|
GBDAT_Q |
DATS
|
8 | 0 | ||||||||||
|
GBORT
Place of birth of the person subject to withholding tax
|
GBORT_Q |
CHAR
|
25 | 0 | ||||||||||
|
SEXKZ
Key for the Sex of the Person Subject to Withholding Tax
|
SEXKZ |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
STKZN
Natural Person
|
STKZN |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
STKZU
Liable for VAT
|
STKZU |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
VBUND
Company ID of trading partner
|
RASSC |
CHAR
|
6 | 0 | ||||||||||
|
STCEG
VAT Registration Number
|
STCEG |
CHAR
|
20 | 0 | ||||||||||
|
TXJCD
Tax Jurisdiction
|
TXJCD |
CHAR
|
15 | 0 | ||||||||||
|
WERKS
Plant
|
WERKS_D |
CHAR
|
4 | 0 | ||||||||||
|
DTAMS
Indicator for Data Medium Exchange
|
DTAMS |
CHAR
|
1 | 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 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
WT_SHORT_ADDR
One-line short form of formatted address
|
AD_LINE_S |
CHAR
|
80 | 0 | ||||||||||
|
FITYP
Tax type
|
J_1AFITP_D |
CHAR
|
2 | 0 | ||||||||||
|
STCDT
Tax Number Type
|
J_1ATOID |
CHAR
|
2 | 0 | ||||||||||
|
KUKLA
Customer classification
|
KUKLA |
CHAR
|
2 | 0 | ||||||||||
|
BAHNS
Train station
|
BAHNS |
CHAR
|
25 | 0 | ||||||||||
|
J_1KFREPRE
Name of Representative
|
REPRES |
CHAR
|
10 | 0 | ||||||||||
|
J_1KFTBUS
Type of Business
|
GESTYP |
CHAR
|
30 | 0 | ||||||||||
|
J_1KFTIND
Type of Industry
|
INDTYP |
CHAR
|
30 | 0 | ||||||||||
|
QSREC
Vendor Recipient Type
|
QSREC |
CHAR
|
2 | 0 | ||||||||||
|
WT_WTSTCD
Withholding tax identification number
|
WT_WTSTCD |
CHAR
|
16 | 0 | ||||||||||
|
WT_EXNR
Exemption certificate number
|
WT_EXNR |
CHAR
|
15 | 0 | ||||||||||
|
WT_EXRT
Exemption rate
|
WT_EXRT |
DEC
|
5 | 2 | ||||||||||
|
WT_EXDF
Date on which exemption begins
|
WT_EXDF |
DATS
|
8 | 0 | ||||||||||
|
WT_EXDT
Date on which exemption ends
|
WT_EXDT |
DATS
|
8 | 0 | ||||||||||
|
WT_WTEXRS
Reason for exemption
|
WT_WTEXRS |
CHAR
|
2 | 0 | ||||||||||
|
WT_WTAGT
Indicator: Withholding tax agent?
|
WT_WTAGT |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
WT_AGTDF
Obligated to withhold tax from
|
WT_AGTDF |
DATS
|
8 | 0 | ||||||||||
|
WT_AGTDT
Obligated to withhold tax until
|
WT_AGTDT |
DATS
|
8 | 0 | ||||||||||
|
QSZNR
Certificate Number of the Withholding Tax Exemption (old WT)
|
WT_QSZNR |
CHAR
|
10 | 0 | ||||||||||
|
QSZDT
Validity Date for Wth/Tax Exemption Certificate (old WT)
|
WT_QSZDT |
DATS
|
8 | 0 | ||||||||||
|
HBKID
Short Key for a House Bank
|
HBKID |
CHAR
|
5 | 0 | ||||||||||
|
COUNC
County Code
|
COUNC |
CHAR
|
3 | 0 | ||||||||||
|
CITYC
City Code
|
CITYC |
CHAR
|
4 | 0 | ||||||||||
|
RPMKR
Regional Market
|
RPMKR |
CHAR
|
5 | 0 | ||||||||||
|
GFORM
Legal status
|
GFORM |
CHAR
|
2 | 0 | ||||||||||
|
NIELS
Nielsen ID
|
NIELS |
CHAR
|
2 | 0 | ||||||||||
|
HWAER
Reporting currency ( local or alternative )
|
WT_HWAER |
CUKY
|
5 | 0 | ||||||||||
|
WT_GROUP1
Grouping criterion
|
WT_GROUP |
CHAR
|
10 | 0 | ||||||||||
|
DMBTR
Gross amount in Reporting Currency
|
WT_DMBTR |
CURR
|
15 | 2 | ||||||||||
|
WT_QSSHH
Withholding Tax Base Amount in Reporting Currency
|
WT_BASE_AMT |
CURR
|
15 | 2 | ||||||||||
|
WT_QBSHH
Withholding Tax Amount in Reporting Currency
|
WT_TAX_AMT |
CURR
|
15 | 2 | ||||||||||
|
WT_QSFHH
Amount exempt from withholding tax (in reporting currency)
|
WT_EXMP_AMT |
CURR
|
15 | 2 | ||||||||||
|
WT_TAXHH
Tax Amount in Reporting Currency
|
WT_HWSTE |
CURR
|
15 | 2 | ||||||||||
|
WT_AMEXCLVAT
Net amount 2 = Invoice amount - VAT ( in Reporting currency)
|
WT_EXCLVAT |
CURR
|
15 | 2 | ||||||||||
|
WT_AMRBASE
WT base amount excluding taxes ( in reporting currency)
|
WT_RBASE |
CURR
|
15 | 2 | ||||||||||
|
WT_AMREXMP
Amount Exempt from WH Tax - VAT (in Reporting Currency)
|
WT_REXMP |
CURR
|
15 | 2 | ||||||||||
|
SKNTO
Cash discount amount in local currency
|
WT_SKNTO |
CURR
|
15 | 2 | ||||||||||
|
PROFS
Profession
|
PROFS |
CHAR
|
30 | 0 | ||||||||||
|
CIIU
Economic Code Activity
|
CIIU |
CHAR
|
16 | 0 | ||||||||||
|
ADDITIONAL_INFO
Additional Vendor information
|
ADDITIONAL_INFO |
CHAR
|
1 | 0 | ||||||||||
|
BUPLA
Business Place
|
BUPLA |
CHAR
|
4 | 0 | ||||||||||
|
ALT_PAYEE
Partner ID
|
PARTNERNO |
CHAR
|
35 | 0 | ||||||||||
|
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 | ||||||||||
|
BE_BA_5060
Minimum Base Amount
|
BE_MINBASE |
CURR
|
13 | 2 | ||||||||||
|
BE_BA_5061
Minimum Base Amount
|
BE_MINBASE |
CURR
|
13 | 2 | ||||||||||
|
BE_BA_5062
Minimum Base Amount
|
BE_MINBASE |
CURR
|
13 | 2 | ||||||||||
|
BE_BA_5063
Minimum Base Amount
|
BE_MINBASE |
CURR
|
13 | 2 | ||||||||||
|
BE_CO_TOTAL
Minimum Base Amount
|
BE_MINBASE |
CURR
|
13 | 2 | ||||||||||
|
STENR
Tax Number at Responsible Tax Authority
|
STENR |
CHAR
|
18 | 0 | ||||||||||
|
KVERM
Memo
|
KVERM |
CHAR
|
30 | 0 | ||||||||||
|
BE_NIHIL
Payment Indicator - Fiche- Belgium
|
BE_NIHIL |
CHAR
|
1 | 0 | ||||||||||
|
KR_QSREC
Vendor Recipient Type
|
KR_QSREC |
CHAR
|
6 | 0 | ||||||||||
|
IE_CONTRACT_ID
Contract identifier from Tax Authority
|
IE_CONTRACT_ID |
INT4
|
10 | 0 | ||||||||||
|
IE_AMNT_UNDECL
Amount Undeclared
|
IE_AMNT_UNDECL |
CURR
|
13 | 2 | ||||||||||
|
IE_LST_PRTNR
Last Partner Flag
|
IE_LST_PRTNR |
CHAR
|
1 | 0 | ||||||||||
|
US_1099K_TRANS
Number of transactions-1099K
|
US_1099K_TRANS |
INT4
|
10 | 0 | ||||||||||
IDWTPARTNER foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| IDWTPARTNER | ADDRORIGIN | IDWTPARTNER | ADDRORIGIN |
TSAD6
Source Address or Personal Data (Business Address Services)
|
ORIGIN |
| IDWTPARTNER | ADDRORIGIN | * |
TSAD6
Source Address or Personal Data (Business Address Services)
|
CLIENT | |
| IDWTPARTNER | BUKRS | SYST | MANDT |
T001
Company Codes
|
MANDT |
| IDWTPARTNER | BUKRS | IDWTPARTNER | BUKRS |
T001
Company Codes
|
BUKRS |
| IDWTPARTNER | CITYH_CODE | * |
ADRCITY
Postal cities
|
CLIENT | |
| IDWTPARTNER | CITYH_CODE | IDWTPARTNER | COUNTRY |
ADRCITY
Postal cities
|
COUNTRY |
| IDWTPARTNER | CITYH_CODE | IDWTPARTNER | CITYH_CODE |
ADRCITY
Postal cities
|
CITY_CODE |
| IDWTPARTNER | CITYP_CODE | * |
ADRCITYPRT
Postal districts
|
CLIENT | |
| IDWTPARTNER | CITYP_CODE | IDWTPARTNER | COUNTRY |
ADRCITYPRT
Postal districts
|
COUNTRY |
| IDWTPARTNER | CITYP_CODE | IDWTPARTNER | CITY_CODE |
ADRCITYPRT
Postal districts
|
CITY_CODE |
| IDWTPARTNER | CITYP_CODE | IDWTPARTNER | CITYP_CODE |
ADRCITYPRT
Postal districts
|
CITYP_CODE |
| IDWTPARTNER | CITY_CODE | IDWTPARTNER | COUNTRY |
ADRCITY
Postal cities
|
COUNTRY |
| IDWTPARTNER | CITY_CODE | IDWTPARTNER | CITY_CODE |
ADRCITY
Postal cities
|
CITY_CODE |
| IDWTPARTNER | CITY_CODE | * |
ADRCITY
Postal cities
|
CLIENT | |
| IDWTPARTNER | CITY_CODE2 | * |
ADRCITY
Postal cities
|
CLIENT | |
| IDWTPARTNER | CITY_CODE2 | IDWTPARTNER | COUNTRY |
ADRCITY
Postal cities
|
COUNTRY |
| IDWTPARTNER | CITY_CODE2 | IDWTPARTNER | CITY_CODE2 |
ADRCITY
Postal cities
|
CITY_CODE |
| IDWTPARTNER | COUNTRY | * |
T005
Countries
|
MANDT | |
| IDWTPARTNER | COUNTRY | IDWTPARTNER | COUNTRY |
T005
Countries
|
LAND1 |
| IDWTPARTNER | COUNTY_CODE | IDWTPARTNER | PO_BOX_CTY |
ADRCOUNTY
County codes
|
COUNTRY |
| IDWTPARTNER | COUNTY_CODE | IDWTPARTNER | PO_BOX_REG |
ADRCOUNTY
County codes
|
REGION |
| IDWTPARTNER | COUNTY_CODE | IDWTPARTNER | COUNTY_CODE |
ADRCOUNTY
County codes
|
COUNTY_CODE |
| IDWTPARTNER | COUNTY_CODE | SYST | MANDT |
ADRCOUNTY
County codes
|
CLIENT |
| IDWTPARTNER | DEFLT_COMM | IDWTPARTNER | DEFLT_COMM |
TSAC
Communication Methods (Business Address Services)
|
COMM_TYPE |
| IDWTPARTNER | DELI_SERV_TYPE | SYST | MANDT |
ADDRC_DELI_SERV
Address Service Types
|
CLIENT |
| IDWTPARTNER | DELI_SERV_TYPE | IDWTPARTNER | DELI_SERV_TYPE |
ADDRC_DELI_SERV
Address Service Types
|
DELI_SERV_TYPE |
| IDWTPARTNER | DONT_USE_P | IDWTPARTNER | DONT_USE_P |
TSAD12
Reasons for Non-Delivery (Business Address Services)
|
UNDELIVER |
| IDWTPARTNER | DONT_USE_P | SYST | MANDT |
TSAD12
Reasons for Non-Delivery (Business Address Services)
|
CLIENT |
| IDWTPARTNER | DONT_USE_S | SYST | MANDT |
TSAD12
Reasons for Non-Delivery (Business Address Services)
|
CLIENT |
| IDWTPARTNER | DONT_USE_S | IDWTPARTNER | DONT_USE_S |
TSAD12
Reasons for Non-Delivery (Business Address Services)
|
UNDELIVER |
| IDWTPARTNER | LANGU | IDWTPARTNER | LANGU |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| IDWTPARTNER | LANGU_CREA | IDWTPARTNER | LANGU_CREA |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| IDWTPARTNER | PO_BOX_CTY | * |
T005
Countries
|
MANDT | |
| IDWTPARTNER | PO_BOX_CTY | IDWTPARTNER | PO_BOX_CTY |
T005
Countries
|
LAND1 |
| IDWTPARTNER | PO_BOX_REG | * |
T005S
Taxes: Region (Province) Key
|
MANDT | |
| IDWTPARTNER | PO_BOX_REG | IDWTPARTNER | PO_BOX_CTY |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| IDWTPARTNER | PO_BOX_REG | IDWTPARTNER | PO_BOX_REG |
T005S
Taxes: Region (Province) Key
|
BLAND |
| IDWTPARTNER | REGIOGROUP | * |
ADRREGGRP
Regional structure grouping
|
CLIENT | |
| IDWTPARTNER | REGIOGROUP | IDWTPARTNER | REGIOGROUP |
ADRREGGRP
Regional structure grouping
|
REGIOGROUP |
| IDWTPARTNER | REGION | * |
T005S
Taxes: Region (Province) Key
|
MANDT | |
| IDWTPARTNER | REGION | IDWTPARTNER | COUNTRY |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| IDWTPARTNER | REGION | IDWTPARTNER | REGION |
T005S
Taxes: Region (Province) Key
|
BLAND |
| IDWTPARTNER | STREETABBR | * |
ADRSTRTYPE
Street type
|
CLIENT | |
| IDWTPARTNER | STREETABBR | IDWTPARTNER | COUNTRY |
ADRSTRTYPE
Street type
|
COUNTRY |
| IDWTPARTNER | STREETABBR | IDWTPARTNER | STREETABBR |
ADRSTRTYPE
Street type
|
STRTYPEAB |
| IDWTPARTNER | STREETCODE | IDWTPARTNER | COUNTRY |
ADRSTREET
Streets
|
COUNTRY |
| IDWTPARTNER | STREETCODE | IDWTPARTNER | STREETCODE |
ADRSTREET
Streets
|
STRT_CODE |
| IDWTPARTNER | STREETCODE | * |
ADRSTREET
Streets
|
CLIENT | |
| IDWTPARTNER | TIME_ZONE | * |
TTZZ
Time zones
|
CLIENT | |
| IDWTPARTNER | TIME_ZONE | IDWTPARTNER | TIME_ZONE |
TTZZ
Time zones
|
TZONE |
| IDWTPARTNER | TITLE | * |
TSAD3
Forms of Address (Key) (Business Address Services)
|
CLIENT | |
| IDWTPARTNER | TITLE | IDWTPARTNER | TITLE |
TSAD3
Forms of Address (Key) (Business Address Services)
|
TITLE |
| IDWTPARTNER | TOWNSHIP_CODE | SYST | MANDT |
ADRTOWNSHIP
Township codes
|
CLIENT |
| IDWTPARTNER | TOWNSHIP_CODE | IDWTPARTNER | PO_BOX_CTY |
ADRTOWNSHIP
Township codes
|
COUNTRY |
| IDWTPARTNER | TOWNSHIP_CODE | IDWTPARTNER | PO_BOX_REG |
ADRTOWNSHIP
Township codes
|
REGION |
| IDWTPARTNER | TOWNSHIP_CODE | IDWTPARTNER | COUNTY_CODE |
ADRTOWNSHIP
Township codes
|
COUNTY_CODE |
| IDWTPARTNER | TOWNSHIP_CODE | IDWTPARTNER | TOWNSHIP_CODE |
ADRTOWNSHIP
Township codes
|
TOWNSHIP_CODE |
| IDWTPARTNER | TRANSPZONE | IDWTPARTNER | TRANSPZONE |
TZONE
Customers: Regional zones
|
ZONE1 |
| IDWTPARTNER | TRANSPZONE | * |
TZONE
Customers: Regional zones
|
MANDT | |
| IDWTPARTNER | TRANSPZONE | IDWTPARTNER | COUNTRY |
TZONE
Customers: Regional zones
|
LAND1 |