SAP ABAP Table JSBW_AM_ORDER_1 (IS-M/AM: BW Structure for IS 0ME_ISM_AM_ORDER_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_ORDER_1   Table Relationship Diagram
Short Description IS-M/AM: BW Structure for IS 0ME_ISM_AM_ORDER_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 Structure for IS 0ME_ISM_AM_ORDER_1  
2 STORNO_KZ XSTORNO_KZ XFELD CHAR 1   0   IS-M: Reversal BW (0Recordmode)  
3 AVM_NR AVM_NR AVM_NR CHAR 10   0   IS-M/AM: Sales Document Number *
4 GPAG GPNR GPNR CHAR 10   0   IS-M: Business Partner Key *
5 POS_ART AVMPOS_ART AVMPOS_ART CHAR 2   0   IS-M: Order-Publishing-Media - Item Type TJH17
6 UR_BELEINH UR_BELEINH BELEINH CHAR 10   0   IS-M: Initial Booking Unit for the OPM Item *
7 PREIS_IM PREIS_IM WERTV8 CURR 15   2   IS-M: Price including VAT  
8 PREIS_OM PREIS_OM WERTV8 CURR 15   2   IS-M: Price excluding VAT  
9 WAERG WAERK WAERS CUKY 5   0   SD document currency *
10 BELEGEINH BELEGEINH BELEINH CHAR 10   0   IS-M/AM: Booking Unit *
11 VKORG VKORG VKORG CHAR 4   0   Sales Organization *
12 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel *
13 SPART SPART SPART CHAR 2   0   Division *
14 VKBUR VKBUR VKBUR CHAR 4   0   Sales office *
15 REGULIERER REGULIERER GPNR CHAR 10   0   IS-M: Payer *
16 INSERENT INSERENT GPNR CHAR 10   0   IS-M: Advertiser *
17 XFAKT_EE XFAKT_EE XFELD CHAR 1   0   IS-M: Billed Indicator  
18 BER_TERMIN BER_TERMIN DATUM DATS 8   0   IS-M: Date Services were Created for Settlement Purposes  
19 VBTYP VBTYP VBTYP CHAR 1   0   SD document category  
20 AUART AUART_PAM AUART_PAM CHAR 4   0   IS-M: Sales Document Type *
21 AUGRU AUGRU AUGRU CHAR 3   0   Order reason (reason for the business transaction) *
22 VKGRP VKGRP VKGRP CHAR 3   0   Sales group *
23 GSBER GSBER GSBER CHAR 4   0   Business Area *
24 STAFO JHSTAFO STAFO CHAR 6   0   IS-M: Update group for statistics update *
25 STWAE STWAE WAERS CUKY 5   0   Statistics currency *
26 AVM_HRKNFT AVM_HRKNFT AVM_HRKNFT CHAR 1   0   IS-M/AM: Order Origin  
27 VERMITTLER VERMK JJMVERM CHAR 10   0   IS-M: Sales Agent with ID Code for Screen *
28 POS_NR POS_NR AVM_PNR NUMC 3   0   IS-M: Order Item Number *
29 BRAN_PAM BRAN_POS BRACO CHAR 10   0   IS-M/AM: Current Industry Sector Associated With Order Item *
30 KAMPAGNE KAMPAGNE KAMPAGNE CHAR 6   0   IS-M: Campaign (customer) *
31 INHK_TECH1 INHK_TECH1 INHALTSKOM CHAR 8   0   IS-M: Technical Content Component (Positioning View) *
32 INHK_TLEV1 INHK_LEV1 INHALTSKOM CHAR 8   0   IS-M: Level 1 content component in the hierarchy *
33 INHK_TECH2 INHK_SOVER INHALTSKOM CHAR 8   0   IS-M: Special Publication Content Component *
34 INHK_KFM INHK_KFM INHALTSKOM CHAR 8   0   IS-M: Business Content Component *
35 AZART_PLAZ AZART_PLAZ AZART_PLAZ CHAR 4   0   IS-M: Ad Type with Regard to General Positioning *
36 KONKAUS KONKAUS KONKAUS CHAR 2   0   IS-M: Competitor exclusion *
37 PRODH J_PRODH J_PRODH CHAR 18   0   IS-M/AM: Product Hierarchy *
38 BLGMENGE BLGMGE_PAM STMENGE DEC 9   0   IS-M: Delivery Quantity for Ad Insert  
39 DISPMENGE DSPMGE_PAM STMENGE DEC 9   0   IS-M: Planning Quantity for Ad Inserts  
40 BERMENGE BERMENGE STMENGE DEC 9   0   IS-M: Calculation Quantity (Ad Insert)  
41 POSTMENGE POSTMENGE STMENGE DEC 9   0   IS-M: Postal Circulation Quantity  
42 SI_TYP SITYP SI_TYP CHAR 2   0   IS-M: Ad Insert Type *
43 SI_GEWICHT JSBW_SIGEW ISPMNG9 QUAN 9   3   IS-M: Ad Insert Weight for BW  
44 MEINHGEWBL MEINHGEWBL MEINS UNIT 3   0   IS-M: Unit of Weight for Ad Insert *
45 MATNR MATNR_DIEN MATNR_DIEN CHAR 18   0   IS-M: Service material number *
46 MENGE DIEN_MENGE MENG13 QUAN 13   3   IS-M: Service Quantity  
47 DIENTYP DIENTYP DIENTYP CHAR 4   0   IS-M: Service Type *
48 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
49 DIEN_BE DIEN_BE BELEINH CHAR 10   0   IS-M: Service: Assigned Booking Unit *
50 DIEN_IKO DIEN_IKO INHALTSKOM CHAR 8   0   IS-M: Service: Assigned Content Component *
51 VRTMENGE VRTMGI_PAM STMENGE DEC 9   0   IS-M/AM: Actual Quantity for Distribution  
52 ANZSEITEN ANZSEITEN NUM8 NUMC 8   0   Number of Pages in Issue  
53 XTECH_MIN1 XTECH_MIN1 XFELD CHAR 1   0   IS-M: Tech.process.started (for at least 1 schedule line)  
54 XTECH_EE XTECH_EE XFELD CHAR 1   0   IS-M: Tech.Complete (All Schedule Lines Fully Processed)  
55 GPNR_RECH GPNR_RECH GPNR CHAR 10   0   IS-M: Business Partner - Bill-To Party *
56 PSTYV PSTYV_PAM PSTYV_PAM CHAR 4   0   IS-M: Item Category for Sales Document *
57 BER_HEFT ISM_BER_HEFT PAM_PERIOD CHAR 14   0   IS-M: Service Creation Copy Number for Settlement  
58 VAVARTYP VAVARTYPTA VAVARTYP CHAR 2   0   Actual issue variant type *
59 IHKOMP INHK_PRICE INHALTSKOM CHAR 8   0   IS-M: Content component from price hierarchy *
60 SEITE_FSP SEITE_FSP SEITE_FSP CHAR 4   0   IS-M: Page/column format *
61 SEITE_FORM SEITE_FORM SEITE_FORM CHAR 2   0   IS-M: Page Format *
62 SMM_SFSP JSBW_SMM_SFSP DECV13_3 DEC 13   3   IS-M/AM: Size in Column mm  
63 SFSP_ABR SFSP_ABR SEITE_FSP CHAR 4   0   IS-M: Column Format for Settlement *
64 WERBK_TYP WERBK_TYP WKOMBI_TYP CHAR 2   0   IS-M: Advertising Combination Type *
65 BREITE BREITE_VER GROESSE QUAN 7   3   IS-M: Ad Spec Width for Settlement  
66 BREITE_EH BREITE_SEH ISPEINHEIT UNIT 3   0   IS-M/AM: Unit of Measure for Width *
67 HOEHE HOEHE_VER GROESSE QUAN 7   3   IS-M: Clearable Height for Ad Spec  
68 HOEHE_EH ISPEINH_H ISPEINH_H UNIT 3   0   IS-M: Unit of Measure for Height *
69 ZUS_MENGE BER_MENGE GROESSE QUAN 7   3   IS-M: Number of Additional Ad Spec Calculation Units  
70 ZUS_BERECH MEINH_ZUS ISPEINHEIT UNIT 3   0   IS-M: Additional Unit of Measure for Settlement *
71 MGLME MENGE_D MENG13 QUAN 13   3   Quantity  
72 LAGME LAGME MEINS UNIT 3   0   Base Unit of Measure *
73 AZART_GEST AZART_GEST AZART_GEST CHAR 4   0   IS-M: Design Ad Type *
74 AZART_FORM AZART_FORM AZART_FORM CHAR 4   0   IS-M: Shape Ad Type *
75 AZART_FARB AZART_FARB AZART_FARB CHAR 4   0   IS-M: Color Scheme Ad Type *
76 AZART_SOND AZART_SOND AZART_SOND CHAR 2   0   IS-M: Ad Type - Special Handling Type *
77 KZWI1 KZWI1 WERTV7 CURR 13   2   Subtotal 1 from pricing procedure for condition  
78 KZWI2 KZWI2 WERTV7 CURR 13   2   Subtotal 2 from pricing procedure for condition  
79 KZWI3 KZWI3 WERTV7 CURR 13   2   Subtotal 3 from pricing procedure for condition  
80 KZWI4 KZWI4 WERTV7 CURR 13   2   Subtotal 4 from pricing procedure for condition  
81 KZWI5 KZWI5 WERTV7 CURR 13   2   Subtotal 5 from pricing procedure for condition  
82 KZWI6 KZWI6 WERTV7 CURR 13   2   Subtotal 6 from pricing procedure for condition  
83 XSTORNIERT XSTORNIERT XFELD CHAR 1   0   IS-M: Canceled Order Object Indicator  
84 STORNOGRND STOGRD_PAM STOGRD_PAM CHAR 3   0   IS-M: Cancellation Reason *
85 INHK_KLEV1 JSBW_LEV1 INHALTSKOM CHAR 8   0   IS-M: Content component level 1 of hierarchy JSBW *
86 SMM_ABR JSBW_SMM_ABR DECV13_3 DEC 13   3   IS-M/AM: Size in Column mm JSBW  
87 BNAME JSBW_B_V TEXT32 CHAR 32   0   IS-M: Name of Ordering Party JSBW  
88 GRUPPABRNR GRUPPABRNR GRUPPABR NUMC 3   0   IS-M/AM: Billing Dataset *
89 BOOK_OL ISM_BOOK_OL ISM_BOOK_OL CHAR 4   0   IS-M/AM: Booking Type for Online Advertising *
90 SELDAT_VON SELDAT_VON DATUM DATS 8   0   IS-M: Start Date for Item  
91 SELDAT_BIS SELDAT_BIS DATUM DATS 8   0   IS-M: End Date for Items  
92 WERBK_KNZ WERBK_KNZ WERBEKKNZ NUMC 4   0   IS-M: Combination Sale Indicator  
93 PREIS_AVM1 PREIS_AVM1 WERTV8 CURR 15   2   IS-M: Price Field 1 in the Order  
94 PREIS_AVM2 PREIS_AVM2 WERTV8 CURR 15   2   IS-M: Price Field 2 in the Order  
95 WS_TIMESLC WS_TIMESLC WS_TIMESLC CHAR 2   0   IS-M: Commercial Time Slice *
96 WS_BLOCK WS_BLOCK WS_BLOCK CHAR 2   0   IS-M: Commercial Cluster *
97 WS_STELLE WS_STELLE NUMC3 NUMC 3   0   IS-M: Position (Sequence) Within a Commercial Cluster  
98 FORMAT_ONL FORMAT_ONL FORMAT_ONL CHAR 4   0   IS-M/AM: Format Proposal (Online) *
99 XAEPROV XAEPROV XFELD CHAR 1   0   IS-M: Agency Commission Credit Memo Indicator  
100 MWST_BETR GRMWSTBETR WERTV7 CURR 13   2   IS-M: Value-Added Tax Amount  
101 IKO_STAT IKO_STAT INHALTSKOM CHAR 8   0   IS-M: Statistical content component *
102 BEGRP_STAT BEGRP_STAT BEGRP_STAT CHAR 4   0   IS-M: BU Grouping for Statistics *
103 TERM_TYP TERMINTYP TERMINTYP CHAR 1   0   IS-M/AM: Date Category Copy Number/Publication Date *
104 STGVB_PAM STGVB_PAM STGVB_PAM CHAR 2   0   IS-M: Statistics Group for Sales Documents *
105 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
106 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
107 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
108 CAMPAIGN_PSP PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
109 REF_VBELN JJBELNR JJBELNR CHAR 10   0   IS-M/AM: Billing Document *
110 REF_POSNR JJPOSNR JJPOSNR NUMC 6   0   IS-M/AM: Item (number) in settlement document *
111 RRREL ISMRR_RELTYP ISMRR_RELTYP CHAR 1   0   IS-M/AM: Revenue Recognition Category  
112 RESTHSHLT_DATUM ISM_DELTA_COVERAGE_DATE DATUM DATS 8   0   IS-M: Alternative Date for Total Market Coverage  
113 COPY_NO_START ISM_COPY_NO_START PAM_PERIOD CHAR 14   0   IS-M/AM: Start of Period for Copy  
114 COPY_NO_END ISM_COPY_NO_END PAM_PERIOD CHAR 14   0   IS-M/AM: End of Period for Copy  
115 AZART_AREA AZART_AREA AZART_AREA CHAR 4   0   IS-M/AM: Fixed Format Proposal /Ad Dimensions *
116 KUKARR_K JKUKARR JKUKARR CHAR 2   0   IS-M: Customer Profile *
117 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) *
118 KDGRP KDGRP KDGRP CHAR 2   0   Customer group *
119 XAGENAUFTR XAGENAUFTR XFELD CHAR 1   0   IS-M: Agency order indicator  
120 MF_BER_MGLME MENGE_D MENG13 QUAN 13   3   Quantity  
121 MF_COA_MGLME MENGE_D MENG13 QUAN 13   3   Quantity  
122 MF_COA_LAGME LAGME MEINS UNIT 3   0   Base Unit of Measure *
123 INS_SERIES_RULE ISM_INSERTION_SERIES_RULE ISM_INSERTION_SERIES_RULE CHAR 4   0   IS-M/AM: Series Rule *
124 INS_SERIES ISM_INSERTION_SERIES CHAR4 CHAR 4   0   IS-M/AM: Unique Identification of a Series Found  
125 INS_SERIES_NO ISM_INSERTION_SERIES_NO NUM4 NUMC 4   0   IS-M/AM: Unique Billing Dataset Number Within a Series  
126 .INCLUDE       0   0   IS-MAM: BW Structure for IS 0ME_ISM_AM_ORDER_1 St  
127 BW_STICHTAG BW_STICHTAG DATUM DATS 8   0   IS-M/AM: Key Date For BW Key Date Logic  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JSBW_AM_ORDER_1 POS_ART TJH17 AVMPOS_ART REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in