SAP ABAP Table JKTWBZIN (IS-M/SD: Clipboard for WBZ Records for Processing)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JKTWBZIN	Table Relationship Diagram
Short Description	IS-M/SD: Clipboard for WBZ Records for Processing

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	T000
2	RZNR	☑	JWBZRZNR	JWBZRZNR	CHAR	2	0	IS-M: WBZ, Computer Center Number	TJKW0
3	DATUM	☑	JWBZDATUM	SYDATS	DATS	8	0	IS-M: Date in file name of WBZ file
4	FILE_IN	☑	FILEINTERN	FILEINTERN	CHAR	60	0	Logical file name	FILENAMECI
5	ZAEHLER	☑	JFILE_CNT	NUM8	NUMC	8	0	IS-M: Consecutive Counter for Transfer of External Data
6	STATUS	☐	JWBZSTAT	JWBZSTAT	CHAR	2	0	IS-M: Status of data record in WBZ inbound file
7	XFLGDIALOG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
8	VBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
9	POSNR	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
10	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
11	.INCLUDE	☐				0	0	IS-M: Message Data
12	MSGID	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
13	MSGNO	☐	SYMSGNO	SYMSGNO	NUMC	3	0	Message Number
14	MSGTY	☐	SYMSGTY	SYCHAR01	CHAR	1	0	Message Type
15	.INCLUDE	☐				0	0	IS-M: Message Variables
16	MSGV1	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
17	MSGV2	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
18	MSGV3	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
19	MSGV4	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
20	.INCLUDE	☐				0	0	IS-M/SD: Data Structure for WBZ (All Fields)
21	WBZSATZART	☐	JWBZSTZART	JWBZSTZART	CHAR	3	0	IS-M: WBZ, Record Type	TJKW1
22	VERLAGSNR	☐	JWBZVRLGNR	JWBZVRLGNR	CHAR	5	0	IS-M: VDZ Publisher Number
23	WBZKUNNR	☐	JWBZKUNNR	JWBZKUNNR	CHAR	6	0	IS-M: WBZ, VDZ Number of WBZ Company
24	VERTRKENNZ	☐	JWBZVKENNZ	JWBZVKENNZ	CHAR	5	0	IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code)	TJKWE
25	RECHZENTNR	☐	JWBZRZNR	JWBZRZNR	CHAR	2	0	IS-M: WBZ, Computer Center Number	TJKW0
26	WBZVORGART	☐	JWBZVORART	JWBZVORART	CHAR	3	0	IS-M: WBZ, Operation Type	TJKW3
27	ABONR	☐	JWBZABONR	JWBZABONR	CHAR	12	0	IS-M: WBZ, Subscription Number
28	WBZTERMIN	☐	JWBZTERMIN	CHAR9	CHAR	9	0	IS-M: WBZ, Date (Format: MMYYYYCCCC)
29	EXEMPLARE	☐	JWBZEXEMPL	JWBZEXEMPL	NUMC	2	0	IS-M: WBZ, Number of Copies
30	HEFTANZAHL	☐	JWBZHFTANZ	CHAR02	CHAR	2	0	IS-M: WBZ, Number of Copies
31	ABOART	☐	JWBZABOART	CHAR03	CHAR	3	0	IS-M: WBZ, Subscriber Type
32	WERBKZSCHL	☐	JWBZWKZSCH	JWBZWKZSCH	CHAR	1	0	IS-M: WBZ, Promotion Rebate Key	TJKW9
33	WERBKZBETR	☐	JWBZWKZBTR	JCHAR5	CHAR	5	0	IS-M: WBZ, Promotion Rebate Amount
34	PLZ	☐	JWBZPLZ	CHAR08	CHAR	8	0	IS-M: WBZ, Postal Code
35	FILLER_15	☐	JWBZFELD15	CHAR03	CHAR	3	0	IS-M: WBZ, data transfer structure field 15 (remains blank)
36	LAND	☐	LANDK	LANDK	CHAR	3	0	Vehicle country key
37	ANREDE	☐	JWBZANREDE	JWBZANREDE	CHAR	1	0	IS-M: WBZ, Form-of-Address Key	TJKW5
38	NAME	☐	JWBZNAME	TEXT30	CHAR	30	0	IS-M: WBZ, Last and First Name
39	ANSCHZUS	☐	JWBZANSZUS	TEXT30	CHAR	30	0	IS-M: WBZ, Address Affix
40	ANSCHZUSKZ	☐	JWBZANSZKZ	JWBZANSZKZ	CHAR	1	0	IS-M: WBZ, indicator for address affix
41	STRASSE	☐	JWBZSTRASS	TEXT30	CHAR	30	0	IS-M: WBZ, street
42	ORT	☐	JWBZORT	TEXT25	CHAR	25	0	IS-M: WBZ, city
43	VERSANDART	☐	JWBZVSART	JWBZVSART	CHAR	2	0	IS-M: WBZ, Shipping Type
44	VERTRETER	☐	JWBZVERTR	CHAR07	CHAR	7	0	IS-M: WBZ, representative indicator
45	FEHLERNR	☐	JWBZFEHLNR	JWBZFEHLNR	CHAR	3	0	IS-M: WBZ, error number	TJKW7
46	JAHR_HEFT	☐	JWBZJHRHFT	CHAR07	CHAR	7	0	IS-M: Year and Copy Number
47	FILLER_27	☐	CHAR05	CHAR005	CHAR	5	0	Character Field with Length 5
48	VERTRBEGIN	☐	JWBZVERTBG	JWBZVERTBG	CHAR	6	0	IS-M: WBZ, Contract Date (DDMMYY)
49	PLZ_NEU	☐	JWBZPLZNEU	JCHAR5	CHAR	5	0	IS-M: WBZ, new postal code (to July 1st 1994)
50	WBZABOKUNR	☐	JWBZABOKNR	JWBZABOKNR	CHAR	9	0	IS-M: Subscription Customer Number
51	FILLER_31	☐	CHAR007	CHAR07	CHAR	7	0	IS-M: Character Field 7 Chars in Length
52	AKTION	☐	JWBZAKTION	JWBZAKTION	NUMC	3	0	IS-M/SD: WBZ, Sales Promotion/Condition Key
53	ANZ_MONATE	☐	JWBZANZ_MONATE	JWBZANZ_MONATE	NUMC	3	0	IS-M/SD: WBZ, Number of Months for Scaled Promotion Rebate
54	WBZTERMIN_2	☐	JWBZTERMIN_2	JWBZTERMIN_2	NUMC	7	0	IS-M/SD: WBZ, Second Date Field (YYYYNNN)
55	NAMENSZUSATZ	☐	JWBZNAMENSZUSATZ	JWBZNAMENSZUSATZ	CHAR	30	0	IS-M/SD: WBZ, Name Affix
56	WAEHRUNG	☐	JWBZWAEHRUNG	JWBZWAEHRUNG	CHAR	3	0	IS-M/SD: WBZ, Currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKTWBZIN	ANREDE	TJKW5	ANREDE		1	CN
2	JKTWBZIN	FEHLERNR	TJKW7	FEHLERNR		1	CN
3	JKTWBZIN	FILE_IN	FILENAMECI	FILEINTERN	KEY	1	CN
4	JKTWBZIN	MANDT	T000	MANDT	KEY	1	CN
5	JKTWBZIN	POSNR	JKAP	POSNR	REF	C	C
6	JKTWBZIN	RECHZENTNR	TJKW0	RECHZENTNR		1	CN
7	JKTWBZIN	RZNR	TJKW0	RECHZENTNR	KEY	1	CN
8	JKTWBZIN	VBELN	JKAK	VBELN	REF	C	C
9	JKTWBZIN	VERTRKENNZ	TJKWE	VERTRKENNZ		1	CN
10	JKTWBZIN	WBZSATZART	TJKW1	SATZART	KEY	1	CN
11	JKTWBZIN	WBZVORGART	TJKW3	VORGANGART	KEY	1	CN
12	JKTWBZIN	WERBKZSCHL	TJKW9	WERBKZSCHL		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in