| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | AKTNR | Promotion | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | PROM_NAME | Promotion description | nvarchar | 40 | 0 | | | | Allow NULL? |
| 4 | PROMOTION_TYPE | Promotion Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | THEME | Promotion theme | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | ON_SALE_FROM | On Sale to Consumers From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ON_SALE_TO | On Sale To Consumers To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | SALES_CURRENCY | Currency current promotion - planning | nvarchar | 5 | 0 | | | | Allow NULL? |
| 9 | SALES_ORG | Sales Organization: Promotion Header | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | DISTR_CHAN | Distribution Channel: Promotion Header | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | PLSCH | Planning Step | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | PLINT | Planning Step Interface | nvarchar | 20 | 0 | | | | Allow NULL? |
| 14 | FORM | Planning Layout | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | VARNR | Variant Number in Manual Planning Layout | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | FILGRP | Plant grouping, sales promotion | nvarchar | 18 | 0 | | | | Allow NULL? |
| 17 | PRKLART | Class Type for Site Groups in a Promotions Interface | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | CREUSR | Promotion Created in MAP By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | CREDAT | Creation Data of MAP Promotion | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | CREUZT | Promotion Created in MAP at | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | STATUS | Status of Object Created in MAP | char | 1 | 0 | | | | Allow NULL? |