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 | Possible values |
|---|---|---|---|---|---|---|
|
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 |