| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | JHAGPZ | IS-M/AM: Assign Business Partner to Order and Item | 5 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
2 | JHA_ORDER_INDEX | Selection Index for Orders | 2 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
3 | JHTFPA | IS-M/AM: Settlement/Billing Document Item: Partner | 5 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
4 | JHTMGPZ | IS-M: Media-Mix Contract: Business Partner | 4 | GPNR | IS-M/AM: Assigned Business Partner in the Contract | nvarchar | 10 | 0 | | |
5 | JHTVGPZ | IS-M/AM: Business Partner Assignment to the Contract | 5 | GPNR | IS-M/AM: Assigned Business Partner in the Contract | nvarchar | 10 | 0 | | |
6 | JJTAL | IS-M/AM: Business Partner Alias | 2 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
7 | JJTAM | IS-M/AM: Media Contact Person | 2 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
8 | JJTGPBTBR | IS-M/AM: Customer Potential: Industry Sector - BP | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
9 | JJTGPBTBZ | IS-M/AM: Customer Potential: Zone - BP | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
10 | JJTGPBTF1 | IS-M/AM: Customer Potential: Free Attribute 1 - BP | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
11 | JJTGPBTF2 | IS-M/AM: Customer Potential: Free Attribute 2 - BP | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
12 | JJTGPBTF3 | IS-M/AM: Customer Potential: Free Attribute 3 - BP | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
13 | JJTGPBTF4 | IS-M/AM: Customer Potential: Free Attribute 4 - BP | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
14 | JJTGPBTF5 | IS-M/AM: Customer Potential: Free Attribute 5 - BP | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
15 | JJTGPBTF6 | IS-M/AM: Customer Potential: Free Attribute 6 - BP | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
16 | JJTGPBTF7 | IS-M/AM: Customer Potential: Free Attribute 7 - BP | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
17 | JJTPH | IS-M/AM: BP Product Hierarchy Assignment | 2 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
TOPMaster Data |
18 | JGTADAV | IS-M/SD: Worklist of Address Changes | 2 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
19 | JGTADRA | IS-M: Business Partner-Address Assignment (Time-Dependent) | 2 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
20 | JGTADRG | IS-M: Business Partner Assignment | 2 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
21 | JGTAKTFSYS | IS-M: Buffer Table for Activities in Non-SAP Systems (BP) | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
22 | JGTBKEZ | IS-M: Additional Data on Collection Authorization for Banks | 2 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
23 | JGTBKVW | IS-M: Note to Payee for Banks | 2 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
24 | JGTGPNR | IS-M: Central Business Partner Table | 2 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
25 | JGTKNBKFSY | IS-M: Index for Synchronization of Cust.Bank with Th.-Pty FI | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
26 | JGTLFBKFSY | IS-M: Index for Synchronization of Vendor Bank w/Th.-Pty FI | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
27 | JGTLFM1 | IS-M/SD: Business Partner Purchasing Organization | 2 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
28 | JGTZUAUS | IS-M/SD: Lost Time for Carriers | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
29 | RJGTEXTORD | IS-M/AM: Transfer Business Partner from Technical System | 2 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
30 | A458 | IS-M/SD: Employee Renewal Commission | 5 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
31 | A459 | IS-M/SD: Employee Up-Front Commission | 5 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
32 | A461 | IS-M/SD: Employee Bonus for Sales Promotion | 5 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
33 | A470 | IS-M/SD: Deliverer Settlement - Normal Items | 5 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
34 | A483 | IS-M/SD: Payment Method for Employee Bonus for Up-Front Com. | 5 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
35 | A484 | IS-M/SD: Employee Commission Deposit | 5 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
36 | JDTDRER | IS-M/SD: Publications | 8 | GPNR | IS-M: Business Partner Publisher | nvarchar | 10 | 0 | | |
37 | JDTPVA | IS-M/SD: Editions | 58 | GPNR | IS-M: Business Partner Publisher | nvarchar | 10 | 0 | | |
38 | JFDFS | IS-M/SD: Billing/Settlement Index | 17 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
39 | JFXDEBIDL | IS-M: Backup Transfer Internal Table XDEBI | 4 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
40 | JKCOMM | Sales Order: Commission for Introduction Record | 5 | GPNR | IS-M: Commission Recipient | nvarchar | 10 | 0 | | |
41 | JKGIFT | Sales Order: Promotional Gifts for Introduction Record | 6 | GPNR | Business Partner Sales Agent | nvarchar | 10 | 0 | | |
42 | JKPA | Sales Order: Partner | 8 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
43 | JKWWWTEMP_BP | IS-M/SD: WWW, Temporary Table for BP Data from Internet | 4 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
44 | JKWWWTEMP_COMPL | IS-M/SD: Temporary Table for Complaints in Internet | 6 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
45 | JKWWWTEMP_GIFT | IS-M: Internet Temporary Table: Gift Data | 22 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
46 | JKWWWTEMP_REDIR | IS-M: Temporary Internet Table: Redirection Data | 22 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
47 | JKWWWTEMP_SERV | IS-M: Temporary Table for Changes from Internet | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
48 | JKWWW_PROTOCOL | IS-M: Table for Logging Creation/Changes made with IACs | 8 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
49 | JLCOMMIND | IS-M: Commission Index | 5 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
50 | JLRK | IS-M/SD: Settlement Header Data | 42 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
51 | JRTBEABST | IS-M/SD: Unloading Point | 7 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
52 | JWTWEKO | IS-M/SD: Sales Activity for Business Partner | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
53 | JYTTRGWAER | IS-M: Trigger Entries for Currency Changes | 2 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
54 | TJKW0 | IS-M/SD: WBZ, Computer Center | 9 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
55 | TJL35 | IS-M/SD: Master Data for Contract Arrangement Determination | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
56 | TJL42 | IS-M/SD: Master Data for External Contract Arrangement Det. | 3 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |
TOPSAP Media |
57 | J_1S_AEND | IS-M/SD CH/S: Orders Affected by Change Number | 7 | GPNR | IS-M: Business Partner Key | nvarchar | 10 | 0 | | |