TWIC8000 SAP (Online store: Profile for product presentation) Table details
Dictionary Type: Table
Description: Online store: Profile for product presentation
Description: Online store: Profile for product presentation
Table field list including key, data, relationships and ABAP select examples
TWIC8000 is a standard SAP Table which is used to store Online store: Profile for product presentation data and is available within R/3 SAP systems depending on the version and release level.
The TWIC8000 table consists of various fields, each holding specific information or linking keys about Online store: Profile for product presentation data available in SAP. These include CSTOBJ (Retail IACs: Customizing object), CSTSCM (Product presentation profile), ANMBR (Display material number), ANAME (Display material description).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TWIC8000 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
CSTOBJ | Retail IACs: Customizing object | W_CSTOBJ | CHAR | 4 | TWICOBJ | W_CSTOBJ | |||
CSTSCM | Product presentation profile | W_OS_PPSCM | CHAR | 4 | TWICSCM | W_CSTSCM | |||
ANMBR | Display material number | W_OS_ANMBR | CHAR | 1 | XFELD | ||||
ANAME | Display material description | W_OS_ANAME | CHAR | 1 | XFELD | ||||
ATITL | Display product heading from catalog | W_OS_ATITL | CHAR | 1 | XFELD | ||||
GAPFM | Display From price for generic material | W_OS_GAPFM | CHAR | 1 | XFELD | ||||
GAPTO | Display To price for generic material | W_OS_GAPTP | CHAR | 1 | XFELD | ||||
GATH1 | Threshold value for several selection boxes | W_OS_GATH1 | INT1 | 3 | INT1 | ||||
GATH2 | Threshold value for switching variant selection method | W_OS_GATH2 | INT1 | 3 | INT1 | ||||
PLSIZ | Number of products displayed per page in product list | W_OS_PLSIZ | INT4 | 10 | INT4 | ||||
PSHUB | Upper limit for number of hits in product search | W_OS_PSHUB | INT4 | 10 | INT4 | ||||
PSFMO | Function module for alternative product search | W_OS_PSFMO | CHAR | 30 | TFDIR | FUNCNAME | |||
PSDES | RFC destination for alternative search | W_OS_PSDES | CHAR | 32 | RFCDES | RFCDEST | |||
PSANR | Material number as search criterion | W_OS_PSANR | CHAR | 1 | XFELD | ||||
PSANM | Material description as search criterion | W_OS_PSANM | CHAR | 1 | XFELD | ||||
PSATL | Catalog heading as search criterion | W_OS_PSATL | CHAR | 1 | XFELD | ||||
PSDSC | Long text as search criterion | W_OS_PSDSC | CHAR | 1 | XFELD | ||||
PSPRC | Price as search criterion | W_OS_PSPRC | CHAR | 1 | XFELD | ||||
PSASH | Cross-shop search | W_OS_PSASH | CHAR | 1 | XFELD | ||||
PSAD1 | Supplementary search criterion 1 | W_OS_PSAD1 | CHAR | 1 | XFELD | ||||
PSAD2 | Supplementary search criterion 2 | W_OS_PSAD2 | CHAR | 1 | XFELD | ||||
PSAD3 | Supplementary search criterion 3 | W_OS_PSAD3 | CHAR | 1 | XFELD | ||||
PSAD4 | Supplementary search criterion 4 | W_OS_PSAD4 | CHAR | 1 | XFELD | ||||
PSAD5 | Supplementary search criterion 5 | W_OS_PSAD5 | CHAR | 1 | XFELD | ||||
ADOC1 | Display additional documents on list screens | W_OS_ADOC1 | CHAR | 1 | XFELD | ||||
ADOC2 | Display additional documents on details screens | W_OS_ADOC2 | CHAR | 1 | XFELD | ||||
TREXP | Display product group hierarchy | W_OS_TREXP | CHAR | 1 | W_OS_TREXP | ||||
TRFFM | Name of function module for reading filter criteria | W_OS_TRFFM | CHAR | 30 | Assigned to domain | FUNCNAME | |||
TRFDE | RFC destination for reading filter criteria | W_OS_TRFDE | CHAR | 32 | Assigned to domain | RFCDEST | |||
NOPRC | Indicator without prices | W_OS_NOPRC | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table TWIC8000 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TWIC8000 to SELECT all data from the tableDATA: WA_TWIC8000 TYPE TWIC8000.
SELECT SINGLE *
FROM TWIC8000
INTO CORRESPONDING FIELDS OF WA_TWIC8000
WHERE...
How to access SAP table TWIC8000
Within an ECC or HANA version of SAP you can also view further information about TWIC8000 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects