SAP ABAP Table TXW_VENDOR (Vendor master)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FTW1 (Package) Data Retention Tool

Basic Data

Table Category	INTTAB	Structure
Structure	TXW_VENDOR	Table Relationship Diagram
Short Description	Vendor master

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
4	NAME1	☐	TXW_NAME1	TEXT40	CHAR	40	0	Name 1
5	NAME2	☐	TXW_NAME2	TEXT40	CHAR	40	0	Name 2
6	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
7	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
8	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
9	STRAS	☐	TXW_STRAS	TEXT60	CHAR	60	0	Street
10	ORT01	☐	TXW_ORT01	TEXT40	CHAR	40	0	City
11	ORT02	☐	TXW_ORT02	TEXT40	CHAR	40	0	District
12	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
13	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
14	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
15	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
16	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
17	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
18	XZEMP	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
19	LNRZB	☐	LNRZB	LIFNR	CHAR	10	0	Account number of the alternative payee	*
20	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	*
21	XVERR	☐	XVERR_LFB1	XFELD	CHAR	1	0	Indicator: Clearing between customer and vendor?
22	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
23	QSZNR	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
24	QSZDT	☐	QSZDT	DATUM	DATS	8	0	Validity Date for Withholding Tax Exemption Certificate
25	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
26	QSREC	☐	QSREC	QSREC	CHAR	2	0	Vendor Recipient Type	*
27	QSBGR	☐	QSBGR	QSBGR	CHAR	1	0	Authority for Exemption from Withholding Tax
28	QLAND	☐	QLAND	QLAND	CHAR	3	0	Withholding Tax Country Key	*
29	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
30	LNRZE	☐	LNRZE	LIFNR	CHAR	10	0	Head office account number	*
31	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
32	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*
33	KTOKK	☐	KTOKK	KTOKK	CHAR	4	0	Vendor account group	*
34	MINDK	☐	MINDK	MINDK	CHAR	3	0	Minority Indicators	*
35	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
36	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
37	.INCLUDE	☐				0	0
38	FISKU	☐	TXW_FISKU	LIFNR	CHAR	10	0	Tax Authority	*
39	STENR	☐	TXW_STENR	CHAR18	CHAR	18	0	Tax code
40	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
41	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
42	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
43	HOUSE_NUM1	☐	TXW_HSNM1	TEXT10	CHAR	10	0	House Number
44	HOUSE_NUM2	☐	TXW_HSNM2	TEXT10	CHAR	10	0	House number supplement
45	NAME3	☐	TXW_NAME3	TEXT40	CHAR	40	0	Name 3
46	NAME4	☐	TXW_NAME4	TEXT40	CHAR	40	0	Name 4

History

Last changed by/on	SAP	20130529
SAP Release Created in