| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | GUID | Unique, Generated Key | varbinary | 16 | 0 | RAW | | No | | WRF_PPW_GUID | |
| 3 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 4 | COLOR | Characteristic Value that Describes a Color | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_COLOR | Allow NULL? |
| 5 | SIZE1 | Characteristic Value for Size | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_SIZE1 | Allow NULL? |
| 6 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WRF_PPW_VKORG | Allow NULL? |
| 7 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WRF_PPW_VTWEG | Allow NULL? |
| 8 | PLTYP | Price List Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WRF_PPW_PLTYP | Allow NULL? |
| 9 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WRF_PPW_WERKS | Allow NULL? |
| 10 | STGRTP | Type of Plant Grouping | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_STGRTP | Allow NULL? |
| 11 | STRGRP | Plant Grouping | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_STRGRP | Allow NULL? |
| 12 | ANLDATE | | decimal | 15 | 0 | | ((0)) | Yes | | | |
| 13 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WRF_PPW_PERIV | Allow NULL? |
| 14 | POPER | Posting Period According to Markdown Profile | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | WRF_PPW_POPER | Allow NULL? |
| 15 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | WRF_PPW_GJAHR | Allow NULL? |
| 16 | MDPROF | Markdown Profile | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_MDPROF | Allow NULL? |
| 17 | ACTSLSRTIO | Actual Sales Ratio | decimal | 5 | 2 | DEC | ((0)) | Yes | | WRF_PPW_ACTSLSRTIO | |
| 18 | TARGSLSRTIO | Target Sales Ratio | decimal | 5 | 2 | DEC | ((0)) | Yes | | WRF_PPW_TARGSLSRTIO | |
| 19 | MDPRC | Price Reduction as Percentage of Initial Price | decimal | 5 | 2 | DEC | ((0)) | Yes | | WRF_PPW_MDPRC | |
| 20 | STOCK | Current Stock | decimal | 17 | 3 | QUAN | ((0)) | Yes | | WRF_PPW_STOCK | |
| 21 | SELLPER | Validity Period of Material According to Markdown Profile | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | WRF_PPW_SELLPER | Allow NULL? |
| 22 | ERSDA | | nvarchar | 14 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 23 | STOCKUNIT | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | WRF_PPW_STOCKUNIT | Allow NULL? |
| 24 | MAXPER | Validity Period of Markdown Profile | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | WRF_PPW_MAXPER | Allow NULL? |
| 25 | ANEPRL | Flag: Analysis Level = Price Activation Level | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_ANEPRL | Allow NULL? |
| 26 | NOLOC | Number of Considered Plants | int | 10 | 0 | INT4 | ((0)) | Yes | | WRF_PPW_NOLOC | Allow NULL? |
| 27 | RUN_NO | Run Number | varbinary | 16 | 0 | RAW | | Yes | | WRF_PPW_RUN_NO | |
| 28 | WLSTA | Worklist Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_WLSTA | Allow NULL? |
| 29 | ERRSTA | PPW Worklist: Error Status | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | WRF_PPW_ERRSTA | Allow NULL? |
| 30 | PMATN | Pricing Reference Material | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_PMATN | Allow NULL? |
| 31 | ATTYP | Material Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_ATTYP | Allow NULL? |
| 32 | SISTER | Related Markdown Proposals Exist | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_SYSTER | Allow NULL? |
| 33 | USRGRP | Price Planner Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | WRF_PPWD_USRGRP | Allow NULL? |
| 34 | OBJECT | Object (Application Log) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_OBJECT | Allow NULL? |
| 35 | SUBOBJECT | Subobject (Application Log) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_SUBOBJECT | Allow NULL? |
| 36 | EXT_NUMBER | External Number (Application Log) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_EXT_NUMMER | Allow NULL? |
| 37 | ERNAM | Name of Person Who Created Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_ERNAM | Allow NULL? |
| 38 | LAEDA | Time Stamp of Last Change | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | WRF_PPD_LAEDA | Allow NULL? |
| 39 | AENAM | User Who Last Changed the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | WRF_PPW_AENAM | Allow NULL? |
