SAP ABAP Table JSBW_AM_COA_3 (IS-M/AM: BW Structure for IS 0ME_ISM_AM_COA_3)
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_3   Table Relationship Diagram
Short Description IS-M/AM: BW Structure for IS 0ME_ISM_AM_COA_3    
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 VBELN JJBELNR JJBELNR CHAR 10   0   IS-M/AM: Billing Document *
60 POSNR JJPOSNR JJPOSNR NUMC 6   0   IS-M/AM: Item (number) in settlement document *
61 VBTYP ISPVBTYP ISPVBTYP CHAR 1   0   IS-M/AM: Sales Document Category  
62 FKART FKART_PAM FKART_PAM CHAR 4   0   IS-M/AM: Billing/Settlement Document Type *
63 FKTYP JHFKTYP JHFKTYP CHAR 1   0   IS-M/AM: Billing Category *
64 WAERK WAERK WAERS CUKY 5   0   SD document currency *
65 BRTWP JHBRTWRP WERTV8 CURR 15   2   IS-M: Gross Value in Document Currency (Item)  
66 NETWP NETWR_FP WERTV8 CURR 15   2   Net value of the billing item in document currency  
67 MWSBP MWSBP WERTV7 CURR 13   2   Tax amount in document currency  
68 KZWI1 KZWI1 WERTV7 CURR 13   2   Subtotal 1 from pricing procedure for condition  
69 KZWI2 KZWI2 WERTV7 CURR 13   2   Subtotal 2 from pricing procedure for condition  
70 KZWI3 KZWI3 WERTV7 CURR 13   2   Subtotal 3 from pricing procedure for condition  
71 KZWI4 KZWI4 WERTV7 CURR 13   2   Subtotal 4 from pricing procedure for condition  
72 KZWI5 KZWI5 WERTV7 CURR 13   2   Subtotal 5 from pricing procedure for condition  
73 KZWI6 KZWI6 WERTV7 CURR 13   2   Subtotal 6 from pricing procedure for condition  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JSBW_AM_COA_3 ABINHNR JGTGPNR GPNR REF 1 CN
2 JSBW_AM_COA_3 ABRECHK TJH15 ABRECHK REF 1 CN
3 JSBW_AM_COA_3 ABSTYP TJH11 ABS_TYP REF 1 CN
4 JSBW_AM_COA_3 BEINH JJTBE BELEINH REF 1 CN
5 JSBW_AM_COA_3 BWZSR TJBW01 BWZSR REF 1 CN
6 JSBW_AM_COA_3 E_BEDNR JHVVB_ABS BEDNR REF 1 CN
7 JSBW_AM_COA_3 SPART TVTA SPART REF 1 CN
8 JSBW_AM_COA_3 VKBUR TVKBZ VKBUR REF 1 CN
9 JSBW_AM_COA_3 VKGRP TVBVK VKGRP REF 1 CN
10 JSBW_AM_COA_3 VKORG TVTA VKORG REF 1 CN
11 JSBW_AM_COA_3 VTWEG TVTA VTWEG REF 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 462