SAP ABAP Table JSBW_SD_CIRCBOOK_COMPL (BW Structure for Extraction JITCIRCBOOK)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-IS (Application Component) Information System
     ⤷ JSBW (Package) IS-M: Link to Business Information Warehouse

Basic Data

Table Category	INTTAB	Structure
Structure	JSBW_SD_CIRCBOOK_COMPL	Table Relationship Diagram
Short Description	BW Structure for Extraction JITCIRCBOOK

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

History

Last changed by/on	SAP	20130529
SAP Release Created in