| 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 | T000 | MANDT | Allow NULL? |
| 2 | CSTOBJ | Retail IACs: Customizing object | nvarchar | 4 | 0 | CHAR | (N' ') | No | TWICOBJ | W_CSTOBJ | Allow NULL? |
| 3 | CSTSCM | Product presentation profile | nvarchar | 4 | 0 | CHAR | (N' ') | No | TWICSCM | W_OS_PPSCM | Allow NULL? |
| 4 | ANMBR | Display material number | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_ANMBR | Allow NULL? |
| 5 | ANAME | Display material description | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_ANAME | Allow NULL? |
| 6 | ATITL | Display product heading from catalog | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_ATITL | Allow NULL? |
| 7 | GAPFM | Display From price for generic material | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_GAPFM | Allow NULL? |
| 8 | GAPTO | Display To price for generic material | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_GAPTP | Allow NULL? |
| 9 | GATH1 | Threshold value for several selection boxes | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | W_OS_GATH1 | |
| 10 | GATH2 | Threshold value for switching variant selection method | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | W_OS_GATH2 | |
| 11 | PLSIZ | Number of products displayed per page in product list | int | 10 | 0 | INT4 | ((0)) | Yes | | W_OS_PLSIZ | Allow NULL? |
| 12 | PSHUB | Upper limit for number of hits in product search | int | 10 | 0 | INT4 | ((0)) | Yes | | W_OS_PSHUB | Allow NULL? |
| 13 | PSFMO | Function module for alternative product search | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | W_OS_PSFMO | Allow NULL? |
| 14 | PSDES | RFC destination for alternative search | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | RFCDES | W_OS_PSDES | Allow NULL? |
| 15 | PSANR | Material number as search criterion | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PSANR | Allow NULL? |
| 16 | PSANM | Material description as search criterion | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PSANM | Allow NULL? |
| 17 | PSATL | Catalog heading as search criterion | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PSATL | Allow NULL? |
| 18 | PSDSC | Long text as search criterion | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PSDSC | Allow NULL? |
| 19 | PSPRC | Price as search criterion | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PSPRC | Allow NULL? |
| 20 | PSASH | Cross-shop search | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PSASH | Allow NULL? |
| 21 | PSAD1 | Supplementary search criterion 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PSAD1 | Allow NULL? |
| 22 | PSAD2 | Supplementary search criterion 2 | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PSAD2 | Allow NULL? |
| 23 | PSAD3 | Supplementary search criterion 3 | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PSAD3 | Allow NULL? |
| 24 | PSAD4 | Supplementary search criterion 4 | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PSAD4 | Allow NULL? |
| 25 | PSAD5 | Supplementary search criterion 5 | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PSAD5 | Allow NULL? |
| 26 | ADOC1 | Display additional documents on list screens | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_ADOC1 | Allow NULL? |
| 27 | ADOC2 | Display additional documents on details screens | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_ADOC2 | Allow NULL? |
| 28 | TREXP | Display product group hierarchy | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_TREXP | Allow NULL? |
| 29 | TRFFM | Name of function module for reading filter criteria | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | W_OS_TRFFM | Allow NULL? |
| 30 | TRFDE | RFC destination for reading filter criteria | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | W_OS_TRFDE | Allow NULL? |
| 31 | NOPRC | Indicator without prices | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_NOPRC | Allow NULL? |
