SAP Table
TWPCTYPE Product Catalog Type
SAP table TWPCTYPE has 2 primary key fields being MANDT,PCTYP.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TWPCTYPE columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||
| KeyPCTYP | Product catalog type | CHAR | 4 | 0 | W_PC_PCTYP | ||||||||||||||
| ONUSE | Use PO number | CHAR | 1 | 0 | W_PC_ONUSE | ||||||||||||||
| CCOBL | Indicator for catalog ID required entry field | CHAR | 1 | 0 | W_PC_CCOBL | ||||||||||||||
| CCREP | Reaction if catalog code is repeated | CHAR | 1 | 0 | W_PC_CCREP | ||||||||||||||
|
|||||||||||||||||||
| CCNRA | Number range for catalog ID | CHAR | 2 | 0 | W_PC_CCNRA | ||||||||||||||
| PROM | Assignable to Promotion | CHAR | 1 | 0 | W_PC_PROM | ||||||||||||||
| TCOPY | Copy heading from material short text | CHAR | 1 | 0 | W_PC_TCOPY | ||||||||||||||
| LCOPY | Copy long text from material text | CHAR | 1 | 0 | W_PC_LCOPY | ||||||||||||||
|
|||||||||||||||||||
| ONFMT | Order number format | CHAR | 1 | 0 | W_PC_ONFMT | ||||||||||||||
|
|||||||||||||||||||
| ONSEP | Order number separator symbol | CHAR | 1 | 0 | W_PC_ONSEP | ||||||||||||||
| ONCHG | Indicator, PO number changeable | CHAR | 1 | 0 | W_PC_ONCHG | ||||||||||||||
| GAWOV | Indicator, allow generic article without variant | CHAR | 1 | 0 | W_PC_GAWOV | ||||||||||||||