SAP ABAP Table JSBW_AM_COA_ASS (IS-M/AM BW: Include for Contract Assignments)

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_ASS	Table Relationship Diagram
Short Description	IS-M/AM BW: Include for Contract Assignments

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JSBW_AM_COA_ASS	ABINHNR	JGTGPNR	GPNR	REF	1	CN
2	JSBW_AM_COA_ASS	ABRECHK	TJH15	ABRECHK	REF	1	CN
3	JSBW_AM_COA_ASS	ABSTYP	TJH11	ABS_TYP	REF	1	CN
4	JSBW_AM_COA_ASS	BEINH	JJTBE	BELEINH	REF	1	CN
5	JSBW_AM_COA_ASS	BWZSR	TJBW01	BWZSR	REF	1	CN
6	JSBW_AM_COA_ASS	E_BEDNR	JHVVB_ABS	BEDNR	REF	1	CN
7	JSBW_AM_COA_ASS	SPART	TVTA	SPART	REF	1	CN
8	JSBW_AM_COA_ASS	VKBUR	TVKBZ	VKBUR	REF	1	CN
9	JSBW_AM_COA_ASS	VKGRP	TVBVK	VKGRP	REF	1	CN
10	JSBW_AM_COA_ASS	VKORG	TVTA	VKORG	REF	1	CN
11	JSBW_AM_COA_ASS	VTWEG	TVTA	VTWEG	REF	1	CN

History

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