SAP ABAP Table JITCIRCBOOK (IS-M/SD: Circulation Book with Delivery Quantities)

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	JITCIRCBOOK	Table Relationship Diagram
Short Description	IS-M/SD: Circulation Book with Delivery Quantities

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	JCBKEY	☑	JCBKEY	JCBKEY	NUMC	20	0	Technical surrogate key for circulation book
3	.INCLUDE	☐				0	0	Canonical Key for Circulation Book
4	CIRC_ORIGIN	☐	J_CIRC_ORIGIN	J_CIRC_ORIGIN	CHAR	1	0	Technical data origin of circulation
5	ISSUE	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	*
6	PUBL_ORDER	☐	DRERZAUFTR	DRERZ	CHAR	8	0	Order Publication	*
7	EDITION_ORDER	☐	PVAAUFTR	PVA	CHAR	8	0	Order-related edition	*
8	DELIV_RETRN_DATE	☐	VERSREMIDAT	DATUM	DATS	8	0	Shipping date or return date of delivered/returned issues
9	DLVRYDOCTYPE	☐	LFNGART	LFNGART	CHAR	1	0	Type of Delivery
10	AUDITCAT	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	TJI01
11	NRMLCOUNTRY	☐	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	*
12	CUKY_SDOC	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
13	MIXTYPE	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
14	BILLFREQ	☐	FKPER	FKPER	CHAR	2	0	Billing Frequency	*
15	PRICEPER	☐	PRSPER	PRSPER	CHAR	2	0	IS-M: Price Frequency	*
16	PRCGRPCUST	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	*
17	RATE_CODE	☐	RATE_CODE	RATE_CODE	CHAR	4	0	IS-M/SD: Rate Code	*
18	CT_SPRICE	☐	CTYPE_SPRICE	KSCHL	CHAR	4	0	Condition Type for Purchase Price	*
19	SUBS_PRICE	☐	JBEZPRS	CHAR13	CHAR	13	0	Purchase price
20	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
21	CUKY_SPRICE	☐	JCURRBEZPRS	WAERS	CUKY	5	0	Currency key for purchase price	*
22	CUST_GROUP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
23	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
24	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
25	PYMT_METH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
26	SDOC_TYPE	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
27	ITEM_TYPE	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	*
28	DELIVTYPE_ORDER	☐	LFARTAUFTR	LIEFERART	CHAR	2	0	Delivery Type for Order Delivery Viability Set	*
29	DELIVTYPE_LOG	☐	LFARTLOG	LIEFERART	CHAR	2	0	Logistical delivery type	*
30	ACT_COUNTRY	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	*
31	POSTAL_CODE	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
32	POSTAL_ZONE	☐	JPLZAWGEB	JPLZAWGEB	CHAR	6	0	Postal code evaluation area	*
33	PLANT	☐	JWERK	WERKS	CHAR	4	0	Plant	*
34	CFIELD1	☐	JICFIELD1	CHAR10	CHAR	10	0	Field 1 for definition by customer (max. 10 characters)
35	CFIELD2	☐	JICFIELD2	CHAR10	CHAR	10	0	Customer field 2 (max. 10 characters)
36	CFIELD3	☐	JICFIELD3	CHAR18	CHAR	18	0	Customer field 3 (max. 18 characters)
37	CFIELD4	☐	JICFIELD4	CHAR18	CHAR	18	0	Customer Field 4 (Max. 18 Characters)
38	CFIELD5	☐	JICFIELD5	CHAR18	CHAR	18	0	Customer Field 5 (Max. 18 Characters)
39	CFIELD6	☐	JICFIELD5	CHAR18	CHAR	18	0	Customer Field 5 (Max. 18 Characters)
40	MEDIAISSUE	☐	ISMMATNR_ISSUE	MATNR	CHAR	18	0	Media Issue	*
41	MEDPRODFAM_SOLD	☐	MEDIAPRODUCTFAM_SOLD	MATNR	CHAR	18	0	Media product family sold	*
42	MEDIAPROD_SOLD	☐	MEDIAPRODUCT_SOLD	MATNR	CHAR	18	0	Media product sold	*
43	SDOC_TYPE_SD	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
44	ITEM_TYPE_SD	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
45	KREISG_SCH	☐	KGS_ORDER	KREISG_SCH	CHAR	15	0	IS-M: District municipality key of ship-to party	*
46	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
47	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
48	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	*
49	NDM_ABC_ZONE	☐	NDM_ABC_ZONE	NDM_ABC_ZONE	CHAR	1	0	Newspaper Designated Market Zone for ABC
50	TRAD_ABC_ZONE	☐	TRAD_ABC_ZONE	TRAD_ABC_ZONE	CHAR	1	0	Zone According to CTZ, RTZ, OTZ for ABC
51	BEZPER	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	*
52	WEEKDAY	☐	ISM_WEEKDAY	ISM_WEEKDAY	NUMC	1	0	IS-M: Number of Weekday	TJPWEEKDAY
53	WERBEAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	*
54	CAID_ED_ORDER	☐	CIRCAUD_ID_EO	IVWNR	NUMC	10	0	Audit Report ID of Edition Purchased in Order
55	PUBL_DELIV	☐	DRERZTAT	DRERZ	CHAR	8	0	Actual Publication Delivered	*
56	EDITION_DELIV	☐	PVATAT	PVA	CHAR	8	0	Actual edition delivered	*
57	MEDIAPRODUCTFAM	☐	MEDIAPRODUCTFAM	MATNR	CHAR	18	0	Media Product Family	*
58	MEDIAPRODUCT	☐	ISMMATNR_PRODUCT	MATNR	CHAR	18	0	Media Product	*
59	PUBL_DATE	☐	ERSCHDAT	DATUM	DATS	8	0	Publication Date
60	IPER_DATE	☐	EPERDATUM	DATUM	DATS	8	0	IS-M: Starting Date of Individual Period
61	COPY_NO_ISSUE	☐	HEFTNUM_VA	HEFTNUMMER	CHAR	9	0	Copy Number of Issue
62	CAID_ED_DELIV	☐	CIRCAUD_ID_ED	IVWNR	NUMC	10	0	Audit Report ID for Edition Delivered
63	DIVI_PUBLCTN	☐	SPARTDRERZ	SPART	CHAR	2	0	Division for publication	*
64	CIRC_FIGURE	☐	CIRC_FIGURE	MENGGPOS	QUAN	10	0	Circulation Figure
65	CIRC_FIG_INSERT	☐	CIRC_FIG_INSERT	MENGGPOS	QUAN	10	0	Inserted Proportion of Circulation
66	CIRC_FIG_COMB	☐	CIRC_FIG_COMB	MENGGPOS	QUAN	10	0	Combined Proportion of Circulation
67	SALES_UNIT	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	*
68	AUFMELDART	☐	AUFMELDART	AUFMELDART	CHAR	2	0	Audit Report Type for Edition	*
69	PZVARCB	☐	JPZVARCB	JPLZAWVAR	CHAR	3	0	Postal code area variant for circulation book	*
70	.INCLUDE	☐				0	0	Created-by data (maximum version)
71	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
72	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
73	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
74	ERFPROG	☐	ERFPROG	PROGRAMM	CHAR	40	0	Program Used to Create Object	*
75	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
76	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
77	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
78	AENPROG	☐	AENPROG	PROGRAMM	CHAR	40	0	Program that Made Last Change	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JITCIRCBOOK	AUDITCAT	TJI01	IVWKN	KEY	1	CN
2	JITCIRCBOOK	MIXTYPE	JDTBEZTYP	BEZTYP
3	JITCIRCBOOK	SDOC_TYPE	TJAK	AUART	KEY	1	CN
4	JITCIRCBOOK	WEEKDAY	TJPWEEKDAY	ISM_WEEKDAY

History

Last changed by/on	SAP	20130529
SAP Release Created in