SAP ABAP Table KOMWBHPE (Trading Contract: External Database Transfer)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO (Application Component) Logistics - General
     ⤷ WB2B_DDIC (Package) Trading Contract: DDIC Objects Retained in AL0

Basic Data

Table Category	INTTAB	Structure
Structure	KOMWBHPE	Table Relationship Diagram
Short Description	Trading Contract: External Database Transfer

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	TKONN	☑	TKONN	TKONN	CHAR	10	0	Trading Contract: Trading Contract Number	*
2	TPOSN	☑	TPOSN	TPOSN	NUMC	6	0	Trading Contract: Item Number
3	TPOSN_SUB	☑	TPOSN_SUB	TPOSN	NUMC	6	0	Trading Contract: Sub-Item Number
4	OLDPO	☐	OLDPO_LF	NUMC6	NUMC	6	0	Document item of the reference document
5	PARVW	☑	PARVW	PARVW	CHAR	2	0	Partner Role	*
6	PARZA	☑	PARZA	PARZA	NUMC	3	0	Partner counter
7	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	LIFNR	☐	LIFN2	LIFNR	CHAR	10	0	Reference to other vendor	*
10	KUNNR	☐	KUNN2	KUNNR	CHAR	10	0	Customer number of business partner	*
11	DEFPA	☐	DEFPA	XFELD	CHAR	1	0	Default partner
12	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
13	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
14	.INCLUDE	☐				0	0	Address work area
15	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
16	ANRED	☐	ANRED_VP	ANRED	CHAR	15	0	Form of address
17	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
18	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
19	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
20	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
21	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
22	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
23	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
24	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
25	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
26	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
27	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
28	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
29	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
30	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
31	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
32	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
33	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
34	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
35	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
36	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
37	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
38	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
39	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
40	HAUSN	☐	HSNMR	NUMC6	NUMC	6	0	House Number
41	PARGE	☐	PARGE	GESCH	CHAR	1	0	Partner's gender
42	NAME_LIST	☐	NAME_LIST	NAME	CHAR	35	0	Name for list displays
43	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
44	ADRNP	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
45	ADDRESS_TYPE	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
46	DUEFL	☐	DUEFL_BAS	DUEFL_BAS	CHAR	1	0	Status of data transfer into subsequent release
47	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
48	STRS2	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
49	STRASNA	☐	STRAS_NA	TEXT35	CHAR	35	0	Street Name (Without House Number)
50	EMAIL_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
51	MOBNUM	☐	AD_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Telephone No.: Dialing Code + Number
52	ADDRESS_ORIGIN	☐	ADDR_ORIGIN	ADDR_ORIGIN	CHAR	1	0	Origin of an address
53	ADDR_LINK	☐	ADDR_LINK	AD_ADDRNUM	CHAR	10	0	Link to address number	*
54	REFOBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
55	REFOBJKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
56	REFLOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
57	P_NUMB_NEW	☐	KUNDE_D	KUNDE	CHAR	10	0	Partner number (KUNNR, LIFNR, or PERNR)
58	P_NUMB_OLD	☐	KUNDE_D	KUNDE	CHAR	10	0	Partner number (KUNNR, LIFNR, or PERNR)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KOMWBHPE	CITYC	T005G	CITYC
2	KOMWBHPE	COUNC	T005E	COUNC
3	KOMWBHPE	LAND1	T005	LAND1
4	KOMWBHPE	LZONE	TZONE	ZONE1
5	KOMWBHPE	REGIO	T005S	BLAND
6	KOMWBHPE	SPRAS	T002	SPRAS

History

Last changed by/on	SAP	20130529
SAP Release Created in