| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000183000 | PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item | 34 | AKTNR | | nvarchar | 10 | 0 | | |
2 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 25 | AKTNR | | nvarchar | 10 | 0 | | |
3 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 24 | AKTNR | | nvarchar | 10 | 0 | | |
4 | /BIC/B0000187000 | PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item) | 28 | AKTNR | | nvarchar | 10 | 0 | | |
5 | /BIC/B0000189000 | PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line | 28 | AKTNR | | nvarchar | 10 | 0 | | |
6 | CNVTDMS_05_WAKHI | Collector Table for Entries in Table WAKHIND | 4 | AKTNR | Action for CNVTDMS_05_* | nvarchar | 10 | 0 | | |
7 | DMF_D_PROMO | Transferred promotions | 3 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
8 | REFXCN_PROMCAT | Promotional Data | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
9 | ZEIM_LIPS | SD document: Delivery: Item data | 152 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPAgency Business Global Trade |
10 | WBRP | Agency business: Item | 59 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPAllocation |
11 | AUBSI | Worklist for PO (Follow-on Document Generation) | 33 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
12 | AUKAI | Worklist for Sales Orders (FBG) | 25 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
13 | AUPO | Allocation Table Document Item | 18 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
14 | AUUMI | Worklist for Stock Transport Orders (Follow-on Doc. Gen.) | 32 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
15 | AUVDI | Worklist for Deliveries (Follow-on Doc. Generation) | 46 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPBilling |
16 | VBRP | Billing Document: Item Data | 131 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPCollectionsDisbursements |
17 | TKKVMAKT | Dunning Activities | 4 | AKTNR | Activity Number of a Dunning Level | nvarchar | 3 | 0 | | |
18 | VVKKMAKT | Executed Dunning Activities | 7 | AKTNR | Activity Number of a Dunning Level | nvarchar | 3 | 0 | | |
TOPConditions |
19 | KONA | Agreements | 40 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
20 | KONH | Conditions (Header) | 18 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
21 | KONP | Conditions (Item) | 52 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPConsumption-Based Planning See Also PP-MRP |
22 | WSAF_PROMO_DELTA | Change Information for Promotions | 3 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
23 | FRE_DB_ABI_HEAD | Header table for DIF occurrence | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
24 | FRE_DB_ABI_POS | Item table for DIF occurrence | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPData Collection |
25 | S086 | Promotion | 8 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
26 | S086E | S086 - Structural Information | 3 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
27 | S117 | Receipt/article | 29 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
28 | S120 | Sales as per receipts | 31 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
29 | S120BIW1 | S120BIW1 * Sales as Per Receipts | 31 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
30 | S120BIW2 | S120BIW2 * Sales as Per Receipts | 31 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
31 | S121 | Material aggregation - POS | 11 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
32 | S121E | S121 - Structural Information | 6 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
33 | S270 | Do not use! | 43 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
34 | S270BIW1 | Do not use! | 43 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
35 | S270BIW2 | Do not use! | 43 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
36 | S271 | Do not use! | 24 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
37 | S271BIW1 | Do not use! | 24 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
38 | S271BIW2 | Do not use! | 24 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
39 | S272 | Do not use! | 42 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
40 | S272BIW1 | Do not use! | 42 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
41 | S272BIW2 | Do not use! | 42 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
42 | S273 | Do not use! | 25 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
43 | S273BIW1 | Do not use! | 25 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
44 | S273BIW2 | Do not use! | 25 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
45 | S275 | Transfer BW: Einkaufsdaten | 33 | AKTNR | Actie | nvarchar | 10 | 0 | | |
46 | S275BIW1 | S275BIW1 * Transfer to BW: Purchasing Data | 33 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
47 | S275BIW2 | S275BIW2 * Transfer to BW: Purchasing Data | 33 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
48 | S276 | Transfer BW: Vertriebsdaten | 29 | AKTNR | Actie | nvarchar | 10 | 0 | | |
49 | S276BIW1 | S276BIW1 * Transfer to BW: Sales and Distribution Data | 29 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
50 | S276BIW2 | S276BIW2 * BW Transfer: Sales and Distribution Data | 29 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
51 | S277 | Transfer BW: VP-Umbewertung | 25 | AKTNR | Actie | nvarchar | 10 | 0 | | |
52 | S277BIW1 | S277BIW1 * Transfer to BW: Revaluation at Retail | 25 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
53 | S277BIW2 | S277BIW2 * Transfer to BW: Revaluation at Retail | 25 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
54 | S279 | Transfer BW: Bestandsführung | 24 | AKTNR | Actie | nvarchar | 10 | 0 | | |
55 | S279BIW1 | S279BIW1 * BW Transfer: Inventory Management | 24 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
56 | S279BIW2 | S279BIW2 * BW Transfer: Inventory Management | 24 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
57 | S953 | BW Vorl.für BON/Artikel S117 | 29 | AKTNR | Aktion | nvarchar | 10 | 0 | | |
TOPDefense Forces and Public Security |
58 | /ISDFPS/ZEBAN | Copy of EBAN | 81 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPFree Goods |
59 | KONBBYH | Bonus Buys: Header | 14 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPInventory Management |
60 | MSEG | Document Segment: Material | 139 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
61 | MWXMSEG | ZMSEG: Interface for Posting of Value | 139 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
62 | MWZMSEG | ZMSEG:Interface for Posting of Value | 139 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
63 | USEG | Retail Revaluation Document: Revaluation Segment | 21 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPInvoice Verification |
64 | RBDRSEG | Batch IV: Invoice Document Items | 82 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPMaterials Management |
65 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 86 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPMerchandise and Assortment Planning |
66 | TWISPS_NOPROMO1 | Parameters for Promotions Created in MAP | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPPerishables Procurement |
67 | FIP_D_PROMO | Promotion data | 3 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
68 | FIP_D_PROMO_T | Promotion data Texts | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPPOS Interface |
69 | WVFB | DRS Interface, Intermediate Buffer, Order Item FM | 31 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPPrice Planning Workbench |
70 | WRF_PPW_PPDHEAD | PPD Header | 7 | AKTNR | Promotion Number | nvarchar | 10 | 0 | | |
TOPProduct Catalog |
71 | WWMI | Product catalog | 4 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPPromotion |
72 | WAAL | Material-to-vendor assignment in price maintenance (promo.) | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
73 | WAEL | Delivery Phases in Retail Promotion | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
74 | WAGU | Validity of plant groups - IS-R | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
75 | WAKC | Assignment of Coupons to Promotion | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
76 | WAKH | Promotion Header Data, IS-R | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
77 | WAKHIND | Promotion header data IS-R: index table for conditions | 3 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
78 | WAKP | Promotion Item Data | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
79 | WAKR | Promotion Discounts | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
80 | WAKRW | Promotion discounts by plant | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
81 | WAKT | Promotion description short text, IS-R | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
82 | WALE | Material to store assignment to promotion | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
83 | WARNG | Saving of RANGES | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
84 | WAZB | Module plant-group assignment | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
85 | WAZT | Promotion/themes assignment | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
86 | WAZW | Promotion/advertising media assignment | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
87 | WMATSITEQTYTIME | Material Quantities in Sites for Promotion Periods | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
88 | WMFP | Markdown Planning - item data (materials) | 12 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
89 | WRF_DISPRO_DF_Q | Worklist for Assignm of TD Promo Data after Changes to Promo | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
90 | WRF_DISPRO_QUEUE | Worklist After Changes to Promotions | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
91 | WRF_DISPRO_TD | Time-Dependent Data for Promotions | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
92 | WRF_RPR_WAPG | Assignment of Plant Grouping to Local Plant Group No. | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
93 | WRF_RPR_WAPGT | Plant Group Descr. Short Text | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
94 | WRF_RPR_WAPL | Assignment of Plants to Local Plant Groups | 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPPurchasing |
95 | EBAN | Purchase Requisition | 81 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
96 | EKPO | Purchasing Document Item | 133 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
97 | MEREQX | Purchase Requisition Change Parameter | 81 | AKTNR | Updated information in related user data field | nvarchar | 1 | 0 | | |
98 | WDFR1 | Requirements Planning for Perishables | 46 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
99 | WRF_POHF_POL | Order list | 29 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
100 | /BEV1/RBKP | Copy Table for KONP for Accrual (Field KBRUE) | 52 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPRetail Enterprise Services |
101 | WESD_BBY_SENT | Bonus Buy: Stores Supplied via Service | 6 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
102 | WESD_PROMO_SENT | Retail Promotion: Stores Supplied via Service | 4 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPShipping |
103 | LIPS | SD document: Delivery: Item data | 152 | AKTNR | Promotion | nvarchar | 10 | 0 | | |
TOPSimulation |
104 | VSEBAN_CN | Version: Purchase requisition | 81 | AKTNR | Promotion | nvarchar | 10 | 0 | | |