SAP ABAP Table TXW_CUST_E1 (Customer master (extension))

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_CUST_E1	Table Relationship Diagram
Short Description	Customer master (extension)

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	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
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	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
9	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
10	STRAS	☐	TXW_STRAS	TEXT60	CHAR	60	0	Street
11	ORT01	☐	TXW_ORT01	TEXT40	CHAR	40	0	City
12	ORT02	☐	TXW_ORT02	TEXT40	CHAR	40	0	District
13	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
14	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
15	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
16	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
17	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
18	XZEMP	☐	XREGU	XFELD	CHAR	1	0	Indicator: Is an alternative payer allowed in document?
19	KNRZB	☐	KNRZB	KUNNR	CHAR	10	0	Account number of an alternative payer	*
20	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	*
21	XVERR	☐	XVERR_KNB1	XFELD	CHAR	1	0	Indicator: Clearing between customer and vendor ?
22	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
23	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
24	KNRZE	☐	KNRZE	KUNNR	CHAR	10	0	Head office account number (in branch accounts)	*
25	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
26	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*
27	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
28	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
29	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
30	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
31	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
32	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
33	HOUSE_NUM1	☐	TXW_HSNM1	TEXT10	CHAR	10	0	House Number
34	HOUSE_NUM2	☐	TXW_HSNM2	TEXT10	CHAR	10	0	House number supplement
35	NAME3	☐	TXW_NAME3	TEXT40	CHAR	40	0	Name 3
36	NAME4	☐	TXW_NAME4	TEXT40	CHAR	40	0	Name 4
37	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C