SAP ABAP Table JCBKANKEY (Canonical Key for Circulation Book)

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	INTTAB	Structure
Structure	JCBKANKEY	Table Relationship Diagram
Short Description	Canonical Key for Circulation Book

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	CIRC_ORIGIN	☐	J_CIRC_ORIGIN	J_CIRC_ORIGIN	CHAR	1	0	Technical data origin of circulation
2	ISSUE	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	*
3	PUBL_ORDER	☐	DRERZAUFTR	DRERZ	CHAR	8	0	Order Publication	*
4	EDITION_ORDER	☐	PVAAUFTR	PVA	CHAR	8	0	Order-related edition	*
5	DELIV_RETRN_DATE	☐	VERSREMIDAT	DATUM	DATS	8	0	Shipping date or return date of delivered/returned issues
6	DLVRYDOCTYPE	☐	LFNGART	LFNGART	CHAR	1	0	Type of Delivery
7	AUDITCAT	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	*
8	NRMLCOUNTRY	☐	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	*
9	CUKY_SDOC	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
10	MIXTYPE	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
11	BILLFREQ	☐	FKPER	FKPER	CHAR	2	0	Billing Frequency	*
12	PRICEPER	☐	PRSPER	PRSPER	CHAR	2	0	IS-M: Price Frequency	*
13	PRCGRPCUST	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	*
14	RATE_CODE	☐	RATE_CODE	RATE_CODE	CHAR	4	0	IS-M/SD: Rate Code	*
15	CT_SPRICE	☐	CTYPE_SPRICE	KSCHL	CHAR	4	0	Condition Type for Purchase Price	*
16	SUBS_PRICE	☐	JBEZPRS	CHAR13	CHAR	13	0	Purchase price
17	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
18	CUKY_SPRICE	☐	JCURRBEZPRS	WAERS	CUKY	5	0	Currency key for purchase price	*
19	CUST_GROUP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
20	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
21	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
22	PYMT_METH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
23	SDOC_TYPE	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	*
24	ITEM_TYPE	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	*
25	DELIVTYPE_ORDER	☐	LFARTAUFTR	LIEFERART	CHAR	2	0	Delivery Type for Order Delivery Viability Set	*
26	DELIVTYPE_LOG	☐	LFARTLOG	LIEFERART	CHAR	2	0	Logistical delivery type	*
27	ACT_COUNTRY	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	*
28	POSTAL_CODE	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
29	POSTAL_ZONE	☐	JPLZAWGEB	JPLZAWGEB	CHAR	6	0	Postal code evaluation area	*
30	PLANT	☐	JWERK	WERKS	CHAR	4	0	Plant	*
31	CFIELD1	☐	JICFIELD1	CHAR10	CHAR	10	0	Field 1 for definition by customer (max. 10 characters)
32	CFIELD2	☐	JICFIELD2	CHAR10	CHAR	10	0	Customer field 2 (max. 10 characters)
33	CFIELD3	☐	JICFIELD3	CHAR18	CHAR	18	0	Customer field 3 (max. 18 characters)
34	CFIELD4	☐	JICFIELD4	CHAR18	CHAR	18	0	Customer Field 4 (Max. 18 Characters)
35	CFIELD5	☐	JICFIELD5	CHAR18	CHAR	18	0	Customer Field 5 (Max. 18 Characters)
36	CFIELD6	☐	JICFIELD5	CHAR18	CHAR	18	0	Customer Field 5 (Max. 18 Characters)
37	MEDIAISSUE	☐	ISMMATNR_ISSUE	MATNR	CHAR	18	0	Media Issue	*
38	MEDPRODFAM_SOLD	☐	MEDIAPRODUCTFAM_SOLD	MATNR	CHAR	18	0	Media product family sold	*
39	MEDIAPROD_SOLD	☐	MEDIAPRODUCT_SOLD	MATNR	CHAR	18	0	Media product sold	*
40	SDOC_TYPE_SD	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
41	ITEM_TYPE_SD	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
42	KREISG_SCH	☐	KGS_ORDER	KREISG_SCH	CHAR	15	0	IS-M: District municipality key of ship-to party	*
43	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
44	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
45	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	*
46	NDM_ABC_ZONE	☐	NDM_ABC_ZONE	NDM_ABC_ZONE	CHAR	1	0	Newspaper Designated Market Zone for ABC
47	TRAD_ABC_ZONE	☐	TRAD_ABC_ZONE	TRAD_ABC_ZONE	CHAR	1	0	Zone According to CTZ, RTZ, OTZ for ABC
48	BEZPER	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	*
49	WEEKDAY	☐	ISM_WEEKDAY	ISM_WEEKDAY	NUMC	1	0	IS-M: Number of Weekday	TJPWEEKDAY
50	WERBEAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JCBKANKEY	MIXTYPE	JDTBEZTYP	BEZTYP
2	JCBKANKEY	WEEKDAY	TJPWEEKDAY	ISM_WEEKDAY

History

Last changed by/on	SAP	20130529
SAP Release Created in