SAP ABAP Table JSBW_AM_COA_1 (IS-M/AM: BW Structure for IS OME_ISM_AM_COA_1)

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_1	Table Relationship Diagram
Short Description	IS-M/AM: BW Structure for IS OME_ISM_AM_COA_1

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	JHTVKO
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	*
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	*
34	BEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
35	MENGE1	☐	JBW_ZIEL	JBW_ZIEL	QUAN	14	5	IS-M/AM BW: Fraction of a Target Agreement
36	EINH1	☐	AB_MALEINH	MEINS	UNIT	3	0	IS-M/AM: Unit for Target Number in Contract	JJV006DL
37	MENGE2	☐	JBW_ZIEL	JBW_ZIEL	QUAN	14	5	IS-M/AM BW: Fraction of a Target Agreement
38	EINH2	☐	AB_MNGEINH	MEINS	UNIT	3	0	IS-M/AM: Unit for Target Quantity in the Contract	JJV006
39	UMSATZ	☐	AB_ZIEL1	WERTV8	CURR	15	2	IS-M/AM: Target Quantity for Monetary Contract
40	WEINH	☐	AB_WEINH	WAERS	CUKY	5	0	IS-M: Currency Key for Contract	TCURC
41	ANZETAGE	☐	JBW_ANZETAGE	INT4	INT4	10	0	IS-M: Number of Relevant Days in Time Slice

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JSBW_AM_COA_1	ABINHNR	JGTGPNR	GPNR	REF	1	CN
2	JSBW_AM_COA_1	ABRECHK	TJH15	ABRECHK	REF	1	CN
3	JSBW_AM_COA_1	BWZSR	TJBW01	BWZSR	REF	1	CN
4	JSBW_AM_COA_1	EINH1	JJV006DL	MSEHI	REF	C	CN
5	JSBW_AM_COA_1	EINH2	JJV006	MSEHI	REF	C	CN
6	JSBW_AM_COA_1	SPART	TVTA	SPART	REF	1	CN
7	JSBW_AM_COA_1	VKBUR	TVKBZ	VKBUR	REF	1	CN
8	JSBW_AM_COA_1	VKGRP	TVBVK	VKGRP	REF	1	CN
9	JSBW_AM_COA_1	VKORG	TVTA	VKORG	REF	1	CN
10	JSBW_AM_COA_1	VTNR	JHTVKO	VTNR	KEY	1	CN
11	JSBW_AM_COA_1	VTWEG	TVTA	VTWEG	REF	1	CN
12	JSBW_AM_COA_1	WEINH	TCURC	WAERS	REF	C	CN

History

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