| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BBPC_CMS_ATTRSTR | Structure type for Attributes | 8 | POS_NR | Position of Attribute in Group | int | 10 | 0 | | |
2 | SALV_IDA_D_TYPES | Test Data for ALV IDA | 4 | POS_NR | | nvarchar | 10 | 0 | | |
TOPAdvertising Management |
3 | /NAM/JHACCBUNDLE | Credit Card Processing - Bundling and Delta Processing | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
4 | JHABPZ | IS-M/AM: Assign Booking Units to an Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
5 | JHACHIF | IS-M/AM: Box No.Attributes/Response Master Record | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
6 | JHAE | IS-M/AM: OPM Sub-Item Schedule Line | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
7 | JHAEA | IS-M/AM: Order-Publishing-Media Ad Schedule Line | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
8 | JHAEO | IS-M/AM: Online Schedule Line | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
9 | JHAERL | IS-M: OPM Ad Error Log for Schedule Line Generation | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
10 | JHAES | IS-M/AM: OPM Ad Insert Schedule Line | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
11 | JHAEV | IS-M/AM: OPM Distribution Schedule Line | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
12 | JHAEW | IS-M/AM: OPM Commercial Schedule Line | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
13 | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
14 | JHAGA2 | IS-M/AM: JHAGA Enhancement | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
15 | JHAGAP | IS-M/AM: Sales Agent Determination Log | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
16 | JHAGAPM | IS-M/AM: Messages Log for Sales Agent Determination | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
17 | JHAGAX | IS-M/AM: Update Index for Billing Dataset | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
18 | JHAGPZ | IS-M/AM: Assign Business Partner to Order and Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
19 | JHAGVX | IS-M/AM: Order Sales Agent Assignment Settlement Index | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
20 | JHAGVZ | IS-M/AM: Order Sales Agent Assignment | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
21 | JHAHFZ | IS-M/AM: Order Item Copy Assignment (Todo) | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
22 | JHAIKZ | IS-M/AM: Item/Booking Unit/Technical Content Comp.Assignment | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
23 | JHAISZ | IS-M/AM: Assignment Table of Advertisers for OPM Order | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
24 | JHAKPV | IS-M/AM: OPM Header Sales Agent / Item Sales Agent | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
25 | JHAMEZ | IS-M/AM: Order Item Schedule Line Data (Manual) Assignment | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
26 | JHAMOZ | IS-M/AM: Assign Ad Specs to Order Objects | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
27 | JHAMOZO | IS-M/AM: Assignment of Online Ad Specs to Order Objects | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
28 | JHAMOZW | IS-M/AM: Assign Commercial Ad Specs to Order Objects | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
29 | JHAOFFERT | IS-M/AM: Response Management | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
30 | JHAP | IS-M/AM: Order-Publishing-Media Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
31 | JHAPA | IS-M/AM: Order-Publishing-Media Ad Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
32 | JHAPAFP | IS-M/AM: Contract Determination Log for OPM Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
33 | JHAPD | IS-M/AM: OPM Service Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
34 | JHAPLZ | IS-M/AM: OPM Positioning Assignment | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
35 | JHAPO | IS-M/AM: Order-Publishing-Media Online Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
36 | JHAPP | Order-Publishing-Media Package Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
37 | JHAPS | IS-M/AM: OPM Ad Insert Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
38 | JHAPV | IS-M/AM: OPM Distribution Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
39 | JHAPW | IS-M/AM: OPM Commercial Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
40 | JHAPZUO | IS-M/AM: Work List of Non Assigned Items | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
41 | JHAP_PPF | IS-M: PPF Order Item in Advertising Management | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
42 | JHAREKL | IS-M/AM: Complaint Object | 11 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
43 | JHAREV1 | IS-M/AM: Order Revenue Recognition Key Date Values | 45 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
44 | JHAREV3 | IS-M/AM: Order Revenue Recognition Key Date Quantities | 42 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
45 | JHASIZ | IS-M/AM: OPM Ad Insert Assignment | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
46 | JHATEOTD | IS-M/AM: Online Production Schedule Line Todo | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
47 | JHATERR | IS-M/AM: Error Messages from the Technical System | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
48 | JHATEXTORD | IS-M/AM: Transfer External Orders from the Technical System | 6 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
49 | JHATGZ | IS-M/AM: Target Group Assignment for OPM Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
50 | JHATPAPTD | IS-M/AM: Ad Production Order Item (Todo) | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
51 | JHATPSI | OPM Prod.Sched.Line - Actual Message with Plnd/Act Variation | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
52 | JHATPSITD | Ad Production Schedule Line - Actual Message Todo | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
53 | JHATPSTD | IS-M/AM: Ad Production Schedule Line - Todo | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
54 | JHATRZ | IS-M/AM: Order Item Date Assignment | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
55 | JHATRZW | IS-M/AM: Order Item Date Assignment (Commercial) | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
56 | JHATSTATOTD | IS-M/AM: Status/Characteristic Alignment from Technical Todo | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
57 | JHATSTATTD | IS-M/AM: Status/Characteristic Alignment from Technical Todo | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
58 | JHATVASPTD | IS-M/AM: Order Item Pool Issue Shift Header | 4 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
59 | JHAU | IS-M/AM: Order-Publishing-Media Sub-Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
60 | JHAUA | IS-M/AM: Order-Publishing-Media Ad Sub-Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
61 | JHAUO | IS-M/AM: OPM Online Sub-Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
62 | JHAUSI | IS-M/AM: Sub-Items (Positioning) for Ad Insert | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
63 | JHAUV | IS-M/AM: Distribution Sub-Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
64 | JHAUW | IS-M/AM: Order-Publishing-Media Ad Sub-Item | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
65 | JHA_ORDER_INDEX | Selection Index for Orders | 11 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
66 | JHTFX | IS-M/AM: Billing Index - Order Billing | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
67 | JHTVAABG | IS-M/AM: Contract Settlement - Changed Assessment Basis | 5 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
68 | JHTVAABP | IS-M/AM: Contract Settlement Item Data | 13 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
69 | JHTVABRUF | IS-M/AM: Contract Access | 5 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
70 | TJHVSW03 | IS-M/AM: Save VSW Interfaces Created | 44 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
TOPBasic Market Data |
71 | /BA1/F4_VOLA | Volatilities | 3 | POS_NR | Volatility Position Number | int | 10 | 0 | | |
TOPDocument Builder |
72 | /IPRO/TATTRSTR | Structure Type for Attributes Used in Duet | 10 | POS_NR | Position of Attribute in Group | int | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
73 | JVTMCI_HEADER | IS-M: TMCI Ad Insert Items | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
74 | JVTMCI_ITEM | IS-M: TMCI Household Addresses for AI Schedule Lines | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
75 | JVTMCI_MERGEINFO | IS-M: Explode TMCI AI Schedule Lines in M/SD Structures | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
76 | JVTMCI_MERGE_RES | TMCI Merge Result: Merge Result for Ship-To Address | 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
77 | JVTSIANZUO | IS-M: Assignment of Insert Mix to AI Orders | 5 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
78 | JVTSIBLZUO | IS-M: Assignment of Insert Mix to AI Orders | 5 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
79 | JVTSIRHZUO | IS-M: Assignment of Delivery to AI Sched.Line - Delta Cov. | 5 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
80 | JVTSIVTZUO | IS-M: Assignment of Delivery to AI Schedule Line for Dist. | 5 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
81 | /BEV3/CHABRSTZ_P | CH Settlement Items - With Translations | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
82 | /BEV3/CHBDMDHST | History of Condit. Modifications from Temp. Settlement Items | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
83 | /BEV3/CHCIVBFS | Error Log Collective Run CH Docs. Using Create Invoice | 5 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
84 | /BEV3/CHERGSTZ_P | CH Settlement Items - With Translations | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
85 | /BEV3/CHERGSTZ_S | CH Settlement Statistics | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
86 | /BEV3/CHEXCSTZ_P | CH Settlement Items/Non-Posted Docs w/o Date Statistics | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
87 | /BEV3/CHRESADMIN | Reset Date - Transfer Paranmeters for Admin. Process | 8 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
88 | /BEV3/CHRESSTZ_P | CH Settlement Items - Reset Documents (2/Transaction) | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
89 | /BEV3/CHSHTSTZSD | Special Interface Data for SD - Not CH-Relevant | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
90 | /BEV3/CHSHTSTZ_P | CH Settlement Item | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
91 | /BEV3/CHSIMBDMDH | CH simulation history of modifications caused by conditions | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
92 | /BEV3/CHSIMSTZ_P | CH Simulation Items | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
93 | /BEV3/CHSIMSTZ_S | CH Simulation Statistics | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
94 | /BEV3/CHTMERGPOS | Document Assignment of Enhancement | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
95 | /BEV3/CHTMPMDHST | Temp. history of cond. modifications from temp. settle. item | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
96 | /BEV3/CHTRMSTZ_P | CH Date Item | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
97 | /BEV3/CHTRMSTZ_S | CH Date Statistics | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |
98 | /BEV3/CHVABRSTZS | CH Settlement Statistics | 3 | POS_NR | CH Item Number | nvarchar | 6 | 0 | | |