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

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	600