SAP ABAP Table KUWEV (Ship-to Party's View of the Customer Master Record)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VZ (Package) Application development R/3 RV central functions

Basic Data

Table Category	INTTAB	Structure
Structure	KUWEV	Table Relationship Diagram
Short Description	Ship-to Party's View of the Customer Master Record

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	KUNNR	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
2	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
3	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
4	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
5	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
6	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
7	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
8	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
9	LAND1	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
10	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
11	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
12	BAHNE	☐	BAHNE	BAHNH	CHAR	25	0	Express train station
13	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
14	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
15	KNFAK	☐	KNFAK	WFCID	CHAR	2	0	Customer factory calendar	TFACD
16	WATSI	☐	TSIWE	TSTRID	CHAR	10	0	Time stream ID goods acceptance times	*
17	WANID	☐	WANID	WANID	CHAR	3	0	Goods receiving hours ID (default value)	TVWA
18	MOAB1	☐	WAMOAB1	UHRZT	TIMS	6	0	Goods receipt times: Monday morning from ...
19	MOBI1	☐	WAMOBI1	UHRZT	TIMS	6	0	Goods receiving hours: Monday morning until ...
20	MOAB2	☐	WAMOAB2	UHRZT	TIMS	6	0	Goods receiving hours: Monday afternoon from ...
21	MOBI2	☐	WAMOBI2	UHRZT	TIMS	6	0	Goods receiving hours: Monday afternoon until ...
22	DIAB1	☐	WADIAB1	UHRZT	TIMS	6	0	Goods receiving hours: Tuesday morning from...
23	DIBI1	☐	WADIBI1	UHRZT	TIMS	6	0	Goods receipt times: Tuesday morning until ...
24	DIAB2	☐	WADIAB2	UHRZT	TIMS	6	0	Goods receiving hours: Tuesday afternoon from ...
25	DIBI2	☐	WADIBI2	UHRZT	TIMS	6	0	Goods receiving hours: Tuesday afternoon until ...
26	MIAB1	☐	WAMIAB1	UHRZT	TIMS	6	0	Goods receiving hours: Wednesday morning from ...
27	MIBI1	☐	WAMIBI1	UHRZT	TIMS	6	0	Goods receiving hours: Wednesday morning until ...
28	MIAB2	☐	WAMIAB2	UHRZT	TIMS	6	0	Goods receiving hours: Wednesday afternoon from ...
29	MIBI2	☐	WAMIBI2	UHRZT	TIMS	6	0	Goods receiving hours: Wednesday afternoon until ...
30	DOAB1	☐	WADOAB1	UHRZT	TIMS	6	0	Goods receiving hours: Thursday morning from ...
31	DOBI1	☐	WADOBI1	UHRZT	TIMS	6	0	Goods receiving hours: Thursday morning until ...
32	DOAB2	☐	WADOAB2	UHRZT	TIMS	6	0	Goods receiving hours: Thursday afternoon from ...
33	DOBI2	☐	WADOBI2	UHRZT	TIMS	6	0	Goods receiving hours: Thursday afternoon until...
34	FRAB1	☐	WAFRAB1	UHRZT	TIMS	6	0	Goods receiving hours: Friday morning from ...
35	FRBI1	☐	WAFRBI1	UHRZT	TIMS	6	0	Goods receiving hours: Friday morning until ...
36	FRAB2	☐	WAFRAB2	UHRZT	TIMS	6	0	Goods receiving hours: Friday afternoon from ...
37	FRBI2	☐	WAFRBI2	UHRZT	TIMS	6	0	Goods receiving hours: Friday afternoon until ...
38	SAAB1	☐	WASAAB1	UHRZT	TIMS	6	0	Goods receiving hours: Saturday morning from ...
39	SABI1	☐	WASABI1	UHRZT	TIMS	6	0	Goods receiving hours: Saturday morning from ...
40	SAAB2	☐	WASAAB2	UHRZT	TIMS	6	0	Goods receiving hours: Saturday afternoon from ...
41	SABI2	☐	WASABI2	UHRZT	TIMS	6	0	Goods receiving hours: Saturday afternoon until ...
42	SOAB1	☐	WASOAB1	UHRZT	TIMS	6	0	Goods receiving hours: Sunday morning from ...
43	SOBI1	☐	WASOBI1	UHRZT	TIMS	6	0	Goods receiving hours: Sunday morning until ...
44	SOAB2	☐	WASOAB2	UHRZT	TIMS	6	0	Goods receiving hours: Sunday afternoon from ...
45	SOBI2	☐	WASOBI2	UHRZT	TIMS	6	0	Goods receiving hours: Sunday afternoon until ...
46	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
47	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer	*
48	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
49	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
50	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
51	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
52	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
53	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
54	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
55	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
56	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
57	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
58	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
59	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
60	STDOK	☐	STDOK	XFELD	CHAR	1	0	Control data sucessfully read from cust. master country seg.
61	DWERK	☐	DWERK	WERKS	CHAR	4	0	Delivering Plant	T001W
62	LIFSD	☐	LIFSD_V	LIFSP	CHAR	2	0	Customer delivery block (sales area)	TVLS
63	AUFSD	☐	AUFSD	KAUFS	CHAR	2	0	Customer blocked for orders	TVAST
64	VSORT	☐	VSORT	VBELN	CHAR	10	0	Item proposal	VBUK
65	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
66	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
67	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
68	KNREF	☐	KNREF	KNREF	CHAR	30	0	Customer description of partner (plant, storage location)
69	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
70	PRAT1	☐	KUAT1	PRATK	CHAR	1	0	ID for product attribute 1
71	PRAT2	☐	KUAT2	PRATK	CHAR	1	0	ID for product attribute 2
72	PRAT3	☐	KUAT3	PRATK	CHAR	1	0	ID for product attribute 3
73	PRAT4	☐	KUAT4	PRATK	CHAR	1	0	ID for product attribute 4
74	PRAT5	☐	KUAT5	PRATK	CHAR	1	0	ID for product attribute 5
75	PRAT6	☐	KUAT6	PRATK	CHAR	1	0	ID for product attribute 6
76	PRAT7	☐	KUAT7	PRATK	CHAR	1	0	ID for product attribute 7
77	PRAT8	☐	KUAT8	PRATK	CHAR	1	0	ID for product attribute 8
78	PRAT9	☐	KUAT9	PRATK	CHAR	1	0	ID for product attribute 9
79	PRATA	☐	KUATA	PRATK	CHAR	1	0	ID for product attribute 10
80	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
81	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
82	WERKS	☐	EMPFW	WERKS	CHAR	4	0	Receiving plant for deliveries	*
83	TXTPA	☐	TXTPA	TXTPA	CHAR	255	0	Display text for partners (name, city, country, street)
84	.INCLUDE	☐				0	0	Ship-to party view of the cust.master: Customer modification
85	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
86	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
87	ADDRESS_TYPE	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
88	DEAR5	☐	DEAR5	XFELD	CHAR	1	0	ID for default sold-to party
89	PODKZ	☐	PODKZ	XFELD	CHAR	1	0	Relevant for POD processing
90	PODTG	☐	PODTG	TSTRDURAG	DEC	11	0	Timeframe for Confirmation of POD

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KUWEV	AUFSD	TVAST	AUFSP
2	KUWEV	DWERK	T001W	WERKS
3	KUWEV	KNFAK	TFACD	IDENT
4	KUWEV	KUNNR	KNA1	KUNNR
5	KUWEV	LAND1	T005	LAND1
6	KUWEV	LIFSD	TVLS	LIFSP
7	KUWEV	LZONE	TZONE	ZONE1
8	KUWEV	PERIV	T009	PERIV
9	KUWEV	REGIO	T005S	BLAND
10	KUWEV	SPRAS	T002	SPRAS
11	KUWEV	TXJCD	TTXJ	TXJCD
12	KUWEV	VSBED	TVSB	VSBED
13	KUWEV	VSORT	VBUK	VBELN
14	KUWEV	WANID	TVWA	WANID

History

Last changed by/on	SAP	20130529
SAP Release Created in