SAP Table TJWAK
IS-M/SD: Sales Promotion
TJWAK (IS-M/SD: Sales Promotion) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TJWAK to other SAP tables.
TJWAK table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| WERBEAKT | Sales Promotion | WERBEAKT | CHAR | 8 | 0 | |||
| GUELTIGVON | Start of Validity of Sales Promotion | WERBAVONDT | DATS | 8 | 0 | |||
| GUELTIGBIS | End of Validity of Sales Promotion | WERBABISDT | DATS | 8 | 0 | |||
| DRERZ | Publication | DRERZ | JDTDRER | CHAR | 8 | 0 | ||
| CO_AUFNR | Order number of internal CO order for account assignment | J_CO_AUFNR | AUFK | CHAR | 12 | 0 | ||
| GEOEIN | IS-M: Geographical Unit in Sales Promotion | GEOEINWB | JSTGEOEINH | CHAR | 10 | 0 | ||
| ANZWERBPLN | Number of Planned Sales Activities | ANZWERBPLN | DEC | 9 | 0 | |||
| ANZPROBPLN | Number of Planned Trial Items | ANZPROBPLN | DEC | 9 | 0 | |||
| ANZABOPLN | Number of Planned Standard Subscription Items | ANZABOPLN | DEC | 9 | 0 | |||
| ANZWERBIST | Actual Sales Activities | ANZWERBIST | DEC | 9 | 0 | |||
| ANZPROBIST | Actual Number of Trial Items | ANZPROBIST | DEC | 9 | 0 | |||
| ANZABOIST | Actual Number of Standard Subscription Items | ANZABOIST | DEC | 9 | 0 | |||
| ANZETPROBE | Number of Publication Days for Trial or Free Item | ANZETPROBE | DEC | 9 | 0 | |||
| RQUOTE_PLN | IS-M: Return rate | J_RQUOTE | DEC | 7 | 4 | |||
| RQUOTE_IST | IS-M: Return rate | J_RQUOTE | DEC | 7 | 4 | |||
| EQUOTE_PLN | IS-M: Success rate | J_EQUOTE | DEC | 7 | 4 | |||
| EQUOTE_IST | IS-M: Success rate | J_EQUOTE | DEC | 7 | 4 | |||
| WAERS_PLN | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||
| WAERS_IST | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||
| KOSTEN_PLN | IS-M: Costs | JKOSTEN | CURR | 15 | 2 | |||
| KOSTEN_IST | IS-M: Costs | JKOSTEN | CURR | 15 | 2 | |||
| CPO | IS-M: Cost per order | JCPO | CURR | 9 | 2 | |||
| ANZABOISTS | IS-M: Full Subscriptions Terminated from Sales Promotion | ANZABOISTS | DEC | 9 | 0 | |||
| AKTDATUM | IS-M: Date of Last Actual Data Update | JISTDATUM | DATS | 8 | 0 | |||
| ERFUSER | Created By | ERFUSER | CHAR | 12 | 0 | |||
| ERFDATE | Created On | ERFDATE | DATS | 8 | 0 | |||
| ERFTIME | Time Created | ERFTIME | TIMS | 6 | 0 | |||
| AENUSER | Last Changed By | AENUSER | CHAR | 12 | 0 | |||
| AENDATE | Date of Last Change | AENDATE | DATS | 8 | 0 | |||
| AENTIME | Time of Last Change | AENTIME | TIMS | 6 | 0 | |||
| ANZABOISTX | IS-M: Terminated Subscriptions from Sales Promotion | ANZABOISTX | DEC | 9 | 0 | |||
| ANZKSTLPLN | Planned Number of Free Items | ANZKSTLPLN | DEC | 9 | 0 | |||
| ANZKSTLIST | Actual Number of Free Items | ANZKSTLIST | DEC | 9 | 0 | |||
| CAMPAIGN | IS-M: Default for Marketing Campaign | ISM_MARKETING_CAMPAIGN_PROP | RAW | 16 | 0 | |||
TJWAK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TJWAK | CO_AUFNR | TJWAK | MANDT | AUFK | Order master data | MANDT |
| TJWAK | CO_AUFNR | TJWAK | CO_AUFNR | AUFK | Order master data | AUFNR |
| TJWAK | DRERZ | TJWAK | MANDT | JDTDRER | IS-M/SD: Publications | MANDT |
| TJWAK | DRERZ | TJWAK | DRERZ | JDTDRER | IS-M/SD: Publications | DRERZ |
| TJWAK | GEOEIN | TJWAK | MANDT | JSTGEOEINH | IS-M/SD: Geographical Unit | MANDT |
| TJWAK | GEOEIN | TJWAK | GEOEIN | JSTGEOEINH | IS-M/SD: Geographical Unit | GEOEIN |
| TJWAK | MANDT | TJWAK | MANDT | T000 | Clients | MANDT |
| TJWAK | WAERS_IST | TJWAK | MANDT | TCURC | Currency Codes | MANDT |
| TJWAK | WAERS_IST | TJWAK | WAERS_IST | TCURC | Currency Codes | WAERS |
| TJWAK | WAERS_PLN | TJWAK | MANDT | TCURC | Currency Codes | MANDT |
| TJWAK | WAERS_PLN | TJWAK | WAERS_PLN | TCURC | Currency Codes | WAERS |
