SAP ABAP Table JSBW_AM_COA_2 (IS-MAM: BW Structure for IS 0ME_ISM_AM_COA_2)

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_AM_COA_2	Table Relationship Diagram
Short Description	IS-MAM: BW Structure for IS 0ME_ISM_AM_COA_2

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	.INCLUDE	☐				0	0	IS-M/AM BW: Include for Contract Assignments
2	.INCLUDE	☐				0	0	IS-M/AM BW: Common Include for JBSW_AM_COA_[123]
3	STORNO_KZ	☐	XSTORNO_KZ	XFELD	CHAR	1	0	IS-M: Reversal BW (0Recordmode)
4	BW_STICHTAG	☐	BW_STICHTAG	DATUM	DATS	8	0	IS-M/AM: Key Date For BW Key Date Logic
5	SLICEBEG	☐	JBW_SLICEBEG	DATUM	DATS	8	0	IS-M/AM BW: Start of a Time Slice
6	SLICEEND	☐	JBW_SLICEEND	DATUM	DATS	8	0	IS-M/AM BW: End of a Time Slice
7	BWZSR	☐	JBW_ZSR	JBW_ZSR	CHAR	2	0	IS-M/AM BW: Time Slice Rule for Contract Update	TJBW01
8	.INCLUDE	☐				0	0	IS-M/AM: Contract BW Classification
9	LEVEL_BP	☐	JH_BWCOALEVEL_BP	JH_BWCOALEVEL_BP	CHAR	1	0	IS-M/AM: Contract BW Classification for Contract Holder
10	LEVEL_BU	☐	JH_BWCOALEVEL_BU	JH_BWCOALEVEL_BU	CHAR	1	0	IS-M/AM: Contract BW Classification for Booking Unit
11	VTNR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	*
12	.INCLUDE	☐				0	0	IS-M: Organizational Data for a Contract
13	.INCLUDE	☐				0	0	IS-M: Sales Area
14	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVTA
15	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTA
16	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
17	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
18	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
19	XORG_ERG	☐	XORG_ERG	XFELD	CHAR	1	0	IS-M: Contract has Explicitly Assigned Sales Areas
20	ABSTYP	☐	ABS_TYP	ABS_TYP	CHAR	1	0	IS-M/AM: Contract Category	TJH11
21	ABINHNR	☐	ABINHNR	GPNR	CHAR	10	0	IS-M/AM: Number of Contract Holder	JGTGPNR
22	KDMI	☐	ISM_CP_CNTRCT_HLDR	BU_PARTNER	CHAR	10	0	IS-M: Contact Person for Contract Holder	*
23	XQUASI	☐	XQUASI	XFELD	CHAR	1	0	IS-M: System Contracts Yes/No Indicator
24	XBESTK	☐	XBESTK	XFELD	CHAR	1	0	IS-M: Contract Status (Created/Confirmed)
25	XNEUSTAT	☐	XNEUSTAT	XFELD	CHAR	1	0	IS-M: Renewal status (renewed y/n)
26	XABRSPERR	☐	XABRSPERR	XFELD	CHAR	1	0	IS-M: Settlement Block
27	ABRECHK	☐	ABRECHK	ABRECHK	CHAR	1	0	IS-M: Settlement Type	TJH15
28	XABR	☐	XABR	XFELD	CHAR	1	0	IS-M: Perform Settlement Yes/No Indicator
29	XLOEVM_COA	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
30	LFZBEG	☐	LFZBEG	DATUM	DATS	8	0	IS-M: Start of Validity Period
31	LFZEND	☐	LFZEND	DATUM	DATS	8	0	IS-M: End of Validity Period
32	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
33	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
34	E_BEDNR	☐	E_BEDNR	ABS_BEDNR	CHAR	10	0	IS-M/AM: Inclusive Contract Requirement	JHVVB_ABS
35	BEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
36	.INCLUDE	☐				0	0	IS-M/AM BW: Include for Contract Assignments
37	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	*
38	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
39	GRUPPABRNR	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	*
40	RABATT_NR	☐	RABATT_NR	RABATT_NR	NUMC	1	0	IS-M: Class of Discount in a Billing Dataset
41	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	*
42	AGENTUR	☐	AGENTUR	GPNR	CHAR	10	0	IS-M: Agency	*
43	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	*
44	ABR_DAT	☐	ABRUF_DAT	DATUM	DATS	8	0	IS-M: Allocation Date of Contract Assignment
45	XFAKTURA	☐	XFAK_ZUO	XFELD	CHAR	1	0	IS-M: Billed Assignment Indicator
46	KAUSSCHL	☐	JH_KAUSSCHL	JH_KAUSSCHL	CHAR	1	0	IS-M: Condition Exclusion Rule for Media-Mix Contract	*
47	XRABATT	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
48	XMITZRAB	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
49	XBONUS	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
50	XMITZBON	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
51	XMANZUO	☐	XMANZUO	JH_MANZUO	CHAR	1	0	IS-M: Level of Manual Influence for a Contract Assignment
52	XFRZUO	☐	XFRZUO	XFELD	CHAR	1	0	IS-M/AM: Indirect COA Assignment Via Hierarchy
53	XAZORIG	☐	XAZORIG	XFELD	CHAR	1	0	IS-M: Indicator for Original Contract Assignment
54	XVBZUO	☐	XVBZUO	XFELD	CHAR	1	0	IS-M/AM: COA Assignment From Other Sales Area
55	XPAR_ABS	☐	XPAR_ABS	XFELD	CHAR	1	0	IS-M: Work With Parallel Contracts Indicator
56	ABR_ZSTAT	☐	ABR_ZSTAT	ABR_ZSTAT	CHAR	1	0	IS-M: Settlement Status of the Assignment
57	XLOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
58	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	*
59	.INCLUDE	☐				0	0	IS-M: Target Agreement for Contract
60	MENGE1	☐	JH_ZIELMAL	JH_ZIELMAL	DEC	5	0	IS-M/AM: Target Number in the Contract
61	EINH1	☐	AB_MALEINH	MEINS	UNIT	3	0	IS-M/AM: Unit for Target Number in Contract	JJV006DL
62	MENGE2	☐	JH_ZIELMNG	ABS_MENGE	QUAN	12	3	IS-M/AM: Target Quantity in the Contract
63	EINH2	☐	AB_MNGEINH	MEINS	UNIT	3	0	IS-M/AM: Unit for Target Quantity in the Contract	JJV006
64	UMSATZ	☐	AB_ZIEL1	WERTV8	CURR	15	2	IS-M/AM: Target Quantity for Monetary Contract
65	WEINH	☐	AB_WEINH	WAERS	CUKY	5	0	IS-M: Currency Key for Contract	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JSBW_AM_COA_2	ABINHNR	JGTGPNR	GPNR	REF	1	CN
2	JSBW_AM_COA_2	ABRECHK	TJH15	ABRECHK	REF	1	CN
3	JSBW_AM_COA_2	ABSTYP	TJH11	ABS_TYP	REF	1	CN
4	JSBW_AM_COA_2	BEINH	JJTBE	BELEINH	REF	1	CN
5	JSBW_AM_COA_2	BWZSR	TJBW01	BWZSR	REF	1	CN
6	JSBW_AM_COA_2	EINH1	JJV006DL	MSEHI	REF	C	CN
7	JSBW_AM_COA_2	EINH2	JJV006	MSEHI	REF	C	CN
8	JSBW_AM_COA_2	E_BEDNR	JHVVB_ABS	BEDNR	REF	1	CN
9	JSBW_AM_COA_2	SPART	TVTA	SPART	REF	1	CN
10	JSBW_AM_COA_2	VKBUR	TVKBZ	VKBUR	REF	1	CN
11	JSBW_AM_COA_2	VKGRP	TVBVK	VKGRP	REF	1	CN
12	JSBW_AM_COA_2	VKORG	TVTA	VKORG	REF	1	CN
13	JSBW_AM_COA_2	VTWEG	TVTA	VTWEG	REF	1	CN
14	JSBW_AM_COA_2	WEINH	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	462